-- MySQL dump 10.13 Distrib 5.7.35, for Linux (x86_64) -- -- Host: localhost Database: l9tslhne_hrmgmt -- ------------------------------------------------------ -- Server version 5.7.35 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `l9tslhne_hrmgmt` -- -- -- Table structure for table `attendence` -- DROP TABLE IF EXISTS `attendence`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `attendence` -- LOCK TABLES `attendence` WRITE; /*!40000 ALTER TABLE `attendence` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `attendence` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `calculator` -- DROP TABLE IF EXISTS `calculator`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `calculator` ( `id` int(11) NOT NULL AUTO_INCREMENT, `incometaxnull` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `calculator` -- LOCK TABLES `calculator` WRITE; /*!40000 ALTER TABLE `calculator` DISABLE KEYS */; /*!40000 ALTER TABLE `calculator` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `clients` -- DROP TABLE IF EXISTS `clients`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `clients` -- LOCK TABLES `clients` WRITE; /*!40000 ALTER TABLE `clients` DISABLE KEYS */; /*!40000 ALTER TABLE `clients` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `departments` -- DROP TABLE IF EXISTS `departments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `departments` -- LOCK TABLES `departments` WRITE; /*!40000 ALTER TABLE `departments` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `departments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `earlier_award` -- DROP TABLE IF EXISTS `earlier_award`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `earlier_award` -- LOCK TABLES `earlier_award` WRITE; /*!40000 ALTER TABLE `earlier_award` DISABLE KEYS */; /*!40000 ALTER TABLE `earlier_award` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `employees` -- DROP TABLE IF EXISTS `employees`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `employees` ( `e_id` int(11) NOT NULL AUTO_INCREMENT, `e_code` varchar(255) NOT NULL, `department` varchar(255) NOT NULL, `e_name` varchar(255) NOT NULL, `f_name` varchar(255) NOT NULL, `p_photograph` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `password` longtext NOT NULL, `dob` varchar(255) NOT NULL, `address` longtext NOT NULL, `status` int(11) NOT NULL, `highschool` varchar(255) NOT NULL, `intermediate` varchar(255) NOT NULL, `graduation` varchar(255) NOT NULL, `p_graduation` varchar(255) NOT NULL, `extraas` varchar(255) NOT NULL, `qualification_files` varchar(255) NOT NULL, `resume` varchar(255) NOT NULL, `mobile` varchar(255) NOT NULL, `telephone` varchar(255) NOT NULL, `idproof` varchar(255) NOT NULL, `idproof1` varchar(255) NOT NULL, `idproof2` varchar(255) NOT NULL, `idproof_files` varchar(255) NOT NULL, `j_date` date NOT NULL, `b_name` varchar(255) NOT NULL, `a_number` varchar(255) NOT NULL, `branch` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `ifsccode` varchar(255) NOT NULL, `salary` varchar(255) NOT NULL, `remarks` longtext NOT NULL, `appointment_date` varchar(255) NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `declaration` varchar(255) NOT NULL, `user_id` int(11) NOT NULL, PRIMARY KEY (`e_id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `employees` -- LOCK TABLES `employees` WRITE; /*!40000 ALTER TABLE `employees` DISABLE KEYS */; INSERT INTO `employees` (`e_id`, `e_code`, `department`, `e_name`, `f_name`, `p_photograph`, `email`, `password`, `dob`, `address`, `status`, `highschool`, `intermediate`, `graduation`, `p_graduation`, `extraas`, `qualification_files`, `resume`, `mobile`, `telephone`, `idproof`, `idproof1`, `idproof2`, `idproof_files`, `j_date`, `b_name`, `a_number`, `branch`, `city`, `ifsccode`, `salary`, `remarks`, `appointment_date`, `time`, `declaration`, `user_id`) VALUES (11,'test employee','1','Sample Employee','Name','','sample@gmail.com','2b5801d08603c0d5f4db58b71dc5ff22e1e3d3b88ac43dcc4468d1cbbaf3c4631c066a848818c4ed52fb329ec8a9ea77aa470d397040f2d938d1a9c8da6fa96c89e495e7941cf9e40e6980d14a16bf023ccd4c91e0e3500f3a1a51c3bbc6fe95da5b1f25d096432dfa739139d5504f6f96fe22fd4c115ca00c36171bacc0b82d1cf80b51b0f2a04dd2f363a5bc96c05990afaca6','02-03-1989','',0,'','','','','',',,,,,','','888789858','888785869','','','',',,,','2014-11-01','','','','','','','','','2015-01-30 12:08:55','89___80_shift.png,132___80_shift.png,',1); /*!40000 ALTER TABLE `employees` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `first_salaryslip` -- DROP TABLE IF EXISTS `first_salaryslip`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `first_salaryslip` -- LOCK TABLES `first_salaryslip` WRITE; /*!40000 ALTER TABLE `first_salaryslip` DISABLE KEYS */; INSERT INTO `first_salaryslip` (`id`, `earning`, `medical_allowance`, `AddField_632`) VALUES (1,NULL,'1000',''); /*!40000 ALTER TABLE `first_salaryslip` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `footer_salaryslip` -- DROP TABLE IF EXISTS `footer_salaryslip`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `footer_salaryslip` -- LOCK TABLES `footer_salaryslip` WRITE; /*!40000 ALTER TABLE `footer_salaryslip` DISABLE KEYS */; /*!40000 ALTER TABLE `footer_salaryslip` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `incometax_slab` -- DROP TABLE IF EXISTS `incometax_slab`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `incometax_slab` -- LOCK TABLES `incometax_slab` WRITE; /*!40000 ALTER TABLE `incometax_slab` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `incometax_slab` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `inventory` -- DROP TABLE IF EXISTS `inventory`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `inventory` -- LOCK TABLES `inventory` WRITE; /*!40000 ALTER TABLE `inventory` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `inventory` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `loan_module` -- DROP TABLE IF EXISTS `loan_module`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `loan_module` -- LOCK TABLES `loan_module` WRITE; /*!40000 ALTER TABLE `loan_module` DISABLE KEYS */; /*!40000 ALTER TABLE `loan_module` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `location` -- DROP TABLE IF EXISTS `location`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `location` -- LOCK TABLES `location` WRITE; /*!40000 ALTER TABLE `location` DISABLE KEYS */; INSERT INTO `location` (`id`, `name`) VALUES (1,'Sanjay Place'),(3,'Sikandra'),(4,'Sadar'); /*!40000 ALTER TABLE `location` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `main_salaryslip` -- DROP TABLE IF EXISTS `main_salaryslip`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `main_salaryslip` -- LOCK TABLES `main_salaryslip` WRITE; /*!40000 ALTER TABLE `main_salaryslip` DISABLE KEYS */; /*!40000 ALTER TABLE `main_salaryslip` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `office` -- DROP TABLE IF EXISTS `office`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `office` -- LOCK TABLES `office` WRITE; /*!40000 ALTER TABLE `office` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `office` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payment` -- DROP TABLE IF EXISTS `payment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `payment` -- LOCK TABLES `payment` WRITE; /*!40000 ALTER TABLE `payment` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `payment` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `payslip` -- DROP TABLE IF EXISTS `payslip`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `payslip` -- LOCK TABLES `payslip` WRITE; /*!40000 ALTER TABLE `payslip` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `payslip` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `salaryslipdata` -- DROP TABLE IF EXISTS `salaryslipdata`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `salaryslipdata` -- LOCK TABLES `salaryslipdata` WRITE; /*!40000 ALTER TABLE `salaryslipdata` DISABLE KEYS */; /*!40000 ALTER TABLE `salaryslipdata` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `second_salaryslip` -- DROP TABLE IF EXISTS `second_salaryslip`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `second_salaryslip` -- LOCK TABLES `second_salaryslip` WRITE; /*!40000 ALTER TABLE `second_salaryslip` DISABLE KEYS */; INSERT INTO `second_salaryslip` (`id`, `deduction`) VALUES (1,''); /*!40000 ALTER TABLE `second_salaryslip` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `setting` -- DROP TABLE IF EXISTS `setting`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `setting` -- LOCK TABLES `setting` WRITE; /*!40000 ALTER TABLE `setting` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `setting` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `singaporetable` -- DROP TABLE IF EXISTS `singaporetable`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `singaporetable` -- LOCK TABLES `singaporetable` WRITE; /*!40000 ALTER TABLE `singaporetable` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `singaporetable` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `status` -- DROP TABLE IF EXISTS `status`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `status` -- LOCK TABLES `status` WRITE; /*!40000 ALTER TABLE `status` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `status` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `password` longtext NOT NULL, `contact` varchar(255) NOT NULL, `address` varchar(255) NOT NULL, `photo` varchar(255) NOT NULL, `suspen_id` tinyint(4) NOT NULL, `type` int(11) NOT NULL COMMENT '0=admin,1=Employee,2= HR Manager, 3= HR Executive', `privilege` longtext NOT NULL, `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` (`id`, `name`, `email`, `password`, `contact`, `address`, `photo`, `suspen_id`, `type`, `privilege`, `time`) VALUES (1,'Sasi','admin@yahoo.com','e80baaae9a4f309cb96f781996a3e57aec3df68c2be5f5866b5a9e2a94078e3ae222abb702df11539521c475c4224d192aedf5e37aa11887593fd73e9247998b8bfd13cad0bc4b2ac41d9e235951e72c9b62c2aa162f7b124697e6aa1077c883f836624a1e8f6c1c08d045ea196daa6122cb707c9c9f3dabf0c6db11d13ac7c6c73597fb97571bf9f5af07e0883c91b68d389084','9733499537','Chennai','231___default_avatar.jpg',0,0,',,mostawarded,earlierawards,giveanawards,employeesdetails,newemployees,,,departments,newdepartments','2019-09-25 01:57:20'),(46,'Durgesh','durgesh@gmail.com','b2e753211ce860c6d6f16a3e9563ccfff5b4dfe5c9a2fcd975216924aabc5e05e143dd51dc6d0d3cf56d8778f7d03a2de2ef678c93d0e433e222e72b0c57a5a67b9378969123ebf166b9469817dfa9895b3a9d60008acbd0faa885bcb0e33871b40583c07e8188ed17562dbacee7ec1f742da47ef63a3e8b563f60d1d4aaa9205d7e25ef4645a140643cdfe4136cf1cc5d89ce77','9856545621','sanjay place','',0,3,',,,\r\n ,,,,\r\n ,,,\r\n ,,,\r\n ,','2018-10-26 17:59:48'),(47,'subodh','subodh@gmail.com','26c669cd0814ac40e5328752b21c4aa6450d16295e4eec30356a06a911c23983aaebe12d5da38eeebfc1b213be650498df8419194d5a26c7e0a50af156853c796ea7ccdcf642953a24672d10b0d32cef576e03294ca30d625406f2156693f69ad87b54e7b28e5d62e88c68d53c2c0bc68aee3a518c3dac553d2977555f85c679c2b2b46d0a790a93f0e9f157539c8a1d3e823c73','8954565452','sikandra','',0,2,',,,\r\n ,,,,\r\n ,,,\r\n ,,,\r\n ,','2015-01-10 09:54:52'),(48,'Amit','amit@gmail.com','26c669cd0814ac40e5328752b21c4aa6450d16295e4eec30356a06a911c23983aaebe12d5da38eeebfc1b213be650498df8419194d5a26c7e0a50af156853c796ea7ccdcf642953a24672d10b0d32cef576e03294ca30d625406f2156693f69ad87b54e7b28e5d62e88c68d53c2c0bc68aee3a518c3dac553d2977555f85c679c2b2b46d0a790a93f0e9f157539c8a1d3e823c73','8954902501','Ram Bagh Agra','41___the-internet-personified-17250-1600x1200.jpg',0,1,',,,,,departments,,singaporetable,payslip,incometax_slab,,','2015-01-10 09:58:51'),(49,'Suresh','suresh@gmail.com','26c669cd0814ac40e5328752b21c4aa6450d16295e4eec30356a06a911c23983aaebe12d5da38eeebfc1b213be650498df8419194d5a26c7e0a50af156853c796ea7ccdcf642953a24672d10b0d32cef576e03294ca30d625406f2156693f69ad87b54e7b28e5d62e88c68d53c2c0bc68aee3a518c3dac553d2977555f85c679c2b2b46d0a790a93f0e9f157539c8a1d3e823c73','9856542123','Mathura','136___the-internet-personified-17250-1600x1200.jpg',0,1,',,,,,,,,,incometax_slab,,','2015-01-10 10:01:33'),(50,'Sample Employee','sample@gmail.com','2b5801d08603c0d5f4db58b71dc5ff22e1e3d3b88ac43dcc4468d1cbbaf3c4631c066a848818c4ed52fb329ec8a9ea77aa470d397040f2d938d1a9c8da6fa96c89e495e7941cf9e40e6980d14a16bf023ccd4c91e0e3500f3a1a51c3bbc6fe95da5b1f25d096432dfa739139d5504f6f96fe22fd4c115ca00c36171bacc0b82d1cf80b51b0f2a04dd2f363a5bc96c05990afaca6','888789858','','',0,1,',,,,,,,,,incometax_slab,,','2015-01-30 12:08:55'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping events for database 'l9tslhne_hrmgmt' -- -- -- Dumping routines for database 'l9tslhne_hrmgmt' -- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2021-09-29 8:05:28