CREATE TABLE `emp_adv_salary_pay` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `empId` varchar(45) NOT NULL,
  `month` varchar(45) DEFAULT NULL,
  `year` varchar(45) DEFAULT NULL,
  `amount` varchar(45) DEFAULT NULL,
  `branch_id` varchar(45) DEFAULT NULL,
  `payDate` date DEFAULT NULL,
  `payMode` varchar(45) DEFAULT NULL,
  `bank_name` text,
  `bank_branch` text,
  `description` text,
  `chq_no` varchar(45) DEFAULT NULL,
  `chq_date` date DEFAULT NULL,
  `adv_salary_status` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;