CREATE TABLE pf_esic_detail (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `employee_pf_rate` varchar(45) DEFAULT NULL,
  `employer_pf_rate` varchar(45) DEFAULT NULL,
  `employee_esic_rate` varchar(45) DEFAULT NULL,
  `employer_esic_rate` varchar(45) DEFAULT NULL,
  `esic_limit` varchar(45) DEFAULT NULL,
  `pf_wage_limit` varchar(45) DEFAULT NULL, 
  `is_pf_applicable` tinyint(4) DEFAULT NULL,
  `is_pf_limit_apply` tinyint(4) DEFAULT NULL,
  `branch_id` varchar(45) DEFAULT NULL,
  `status` varchar(45) DEFAULT NULL,
  `basic_per` varchar(45) NOT NULL,
  `hra_per` varchar(45) NOT NULL,
  `special_per` varchar(45) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;