--
-- Host: localhost    Database: l9tslhne_hrmgmt
-- ------------------------------------------------------


--
-- Current Database: `l9tslhne_hrmgmt`
--


--
-- Table structure for table `attendence`
--

CREATE TABLE `attendence` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `e_id` int(11) NOT NULL,
  `firsthalf` float(4,2) NOT NULL DEFAULT '0.00',
  `secondhalf` float(4,2) NOT NULL DEFAULT '0.00',
  `t_leave` varchar(255) NOT NULL,
  `application` varchar(255) NOT NULL,
  `date` date NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=511 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `attendence`
--

INSERT INTO `attendence` (`id`, `e_id`, `firsthalf`, `secondhalf`, `t_leave`, `application`, `date`, `time`) VALUES (420,11,0.00,0.00,'','','2015-01-30','2015-01-30 12:14:32'),(421,11,0.00,0.00,'','','2014-11-01','2015-01-30 12:15:13'),(422,11,0.00,0.00,'','','2014-11-02','2015-01-30 12:15:13'),(423,11,0.00,0.00,'','','2014-11-03','2015-01-30 12:15:13'),(424,11,0.00,0.00,'','','2014-11-04','2015-01-30 12:15:13'),(425,11,0.00,0.00,'','','2014-11-05','2015-01-30 12:15:13'),(426,11,0.00,0.00,'','','2014-11-06','2015-01-30 12:15:13'),(427,11,0.00,0.00,'','','2014-11-07','2015-01-30 12:15:13'),(428,11,0.00,0.00,'','','2014-11-08','2015-01-30 12:15:13'),(429,11,0.00,0.00,'','','2014-11-09','2015-01-30 12:15:13'),(430,11,0.00,0.00,'','','2014-11-10','2015-01-30 12:15:13'),(431,11,0.00,0.00,'','','2014-11-11','2015-01-30 12:15:13'),(432,11,0.00,0.00,'','','2014-11-12','2015-01-30 12:15:13'),(433,11,0.00,0.00,'','','2014-11-13','2015-01-30 12:15:13'),(434,11,0.00,0.00,'','','2014-11-14','2015-01-30 12:15:13'),(435,11,0.00,0.00,'','','2014-11-15','2015-01-30 12:15:13'),(436,11,0.00,0.00,'','','2014-11-16','2015-01-30 12:15:13'),(437,11,0.00,0.00,'','','2014-11-17','2015-01-30 12:15:13'),(438,11,0.00,0.00,'','','2014-11-18','2015-01-30 12:15:13'),(439,11,0.00,0.00,'','','2014-11-19','2015-01-30 12:15:13'),(440,11,0.00,0.00,'','','2014-11-20','2015-01-30 12:15:13'),(441,11,0.00,0.00,'','','2014-11-21','2015-01-30 12:15:13'),(442,11,0.00,0.00,'','','2014-11-22','2015-01-30 12:15:13'),(443,11,0.00,0.00,'','','2014-11-23','2015-01-30 12:15:13'),(444,11,0.00,0.00,'','','2014-11-24','2015-01-30 12:15:13'),(445,11,0.00,0.00,'','','2014-11-25','2015-01-30 12:15:13'),(446,11,0.00,0.00,'','','2014-11-26','2015-01-30 12:15:13'),(447,11,0.00,0.00,'','','2014-11-27','2015-01-30 12:15:13'),(448,11,0.00,0.00,'','','2014-11-28','2015-01-30 12:15:13'),(449,11,0.00,0.00,'','','2014-11-29','2015-01-30 12:15:13'),(450,11,0.00,0.00,'','','2014-11-30','2015-01-30 12:15:13'),(451,11,0.00,0.00,'','','2014-12-01','2015-01-30 12:15:13'),(452,11,0.00,0.00,'','','2014-12-02','2015-01-30 12:15:13'),(453,11,0.00,0.00,'','','2014-12-03','2015-01-30 12:15:13'),(454,11,0.00,0.00,'','','2014-12-04','2015-01-30 12:15:13'),(455,11,0.00,0.00,'','','2014-12-05','2015-01-30 12:15:13'),(456,11,0.00,0.00,'','','2014-12-06','2015-01-30 12:15:13'),(457,11,0.00,0.00,'','','2014-12-07','2015-01-30 12:15:13'),(458,11,0.00,0.00,'','','2014-12-08','2015-01-30 12:15:13'),(459,11,0.00,0.00,'','','2014-12-09','2015-01-30 12:15:13'),(460,11,0.00,0.00,'','','2014-12-10','2015-01-30 12:15:13'),(461,11,0.00,0.00,'','','2014-12-11','2015-01-30 12:15:13'),(462,11,0.00,0.00,'','','2014-12-12','2015-01-30 12:15:13'),(463,11,0.00,0.00,'','','2014-12-13','2015-01-30 12:15:13'),(464,11,0.00,0.00,'','','2014-12-14','2015-01-30 12:15:13'),(465,11,0.00,0.00,'','','2014-12-15','2015-01-30 12:15:13'),(466,11,0.00,0.00,'','','2014-12-16','2015-01-30 12:15:13'),(467,11,0.00,0.00,'','','2014-12-17','2015-01-30 12:15:13'),(468,11,0.00,0.00,'','','2014-12-18','2015-01-30 12:15:13'),(469,11,0.00,0.00,'','','2014-12-19','2015-01-30 12:15:13'),(470,11,0.00,0.00,'','','2014-12-20','2015-01-30 12:15:13'),(471,11,0.00,0.00,'','','2014-12-21','2015-01-30 12:15:13'),(472,11,0.00,0.00,'','','2014-12-22','2015-01-30 12:15:13'),(473,11,0.00,0.00,'','','2014-12-23','2015-01-30 12:15:13'),(474,11,0.00,0.00,'','','2014-12-24','2015-01-30 12:15:13'),(475,11,0.00,0.00,'','','2014-12-25','2015-01-30 12:15:13'),(476,11,0.00,0.00,'','','2014-12-26','2015-01-30 12:15:13'),(477,11,0.00,0.00,'','','2014-12-27','2015-01-30 12:15:13'),(478,11,0.00,0.00,'','','2014-12-28','2015-01-30 12:15:13'),(479,11,0.00,0.00,'','','2014-12-29','2015-01-30 12:15:13'),(480,11,0.00,0.00,'','','2014-12-30','2015-01-30 12:15:13'),(481,11,0.00,0.00,'','','2014-12-31','2015-01-30 12:15:13'),(482,11,0.00,0.00,'','','2015-01-01','2015-01-30 12:15:13'),(483,11,0.00,0.00,'','','2015-01-02','2015-01-30 12:15:13'),(484,11,0.00,0.00,'','','2015-01-03','2015-01-30 12:15:13'),(485,11,0.00,0.00,'','','2015-01-04','2015-01-30 12:15:13'),(486,11,0.00,0.00,'','','2015-01-05','2015-01-30 12:15:13'),(487,11,0.00,0.00,'','','2015-01-06','2015-01-30 12:15:13'),(488,11,0.00,0.00,'','','2015-01-07','2015-01-30 12:15:13'),(489,11,0.00,0.00,'','','2015-01-08','2015-01-30 12:15:13'),(490,11,0.00,0.00,'','','2015-01-09','2015-01-30 12:15:13'),(491,11,0.00,0.00,'','','2015-01-10','2015-01-30 12:15:13'),(492,11,0.00,0.00,'','','2015-01-11','2015-01-30 12:15:13'),(493,11,0.00,0.00,'','','2015-01-12','2015-01-30 12:15:13'),(494,11,0.00,0.00,'','','2015-01-13','2015-01-30 12:15:13'),(495,11,0.00,0.00,'','','2015-01-14','2015-01-30 12:15:13'),(496,11,0.00,0.00,'','','2015-01-15','2015-01-30 12:15:13'),(497,11,0.00,0.00,'','','2015-01-16','2015-01-30 12:15:13'),(498,11,0.00,0.00,'','','2015-01-17','2015-01-30 12:15:13'),(499,11,0.00,0.00,'','','2015-01-18','2015-01-30 12:15:13'),(500,11,0.00,0.00,'','','2015-01-19','2015-01-30 12:15:13'),(501,11,0.00,0.00,'','','2015-01-20','2015-01-30 12:15:13'),(502,11,0.00,0.00,'','','2015-01-21','2015-01-30 12:15:13'),(503,11,0.00,0.00,'','','2015-01-22','2015-01-30 12:15:13'),(504,11,0.00,0.00,'','','2015-01-23','2015-01-30 12:15:13'),(505,11,0.00,0.00,'','','2015-01-24','2015-01-30 12:15:13'),(506,11,0.00,0.00,'','','2015-01-25','2015-01-30 12:15:13'),(507,11,0.00,0.00,'','','2015-01-26','2015-01-30 12:15:13'),(508,11,0.00,0.00,'','','2015-01-27','2015-01-30 12:15:13'),(509,11,0.00,0.00,'','','2015-01-28','2015-01-30 12:15:13'),(510,11,0.00,0.00,'','','2015-01-29','2015-01-30 12:15:13');

--
-- Table structure for table `calculator`
--

CREATE TABLE `calculator` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `incometaxnull` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `calculator`
--


--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `full_name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `c_name` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `telephone` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `skype` varchar(255) NOT NULL,
  `gtalk` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  `notes` varchar(255) NOT NULL,
  `sec_status` varchar(255) NOT NULL,
  `created_date` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `clients`
--


--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` longtext NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `departments`
--

INSERT INTO `departments` (`id`, `name`, `description`, `time`) VALUES (1,'IT','This is the information technology','2015-01-10 09:50:48'),(3,'Finance','Account manager\r\n','2015-01-10 09:50:39');

--
-- Table structure for table `earlier_award`
--

CREATE TABLE `earlier_award` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `award_name` varchar(255) NOT NULL,
  `gift_item` varchar(255) NOT NULL,
  `e_id` int(11) NOT NULL,
  `month` varchar(255) NOT NULL,
  `year` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `earlier_award`
--


--
-- Table structure for table `first_salaryslip`
--

CREATE TABLE `first_salaryslip` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `earning` varchar(255) DEFAULT NULL,
  `medical_allowance` varchar(255) DEFAULT NULL,
  `AddField_632` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `first_salaryslip`
--

INSERT INTO `first_salaryslip` (`id`, `earning`, `medical_allowance`, `AddField_632`) VALUES (1,NULL,'1000','');

--
-- Table structure for table `footer_salaryslip`
--

CREATE TABLE `footer_salaryslip` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `annual_gross_income` varchar(255) DEFAULT NULL,
  `income_tax` varchar(255) DEFAULT NULL,
  `Net_Salary_Rs` varchar(255) DEFAULT NULL,
  `Prepared_By` varchar(255) DEFAULT NULL,
  `Authorised_Sign` varchar(255) DEFAULT NULL,
  `Employee_sign` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `footer_salaryslip`
--


--
-- Table structure for table `incometax_slab`
--

CREATE TABLE `incometax_slab` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `CI` varchar(255) NOT NULL,
  `Rate` varchar(255) NOT NULL,
  `GTP` varchar(255) NOT NULL,
  `first` varchar(255) DEFAULT '',
  `next` varchar(255) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `incometax_slab`
--

INSERT INTO `incometax_slab` (`id`, `CI`, `Rate`, `GTP`, `first`, `next`, `time`) VALUES (1,'20000','1','0','1','','2014-11-19 11:50:54'),(2,'10000','2.5','200','','2','2014-11-12 17:37:55'),(3,'30000','','200','1','','2014-09-19 13:08:31'),(4,'10000','3.5','350','','2','2014-09-19 13:08:31'),(5,'40000','','550','1','','2014-09-19 13:08:31'),(6,'10000','7.0','2800','','2','2014-09-19 13:08:31'),(7,'80000','','3350','1','','2014-09-19 13:08:31'),(8,'40000','11.5','4600','','2','2014-09-19 13:08:31'),(9,'120000','','7950','1','','2014-09-19 13:08:31'),(10,'40000','15','6000','','2','2014-09-19 13:08:31'),(11,'160000','','13950','1','','2014-09-19 13:08:31'),(12,'40000','17','6800','','2','2014-09-19 13:08:31'),(13,'200000','1','20750','1','','2014-11-19 11:50:54'),(14,'120000','18','21600','','2','2014-09-19 13:08:31'),(15,'320000','','42350','1','','2014-09-19 13:08:31'),(16,'320000','20','','','','2014-09-19 13:08:31');

--
-- Table structure for table `inventory`
--

CREATE TABLE `inventory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `item_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `purchase_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `item_amount` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `installment` tinyint(4) NOT NULL COMMENT '1 for Yes 2 for No',
  `payment_amount` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `payment_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `inventory`
--

INSERT INTO `inventory` (`id`, `item_name`, `item_code`, `purchase_date`, `location`, `item_amount`, `installment`, `payment_amount`, `payment_date`, `created_date`, `timestamp`) VALUES (1,'Mobile','mob','10-01-2015','Sikandra','20000',2,'20000','10-01-2015','1420889905','2015-01-10 11:38:25'),(3,'Car','SKU3456','10-01-2015','Sanjay Place','230000',1,'a:1:{i:0;s:5:\"20000\";}','a:1:{i:0;s:10:\"13-01-2015\";}','1420891290','2015-01-10 12:01:30'),(4,'Stationary','526','22-01-2015','Sikandra','50',2,'50','22-01-2015','1422525566','2015-01-29 09:59:26'),(5,'Stationary2','527','14-01-2015','Sadar','50',1,'a:1:{i:0;s:2:\"50\";}','a:1:{i:0;s:10:\"22-01-2015\";}','1422525593','2015-01-29 09:59:53'),(6,'Stationary3','528','25-12-2014','Sikandra','50',2,'50','25-12-2014','1422525611','2015-01-29 10:00:11');

--
-- Table structure for table `loan_module`
--

CREATE TABLE `loan_module` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `e_id` int(11) NOT NULL,
  `e_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `advance_amount` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `day` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `month` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `year` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `loan_module`
--


--
-- Table structure for table `location`
--

CREATE TABLE `location` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `location`
--

INSERT INTO `location` (`id`, `name`) VALUES (1,'Sanjay Place'),(3,'Sikandra'),(4,'Sadar');

--
-- Table structure for table `main_salaryslip`
--

CREATE TABLE `main_salaryslip` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name_vala` varchar(255) DEFAULT NULL,
  `pf_code` varchar(255) DEFAULT NULL,
  `department` varchar(255) DEFAULT NULL,
  `empcode` varchar(255) DEFAULT NULL,
  `paidday` varchar(255) DEFAULT NULL,
  `presentday` varchar(255) DEFAULT NULL,
  `W_Off` varchar(255) DEFAULT NULL,
  `Leave` varchar(255) DEFAULT NULL,
  `Absents` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `main_salaryslip`
--


--
-- Table structure for table `office`
--

CREATE TABLE `office` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `w_day` varchar(255) NOT NULL,
  `whr_am` varchar(255) NOT NULL,
  `whr_pm` varchar(255) NOT NULL,
  `first_am` varchar(255) NOT NULL,
  `first_pm` varchar(255) NOT NULL,
  `second_am` varchar(255) NOT NULL,
  `second_pm` varchar(255) NOT NULL,
  `c_leave` varchar(255) NOT NULL,
  `s_leave` varchar(255) NOT NULL,
  `e_leave` varchar(255) NOT NULL,
  `m_leave` varchar(255) NOT NULL,
  `o_leave` varchar(255) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `office`
--

INSERT INTO `office` (`id`, `w_day`, `whr_am`, `whr_pm`, `first_am`, `first_pm`, `second_am`, `second_pm`, `c_leave`, `s_leave`, `e_leave`, `m_leave`, `o_leave`, `time`) VALUES (1,'a:5:{s:6:\"monday\";s:1:\"1\";s:7:\"tuesday\";s:1:\"2\";s:9:\"wednesday\";s:1:\"3\";s:8:\"thursday\";s:1:\"4\";s:6:\"friday\";s:1:\"5\";}','08:00:00','17:00:00','08:00:00','12:15:00','13:00:00','17:00:00','14','7','1','3','','2014-11-11 06:51:49');

--
-- Table structure for table `payment`
--

CREATE TABLE `payment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amount` int(255) NOT NULL,
  `description` longtext NOT NULL,
  `date` varchar(255) NOT NULL,
  `payment` varchar(255) NOT NULL,
  `files` varchar(255) NOT NULL,
  `user_id` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment`
--

INSERT INTO `payment` (`id`, `amount`, `description`, `date`, `payment`, `files`, `user_id`, `time`) VALUES (1,543,'tryhrt','27-09-2014','expense','134___image-1.jpg,152___image-2.jpg,105___image-3.jpg,',1,'2014-09-27 07:32:17'),(2,56,'eryhjk','11-09-2014','expense','128___image-4.jpg,38___,22___,',1,'2014-09-27 07:38:30');

--
-- Table structure for table `payslip`
--

CREATE TABLE `payslip` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `empname` varchar(255) NOT NULL,
  `department` varchar(255) NOT NULL,
  `empcode` varchar(255) NOT NULL,
  `employment_income` varchar(255) NOT NULL,
  `employment_expences` varchar(255) NOT NULL,
  `net_employment_income` varchar(255) NOT NULL,
  `trade_income` varchar(255) NOT NULL,
  `paidday` varchar(255) NOT NULL,
  `presentday` varchar(255) NOT NULL,
  `weekoff` varchar(255) NOT NULL,
  `total_leaves` varchar(255) NOT NULL,
  `extrawork` varchar(255) NOT NULL,
  `dividends` varchar(255) NOT NULL,
  `earned_income_relief` varchar(255) NOT NULL,
  `interest` varchar(255) NOT NULL,
  `spouse_relief` varchar(255) NOT NULL,
  `property_rent` varchar(255) NOT NULL,
  `qualifying_relief` varchar(255) NOT NULL,
  `royality_income` varchar(255) NOT NULL,
  `mother_relief` varchar(255) NOT NULL,
  `gain_income_nature` varchar(255) NOT NULL,
  `parent_relief` varchar(255) NOT NULL,
  `total_income` varchar(255) NOT NULL,
  `grandparent_relief` varchar(255) NOT NULL,
  `approved_donations` varchar(255) NOT NULL,
  `brosis_relief` varchar(255) NOT NULL,
  `cpf_relief` varchar(255) NOT NULL,
  `life_insurance_relief` varchar(255) NOT NULL,
  `coursefee_relief` varchar(255) NOT NULL,
  `leavy_relief` varchar(255) NOT NULL,
  `cpf` varchar(255) NOT NULL,
  `srs` varchar(255) NOT NULL,
  `nsman` varchar(255) NOT NULL,
  `assessableincome` varchar(255) NOT NULL,
  `chargeableincome` varchar(255) NOT NULL,
  `chargeableincometax` varchar(255) NOT NULL,
  `parenthood_tax` varchar(255) NOT NULL,
  `nettax_payable` varchar(255) NOT NULL,
  `prepared_by` varchar(255) NOT NULL,
  `authorised_sign` varchar(255) NOT NULL,
  `employee_sign` varchar(255) NOT NULL,
  `payslipdate` varchar(255) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payslip`
--

INSERT INTO `payslip` (`id`, `empname`, `department`, `empcode`, `employment_income`, `employment_expences`, `net_employment_income`, `trade_income`, `paidday`, `presentday`, `weekoff`, `total_leaves`, `extrawork`, `dividends`, `earned_income_relief`, `interest`, `spouse_relief`, `property_rent`, `qualifying_relief`, `royality_income`, `mother_relief`, `gain_income_nature`, `parent_relief`, `total_income`, `grandparent_relief`, `approved_donations`, `brosis_relief`, `cpf_relief`, `life_insurance_relief`, `coursefee_relief`, `leavy_relief`, `cpf`, `srs`, `nsman`, `assessableincome`, `chargeableincome`, `chargeableincometax`, `parenthood_tax`, `nettax_payable`, `prepared_by`, `authorised_sign`, `employee_sign`, `payslipdate`, `time`) VALUES (2,'11','IT','test employee','2300','20','2320','','	31','31','8','0','8','','','','','','','','','','','','','','','16%','','','','20%','2100','','2320','10200','0','','5650   ','','','','December-2014','2015-01-30 12:15:46');

--
-- Table structure for table `salaryslipdata`
--

CREATE TABLE `salaryslipdata` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `metavalue` longtext NOT NULL,
  `emp_id` int(11) NOT NULL,
  `month` varchar(255) NOT NULL,
  `year` varchar(255) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `salaryslipdata`
--


--
-- Table structure for table `second_salaryslip`
--

CREATE TABLE `second_salaryslip` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `deduction` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `second_salaryslip`
--

INSERT INTO `second_salaryslip` (`id`, `deduction`) VALUES (1,'');

--
-- Table structure for table `setting`
--

CREATE TABLE `setting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `c_name` varchar(255) NOT NULL,
  `c_email` varchar(255) NOT NULL,
  `website` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `zip` varchar(255) NOT NULL,
  `telephone` varchar(255) NOT NULL,
  `telephone2` varchar(255) NOT NULL,
  `fax` varchar(255) NOT NULL,
  `c_logo` longtext NOT NULL,
  `e_tax` varchar(255) DEFAULT NULL,
  `taxvalue` varchar(255) NOT NULL,
  `registration` varchar(255) NOT NULL,
  `taxnumber` varchar(255) NOT NULL,
  `currency` varchar(255) NOT NULL,
  `fiscal` varchar(255) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`id`, `c_name`, `c_email`, `website`, `address`, `city`, `state`, `zip`, `telephone`, `telephone2`, `fax`, `c_logo`, `e_tax`, `taxvalue`, `registration`, `taxnumber`, `currency`, `fiscal`, `time`) VALUES (1,'HR Manager','info@phpscriptsonline.com','phpscriptsonline.com','22210 Victory Blvd','Woodland Hills','Uttar Pradesh','299299','','9733499537','212121','180___phpscriptsonline-logo-new.png','no','3','SDAD2342423','GHAJ67777','$','05-09','2018-10-26 18:04:03');

--
-- Table structure for table `singaporetable`
--

CREATE TABLE `singaporetable` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `employment_income` varchar(255) DEFAULT NULL,
  `employment_expences` varchar(255) DEFAULT NULL,
  `net_employment_income` varchar(255) DEFAULT NULL,
  `trade_income` varchar(255) DEFAULT NULL,
  `dividends` varchar(255) DEFAULT NULL,
  `interest` varchar(255) DEFAULT NULL,
  `property_rent` varchar(255) DEFAULT NULL,
  `royality_income` varchar(255) DEFAULT NULL,
  `gain_income_nature` varchar(255) DEFAULT NULL,
  `total_income` varchar(255) DEFAULT NULL,
  `approved_donations` varchar(255) DEFAULT NULL,
  `assessable_income` varchar(255) DEFAULT NULL,
  `earned_income_relief` varchar(255) DEFAULT NULL,
  `spouse_relief` varchar(255) DEFAULT NULL,
  `qualifying_relief` varchar(255) DEFAULT NULL,
  `mother_relief` varchar(255) DEFAULT NULL,
  `parent_relief` varchar(255) DEFAULT NULL,
  `grandparent_relief` varchar(255) DEFAULT NULL,
  `brosis_relief` varchar(255) DEFAULT NULL,
  `cpf_relief` varchar(255) DEFAULT NULL,
  `life_insurance_relief` varchar(255) DEFAULT NULL,
  `coursefee_relief` varchar(255) DEFAULT NULL,
  `leavy_relief` varchar(255) DEFAULT NULL,
  `cpf` varchar(255) DEFAULT NULL,
  `srs` varchar(255) DEFAULT NULL,
  `nsman` varchar(255) DEFAULT NULL,
  `chargeable_income` varchar(255) DEFAULT NULL,
  `chargeable_tax` varchar(255) DEFAULT NULL,
  `parenthood_tax` varchar(255) DEFAULT NULL,
  `nettax_payable` varchar(255) DEFAULT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `singaporetable`
--

INSERT INTO `singaporetable` (`id`, `employment_income`, `employment_expences`, `net_employment_income`, `trade_income`, `dividends`, `interest`, `property_rent`, `royality_income`, `gain_income_nature`, `total_income`, `approved_donations`, `assessable_income`, `earned_income_relief`, `spouse_relief`, `qualifying_relief`, `mother_relief`, `parent_relief`, `grandparent_relief`, `brosis_relief`, `cpf_relief`, `life_insurance_relief`, `coursefee_relief`, `leavy_relief`, `cpf`, `srs`, `nsman`, `chargeable_income`, `chargeable_tax`, `parenthood_tax`, `nettax_payable`, `time`) VALUES (1,'2300','20','2320',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2320','','','','','','','','16%','','','','20%','2100','','10200','0','','5650   ','2015-01-09 03:52:37');

--
-- Table structure for table `status`
--

CREATE TABLE `status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `class` varchar(255) NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `status`
--

INSERT INTO `status` (`id`, `name`, `class`, `time`) VALUES (1,'Qualified Lead','badge badge-warning','2014-06-27 09:04:42'),(2,'prospective','badge badge-purple','2014-06-27 11:36:53'),(3,'status1','badge badge-yellow','2014-06-27 11:37:14'),(4,'status2','badge badge-warning','2014-06-27 11:37:22'),(5,'status3','badge badge-yellow','2014-06-27 11:37:34');

--
-- Dumping events for database 'l9tslhne_hrmgmt'
--

--
-- Dumping routines for database 'l9tslhne_hrmgmt'
--


