-- Table structure for table `demo_class_fee`
--

CREATE TABLE `demo_class_fee` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `class_id` varchar(50) DEFAULT NULL,
  `admission_fee` varchar(50) DEFAULT NULL,
  `registration_fee` varchar(50) DEFAULT NULL,
  `transportation_fee` varchar(50) DEFAULT NULL,
  `tuition_fee` varchar(50) DEFAULT NULL,
  `total_fee` varchar(50) DEFAULT NULL,
  `apply_date` int(11) DEFAULT NULL,
  `duration` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `demo_class_fee`
--

INSERT INTO `demo_class_fee` VALUES (11,'64','0','0','0','0','0',1614364200,'0'),(12,'63','0','0','0','0','0',2147483647,'1'),(13,'65','0','0','0','0','0',2147483647,'0'),(14,'66','0','0','0','0','0',2147483647,'0'),(15,'82','1','2','3','4','10',1616005800,'1'),(16,'73','1','2','3','4','10',1616697000,'1'),(17,'94','35000','1000','200','5000','41200',2147483647,'4'),(18,'92','1','122','2','2','127',2147483647,'4'),(19,'103','1','2','3','4','10',1619548200,'1'),(20,'88','1','2','3','4','10',1619634600,'4'),(21,'105','5000','1000','500','4000','10500',1620066600,'2'),(22,'104','2000','500','500','2000','5000',1620066600,'3'),(23,'74','1','2','3','4','10',1626460200,'2');

--
-- Table structure for table `demo_class_subject`
--

CREATE TABLE `demo_class_subject` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `class_id` varchar(50) DEFAULT NULL,
  `subject_id` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=794 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_class_subject`
--

INSERT INTO `demo_class_subject` VALUES (626,'64','28'),(627,'64','29'),(628,'64','30'),(629,'64','31'),(630,'64','32'),(631,'65','28'),(632,'65','29'),(633,'65','30'),(634,'65','31'),(635,'65','32'),(636,'66','28'),(637,'66','29'),(638,'66','30'),(639,'66','31'),(640,'66','32'),(641,'67','28'),(642,'67','29'),(643,'67','30'),(644,'67','31'),(645,'67','32'),(646,'68','28'),(647,'68','29'),(648,'68','30'),(649,'68','31'),(650,'68','32'),(651,'68','33'),(658,'70','28'),(659,'70','29'),(660,'70','30'),(661,'70','31'),(662,'70','32'),(663,'70','33'),(664,'71','28'),(665,'71','29'),(666,'71','30'),(667,'71','32'),(668,'71','34'),(669,'71','35'),(670,'71','36'),(691,'74','29'),(692,'74','30'),(693,'74','33'),(694,'74','34'),(695,'74','35'),(696,'74','38'),(705,'72','28'),(706,'72','29'),(707,'72','30'),(708,'72','31'),(709,'72','32'),(710,'72','33'),(711,'72','34'),(712,'72','35'),(713,'72','36'),(714,'72','37'),(715,'72','38'),(717,'78','39'),(718,'78','40'),(727,'80','28'),(728,'80','29'),(729,'80','30'),(730,'73','29'),(731,'73','30'),(732,'73','33'),(733,'73','34'),(734,'73','35'),(735,'73','38'),(736,'73','45'),(737,'73','46'),(738,'73','47'),(743,'81','30'),(750,'69','28'),(751,'69','29'),(752,'69','30'),(753,'69','32'),(754,'69','33'),(755,'69','41'),(768,'63','28'),(769,'92','37'),(770,'92','58'),(771,'102','30'),(772,'103','59'),(773,'103','60'),(774,'88','29'),(775,'88','30'),(776,'94','45'),(777,'94','46'),(778,'94','47'),(779,'94','48'),(782,'104','59'),(783,'104','60'),(784,'106','44'),(785,'106','45'),(787,'107','61'),(788,'89','44'),(789,'89','45'),(790,'89','46'),(791,'89','47'),(792,'89','48'),(793,'89','61');

--
-- Table structure for table `demo_class_teacher_list`
--

CREATE TABLE `demo_class_teacher_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `teacher_id` varchar(50) DEFAULT NULL,
  `class_id` varchar(50) DEFAULT NULL,
  `delete_status` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_class_teacher_list`
--


--
-- Table structure for table `demo_countries`
--

CREATE TABLE `demo_countries` (
  `country_id` int(11) NOT NULL,
  `country_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `demo_countries`
--

INSERT INTO `demo_countries` VALUES (1,'Aruba'),(2,'Afghanistan'),(3,'Angola'),(4,'Anguilla'),(5,'Albania'),(6,'Andorra'),(7,'Netherlands Antilles'),(8,'United Arab Emirates'),(9,'Argentina'),(10,'Armenia'),(11,'American Samoa'),(12,'Antarctica'),(13,'French Southern territories'),(14,'Antigua and Barbuda'),(15,'Australia'),(16,'Austria'),(17,'Azerbaijan'),(18,'Burundi'),(19,'Belgium'),(20,'Benin'),(21,'Burkina Faso'),(22,'Bangladesh'),(23,'Bulgaria'),(24,'Bahrain'),(25,'Bahamas'),(26,'Bosnia and Herzegovina'),(27,'Belarus'),(28,'Belize'),(29,'Bermuda'),(30,'Bolivia'),(31,'Brazil'),(32,'Barbados'),(33,'Brunei'),(34,'Bhutan'),(35,'Bouvet Island'),(36,'Botswana'),(37,'Central African Republic'),(38,'Canada'),(39,'Cocos (Keeling) Islands'),(40,'Switzerland'),(41,'Chile'),(42,'China'),(43,'Côte d’Ivoire'),(44,'Cameroon'),(45,'Congo, The Democratic Republic'),(46,'Congo'),(47,'Cook Islands'),(48,'Colombia'),(49,'Comoros'),(50,'Cape Verde'),(51,'Costa Rica'),(52,'Cuba'),(53,'Christmas Island'),(54,'Cayman Islands'),(55,'Cyprus'),(56,'Czech Republic'),(57,'Germany'),(58,'Djibouti'),(59,'Dominica'),(60,'Denmark'),(61,'Dominican Republic'),(62,'Algeria'),(63,'Ecuador'),(64,'Egypt'),(65,'Eritrea'),(66,'Western Sahara'),(67,'Spain'),(68,'Estonia'),(69,'Ethiopia'),(70,'Finland'),(71,'Fiji Islands'),(72,'Falkland Islands'),(73,'France'),(74,'Faroe Islands'),(75,'Micronesia, Federated States o'),(76,'Gabon'),(77,'United Kingdom'),(78,'Georgia'),(79,'Ghana'),(80,'Gibraltar'),(81,'Guinea'),(82,'Guadeloupe'),(83,'Gambia'),(84,'Guinea-Bissau'),(85,'Equatorial Guinea'),(86,'Greece'),(87,'Grenada'),(88,'Greenland'),(89,'Guatemala'),(90,'French Guiana'),(91,'Guam'),(92,'Guyana'),(93,'Hong Kong'),(94,'Heard Island and McDonald Isla'),(95,'Honduras'),(96,'Croatia'),(97,'Haiti'),(98,'Hungary'),(99,'Indonesia'),(100,'India'),(101,'British Indian Ocean Territory'),(102,'Ireland'),(103,'Iran'),(104,'Iraq'),(105,'Iceland'),(106,'Israel'),(107,'Italy'),(108,'Jamaica'),(109,'Jordan'),(110,'Japan'),(111,'Kazakstan'),(112,'Kenya'),(113,'Kyrgyzstan'),(114,'Cambodia'),(115,'Kiribati'),(116,'Saint Kitts and Nevis'),(117,'South Korea'),(118,'Kuwait'),(119,'Laos'),(120,'Lebanon'),(121,'Liberia'),(122,'Libyan Arab Jamahiriya'),(123,'Saint Lucia'),(124,'Liechtenstein'),(125,'Sri Lanka'),(126,'Lesotho'),(127,'Lithuania'),(128,'Luxembourg'),(129,'Latvia'),(130,'Macao'),(131,'Morocco'),(132,'Monaco'),(133,'Moldova'),(134,'Madagascar'),(135,'Maldives'),(136,'Mexico'),(137,'Marshall Islands'),(138,'Macedonia'),(139,'Mali'),(140,'Malta'),(141,'Myanmar'),(142,'Mongolia'),(143,'Northern Mariana Islands'),(144,'Mozambique'),(145,'Mauritania'),(146,'Montserrat'),(147,'Martinique'),(148,'Mauritius'),(149,'Malawi'),(150,'Malaysia'),(151,'Mayotte'),(152,'Namibia'),(153,'New Caledonia'),(154,'Niger'),(155,'Norfolk Island'),(156,'Nigeria'),(157,'Nicaragua'),(158,'Niue'),(159,'Netherlands'),(160,'Norway'),(161,'Nepal'),(162,'Nauru'),(163,'New Zealand'),(164,'Oman'),(165,'Pakistan'),(166,'Panama'),(167,'Pitcairn'),(168,'Peru'),(169,'Philippines'),(170,'Palau'),(171,'Papua New Guinea'),(172,'Poland'),(173,'Puerto Rico'),(174,'North Korea'),(175,'Portugal'),(176,'Paraguay'),(177,'Palestine'),(178,'French Polynesia'),(179,'Qatar'),(180,'Réunion'),(181,'Romania'),(182,'Russian Federation'),(183,'Rwanda'),(184,'Saudi Arabia'),(185,'Sudan'),(186,'Senegal'),(187,'Singapore'),(188,'South Georgia and the South Sa'),(189,'Saint Helena'),(190,'Svalbard and Jan Mayen'),(191,'Solomon Islands'),(192,'Sierra Leone'),(193,'El Salvador'),(194,'San Marino'),(195,'Somalia'),(196,'Saint Pierre and Miquelon'),(197,'Sao Tome and Principe'),(198,'Suriname'),(199,'Slovakia'),(200,'Slovenia'),(201,'Sweden'),(202,'Swaziland'),(203,'Seychelles'),(204,'Syria'),(205,'Turks and Caicos Islands'),(206,'Chad'),(207,'Togo'),(208,'Thailand'),(209,'Tajikistan'),(210,'Tokelau'),(211,'Turkmenistan'),(212,'East Timor'),(213,'Tonga'),(214,'Trinidad and Tobago'),(215,'Tunisia'),(216,'Turkey'),(217,'Tuvalu'),(218,'Taiwan'),(219,'Tanzania'),(220,'Uganda'),(221,'Ukraine'),(222,'United States Minor Outlying I'),(223,'Uruguay'),(224,'United States'),(225,'Uzbekistan'),(226,'Holy See (Vatican City State)'),(227,'Saint Vincent and the Grenadin'),(228,'Venezuela'),(229,'Virgin Islands, British'),(230,'Virgin Islands, U.S.'),(231,'Vietnam'),(232,'Vanuatu'),(233,'Wallis and Futuna'),(234,'Samoa'),(235,'Yemen'),(236,'Yugoslavia'),(237,'South Africa'),(238,'Zambia'),(239,'Zimbabwe');

--
-- Table structure for table `demo_custom_event`
--

CREATE TABLE `demo_custom_event` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `startdate` varchar(50) DEFAULT NULL,
  `enddate` varchar(50) DEFAULT NULL,
  `amount` varchar(100) DEFAULT NULL,
  `delete_status` varchar(50) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `discription` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `demo_custom_event`
--

INSERT INTO `demo_custom_event` VALUES (16,'dg','1614537000','1614623399',NULL,'1',142,NULL),(17,'abc','1615314600','1615400999',NULL,'1',142,NULL),(18,'teachers meeting','1615314600','1615400999',NULL,'1',156,NULL),(19,'take unit test 10th class','1616697000','1616783399',NULL,'0',142,NULL),(20,'exam','1615401000','1615487399',NULL,'0',156,NULL),(21,'abc','1615314600','1615400999',NULL,'1',143,NULL),(22,'sdsd','1617647400','1617733799',NULL,'1',145,NULL),(23,'ketk ek erkerkt ekrte we','1618338600','1618424999',NULL,'0',145,NULL),(24,'sd.....','1617820200','1617906599',NULL,'0',143,NULL),(25,'variy.....','1619548200','1619634599',NULL,'0',143,NULL),(26,'teach.....','1619721000','1619807399',NULL,'1',211,'teacher meeting'),(27,'unit .....','1617733800','1617820199',NULL,'1',216,'unit test in class btech'),(28,'sassd.....','1618943400','1619029799',NULL,'0',216,'sassdsd'),(29,'sdsd.....','1618943400','1619029799',NULL,'0',216,'sdsd'),(30,'assad.....','1618943400','1619029799',NULL,'0',216,'assadas'),(31,'sds.....','1618943400','1619029799',NULL,'0',216,'sds'),(32,'off today','1619893800','1619980199',NULL,'0',156,NULL),(33,'abc','1620671400','1620757799',NULL,'0',156,NULL),(34,'paren.....','1620412200','1620498599',NULL,'1',264,'parent techer meeting'),(35,'calcu.....','1620066600','1620152999',NULL,'0',143,'calculate salary'),(36,'aa.....','1620066600','1620152999',NULL,'1',143,'aa'),(37,'as.....','1620066600','1620152999',NULL,'0',143,'as'),(38,'vasba.....','1620066600','1620152999',NULL,'0',143,'vasbab'),(39,'vahbs.....','1620066600','1620152999',NULL,'0',143,'vahbs'),(40,'unit .....','1620066600','1620152999',NULL,'1',266,'unit test'),(41,'unit .....','1620153000','1620239399',NULL,'0',272,'unit test'),(42,'principal','1619548200','1619634599',NULL,'1',156,NULL),(43,'hyeee pr','1619548200','1619634599',NULL,'0',156,NULL),(44,'hhhhh.....','1619548200','1619634599',NULL,'1',216,'hhhhh'),(45,'hbsdmfbsd','1620153000','1620239399',NULL,'0',156,NULL),(46,'asdad.....','1620239400','1620325799',NULL,'0',156,'asdadasd'),(47,'demo','1624905000','1624991399',NULL,'0',156,NULL),(48,'abc.....','1624905000','1624991399',NULL,'0',143,'abc');

--
-- Table structure for table `demo_custom_lecture_request`
--

CREATE TABLE `demo_custom_lecture_request` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `custom_timetable_id` int(11) DEFAULT NULL,
  `teacher_id` int(11) DEFAULT NULL,
  `status` enum('pending','accepted','rejected') DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_custom_lecture_request`
--

INSERT INTO `demo_custom_lecture_request` VALUES (1,1,147,'accepted'),(2,1,148,'accepted'),(3,4,141,'pending'),(4,22,158,'rejected'),(5,30,157,'accepted'),(6,37,157,'accepted'),(7,44,158,'accepted');

--
-- Table structure for table `demo_custom_timetable`
--

CREATE TABLE `demo_custom_timetable` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `timetable_id` int(11) DEFAULT NULL,
  `period_id` int(11) DEFAULT NULL,
  `week_id` int(11) DEFAULT NULL,
  `teacher_id` int(11) DEFAULT NULL,
  `class_id` int(11) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `subject_id` int(11) DEFAULT NULL,
  `start_time` varchar(50) DEFAULT NULL,
  `end_time` varchar(50) DEFAULT NULL,
  `adjustment_duration` varchar(50) DEFAULT NULL,
  `addStartDate` varchar(50) DEFAULT NULL,
  `addEndDate` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `demo_custom_timetable`
--

INSERT INTO `demo_custom_timetable` VALUES (1,16,126,4,148,74,14,35,'1612931400','1612933200','1614277799','1614191400','1614277799'),(2,14,128,3,142,74,14,29,'1612935000','1612936800','1614191399','1614105000','1614191399'),(3,3,122,2,157,74,14,34,'1612924200','1612926000','1614104999','1614018600','1614104999'),(4,11,124,3,158,74,14,35,'1612927800','1612929600','1614191399','1614105000','1614191399'),(5,14,128,3,146,74,14,31,'1612935000','1612936800','1614796199','1614709800','1614796199'),(6,22,128,5,157,74,15,34,'1612935000','1612936800','1615487399','1614277799','1615487399'),(7,31,129,5,142,74,14,29,'1612936800','1612938600','1614968999','1614882600','1614968999'),(8,39,108,5,147,72,14,32,'1612929600','1612931400','1614364199','1614277800','1614364199'),(9,49,98,5,149,71,14,36,'1612926000','1612927800','1614364199','1614277800','1614364199'),(10,51,93,5,149,71,15,36,'1612931400','1612933200','1614364199','1614277800','1614364199'),(11,56,96,6,142,71,15,29,'1612936800','1612938600','1614450599','1614364200','1614450599'),(13,62,130,3,158,74,14,35,'1614234600','1614236400','1615919399','1615746600','1615919399'),(14,71,112,1,145,72,14,30,'1616653800','1616655600','1615919399','1615746600','1615919399'),(15,70,112,4,157,72,15,34,'1616653800','1616655600','1616005799','1615833000','1616005799'),(16,82,105,4,158,72,15,35,'1612924200','1612926000','1616092199','1616005800','1616092199'),(17,83,110,4,158,72,15,35,'1616648400','1616652000','1616092199','1616005800','1616092199'),(19,67,127,5,142,74,14,29,'1612933200','1612935000','1616869799','1616697000','1616869799'),(21,68,108,3,142,72,15,29,'1612929600','1612931400','1616005799','1615919400','1616005799'),(22,95,106,5,157,72,15,34,'1612926000','1612927800','1616178599','1616092200','1616178599'),(23,101,113,1,141,73,14,28,'1612924200','1612926000','1617042599','1616956200','1617042599'),(24,64,126,1,141,74,14,28,'1612931400','1612933200','1617042599','1616956200','1617042599'),(25,86,109,4,157,72,14,34,'1612931400','1612933200','1616696999','1616610600','1616696999'),(26,70,112,4,157,72,15,34,'1616653800','1616655600','1616696999','1616610600','1616696999'),(27,139,106,6,157,72,14,34,'1612926000','1612927800','1616264999','1616178600','1616264999'),(28,134,112,2,142,72,14,29,'1616653800','1616655600','1616610599','1616437800','1616610599'),(29,68,108,3,142,72,15,29,'1612929600','1612931400','1616610599','1616437800','1616610599'),(30,173,168,5,157,89,24,48,'1616650200','1616652000','1618079399','1617993000','1618079399'),(31,172,166,6,215,89,24,48,'1616646600','1616648400','1618079399','1617993000','1618079399'),(32,152,169,1,145,89,24,30,'1616652000','1616653800','1618338599','1618165800','1618338599'),(33,161,169,2,157,89,24,34,'1616652000','1616653800','1618338599','1618165800','1618338599'),(34,167,169,3,215,89,24,48,'1616652000','1616653800','1618424999','1618338600','1618424999'),(35,176,173,1,213,94,24,45,'1618113600','1618115400','1618856999','1618770600','1618856999'),(36,156,166,1,213,89,24,45,'1616646600','1616648400','1618856999','1618770600','1618856999'),(37,159,168,2,157,89,24,40,'1616650200','1616652000','1618943399','1618857000','1618943399'),(38,139,106,6,157,72,14,34,'1612926000','1612927800','1619375399','1619202600','1619375399'),(39,140,110,6,149,72,14,36,'1616648400','1616652000','1619288999','1619202600','1619288999'),(42,214,184,5,211,92,24,44,'1619161200','1619164800','1619807399','1619721000','1619807399'),(43,51,93,5,157,71,15,34,'1612931400','1612933200','1619980199','1619893800','1619980199'),(44,214,184,5,158,92,24,34,'1619161200','1619164800','1621016999','1620930600','1621016999'),(45,243,207,1,267,105,24,62,'1620019800','1620021600','1620066599','1619980200','1620066599'),(46,156,166,1,228,89,24,45,'1616646600','1616648400','1620066599','1619980200','1620066599'),(47,176,173,1,254,94,24,59,'1618113600','1618115400','1620066599','1619980200','1620066599'),(48,251,209,1,270,106,24,45,'1620099000','1620102600','1620844199','1620585000','1620844199'),(49,253,211,2,270,106,24,45,'1620106200','1620109800','1620844199','1620585000','1620844199'),(50,256,212,3,270,106,24,45,'1620109800','1620113400','1620844199','1620585000','1620844199'),(51,71,112,1,142,72,14,29,'1616653800','1616655600','1627410599','1627324200','1627410599'),(52,134,112,2,142,72,14,29,'1616653800','1616655600','1627410599','1627324200','1627410599'),(53,148,111,2,142,72,15,29,'1616652000','1616653800','1627410599','1627324200','1627410599'),(54,251,209,1,141,106,24,32,'1620099000','1620102600','1627410599','1627324200','1627410599'),(56,187,179,1,142,64,14,29,'1618360200','1618362000','1627410599','1627324200','1627410599'),(58,147,111,4,142,72,14,29,'1616652000','1616653800','1627410599','1627324200','1627410599'),(59,147,111,4,149,72,14,36,'1616652000','1616653800','1627410599','1627324200','1627410599'),(62,71,112,1,142,72,14,29,'1616653800','1616655600','1627496999','1627410600','1627496999');

--
-- Table structure for table `demo_emi`
--

CREATE TABLE `demo_emi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `loan_id` int(11) DEFAULT NULL,
  `month` varchar(100) DEFAULT NULL,
  `emi_number` int(11) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `updated_date` varchar(100) DEFAULT NULL,
  `created_date` varchar(100) DEFAULT NULL,
  `salary_id` varchar(100) DEFAULT NULL,
  `interest` varchar(100) DEFAULT NULL,
  `emi_amount` varchar(100) DEFAULT NULL,
  `delete_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_emi`
--

INSERT INTO `demo_emi` VALUES (6,4,'Feb',1,'1',NULL,NULL,'59','0','500',0),(7,4,'Mar',2,'1',NULL,NULL,'59','0','500',0),(8,4,'Apr',3,'1',NULL,NULL,'59','0','500',0),(9,4,'May',4,'1',NULL,NULL,'59','0','500',0),(10,5,'Feb',1,'1',NULL,NULL,'59','0','1000',0),(11,5,'Mar',2,'1',NULL,NULL,'59','0','1000',0),(12,6,'Feb',1,'1',NULL,NULL,'59','0','2500',0),(13,6,'Mar',2,'1',NULL,NULL,'59','0','2500',0),(14,7,'Feb',1,'1',NULL,NULL,'59','0','500',0),(15,7,'Mar',2,'1',NULL,NULL,'59','0','500',0),(16,8,'Feb',1,'1',NULL,NULL,'59','0','2000',0),(17,8,'Mar',2,'1',NULL,NULL,'59','0','2000',0),(18,9,'Feb',1,'1',NULL,NULL,'59','0','5000',0),(19,10,'Mar',1,'1',NULL,NULL,'59','0','1000',0),(20,10,'Apr',2,'1',NULL,NULL,'59','0','1000',0),(21,10,'May',3,'1',NULL,NULL,'59','0','1000',0),(22,10,'Jun',4,'1',NULL,NULL,'59','0','1000',0),(23,10,'Jul',5,'1',NULL,NULL,'59','0','1000',0),(24,11,'Mar',1,'1',NULL,NULL,'59','0','1000',0),(25,11,'Apr',2,'1',NULL,NULL,'59','0','1000',0),(26,11,'May',3,'1',NULL,NULL,'59','0','1000',0),(27,11,'Jun',4,'1',NULL,NULL,'59','0','1000',0),(28,11,'Jul',5,'1',NULL,NULL,'59','0','1000',0),(29,12,'Mar',1,'1',NULL,NULL,'59','0','10000',0),(30,12,'Apr',2,'1',NULL,NULL,'59','0','10000',0),(31,12,'May',3,'1',NULL,NULL,'59','0','10000',0),(32,12,'Jun',4,'1',NULL,NULL,'59','0','10000',0),(33,12,'Jul',5,'1',NULL,NULL,'59','0','10000',0),(34,13,'Apr',1,'1',NULL,NULL,'62','0','5000',0),(35,13,'May',2,'1',NULL,NULL,'63','0','5000',0),(39,15,'Apr',1,'0',NULL,NULL,NULL,'0','1447.6666666667',0),(40,15,'May',2,'0',NULL,NULL,NULL,'0','1447.6666666667',0),(41,15,'Jun',3,'0',NULL,NULL,NULL,'0','1447.6666666667',0),(42,16,'Apr',1,'0',NULL,NULL,NULL,'0','33',0),(43,17,'Apr',1,'0',NULL,NULL,NULL,'0','5000',0),(44,17,'May',2,'0',NULL,NULL,NULL,'0','5000',0),(45,18,'Apr',1,'0',NULL,NULL,NULL,'0','5000',0),(46,18,'May',2,'0',NULL,NULL,NULL,'0','5000',0),(50,14,'May',1,'0',NULL,NULL,NULL,'0','2500',0),(51,14,'Jun',2,'0',NULL,NULL,NULL,'0','2500',0),(56,19,'May',1,'0',NULL,NULL,NULL,'0','1250',0),(57,19,'Jun',2,'0',NULL,NULL,NULL,'0','1250',0),(58,19,'Jul',3,'0',NULL,NULL,NULL,'0','1250',0),(59,19,'Aug',4,'0',NULL,NULL,NULL,'0','1250',0),(60,20,'May',1,'1',NULL,NULL,'69','0','10000',0),(61,20,'Jun',2,'1',NULL,NULL,'70','0','10000',0);

--
-- Table structure for table `demo_employee_image`
--

CREATE TABLE `demo_employee_image` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_name` varchar(50) DEFAULT NULL,
  `file_path` varchar(50) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `demo_employee_image`
--

INSERT INTO `demo_employee_image` VALUES (21,'1612944256_a3a5ab8f4faacfe7f8b7.jpg','employee/1612944256_a3a5ab8f4faacfe7f8b7.jpg','141'),(22,'1613545214_5ab9bb4f00ddc0defb01.jpg','employee/1613545214_5ab9bb4f00ddc0defb01.jpg','157'),(23,'1614078422_9203f6f34224e14da930.jpg','employee/1614078422_9203f6f34224e14da930.jpg','147'),(24,'1614082005_9901a9e06e566ce9a1b5.jpg','employee/1614082005_9901a9e06e566ce9a1b5.jpg','145'),(25,'1614340037_de3f934b38f249e19496.jpg','employee/1614340037_de3f934b38f249e19496.jpg','149'),(26,'1615626600_0fb1de791edbccf0ce53.jpg','employee/1615626600_0fb1de791edbccf0ce53.jpg','187'),(27,'1615812444_e1db0b6a88d94964dc6f.jpg','employee/1615812444_e1db0b6a88d94964dc6f.jpg','142'),(28,'1619503990_706ad50fc2c5c0552a5e.jpg','employee/1619503990_706ad50fc2c5c0552a5e.jpg','251'),(29,'1619522260_b93a4ffc32aa210b51f1.jpg','employee/1619522260_b93a4ffc32aa210b51f1.jpg','252'),(30,'1619938106_0637e1c2c7aab66a5dae.jpg','employee/1619938106_0637e1c2c7aab66a5dae.jpg','211'),(31,'1620109909_a18dfc12203ba75da248.jpg','employee/1620109909_a18dfc12203ba75da248.jpg','269');

--
-- Table structure for table `demo_employee_order`
--

CREATE TABLE `demo_employee_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  `status` varchar(10) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `location` enum('front','back') DEFAULT NULL,
  `field_name` varchar(50) DEFAULT NULL,
  `show_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `demo_employee_order`
--

INSERT INTO `demo_employee_order` VALUES (1,'User Name','1',2,'back','uname','User Name'),(2,'First Name','1',3,'front','firstname','First Name'),(3,'Last Name','1',1,'front','lastname','Last Name'),(4,'Email Id','1',4,'back','email','Email Id');

--
-- Table structure for table `demo_exam`
--

CREATE TABLE `demo_exam` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `delete_status` varchar(50) DEFAULT NULL,
  `max_marks` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_exam`
--

INSERT INTO `demo_exam` VALUES (20,'Pre_board','1','100'),(21,'Final_exam','1','100'),(22,'Weekly_exam','0','20'),(23,'sessional','1','100'),(24,'pre_board','0','50'),(25,'pre_board','1','100'),(26,'final_exam','0','100'),(27,'Sessional','0','20'),(28,'sessional','1','100'),(29,'ff','1','100'),(30,'as','1','100'),(31,'as','1','100'),(32,'Monthly_exam','0','50'),(33,'final','1','100'),(34,'unit_test','0','40'),(35,'xch','1','45');

--
-- Table structure for table `demo_fees`
--

CREATE TABLE `demo_fees` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `admission_fee` varchar(50) DEFAULT NULL,
  `registration_fee` varchar(50) DEFAULT NULL,
  `transportation_fee` varchar(50) DEFAULT NULL,
  `tuition_fee` varchar(50) DEFAULT NULL,
  `total_fee` varchar(50) DEFAULT NULL,
  `sid` varchar(50) DEFAULT NULL,
  `from_date` varchar(50) DEFAULT NULL,
  `to_date` varchar(50) DEFAULT NULL,
  `paid` enum('yes','no') DEFAULT NULL,
  `month` varchar(50) DEFAULT NULL,
  `delete_status` int(11) DEFAULT NULL,
  `other_fee` varchar(50) DEFAULT NULL,
  `year` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_fees`
--

INSERT INTO `demo_fees` VALUES (1,'2000','1000','500','2000','5500','147',NULL,NULL,'yes','01',0,NULL,NULL),(2,'1','2','3','4','10','147',NULL,NULL,'yes','02',0,NULL,NULL),(3,'1','2','3','4','10','147',NULL,NULL,'yes','03',0,NULL,NULL),(4,'1','1','1','1','4','147',NULL,NULL,'yes','11',0,NULL,NULL),(5,'10','10','10','10','40','147',NULL,NULL,'yes','01',0,NULL,NULL),(6,'10','10','10','10','40','147',NULL,NULL,'yes','10',0,NULL,NULL),(7,'1','1','1','1','4','147',NULL,NULL,'yes','03',0,NULL,NULL),(8,'1','1','1','1','4','147',NULL,NULL,'no','03',0,NULL,NULL),(9,'1','2','3','4','10','147',NULL,NULL,'yes','05',0,NULL,NULL),(10,'0','0','0','2000','2000','147',NULL,NULL,'no','06',0,NULL,NULL),(11,'0','0','0','0','0','147',NULL,NULL,'no','07',0,NULL,NULL),(12,'1','2','3','4','10','147',NULL,NULL,'no','08',0,NULL,NULL),(13,'1','2','3','4','10','146',NULL,NULL,'yes','01',0,NULL,NULL),(14,'0','0','1000','2000','3000','146',NULL,NULL,'yes','02',0,NULL,NULL),(15,'0','0','0','2000','2000','146',NULL,NULL,'yes','03',0,NULL,NULL),(16,'1','2','3','5','11','142',NULL,NULL,'yes','03',0,NULL,NULL),(17,'1','2','3','4','10','148',NULL,NULL,'no','03',0,NULL,NULL),(18,'1','2','3','4','10','150',NULL,NULL,'no','03',0,NULL,NULL),(19,'1','2','3','5','11','730',NULL,NULL,'no','04',0,NULL,NULL),(20,'0','2','3','4','9','730',NULL,NULL,'no','05',0,NULL,NULL),(21,'0','0','455','565','1020','730',NULL,NULL,'no','06',0,NULL,NULL),(22,'132323','23234','434434','434','590425','730',NULL,NULL,'no','07',0,NULL,NULL),(23,'0','0','4','4','8','730',NULL,NULL,'no','08',0,NULL,NULL),(24,'1','2','3','4','10','730',NULL,NULL,'no','09',0,NULL,NULL),(25,'1','2','3','4','10','730',NULL,NULL,'no','10',0,NULL,NULL),(26,'1','2','3','4','10','730',NULL,NULL,'no','11',0,NULL,NULL),(27,'1','1','1','3','6','730',NULL,NULL,'no','12',0,NULL,NULL),(28,'1','2','3','4','10','730',NULL,NULL,'no','01',0,NULL,NULL),(29,'1','2','3','4','10','730',NULL,NULL,'no','02',0,NULL,NULL),(30,'1','2','3','4','10','113',NULL,NULL,'yes','02',0,NULL,NULL),(31,'1','2','3','4','15','131',NULL,NULL,'no','01',0,'5',NULL),(32,'10','20','30','40','150','731',NULL,NULL,'yes','01',0,'50',NULL),(33,'1','2','3','4','15','740',NULL,NULL,'no','01',0,'5',NULL),(34,'5','1','2','7','18','740',NULL,NULL,'no','01',0,'3',NULL),(35,'1','2','3','4','15','739',NULL,NULL,'yes','01',0,'5',NULL),(36,'1','2','3','4','15','533',NULL,NULL,'no','01',0,'5',NULL),(37,'1','2','3','4','15','527',NULL,NULL,'no','01',0,'5',NULL),(38,'1','2','3','656','712','747',NULL,NULL,'yes','01',0,'50',NULL),(39,'1000','500','500','3000','8000','748',NULL,NULL,'yes','04',0,'3000',NULL),(40,'1','2','3','4','15','751',NULL,NULL,'no','03',0,'5',NULL),(41,'1','2','3','4','15','750',NULL,NULL,'yes','01',0,'5',NULL),(42,'1','2','3','4','15','750',NULL,NULL,'yes','02',0,'5',NULL),(43,'1','2','3','4','15','750',NULL,NULL,'yes','03',0,'5',NULL),(44,'1','2','3','4','15','750',NULL,NULL,'no','04',0,'5',NULL),(45,'1','2','3','4','15','750',NULL,NULL,'no','05',0,'5',NULL),(46,'1','2','3','4','15','750',NULL,NULL,'no','06',0,'5',NULL),(47,'1','2','3','4','15','750',NULL,NULL,'no','07',0,'5',NULL),(48,'1','2','3','4','15','750',NULL,NULL,'no','08',0,'5',NULL),(49,'1','2','3','4','15','750',NULL,NULL,'no','09',0,'5',NULL),(50,'1','2','3','4','15','750',NULL,NULL,'no','10',0,'5',NULL),(51,'1','2','3','4','15','750',NULL,NULL,'no','11',0,'5',NULL),(52,'1','2','3','4','15','750',NULL,NULL,'no','12',0,'5',NULL),(53,'1','2','3','4','15','754',NULL,NULL,'yes','04',0,'5',NULL),(54,'1','2','3','4','15','754',NULL,NULL,'no','05',0,'5',NULL),(55,'10','20','20','20','100','748',NULL,NULL,'yes','05',0,'30',NULL),(56,'10','10','10','10','50','757',NULL,NULL,'no','01',0,'10',NULL),(57,'1','2','3','4','15','755',NULL,NULL,'yes','04',0,'5',NULL),(58,'1','2','3','4','15','755',NULL,NULL,'yes','05',0,'5',NULL),(59,'1','2','1','1','6','755',NULL,NULL,'yes','09',0,'1',NULL),(60,'3','1','2','7','69','755',NULL,NULL,'yes','09',0,'56',NULL),(61,'1','3','3','3','14','755',NULL,NULL,'yes','10',0,'4',NULL),(62,'1','2','3','4','15','761',NULL,NULL,'no','04',0,'5',NULL),(63,'1','2','3','4','15','753',NULL,NULL,'no','05',0,'5',NULL),(64,'10','20','30','40','150','755',NULL,NULL,'no','06',1,'50',NULL),(65,'10','20','30','40','150','755',NULL,NULL,'yes','06',0,'50',NULL),(66,'1','2','3','4','15','755',NULL,NULL,'yes','10',0,'5',NULL),(67,'1','2','3','4','15','770',NULL,NULL,'no','06',0,'5',NULL),(68,'1','2','3','4','15','771',NULL,NULL,'yes','02',0,'5',NULL),(69,'5','5','2','3','19','771',NULL,NULL,'yes','03',0,'4',NULL),(70,'1','2','4','3','15','771',NULL,NULL,'yes','04',0,'5','2021'),(71,'1','2','3','4','15','771',NULL,NULL,'yes','05',0,'5','2021'),(72,'1000','2000','500','600','6100','771',NULL,NULL,'yes','07',0,'2000','2021'),(73,'1','1','1','1','5','772',NULL,NULL,'no','01',0,'1',NULL),(74,'12','12','12','12','60','771',NULL,NULL,'yes','08',0,'12','2021'),(75,'10','2','2','3','20','771',NULL,NULL,'yes','09',0,'3','2021'),(76,'11','12','13','14','65','771',NULL,NULL,'no','11',1,'15','2021'),(77,'1','2','3','4','15','771',NULL,NULL,'no','11',1,'5','2021'),(78,'1','2','3','4','15','771',NULL,NULL,'yes','12',0,'5','2021'),(79,'1','2','3','4','15','771',NULL,NULL,'yes','11',0,'5','2021'),(80,'0','0','0','100','100','772',NULL,NULL,'no','01',0,'0','2022'),(81,'1','2','3','4','15','771',NULL,NULL,'no','04',0,'5','2021'),(82,'2','1','5','3','14','771',NULL,NULL,'no','05',0,'3','2021'),(83,'10','20','30','40','150','780',NULL,NULL,'no','01',0,'50','2021'),(84,'1','1','1','1','5','745',NULL,NULL,'no','04',0,'1','2021'),(85,'1','2','3','4','15','773',NULL,NULL,'yes','01',0,'5','2021'),(86,'1','2','3','4','15','789',NULL,NULL,'no','01',0,'5','2021'),(87,'1','2','3','4','15','789',NULL,NULL,'no','02',0,'5','2021'),(88,'1','2','5','3','15','789',NULL,NULL,'no','03',0,'4','2021'),(89,'1','2','2','5','14','789',NULL,NULL,'no','04',0,'4','2022'),(90,'1','2','3','5','15','789',NULL,NULL,'no','05',0,'4','2021'),(91,'1','2','3','4','15','789',NULL,NULL,'no','06',0,'5','2021'),(92,'1','2','3','4','14','789',NULL,NULL,'no','07',0,'4','2021'),(93,'1','2','3','4','15','789',NULL,NULL,'no','08',0,'5','2021'),(94,'1','2','3','4','15','789',NULL,NULL,'no','09',0,'5','2021'),(95,'1','2','3','4','15','789',NULL,NULL,'no','10',0,'5','2021'),(96,'10','20','3','4','42','789',NULL,NULL,'no','11',0,'5','2021'),(97,'1','1','1','1','5','727',NULL,NULL,'no','01',0,'1','2021'),(98,'1','2','3','4','15','771',NULL,NULL,'no','07',0,'5','2021'),(99,'1','1','1','1','5','790',NULL,NULL,'no','02',0,'1','2021'),(100,'1','2','3','4','15','773',NULL,NULL,'yes','02',0,'5','2021'),(101,'1','2','3','4','15','790',NULL,NULL,'yes','03',0,'5','2021'),(102,'1','2','3','4','15','782',NULL,NULL,'no','04',0,'5','2021'),(103,'0','0','0','0','0','758',NULL,NULL,'no','04',NULL,'0','2021'),(104,'0','0','0','0','0','114',NULL,NULL,'no','04',NULL,'0','2021'),(105,'0','0','0','0','0','113',NULL,NULL,'no','04',NULL,'0','2021'),(106,'1','2','3','4','15','782',NULL,NULL,'no','05',0,'5','2021'),(107,'1','2','3','4','15','801',NULL,NULL,'yes','05',0,'5','2021'),(108,'1','2','3','4','15','800',NULL,NULL,'no','05',0,'5','2021'),(109,'1','2','3','4','15','799',NULL,NULL,'no','05',0,'5','2021'),(110,'0','0','0','0','0','111',NULL,NULL,'no','4',NULL,'0','2021'),(111,'0','0','0','0','0','112',NULL,NULL,'no','4',NULL,'0','2021'),(113,'5000','1000','500','4000','10500',NULL,NULL,NULL,'no','4',NULL,'0','2021'),(114,'2000','500','500','2000','5000','801',NULL,NULL,'no','4',NULL,'0','2021'),(115,'2000','500','500','2000','5000','800',NULL,NULL,'no','4',NULL,'0','2021'),(116,'2000','500','500','2000','5000','799',NULL,NULL,'no','4',NULL,'0','2021'),(117,'2000','500','500','2000','5000','791',NULL,NULL,'no','4',NULL,'0','2021'),(118,'2000','500','500','2000','5000','790',NULL,NULL,'no','4',NULL,'0','2021'),(119,'2000','500','500','2000','5000','792',NULL,NULL,'no','4',NULL,'0','2021'),(121,'5','5','5','5','25','801',NULL,NULL,'no','01',0,'5','2021'),(122,'4444','4','4','44','4500','806',NULL,NULL,'yes','01',0,'4','2021'),(123,'1','2','3','4','15','806',NULL,NULL,'yes','05',0,'5','2021'),(124,'1','2','3','3','15','806',NULL,NULL,'yes','02',0,'6','2021'),(125,'1','1','1','1','5','806',NULL,NULL,'no','01',0,'1','2021');

--
-- Table structure for table `demo_field_value`
--

CREATE TABLE `demo_field_value` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reference_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `field_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `field_value` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `demo_field_value`
--

INSERT INTO `demo_field_value` VALUES (98,'126','11',NULL),(99,'127','13','B'),(100,'128','13',NULL),(101,'129','13','54'),(102,'130','13','sa'),(103,'131','13','A'),(104,'132','13','B'),(105,'133','13','B'),(106,'134','13','C'),(107,'135','13','A'),(108,'136','13','A'),(109,'137','13',''),(110,'138','13',NULL),(111,'139','13',NULL),(112,'140','13',NULL),(113,'141','13',NULL);

--
-- Table structure for table `demo_holiday`
--

CREATE TABLE `demo_holiday` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `startdate` varchar(50) DEFAULT NULL,
  `enddate` varchar(50) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `delete_status` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_holiday`
--

INSERT INTO `demo_holiday` VALUES (15,'abc','1613673000','1613845800','1','1'),(16,'holi','1616956200','1617129000','3','0'),(17,'sd','1615919400','1615919400','3','1'),(18,'','-19800','-19800','1','1'),(19,'','0','0','1','1'),(20,'holiday','1618511400','1618511400','1','0'),(21,'sd','1618511400','1618597800','3','1'),(22,'dfd','1619029800','1619116200','1','0'),(23,'abc','1619029800','1619029800','2','1'),(24,'tempory holiday','1619980200','1619980200','1','0');

--
-- Table structure for table `demo_island`
--

CREATE TABLE `demo_island` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `demo_island`
--


--
-- Table structure for table `demo_item`
--

CREATE TABLE `demo_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `demo_item`
--


--
-- Table structure for table `demo_jobassignment`
--

CREATE TABLE `demo_jobassignment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `assignment_id` varchar(100) DEFAULT NULL,
  `reporting_id` int(11) DEFAULT NULL,
  `dept_id` int(11) DEFAULT NULL,
  `created` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_jobassignment`
--

INSERT INTO `demo_jobassignment` VALUES (24,141,'0123',156,1,NULL,NULL),(25,142,'1211',145,2,NULL,NULL),(26,145,'1212',156,1,NULL,NULL),(27,148,'1213',145,1,NULL,NULL),(28,157,'1214',143,1,NULL,NULL),(29,158,'1215',157,2,NULL,NULL),(30,151,'1216',156,1,NULL,NULL),(31,146,'12345',156,1,NULL,NULL),(32,147,'55561',156,1,NULL,NULL),(33,149,'4546',142,2,NULL,NULL),(34,183,'122',157,1,NULL,NULL),(35,187,'345',157,1,NULL,NULL),(36,200,'12212',198,1,NULL,NULL),(37,143,'233',156,1,NULL,NULL),(38,156,'6776',143,1,NULL,NULL),(39,210,'67',157,0,NULL,NULL),(40,213,'2323',251,1,NULL,NULL),(41,215,'456',213,1,NULL,NULL),(42,222,'232',156,1,NULL,NULL),(43,228,'125',153,1,NULL,NULL),(44,229,'123',156,1,NULL,NULL),(45,232,'ww',156,1,NULL,NULL),(46,211,'1223',156,1,NULL,NULL),(47,216,'23234',156,1,NULL,NULL),(48,195,'13',143,1,NULL,NULL),(49,251,'123df',156,1,NULL,NULL),(50,253,'12398',142,1,NULL,NULL),(51,255,'34512',254,1,NULL,NULL),(52,254,'765',156,2,NULL,NULL),(53,268,'12334',156,1,NULL,NULL),(54,267,'6578',156,2,NULL,NULL),(55,269,'3456',156,1,NULL,NULL),(56,270,'5678',156,1,NULL,NULL);

--
-- Table structure for table `demo_leavetype_list`
--

CREATE TABLE `demo_leavetype_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `days` int(11) DEFAULT '0',
  `delete_status` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_leavetype_list`
--

INSERT INTO `demo_leavetype_list` VALUES (19,'SL',10,0),(20,'EL',2,0),(21,'CL',7,0),(22,'we',3,1),(23,'ab',2,1),(24,'df',0,1);

--
-- Table structure for table `demo_loan`
--

CREATE TABLE `demo_loan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `amount` varchar(20) DEFAULT NULL,
  `description` varchar(50) DEFAULT NULL,
  `delete_status` int(11) DEFAULT NULL,
  `status` enum('pending','accepted','rejected','adjusted') DEFAULT NULL,
  `emi` int(11) DEFAULT NULL,
  `paid_amount` varchar(50) DEFAULT NULL,
  `created_date` varchar(100) DEFAULT NULL,
  `updated_date` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `demo_loan`
--

INSERT INTO `demo_loan` VALUES (4,158,'2000','desc',0,'accepted',4,'1000','1613396434','1613396445'),(5,158,'2000','loan',0,'accepted',2,'1000','1613476096','1613476169'),(6,157,'5000','loan',0,'adjusted',2,'5000','1613476622','1613476689'),(7,158,'1000','abc',0,'accepted',2,'500','1613720932','1613721040'),(8,146,'4000','loan',0,'adjusted',2,'4000','1613725166','1613725217'),(9,146,'5000','abc',0,'adjusted',1,'5000','1613725907','1613725974'),(10,143,'5000','56',0,'pending',5,NULL,'1616580044',NULL),(11,213,'5000','abc',0,'pending',5,NULL,'1616760219',NULL),(12,215,'50000','loan',0,'adjusted',5,'50000','1617102355','1617102651'),(13,145,'10000','demo',0,'accepted',2,'10000','1617349347','1617349460'),(14,156,'5000','loan request',0,'pending',2,NULL,'1619519197',NULL),(15,156,'4343','fff',0,'pending',3,NULL,'1619519201',NULL),(16,156,'33','fgfg',0,'pending',1,NULL,'1619519219',NULL),(17,211,'10000','loan',0,'pending',2,NULL,'1619782176',NULL),(18,216,'10000','we',0,'pending',2,NULL,'1619786847',NULL),(19,143,'5000','home loan',0,'pending',4,NULL,'1620014725',NULL),(20,269,'20000','home loan',0,'accepted',2,'20000','1620111239','1620111670');

--
-- Table structure for table `demo_marke_type`
--

CREATE TABLE `demo_marke_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `markes_type` enum('number','grade') DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_marke_type`
--

INSERT INTO `demo_marke_type` VALUES (1,'student markes Type','number');

--
-- Table structure for table `demo_mass_mail_sms`
--

CREATE TABLE `demo_mass_mail_sms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `user_email` varchar(50) DEFAULT NULL,
  `message` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_mass_mail_sms`
--


--
-- Table structure for table `demo_over_time`
--

CREATE TABLE `demo_over_time` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `hour` varchar(20) DEFAULT NULL,
  `description` varchar(50) DEFAULT NULL,
  `delete_status` int(11) DEFAULT NULL,
  `status` enum('pending','accepted','rejected','adjusted') DEFAULT NULL,
  `created_date` varchar(100) DEFAULT NULL,
  `updated_date` varchar(100) DEFAULT NULL,
  `salary_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `demo_over_time`
--

INSERT INTO `demo_over_time` VALUES (1,158,'30','over time',0,'adjusted','1613391824','1613391845',6),(2,157,'30','over time',0,'adjusted','1613477125','1613477177',14),(3,157,'60','over time',0,'adjusted','1613477572','1613477594',16),(4,142,'30','over time',0,'adjusted','1613559576','1613559801',21),(5,142,'30','overtime',0,'adjusted','1613628746','1613628817',25),(6,142,'10','tvbr',0,'adjusted','1613629007','1613629022',26),(7,158,'30','over time',0,'adjusted','1613720997','1613721054',36),(8,158,'60','abc',0,'adjusted','1613721685','1613721698',38),(9,146,'10','overtime',0,'adjusted','1613725511','1613725525',42),(10,146,'20','over time',0,'adjusted','1613725947','1613725967',44),(11,143,'100','',0,'pending','1616580011',NULL,NULL),(12,145,'30','abc',0,'adjusted','1617349311','1617349478',62),(13,156,'30','over time',0,'pending','1619518136',NULL,NULL),(14,211,'10','over time',0,'pending','1619782116',NULL,NULL),(15,216,'1','df',0,'pending','1619786789',NULL,NULL),(16,156,'5','cv',1,'pending','1619936383',NULL,NULL),(17,143,'15','over time',0,'pending','1620014628',NULL,NULL),(18,269,'30','over time',0,'adjusted','1620111197','1620111612',69),(19,270,'34','bhbh',0,'pending','1620127851',NULL,NULL);

--
-- Table structure for table `demo_period`
--

CREATE TABLE `demo_period` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `startdate` varchar(50) DEFAULT NULL,
  `enddate` varchar(50) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `demo_period`
--


--
-- Table structure for table `demo_permission`
--

CREATE TABLE `demo_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `permission` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `demo_permission`
--

INSERT INTO `demo_permission` VALUES (82,'user'),(83,'marks'),(84,'subject'),(85,'salary'),(86,'fee'),(87,'Attendance'),(90,'Accounting'),(91,'abc'),(92,'xyz'),(95,'ffg'),(96,'yyu'),(97,'knknk'),(98,'joljol');

--
-- Table structure for table `demo_preveducation`
--

CREATE TABLE `demo_preveducation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `school_name` varchar(50) DEFAULT NULL,
  `class` varchar(50) DEFAULT NULL,
  `marks` varchar(50) DEFAULT NULL,
  `sid` int(11) DEFAULT NULL,
  `type` enum('admin','student') DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_preveducation`
--

INSERT INTO `demo_preveducation` VALUES (92,'oxford','2','56',115,'student'),(93,'abc','12','78',137,'admin'),(94,'abc','11','78',142,'admin'),(95,'abc','12','65',145,'admin'),(96,'abc','9','65',150,'student'),(97,'abc','1','68',730,'admin'),(98,'uj','2','78',730,'admin'),(99,'ioi','2','90',730,'admin'),(100,'demo','2','45',732,'admin'),(101,'demo','2','98',732,'admin'),(102,'demo','1','45',732,'admin'),(103,'demo','3','23',732,'admin'),(104,'demo','4','78',732,'admin'),(105,'demo','5','23',732,'admin'),(106,'demo','6','23',732,'admin'),(107,'demo','7','34',732,'admin'),(108,'demo','8','23',732,'admin'),(109,'demo','10','34',732,'admin'),(110,'demo','9','34',732,'admin'),(111,'demo','11','45',732,'admin'),(112,'demo','5','69',131,'admin'),(114,'demo','5','70',131,'student'),(115,'hj','9','45',747,'admin'),(116,'1','1','2',731,'admin'),(117,'demo','1','45',747,'student'),(118,'demo','12','65',751,'admin'),(119,'demo','10','65',750,'student'),(121,'demo','1','788876',753,'student'),(122,'demo','12','67',753,'student'),(123,'abc57','1','99',768,'admin'),(125,'demo','1','60',761,'admin'),(126,'demo','1','56',747,'admin'),(127,'abc','1','65',768,'admin'),(128,'abc','1','50',747,'student'),(129,'gf','1','44',756,'admin'),(130,'sc','1','4',768,'admin'),(133,'d','4','45',761,'admin'),(134,'demo','3','56',758,'admin'),(135,'demo','3','56',761,'admin'),(136,'45','1','45',770,'admin'),(137,'vidya nikaten','12','45',772,'admin'),(138,'demo','4','89',799,'student'),(139,'vidya nikaten','6','55',799,'student'),(140,'demp','12','55',799,'student'),(141,'grg','1','45',790,'student');

--
-- Table structure for table `demo_registration`
--

CREATE TABLE `demo_registration` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(50) DEFAULT NULL,
  `middle_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50) DEFAULT NULL,
  `dob` varchar(50) DEFAULT NULL,
  `gender` varchar(50) DEFAULT NULL,
  `mobile` varchar(50) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `father_name` varchar(50) DEFAULT NULL,
  `mother_name` varchar(50) DEFAULT NULL,
  `address1` text,
  `address2` text,
  `zip_code` varchar(50) DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `country` varchar(50) DEFAULT NULL,
  `delete_status` varchar(50) DEFAULT NULL,
  `key_email` varchar(50) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `registration_status` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `first_name` (`first_name`,`email`)
) ENGINE=InnoDB AUTO_INCREMENT=807 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_registration`
--

INSERT INTO `demo_registration` VALUES (111,'matti','Karttunen','Karttunen','2017-03-10','2','0444564987','Matti1@gmail.com','Domingues','Anabela','Berlin','Berlin','3445','0','0','10','0',NULL,'1','1'),(112,'	wilman ','Kala','Kala','2016-06-11','1','0634893733','Wilman@gmail.com','Mary 	','Saveley','	Paris','	Paris','156454','0','0','0','1',NULL,'1','1'),(113,'	karl ','Jablonsk','Jablonsk','2015-07-11','1','455454544','Karl@gmail.com','	Paul ','Henriot','Seattle','Seattle','556','0','0','182','0',NULL,'1','1'),(114,'	paula ',' Parente',' Parente','2017-07-07','2','0634893733','Paula@gmail.com','Wellington Importadora','Importadora','	Helsink','	Helsink','	123456','0','0','16','0',NULL,'1','1'),(115,'helen ','Bennet','Bennet','2018-07-13','2','0634893733','sadhna1@yatharthriti.com','Hanari ','Carne','Toulouse','Toulouse','123456','0','0','19','0',NULL,'1','1'),(116,'wolski','Paula ',' Parente','2015-02-19','2','02389-673','Wolski@gmail.com','Lúcia ','Carvalho','305 - 14th Ave. S. Suite 3B','305 - 14th Ave. S. Suite 3B','123456','0','0','134','1',NULL,'1','1'),(117,'wolski','Paula ',' Parente','2015-02-19','2','02389-673','Wolski@gmail.com','Lúcia ','Carvalho','305 - 14th Ave. S. Suite 3B','305 - 14th Ave. S. Suite 3B','123456','0','0','134','1',NULL,'1','1'),(118,'pirkko ','Koskitalo','Koskitalo','2016-06-11','1','78795465','Pirkko@gmail.com','Wartian',' Herkku','	59 rue de l\'Abbay','	59 rue de l\'Abbay','55656','0','0','60','0',NULL,'1','1'),(119,'die ','Wandernde','Kuh','2015-06-12','1','0634893733','Die@gmail.com',' Müller	','Rita ','fg','fg','fg','0','0','18','1',NULL,'1','1'),(120,'toms','bhgbhbh','njnjnjnj','2016-10-14','1','634893733','Toms@gmail.com','Karin','Josephs','Helsink','Helsink','123456','0','0','16','0',NULL,'1','1'),(121,'liu ','Wong','Wong','2014-05-07','1','455454544','Liu@gmail.com','Pascale Cartrain','Cartrain','55 Grizzly Peak Rd','55 Grizzly Peak Rd','556','0','0','182','0',NULL,'1','1'),(122,'jytte ',' Petersen',' Petersen','2015-06-03','1','634893733','Jytte@gmail.com','Simons','bistro','Helsink','Helsink','123456','0','0','11','0',NULL,'1','1'),(123,'hari kumar',' Kumar','Hari ','2014-10-07','1','0634893733','Hari@gmail.com','Erling ',' Skakkes','90 Wadhurst Rd','90 Wadhurst Rd','121564','0','0','59','0',NULL,'1','1'),(124,'jonas ','Bergulfsen','Bergulfsen','2012-12-26','1','12656744','Jonas@gmail.com','Santé ','Gourmet','Erling Skakkes gate 78','Erling Skakkes gate 78','4546','0','0','18','0',NULL,'1','1'),(125,'victoria','demo','demo','2008-04-23','2','45465665','Victoria1@gmail.com','lourance','Lebihans','C/ Araquil, 67','C/ Araquil, 67','4656','1094','4740','160','0',NULL,'1','1'),(126,'hanna moos','Moos','Moos','2005-05-18','2','dfd','Hanna@gmail.com','Antonio ',' Moreno','Mataderos 2314','Mataderos 2314','6+5+','0','0','112','0',NULL,'1','1'),(127,'yang ','Wang','Wang','2004-07-28','1','6878566','Yang@gmail.com','Lincoln','Elizabeth ','Sierras de Granada 9993','Sierras de Granada 9993','1234567','0','0','112','0',NULL,'1','1'),(128,'victoria ','Ashworth','Ashworth','2000-10-05','2','634893733','Victoria@gmail.com','Ashworth Fauntleroy ','Circica','Helsink','Helsink','123456','0','0','16','0',NULL,'1','1'),(129,'janine','Labrune','Labrune','2000-08-13','1','634893733','Janine@gmail.com','Du monde ','entier','67, rue des Cinquante Otages	','67, rue des Cinquante Otages	','123456','0','0','60','0',NULL,'1','1'),(130,'aria ','cruz','cruz','2000-05-09','2','455454544','Aria@gmail.com','Familia ',' Arquibaldo','Seattle	Rua Orós, 92','Seattle	Rua Orós, 92','556d','0','0','15','1',NULL,'1','1'),(131,'peter franken',' Franken',' Franken','2000-03-16','1','80455454544','Peter@gmail.com','Paolo ','Accorti','Seattle	Rua Orós, 92	Via Monte Bianco 34','Seattle	Rua Orós, 92	Via Monte Bianco 34','100012','0','0','82','0',NULL,'1','1'),(132,'jose ',' Pedro ','  Freyre','1999-01-15','1','634893733','Jose@gmail.com','Godos Típica','Cocina ','HelsinkC/ Romero, 33','HelsinkC/ Romero, 33','123456','0','0','160','0',NULL,'1','1'),(133,'yoshi ',' Latimer',' Latimer','2000-06-09','2','65879655','Yoshi@gmail.com','Patricia ','McKenna','8 Johnstown Road','8 Johnstown Road','216645','0','0','80','0',NULL,'1','1'),(134,'philip','	Philip Cramer',' Cramer','2000-12-15','1','0634893733','Philipi@gmail.com','Helen ','Bennett','Garden House Crowther Way','Garden House Crowther Way','12322','0','0','182','0',NULL,'1','1'),(135,'daniel ',' Tonini',' Tonini','2000-04-11','1','678734874','Daniel@gmail.com','Daniel ','Tonini','67, avenue de l\'Europe','67, avenue de l\'Europe','123456','0','0','60','0',NULL,'1','1'),(136,'alexander ','Feuer','Feuer','2000-05-26','1','126646','Alexander@gmail.com','Crowther','Simon ','South House 300 Queensbridg','South House 300 Queensbridg','123456','0','0','182','0',NULL,'1','1'),(137,'georg','Pipps','Pipps','2000-09-07','1','455454544','Georg@gmail.com','Bernardo ','Batista','Rua da Panificadora, 12','Rua da Panificadora, 12eattle','12565','0','0','23','0',NULL,'1','1'),(138,' sammy','Parente','Parente','1997-06-04','1','634893733','shamshad@yatharthriti.com','ranny','somya','Helsink','Helsink','123456','0','0','16','0',NULL,'1','1'),(139,'rash','marry','Parente','1995-08-11','2','634893733','rashmi@yatharthriti.com','robby','nancy','Helsink','Helsink','123456','0','0','16','1',NULL,'1','1'),(141,'sandeep','kumar','demo','2021-02-18','1','9542512558','naresh@yatharthriti.com','father','mother','demo_AD1','demo_AD2','121001','2','2','12','0',NULL,'1','1'),(142,'sandeep','sharma','sharma','2021-02-15','2','9145214420','sandeepkumar@yatharthriti.com','father','mother','tets_ad1','test_ad2','121005','3','3','14','1',NULL,'1','1'),(144,'diva','robert','robert','2021-02-18','2','9542512558','diva@yatharthriti.com','peter','peta','demo_AD1','demo_AD2','121001','2','2','12','0',NULL,'1','1'),(145,'divya','demo','luice','2021-02-15','2','9145214420','divya@yatharthriti.com','richard','maria','tets_ad1','test_ad2','121005','3','3','14','0',NULL,'1','1'),(146,'rony','Parente','Parente','1999-06-22','1','634893733','rony@gmail.com','abc','abc','Helsink','Helsink','123456','0','0','16','0',NULL,'1','1'),(147,'rocky','Parente','Parente','2012-06-23','1','634893733','roni@gmail.com','bn','nm','Helsink','Helsink','123456','0','0','16','0',NULL,'1','1'),(148,'diva','robert','robert','2021-02-18','2','9542512558','diva@yatharthriti.com','demo_father','demo_mother','demo_AD1','demo_AD2','121001','2','2','12','0',NULL,'1','1'),(149,'sofi','luise','luice','2021-02-15','2','9145214420','sofi@yatharthriti.com','test_father','test_mother','tets_ad1','test_ad2','121005','3','3','14','0',NULL,'1','1'),(150,'tom','Karttunen','Karttunen','2009-07-04','1','0444564987','sadhna70651@gmail.com','juhn','teila','Berlin','Berlin','12209','0','0','0','0',NULL,'1','1'),(527,'avdhut','DEMO','SANGALE','2021-01-01','1','123456789','demo@demo2.com','ABC','XYZ','DEMO 1','DEMO 2','421301','14','0','76','0',NULL,'1','1'),(528,'CHINMAY','DEMO','WAVHAL','2021-01-01','MALE','123456789','demo@demo.com_3','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(529,'VARAD','DEMO','SHIMPI','2021-01-01','MALE','123456789','demo@demo.com_4','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(530,'RAKSHIT','DEMO','THAKUR','2021-01-01','MALE','123456789','demo@demo.com_5','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(531,'VIJAY','DEMO','WAVU','2021-01-01','MALE','123456789','demo@demo.com_6','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(532,'SUSHIL','DEMO','SHANKPAL','2021-01-01','MALE','123456789','demo@demo.com_7','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(533,'HETAVI','DEMO','HETAVI BHOER','2021-01-01','FEMALE','123456789','demo@demo.com_8','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(534,'YASHITA','DEMO','AATALKAR','2021-01-01','FEMALE','123456789','demo@demo.com_9','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(535,'TRISHA','DEMO','CHAVHAN','2021-01-01','FEMALE','123456789','demo@demo.com_10','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(536,'PRAJKTA','DEMO','DHAWALE','2021-01-01','FEMALE','123456789','demo@demo.com_11','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(537,'DAMINI','DEMO','MORE','2021-01-01','FEMALE','123456789','demo@demo.com_12','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(538,'SARVADNYA','DEMO','SAWANT','2021-01-01','FEMALE','123456789','demo@demo.com_13','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(539,'RUCHI','DEMO','INAMDAR','2021-01-01','FEMALE','123456789','demo@demo.com_14','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(540,'DEVYANI','DEMO','GAIKWAD','2021-01-01','FEMALE','123456789','demo@demo.com_15','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(541,'SHRIYA','DEMO','PITALE','2021-01-01','FEMALE','123456789','demo@demo.com_16','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(542,'RISHA','DEMO','THAKKAR','2021-01-01','FEMALE','123456789','demo@demo.com_17','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(543,'BHAGYASHREE','DEMO','SARAGE','2021-01-01','FEMALE','123456789','demo@demo.com_18','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(544,'PRANJALI','DEMO','HANKARE','2021-01-01','FEMALE','123456789','demo@demo.com_19','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(545,'VIDHI','DEMO','NIKUMBH','2021-01-01','FEMALE','123456789','demo@demo.com_20','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(546,'GIRIJA','DEMO','LADAVA','2021-01-01','FEMALE','123456789','demo@demo.com_21','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(547,'HARSHAVI','DEMO','JAIN','2021-01-01','FEMALE','123456789','demo@demo.com_22','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(548,'VAIDEHI','DEMO','GHORPADE','2021-01-01','FEMALE','123456789','demo@demo.com_23','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(549,'SHRAVANI','DEMO','KULKARNI','2021-01-01','FEMALE','123456789','demo@demo.com_24','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(550,'SUKHADA','DEMO','VEDPATHAK','2021-01-01','FEMALE','123456789','demo@demo.com_25','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(551,'SAMIKSHA','DEMO','WAGALE','2021-01-01','FEMALE','123456789','demo@demo.com_26','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(552,'TANVI','DEMO','SATOSE','2021-01-01','FEMALE','123456789','demo@demo.com_27','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(553,'AARYA','DEMO','PHADNIS','2021-01-01','FEMALE','123456789','demo@demo.com_28','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(554,'AACHAL','DEMO','PATIL','2021-01-01','FEMALE','123456789','demo@demo.com_29','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(555,'SHREYA','DEMO','PATIL','2021-01-01','FEMALE','123456789','demo@demo.com_30','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(556,'SWARA','DEMO','PATIL','2021-01-01','FEMALE','123456789','demo@demo.com_31','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(557,'PRACHITI','DEMO','PATIL','2021-01-01','FEMALE','123456789','demo@demo.com_32','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(558,'JANHAVI','DEMO','SARAGE','2021-01-01','FEMALE','123456789','demo@demo.com_33','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(559,'AAYUSHI','DEMO','KARNIK','2021-01-01','FEMALE','123456789','demo@demo.com_34','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(560,'AARAVA','DEMO','GEDAM','2021-01-01','FEMALE','123456789','demo@demo.com_35','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(561,'SONALI','DEMO','GOKHALE','2021-01-01','FEMALE','123456789','demo@demo.com_36','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(562,'PURVASHRI','DEMO','SARAGE','2021-01-01','FEMALE','123456789','demo@demo.com_37','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(563,'ANUSHKA','DEMO','PILLE','2021-01-01','FEMALE','123456789','demo@demo.com_38','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(564,'JANHAVI','DEMO','SONAVANE','2021-01-01','FEMALE','123456789','demo@demo.com_39','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(565,'SHARAYU','DEMO','VYAVHARE','2021-01-01','FEMALE','123456789','demo@demo.com_40','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(566,'SUPRIYA','DEMO','PALAVE','2021-01-01','FEMALE','123456789','demo@demo.com_41','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(567,'MRUNAL','DEMO','JOSHI','2021-01-01','FEMALE','123456789','demo@demo.com_42','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(568,'ACHALA','DEMO','SHENOY','2021-01-01','FEMALE','123456789','demo@demo.com_43','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(569,'RUCHI','DEMO','DEVKARE','2021-01-01','FEMALE','123456789','demo@demo.com_44','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(570,'LEHER','DEMO','THAKKAR','2021-01-01','FEMALE','123456789','demo@demo.com_45','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(571,'SAYALI','DEMO','AAVHAD','2021-01-01','FEMALE','123456789','demo@demo.com_46','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(572,'SANCHITA','DEMO','CHAUDHARI','2021-01-01','FEMALE','123456789','demo@demo.com_47','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(573,'RADHIKA','DEMO','JOSHI','2021-01-01','FEMALE','123456789','demo@demo.com_48','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(574,'PRAVESHA','DEMO','ACHAREKAR','2021-01-01','FEMALE','123456789','demo@demo.com_49','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(575,'JANHAVI','DEMO','PATEL','2021-01-01','FEMALE','123456789','demo@demo.com_50','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(576,'MANISHA','DEMO','SANGALE','2021-01-01','FEMALE','123456789','demo@demo.com_51','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(577,'MEGHANA','DEMO','SHINDE','2021-01-01','FEMALE','123456789','demo@demo.com_52','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(578,'ANANYA','DEMO','BAGADE','2021-01-01','FEMALE','123456789','demo@demo.com_53','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(579,'SHALMALI','DEMO','PATIL','2021-01-01','FEMALE','123456789','demo@demo.com_54','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(580,'SAEE','DEMO','DAREKAR','2021-01-01','FEMALE','123456789','demo@demo.com_55','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(581,'SAMRUDDHI','DEMO','BHISE','2021-01-01','FEMALE','123456789','demo@demo.com_56','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(582,'KOMAL','DEMO','DIVEKAR','2021-01-01','FEMALE','123456789','demo@demo.com_57','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(583,'RENUKA','DEMO','GHAISAS','2021-01-01','FEMALE','123456789','demo@demo.com_58','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(584,'SWARALI','DEMO','DESHPANDE','2021-01-01','FEMALE','123456789','demo@demo.com_59','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(585,'MOKSHADA','DEMO','BHINGARDE','2021-01-01','FEMALE','123456789','demo@demo.com_60','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(586,'GARVI','DEMO','CHAUHAN','2021-01-01','FEMALE','123456789','demo@demo.com_61','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(587,'DIPTI','DEMO','PATRE','2021-01-01','FEMALE','123456789','demo@demo.com_62','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(588,'ADITI','DEMO','JAHAGIRDAR','2021-01-01','FEMALE','123456789','demo@demo.com_63','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(589,'NEHA','DEMO','WAGH','2021-01-01','FEMALE','123456789','demo@demo.com_64','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(590,'PRASAD','DEMO','PAWAR','2021-01-01','MALE','123456789','demo@demo.com_65','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(591,'AARYAN','DEMO','SHETTI','2021-01-01','MALE','123456789','demo@demo.com_66','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(592,'SATISH','DEMO','BHAVE','2021-01-01','MALE','123456789','demo@demo.com_67','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(593,'SRUSHTI','DEMO','GUJRATHI','2021-01-01','FEMALE','123456789','demo@demo.com_68','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(594,'bhakti','DEMO','KOLTE','2021-01-01','1','123456789','demo@123demo.com','ABC','XYZ','DEMO 1','DEMO 2','421301','14','0','76','0',NULL,'1','1'),(595,'AISHWARYA','DEMO','JOGALEKAR','2021-01-01','FEMALE','123456789','demo@demo.com_70','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(596,'PRAVEENA','DEMO','GAIKWAD','2021-01-01','FEMALE','123456789','demo@demo.com_71','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(597,'SHUBHANGI','DEMO','SINNARKAR','2021-01-01','FEMALE','123456789','demo@demo.com_72','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(598,'ASMITA','DEMO','LAD','2021-01-01','FEMALE','123456789','demo@demo.com_73','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(599,'AAROHI','DEMO','BARVE','2021-01-01','FEMALE','123456789','demo@demo.com_74','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(600,'PALLAVI','DEMO','OVALEKAR/JOSHI','2021-01-01','FEMALE','123456789','demo@demo.com_75','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(601,'SAI','DEMO','DHAMAPURKAR','2021-01-01','FEMALE','123456789','demo@demo.com_76','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(602,'ISHITA','DEMO','PATHAK','2021-01-01','FEMALE','123456789','demo@demo.com_77','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(603,'RUDRA','DEMO','SARDAR','2021-01-01','MALE','123456789','demo@demo.com_78','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(604,'PRIYANKA','DEMO','PATIL','2021-01-01','FEMALE','123456789','demo@demo.com_79','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(605,'CHAITRALI','DEMO','GANORKAR','2021-01-01','FEMALE','123456789','demo@demo.com_80','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(606,'RAKHI','DEMO','DATAR','2021-01-01','FEMALE','123456789','demo@demo.com_81','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(607,'TEJASWINI','DEMO','JADHAV','2021-01-01','FEMALE','123456789','demo@demo.com_82','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(608,'ROSHANI','DEMO','PATRA','2021-01-01','FEMALE','123456789','demo@demo.com_83','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(609,'YASHASHREE','DEMO','KARANDIKAR','2021-01-01','FEMALE','123456789','demo@demo.com_84','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(610,'PADMA','DEMO','GEDAM','2021-01-01','FEMALE','123456789','demo@demo.com_85','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(611,'SARIKA','DEMO','SONAWALE','2021-01-01','FEMALE','123456789','demo@demo.com_86','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(612,'SHILPA','DEMO','KHANGAOKAR','2021-01-01','FEMALE','123456789','demo@demo.com_87','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(613,'SHREYA','DEMO','DESHMUKH','2021-01-01','FEMALE','123456789','demo@demo.com_88','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(614,'AARATI','DEMO','PHAD','2021-01-01','FEMALE','123456789','demo@demo.com_89','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(615,'PRABHATKUMAR','DEMO','SAHU','2021-01-01','FEMALE','123456789','demo@demo.com_90','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(616,'SAMRUDDHI','DEMO','PALNITKAR','2021-01-01','FEMALE','123456789','demo@demo.com_91','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(617,'REKHA','DEMO','PAHADI','2021-01-01','FEMALE','123456789','demo@demo.com_92','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(618,'ROHINI','DEMO','BIDWAI','2021-01-01','FEMALE','123456789','demo@demo.com_93','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(619,'VASUSHREE','DEMO','KINIKAR','2021-01-01','FEMALE','123456789','demo@demo.com_94','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(620,'DIKSHA','DEMO','MARATHE','2021-01-01','FEMALE','123456789','demo@demo.com_95','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(621,'SANIKA','DEMO','JOSHI','2021-01-01','FEMALE','123456789','demo@demo.com_96','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(622,'APURVA','DEMO','CHITALE','2021-01-01','FEMALE','123456789','demo@demo.com_97','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(623,'CHETNA','DEMO','SONAR','2021-01-01','FEMALE','123456789','demo@demo.com_98','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(624,'JAYMALA','DEMO','WAGH','2021-01-01','FEMALE','123456789','demo@demo.com_99','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(625,'DIPTI','DEMO','BHIDE','2021-01-01','FEMALE','123456789','demo@demo.com_100','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(626,'SWAPNALI','DEMO','SUKHATME','2021-01-01','FEMALE','123456789','demo@demo.com_101','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(627,'ANKITA','DEMO','KARNIK','2021-01-01','FEMALE','123456789','demo@demo.com_102','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(628,'HITESHI','DEMO','JAIN','2021-01-01','FEMALE','123456789','demo@demo.com_103','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(629,'HARDIKA','DEMO','JAIN','2021-01-01','FEMALE','123456789','demo@demo.com_104','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(630,'SONALI','DEMO','LOKHANDE','2021-01-01','FEMALE','123456789','demo@demo.com_105','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(631,'TEJASHRI','DEMO','TOKIKAR','2021-01-01','FEMALE','123456789','demo@demo.com_106','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(632,'SHREYA','DEMO','MORE','2021-01-01','FEMALE','123456789','demo@demo.com_107','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(633,'NAYONIKA','DEMO','SHAH','2021-01-01','FEMALE','123456789','demo@demo.com_108','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(634,'ANAGHA','DEMO','RAJHANS','2021-01-01','FEMALE','123456789','demo@demo.com_109','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(635,'DEVASHREE','DEMO','TOFKHANE','2021-01-01','FEMALE','123456789','demo@demo.com_110','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(636,'ADITI','DEMO','BHALEKAR','2021-01-01','FEMALE','123456789','demo@demo.com_111','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(637,'SNEHA','DEMO','SONAWANE','2021-01-01','FEMALE','123456789','demo@demo.com_112','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(638,'ANAGHA','DEMO','AVASARMAL','2021-01-01','FEMALE','123456789','demo@demo.com_113','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(639,'SHRINIDHI','DEMO','VAISHNAV','2021-01-01','FEMALE','123456789','demo@demo.com_114','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(640,'KASTURI','DEMO','DESAI','2021-01-01','FEMALE','123456789','demo@demo.com_115','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(641,'MANASI','DEMO','MUKADAM','2021-01-01','FEMALE','123456789','demo@demo.com_116','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(642,'MANASI','DEMO','MUKADAM','2021-01-01','FEMALE','123456789','demo@demo.com_117','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(643,'NAMITA','DEMO','BHAVE','2021-01-01','FEMALE','123456789','demo@demo.com_118','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(644,'KASTURI','DEMO','KULKARNI','2021-01-01','FEMALE','123456789','demo@demo.com_119','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(645,'RIDDHI','DEMO','LOHAR','2021-01-01','FEMALE','123456789','demo@demo.com_120','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(646,'PRATIKSHA','DEMO','GAWANDE','2021-01-01','FEMALE','123456789','demo@demo.com_121','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(647,'KASTURI','DEMO','NENE','2021-01-01','FEMALE','123456789','demo@demo.com_122','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(648,'SRUSHTI','DEMO','NANDURKAR','2021-01-01','FEMALE','123456789','demo@demo.com_123','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(649,'PRATIKSHA','DEMO','GAIKWAD','2021-01-01','FEMALE','123456789','demo@demo.com_124','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(650,'GAURI','DEMO','DEV','2021-01-01','FEMALE','123456789','demo@demo.com_125','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(651,'GAYATRI','DEMO','DEV','2021-01-01','FEMALE','123456789','demo@demo.com_126','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(652,'BHAIRAVI','DEMO','BHISE','2021-01-01','FEMALE','123456789','demo@demo.com_127','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(653,'SHRADDHA','DEMO','GAWADE','2021-01-01','FEMALE','123456789','demo@demo.com_128','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(654,'SHRAVANI','DEMO','VAISHNAV','2021-01-01','FEMALE','123456789','demo@demo.com_129','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(655,'APURVA','DEMO','VAZE','2021-01-01','FEMALE','123456789','demo@demo.com_130','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(656,'MADHURI','DEMO','AATHAVALE','2021-01-01','FEMALE','123456789','demo@demo.com_131','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(657,'PRATAP','DEMO','MORE','2021-01-01','MALE','123456789','demo@demo.com_132','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(658,'ARUN','DEMO','KARVE','2021-01-01','MALE','123456789','demo@demo.com_133','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(659,'ANUJA','DEMO','PETHE','2021-01-01','FEMALE','123456789','demo@demo.com_134','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(660,'YASHASHREE','DEMO','KARANDIKAR','2021-01-01','FEMALE','123456789','demo@demo.com_135','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(661,'MILIND','DEMO','BACHCHAV','2021-01-01','MALE','123456789','demo@demo.com_136','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(662,'HRUSHIKESH','DEMO','JADHAV','2021-01-01','MALE','123456789','demo@demo.com_137','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(663,'SHIV','DEMO','MANDLIK','2021-01-01','MALE','123456789','demo@demo.com_138','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(664,'OVI','DEMO','PANCHAL','2021-01-01','FEMALE','123456789','demo@demo.com_139','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(665,'RAGHUNATH','DEMO','KOR','2021-01-01','MALE','123456789','demo@demo.com_140','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(666,'VIHANG','DEMO','BHAVE','2021-01-01','MALE','123456789','demo@demo.com_141','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(667,'AARAV','DEMO','BARHATE','2021-01-01','MALE','123456789','demo@demo.com_142','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(668,'TANMAY','DEMO','DAREKAR','2021-01-01','MALE','123456789','demo@demo.com_143','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(669,'VIJAY','DEMO','KOLHE','2021-01-01','MALE','123456789','demo@demo.com_144','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(670,'HRUSHIKESH','DEMO','THAKARE','2021-01-01','MALE','123456789','demo@demo.com_145','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(671,'HIREN','DEMO','GODE','2021-01-01','MALE','123456789','demo@demo.com_146','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(672,'VARAD','DEMO','BRAHMA','2021-01-01','MALE','123456789','demo@demo.com_147','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(673,'ATHARV','DEMO','NIKUMBH','2021-01-01','MALE','123456789','demo@demo.com_148','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(674,'SAURABH','DEMO','WALANJ','2021-01-01','MALE','123456789','demo@demo.com_149','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(675,'RUDRA','DEMO','BADAVE','2021-01-01','MALE','123456789','demo@demo.com_150','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(676,'SHAUNAK','DEMO','LAWATE','2021-01-01','MALE','123456789','demo@demo.com_151','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(677,'MALHAR','DEMO','KULKARNI','2021-01-01','MALE','123456789','demo@demo.com_152','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(678,'RUTVI','DEMO','SATVIK','2021-01-01','MALE','123456789','demo@demo.com_153','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(679,'SARVANG','DEMO','BHARAMBE','2021-01-01','MALE','123456789','demo@demo.com_154','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(680,'ADITI','DEMO','BARVE','2021-01-01','FEMALE','123456789','demo@demo.com_155','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(681,'KASTURI','DEMO','MHATRE','2021-01-01','FEMALE','123456789','demo@demo.com_156','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(682,'SAKSHI','DEMO','WALIMBE','2021-01-01','FEMALE','123456789','demo@demo.com_157','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(683,'AARYA','DEMO','DESHPANDE','2021-01-01','FEMALE','123456789','demo@demo.com_158','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(684,'PARINITA','DEMO','PAWAR','2021-01-01','FEMALE','123456789','demo@demo.com_159','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(685,'JUI','DEMO','SANE','2021-01-01','FEMALE','123456789','demo@demo.com_160','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(686,'NETRA','DEMO','SATHE','2021-01-01','FEMALE','123456789','demo@demo.com_161','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(687,'PRIYANKA','DEMO','CHIKSHETTI','2021-01-01','FEMALE','123456789','demo@demo.com_162','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(688,'AVANTIKA','DEMO','MARATHE','2021-01-01','FEMALE','123456789','demo@demo.com_163','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(689,'HARSHITA','DEMO','AAMBEKAR','2021-01-01','FEMALE','123456789','demo@demo.com_164','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(690,'VIDISHA','DEMO','CHAUDHARI','2021-01-01','FEMALE','123456789','demo@demo.com_165','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(691,'SHRAVANI','DEMO','KULKARNI','2021-01-01','FEMALE','123456789','demo@demo.com_166','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(692,'SIYA','DEMO','DALAL','2021-01-01','FEMALE','123456789','demo@demo.com_167','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(693,'NUPUR','DEMO','BHIDE','2021-01-01','FEMALE','123456789','demo@demo.com_168','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(694,'HETAL','DEMO','ZALAR','2021-01-01','FEMALE','123456789','demo@demo.com_169','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(695,'PRITI','DEMO','YASHWANTE','2021-01-01','FEMALE','123456789','demo@demo.com_170','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(696,'TANVI','DEMO','DESHPANDE','2021-01-01','FEMALE','123456789','demo@demo.com_171','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(697,'MRUDULA','DEMO','BACHCHHAV','2021-01-01','FEMALE','123456789','demo@demo.com_172','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(698,'VISHRAM','DEMO','KOLHE','2021-01-01','MALE','123456789','demo@demo.com_173','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','1',NULL,'1','1'),(699,'RITI','DEMO','ZALAR','2021-01-01','FEMALE','123456789','demo@demo.com_174','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(700,'CHARUL','DEMO','DAFADE','2021-01-01','FEMALE','123456789','demo@demo.com_175','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(701,'PRATHA','DEMO','CHAUDHARI','2021-01-01','FEMALE','123456789','demo@demo.com_176','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(702,'MEGH','DEMO','DANDEKAR','2021-01-01','MALE','123456789','demo@demo.com_177','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(703,'ISHAN','DEMO','BHAT','2021-01-01','MALE','123456789','demo@demo.com_178','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(704,'MEGHNAD','DEMO','KAMBALE','2021-01-01','MALE','123456789','demo@demo.com_179','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(705,'CHAITANYA','DEMO','VAZE','2021-01-01','MALE','123456789','demo@demo.com_180','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(706,'ATHARV','DEMO','DAMALE','2021-01-01','MALE','123456789','demo@demo.com_181','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(707,'MALHAR','DEMO','KULKARNI','2021-01-01','MALE','123456789','demo@demo.com_182','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(708,'RUGVED','DEMO','RODE','2021-01-01','MALE','123456789','demo@demo.com_183','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(709,'TEJAS','DEMO','KALKAR','2021-01-01','MALE','123456789','demo@demo.com_184','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(710,'MAITREY','DEMO','BHARAMBE','2021-01-01','MALE','123456789','demo@demo.com_185','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(711,'GANDHARV','DEMO','CHUMBALE','2021-01-01','MALE','123456789','demo@demo.com_186','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(712,'AARYVEER','DEMO','SALGAVKAR','2021-01-01','MALE','123456789','demo@demo.com_187','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(713,'ATHARV','DEMO','BUDHKAR','2021-01-01','MALE','123456789','demo@demo.com_188','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(714,'SAKAR','DEMO','DESAI','2021-01-01','MALE','123456789','demo@demo.com_189','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(715,'HANSIN','DEMO','SAKALYE','2021-01-01','MALE','123456789','demo@demo.com_190','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(716,'SHYAM','DEMO','DESHMUKH','2021-01-01','MALE','123456789','demo@demo.com_191','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(717,'VARAD','DEMO','PATHAK','2021-01-01','MALE','123456789','demo@demo.com_192','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(718,'HERAMB','DEMO','RAJE','2021-01-01','MALE','123456789','demo@demo.com_193','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(719,'SMITESH','DEMO','MAHAJAN','2021-01-01','MALE','123456789','demo@demo.com_194','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(720,'AADITYA','DEMO','PAITHANKAR','2021-01-01','MALE','123456789','demo@demo.com_195','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(721,'athang','DEMO','PHANASE','2021-01-01','1','123456789','demo@demo.com','ABC','XYZ','DEMO 1','DEMO 2','421301','14','0','76','0',NULL,'1','1'),(722,'DEVESH','DEMO','PARAB','2021-01-01','MALE','123456789','demo@demo.com_197','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(723,'SUMEDH','DEMO','BHATAVADEKAR','2021-01-01','MALE','123456789','demo@demo.com_198','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(724,'AARUSH','DEMO','BAGAL','2021-01-01','MALE','123456789','demo@demo.com_199','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(725,'CHAITANYA','DEMO','JOSHI','2021-01-01','MALE','123456789','demo@demo.com_200','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(726,'NAHUSH','DEMO','AGRAWAL','2021-01-01','MALE','123456789','demo@demo.com_201','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(727,'RUDRA','DEMO','PARDESHI','2021-01-01','MALE','123456789','demo@demo.com_202','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(728,'SAUMITRA','DEMO','BIVALKAR','2021-01-01','MALE','123456789','demo@demo.com_203','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(729,'UMESH','DEMO','NIMBHORKAR','2021-01-01','MALE','123456789','demo@demo.com_204','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(730,'KRISHNA','DEMO','KARADA','2021-01-01','MALE','123456789','demo@demo.com_205','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(731,'dhruv','cc','cv','2019-06-12','1','4545565','dhruvk333@gmail.com','dcd','df','fdf','df','46','0','0','0','0',NULL,'1','1'),(732,'ABHI','DEMO','SANGALE','2021-01-01','1','123456789','demo@demo.com_300','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(733,'abhi','kumar','yadav','2021-03-03','1','365546544','demo@yatharthriti.com','demo','demo','demo','demo','555','748','3523','100','0',NULL,'1','1'),(734,'jacky','DEMO','SANGALE','2021-01-01','1','123456789','sv419459@gmail.com','ABC','XYZ','DEMO 1','DEMO 2','421301','14','0','76','0',NULL,'1','1'),(735,'robby','DEMO','SANGALE','2021-01-01','1','123456789','demo_1@demo.com','ABC','XYZ','DEMO 1','DEMO 2','421301','14','0','76','0',NULL,'1','1'),(736,'alla','DEMO','SANGALE','2021-01-01','1','123456789','demo_2@demo.com','ABC','XYZ','DEMO 1','DEMO 2','421301','0','0','0','0',NULL,'1','1'),(737,'roni','DEMO','SANGALE','2021-01-01','2','123456789','demo_3@demo.com','ABC','XYZ','DEMO 1','DEMO 2','421301','Andhra Pradesh','New Delhi','Afghanistan','0',NULL,'1','1'),(738,'riya','DEMO','SANGALE','2021-01-01','2','123456789','demo_4@demo.com','ABC','XYZ','DEMO 1','DEMO 2','421301','0','0','0','0',NULL,'1','1'),(739,'mansee','DEMO','Sulodiya','2021-01-01','2','123456789','mansee1@gmail.com','ABC','XYZ','DEMO 1','DEMO 2','421301','0','0','0','0',NULL,'1','1'),(740,'shivani','DEMO','Sulodiya','2021-01-01','2','123456789','shivani@gmail.com','ABC','XYZ','DEMO 1','DEMO 2','421301','abc','abc','abc','0',NULL,'1','1'),(741,'oliva','abc','abc','2014-06-19','2','634893733','Olivia@gmail.com','Harry','Ava','Helsink','Helsink','123456','0','0','16','0',NULL,'1','1'),(742,'ava','demo','demo','2007-06-06','2','634893733','Ava@gmail.com','Clara','Bella','Helsink','Helsink','123456','291','1791','16','0',NULL,'1','1'),(743,'dora','demo','sharma','2009-06-20','1','0634893733','Dora@gmail.com','Dandy','Elena','fg','fg','fg','0','0','0','0',NULL,'1','1'),(744,'ceila','demo','Cruz','2021-03-04','2','80455454544','Ceila@gmail.com','Charlotte','Clara','Seattle	Rua Orós, 92','Seattle	Rua Orós, 92','556d','0','0','15','0',NULL,'1','1'),(745,'fanny','demo','demo','2010-06-17','1','634893733','Fanny@gmail.com','demo','demo','Helsink','Helsink','123456','0','0','16','0',NULL,'1','1'),(746,'shivani','DEMO','Sulodiya','2021-01-01','2','123456789','shivi@gmail.com','ABC','XYZ','DEMO 1','DEMO 2','421301','0','0','0','0',NULL,'1','1'),(747,'robby','demo','demo','2008-02-05','1','23433','robby@gmail.com','demo','demo','HelsinkC/ Romero, 33','HelsinkC/ Romero, 33','234sd23','0','0','16','0',NULL,'1','1'),(748,'emily','desoza','desoza','2004-02-13','2','81309400','sadhna7065@gmail.com','olive','oliviya','1347,sanjay Enclave','1347,sanjay Enclave','121005','7','0','183','0',NULL,'1','1'),(749,'eva','demo','demo','1999-06-09','2','0634893733','kuldeepbanga@gmail.com','richard','demo','demo','demo','1234','0','0','0','0',NULL,'1','1'),(750,'melina','demo','demo','2021-02-26','2','634893733','melina@gmail.com','demo','demo','Helsink','Helsink','123456','0','0','16','0',NULL,'1','1'),(751,'mya','demo','demo','1998-10-17','2','634893733','mya@gmail.com','demo','demo','Helsink','Helsink','123456','0','0','16','0',NULL,'1','1'),(752,'nova','demo','sharma','1997-01-08','1','0634893733','nova@gmail.com','demo','demo','fg','fg','fg','0','0','0','0',NULL,'1','1'),(753,'ameliya','demo','demo','2005-03-11','2','634893733','Ameliya@gmail.com','demo','demo','Helsink','Helsink','123456','0','0','16','0',NULL,'1','1'),(754,'chitra','demo','demo','2009-03-06','2','634893733','chitra@gmail.com','demo','demo','Helsink','Helsink','123456','0','0','16','0',NULL,'1','1'),(755,'shivi','demo','demo','1998-06-04','2','634893733','divyamisra25@gmail.com','demo','demo','Helsink','Helsink','123456','0','0','16','0',NULL,'1','1'),(756,'riya','DEMO','SANGALE','2021-01-01','2','123456789','gfgh',NULL,'XYZ','DEMO 1','DEMO 2','421301','Andhra Pradesh','New Delhi','Afghanistan','0',NULL,'1','1'),(757,'riya','DEMO','SANGALE','2021-01-01','2','123456789','ddf','demo_sd','XYZ_dsd','DEMO 1','DEMO 2','421301','Andhra Pradesh','New Delhi','Afghanistan','1',NULL,'1','1'),(758,'asd','asd','asd','2021-04-08','2','123131','sadhna1@yatharthriti.coma','asdfsaf','sdfdas','faridabadgtr rrgt5','newtghtdhrtd faridabad','121005ds','0','2','77','0',NULL,'1','1'),(759,'riya','DEMO','SANGALE','2021-01-01','2','123456789','sa@gmail.com','demo','XYZ','DEMO 1','DEMO 2','421301','0','0','0','1',NULL,'1','1'),(760,'riya','DEMO','SANGALE','2021-01-01','2','123456789','safg@hmail.com','demo','XY','DEMO 1','DEMO 2','421301','0','0','0','1',NULL,'1','1'),(761,'albert','Parente','Parente','2009-06-09','1','634893733','albert@gmail.com','richard','rincy','Helsink','Helsink','123456','292','1792','16','0',NULL,'1','1'),(762,NULL,'DEMO','SANGALE','2021-01-01','2','123456789',NULL,'demo_sd','XYZ_dsd','DEMO 1','DEMO 2','421301','Andhra Pradesh','New Delhi','Afghanistan','1',NULL,'1','1'),(763,NULL,NULL,NULL,'2021-01-01','2','123456789','ddd','demo_sd','XYZ_dsd','DEMO 1','DEMO 2','421301','Andhra Pradesh','New Delhi','Afghanistan','1',NULL,'1','1'),(764,NULL,NULL,NULL,'2021-01-01','2','123456789','sd','demo_sd','XYZ_dsd','DEMO 1','DEMO 2','421301',NULL,NULL,NULL,'1',NULL,'1','1'),(765,NULL,NULL,NULL,'2021-01-01','2','123456789','sdsd','demo_sd','XYZ_dsd','DEMO 1','DEMO 2','421301',NULL,NULL,NULL,'1',NULL,'1','1'),(766,NULL,NULL,NULL,'2021-01-01','2','123456789','s@gmail.com','demo_sd','XYZ_dsd','DEMO 1','DEMO 2','421301',NULL,NULL,NULL,'1',NULL,'1','1'),(767,NULL,NULL,NULL,'2021-01-01','2','123456789','s11@gmail.com','demo_sd','XYZ_dsd','DEMO 1','DEMO 2','421301',NULL,NULL,NULL,'1',NULL,'1','1'),(768,NULL,NULL,NULL,'2021-01-01','2','123456789','s13@gmail.com','demo_sd','XYZ_dsd','DEMO 1','DEMO 2','421301',NULL,NULL,NULL,'1',NULL,'1','1'),(769,'sheetal','demo','demo','1999-05-05','2','0634893733','sharma@gmail.com','demo','demo','90 Wadhurst Rd','90 Wadhurst Rd','121564','739','3419','100','0',NULL,'1','1'),(770,'emma','Kumar','luise','2010-06-17','2','0634893733','emma@gmail.com','dem','demo','90 Wadhurst Rd','90 Wadhurst Rd','121564','1525','5743','224','0',NULL,'1','1'),(771,'sadhna','','yadav','1995-06-28','2','063489373','sadhna37@yatharthriti.com','demo','demo','fg','fg','4512','739','3419','100','0',NULL,'1','1'),(772,'sandya','demo','yadav','1995-06-28','2','0634893733','sandya@yatharthriti.com','demo','demo','fg','fg','4512','749','3529','100','0',NULL,'1','1'),(773,'samya','A','Parente','2021-04-01','2','634893733','sadhna@yatharthriti.com','as','sd','Helsink','Helsink','123456','746',NULL,'100','0',NULL,'1','1'),(774,'marry','Karttunen','Karttunen','2017-02-09','2','0444564987','Marry@gmail.com','demo','demo','Berlin','Berlin','12209','738',NULL,'100','0',NULL,'1','1'),(775,'subjectm','Karttunen','Karttunen','2021-03-31','1','0444564987','subject@gmail.com','demo','demo','Berlin','Berlin','12209','737',NULL,'100','1',NULL,'1','1'),(776,'sandeepsubject','Karttunen','Karttunen','2021-04-21','1','0444564987','Matti@gmail.com','asdfasdf','sadfasdf','Berlin','Berlin','12209','250',NULL,'5','0',NULL,'1','1'),(777,'richard','Parente','Parente','2017-06-07','1','634893733','richard@gmail.com','demo','demo','Helsink','Helsink','123456','304',NULL,'19','1',NULL,'0','1'),(778,'sadhna',NULL,'yadav','1995-06-28','2','063489373','s1@yatharthriti.com','demo','demo','fg','fg','4512','739','3419','100','1',NULL,'1','1'),(779,'sadhna',NULL,'yadav','1995-06-28','2','063489373','s11@yatharthriti.com','demo','demo','fg','fg','4512','739','3419','100','1',NULL,'1','1'),(781,'sanya','demo','yadav','1995-06-28','2','0634893733','sanya@gmail.com','demo','demo','fg','fg','4512','739','3419','100','0',NULL,'1','1'),(782,'sreya','demo','yadav','1995-06-28','2','0634893733','sreya@gmail.com','demo','demo','fg','fg','4512','739','3419','100','0',NULL,'1','1'),(783,'sreya','demo','yadav','1995-06-28','2','0634893733','sreya@yatharthriti.com','demo','demo','fg','fg','4512','739','3419','100','0',NULL,'1','1'),(784,'sreya','demo_abc','yadav',NULL,'2','0634893733','s1123@yatharthriti.com','demo','demo','fg','fg','4512','739','3419','100','0',NULL,'1','1'),(785,'sreya','demo_abc','yadav','6/28/1995','2','0634893733','s123@yatharthriti.com','demo','demo','fg','fg','4512','739','3419','100','1',NULL,'1','1'),(786,'AVDHUT','DEMO','SANGALE','2021-01-01','1','123456789','demo@demo.com_2','ABC','XYZ','DEMO 1','DEMO 2','421301','745','3489','100','0',NULL,'1','1'),(787,'xyz','demo_abc','yadav','6/28/1995','2','0634893733','xyz@gmail.com','demo','demo','fg','fg','4512','739','3419','100','0',NULL,'1','1'),(788,'xyz','demo_abc','yadav',NULL,'2','0634893733','xyz1@gmail.com','demo','demo','fg','fg','4512','739','3419','100','0',NULL,'1','1'),(789,'Harry','demo_abc','james','6/28/1995','2','0634893733','harry@gmail.com','demo','demo','sector-7','sector-7','4512','739','3419','100','0',NULL,'1','1'),(790,'niya','','sharma','2019-03-14','2','2134465','niya@gmail.com','demo','demo','1347,sanjay Enclave','demo','121005','1524','5723','224','0',NULL,'1','1'),(791,'mia','','jorg','2007-03-15','2','9874121541','mia@gmail.com','demo','demo','1347,sanjay Enclave','demo','121005','739','3428','100','0',NULL,'1','1'),(792,'daisy','DSV','demo','2007-07-07','2','123456789','daisy@gmail.com','demo','demo','demo','demo','555','743','3458','100','0',NULL,'1','1'),(793,'aryab','dem','demo','2020-01-31','1','6772777283','aryab@gmail.com','demo','demo','1347,sanjay Enclave','demo','121005','739','3427','100','0',NULL,'1','1'),(794,'sarry','demo_abc','james','6/28/1995','2','0634893733','sarry@gmail.com','demo','demo','sector-7','sector-7','4512','739','3419','100','0',NULL,'1','1'),(795,'sarry','','james','6/28/1995','2','0634893733','sarry1@gmail.com','demo','demo','sector-7','sector-7','4512','739','3419','100','0',NULL,'1','1'),(796,'sarry','','demo','6/28/1995','2','0634893733','sarry12@gmail.com','demo','demo','sector-7','sector-7','4512','739','3419','100','0',NULL,'1','1'),(797,'sarry','','demo','6/28/1995','1','9871167453','sarry23@gmail.com','ram kumar','sita','sector-7','sector-7','4512','739','3419','100','0',NULL,'1','1'),(798,'micky','','demo','2021-04-08','1','9871167453','micky@gmail.com','ram_kumar','sita_kumari','sector-7','sector-7','4512','739','3421','100','0',NULL,'1','1'),(799,'ayeesha','safi','safi','1995-12-31','2','876555366','ayeesha@gmail.com','tariqe','jannat','badkhal','badkhal','12111','739','3419','100','0',NULL,'1','1'),(800,'ritu','sharma','sharma','1996-02-22','2','876356363','ritu@gmail.com','Narendar','kamla','dabua colony','dabula colony','123','738','3411','100','0',NULL,'1','1'),(801,'jyoti','kumari','kumari','1998-02-04','2','663773883','jyoti@gmail.com','ram','sita','Hno-123 ,bhadna chowk','Hno-123 ,bhadna chowk','123','737','3395','100','0',NULL,'1','1'),(802,'scott','layton','layton','2004-06-10','1','8635277892','scott@gmail.com','davis','kimber','1347,sanjay Enclave','demo','121005','739','3427','100','0',NULL,'1','1'),(803,'skyla','','kimber','2008-02-14','2','6778989899','skyla@gmail.com','jayda','mae','demo','demo','555','280','1772','11','0',NULL,'1','1'),(804,'zeke','liberty','liberty','2003-03-04','1','686567878','zeke@gmail.com','laney','hayley','badkhal','badkhal','12111','683','3206','90','0',NULL,'1','1'),(805,'nelson','devon','devon','2005-06-23','1','678787987','nelson@gmail.com','miller','alvin','1347,sanjay Enclave','demo','121005','1528','5806','224','0',NULL,'1','1'),(806,'ayansh','','Yadav','2021-05-05','1','878798967','sandeepking1015@gmail.com','hh','gvg','Hno-123 ,bhadna chowk','Hno-123 ,bhadna chowk','123','746','3521','100','0',NULL,'1','1');

--
-- Table structure for table `demo_retailer`
--

CREATE TABLE `demo_retailer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `demo_retailer`
--


--
-- Table structure for table `demo_role`
--

CREATE TABLE `demo_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `demo_role`
--

INSERT INTO `demo_role` VALUES (5,'admin'),(12,'student'),(20,'reporting officer'),(22,'principal'),(24,'guest teacher'),(25,'manager'),(29,'class teacher'),(58,'teacher'),(59,'staff'),(99,'user'),(100,'role');

--
-- Table structure for table `demo_role_permission`
--

CREATE TABLE `demo_role_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role` varchar(50) NOT NULL DEFAULT '0',
  `permission` varchar(50) NOT NULL DEFAULT '0',
  `status` varchar(50) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=211 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `demo_role_permission`
--

INSERT INTO `demo_role_permission` VALUES (107,'5','82','1'),(108,'5','83','1'),(109,'5','84','0'),(110,'5','85','0'),(111,'5','86','0'),(112,'12','82','1'),(113,'12','83','1'),(114,'12','84','0'),(115,'12','85','0'),(116,'12','86','1'),(117,'20','82','0'),(118,'20','83','0'),(119,'20','84','0'),(120,'20','85','0'),(121,'20','86','0'),(122,'22','82','1'),(123,'22','83','1'),(124,'22','84','0'),(125,'22','85','0'),(126,'22','86','0'),(127,'24','82','0'),(128,'24','83','0'),(129,'24','84','0'),(130,'24','85','0'),(131,'24','86','0'),(132,'25','82','0'),(133,'25','83','0'),(134,'25','84','0'),(135,'25','85','0'),(136,'25','86','0'),(137,'29','82','1'),(138,'29','83','0'),(139,'29','84','0'),(140,'29','85','0'),(141,'29','86','0'),(142,'58','82','1'),(143,'58','83','1'),(144,'58','84','1'),(145,'58','85','0'),(146,'58','86','0'),(147,'59','82','0'),(148,'59','83','0'),(149,'59','84','0'),(150,'59','85','0'),(151,'59','86','0'),(157,'5','87','0'),(158,'5','90','0'),(159,'5','91','0'),(160,'5','92','0'),(162,'5','95','0'),(163,'12','87','0'),(164,'12','90','0'),(165,'12','91','0'),(166,'12','92','0'),(168,'12','95','0'),(169,'20','87','0'),(170,'20','90','0'),(171,'20','91','0'),(172,'20','92','0'),(174,'20','95','0'),(175,'22','87','0'),(176,'22','90','0'),(177,'22','91','0'),(178,'22','92','0'),(180,'22','95','0'),(181,'24','87','0'),(182,'24','90','0'),(183,'24','91','0'),(184,'24','92','0'),(186,'24','95','0'),(187,'25','87','0'),(188,'25','90','0'),(189,'25','91','0'),(190,'25','92','0'),(192,'25','95','0'),(193,'29','87','0'),(194,'29','90','0'),(195,'29','91','0'),(196,'29','92','0'),(198,'29','95','0'),(199,'58','87','1'),(200,'58','90','0'),(201,'58','91','0'),(202,'58','92','0'),(204,'58','95','0'),(205,'59','87','0'),(206,'59','90','0'),(207,'59','91','0'),(208,'59','92','0'),(210,'59','95','0');

--
-- Table structure for table `demo_rolelist`
--

CREATE TABLE `demo_rolelist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(20) DEFAULT NULL,
  `role_id` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=452 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `demo_rolelist`
--

INSERT INTO `demo_rolelist` VALUES (253,'119','5'),(297,'141','58'),(299,'143','59'),(300,'144','59'),(301,'142','58'),(303,'146','58'),(305,'148','58'),(306,'149','58'),(307,'150','58'),(308,'151','58'),(311,'158','58'),(312,'159','12'),(313,'160','12'),(314,'161','12'),(317,'156','22'),(318,'163','12'),(319,'164','12'),(320,'165','12'),(321,'166','12'),(322,'167','12'),(323,'168','12'),(324,'169','12'),(325,'152','12'),(326,'170','12'),(327,'171','12'),(328,'172','12'),(329,'173','12'),(331,'175','12'),(332,'176','12'),(333,'177','12'),(334,'157','58'),(337,'180','12'),(339,'145','29'),(340,'174','12'),(341,'181','12'),(342,'182','12'),(344,'183','58'),(345,'184','58'),(346,'185','58'),(347,'186','58'),(348,'187','58'),(349,'188','58'),(350,'189','58'),(351,'190','58'),(352,'191','58'),(354,'192','58'),(355,'193','58'),(356,'194','58'),(358,'147','29'),(360,'195','58'),(361,'196','12'),(362,'197','12'),(366,'201','12'),(368,'198','12'),(369,'202','12'),(370,'203','12'),(371,'205','12'),(372,'206','12'),(374,'207','12'),(375,'204','12'),(376,'199','12'),(377,'208','29'),(378,'209','12'),(381,'210','12'),(385,'162','12'),(386,'211','29'),(387,'212','12'),(388,'213','29'),(389,'214','58'),(390,'215','58'),(391,'216','58'),(392,'217','12'),(393,'218','12'),(394,'219','12'),(395,'220','12'),(396,'221','12'),(397,'222','58'),(398,'223','12'),(399,'224','12'),(400,'225','12'),(401,'200','29'),(402,'227','58'),(403,'228','29'),(405,'229','29'),(406,'230','12'),(407,'231','12'),(408,'233','12'),(409,'234','12'),(410,'235','12'),(411,'236','12'),(412,'237','12'),(413,'238','12'),(414,'239','12'),(415,'240','12'),(416,'241','12'),(417,'242','12'),(418,'243','12'),(419,'244','12'),(420,'245','12'),(421,'247','12'),(422,'248','12'),(423,'249','12'),(424,'250','12'),(425,'251','59'),(426,'252','58'),(428,'253','12'),(429,'254','29'),(431,'255','58'),(432,'256','12'),(433,'257','12'),(434,'258','12'),(435,'259','12'),(436,'260','12'),(437,'261','12'),(438,'262','12'),(439,'263','12'),(440,'264','12'),(441,'265','12'),(442,'266','12'),(443,'267','58'),(444,'268','58'),(445,'269','29'),(446,'270','58'),(447,'271','12'),(448,'272','12'),(449,'273','12'),(450,'274','12'),(451,'275','12');

--
-- Table structure for table `demo_salary`
--

CREATE TABLE `demo_salary` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(50) DEFAULT NULL,
  `fixed_salary` varchar(50) DEFAULT NULL,
  `fixed_salary_val` varchar(50) DEFAULT NULL,
  `fixed_tds_dropdwon` varchar(50) DEFAULT NULL,
  `hra` varchar(50) DEFAULT NULL,
  `basic_salary` varchar(50) DEFAULT NULL,
  `travel` varchar(50) DEFAULT NULL,
  `other_expenses` varchar(50) DEFAULT NULL,
  `tds_value` varchar(50) DEFAULT NULL,
  `tax` varchar(50) DEFAULT NULL,
  `pan_card` varchar(50) DEFAULT NULL,
  `account_number` varchar(50) DEFAULT NULL,
  `ifsc_code` varchar(50) DEFAULT NULL,
  `account_holder_name` varchar(50) DEFAULT NULL,
  `pf` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `demo_salary`
--

INSERT INTO `demo_salary` VALUES (1,'158','0',NULL,NULL,'300','3000','300','300','1','300','123','123','123','sandy',NULL),(2,'148','0',NULL,NULL,'300','3000','300','3000','1','300','1233','123','cv','richard',NULL),(3,'157','1','3000','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'123','454','narry',NULL),(4,'142','0',NULL,NULL,'1000','1000','500','500','1','3000','12345','1234','455','ana',NULL),(5,'147','0',NULL,NULL,'300','3000','300','300','1','300','123','123','123','teila',NULL),(6,'150','1','10','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'4','78','rthd',NULL),(7,'151','0',NULL,NULL,'300','3000','300','300','1','300','545','5454','4546','mario',NULL),(8,'144','1','442','10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'258','25','87',NULL),(9,'156','0',NULL,NULL,'3000','30000','3000','3000','1','3000','123','123','123','john','1000'),(10,'146','0',NULL,NULL,'1000','20000','1000','1000','1','1000','2122','123','123','ricy',NULL),(11,'149','0',NULL,NULL,'300','3000','300','300','1','500','123232','546','555','hj','300'),(12,'145','1','10000','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'35','35','kayla',NULL),(13,'213','1','10000','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'123456789','454','12345',NULL),(14,'215','1','30000','10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'123','123','nora',NULL),(15,'211','1','30000','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'11','qw','james',NULL),(16,'269','1','30000','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'12345','4344','anjali',NULL);

--
-- Table structure for table `demo_salary_history`
--

CREATE TABLE `demo_salary_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(50) DEFAULT NULL,
  `fixed_salary` varchar(50) DEFAULT NULL,
  `fixed_salary_val` varchar(50) DEFAULT NULL,
  `fixed_tds_dropdwon` varchar(50) DEFAULT NULL,
  `hra` varchar(50) DEFAULT NULL,
  `basic_salary` varchar(50) DEFAULT NULL,
  `travel` varchar(50) DEFAULT NULL,
  `other_expenses` varchar(50) DEFAULT NULL,
  `tds_value` varchar(50) DEFAULT NULL,
  `tax` varchar(50) DEFAULT NULL,
  `pan_card` varchar(50) DEFAULT NULL,
  `account_number` varchar(50) DEFAULT NULL,
  `ifsc_code` varchar(50) DEFAULT NULL,
  `account_holder_name` varchar(50) DEFAULT NULL,
  `salary_id` int(11) DEFAULT NULL,
  `pf` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_salary_history`
--

INSERT INTO `demo_salary_history` VALUES (1,'158','0',NULL,'','300','3000','300','300','1','300','123','123','123','sandy',1,NULL),(2,'158','0',NULL,'','300','3000','300','300','1','300','123','123','123','sandy',2,NULL),(3,'158','0',NULL,'','300','3000','300','300','1','300','123','123','123','sandy',3,NULL),(4,'158','0',NULL,'','300','3000','300','300','1','300','123','123','123','sandy',4,NULL),(5,'158','0',NULL,'','300','3000','300','300','1','300','123','123','123','sandy',5,NULL),(6,'158','0',NULL,'','300','3000','300','300','1','300','123','123','123','sandy',6,NULL),(7,'158','0',NULL,'','300','3000','300','300','1','300','123','123','123','sandy',7,NULL),(8,'158','0',NULL,'','300','3000','300','300','1','300','123','123','123','sandy',8,NULL),(9,'158','0',NULL,'','300','3000','300','300','1','300','123','123','123','sandy',9,NULL),(10,'157','1',NULL,'5','','','','','','','','123','454','narry',10,NULL),(11,'157','1',NULL,'5','','','','','','','','123','454','narry',11,NULL),(12,'157','1',NULL,'5','','','','','','','','123','454','narry',12,NULL),(13,'157','1',NULL,'5','','','','','','','','123','454','narry',13,NULL),(14,'157','1',NULL,'5','','','','','','','','123','454','narry',14,NULL),(15,'157','1',NULL,'5','','','','','','','','123','454','narry',15,NULL),(16,'157','1',NULL,'5','','','','','','','','123','454','narry',16,NULL),(17,'142','1',NULL,'10','','','','','','','','123','122','ana',17,NULL),(18,'142','0',NULL,'','3000','30000','3000','3000','1','3000','12345','1234','455','ana',18,NULL),(19,'142','0',NULL,'','3000','30000','3000','3000','1','3000','12345','1234','455','ana',19,NULL),(20,'142','0',NULL,'','3000','30000','3000','3000','1','3000','12345','1234','455','ana',20,NULL),(21,'142','0',NULL,'','3000','30000','3000','3000','1','3000','12345','1234','455','ana',21,NULL),(22,'147','1',NULL,'5','','','','','','','','12345','456','teila',22,NULL),(23,'147','1',NULL,'5','','','','','','','','12345','456','teila',23,NULL),(24,'147','0',NULL,'','300','3000','300','300','1','300','123','123','123','teila',24,NULL),(25,'142','0',NULL,'','3000','30000','3000','3000','1','3000','12345','1234','455','ana',25,NULL),(26,'142','0',NULL,'','1000','1000','500','500','1','3000','12345','1234','455','ana',26,NULL),(27,'150','0',NULL,'','10','10','10','10','0','','','14','783','8736',27,NULL),(28,'151','1',NULL,'5','','','','','','','','123','123','mara',28,NULL),(29,'151','0',NULL,'','300','3000','300','300','1','300','545','5454','4546','mario',29,NULL),(30,'144','1',NULL,'10','','','','','','','','258','25','87',30,NULL),(31,'156','1','30000','5','','','','','','','','123','dv','principal',31,NULL),(32,'156','1','30000','5','','','','','','','','123','dv','principal',32,NULL),(33,'156','0','','','3000','30000','3000','3000','1','3000','123','123','123','john',33,NULL),(34,'156','0','','','3000','30000','3000','3000','1','3000','123','123','123','john',34,NULL),(35,'156','0','','','3000','30000','3000','3000','1','3000','123','123','123','john',35,NULL),(36,'158','0','','','300','3000','300','300','1','300','123','123','123','sandy',36,NULL),(37,'158','0','','','300','3000','300','300','1','300','123','123','123','sandy',37,NULL),(38,'158','0','','','300','3000','300','300','1','300','123','123','123','sandy',38,NULL),(39,'146','1','10000','10','','','','','','','','123','123','abc',39,NULL),(40,'146','1','10000','10','','','','','','','','123','123','abc',40,NULL),(41,'146','1','10000','10','','','','','','','','123','123','abc',41,NULL),(42,'146','1','10000','10','','','','','','','','123','123','abc',42,NULL),(43,'146','0','','','1000','20000','1000','1000','1','1000','2122','123','123','ricy',43,NULL),(44,'146','0','','','1000','20000','1000','1000','1','1000','2122','123','123','ricy',44,NULL),(45,'146','0','','','1000','20000','1000','1000','1','1000','2122','123','123','ricy',45,NULL),(46,'156','0','','','3000','30000','3000','3000','1','3000','123','123','123','john',46,'1000'),(47,'149','0','','','300','3000','300','300','1','500','123232','546','555','hj',47,'300'),(48,'149','0','','','300','3000','300','300','1','500','123232','546','555','hj',48,'300'),(49,'147','0','','','300','3000','300','300','1','300','123','123','123','teila',49,''),(50,'145','1','10000','5','','','','','','','','35','35','kayla',50,''),(51,'145','1','10000','5','','','','','','','','35','35','kayla',51,''),(52,'213','1','10000','5','','','','','','','','123456789','454','12345',52,''),(53,'215','1','30000','10','','','','','','','','123','123','nora',53,''),(54,'215','1','30000','10','','','','','','','','123','123','nora',54,''),(55,'215','1','30000','10','','','','','','','','123','123','nora',55,''),(56,'215','1','30000','10','','','','','','','','123','123','nora',56,''),(57,'215','1','30000','10','','','','','','','','123','123','nora',57,''),(58,'215','1','30000','10','','','','','','','','123','123','nora',58,''),(59,'215','1','30000','10','','','','','','','','123','123','nora',59,''),(60,'145','1','10000','5','','','','','','','','35','35','kayla',60,''),(61,'145','1','10000','5','','','','','','','','35','35','kayla',61,''),(62,'145','1','10000','5','','','','','','','','35','35','kayla',62,''),(63,'145','1','10000','5','','','','','','','','35','35','kayla',63,''),(64,'213','1','10000','5','','','','','','','','123456789','454','12345',64,''),(65,'213','1','10000','5','','','','','','','','123456789','454','12345',65,''),(66,'211','1','30000','5','','','','','','','','11','qw','james',66,''),(67,'269','1','30000','5','','','','','','','','12345','4344','anjali',67,''),(68,'269','1','30000','5','','','','','','','','12345','4344','anjali',68,''),(69,'269','1','30000','5','','','','','','','','12345','4344','anjali',69,''),(70,'269','1','30000','5','','','','','','','','12345','4344','anjali',70,'');

--
-- Table structure for table `demo_salary_month_wise`
--

CREATE TABLE `demo_salary_month_wise` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(50) DEFAULT NULL,
  `fixed_salary` int(11) DEFAULT NULL,
  `fixed_salary_val` varchar(50) DEFAULT NULL,
  `fixed_tds_dropdwon` int(11) DEFAULT NULL,
  `hra` varchar(50) DEFAULT NULL,
  `basic_salary` varchar(50) DEFAULT NULL,
  `travel` varchar(50) DEFAULT NULL,
  `other_expenses` varchar(50) DEFAULT NULL,
  `tax` int(11) DEFAULT NULL,
  `month` varchar(50) DEFAULT NULL,
  `year` varchar(50) DEFAULT NULL,
  `present_days` varchar(50) DEFAULT NULL,
  `working_days` varchar(50) DEFAULT NULL,
  `total` int(11) DEFAULT NULL,
  `over_time_amount` varchar(50) DEFAULT NULL,
  `loan_amount` varchar(50) DEFAULT NULL,
  `advance_salary_amount` varchar(50) DEFAULT NULL,
  `pf` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `demo_salary_month_wise`
--

INSERT INTO `demo_salary_month_wise` VALUES (1,'158',0,NULL,NULL,'300','3000','300','300',300,'01','2021','31','31',3600,'0','0','0',NULL),(2,'158',0,NULL,NULL,'300','3000','300','300',300,'02','2021','28','28',2600,'0','0','1000',NULL),(3,'158',0,NULL,NULL,'300','3000','300','300',300,'03','2021','31','31',3600,'0','0','0',NULL),(4,'158',0,NULL,NULL,'300','3000','300','300',300,'04','2021','30','30',3600,'0','0','0',NULL),(5,'158',0,NULL,NULL,'300','3000','300','300',300,'05','2021','30','30',3600,'0','0','0',NULL),(6,'158',0,NULL,NULL,'300','3000','300','300',300,'06','2021','30','30',7374,'3774.1935483871','0','0',NULL),(7,'158',0,NULL,NULL,'300','3000','300','300',300,'07','2021','12','12',3600,'0','0','0',NULL),(8,'158',0,NULL,NULL,'300','3000','300','300',300,'08','2021','30','30',3100,'0','500','0',NULL),(9,'158',0,NULL,NULL,'300','3000','300','300',300,'09','2021','30','30',2100,'0','1500','0',NULL),(10,'157',1,'3000',5,NULL,NULL,NULL,NULL,NULL,'01','2021','30','30',350,'0','2500','0',NULL),(11,'157',1,'3000',5,NULL,NULL,NULL,NULL,NULL,'02','2021','28','28',350,'0','2500','0',NULL),(12,'157',1,'3000',5,NULL,NULL,NULL,NULL,NULL,'03','2021','31','31',2850,'0','0','0',NULL),(13,'157',1,'3000',5,NULL,NULL,NULL,NULL,NULL,'04','2021','30','30',2820,'0','0','30',NULL),(14,'157',1,'3000',5,NULL,NULL,NULL,NULL,NULL,'05','2021','31','31',5753,'2903.2258064516','0','0',NULL),(15,'157',1,'3000',5,NULL,NULL,NULL,NULL,NULL,'06','2021','30','30',1850,'0','0','1000',NULL),(16,'157',1,'3000',5,NULL,NULL,NULL,NULL,NULL,'07','2021','31','31',8656,'5806.4516129032','0','0',NULL),(17,'142',1,'0',10,NULL,NULL,NULL,NULL,NULL,'01','2021','31','31',0,'0','0','0',NULL),(18,'142',0,NULL,NULL,'3000','30000','3000','3000',3000,'02','2021','28','28',36000,'0','0','0',NULL),(19,'142',0,NULL,NULL,'2419.3548387097','24193.548387097','2419.3548387097','2419.3548387097',3000,'03','2021','25','31',28452,'0','0','0',NULL),(20,'142',0,NULL,NULL,'3000','30000','3000','3000',3000,'04','2021','30','30',36000,'0','0','0',NULL),(21,'142',0,NULL,NULL,'3000','30000','3000','3000',3000,'05','2021','31','31',73742,'37741.935483871','0','0',NULL),(22,'147',1,'3000',5,NULL,NULL,NULL,NULL,NULL,'01','2021','31','31',2850,'0','0','0',NULL),(23,'147',1,'0',5,NULL,NULL,NULL,NULL,NULL,'02','2021','28','28',0,'0','0','0',NULL),(24,'147',0,NULL,NULL,'300','3000','300','300',300,'03','2021','31','31',3600,'0','0','0',NULL),(25,'142',0,NULL,NULL,'3000','30000','3000','3000',3000,'06','2021','30','30',75000,'39000','0','0',NULL),(26,'142',0,NULL,NULL,'1000','1000','500','500',3000,'01','2018','30','30',100,'100','0','0',NULL),(27,'150',0,NULL,NULL,'10','10','10','10',0,'01','2018','30','30',40,'0','0','0',NULL),(28,'151',1,'0',5,NULL,NULL,NULL,NULL,NULL,'01','2021','31','31',0,'0','0','0',NULL),(29,'151',0,NULL,NULL,'300','3000','300','300',300,'02','2021','28','28',3600,'0','0','0',NULL),(30,'144',1,'442',10,NULL,NULL,NULL,NULL,NULL,'01','2018','20','20',398,'0','0','0',NULL),(31,'156',1,'30000.00',5,NULL,NULL,NULL,NULL,NULL,'01','2021','30','30',28500,'0.00','0.00','0.00',NULL),(32,'156',1,'26785.71',5,NULL,NULL,NULL,NULL,NULL,'02','2021','25','28',25446,'0.00','0.00','0.00',NULL),(33,'156',0,NULL,NULL,'2000.00','20000.00','2000.00','2000.00',3000,'03','2021','20','30',23000,'0.00','0.00','0.00',NULL),(34,'156',0,NULL,NULL,'3000.00','30000.00','3000.00','3000.00',3000,'04','2021','30','30',36000,'0.00','0.00','0.00',NULL),(35,'156',0,NULL,NULL,'3000.00','30000.00','3000.00','3000.00',3000,'05','2021','30','30',36000,'0.00','0.00','0.00',NULL),(36,'158',0,NULL,NULL,'300.00','3000.00','300.00','300.00',300,'10','2021','31','31',3072,'471.77','500.00','500.00',NULL),(37,'158',0,NULL,NULL,'300.00','3000.00','300.00','300.00',300,'11','2021','30','30',3600,'0.00','0.00','0.00',NULL),(38,'158',0,NULL,NULL,'300.00','3000.00','300.00','300.00',300,'12','2021','31','31',4544,'943.55','0.00','0.00',NULL),(39,'146',1,'10000.00',10,NULL,NULL,NULL,NULL,NULL,'01','2021','31','31',9000,'0.00','0.00','0.00',NULL),(40,'146',1,'10000.00',10,NULL,NULL,NULL,NULL,NULL,'02','2021','28','28',7000,'0.00','2000.00','0.00',NULL),(41,'146',1,'10000.00',10,NULL,NULL,NULL,NULL,NULL,'03','2021','31','31',6500,'0.00','2000.00','500.00',NULL),(42,'146',1,'10000.00',10,NULL,NULL,NULL,NULL,NULL,'04','2021','30','30',9417,'416.67','0.00','0.00',NULL),(43,'146',0,NULL,NULL,'1000.00','20000.00','1000.00','1000.00',1000,'05','2021','31','31',22000,'0.00','0.00','0.00',NULL),(44,'146',0,NULL,NULL,'1000.00','20000.00','1000.00','1000.00',1000,'06','2021','30','30',17917,'1916.67','5000.00','1000.00',NULL),(45,'146',0,NULL,NULL,'677.42','13548.39','677.42','677.42',1000,'07','2021','21','31',14581,'0.00','0.00','0.00',NULL),(46,'156',0,NULL,NULL,'3000.00','30000.00','3000.00','3000.00',3000,'01','2024','30','30',35000,'0.00','0.00','0.00','1000.00'),(47,'149',0,NULL,NULL,'300.00','3000.00','300.00','300.00',500,'01','2021','30','30',3100,'0.00','0.00','0.00','300.00'),(48,'149',0,NULL,NULL,'267.86','2678.57','267.86','267.86',500,'02','2021','25','28',2714,'0.00','0.00','0.00','267.86'),(49,'147',0,NULL,NULL,'300.00','3000.00','300.00','300.00',300,'06','2021','30','30',3600,'0.00','0.00','0.00','0.00'),(50,'145',1,'10000.00',5,NULL,NULL,NULL,NULL,NULL,'01','2021','30','30',9500,'0.00','0.00','0.00','0'),(51,'145',1,'10000.00',5,NULL,NULL,NULL,NULL,NULL,'03','2021','30','30',9500,'0.00','0.00','0.00','0'),(52,'213',1,'10000.00',5,NULL,NULL,NULL,NULL,NULL,'03','2021','30','30',9500,'0.00','0.00','0.00','0'),(53,'215',1,'30000.00',10,NULL,NULL,NULL,NULL,NULL,'03','2021','30','30',27000,'0.00','0.00','0.00','0'),(54,'215',1,'30000.00',10,NULL,NULL,NULL,NULL,NULL,'04','2021','30','30',12000,'0.00','10000.00','5000.00','0'),(55,'215',1,'25000.00',10,NULL,NULL,NULL,NULL,NULL,'05','2021','25','30',12500,'0.00','10000.00','0.00','0'),(56,'215',1,'30000.00',10,NULL,NULL,NULL,NULL,NULL,'08','2021','30','30',17000,'0.00','10000.00','0.00','0'),(57,'215',1,'30000.00',10,NULL,NULL,NULL,NULL,NULL,'09','2021','30','30',17000,'0.00','10000.00','0.00','0'),(58,'215',1,'30000.00',10,NULL,NULL,NULL,NULL,NULL,'10','2021','30','30',17000,'0.00','10000.00','0.00','0'),(59,'215',1,'30000.00',10,NULL,NULL,NULL,NULL,NULL,'06','2021','30','30',27000,'0.00','0.00','0.00','0'),(60,'145',1,'10000.00',5,NULL,NULL,NULL,NULL,NULL,'04','2021','30','30',9500,'0.00','0.00','0.00','0'),(61,'145',1,'10000.00',5,NULL,NULL,NULL,NULL,NULL,'05','2021','31','31',9500,'0.00','0.00','0.00','0'),(62,'145',1,'10000.00',5,NULL,NULL,NULL,NULL,NULL,'06','2021','30','30',750,'1250.00','5000.00','5000.00','0'),(63,'145',1,'6666.67',5,NULL,NULL,NULL,NULL,NULL,'07','2021','20','30',-8667,'0.00','5000.00','10000.00','0'),(64,'213',1,'8333.33',5,NULL,NULL,NULL,NULL,NULL,'04','2021','25','30',7917,'0.00','0.00','0.00','0'),(65,'213',1,'6666.67',5,NULL,NULL,NULL,NULL,NULL,'05','2021','20','30',6333,'0.00','0.00','0.00','0'),(66,'211',1,'29032.26',5,NULL,NULL,NULL,NULL,NULL,'04','2021','30','31',27581,'0.00','0.00','0.00','0'),(67,'269',1,'30000.00',5,NULL,NULL,NULL,NULL,NULL,'04','2021','30','30',28500,'0.00','0.00','0.00','0'),(68,'269',1,'30000.00',5,NULL,NULL,NULL,NULL,NULL,'05','2021','30','30',23500,'0.00','0.00','5000.00','0'),(69,'269',1,'30000.00',5,NULL,NULL,NULL,NULL,NULL,'06','2021','30','30',22250,'3750.00','10000.00','0.00','0'),(70,'269',1,'30000.00',5,NULL,NULL,NULL,NULL,NULL,'07','2021','30','30',18500,'0.00','10000.00','0.00','0'),(71,'150',1,'0',10,NULL,NULL,NULL,NULL,NULL,'02','2021',NULL,NULL,0,NULL,NULL,NULL,NULL),(72,'149',1,'0',10,NULL,NULL,NULL,NULL,NULL,'03','2021',NULL,NULL,0,NULL,NULL,NULL,NULL),(73,'141',1,'0',10,NULL,NULL,NULL,NULL,NULL,'01','2021',NULL,NULL,0,NULL,NULL,NULL,NULL);

--
-- Table structure for table `demo_section_list`
--

CREATE TABLE `demo_section_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `section_id` varchar(50) DEFAULT NULL,
  `class_id` varchar(50) DEFAULT NULL,
  `delete_status` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=583 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_section_list`
--

INSERT INTO `demo_section_list` VALUES (419,'14','64',NULL),(420,'15','64',NULL),(423,'14','65',NULL),(424,'15','65',NULL),(428,'14','66',NULL),(429,'15','66',NULL),(430,'14','67',NULL),(431,'15','67',NULL),(440,'14','71',NULL),(441,'15','71',NULL),(453,'14','76','1'),(459,'20','80','0'),(461,'20','82','0'),(464,'20','83','1'),(466,'20','78',NULL),(467,'20','81',NULL),(482,'14','84','1'),(483,'14','85','1'),(484,'14','86','1'),(490,'14','87','1'),(498,'14','63','1'),(499,'15','63','1'),(502,'20','79','1'),(504,'14','88',NULL),(505,'14','74',NULL),(506,'15','74',NULL),(507,'16','74',NULL),(511,'14','70',NULL),(512,'15','70',NULL),(517,'14','73','1'),(518,'15','73','1'),(519,'16','73','1'),(524,'14','68',NULL),(525,'15','68',NULL),(526,'16','68',NULL),(527,'15','90','1'),(529,'15','91','1'),(532,'14','93','1'),(540,'14','95','1'),(541,'14','96','1'),(542,'14','97','1'),(546,'14','98','1'),(548,'14','99','1'),(550,'14','100','1'),(552,'14','101','1'),(554,'24','94',NULL),(559,'14','92',NULL),(560,'24','92',NULL),(563,'24','102',NULL),(564,'14','69',NULL),(565,'15','69',NULL),(566,'16','69',NULL),(569,'24','103','1'),(571,'24','104',NULL),(573,'24','106','1'),(574,'36','107','0'),(575,'24','105',NULL),(576,'24','89',NULL),(577,'15','108','0'),(578,'16','108','0'),(579,'14','72',NULL),(580,'15','72',NULL),(581,'16','72',NULL),(582,'17','72',NULL);

--
-- Table structure for table `demo_session`
--

CREATE TABLE `demo_session` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `startdate` varchar(50) DEFAULT NULL,
  `enddate` varchar(50) DEFAULT NULL,
  `delete_status` varchar(50) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `startMonth` varchar(50) DEFAULT NULL,
  `endMonth` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_session`
--

INSERT INTO `demo_session` VALUES (23,'Session21','2021','2022','1',0,'01','01'),(24,'SESSION',NULL,NULL,NULL,NULL,NULL,NULL),(25,'Session 1',NULL,NULL,NULL,NULL,NULL,NULL),(26,'session22_23','2022','2023','1',0,'01','01'),(27,'Session22','2022','2023','0',0,'01','01'),(28,'Session_21','2021','2022','2',1,'01','01'),(29,'session23','2023','2024','2',0,'01','01'),(30,'session24','2024','2024','2',0,'01','01'),(31,'session123','0','0','1',0,'0','0'),(32,'sess','2018','2019','1',0,'01','01');

--
-- Table structure for table `demo_sms_class`
--

CREATE TABLE `demo_sms_class` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `class` varchar(50) DEFAULT NULL,
  `no_of_period` int(11) DEFAULT NULL,
  `period_duration` int(11) DEFAULT NULL,
  `period_start_time` int(11) DEFAULT NULL,
  `lunch_duration` int(11) DEFAULT NULL,
  `lunch_start_time` int(11) DEFAULT NULL,
  `delete_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_sms_class`
--

INSERT INTO `demo_sms_class` VALUES (7,'63',6,1800,1612837800,1800,3,0),(8,'64',5,1800,1612924200,1800,3,0),(9,'65',5,1800,1612924200,1800,3,0),(10,'66',5,1800,1612924200,1800,3,0),(11,'67',5,1800,1612924200,1800,3,0),(12,'68',6,2700,1612924200,1800,3,0),(13,'69',6,1800,1612924200,1800,3,0),(14,'70',6,1800,1612924200,1800,3,0),(15,'71',7,1800,1612924200,1800,3,0),(16,'71',7,1800,1612924200,1800,3,0),(17,'72',7,1800,1612924200,1800,3,0),(18,'73',8,1800,1612924200,1800,3,0),(19,'74',8,1800,1612924200,1800,3,0),(20,'76',6,3600,1613968200,2700,3,1),(21,'78',5,1800,1615595400,1800,0,0),(22,'81',3,1800,1615595400,1800,0,0),(23,'88',5,2700,1616643000,1800,3,1),(24,'88',5,2700,1616643000,2700,3,0),(25,'89',5,1800,1616643000,1800,3,0),(26,'63',1,1800,1618101000,1800,0,1),(27,'63',1,1800,1618101000,1800,0,1),(28,'94',5,1800,1618111800,1800,3,0),(29,'64',1,1800,1618360200,1800,0,1),(30,'92',5,3600,1619148600,1800,3,0),(31,'102',5,1800,1619494200,1800,0,0),(32,'104',5,1800,1619929800,1800,3,0),(33,'85',5,1800,1624851000,1800,3,0),(34,'106',6,3600,1620099000,1800,3,0),(35,'103',5,1800,1626051600,1800,4,0);

--
-- Table structure for table `demo_sms_period`
--

CREATE TABLE `demo_sms_period` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `period` varchar(50) DEFAULT NULL,
  `start_time` varchar(50) DEFAULT NULL,
  `end_time` varchar(50) DEFAULT NULL,
  `class_id` varchar(50) DEFAULT NULL,
  `class_list_id` varchar(50) DEFAULT NULL,
  `delete_status` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=228 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_sms_period`
--

INSERT INTO `demo_sms_period` VALUES (37,'1','1612837800','1612839600','63','7','0'),(38,'2','1612839600','1612841400','63','7','0'),(39,'3','1612841400','1612843200','63','7','0'),(40,'999','1612843200','1612845000','63','7','0'),(41,'4','1612845000','1612846800','63','7','0'),(42,'5','1612846800','1612848600','63','7','0'),(43,'6','1612848600','1612850400','63','7','0'),(44,'1','1612924200','1612926000','64','8','0'),(45,'2','1612926000','1612927800','64','8','0'),(46,'3','1612927800','1612929600','64','8','0'),(47,'999','1612929600','1612931400','64','8','0'),(48,'4','1612931400','1612933200','64','8','0'),(49,'5','1612933200','1612935000','64','8','0'),(50,'1','1612924200','1612926000','65','9','0'),(51,'2','1612926000','1612927800','65','9','0'),(52,'3','1612927800','1612929600','65','9','0'),(53,'999','1612929600','1612931400','65','9','0'),(54,'4','1612931400','1612933200','65','9','0'),(55,'5','1612933200','1612935000','65','9','0'),(56,'1','1612924200','1612926000','66','10','0'),(57,'2','1612926000','1612927800','66','10','0'),(58,'3','1612927800','1612929600','66','10','0'),(59,'999','1612929600','1612931400','66','10','0'),(60,'4','1612931400','1612933200','66','10','0'),(61,'5','1612933200','1612935000','66','10','0'),(62,'1','1612924200','1612926000','67','11','0'),(63,'2','1612926000','1612927800','67','11','0'),(64,'3','1612927800','1612929600','67','11','0'),(65,'999','1612929600','1612931400','67','11','0'),(66,'4','1612931400','1612933200','67','11','0'),(67,'5','1612933200','1612935000','67','11','0'),(68,'1','1612924200','1612926900','68','12','0'),(69,'2','1612926900','1612929600','68','12','0'),(70,'3','1612929600','1612932300','68','12','0'),(71,'999','1612932300','1612934100','68','12','0'),(72,'4','1612934100','1612936800','68','12','0'),(73,'5','1612936800','1612939500','68','12','0'),(74,'6','1612939500','1612942200','68','12','0'),(75,'1','1612924200','1612926000','69','13','0'),(76,'2','1612926000','1612927800','69','13','0'),(77,'3','1612927800','1612929600','69','13','0'),(78,'999','1612929600','1612931400','69','13','0'),(79,'4','1612931400','1612933200','69','13','0'),(80,'5','1612933200','1612935000','69','13','0'),(81,'6','1612935000','1612936800','69','13','0'),(82,'1','1612924200','1612926000','70','14','0'),(83,'2','1612926000','1612927800','70','14','0'),(84,'3','1612927800','1612929600','70','14','0'),(85,'999','1612929600','1612931400','70','14','0'),(86,'4','1612931400','1612933200','70','14','0'),(87,'5','1612933200','1612935000','70','14','0'),(88,'6','1612935000','1612936800','70','14','0'),(89,'1','1612924200','1612926000','71','15','0'),(90,'2','1612926000','1612927800','71','15','0'),(91,'3','1612927800','1612929600','71','15','0'),(92,'999','1612929600','1612931400','71','15','0'),(93,'4','1612931400','1612933200','71','15','0'),(94,'5','1612933200','1612935000','71','15','0'),(95,'6','1612935000','1612936800','71','15','0'),(96,'7','1612936800','1612938600','71','15','0'),(97,'1','1612924200','1612926000','71','16','0'),(98,'2','1612926000','1612927800','71','16','0'),(99,'3','1612927800','1612929600','71','16','0'),(100,'999','1612929600','1612931400','71','16','0'),(101,'4','1612931400','1612933200','71','16','0'),(102,'5','1612933200','1612935000','71','16','0'),(103,'6','1612935000','1612936800','71','16','0'),(104,'7','1614319200','1614321900','71','16','0'),(105,'1','1612924200','1612926000','72','17','0'),(106,'2','1612926000','1612927800','72','17','0'),(107,'3','1612927800','1612929600','72','17','0'),(108,'999','1612929600','1612931400','72','17','0'),(109,'4','1612931400','1612933200','72','17','0'),(110,'5','1616648400','1616652000','72','17','0'),(111,'6','1616652000','1616653800','72','17','0'),(112,'7','1616653800','1616655600','72','17','0'),(113,'1','1612924200','1612926000','73','18','0'),(114,'2','1612926000','1612927800','73','18','0'),(115,'3','1612927800','1612929600','73','18','0'),(116,'999','1612929600','1612931400','73','18','0'),(117,'4','1612931400','1612933200','73','18','0'),(118,'5','1612933200','1612935000','73','18','0'),(119,'6','1612935000','1612936800','73','18','0'),(120,'7','1612936800','1612938600','73','18','0'),(121,'8','1613370600','1613374200','73','18','0'),(122,'1','1612924200','1612926000','74','19','0'),(123,'2','1612926000','1612927800','74','19','0'),(124,'3','1612927800','1612929600','74','19','0'),(125,'999','1612929600','1612931400','74','19','0'),(126,'4','1612931400','1612933200','74','19','0'),(127,'5','1612933200','1612935000','74','19','0'),(128,'6','1612935000','1612936800','74','19','0'),(129,'7','1612936800','1612938600','74','19','0'),(130,'8','1614234600','1614236400','74','19','0'),(137,'1','1613968200','1613971800','76','20','1'),(138,'2','1613971800','1613975400','76','20','1'),(139,'3','1613975400','1613979000','76','20','1'),(140,'999','1613979000','1613981700','76','20','1'),(141,'4','1613981700','1613984400','76','20','1'),(142,'5','1613984400','1613988000','76','20','1'),(143,'6','1613988000','1613991600','76','20','1'),(144,'1','1615595400','1615597200','78','21','0'),(145,'2','1615597200','1615599000','78','21','0'),(146,'3','1615599000','1615600800','78','21','0'),(147,'4','1615600800','1615602600','78','21','0'),(148,'5','1615602600','1615604400','78','21','0'),(149,'1','1615595400','1615597200','81','22','0'),(150,'2','1615597200','1615599000','81','22','0'),(151,'3','1615599000','1615600800','81','22','0'),(152,'1','1616643000','1616645700','88','23','1'),(153,'2','1616645700','1616648400','88','23','1'),(154,'3','1616648400','1616651100','88','23','1'),(155,'999','1616651100','1616652900','88','23','1'),(156,'4','1616652900','1616655600','88','23','1'),(157,'5','1616655600','1616658300','88','23','1'),(158,'1','1616643000','1616645700','88','24','0'),(159,'2','1616645700','1616648400','88','24','0'),(160,'3','1616648400','1616651100','88','24','0'),(161,'999','1617860700','1617864300','88','24','0'),(162,'4','1617864300','1617867000','88','24','0'),(163,'5','1617867000','1617869700','88','24','0'),(164,'1','1616643000','1616644800','89','25','0'),(165,'2','1616644800','1616646600','89','25','0'),(166,'3','1616646600','1616648400','89','25','0'),(167,'999','1616648400','1616650200','89','25','0'),(168,'4','1616650200','1616652000','89','25','0'),(169,'5','1616652000','1616653800','89','25','0'),(170,'1','1618101000','1618102800','63','26','1'),(171,'1','1618101000','1618102800','63','27','1'),(172,'1','1618111800','1618113600','94','28','0'),(173,'2','1618113600','1618115400','94','28','0'),(174,'3','1618115400','1618117200','94','28','0'),(175,'999','1618117200','1618119000','94','28','0'),(176,'4','1618119000','1618120800','94','28','0'),(177,'5','1618120800','1618122600','94','28','0'),(179,'1','1618360200','1618362000','64','29','1'),(180,'1','1619148600','1619152200','92','30','0'),(181,'2','1619152200','1619155800','92','30','0'),(182,'3','1619155800','1619159400','92','30','0'),(183,'999','1619159400','1619161200','92','30','0'),(184,'4','1619161200','1619164800','92','30','0'),(185,'5','1619164800','1619168400','92','30','0'),(186,'1','1619494200','1619496000','102','31','0'),(187,'2','1619496000','1619497800','102','31','0'),(188,'3','1619497800','1619499600','102','31','0'),(189,'4','1619499600','1619501400','102','31','0'),(190,'5','1619501400','1619503200','102','31','0'),(197,'1','1619929800','1619931600','104','32','0'),(198,'2','1619931600','1619933400','104','32','0'),(199,'3','1619933400','1619935200','104','32','0'),(200,'999','1619935200','1619938800','104','32','0'),(201,'4','1619938800','1619940600','104','32','0'),(202,'5','1619940600','1619942400','104','32','0'),(209,'1','1620099000','1620102600','106','34','0'),(210,'2','1620102600','1620106200','106','34','0'),(211,'3','1620106200','1620109800','106','34','0'),(212,'999','1620109800','1620113400','106','34','0'),(213,'4','1620113400','1620117000','106','34','0'),(214,'5','1620117000','1620120600','106','34','0'),(215,'6','1620120600','1620124200','106','34','0'),(216,'1','1624851000','1624852800','85','33','0'),(217,'2','1624852800','1624854600','85','33','0'),(218,'3','1624854600','1624856400','85','33','0'),(219,'999','1624856400','1624858200','85','33','0'),(220,'4','1624858200','1624860000','85','33','0'),(221,'5','1624860000','1624861800','85','33','0'),(222,'1','1626051600','1626053400','103','35','0'),(223,'2','1626053400','1626055200','103','35','0'),(224,'3','1626055200','1626057000','103','35','0'),(225,'4','1626057000','1626058800','103','35','0'),(226,'999','1626058800','1626060600','103','35','0'),(227,'5','1626060600','1626062400','103','35','0');

--
-- Table structure for table `demo_states`
--

CREATE TABLE `demo_states` (
  `state_id` int(11) NOT NULL,
  `state_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `country_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `demo_states`
--

INSERT INTO `demo_states` VALUES (240,'–',1),(241,'Balkh',2),(242,'Herat',2),(243,'Kabol',2),(244,'Qandahar',2),(245,'Benguela',3),(246,'Huambo',3),(247,'Luanda',3),(248,'Namibe',3),(249,'–',4),(250,'Tirana',5),(251,'Andorra la Vella',6),(252,'Curaçao',7),(253,'Abu Dhabi',8),(254,'Ajman',8),(255,'Dubai',8),(256,'Sharja',8),(257,'Buenos Aires',9),(258,'Catamarca',9),(259,'Córdoba',9),(260,'Chaco',9),(261,'Chubut',9),(262,'Corrientes',9),(263,'Distrito Federal',9),(264,'Entre Rios',9),(265,'Formosa',9),(266,'Jujuy',9),(267,'La Rioja',9),(268,'Mendoza',9),(269,'Misiones',9),(270,'Neuquén',9),(271,'Salta',9),(272,'San Juan',9),(273,'San Luis',9),(274,'Santa Fé',9),(275,'Santiago del Estero',9),(276,'Tucumán',9),(277,'Lori',10),(278,'Yerevan',10),(279,'Å irak',10),(280,'Tutuila',11),(281,'St John',14),(282,'Capital Region',15),(283,'New South Wales',15),(284,'Queensland',15),(285,'South Australia',15),(286,'Tasmania',15),(287,'Victoria',15),(288,'West Australia',15),(289,'Kärnten',16),(290,'North Austria',16),(291,'Salzburg',16),(292,'Steiermark',16),(293,'Tiroli',16),(294,'Wien',16),(295,'Baki',17),(296,'Gäncä',17),(297,'Mingäçevir',17),(298,'Sumqayit',17),(299,'Bujumbura',18),(300,'Antwerpen',19),(301,'Bryssel',19),(302,'East Flanderi',19),(303,'Hainaut',19),(304,'Liège',19),(305,'Namur',19),(306,'West Flanderi',19),(307,'Atacora',20),(308,'Atlantique',20),(309,'Borgou',20),(310,'Ouémé',20),(311,'Boulkiemdé',21),(312,'Houet',21),(313,'Kadiogo',21),(314,'Barisal',22),(315,'Chittagong',22),(316,'Dhaka',22),(317,'Khulna',22),(318,'Rajshahi',22),(319,'Sylhet',22),(320,'Burgas',23),(321,'Grad Sofija',23),(322,'Haskovo',23),(323,'Lovec',23),(324,'Plovdiv',23),(325,'Ruse',23),(326,'Varna',23),(327,'al-Manama',24),(328,'New Providence',25),(329,'Federaatio',26),(330,'Republika Srpska',26),(331,'Brest',27),(332,'Gomel',27),(333,'Grodno',27),(334,'Horad Minsk',27),(335,'Minsk',27),(336,'Mogiljov',27),(337,'Vitebsk',27),(338,'Belize City',28),(339,'Cayo',28),(340,'Hamilton',29),(341,'Saint George´s',29),(342,'Chuquisaca',30),(343,'Cochabamba',30),(344,'La Paz',30),(345,'Oruro',30),(346,'Potosí',30),(347,'Santa Cruz',30),(348,'Tarija',30),(349,'Acre',31),(350,'Alagoas',31),(351,'Amapá',31),(352,'Amazonas',31),(353,'Bahia',31),(354,'Ceará',31),(355,'Distrito Federal',31),(356,'Espírito Santo',31),(357,'Goiás',31),(358,'Maranhão',31),(359,'Mato Grosso',31),(360,'Mato Grosso do Sul',31),(361,'Minas Gerais',31),(362,'Paraíba',31),(363,'Paraná',31),(364,'Pará',31),(365,'Pernambuco',31),(366,'Piauí',31),(367,'Rio de Janeiro',31),(368,'Rio Grande do Norte',31),(369,'Rio Grande do Sul',31),(370,'Rondônia',31),(371,'Roraima',31),(372,'Santa Catarina',31),(373,'São Paulo',31),(374,'Sergipe',31),(375,'Tocantins',31),(376,'St Michael',32),(377,'Brunei and Muara',33),(378,'Thimphu',34),(379,'Francistown',36),(380,'Gaborone',36),(381,'Bangui',37),(382,'Alberta',38),(383,'British Colombia',38),(384,'Manitoba',38),(385,'Newfoundland',38),(386,'Nova Scotia',38),(387,'Ontario',38),(388,'Québec',38),(389,'Saskatchewan',38),(390,'Home Island',39),(391,'West Island',39),(392,'Basel-Stadt',40),(393,'Bern',40),(394,'Geneve',40),(395,'Vaud',40),(396,'Zürich',40),(397,'Antofagasta',41),(398,'Atacama',41),(399,'Bíobío',41),(400,'Coquimbo',41),(401,'La Araucanía',41),(402,'Los Lagos',41),(403,'Magallanes',41),(404,'Maule',41),(405,'O´Higgins',41),(406,'Santiago',41),(407,'Tarapacá',41),(408,'Valparaíso',41),(409,'Anhui',42),(410,'Chongqing',42),(411,'Fujian',42),(412,'Gansu',42),(413,'Guangdong',42),(414,'Guangxi',42),(415,'Guizhou',42),(416,'Hainan',42),(417,'Hebei',42),(418,'Heilongjiang',42),(419,'Henan',42),(420,'Hubei',42),(421,'Hunan',42),(422,'Inner Mongolia',42),(423,'Jiangsu',42),(424,'Jiangxi',42),(425,'Jilin',42),(426,'Liaoning',42),(427,'Ningxia',42),(428,'Peking',42),(429,'Qinghai',42),(430,'Shaanxi',42),(431,'Shandong',42),(432,'Shanghai',42),(433,'Shanxi',42),(434,'Sichuan',42),(435,'Tianjin',42),(436,'Tibet',42),(437,'Xinxiang',42),(438,'Yunnan',42),(439,'Zhejiang',42),(440,'Abidjan',43),(441,'Bouaké',43),(442,'Daloa',43),(443,'Korhogo',43),(444,'Yamoussoukro',43),(445,'Centre',44),(446,'Extrême-Nord',44),(447,'Littoral',44),(448,'Nord',44),(449,'Nord-Ouest',44),(450,'Ouest',44),(451,'Bandundu',0),(452,'Bas-Zaïre',0),(453,'East Kasai',0),(454,'Equateur',0),(455,'Haute-Zaïre',0),(456,'Kinshasa',0),(457,'North Kivu',0),(458,'Shaba',0),(459,'South Kivu',0),(460,'West Kasai',0),(461,'Brazzaville',46),(462,'Kouilou',46),(463,'Rarotonga',47),(464,'Antioquia',48),(465,'Atlántico',48),(466,'Bolívar',48),(467,'Boyacá',48),(468,'Caldas',48),(469,'Caquetá',48),(470,'Cauca',48),(471,'Córdoba',48),(472,'Cesar',48),(473,'Cundinamarca',48),(474,'Huila',48),(475,'La Guajira',48),(476,'Magdalena',48),(477,'Meta',48),(478,'Nariño',48),(479,'Norte de Santander',48),(480,'Quindío',48),(481,'Risaralda',48),(482,'Santafé de Bogotá',48),(483,'Santander',48),(484,'Sucre',48),(485,'Tolima',48),(486,'Valle',48),(487,'Njazidja',49),(488,'São Tiago',50),(489,'San José',51),(490,'Camagüey',52),(491,'Ciego de Ãvila',52),(492,'Cienfuegos',52),(493,'Granma',52),(494,'Guantánamo',52),(495,'Holguín',52),(496,'La Habana',52),(497,'Las Tunas',52),(498,'Matanzas',52),(499,'Pinar del Río',52),(500,'Sancti-Spíritus',52),(501,'Santiago de Cuba',52),(502,'Villa Clara',52),(503,'–',53),(504,'Grand Cayman',54),(505,'Limassol',55),(506,'Nicosia',55),(507,'Hlavní mesto Praha',56),(508,'Jizní Cechy',56),(509,'Jizní Morava',56),(510,'Severní Cechy',56),(511,'Severní Morava',56),(512,'Východní Cechy',56),(513,'Zapadní Cechy',56),(514,'Anhalt Sachsen',57),(515,'Baden-Württemberg',57),(516,'Baijeri',57),(517,'Berliini',57),(518,'Brandenburg',57),(519,'Bremen',57),(520,'Hamburg',57),(521,'Hessen',57),(522,'Mecklenburg-Vorpomme',57),(523,'Niedersachsen',57),(524,'Nordrhein-Westfalen',57),(525,'Rheinland-Pfalz',57),(526,'Saarland',57),(527,'Saksi',57),(528,'Schleswig-Holstein',57),(529,'Thüringen',57),(530,'Djibouti',58),(531,'St George',59),(532,'Århus',60),(533,'Frederiksberg',60),(534,'Fyn',60),(535,'København',60),(536,'Nordjylland',60),(537,'Distrito Nacional',61),(538,'Duarte',61),(539,'La Romana',61),(540,'Puerto Plata',61),(541,'San Pedro de Macorí',61),(542,'Santiago',61),(543,'Alger',62),(544,'Annaba',62),(545,'Batna',62),(546,'Béchar',62),(547,'Béjaïa',62),(548,'Biskra',62),(549,'Blida',62),(550,'Chlef',62),(551,'Constantine',62),(552,'Ghardaïa',62),(553,'Mostaganem',62),(554,'Oran',62),(555,'Sétif',62),(556,'Sidi Bel Abbès',62),(557,'Skikda',62),(558,'Tébessa',62),(559,'Tiaret',62),(560,'Tlemcen',62),(561,'Azuay',63),(562,'Chimborazo',63),(563,'El Oro',63),(564,'Esmeraldas',63),(565,'Guayas',63),(566,'Imbabura',63),(567,'Loja',63),(568,'Los Ríos',63),(569,'Manabí',63),(570,'Pichincha',63),(571,'Tungurahua',63),(572,'al-Buhayra',64),(573,'al-Daqahliya',64),(574,'al-Faiyum',64),(575,'al-Gharbiya',64),(576,'al-Minufiya',64),(577,'al-Minya',64),(578,'al-Qalyubiya',64),(579,'al-Sharqiya',64),(580,'Aleksandria',64),(581,'Assuan',64),(582,'Asyut',64),(583,'Bani Suwayf',64),(584,'Giza',64),(585,'Ismailia',64),(586,'Kafr al-Shaykh',64),(587,'Kairo',64),(588,'Luxor',64),(589,'Port Said',64),(590,'Qina',64),(591,'Sawhaj',64),(592,'Shamal Sina',64),(593,'Suez',64),(594,'Maekel',65),(595,'El-Aaiún',66),(596,'Andalusia',67),(597,'Aragonia',67),(598,'Asturia',67),(599,'Balears',67),(600,'Baskimaa',67),(601,'Canary Islands',67),(602,'Cantabria',67),(603,'Castilla and León',67),(604,'Extremadura',67),(605,'Galicia',67),(606,'Kastilia-La Mancha',67),(607,'Katalonia',67),(608,'La Rioja',67),(609,'Madrid',67),(610,'Murcia',67),(611,'Navarra',67),(612,'Valencia',67),(613,'Harjumaa',68),(614,'Tartumaa',68),(615,'Addis Abeba',69),(616,'Amhara',69),(617,'Dire Dawa',69),(618,'Oromia',69),(619,'Tigray',69),(620,'Newmaa',70),(621,'Päijät-Häme',70),(622,'Pirkanmaa',70),(623,'Pohjois-Pohjanmaa',70),(624,'Varsinais-Suomi',70),(625,'Central',71),(626,'East Falkland',72),(627,'Alsace',73),(628,'Aquitaine',73),(629,'Auvergne',73),(630,'Île-de-France',73),(631,'Basse-Normandie',73),(632,'Bourgogne',73),(633,'Bretagne',73),(634,'Centre',73),(635,'Champagne-Ardenne',73),(636,'Franche-Comté',73),(637,'Haute-Normandie',73),(638,'Languedoc-Roussillon',73),(639,'Limousin',73),(640,'Lorraine',73),(641,'Midi-Pyrénées',73),(642,'Nord-Pas-de-Calais',73),(643,'Pays de la Loire',73),(644,'Picardie',73),(645,'Provence-Alpes-Côte',73),(646,'Rhône-Alpes',73),(647,'Streymoyar',74),(648,'Chuuk',0),(649,'Pohnpei',0),(650,'Estuaire',76),(651,'–',77),(652,'England',77),(653,'Jersey',77),(654,'North Ireland',77),(655,'Scotland',77),(656,'Wales',77),(657,'Abhasia [Aphazeti]',78),(658,'Adzaria [Atšara]',78),(659,'Imereti',78),(660,'Kvemo Kartli',78),(661,'Tbilisi',78),(662,'Ashanti',79),(663,'Greater Accra',79),(664,'Northern',79),(665,'Western',79),(666,'–',80),(667,'Conakry',81),(668,'Basse-Terre',82),(669,'Grande-Terre',82),(670,'Banjul',83),(671,'Kombo St Mary',83),(672,'Bissau',84),(673,'Bioko',85),(674,'Attika',86),(675,'Central Macedonia',86),(676,'Crete',86),(677,'Thessalia',86),(678,'West Greece',86),(679,'St George',87),(680,'Kitaa',88),(681,'Guatemala',89),(682,'Quetzaltenango',89),(683,'Cayenne',90),(684,'–',91),(685,'Georgetown',92),(686,'Hongkong',93),(687,'Kowloon and New Kowl',93),(688,'Atlántida',95),(689,'Cortés',95),(690,'Distrito Central',95),(691,'Grad Zagreb',96),(692,'Osijek-Baranja',96),(693,'Primorje-Gorski Kota',96),(694,'Split-Dalmatia',96),(695,'Nord',97),(696,'Ouest',97),(697,'Baranya',98),(698,'Bács-Kiskun',98),(699,'Borsod-Abaúj-ZemplÃ',98),(700,'Budapest',98),(701,'Csongrád',98),(702,'Fejér',98),(703,'Györ-Moson-Sopron',98),(704,'Hajdú-Bihar',98),(705,'Szabolcs-Szatmár-Be',98),(706,'Aceh',99),(707,'Bali',99),(708,'Bengkulu',99),(709,'Central Java',99),(710,'East Java',99),(711,'Jakarta Raya',99),(712,'Jambi',99),(713,'Kalimantan Barat',99),(714,'Kalimantan Selatan',99),(715,'Kalimantan Tengah',99),(716,'Kalimantan Timur',99),(717,'Lampung',99),(718,'Molukit',99),(719,'Nusa Tenggara Barat',99),(720,'Nusa Tenggara Timur',99),(721,'Riau',99),(722,'Sulawesi Selatan',99),(723,'Sulawesi Tengah',99),(724,'Sulawesi Tenggara',99),(725,'Sulawesi Utara',99),(726,'Sumatera Barat',99),(727,'Sumatera Selatan',99),(728,'Sumatera Utara',99),(729,'West Irian',99),(730,'West Java',99),(731,'Yogyakarta',99),(732,'Andhra Pradesh',100),(733,'Assam',100),(734,'Bihar',100),(735,'Chandigarh',100),(736,'Chhatisgarh',100),(737,'Delhi',100),(738,'Gujarat',100),(739,'Haryana',100),(740,'Jammu and Kashmir',100),(741,'Jharkhand',100),(742,'Karnataka',100),(743,'Kerala',100),(744,'Madhya Pradesh',100),(745,'Maharashtra',100),(746,'Manipur',100),(747,'Meghalaya',100),(748,'Mizoram',100),(749,'Orissa',100),(750,'Pondicherry',100),(751,'Punjab',100),(752,'Rajasthan',100),(753,'Tamil Nadu',100),(754,'Tripura',100),(755,'Uttar Pradesh',100),(756,'Uttaranchal',100),(757,'West Bengal',100),(758,'Leinster',102),(759,'Munster',102),(760,'Ardebil',103),(761,'Bushehr',103),(762,'Chaharmahal va Bakht',103),(763,'East Azerbaidzan',103),(764,'Esfahan',103),(765,'Fars',103),(766,'Gilan',103),(767,'Golestan',103),(768,'Hamadan',103),(769,'Hormozgan',103),(770,'Ilam',103),(771,'Kerman',103),(772,'Kermanshah',103),(773,'Khorasan',103),(774,'Khuzestan',103),(775,'Kordestan',103),(776,'Lorestan',103),(777,'Markazi',103),(778,'Mazandaran',103),(779,'Qazvin',103),(780,'Qom',103),(781,'Semnan',103),(782,'Sistan va Baluchesta',103),(783,'Teheran',103),(784,'West Azerbaidzan',103),(785,'Yazd',103),(786,'Zanjan',103),(787,'al-Anbar',104),(788,'al-Najaf',104),(789,'al-Qadisiya',104),(790,'al-Sulaymaniya',104),(791,'al-Tamim',104),(792,'Babil',104),(793,'Baghdad',104),(794,'Basra',104),(795,'DhiQar',104),(796,'Diyala',104),(797,'Irbil',104),(798,'Karbala',104),(799,'Maysan',104),(800,'Ninawa',104),(801,'Wasit',104),(802,'Höfuðborgarsvæði',105),(803,'Ha Darom',106),(804,'Ha Merkaz',106),(805,'Haifa',106),(806,'Jerusalem',106),(807,'Tel Aviv',106),(808,'Abruzzit',107),(809,'Apulia',107),(810,'Calabria',107),(811,'Campania',107),(812,'Emilia-Romagna',107),(813,'Friuli-Venezia Giuli',107),(814,'Latium',107),(815,'Liguria',107),(816,'Lombardia',107),(817,'Marche',107),(818,'Piemonte',107),(819,'Sardinia',107),(820,'Sisilia',107),(821,'Toscana',107),(822,'Trentino-Alto Adige',107),(823,'Umbria',107),(824,'Veneto',107),(825,'St. Andrew',108),(826,'St. Catherine',108),(827,'al-Zarqa',109),(828,'Amman',109),(829,'Irbid',109),(830,'Aichi',110),(831,'Akita',110),(832,'Aomori',110),(833,'Chiba',110),(834,'Ehime',110),(835,'Fukui',110),(836,'Fukuoka',110),(837,'Fukushima',110),(838,'Gifu',110),(839,'Gumma',110),(840,'Hiroshima',110),(841,'Hokkaido',110),(842,'Hyogo',110),(843,'Ibaragi',110),(844,'Ishikawa',110),(845,'Iwate',110),(846,'Kagawa',110),(847,'Kagoshima',110),(848,'Kanagawa',110),(849,'Kochi',110),(850,'Kumamoto',110),(851,'Kyoto',110),(852,'Mie',110),(853,'Miyagi',110),(854,'Miyazaki',110),(855,'Nagano',110),(856,'Nagasaki',110),(857,'Nara',110),(858,'Niigata',110),(859,'Oita',110),(860,'Okayama',110),(861,'Okinawa',110),(862,'Osaka',110),(863,'Saga',110),(864,'Saitama',110),(865,'Shiga',110),(866,'Shimane',110),(867,'Shizuoka',110),(868,'Tochigi',110),(869,'Tokushima',110),(870,'Tokyo-to',110),(871,'Tottori',110),(872,'Toyama',110),(873,'Wakayama',110),(874,'Yamagata',110),(875,'Yamaguchi',110),(876,'Yamanashi',110),(877,'Almaty',111),(878,'Almaty Qalasy',111),(879,'Aqtöbe',111),(880,'Astana',111),(881,'Atyrau',111),(882,'East Kazakstan',111),(883,'Mangghystau',111),(884,'North Kazakstan',111),(885,'Pavlodar',111),(886,'Qaraghandy',111),(887,'Qostanay',111),(888,'Qyzylorda',111),(889,'South Kazakstan',111),(890,'Taraz',111),(891,'West Kazakstan',111),(892,'Central',112),(893,'Coast',112),(894,'Eastern',112),(895,'Nairobi',112),(896,'Nyanza',112),(897,'Rift Valley',112),(898,'Bishkek shaary',113),(899,'Osh',113),(900,'Battambang',114),(901,'Phnom Penh',114),(902,'Siem Reap',114),(903,'South Tarawa',115),(904,'St George Basseterre',116),(905,'Cheju',117),(906,'Chollabuk',117),(907,'Chollanam',117),(908,'Chungchongbuk',117),(909,'Chungchongnam',117),(910,'Inchon',117),(911,'Kang-won',117),(912,'Kwangju',117),(913,'Kyonggi',117),(914,'Kyongsangbuk',117),(915,'Kyongsangnam',117),(916,'Pusan',117),(917,'Seoul',117),(918,'Taegu',117),(919,'Taejon',117),(920,'al-Asima',118),(921,'Hawalli',118),(922,'Savannakhet',119),(923,'Viangchan',119),(924,'al-Shamal',120),(925,'Beirut',120),(926,'Montserrado',121),(927,'al-Zawiya',122),(928,'Bengasi',122),(929,'Misrata',122),(930,'Tripoli',122),(931,'Castries',123),(932,'Schaan',124),(933,'Vaduz',124),(934,'Central',125),(935,'Northern',125),(936,'Western',125),(937,'Maseru',126),(938,'Kaunas',127),(939,'Klaipeda',127),(940,'Panevezys',127),(941,'Vilna',127),(942,'Å iauliai',127),(943,'Luxembourg',128),(944,'Daugavpils',129),(945,'Liepaja',129),(946,'Riika',129),(947,'Macau',130),(948,'Casablanca',131),(949,'Chaouia-Ouardigha',131),(950,'Doukkala-Abda',131),(951,'Fès-Boulemane',131),(952,'Gharb-Chrarda-Béni',131),(953,'Marrakech-Tensift-Al',131),(954,'Meknès-Tafilalet',131),(955,'Oriental',131),(956,'Rabat-Salé-Zammour-',131),(957,'Souss Massa-Draâ',131),(958,'Tadla-Azilal',131),(959,'Tanger-Tétouan',131),(960,'Taza-Al Hoceima-Taou',131),(961,'–',132),(962,'Balti',133),(963,'Bender (Tîghina)',133),(964,'Chisinau',133),(965,'Dnjestria',133),(966,'Antananarivo',134),(967,'Fianarantsoa',134),(968,'Mahajanga',134),(969,'Toamasina',134),(970,'Maale',135),(971,'Aguascalientes',136),(972,'Baja California',136),(973,'Baja California Sur',136),(974,'Campeche',136),(975,'Chiapas',136),(976,'Chihuahua',136),(977,'Coahuila de Zaragoza',136),(978,'Colima',136),(979,'Distrito Federal',136),(980,'Durango',136),(981,'Guanajuato',136),(982,'Guerrero',136),(983,'Hidalgo',136),(984,'Jalisco',136),(985,'México',136),(986,'Michoacán de Ocampo',136),(987,'Morelos',136),(988,'Nayarit',136),(989,'Nuevo León',136),(990,'Oaxaca',136),(991,'Puebla',136),(992,'Querétaro',136),(993,'Querétaro de Arteag',136),(994,'Quintana Roo',136),(995,'San Luis Potosí',136),(996,'Sinaloa',136),(997,'Sonora',136),(998,'Tabasco',136),(999,'Tamaulipas',136),(1000,'Veracruz',136),(1001,'Veracruz-Llave',136),(1002,'Yucatán',136),(1003,'Zacatecas',136),(1004,'Majuro',137),(1005,'Skopje',138),(1006,'Bamako',139),(1007,'Inner Harbour',140),(1008,'Outer Harbour',140),(1009,'Irrawaddy [Ayeyarwad',141),(1010,'Magwe [Magway]',141),(1011,'Mandalay',141),(1012,'Mon',141),(1013,'Pegu [Bago]',141),(1014,'Rakhine',141),(1015,'Rangoon [Yangon]',141),(1016,'Sagaing',141),(1017,'Shan',141),(1018,'Tenasserim [Tanintha',141),(1019,'Ulaanbaatar',142),(1020,'Saipan',143),(1021,'Gaza',144),(1022,'Inhambane',144),(1023,'Manica',144),(1024,'Maputo',144),(1025,'Nampula',144),(1026,'Sofala',144),(1027,'Tete',144),(1028,'Zambézia',144),(1029,'Dakhlet Nouâdhibou',145),(1030,'Nouakchott',145),(1031,'Plymouth',146),(1032,'Fort-de-France',147),(1033,'Plaines Wilhelms',148),(1034,'Port-Louis',148),(1035,'Blantyre',149),(1036,'Lilongwe',149),(1037,'Johor',150),(1038,'Kedah',150),(1039,'Kelantan',150),(1040,'Negeri Sembilan',150),(1041,'Pahang',150),(1042,'Perak',150),(1043,'Pulau Pinang',150),(1044,'Sabah',150),(1045,'Sarawak',150),(1046,'Selangor',150),(1047,'Terengganu',150),(1048,'Wilayah Persekutuan',150),(1049,'Mamoutzou',151),(1050,'Khomas',152),(1051,'–',153),(1052,'Maradi',154),(1053,'Niamey',154),(1054,'Zinder',154),(1055,'–',155),(1056,'Anambra & Enugu & Eb',156),(1057,'Bauchi & Gombe',156),(1058,'Benue',156),(1059,'Borno & Yobe',156),(1060,'Cross River',156),(1061,'Edo & Delta',156),(1062,'Federal Capital Dist',156),(1063,'Imo & Abia',156),(1064,'Kaduna',156),(1065,'Kano & Jigawa',156),(1066,'Katsina',156),(1067,'Kwara & Kogi',156),(1068,'Lagos',156),(1069,'Niger',156),(1070,'Ogun',156),(1071,'Ondo & Ekiti',156),(1072,'Oyo & Osun',156),(1073,'Plateau & Nassarawa',156),(1074,'Rivers & Bayelsa',156),(1075,'Sokoto & Kebbi & Zam',156),(1076,'Chinandega',157),(1077,'León',157),(1078,'Managua',157),(1079,'Masaya',157),(1080,'–',158),(1081,'Drenthe',159),(1082,'Flevoland',159),(1083,'Gelderland',159),(1084,'Groningen',159),(1085,'Limburg',159),(1086,'Noord-Brabant',159),(1087,'Noord-Holland',159),(1088,'Overijssel',159),(1089,'Utrecht',159),(1090,'Zuid-Holland',159),(1091,'Akershus',160),(1092,'Hordaland',160),(1093,'Oslo',160),(1094,'Rogaland',160),(1095,'Sør-Trøndelag',160),(1096,'Central',161),(1097,'Eastern',161),(1098,'Western',161),(1099,'–',162),(1100,'Auckland',163),(1101,'Canterbury',163),(1102,'Dunedin',163),(1103,'Hamilton',163),(1104,'Wellington',163),(1105,'al-Batina',164),(1106,'Masqat',164),(1107,'Zufar',164),(1108,'Baluchistan',165),(1109,'Islamabad',165),(1110,'Nothwest Border Prov',165),(1111,'Punjab',165),(1112,'Sind',165),(1113,'Sindh',165),(1114,'Panamá',166),(1115,'San Miguelito',166),(1116,'–',167),(1117,'Ancash',168),(1118,'Arequipa',168),(1119,'Ayacucho',168),(1120,'Cajamarca',168),(1121,'Callao',168),(1122,'Cusco',168),(1123,'Huanuco',168),(1124,'Ica',168),(1125,'Junín',168),(1126,'La Libertad',168),(1127,'Lambayeque',168),(1128,'Lima',168),(1129,'Loreto',168),(1130,'Piura',168),(1131,'Puno',168),(1132,'Tacna',168),(1133,'Ucayali',168),(1134,'ARMM',169),(1135,'Bicol',169),(1136,'Cagayan Valley',169),(1137,'CAR',169),(1138,'Caraga',169),(1139,'Central Luzon',169),(1140,'Central Mindanao',169),(1141,'Central Visayas',169),(1142,'Eastern Visayas',169),(1143,'Ilocos',169),(1144,'National Capital Reg',169),(1145,'Northern Mindanao',169),(1146,'Southern Mindanao',169),(1147,'Southern Tagalog',169),(1148,'Western Mindanao',169),(1149,'Western Visayas',169),(1150,'Koror',170),(1151,'National Capital Dis',171),(1152,'Dolnoslaskie',172),(1153,'Kujawsko-Pomorskie',172),(1154,'Lodzkie',172),(1155,'Lubelskie',172),(1156,'Lubuskie',172),(1157,'Malopolskie',172),(1158,'Mazowieckie',172),(1159,'Opolskie',172),(1160,'Podkarpackie',172),(1161,'Podlaskie',172),(1162,'Pomorskie',172),(1163,'Slaskie',172),(1164,'Swietokrzyskie',172),(1165,'Warminsko-Mazurskie',172),(1166,'Wielkopolskie',172),(1167,'Zachodnio-Pomorskie',172),(1168,'Arecibo',173),(1169,'Bayamón',173),(1170,'Caguas',173),(1171,'Carolina',173),(1172,'Guaynabo',173),(1173,'Mayagüez',173),(1174,'Ponce',173),(1175,'San Juan',173),(1176,'Toa Baja',173),(1177,'Chagang',174),(1178,'Hamgyong N',174),(1179,'Hamgyong P',174),(1180,'Hwanghae N',174),(1181,'Hwanghae P',174),(1182,'Kaesong-si',174),(1183,'Kangwon',174),(1184,'Nampo-si',174),(1185,'Pyongan N',174),(1186,'Pyongan P',174),(1187,'Pyongyang-si',174),(1188,'Yanggang',174),(1189,'Braga',175),(1190,'Coímbra',175),(1191,'Lisboa',175),(1192,'Porto',175),(1193,'Alto Paraná',176),(1194,'Asunción',176),(1195,'Central',176),(1196,'Gaza',177),(1197,'Hebron',177),(1198,'Khan Yunis',177),(1199,'Nablus',177),(1200,'North Gaza',177),(1201,'Rafah',177),(1202,'Tahiti',178),(1203,'Doha',179),(1204,'Saint-Denis',180),(1205,'Arad',181),(1206,'Arges',181),(1207,'Bacau',181),(1208,'Bihor',181),(1209,'Botosani',181),(1210,'Braila',181),(1211,'Brasov',181),(1212,'Bukarest',181),(1213,'Buzau',181),(1214,'Caras-Severin',181),(1215,'Cluj',181),(1216,'Constanta',181),(1217,'Dâmbovita',181),(1218,'Dolj',181),(1219,'Galati',181),(1220,'Gorj',181),(1221,'Iasi',181),(1222,'Maramures',181),(1223,'Mehedinti',181),(1224,'Mures',181),(1225,'Neamt',181),(1226,'Prahova',181),(1227,'Satu Mare',181),(1228,'Sibiu',181),(1229,'Suceava',181),(1230,'Timis',181),(1231,'Tulcea',181),(1232,'Vâlcea',181),(1233,'Vrancea',181),(1234,'Adygea',182),(1235,'Altai',182),(1236,'Amur',182),(1237,'Arkangeli',182),(1238,'Astrahan',182),(1239,'Baškortostan',182),(1240,'Belgorod',182),(1241,'Brjansk',182),(1242,'Burjatia',182),(1243,'Dagestan',182),(1244,'Habarovsk',182),(1245,'Hakassia',182),(1246,'Hanti-Mansia',182),(1247,'Irkutsk',182),(1248,'Ivanovo',182),(1249,'Jaroslavl',182),(1250,'Kabardi-Balkaria',182),(1251,'Kaliningrad',182),(1252,'Kalmykia',182),(1253,'Kaluga',182),(1254,'Kamtšatka',182),(1255,'Karatšai-Tšerkessi',182),(1256,'Karjala',182),(1257,'Kemerovo',182),(1258,'Kirov',182),(1259,'Komi',182),(1260,'Kostroma',182),(1261,'Krasnodar',182),(1262,'Krasnojarsk',182),(1263,'Kurgan',182),(1264,'Kursk',182),(1265,'Lipetsk',182),(1266,'Magadan',182),(1267,'Marinmaa',182),(1268,'Mordva',182),(1269,'Moscow (City)',182),(1270,'Moskova',182),(1271,'Murmansk',182),(1272,'Nizni Novgorod',182),(1273,'North Ossetia-Alania',182),(1274,'Novgorod',182),(1275,'Novosibirsk',182),(1276,'Omsk',182),(1277,'Orenburg',182),(1278,'Orjol',182),(1279,'Penza',182),(1280,'Perm',182),(1281,'Pietari',182),(1282,'Pihkova',182),(1283,'Primorje',182),(1284,'Rjazan',182),(1285,'Rostov-na-Donu',182),(1286,'Saha (Jakutia)',182),(1287,'Sahalin',182),(1288,'Samara',182),(1289,'Saratov',182),(1290,'Smolensk',182),(1291,'Stavropol',182),(1292,'Sverdlovsk',182),(1293,'Tambov',182),(1294,'Tatarstan',182),(1295,'Tjumen',182),(1296,'Tomsk',182),(1297,'Tula',182),(1298,'Tver',182),(1299,'Tyva',182),(1300,'Tšeljabinsk',182),(1301,'Tšetšenia',182),(1302,'Tšita',182),(1303,'Tšuvassia',182),(1304,'Udmurtia',182),(1305,'Uljanovsk',182),(1306,'Vladimir',182),(1307,'Volgograd',182),(1308,'Vologda',182),(1309,'Voronez',182),(1310,'Yamalin Nenetsia',182),(1311,'Kigali',183),(1312,'al-Khudud al-Samaliy',184),(1313,'al-Qasim',184),(1314,'al-Sharqiya',184),(1315,'Asir',184),(1316,'Hail',184),(1317,'Medina',184),(1318,'Mekka',184),(1319,'Najran',184),(1320,'Qasim',184),(1321,'Riad',184),(1322,'Riyadh',184),(1323,'Tabuk',184),(1324,'al-Bahr al-Abyad',185),(1325,'al-Bahr al-Ahmar',185),(1326,'al-Jazira',185),(1327,'al-Qadarif',185),(1328,'Bahr al-Jabal',185),(1329,'Darfur al-Janubiya',185),(1330,'Darfur al-Shamaliya',185),(1331,'Kassala',185),(1332,'Khartum',185),(1333,'Kurdufan al-Shamaliy',185),(1334,'Cap-Vert',186),(1335,'Diourbel',186),(1336,'Kaolack',186),(1337,'Saint-Louis',186),(1338,'Thiès',186),(1339,'Ziguinchor',186),(1340,'–',187),(1341,'Saint Helena',189),(1342,'Länsimaa',190),(1343,'Honiara',191),(1344,'Western',192),(1345,'La Libertad',193),(1346,'San Miguel',193),(1347,'San Salvador',193),(1348,'Santa Ana',193),(1349,'San Marino',194),(1350,'Serravalle/Dogano',194),(1351,'Banaadir',195),(1352,'Jubbada Hoose',195),(1353,'Woqooyi Galbeed',195),(1354,'Saint-Pierre',196),(1355,'Aqua Grande',197),(1356,'Paramaribo',198),(1357,'Bratislava',199),(1358,'Východné Slovensko',199),(1359,'Osrednjeslovenska',200),(1360,'Podravska',200),(1361,'Örebros län',201),(1362,'East Götanmaan län',201),(1363,'Gävleborgs län',201),(1364,'Jönköpings län',201),(1365,'Lisboa',201),(1366,'Skåne län',201),(1367,'Uppsala län',201),(1368,'Västerbottens län',201),(1369,'Västernorrlands lä',201),(1370,'Västmanlands län',201),(1371,'West Götanmaan län',201),(1372,'Hhohho',202),(1373,'Mahé',203),(1374,'al-Hasaka',204),(1375,'al-Raqqa',204),(1376,'Aleppo',204),(1377,'Damascus',204),(1378,'Damaskos',204),(1379,'Dayr al-Zawr',204),(1380,'Hama',204),(1381,'Hims',204),(1382,'Idlib',204),(1383,'Latakia',204),(1384,'Grand Turk',205),(1385,'Chari-Baguirmi',206),(1386,'Logone Occidental',206),(1387,'Maritime',207),(1388,'Bangkok',208),(1389,'Chiang Mai',208),(1390,'Khon Kaen',208),(1391,'Nakhon Pathom',208),(1392,'Nakhon Ratchasima',208),(1393,'Nakhon Sawan',208),(1394,'Nonthaburi',208),(1395,'Songkhla',208),(1396,'Ubon Ratchathani',208),(1397,'Udon Thani',208),(1398,'Karotegin',209),(1399,'Khujand',209),(1400,'Fakaofo',210),(1401,'Ahal',211),(1402,'Dashhowuz',211),(1403,'Lebap',211),(1404,'Mary',211),(1405,'Dili',212),(1406,'Tongatapu',213),(1407,'Caroni',214),(1408,'Port-of-Spain',214),(1409,'Ariana',215),(1410,'Biserta',215),(1411,'Gabès',215),(1412,'Kairouan',215),(1413,'Sfax',215),(1414,'Sousse',215),(1415,'Tunis',215),(1416,'Adana',216),(1417,'Adiyaman',216),(1418,'Afyon',216),(1419,'Aksaray',216),(1420,'Ankara',216),(1421,'Antalya',216),(1422,'Aydin',216),(1423,'Çorum',216),(1424,'Balikesir',216),(1425,'Batman',216),(1426,'Bursa',216),(1427,'Denizli',216),(1428,'Diyarbakir',216),(1429,'Edirne',216),(1430,'Elâzig',216),(1431,'Erzincan',216),(1432,'Erzurum',216),(1433,'Eskisehir',216),(1434,'Gaziantep',216),(1435,'Hatay',216),(1436,'Içel',216),(1437,'Isparta',216),(1438,'Istanbul',216),(1439,'Izmir',216),(1440,'Kahramanmaras',216),(1441,'Karabük',216),(1442,'Karaman',216),(1443,'Kars',216),(1444,'Kayseri',216),(1445,'Kütahya',216),(1446,'Kilis',216),(1447,'Kirikkale',216),(1448,'Kocaeli',216),(1449,'Konya',216),(1450,'Malatya',216),(1451,'Manisa',216),(1452,'Mardin',216),(1453,'Ordu',216),(1454,'Osmaniye',216),(1455,'Sakarya',216),(1456,'Samsun',216),(1457,'Sanliurfa',216),(1458,'Siirt',216),(1459,'Sivas',216),(1460,'Tekirdag',216),(1461,'Tokat',216),(1462,'Trabzon',216),(1463,'Usak',216),(1464,'Van',216),(1465,'Zonguldak',216),(1466,'Funafuti',217),(1468,'Changhwa',218),(1469,'Chiayi',218),(1470,'Hsinchu',218),(1471,'Hualien',218),(1472,'Ilan',218),(1473,'Kaohsiung',218),(1474,'Keelung',218),(1475,'Miaoli',218),(1476,'Nantou',218),(1477,'Pingtung',218),(1478,'Taichung',218),(1479,'Tainan',218),(1480,'Taipei',218),(1481,'Taitung',218),(1482,'Taoyuan',218),(1483,'Yünlin',218),(1484,'Arusha',219),(1485,'Dar es Salaam',219),(1486,'Dodoma',219),(1487,'Kilimanjaro',219),(1488,'Mbeya',219),(1489,'Morogoro',219),(1490,'Mwanza',219),(1491,'Tabora',219),(1492,'Tanga',219),(1493,'Zanzibar West',219),(1494,'Central',220),(1495,'Dnipropetrovsk',221),(1496,'Donetsk',221),(1497,'Harkova',221),(1498,'Herson',221),(1499,'Hmelnytskyi',221),(1500,'Ivano-Frankivsk',221),(1501,'Kiova',221),(1502,'Kirovograd',221),(1503,'Krim',221),(1504,'Lugansk',221),(1505,'Lviv',221),(1506,'Mykolajiv',221),(1507,'Odesa',221),(1508,'Pultava',221),(1509,'Rivne',221),(1510,'Sumy',221),(1511,'Taka-Karpatia',221),(1512,'Ternopil',221),(1513,'Tšerkasy',221),(1514,'Tšernigiv',221),(1515,'Tšernivtsi',221),(1516,'Vinnytsja',221),(1517,'Volynia',221),(1518,'Zaporizzja',221),(1519,'Zytomyr',221),(1520,'Montevideo',223),(1521,'Alabama',224),(1522,'Alaska',224),(1523,'Arizona',224),(1524,'Arkansas',224),(1525,'California',224),(1526,'Colorado',224),(1527,'Connecticut',224),(1528,'District of Columbia',224),(1529,'Florida',224),(1530,'Georgia',224),(1531,'Hawaii',224),(1532,'Idaho',224),(1533,'Illinois',224),(1534,'Indiana',224),(1535,'Iowa',224),(1536,'Kansas',224),(1537,'Kentucky',224),(1538,'Louisiana',224),(1539,'Maryland',224),(1540,'Massachusetts',224),(1541,'Michigan',224),(1542,'Minnesota',224),(1543,'Mississippi',224),(1544,'Missouri',224),(1545,'Montana',224),(1546,'Nebraska',224),(1547,'Nevada',224),(1548,'New Hampshire',224),(1549,'New Jersey',224),(1550,'New Mexico',224),(1551,'New York',224),(1552,'North Carolina',224),(1553,'Ohio',224),(1554,'Oklahoma',224),(1555,'Oregon',224),(1556,'Pennsylvania',224),(1557,'Rhode Island',224),(1558,'South Carolina',224),(1559,'South Dakota',224),(1560,'Tennessee',224),(1561,'Texas',224),(1562,'Utah',224),(1563,'Virginia',224),(1564,'Washington',224),(1565,'Wisconsin',224),(1566,'Andijon',225),(1567,'Buhoro',225),(1568,'Cizah',225),(1569,'Fargona',225),(1570,'Karakalpakistan',225),(1571,'Khorazm',225),(1572,'Namangan',225),(1573,'Navoi',225),(1574,'Qashqadaryo',225),(1575,'Samarkand',225),(1576,'Surkhondaryo',225),(1577,'Toskent',225),(1578,'Toskent Shahri',225),(1579,'–',226),(1580,'St George',0),(1582,'Anzoátegui',228),(1583,'Apure',228),(1584,'Aragua',228),(1585,'Barinas',228),(1586,'Bolívar',228),(1587,'Carabobo',228),(1588,'Distrito Federal',228),(1589,'Falcón',228),(1590,'Guárico',228),(1591,'Lara',228),(1592,'Mérida',228),(1593,'Miranda',228),(1594,'Monagas',228),(1595,'Portuguesa',228),(1596,'Sucre',228),(1597,'Táchira',228),(1598,'Trujillo',228),(1599,'Yaracuy',228),(1600,'Zulia',228),(1601,'Tortola',229),(1602,'St Thomas',230),(1603,'An Giang',231),(1604,'Ba Ria-Vung Tau',231),(1605,'Bac Thai',231),(1606,'Binh Dinh',231),(1607,'Binh Thuan',231),(1608,'Can Tho',231),(1609,'Dac Lac',231),(1610,'Dong Nai',231),(1611,'Haiphong',231),(1612,'Hanoi',231),(1613,'Ho Chi Minh City',231),(1614,'Khanh Hoa',231),(1615,'Kien Giang',231),(1616,'Lam Dong',231),(1617,'Nam Ha',231),(1618,'Nghe An',231),(1619,'Quang Binh',231),(1620,'Quang Nam-Da Nang',231),(1621,'Quang Ninh',231),(1622,'Thua Thien-Hue',231),(1623,'Tien Giang',231),(1624,'Shefa',232),(1625,'Wallis',233),(1626,'Upolu',234),(1627,'Aden',235),(1628,'Hadramawt',235),(1629,'Hodeida',235),(1630,'Ibb',235),(1631,'Sanaa',235),(1632,'Taizz',235),(1633,'Central Serbia',236),(1634,'Kosovo and Metohija',236),(1635,'Montenegro',236),(1636,'Vojvodina',236),(1637,'Eastern Cape',237),(1638,'Free State',237),(1639,'Gauteng',237),(1640,'KwaZulu-Natal',237),(1641,'Mpumalanga',237),(1642,'North West',237),(1643,'Northern Cape',237),(1644,'Western Cape',237),(1645,'Central',238),(1646,'Copperbelt',238),(1647,'Lusaka',238),(1648,'Bulawayo',239),(1649,'Harare',239),(1650,'Manicaland',239),(1651,'Midlands',239);

--
-- Table structure for table `demo_student_order`
--

CREATE TABLE `demo_student_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  `status` varchar(10) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `location` enum('front','back') DEFAULT NULL,
  `field_name` varchar(50) DEFAULT NULL,
  `show_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `demo_student_order`
--

INSERT INTO `demo_student_order` VALUES (2,'First Name','1',2,'front','First Name','first_name'),(3,'Last Name','1',3,'front','Last Name','last_name'),(4,'Mobile Number','1',4,'front','Mobile Number','mobile'),(5,'Email Id','1',7,'back','Email Id','email'),(6,'Father Name','1',5,'back','Father Name','father_name'),(7,'Mother Name','1',6,'back','Mother Name','mother_name');

--
-- Table structure for table `demo_student_verification`
--

CREATE TABLE `demo_student_verification` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) DEFAULT NULL,
  `random_id` varchar(50) DEFAULT NULL,
  `status` enum('used','not used') DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_student_verification`
--

INSERT INTO `demo_student_verification` VALUES (1,138,'555555701','used'),(2,139,'1881173865','used'),(3,142,'1354704596','used'),(4,142,'1107324142','used'),(5,149,'642293444','not used'),(6,150,'911242545','used'),(7,731,'600426397','used'),(8,731,'1150163917','not used'),(9,734,'1385744889','used'),(10,748,'1080967066','used'),(11,748,'532369220','not used'),(12,755,'394049327','used'),(13,145,'418097156','used'),(14,748,'628431326','used'),(15,748,'287880198','not used'),(16,748,'1456645043','not used'),(17,748,'966135802','not used'),(18,748,'956502183','not used'),(19,748,'464535079','not used'),(20,748,'47584446','not used'),(21,749,'1716931927','not used'),(22,749,'255603355','used'),(23,755,'808046256','used'),(24,771,'1849849931','used'),(25,771,'1142800853','used'),(26,771,'1967728076','used'),(27,773,'1813835798','used'),(28,773,'517376931','used'),(29,773,'424316959','not used'),(30,773,'382268092','not used'),(31,773,'1421236877','used');

--
-- Table structure for table `demo_student_work_description`
--

CREATE TABLE `demo_student_work_description` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `work_description_id` int(11) DEFAULT NULL,
  `teacher_id` int(11) DEFAULT NULL,
  `student_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `created` int(11) DEFAULT NULL,
  `modified` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=365 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_student_work_description`
--

INSERT INTO `demo_student_work_description` VALUES (1,2,157,131,164,1613327400,NULL),(2,2,157,130,165,1613327400,NULL),(3,2,157,129,166,1613327400,NULL),(4,2,157,128,167,1613327400,NULL),(5,2,157,127,168,1613327400,NULL),(8,4,148,131,164,1613500200,NULL),(9,4,148,130,165,1613500200,NULL),(10,4,148,129,166,1613500200,NULL),(11,4,148,128,167,1613500200,NULL),(12,4,148,127,168,1613500200,NULL),(15,5,157,131,164,1613500200,NULL),(16,5,157,130,165,1613500200,NULL),(17,5,157,129,166,1613500200,NULL),(18,5,157,128,167,1613500200,NULL),(19,5,157,127,168,1613500200,NULL),(22,6,158,131,164,1613500200,NULL),(23,6,158,130,165,1613500200,NULL),(24,6,158,129,166,1613500200,NULL),(25,6,158,128,167,1613500200,NULL),(26,6,158,127,168,1613500200,NULL),(29,7,151,131,164,1613500200,NULL),(30,7,151,130,165,1613500200,NULL),(31,7,151,129,166,1613500200,NULL),(32,7,151,128,167,1613500200,NULL),(33,7,151,127,168,1613500200,NULL),(34,11,145,131,164,1616005800,NULL),(35,11,145,130,165,1616005800,NULL),(36,11,145,129,166,1616005800,NULL),(37,11,145,128,167,1616005800,NULL),(38,11,145,127,168,1616005800,NULL),(39,11,145,142,177,1616005800,NULL),(41,13,157,131,164,1616092200,NULL),(42,13,157,130,165,1616092200,NULL),(43,13,157,129,166,1616092200,NULL),(44,13,157,128,167,1616092200,NULL),(45,13,157,127,168,1616092200,NULL),(46,13,157,142,177,1616092200,NULL),(47,22,211,781,241,1619548200,NULL),(48,22,211,782,242,1619548200,NULL),(49,22,211,789,250,1619548200,NULL),(50,23,216,781,241,1619548200,NULL),(51,23,216,782,242,1619548200,NULL),(52,23,216,789,250,1619548200,NULL),(53,24,216,748,212,1619634600,NULL),(54,24,216,753,221,1619634600,NULL),(55,24,216,754,223,1619634600,NULL),(56,24,216,770,230,1619634600,NULL),(57,24,216,771,231,1619634600,NULL),(58,24,216,772,232,1619634600,NULL),(59,24,216,773,233,1619634600,NULL),(60,24,216,774,234,1619634600,NULL),(61,24,216,775,235,1619634600,NULL),(62,24,216,777,237,1619634600,NULL),(63,24,216,778,238,1619634600,NULL),(64,24,216,779,239,1619634600,NULL),(65,24,216,780,240,1619634600,NULL),(66,24,216,783,243,1619634600,NULL),(67,24,216,784,244,1619634600,NULL),(68,24,216,785,245,1619634600,NULL),(69,24,216,787,248,1619634600,NULL),(70,24,216,788,249,1619634600,NULL),(84,25,216,748,212,1619634600,NULL),(85,25,216,753,221,1619634600,NULL),(86,25,216,754,223,1619634600,NULL),(87,25,216,770,230,1619634600,NULL),(88,25,216,771,231,1619634600,NULL),(89,25,216,772,232,1619634600,NULL),(90,25,216,773,233,1619634600,NULL),(91,25,216,774,234,1619634600,NULL),(92,25,216,775,235,1619634600,NULL),(93,25,216,777,237,1619634600,NULL),(94,25,216,778,238,1619634600,NULL),(95,25,216,779,239,1619634600,NULL),(96,25,216,780,240,1619634600,NULL),(97,25,216,783,243,1619634600,NULL),(98,25,216,784,244,1619634600,NULL),(99,25,216,785,245,1619634600,NULL),(100,25,216,787,248,1619634600,NULL),(101,25,216,788,249,1619634600,NULL),(115,26,216,748,212,1619634600,NULL),(116,26,216,753,221,1619634600,NULL),(117,26,216,754,223,1619634600,NULL),(118,26,216,770,230,1619634600,NULL),(119,26,216,771,231,1619634600,NULL),(120,26,216,772,232,1619634600,NULL),(121,26,216,773,233,1619634600,NULL),(122,26,216,774,234,1619634600,NULL),(123,26,216,775,235,1619634600,NULL),(124,26,216,777,237,1619634600,NULL),(125,26,216,778,238,1619634600,NULL),(126,26,216,779,239,1619634600,NULL),(127,26,216,780,240,1619634600,NULL),(128,26,216,783,243,1619634600,NULL),(129,26,216,784,244,1619634600,NULL),(130,26,216,785,245,1619634600,NULL),(131,26,216,787,248,1619634600,NULL),(132,26,216,788,249,1619634600,NULL),(146,28,211,748,212,1619807400,NULL),(147,28,211,753,221,1619807400,NULL),(148,28,211,754,223,1619807400,NULL),(149,28,211,770,230,1619807400,NULL),(150,28,211,771,231,1619807400,NULL),(151,28,211,772,232,1619807400,NULL),(152,28,211,773,233,1619807400,NULL),(153,28,211,774,234,1619807400,NULL),(154,28,211,775,235,1619807400,NULL),(155,28,211,777,237,1619807400,NULL),(156,28,211,778,238,1619807400,NULL),(157,28,211,779,239,1619807400,NULL),(158,28,211,780,240,1619807400,NULL),(159,28,211,783,243,1619807400,NULL),(160,28,211,784,244,1619807400,NULL),(161,28,211,785,245,1619807400,NULL),(162,28,211,787,248,1619807400,NULL),(163,28,211,788,249,1619807400,NULL),(164,28,211,793,258,1619807400,NULL),(165,28,211,798,263,1619807400,NULL),(177,31,255,790,253,1619980200,NULL),(178,31,255,791,256,1619980200,NULL),(179,31,255,792,257,1619980200,NULL),(180,31,255,799,264,1619980200,NULL),(181,31,255,800,265,1619980200,NULL),(182,31,255,801,266,1619980200,NULL),(184,32,255,790,253,1619980200,NULL),(185,32,255,791,256,1619980200,NULL),(186,32,255,792,257,1619980200,NULL),(187,32,255,799,264,1619980200,NULL),(188,32,255,800,265,1619980200,NULL),(189,32,255,801,266,1619980200,NULL),(191,34,255,790,253,1619980200,NULL),(192,34,255,791,256,1619980200,NULL),(193,34,255,792,257,1619980200,NULL),(194,34,255,799,264,1619980200,NULL),(195,34,255,800,265,1619980200,NULL),(196,34,255,801,266,1619980200,NULL),(198,35,255,790,253,1619980200,NULL),(199,35,255,791,256,1619980200,NULL),(200,35,255,792,257,1619980200,NULL),(201,35,255,799,264,1619980200,NULL),(202,35,255,800,265,1619980200,NULL),(203,35,255,801,266,1619980200,NULL),(205,36,213,748,212,1620066600,NULL),(206,36,213,753,221,1620066600,NULL),(207,36,213,754,223,1620066600,NULL),(208,36,213,770,230,1620066600,NULL),(209,36,213,771,231,1620066600,NULL),(210,36,213,772,232,1620066600,NULL),(211,36,213,773,233,1620066600,NULL),(212,36,213,774,234,1620066600,NULL),(213,36,213,775,235,1620066600,NULL),(214,36,213,777,237,1620066600,NULL),(215,36,213,778,238,1620066600,NULL),(216,36,213,779,239,1620066600,NULL),(217,36,213,780,240,1620066600,NULL),(218,36,213,783,243,1620066600,NULL),(219,36,213,784,244,1620066600,NULL),(220,36,213,785,245,1620066600,NULL),(221,36,213,787,248,1620066600,NULL),(222,36,213,788,249,1620066600,NULL),(223,36,213,793,258,1620066600,NULL),(224,36,213,798,263,1620066600,NULL),(236,37,213,748,212,1620066600,NULL),(237,37,213,753,221,1620066600,NULL),(238,37,213,754,223,1620066600,NULL),(239,37,213,770,230,1620066600,NULL),(240,37,213,771,231,1620066600,NULL),(241,37,213,772,232,1620066600,NULL),(242,37,213,773,233,1620066600,NULL),(243,37,213,774,234,1620066600,NULL),(244,37,213,775,235,1620066600,NULL),(245,37,213,777,237,1620066600,NULL),(246,37,213,778,238,1620066600,NULL),(247,37,213,779,239,1620066600,NULL),(248,37,213,780,240,1620066600,NULL),(249,37,213,783,243,1620066600,NULL),(250,37,213,784,244,1620066600,NULL),(251,37,213,785,245,1620066600,NULL),(252,37,213,787,248,1620066600,NULL),(253,37,213,788,249,1620066600,NULL),(254,37,213,793,258,1620066600,NULL),(255,37,213,798,263,1620066600,NULL),(267,38,269,802,271,1620153000,NULL),(268,38,269,803,272,1620153000,NULL),(269,38,269,804,273,1620153000,NULL),(270,38,269,805,274,1620153000,NULL),(274,39,269,802,271,1620066600,NULL),(275,39,269,803,272,1620066600,NULL),(276,39,269,804,273,1620066600,NULL),(277,39,269,805,274,1620066600,NULL),(281,40,269,802,271,1620153000,NULL),(282,40,269,803,272,1620153000,NULL),(283,40,269,804,273,1620153000,NULL),(284,40,269,805,274,1620153000,NULL),(288,41,270,802,271,1620153000,NULL),(289,41,270,803,272,1620153000,NULL),(290,41,270,804,273,1620153000,NULL),(291,41,270,805,274,1620153000,NULL),(295,42,270,802,271,1620153000,NULL),(296,42,270,803,272,1620153000,NULL),(297,42,270,804,273,1620153000,NULL),(298,42,270,805,274,1620153000,NULL),(302,43,211,748,212,1620844200,NULL),(303,43,211,753,221,1620844200,NULL),(304,43,211,754,223,1620844200,NULL),(305,43,211,770,230,1620844200,NULL),(306,43,211,771,231,1620844200,NULL),(307,43,211,772,232,1620844200,NULL),(308,43,211,773,233,1620844200,NULL),(309,43,211,774,234,1620844200,NULL),(310,43,211,775,235,1620844200,NULL),(311,43,211,777,237,1620844200,NULL),(312,43,211,778,238,1620844200,NULL),(313,43,211,779,239,1620844200,NULL),(314,43,211,780,240,1620844200,NULL),(315,43,211,783,243,1620844200,NULL),(316,43,211,784,244,1620844200,NULL),(317,43,211,785,245,1620844200,NULL),(318,43,211,787,248,1620844200,NULL),(319,43,211,788,249,1620844200,NULL),(320,43,211,793,258,1620844200,NULL),(321,43,211,798,263,1620844200,NULL),(333,44,216,748,212,1620844200,NULL),(334,44,216,753,221,1620844200,NULL),(335,44,216,754,223,1620844200,NULL),(336,44,216,770,230,1620844200,NULL),(337,44,216,771,231,1620844200,NULL),(338,44,216,772,232,1620844200,NULL),(339,44,216,773,233,1620844200,NULL),(340,44,216,774,234,1620844200,NULL),(341,44,216,775,235,1620844200,NULL),(342,44,216,777,237,1620844200,NULL),(343,44,216,778,238,1620844200,NULL),(344,44,216,779,239,1620844200,NULL),(345,44,216,780,240,1620844200,NULL),(346,44,216,783,243,1620844200,NULL),(347,44,216,784,244,1620844200,NULL),(348,44,216,785,245,1620844200,NULL),(349,44,216,787,248,1620844200,NULL),(350,44,216,788,249,1620844200,NULL),(351,44,216,793,258,1620844200,NULL),(352,44,216,798,263,1620844200,NULL),(364,45,216,806,275,1620844200,NULL);

--
-- Table structure for table `demo_subject_list`
--

CREATE TABLE `demo_subject_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `teacher_id` varchar(50) DEFAULT NULL,
  `subject_id` varchar(50) DEFAULT NULL,
  `delete_status` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=368 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_subject_list`
--

INSERT INTO `demo_subject_list` VALUES (324,'142','29','0'),(326,'146','31','0'),(327,'157','34','0'),(328,'158','35','0'),(329,'147','32','0'),(330,'148','33','0'),(331,'149','36','0'),(332,'150','37','0'),(333,'151','38','0'),(334,'187','39','0'),(335,'191','40','0'),(336,'183','40','0'),(339,'145','30','0'),(342,'141','32','0'),(343,'193','43','0'),(345,'213','45','0'),(347,'215','48','0'),(348,'214','47','0'),(349,'222','29','0'),(350,'228','45','0'),(353,'229','47','0'),(354,'200','47','0'),(355,'211','44','0'),(356,'211','58','0'),(357,'216','37','0'),(358,'216','46','0'),(359,'252','30','0'),(362,'255','60','0'),(363,'254','59','0'),(364,'268','61','0'),(365,'267','62','0'),(366,'270','45','0'),(367,'269','44','0');

--
-- Table structure for table `demo_supplier`
--

CREATE TABLE `demo_supplier` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `demo_supplier`
--


--
-- Table structure for table `demo_teacher_class_section_list`
--

CREATE TABLE `demo_teacher_class_section_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `teacher_id` varchar(50) DEFAULT NULL,
  `class_id` varchar(50) DEFAULT NULL,
  `section_id` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `demo_teacher_class_section_list`
--

INSERT INTO `demo_teacher_class_section_list` VALUES (21,'147','0','0'),(23,'208','79','20'),(25,'229','94','0'),(26,'228','94','24'),(27,'213','89','24'),(29,'200','63','0'),(30,'211','92','24'),(31,'254','104','24'),(32,'269','106','24'),(33,'145','74','14');

--
-- Table structure for table `demo_teacher_list`
--

CREATE TABLE `demo_teacher_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `teacher_id` varchar(255) DEFAULT NULL,
  `class_id` varchar(255) DEFAULT NULL,
  `delete_status` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=971 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `demo_teacher_list`
--

INSERT INTO `demo_teacher_list` VALUES (673,'141','64',NULL),(674,'142','64',NULL),(675,'145','64',NULL),(676,'146','64',NULL),(677,'147','64',NULL),(683,'141','65',NULL),(684,'145','65',NULL),(685,'146','65',NULL),(686,'147','65',NULL),(687,'142','65',NULL),(694,'141','66',NULL),(695,'145','66',NULL),(696,'146','66',NULL),(697,'147','66',NULL),(698,'142','66',NULL),(699,'141','67',NULL),(700,'145','67',NULL),(701,'146','67',NULL),(702,'147','67',NULL),(703,'142','67',NULL),(722,'141','71',NULL),(723,'145','71',NULL),(724,'147','71',NULL),(725,'148','71',NULL),(726,'149','71',NULL),(727,'157','71',NULL),(728,'158','71',NULL),(729,'142','71',NULL),(752,'158','76','1'),(761,'186','80','0'),(763,'190','82','0'),(769,'192','83','1'),(772,'183','78',NULL),(773,'191','78',NULL),(774,'194','78',NULL),(775,'187','81',NULL),(776,'188','81',NULL),(777,'189','81',NULL),(778,'193','81',NULL),(798,'141','84','1'),(799,'141','85','1'),(800,'142','86','1'),(809,'189','87','1'),(829,'141','63','1'),(830,'146','63','1'),(831,'142','63','1'),(832,'145','63','1'),(833,'147','63','1'),(844,'184','79','1'),(845,'185','79','1'),(847,'141','88',NULL),(848,'148','74',NULL),(849,'151','74',NULL),(850,'158','74',NULL),(851,'157','74',NULL),(852,'222','74',NULL),(853,'145','74',NULL),(855,'222','70',NULL),(857,'141','73','1'),(858,'148','73','1'),(859,'149','73','1'),(860,'150','73','1'),(861,'158','73','1'),(862,'157','73','1'),(863,'222','73','1'),(871,'141','68',NULL),(872,'148','68',NULL),(873,'142','68',NULL),(874,'145','68',NULL),(875,'147','68',NULL),(876,'141','90','1'),(878,'141','91','1'),(894,'149','95','1'),(895,'141','96','1'),(896,'141','97','1'),(908,'149','98','1'),(910,'149','99','1'),(912,'141','100','1'),(914,'141','101','1'),(918,'215','94',NULL),(919,'229','94',NULL),(920,'228','94',NULL),(932,'141','92',NULL),(933,'216','92',NULL),(934,'211','92',NULL),(938,'216','102',NULL),(939,'252','102',NULL),(940,'141','69',NULL),(941,'142','69',NULL),(942,'145','69',NULL),(943,'147','69',NULL),(947,'254','103','1'),(948,'255','103','1'),(951,'254','104',NULL),(952,'255','104',NULL),(955,'269','106','1'),(956,'270','106','1'),(957,'268','107','0'),(958,'267','105',NULL),(959,'268','105',NULL),(960,'214','89',NULL),(961,'215','89',NULL),(962,'216','89',NULL),(963,'268','89',NULL),(964,'211','89',NULL),(965,'213','89',NULL),(966,'141','108','0'),(967,'142','108','0'),(968,'149','108','0'),(969,'141','72',NULL),(970,'142','72',NULL);

--
-- Table structure for table `demo_teacher_mentor`
--

CREATE TABLE `demo_teacher_mentor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `teacher_id` varchar(50) DEFAULT NULL,
  `std_id` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_teacher_mentor`
--

INSERT INTO `demo_teacher_mentor` VALUES (1,'185','138'),(25,'142','745'),(50,'208','150'),(51,'208','680'),(52,'208','732'),(53,'208','735'),(54,'208','741'),(55,'208','745'),(56,'141','128'),(57,'141','745'),(58,'141','747'),(59,'183','735'),(60,'193','731'),(65,'213','751'),(84,'214','752'),(88,'145','127'),(89,'145','128'),(90,'145','744'),(91,'145','750'),(97,'229','747'),(98,'157','754'),(99,'200','127'),(100,'200','128'),(101,'200','129'),(102,'200','148'),(103,'200','771'),(104,'200','752'),(105,'215','128'),(106,'215','748'),(107,'215','752'),(108,'215','753'),(109,'215','752'),(110,'216','748'),(111,'216','782'),(112,'211','751'),(113,'211','789'),(114,'269','802'),(115,'269','803');

--
-- Table structure for table `demo_teacher_registration`
--

CREATE TABLE `demo_teacher_registration` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_teacher_registration`
--


--
-- Table structure for table `demo_temporary_timetable`
--

CREATE TABLE `demo_temporary_timetable` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `timetable_id` int(11) DEFAULT NULL,
  `period_id` int(11) DEFAULT NULL,
  `week_id` int(11) DEFAULT NULL,
  `teacher_id` int(11) DEFAULT NULL,
  `class_id` int(11) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `subject_id` int(11) DEFAULT NULL,
  `start_time` varchar(50) DEFAULT NULL,
  `end_time` varchar(50) DEFAULT NULL,
  `leaveList_id` int(11) DEFAULT NULL,
  `status` enum('pending','requested','accepted','rejected') DEFAULT NULL,
  `delete_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `demo_temporary_timetable`
--

INSERT INTO `demo_temporary_timetable` VALUES (6,31,129,5,145,74,14,30,'1612936800','1612938600',10,'pending',0),(26,101,113,1,145,73,14,39,'1612924200','1612926000',53,'requested',0),(27,64,126,1,145,74,14,40,'1612931400','1612933200',53,'requested',0),(28,96,123,2,145,74,15,40,'1612926000','1612927800',53,'requested',0),(29,102,116,2,146,73,14,31,'1612929600','1612931400',53,'requested',0),(30,99,126,2,146,74,16,31,'1612931400','1612933200',53,'requested',0),(31,103,110,2,145,72,14,40,'1616648400','1616652000',53,'requested',0),(32,62,130,3,146,74,14,31,'1614234600','1614236400',53,'requested',0),(37,105,114,3,145,73,14,30,'1612926000','1612927800',69,'pending',0),(38,104,112,3,145,72,14,30,'1616653800','1616655600',69,'pending',0),(39,97,126,3,145,74,15,30,'1612931400','1612933200',69,'pending',0),(40,109,124,5,145,74,14,30,'1612927800','1612929600',69,'pending',0),(41,95,106,5,145,72,15,30,'1612926000','1612927800',69,'pending',0),(42,137,105,5,145,72,14,30,'1612924200','1612926000',69,'pending',0),(48,68,108,3,149,72,15,36,'1612929600','1612931400',71,'pending',1),(49,146,110,3,149,72,14,36,'1616648400','1616652000',72,'pending',0),(51,161,169,2,145,89,24,30,'1616652000','1616653800',97,'accepted',1),(60,165,166,3,157,89,24,34,'1616646600','1616648400',110,'accepted',0),(62,128,105,2,157,72,14,34,'1612924200','1612926000',112,'pending',0),(63,112,125,3,157,74,16,34,'1612929600','1612931400',113,'requested',0),(65,165,166,3,141,89,24,32,'1616646600','1616648400',94,'pending',0),(66,212,165,5,145,89,24,30,'1616644800','1616646600',118,'requested',0),(67,211,166,5,145,89,24,30,'1616646600','1616648400',118,'requested',0),(68,157,168,1,157,89,24,34,'1616650200','1616652000',119,'pending',1),(70,171,120,2,157,73,14,34,'1612936800','1612938600',124,'accepted',0),(71,169,129,3,158,74,14,35,'1612936800','1612938600',124,'requested',0),(73,234,202,1,254,104,24,59,'1619940600','1619942400',139,'pending',0),(75,237,198,2,254,104,24,59,'1619931600','1619933400',140,'pending',0),(78,156,166,1,228,89,24,45,'1616646600','1616648400',158,'accepted',1),(82,251,209,1,270,106,24,45,'1620099000','1620102600',161,'accepted',1),(83,253,211,2,270,106,24,45,'1620106200','1620109800',161,'accepted',1),(88,252,215,1,269,106,24,44,'1620120600','1620124200',166,'accepted',1),(90,252,215,1,269,106,24,44,'1620120600','1620124200',167,'accepted',0),(91,254,214,2,269,106,24,44,'1620117000','1620120600',167,'accepted',0),(92,135,105,3,270,72,14,45,'1612924200','1612926000',168,'pending',1),(93,138,111,5,270,72,14,45,'1616652000','1616653800',170,'pending',0),(94,138,111,5,270,72,14,45,'1616652000','1616653800',171,'pending',0),(95,254,214,2,157,106,24,34,'1620117000','1620120600',172,'accepted',0),(96,255,209,3,157,106,24,34,'1620099000','1620102600',172,'accepted',0),(97,258,215,4,270,106,24,45,'1620120600','1620124200',174,'pending',0);

--
-- Table structure for table `demo_temporary_timetable_history`
--

CREATE TABLE `demo_temporary_timetable_history` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `timetable_id` int(11) DEFAULT NULL,
  `period_id` int(11) DEFAULT NULL,
  `week_id` int(11) DEFAULT NULL,
  `teacher_id` int(11) DEFAULT NULL,
  `class_id` int(11) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `subject_id` int(11) DEFAULT NULL,
  `start_time` varchar(50) DEFAULT NULL,
  `end_time` varchar(50) DEFAULT NULL,
  `leaveList_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `demo_temporary_timetable_history`
--

INSERT INTO `demo_temporary_timetable_history` VALUES (1,11,124,3,158,74,14,35,'1612927800','1612929600',2),(2,24,128,6,147,74,16,32,'1612935000','1612936800',12),(3,22,128,5,147,74,15,32,'1612935000','1612936800',14),(4,51,93,5,149,71,15,36,'1612931400','1612933200',19),(5,84,107,5,158,72,15,35,'1612927800','1612929600',47),(6,167,169,3,145,89,24,30,'1616652000','1616653800',107),(7,179,176,3,157,94,24,34,'1618119000','1618120800',110),(8,67,127,5,157,74,14,34,'1612933200','1612935000',115),(9,161,169,2,145,89,24,30,'1616652000','1616653800',106),(10,176,173,1,229,94,24,47,'1618113600','1618115400',158),(11,256,212,3,270,106,24,45,'1620109800','1620113400',161),(12,254,214,2,269,106,24,44,'1620117000','1620120600',166);

--
-- Table structure for table `demo_timetable`
--

CREATE TABLE `demo_timetable` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `period_id` int(11) DEFAULT NULL,
  `week_id` int(11) DEFAULT NULL,
  `teacher_id` int(11) DEFAULT NULL,
  `class_id` int(11) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `subject_id` int(11) DEFAULT NULL,
  `start_time` int(11) DEFAULT NULL,
  `end_time` int(11) DEFAULT NULL,
  `adjustment` int(11) DEFAULT NULL,
  `custom_table_id` int(11) DEFAULT NULL,
  `adjusted_lecture` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=281 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_timetable`
--

INSERT INTO `demo_timetable` VALUES (13,127,3,148,74,14,33,1612933200,1612935000,0,0,0),(16,126,4,148,74,14,34,1612931400,1612933200,0,0,0),(20,128,4,148,74,15,30,1612935000,1612936800,0,0,0),(22,128,5,148,74,15,30,1612935000,1612936800,0,0,0),(24,128,6,148,74,16,30,1612935000,1612936800,0,0,0),(28,126,1,148,74,15,29,1612931400,1612933200,0,0,0),(30,130,1,148,74,14,35,1613370600,1613374200,0,0,0),(39,108,5,148,72,14,28,1612929600,1612931400,0,0,0),(40,111,6,148,72,14,28,1616652000,1616653800,0,0,0),(42,89,1,149,71,14,36,1612924200,1612926000,0,0,0),(43,91,2,149,71,14,36,1612927800,1612929600,0,0,0),(45,93,3,142,71,14,29,1612931400,1612933200,0,0,0),(49,98,5,142,71,14,29,1612926000,1612927800,0,0,0),(50,93,4,142,71,15,29,1612931400,1612933200,0,0,0),(51,93,5,142,71,15,29,1612931400,1612933200,0,0,0),(52,94,5,149,71,14,36,1612933200,1612935000,0,0,0),(56,96,6,149,71,15,36,1612936800,1612938600,0,0,0),(57,97,2,149,71,15,36,1612924200,1612926000,0,0,0),(60,90,2,149,71,15,36,1612926000,1612927800,0,0,0),(62,130,3,157,74,14,34,1614234600,1614236400,0,0,0),(63,126,6,157,74,14,34,1612931400,1612933200,0,0,0),(64,126,1,157,74,14,34,1612931400,1612933200,0,0,0),(65,122,4,145,74,14,30,1612924200,1612926000,0,0,0),(66,124,1,145,74,14,30,1612927800,1612929600,0,0,0),(67,127,5,145,74,14,30,1612933200,1612935000,0,0,0),(68,108,3,141,72,15,28,1612929600,1612931400,0,0,0),(69,108,6,157,72,15,34,1612929600,1612931400,0,0,0),(70,112,4,158,72,15,35,1616653800,1616655600,0,0,0),(71,112,1,141,72,14,28,1616653800,1616655600,0,0,0),(72,150,1,187,81,20,39,1615597200,1615599000,0,0,0),(73,150,3,187,81,20,39,1615597200,1615599000,0,0,0),(74,150,6,187,81,20,39,1615597200,1615599000,0,0,0),(80,123,4,142,74,15,29,1612926000,1612927800,0,0,0),(82,105,4,157,72,15,34,1612924200,1612926000,0,0,0),(83,110,4,157,72,15,34,1616648400,1616652000,0,0,0),(86,109,4,158,72,14,35,1612931400,1612933200,0,0,0),(94,105,4,142,72,16,29,1612924200,1612926000,0,0,0),(95,106,5,158,72,15,35,1612926000,1612927800,0,0,0),(96,123,2,157,74,15,34,1612926000,1612927800,0,0,0),(97,126,3,158,74,15,35,1612931400,1612933200,0,0,0),(99,126,2,157,74,16,34,1612931400,1612933200,0,0,0),(100,122,2,158,74,16,35,1612924200,1612926000,0,0,0),(101,113,1,157,73,14,34,1612924200,1612926000,0,0,0),(102,116,2,157,73,14,34,1612929600,1612931400,0,0,0),(104,112,3,158,72,14,35,1616653800,1616655600,0,0,0),(105,114,3,158,73,14,35,1612926000,1612927800,0,0,0),(106,130,2,158,74,14,35,1614234600,1614236400,0,0,0),(107,128,2,158,74,14,35,1612935000,1612936800,0,0,0),(109,124,5,158,74,14,35,1612927800,1612929600,0,0,0),(110,129,5,157,74,14,34,1612936800,1612938600,0,0,0),(111,125,2,145,74,15,30,1612929600,1612931400,0,0,0),(112,125,3,145,74,16,30,1612929600,1612931400,0,0,0),(113,146,1,183,78,20,40,1615599000,1615600800,0,0,0),(114,147,2,183,78,20,40,1615600800,1615602600,0,0,0),(115,148,3,183,78,20,40,1615602600,1615604400,0,0,0),(116,144,4,191,78,20,40,1615595400,1615597200,0,0,0),(117,146,5,191,78,20,40,1615599000,1615600800,0,0,0),(118,148,6,191,78,20,40,1615602600,1615604400,0,0,0),(122,110,1,148,72,14,33,1616648400,1616652000,0,0,0),(123,109,1,158,72,14,35,1612931400,1612933200,0,0,0),(125,107,1,157,72,14,34,1612927800,1612929600,0,0,0),(126,106,1,142,72,14,29,1612926000,1612927800,0,0,0),(127,105,1,145,72,14,30,1612924200,1612926000,0,0,0),(128,105,2,145,72,14,30,1612924200,1612926000,0,0,0),(129,106,2,142,72,14,29,1612926000,1612927800,0,0,0),(130,107,2,157,72,14,34,1612927800,1612929600,0,0,0),(131,109,2,158,72,14,35,1612931400,1612933200,0,0,0),(132,110,2,148,72,14,33,1616648400,1616652000,0,0,0),(134,112,2,141,72,14,28,1616653800,1616655600,0,0,0),(135,105,3,157,72,14,34,1612924200,1612926000,0,0,0),(137,105,5,158,72,14,35,1612924200,1612926000,0,0,0),(138,111,5,157,72,14,34,1616652000,1616653800,0,0,0),(139,106,6,158,72,14,35,1612926000,1612927800,0,0,0),(140,110,6,157,72,14,34,1616648400,1616652000,0,0,0),(146,110,3,141,72,14,32,1616648400,1616652000,0,0,0),(147,111,4,141,72,14,32,1616652000,1616653800,0,0,0),(148,111,2,141,72,15,32,1616652000,1616653800,0,0,0),(149,164,1,211,89,24,44,1616643000,1616644800,0,0,0),(151,167,4,211,89,24,44,1616648400,1616650200,0,0,0),(152,169,1,213,89,24,45,1616652000,1616653800,0,0,0),(155,165,1,214,89,24,47,1616644800,1616646600,0,0,0),(156,166,1,215,89,24,48,1616646600,1616648400,0,0,0),(157,168,1,216,89,24,46,1616650200,1616652000,0,0,0),(158,164,2,214,89,24,47,1616643000,1616644800,0,0,0),(159,168,2,215,89,24,48,1616650200,1616652000,0,0,0),(160,166,2,216,89,24,46,1616646600,1616648400,0,0,0),(161,169,2,213,89,24,45,1616652000,1616653800,0,0,0),(162,165,2,211,89,24,44,1616644800,1616646600,0,0,0),(163,164,3,211,89,24,44,1616643000,1616644800,0,0,0),(164,165,3,214,89,24,47,1616644800,1616646600,0,0,0),(165,166,3,215,89,24,48,1616646600,1616648400,0,0,0),(166,168,3,216,89,24,46,1616650200,1616652000,0,0,0),(167,169,3,213,89,24,45,1616652000,1616653800,0,0,0),(169,129,3,222,74,14,29,1612936800,1612938600,0,0,0),(170,129,4,222,74,14,29,1612936800,1612938600,0,0,0),(171,120,2,222,73,14,29,1612936800,1612938600,0,0,0),(172,166,6,213,89,24,45,1616646600,1616648400,0,0,0),(173,168,5,213,89,24,45,1616650200,1616652000,0,0,0),(176,173,1,215,94,24,48,1618113600,1618115400,0,0,0),(177,176,1,228,94,24,45,1618119000,1618120800,0,0,0),(178,174,2,228,94,24,45,1618115400,1618117200,0,0,0),(179,176,3,215,94,24,48,1618119000,1618120800,0,0,0),(182,173,3,229,94,24,47,1618113600,1618115400,0,0,0),(183,172,2,229,94,24,47,1618111800,1618113600,0,0,0),(187,179,1,141,64,14,32,1618360200,1618362000,0,0,0),(188,179,2,142,64,14,29,1618360200,1618362000,0,0,0),(200,181,1,211,92,24,58,1619152200,1619155800,0,0,0),(201,184,1,216,92,24,37,1619161200,1619164800,0,0,0),(203,180,2,216,92,24,37,1619148600,1619152200,0,0,0),(204,183,2,211,92,24,58,1619159400,1619161200,0,0,0),(205,181,3,211,92,24,58,1619152200,1619155800,0,0,0),(206,185,3,216,92,24,37,1619164800,1619168400,0,0,0),(207,184,4,211,92,24,58,1619161200,1619164800,0,0,0),(208,181,4,216,92,24,37,1619152200,1619155800,0,0,0),(210,168,6,215,89,24,48,1616650200,1616652000,0,0,0),(211,166,5,215,89,24,48,1616646600,1616648400,0,0,0),(212,165,5,215,89,24,48,1616644800,1616646600,0,0,0),(213,181,5,211,92,24,44,1619152200,1619155800,0,0,0),(214,184,5,216,92,24,46,1619161200,1619164800,0,0,0),(215,182,6,211,92,24,58,1619155800,1619159400,0,0,0),(216,185,6,216,92,24,46,1619164800,1619168400,0,0,0),(221,188,1,252,102,24,30,1619497800,1619499600,0,0,0),(222,189,3,252,102,24,30,1619499600,1619501400,0,0,0),(223,186,2,252,102,24,30,1619494200,1619496000,0,0,0),(224,187,5,252,102,24,30,1619496000,1619497800,0,0,0),(225,191,1,254,103,24,59,1619584200,1619586000,0,0,0),(226,195,1,255,103,24,60,1619591400,1619593200,0,0,0),(227,192,2,255,103,24,60,1619586000,1619587800,0,0,0),(228,196,2,254,103,24,59,1619593200,1619595000,0,0,0),(229,193,3,254,103,24,59,1619587800,1619589600,0,0,0),(230,196,3,255,103,24,60,1619593200,1619595000,0,0,0),(233,197,1,254,104,24,59,1619929800,1619931600,0,0,0),(234,202,1,255,104,24,60,1619940600,1619942400,0,0,0),(237,198,2,255,104,24,60,1619931600,1619933400,0,0,0),(238,202,2,254,104,24,59,1619940600,1619942400,0,0,0),(239,199,3,254,104,24,59,1619933400,1619935200,0,0,0),(240,201,3,255,104,24,60,1619938800,1619940600,0,0,0),(242,203,1,267,105,24,62,1620012600,1620014400,0,0,0),(243,207,1,268,105,24,61,1620019800,1620021600,0,0,0),(244,204,2,268,105,24,61,1620014400,1620016200,0,0,0),(245,208,2,267,105,24,62,1620021600,1620023400,0,0,0),(246,205,3,267,105,24,62,1620016200,1620018000,0,0,0),(247,207,3,268,105,24,61,1620019800,1620021600,0,0,0),(251,209,1,269,106,24,44,1620099000,1620102600,0,0,0),(252,215,1,270,106,24,45,1620120600,1620124200,0,0,0),(253,211,2,269,106,24,44,1620106200,1620109800,0,0,0),(254,214,2,270,106,24,45,1620117000,1620120600,0,0,0),(255,209,3,270,106,24,45,1620099000,1620102600,0,0,0),(256,212,3,269,106,24,44,1620109800,1620113400,0,0,0),(257,211,4,270,106,24,45,1620106200,1620109800,0,0,0),(258,215,4,269,106,24,44,1620120600,1620124200,0,0,0),(259,210,5,269,106,24,44,1620102600,1620106200,0,0,0),(260,213,5,270,106,24,45,1620113400,1620117000,0,0,0),(261,209,6,269,106,24,44,1620099000,1620102600,0,0,0),(262,215,6,270,106,24,45,1620120600,1620124200,0,0,0),(267,164,4,268,89,24,61,1616643000,1616644800,0,0,0),(268,167,2,268,89,24,61,1616648400,1616650200,0,0,0),(269,222,1,254,103,24,59,1626051600,1626053400,0,0,0),(270,222,2,255,103,24,60,1626051600,1626053400,0,0,0),(279,110,1,141,72,15,32,1616648400,1616652000,0,0,0),(280,108,2,142,72,15,29,1612929600,1612931400,0,0,0);

--
-- Table structure for table `demo_upload_document`
--

CREATE TABLE `demo_upload_document` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `color_name` varchar(50) DEFAULT NULL,
  `logo_name` varchar(1000) DEFAULT NULL,
  `logo_path` varchar(1000) DEFAULT NULL,
  `favicon_name` varchar(1000) DEFAULT NULL,
  `favicon_path` varchar(1000) DEFAULT NULL,
  `water_mark_name` varchar(1000) DEFAULT NULL,
  `water_mark_path` varchar(1000) DEFAULT NULL,
  `working_hour` int(11) DEFAULT NULL,
  `file_size` int(11) DEFAULT NULL,
  `No_of_files` int(11) DEFAULT NULL,
  `institute_name` varchar(100) DEFAULT NULL,
  `background_image_name` varchar(50) DEFAULT NULL,
  `background_image_path` varchar(100) DEFAULT NULL,
  `columnbackground_image_path` varchar(50) DEFAULT NULL,
  `institute_full_name` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_upload_document`
--

INSERT INTO `demo_upload_document` VALUES (1,'#08016a','1612872264_a7f77f19640b9712387c.jpg','logo_and_favicon/1612872264_a7f77f19640b9712387c.jpg','1612872290_b5b92093341cc36b947b.png','logo_and_favicon/1612872290_b5b92093341cc36b947b.png','1613623165_3ca8bffbdf6ca9b31b1c.jpg','logo_and_favicon/1613623165_3ca8bffbdf6ca9b31b1c.jpg',8,1,15,'SMS','1614429915_b7a622374b8f473e0573.jpg','logo_and_favicon/1614429915_b7a622374b8f473e0573.jpg',NULL,'Dinkar sangeet vidyalay');

--
-- Table structure for table `demo_uploadimage`
--

CREATE TABLE `demo_uploadimage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_name` varchar(50) DEFAULT NULL,
  `file_path` varchar(50) DEFAULT NULL,
  `file_real_name` varchar(50) DEFAULT NULL,
  `document_name` varchar(50) DEFAULT NULL,
  `std_id` varchar(50) DEFAULT NULL,
  `document_type` varchar(50) DEFAULT NULL,
  `type` enum('photo','document') DEFAULT NULL,
  `delete_status` int(11) DEFAULT NULL,
  `uploadby` enum('admin','student') DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_uploadimage`
--

INSERT INTO `demo_uploadimage` VALUES (57,'1612934816_f8500f7208f589a3c112.jpg','student/1612934816_f8500f7208f589a3c112.jpg','Hydrangeas.jpg','abc','115','jpg','document',0,'student'),(58,'1613383143_d709039e49366bd8a3d5.jpg','student/1613383143_d709039e49366bd8a3d5.jpg',NULL,NULL,'137',NULL,'photo',NULL,NULL),(59,'1613622787_77608a0a22025aedbd64.jpg','student/1613622787_77608a0a22025aedbd64.jpg','Hydrangeas.jpg','abc','139','jpg','document',0,'admin'),(60,'1613622928_10db96d7409ad1cc5e4d.jpg','student/1613622928_10db96d7409ad1cc5e4d.jpg','Chrysanthemum.jpg','xyz','139','jpg','document',0,'admin'),(61,'1613623036_e231d0753b4d49b74e33.jpg','student/1613623036_e231d0753b4d49b74e33.jpg','Tulips.jpg','image','139','jpg','document',0,'admin'),(62,'1613623675_81e7350ca4f151cd7a04.jpg','student/1613623675_81e7350ca4f151cd7a04.jpg','flower.jpg','image2','139','jpg','document',1,'admin'),(63,'1613623678_a13576cc484b518ea449.jpg','student/1613623678_a13576cc484b518ea449.jpg','flower.jpg','image2','139','jpg','document',1,'admin'),(64,'1613624836_84c992c61afcdf919bf5.jpg','student/1613624836_84c992c61afcdf919bf5.jpg','Hydrangeas.jpg','abc','138','jpg','document',0,'admin'),(65,'1613710155_45f5f63e262c4fdb19a7.jpg','student/1613710155_45f5f63e262c4fdb19a7.jpg','flower.jpg','xyz','142','jpg','document',0,'admin'),(66,'1613990908_dfd90e8735473a6c411c.jpg','student/1613990908_dfd90e8735473a6c411c.jpg','flower.jpg','abc','145','jpg','document',0,'admin'),(67,'1614430008_d40ad979e8051e18ae2a.jpg','student/1614430008_d40ad979e8051e18ae2a.jpg',NULL,NULL,'131',NULL,'photo',NULL,NULL),(68,'1614770781_abfaef1b51625c1fda94.jpg','student/1614770781_abfaef1b51625c1fda94.jpg',NULL,NULL,'149',NULL,'photo',NULL,NULL),(69,'1614836769_fb0214c5d731331908b6.jpg','student/1614836769_fb0214c5d731331908b6.jpg',NULL,NULL,'150',NULL,'photo',NULL,NULL),(70,'1614836847_0dfc89abac4e04b2a8c8.jpg','student/1614836847_0dfc89abac4e04b2a8c8.jpg','flower.jpg','xyz','150','jpg','document',1,'student'),(71,'1614936483_1ed9aed5d96a9ec90e91.jpg','student/1614936483_1ed9aed5d96a9ec90e91.jpg','images.jpg','xyz','730','jpg','document',0,'admin'),(72,'1614936516_c4d7a7f0ee31b025e5c6.csv','student/1614936516_c4d7a7f0ee31b025e5c6.csv','Student-05-Mar-2021 (1)','as','730','csv','document',0,'admin'),(73,'1614936865_0bb7e94b6f522b00344c.jpg','student/1614936865_0bb7e94b6f522b00344c.jpg','_var_www_html_labz_writable_uploads_student_161399','hjh','730','jpg','document',0,'admin'),(74,'1614945539_fd95cfc773b49cf34116.xlsx','student/1614945539_fd95cfc773b49cf34116.xlsx','studenttemplate .xlsx','vv','721','xlsx','document',0,'admin'),(75,'1615627466_a47afdddda5e92e81bcb.jpg','student/1615627466_a47afdddda5e92e81bcb.jpg','Hydrangeas.jpg','abc1','730','jpg','document',0,'admin'),(76,'1615627603_5bf04bf28026b9242d3b.csv','student/1615627603_5bf04bf28026b9242d3b.csv','Student-05-Mar-2021 (2)','df','730','csv','document',0,'admin'),(77,'1615628522_ad8ebf2dba22a544a239.pdf','student/1615628522_ad8ebf2dba22a544a239.pdf','Milangupta_cv.pdf','as','730','pdf','document',0,'admin'),(78,'1615628540_17122b8f5d687fbe5f2b.docx','student/1615628540_17122b8f5d687fbe5f2b.docx','Sachin Rawat.docx','sd','730','docx','document',0,'admin'),(79,'1615633473_77c41ff625c71486a388.jpg','student/1615633473_77c41ff625c71486a388.jpg','flower.jpg','sdsd','730','jpg','document',0,'admin'),(80,'1615633529_8b93fc3e167cbf8980b1.csv','student/1615633529_8b93fc3e167cbf8980b1.csv','php7.lib','vd','730','csv','document',0,'admin'),(81,'1615633693_ee4a987d1f12a8a21933.jpg','student/1615633693_ee4a987d1f12a8a21933.jpg','flower.jpg','gfg','730','jpg','document',0,'admin'),(82,'1615633758_61df2c249e283da73493.jpg','student/1615633758_61df2c249e283da73493.jpg','images.jpg','nh','730','jpg','document',0,'admin'),(83,'1615633793_e934bd8f3264cab541a6.jpg','student/1615633793_e934bd8f3264cab541a6.jpg','Chrysanthemum.jpg','cv','730','jpg','document',0,'admin'),(84,'1615734580_18bf4915cce61615311d.pdf','student/1615734580_18bf4915cce61615311d.pdf','Delhi-05_Cycle3.pdf','demo1','131','pdf','document',0,'admin'),(85,'1615734674_b059352edcf6290464e1.pdf','student/1615734674_b059352edcf6290464e1.pdf','Delhi-05_Cycle3.pdf','demo','131','pdf','document',0,'admin'),(86,'1615734758_e2ece4bb1b4740f4930d.png','student/1615734758_e2ece4bb1b4740f4930d.png','Screenshot_2019-02-15-14-39-36-697_com.google.andr','uu','131','png','document',0,'admin'),(87,'1615734841_8ca4dffd23e21c43affd.jpg','student/1615734841_8ca4dffd23e21c43affd.jpg','IMG-20180914-WA0004.jpg','demo','131','jpg','document',1,'student'),(88,'1615735163_bf227c2806ce0fc71eb9.png','student/1615735163_bf227c2806ce0fc71eb9.png','Screenshot_2019-02-15-14-39-36-697_com.google.andr','demo1','131','png','document',1,'student'),(89,'1615888107_419f1a0f27dc89ed5d3f.jpg','student/1615888107_419f1a0f27dc89ed5d3f.jpg','download.jpg','my10','131','jpg','document',0,'student'),(90,'1615954950_3c37268ac590057819a4.jpg','student/1615954950_3c37268ac590057819a4.jpg','index.jpg','abc','731','jpg','document',0,'student'),(91,'1615955856_3392b33c157b5d2bdac7.jpg','student/1615955856_3392b33c157b5d2bdac7.jpg','Hydrangeas.jpg','qwsd55','738','jpg','document',0,'admin'),(92,'1616044718_3435889baee3a4d2f12b.jpg','student/1616044718_3435889baee3a4d2f12b.jpg',NULL,NULL,'737',NULL,'photo',NULL,NULL),(93,'1616136153_b3c00057dbf6bc49cbab.jpg','student/1616136153_b3c00057dbf6bc49cbab.jpg','flower.jpg','abc','741','jpg','document',0,'student'),(94,'1616136703_fdf6bec22d534faf7cad.jpg','student/1616136703_fdf6bec22d534faf7cad.jpg',NULL,NULL,'741',NULL,'photo',NULL,NULL),(95,'1616136781_50b342687f597f644967.jpg','student/1616136781_50b342687f597f644967.jpg','Hydrangeas.jpg','xyz','741','jpg','document',0,'student'),(96,'1616331231_5a4581d5f5915ea30341.png','student/1616331231_5a4581d5f5915ea30341.png','Screenshot_2019-02-15-14-39-36-697_com.google.andr','abc','745','png','document',1,'student'),(97,'1616331338_7cd9c89c73cb9b04cafa.png','student/1616331338_7cd9c89c73cb9b04cafa.png','Screenshot_2019-02-15-14-39-36-697_com.google.andr','xhz','745','png','document',0,'admin'),(98,'1616331363_839162479c966c322f5a.png','student/1616331363_839162479c966c322f5a.png','Screenshot_2019-02-15-14-39-36-697_com.google.andr','xhz','745','png','document',1,'admin'),(99,'1616331378_a4f7e0d746323c0fd439.png','student/1616331378_a4f7e0d746323c0fd439.png','Screenshot_2019-02-15-14-39-36-697_com.google.andr','xhz','745','png','document',1,'admin'),(100,'1616331510_7154894c33b7ba4e7065.png','student/1616331510_7154894c33b7ba4e7065.png',NULL,NULL,'745',NULL,'photo',NULL,NULL),(101,'1616564478_797718d66c08b52299ad.csv','student/1616564478_797718d66c08b52299ad.csv','Student-23-Mar-2021','abc','747','csv','document',0,'admin'),(102,'1616564576_a159aed0591544cfdef4.pdf','student/1616564576_a159aed0591544cfdef4.pdf','demo1.pdf','as','747','pdf','document',0,'admin'),(103,'1616564652_bbd313f9dad7260d5565.docx','student/1616564652_bbd313f9dad7260d5565.docx','KGS_Role_Structure.docx','as','747','docx','document',0,'admin'),(104,'1616564767_cc7d242c4eca99822ea3.jpg','student/1616564767_cc7d242c4eca99822ea3.jpg','flower.jpg','as','747','jpg','document',0,'admin'),(105,'1616565157_047730cc9c7f79ec8bb9.jpg','student/1616565157_047730cc9c7f79ec8bb9.jpg','Chrysanthemum.jpg','aa','747','jpg','document',0,'admin'),(106,'1616565304_69cd80b0900db9c2d7f9.jpg','student/1616565304_69cd80b0900db9c2d7f9.jpg',NULL,NULL,'747',NULL,'photo',NULL,NULL),(107,'1616578571_30bb2b24ff9a5b2abc35.pdf','student/1616578571_30bb2b24ff9a5b2abc35.pdf','as (1).pdf','demo','747','pdf','document',0,'student'),(108,'1616578604_6f77afcbefcaf413a431.jpg','student/1616578604_6f77afcbefcaf413a431.jpg','flower.jpg','abc','747','jpg','document',0,'student'),(109,'1616691385_1c18128d1a3df72f191f.png','student/1616691385_1c18128d1a3df72f191f.png',NULL,NULL,'748',NULL,'photo',NULL,NULL),(110,'1616750216_3161885023a23ddd3421.jpg','student/1616750216_3161885023a23ddd3421.jpg',NULL,NULL,'752',NULL,'photo',NULL,NULL),(111,'1616758462_58ea80c473d74e79f3e5.jpg','student/1616758462_58ea80c473d74e79f3e5.jpg',NULL,NULL,'751',NULL,'photo',NULL,NULL),(112,'1616758791_335b4de3317c85333f3b.jpg','student/1616758791_335b4de3317c85333f3b.jpg','flower.jpg','demo','751','jpg','document',0,'admin'),(113,'1617086439_03f12c3232f3a8f17eeb.jpg','student/1617086439_03f12c3232f3a8f17eeb.jpg','Chrysanthemum.jpg','demo','750','jpg','document',0,'student'),(114,'1617602098_0feb4870aa2ea41e99cf.jpg','student/1617602098_0feb4870aa2ea41e99cf.jpg','flower.jpg','demo','753','jpg','document',0,'student'),(115,'1617779789_1bc5ede041e90e585ce0.csv','student/1617779789_1bc5ede041e90e585ce0.csv','abc.csv','sd','756','csv','document',0,'admin'),(116,'1617941733_e6bc4e48a75644698e4e.jpg','student/1617941733_e6bc4e48a75644698e4e.jpg','flower.jpg','abc','753','jpg','document',0,'admin'),(117,'1618822686_cdd7f64d26b961651433.jpg','student/1618822686_cdd7f64d26b961651433.jpg',NULL,NULL,'771',NULL,'photo',NULL,NULL),(118,'1618905660_ed0cd1e9fc1c81bf3cc6.jpg','student/1618905660_ed0cd1e9fc1c81bf3cc6.jpg','index.jpg','ab','771','jpg','document',0,'admin'),(119,'1618910421_4de2fd6c836e48989201.jpg','student/1618910421_4de2fd6c836e48989201.jpg','images.jpg','av','771','jpg','document',0,'admin'),(120,'1618910764_128f16b6155223b35036.docx','student/1618910764_128f16b6155223b35036.docx','bug_report_sms.docx','docx','771','docx','document',0,'admin'),(121,'1618911087_453f09da4c88792e9857.pdf','student/1618911087_453f09da4c88792e9857.pdf','Increment letter- Sadhna.pdf','pdf','771','pdf','document',1,'admin'),(122,'1618911581_54d632c319588b0c6f04.jpg','student/1618911581_54d632c319588b0c6f04.jpg','flower-2mb.jpg','f','772','jpg','document',0,'admin'),(123,'1619156001_fc3ffc68e5cd2fdc7882.png','student/1619156001_fc3ffc68e5cd2fdc7882.png','sms.png','png','711','png','document',0,'admin'),(124,'1619159291_f1698472d365cf16b515.jpg','student/1619159291_f1698472d365cf16b515.jpg','_var_www_html_sandeep_smserp_writable_uploads_stud','flower','785','jpg','document',0,'admin'),(125,'1619246277_1a6c9c4a655b769278cd.jpg','student/1619246277_1a6c9c4a655b769278cd.jpg',NULL,NULL,'723',NULL,'photo',NULL,NULL),(126,'1619249295_cbb3bcd3eb3c33cdad0a.jpg','student/1619249295_cbb3bcd3eb3c33cdad0a.jpg','download.jpg','dadda','723','jpg','document',0,'student'),(127,'1619255427_ede22648a7267e3beaa0.jpg','student/1619255427_ede22648a7267e3beaa0.jpg','flower.jpg','gh','782','jpg','document',0,'student'),(128,'1619600417_7e3944569b19bea6da19.jpg','student/1619600417_7e3944569b19bea6da19.jpg','flower.jpg','abc','782','jpg','document',0,'student'),(129,'1619432134_615379b7e24578b6338c.pdf','student/1619432134_615379b7e24578b6338c.pdf','IATF PROJECT.pdf','ERFER','723','pdf','document',1,'student'),(130,'1619432138_1e4c0a08d012541b0e6f.pdf','student/1619432138_1e4c0a08d012541b0e6f.pdf','IATF PROJECT.pdf','ERFER','723','pdf','document',1,'student'),(131,'1619513846_cb28e5ee81dccb51da3a.jpg','student/1619513846_cb28e5ee81dccb51da3a.jpg','portrait.jpg','hello1','789','jpg','document',0,'admin'),(132,'1619600364_5b111c6c573ad982a952.jpg','student/1619600364_5b111c6c573ad982a952.jpg','flower.jpg','demo','782','jpg','document',0,'student'),(133,'1619756977_4c6e371b350015529862.jpg','student/1619756977_4c6e371b350015529862.jpg',NULL,NULL,'792',NULL,'photo',NULL,NULL),(134,'1619763965_998c5580d7e5c968fed0.jpg','student/1619763965_998c5580d7e5c968fed0.jpg',NULL,NULL,'782',NULL,'photo',NULL,NULL),(135,'1619774009_677665ecbc5ae6e418cb.jpg','student/1619774009_677665ecbc5ae6e418cb.jpg','flower.jpg','abd','788','jpg','document',0,'admin'),(136,'1619774097_877054ce725e1d65b45c.pdf','student/1619774097_877054ce725e1d65b45c.pdf','Fee Reciept.pdf','pdf','788','pdf','document',0,'admin'),(137,'1619972860_c0bc9ee99c8ad6c865e4.jpg','student/1619972860_c0bc9ee99c8ad6c865e4.jpg','flower.jpg','er','799','jpg','document',0,'student'),(138,'1619973956_5e36a61943ea2c5df67d.jpg','student/1619973956_5e36a61943ea2c5df67d.jpg',NULL,NULL,'799',NULL,'photo',NULL,NULL),(139,'1620031877_4774a4ebab00368d7cd5.jpg','student/1620031877_4774a4ebab00368d7cd5.jpg','IMG_20210318_194859.jpg','fg','799','jpg','document',1,'student'),(140,'1620032024_ae62b1b94b69916137a9.pdf','student/1620032024_ae62b1b94b69916137a9.pdf','pdf.pdf','pdf file','799','pdf','document',0,'student'),(141,'1620032141_31e91c70ec199b1af7c3.docx','student/1620032141_31e91c70ec199b1af7c3.docx','Teacher leave issue .docx','word','799','docx','document',0,'student'),(142,'1620035646_e6a43d314191b55d41ab.jpg','student/1620035646_e6a43d314191b55d41ab.jpg','demo.jpg','student image','799','jpg','document',0,'student'),(143,'1620113707_2478263994699f2587f3.jpg','student/1620113707_2478263994699f2587f3.jpg',NULL,NULL,'803',NULL,'photo',NULL,NULL),(144,'1620200360_c7694a3f83b319a3fc7f.jpg','student/1620200360_c7694a3f83b319a3fc7f.jpg','1586897152-2436.jpg','ss','806','jpg','document',0,'admin'),(145,'1621315635_9ffbe945070ab0c105fa.jpg','student/1621315635_9ffbe945070ab0c105fa.jpg','photo-1542317148-8b4bdccb33ea.jfif','adasd','782','jpg','document',0,'student'),(146,'1624248997_e5c5dd697adddd430b65.jpg','student/1624248997_e5c5dd697adddd430b65.jpg',NULL,NULL,'790',NULL,'photo',NULL,NULL);

--
-- Table structure for table `demo_user_attendance`
--

CREATE TABLE `demo_user_attendance` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(255) DEFAULT NULL,
  `date` varchar(255) DEFAULT NULL,
  `attendance_status` varchar(255) DEFAULT NULL,
  `role_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=755 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `demo_user_attendance`
--

INSERT INTO `demo_user_attendance` VALUES (283,'163','1612895400','1',12),(284,'163','1612981800','2',12),(286,'162','4768569000','1',29),(287,'168','4768655400','1',29),(288,'167','4768655400','2',29),(289,'166','4768655400','3',29),(290,'164','4768655400','1',29),(291,'165','4768655400','1',29),(292,'162','4768741800','1',29),(299,'162','4769001000','1',29),(300,'164','1613327400','1',12),(301,'174','1613327400','1',12),(302,'174','1613241000','2',12),(303,'174','1613154600','3',12),(304,'174','1613068200','1',12),(305,'168','4769346600','1',29),(306,'167','4769346600','2',29),(307,'168','4769605800','1',29),(308,'166','4769605800','2',29),(309,'142','1613932200','1',29),(315,'141','1613932200','1',58),(316,'146','1613932200','2',58),(317,'148','1613932200','1',58),(318,'149','1613932200','2',58),(319,'151','1613932200','3',58),(321,'168','4769692200','1',29),(322,'166','4769692200','2',29),(323,'165','4769692200','3',29),(329,'168','4769865000','1',29),(333,'141','1614364200','1',58),(334,'146','1614364200','2',58),(335,'148','1614364200','2',58),(336,'149','1614364200','3',58),(337,'150','1614364200','2',58),(338,'158','1614364200','1',58),(339,'147','1614364200','3',58),(340,'159','1614364200','1',12),(341,'160','1614364200','2',12),(342,'162','1614364200','1',12),(343,'164','1614364200','2',12),(344,'165','1614364200','3',12),(345,'166','1614364200','1',12),(346,'143','1614364200','1',59),(347,'144','1614364200','2',59),(350,'166','4770037800','1',29),(351,'164','4770037800','2',29),(352,'177','4770037800','3',29),(356,'142','1615746600','1',29),(357,'145','1615746600','1',29),(358,'147','1615746600','1',29),(365,'141','1615746600','1',58),(366,'146','1615746600','2',58),(367,'148','1615746600','3',58),(368,'198','1615746600','1',58),(371,'143','1615746600','1',59),(372,'144','1615746600','2',59),(398,'142','1615833000','1',29),(399,'145','1615833000','2',29),(400,'147','1615833000','1',29),(401,'141','1615833000','1',58),(402,'146','1615833000','2',58),(403,'148','1615833000','3',58),(406,'143','1615833000','1',59),(407,'144','1615833000','2',59),(417,'156','1615833000','2',22),(433,'202','1616005800','1',12),(434,'202','1615919400','3',12),(442,'168','1616092200','1',12),(443,'167','1616092200','1',12),(444,'166','1616092200','1',12),(445,'164','1616092200','1',12),(446,'165','1616092200','3',12),(447,'177','1616092200','3',12),(448,'202','1616092200','2',12),(449,'159','1615833000','1',12),(450,'160','1615833000','2',12),(451,'164','1615833000','1',12),(452,'202','1615833000','1',12),(453,'168','1615746600','1',12),(454,'167','1615746600','1',12),(455,'166','1615746600','2',12),(456,'164','1615746600','2',12),(457,'165','1615746600','1',12),(458,'177','1615746600','3',12),(459,'202','1615746600','2',12),(466,'143','1616092200','1',59),(467,'144','1616092200','2',59),(468,'142','1616092200','1',29),(469,'145','1616092200','2',29),(470,'147','1616092200','3',29),(471,'141','1616092200','1',58),(472,'146','1616092200','2',58),(473,'148','1616092200','3',58),(474,'149','1616092200','1',58),(475,'150','1616092200','2',58),(476,'151','1616092200','3',58),(477,'158','1616092200','1',58),(478,'157','1616092200','2',58),(479,'183','1616092200','4',58),(480,'184','1616092200','1',58),(483,'206','1616437800','3',12),(484,'206','1616178600','1',12),(485,'141','1616265000','1',58),(486,'146','1616265000','2',58),(487,'202','1616265000','1',12),(488,'168','1616351400','1',12),(489,'210','1616524200','1',12),(502,'141','1616610600','1',58),(503,'146','1616610600','1',58),(504,'148','1616610600','2',58),(505,'149','1616610600','2',58),(506,'150','1616610600','3',58),(507,'151','1616610600','3',58),(508,'142','1616610600','1',29),(509,'145','1616610600','2',29),(510,'147','1616610600','3',29),(514,'142','1616697000','1',29),(515,'145','1616697000','2',29),(516,'147','1616697000','3',29),(525,'141','1616697000','1',58),(526,'146','1616697000','1',58),(527,'148','1616697000','2',58),(528,'149','1616697000','2',58),(529,'150','1616697000','3',58),(530,'151','1616697000','3',58),(531,'158','1616697000','1',58),(532,'157','1616697000','1',58),(533,'183','1616697000','1',58),(534,'184','1616697000','1',58),(535,'143','1616610600','1',59),(536,'144','1616610600','3',59),(550,'212','1616610600','1',12),(552,'212','1616697000','1',12),(553,'219','1616697000','2',12),(554,'218','1616697000','3',12),(555,'217','1616697000','1',12),(556,'220','1616697000','2',12),(557,'143','1616697000','1',59),(558,'144','1616697000','2',59),(561,'206','1616783400','1',12),(562,'221','1616783400','1',12),(565,'212','1617042600','1',12),(566,'221','1617042600','2',12),(567,'217','1617042600','3',12),(571,'212','1617215400','1',12),(572,'221','1617215400','2',12),(573,'217','1617215400','3',12),(594,'212','1617301800','1',12),(595,'217','1617301800','1',12),(603,'223','1617561000','1',12),(604,'223','1617474600','2',12),(605,'223','1617388200','3',12),(609,'212','1617647400','1',12),(610,'217','1617647400','2',12),(611,'158','1617733800','1',58),(612,'157','1617733800','2',58),(613,'145','1617733800','3',29),(615,'210','1618079400','1',12),(616,'210','1617993000','2',12),(617,'228','1618079400','1',58),(618,'212','1618165800','1',12),(619,'217','1618165800','2',12),(621,'212','1618338600','1',12),(622,'217','1618338600','2',12),(623,'212','1618252200','1',12),(624,'217','1618252200','3',12),(628,'231','1618597800','2',12),(629,'212','1618770600','1',12),(630,'217','1618770600','1',12),(631,'223','1618770600','3',12),(632,'231','1618770600','1',12),(640,'167','1618943400','1',12),(658,'175','1619029800','1',12),(659,'242','1619116200','1',12),(660,'241','1619116200','1',12),(662,'242','1619202600','2',12),(663,'241','1619202600','1',12),(685,'242','1619375400','1',12),(686,'241','1619375400','2',12),(687,'250','1619375400','3',12),(688,'242','1619461800','1',12),(689,'241','1619461800','2',12),(690,'250','1619461800','3',12),(694,'241','1619721000','1',12),(695,'250','1619721000','1',12),(696,'242','1619721000','3',12),(699,'256','1619807400','1',12),(704,'264','1619893800','1',12),(705,'265','1619893800','2',12),(706,'266','1619893800','3',12),(707,'264','1619980200','2',12),(709,'271','1620066600','1',12),(710,'272','1620066600','2',12),(711,'273','1620066600','3',12),(712,'274','1620066600','1',12),(721,'268','1620066600','1',58),(722,'270','1620066600','1',58),(723,'269','1620066600','2',29),(724,'143','1620066600','1',59),(725,'144','1620066600','2',59),(726,'251','1620066600','3',59),(727,'159','1624645800','1',12),(728,'159','0','1',12),(739,'150','1630953000','1',58),(740,'151','1630953000','2',58),(741,'143','1630953000','1',59),(742,'144','1630953000','2',59),(743,'251','1630953000','3',59),(744,'202','1625769000','1',12),(745,'224','1625769000','2',12),(746,'159','1630953000','1',12),(747,'160','1630953000','2',12),(748,'161','1630953000','3',12),(749,'275','1630953000','1',12),(750,'275','1628274600','2',12),(753,'202','1626028200','1',12),(754,'224','1626028200','2',12);

--
-- Table structure for table `demo_user_permission`
--

CREATE TABLE `demo_user_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` varchar(50) NOT NULL DEFAULT '0',
  `permission_id` varchar(50) NOT NULL DEFAULT '0',
  `status` varchar(50) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1504 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `demo_user_permission`
--

INSERT INTO `demo_user_permission` VALUES (1393,'156','82','1'),(1394,'156','83','1'),(1395,'156','84','0'),(1396,'156','85','0'),(1397,'156','86','1'),(1398,'166','82','1'),(1399,'166','83','1'),(1400,'166','84','1'),(1401,'166','85','0'),(1402,'166','86','0'),(1403,'167','82','1'),(1404,'167','83','1'),(1405,'167','84','0'),(1406,'167','85','0'),(1407,'167','86','1'),(1408,'157','82','0'),(1409,'157','83','0'),(1410,'157','84','0'),(1411,'157','85','0'),(1412,'157','86','0'),(1413,'119','82','1'),(1414,'119','83','1'),(1415,'119','84','0'),(1416,'119','85','0'),(1417,'119','86','0'),(1418,'141','82','0'),(1419,'141','83','0'),(1420,'141','84','0'),(1421,'141','85','0'),(1422,'141','86','0'),(1423,'141','87','1'),(1424,'141','90','0'),(1425,'141','91','0'),(1426,'141','92','0'),(1427,'141','94','0'),(1428,'141','95','0'),(1429,'119','87','0'),(1430,'119','90','0'),(1431,'119','91','0'),(1432,'119','92','0'),(1433,'119','94','0'),(1434,'119','95','0'),(1435,'142','82','1'),(1436,'142','83','0'),(1437,'142','84','0'),(1438,'142','85','1'),(1439,'142','86','0'),(1440,'142','87','0'),(1441,'142','90','0'),(1442,'142','91','0'),(1443,'142','92','0'),(1444,'142','94','0'),(1445,'142','95','0'),(1446,'228','82','1'),(1447,'228','83','1'),(1448,'228','84','1'),(1449,'228','85','0'),(1450,'228','86','0'),(1451,'228','87','1'),(1452,'228','90','0'),(1453,'228','91','0'),(1454,'228','92','1'),(1455,'228','94','0'),(1456,'228','95','0'),(1457,'231','82','1'),(1458,'231','83','1'),(1459,'231','84','0'),(1460,'231','85','0'),(1461,'231','86','1'),(1462,'231','87','0'),(1463,'231','90','0'),(1464,'231','91','0'),(1465,'231','92','0'),(1466,'231','94','0'),(1467,'231','95','0'),(1468,'163','82','1'),(1469,'163','83','1'),(1470,'163','84','0'),(1471,'163','85','0'),(1472,'163','86','1'),(1473,'163','87','1'),(1474,'163','90','0'),(1475,'163','91','0'),(1476,'163','92','0'),(1477,'163','94','0'),(1478,'163','95','0'),(1479,'242','82','1'),(1480,'242','83','1'),(1481,'242','84','0'),(1482,'242','85','0'),(1483,'242','86','1'),(1484,'242','87','0'),(1485,'242','90','0'),(1486,'242','91','0'),(1487,'242','92','0'),(1488,'242','95','0'),(1489,'182','82','1'),(1490,'182','83','1'),(1491,'182','84','0'),(1492,'182','85','0'),(1493,'182','86','1'),(1494,'182','87','1'),(1495,'182','90','0'),(1496,'182','91','0'),(1497,'182','92','0'),(1498,'182','95','0'),(1499,'157','87','1'),(1500,'157','90','0'),(1501,'157','91','0'),(1502,'157','92','0'),(1503,'157','95','0');

--
-- Table structure for table `demo_vch_type`
--

CREATE TABLE `demo_vch_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `delete_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_vch_type`
--

INSERT INTO `demo_vch_type` VALUES (1,'cash',0),(2,'cheque',0),(3,'bank',0),(4,'Netbanking',0),(5,'hj',1);

--
-- Table structure for table `demo_work_description`
--

CREATE TABLE `demo_work_description` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `work_description` text,
  `teacher_id` varchar(50) DEFAULT NULL,
  `create_date` varchar(50) DEFAULT NULL,
  `delete` varchar(50) DEFAULT NULL,
  `class_id` int(11) DEFAULT NULL,
  `section_id` int(11) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `demo_work_description`
--

INSERT INTO `demo_work_description` VALUES (1,'test','141','1613586600','0',67,14,NULL),(2,'physics: learn ch-1.2,3','157','1613327400','0',74,14,NULL),(3,'test ch-2 in physic ','157','1613327400','0',73,15,NULL),(4,'computer: learn ch-1,2 \r\ntest which teach in previous class','148','1613500200','0',74,14,NULL),(5,'physics: learn ch-5,6 and also write question and answer in notebook','157','1613500200','0',74,14,NULL),(6,'chemistry: learn ch-1,3 ,5 and test on wednesday','158','1613500200','0',74,14,NULL),(7,'learn about surya namaskar and what are benifit of this','151','1613500200','0',74,14,NULL),(8,'ghg','147','-19800','0',72,14,NULL),(9,'hg','187','1615660200','1',81,NULL,NULL),(10,'adc','187','1615919400','0',81,NULL,NULL),(11,'EX-5,6,7 do','145','1616005800','0',74,14,NULL),(12,'','157','0','1',74,0,NULL),(13,'learn 7 chapter to 10','157','1616092200','0',74,14,NULL),(14,'','213','0','1',0,NULL,NULL),(15,'','213','0','0',0,NULL,NULL),(16,'','215','0','1',0,NULL,NULL),(17,'','228','-19800','0',0,NULL,NULL),(18,'','215','-19800','1',89,24,NULL),(19,'dff','215','0','1',0,NULL,NULL),(20,'dff','215','0','1',0,NULL,NULL),(21,'','215','1618511400','0',94,0,NULL),(22,'Account: revise chapter -1,6,7\r\nand also unit test of 5 chapter','211','1619548200','0',92,24,NULL),(23,'commerce:  read chater 4,5,6\r\nand also unit test\r\nall for final exam revice : 1-3 chapter\r\n','216','1619548200','0',92,24,NULL),(24,'read about c and fuction ,class, overloading','216','1619634600','1',89,24,'read .....'),(25,'demo','216','1619634600','0',89,24,'demo.....'),(26,'home work','216','1619634600','0',89,24,'home .....'),(27,'qwq','211','0','1',89,24,'qwq.....'),(28,'c++: learn basic concept of oops and fuction also sa','211','1619807400','0',89,24,'c++: .....'),(29,'art2: learn basic concept','254','1619980200','0',104,24,'art2:.....'),(30,'economics','255','1619980200','0',103,24,'econo.....'),(31,'econimics2','255','1619980200','0',104,24,'econi.....'),(32,'learn 1,3','255','1619980200','0',104,24,'learn.....'),(33,'art1: learn 5 ch','254','1619980200','0',103,24,'art1:.....'),(34,'eco :bbsjjnsd','255','1619980200','0',104,24,'eco :.....'),(35,'learn ch-3 in economics','255','1619980200','0',104,24,'learn.....'),(36,'c++: what is  c++ and fuction\r\nadvantage of oops','213','1620066600','0',89,24,'c++: .....'),(37,'c++: difference betwwen c and c++\r\nwhich is more relibale','213','1620066600','0',89,24,'c++: .....'),(38,'Java: learn basic concept of java','269','1620153000','0',106,24,'Java:.....'),(39,'java: difference between java and c++','269','1620153000','0',106,24,'java:.....'),(40,'java:\r\nadvantage of java as compaire to oops','269','1620153000','0',106,24,'java:.....'),(41,'c++: \r\nlearn basis concept of c++','270','1620153000','0',106,24,'c++: .....'),(42,'c++ : difference betwwen c and c++','270','1620153000','0',106,24,'c++ :.....'),(43,'class teacher','211','1620844200','0',89,24,'class.....'),(44,'teacher','216','1620844200','0',89,24,'teach.....'),(45,'teacher mca','216','1620844200','0',102,24,'teach.....'),(46,'completed home work','145','0','0',74,14,'compl.....');

--
-- Table structure for table `emi`
--

CREATE TABLE `emi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `loan_id` int(11) DEFAULT NULL,
  `month` varchar(100) DEFAULT NULL,
  `emi_number` int(11) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `updated_date` varchar(100) DEFAULT NULL,
  `created_date` varchar(100) DEFAULT NULL,
  `salary_id` varchar(100) DEFAULT NULL,
  `interest` varchar(100) DEFAULT NULL,
  `emi_amount` varchar(100) DEFAULT NULL,
  `delete_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `emi`
--


--
-- Table structure for table `employee_image`
--

CREATE TABLE `employee_image` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `file_name` varchar(50) DEFAULT NULL,
  `file_path` varchar(50) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `employee_image`
--


--
-- Table structure for table `employee_order`
--

CREATE TABLE `employee_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  `status` varchar(10) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `location` enum('front','back') DEFAULT NULL,
  `field_name` varchar(50) DEFAULT NULL,
  `show_name` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `employee_order`
--

INSERT INTO `employee_order` VALUES (1,'User Name','1',3,'front','uname','User Name'),(2,'First Name','1',4,'front','firstname','First Name'),(3,'Last Name','1',1,'front','lastname','Last Name'),(4,'Email Id','1',2,'front','email','Email Id');

--
-- Table structure for table `exam`
--

CREATE TABLE `exam` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `delete_status` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `exam`
--

INSERT INTO `exam` VALUES (20,'pre_board','0'),(21,'final_exam','0');

--
-- Table structure for table `fees`
--

CREATE TABLE `fees` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `admission_fee` varchar(50) DEFAULT NULL,
  `registration_fee` varchar(50) DEFAULT NULL,
  `transportation_fee` varchar(50) DEFAULT NULL,
  `tuition_fee` varchar(50) DEFAULT NULL,
  `total_fee` varchar(50) DEFAULT NULL,
  `sid` varchar(50) DEFAULT NULL,
  `from_date` varchar(50) DEFAULT NULL,
  `to_date` varchar(50) DEFAULT NULL,
  `paid` enum('yes','no') DEFAULT NULL,
  `MONTH` varchar(50) DEFAULT NULL,
  `delete_status` int(11) DEFAULT NULL,
  `other_fee` varchar(50) DEFAULT NULL,
  `year` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `fees`
--

INSERT INTO `fees` VALUES (52,'1','2','3','40','46','112',NULL,NULL,'no','2',0,NULL,NULL),(53,'1','2','3','4','10','111',NULL,NULL,'no','2',0,NULL,NULL),(54,'444','1567','234','112','2357','112',NULL,NULL,'no','0',0,NULL,NULL);

--
-- Table structure for table `fff_Event`
--

CREATE TABLE `fff_Event` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `description_name` varchar(50) DEFAULT NULL,
  `startdate` varchar(50) DEFAULT NULL,
  `enddate` varchar(50) DEFAULT NULL,
  `amount` varchar(100) DEFAULT NULL,
  `delete_status` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `fff_Event`
--


--
-- Table structure for table `fff_accounting`
--

CREATE TABLE `fff_accounting` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` varchar(50) DEFAULT NULL,
  `particular` varchar(20) DEFAULT NULL,
  `vch_number` varchar(50) DEFAULT NULL,
  `vch_type` varchar(50) DEFAULT NULL,
  `salary_type` varchar(50) DEFAULT NULL,
  `amount` varchar(50) DEFAULT NULL,
  `user_id` varchar(50) DEFAULT NULL,
  `delete_status` int(11) DEFAULT NULL,
  `student` enum('yes','no') DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `fff_accounting`
--


--
-- Table structure for table `fff_add_class`
--

CREATE TABLE `fff_add_class` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `delete_status` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `fff_add_class`
--


--
-- Table structure for table `fff_add_field`
--

CREATE TABLE `fff_add_field` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `field_name` varchar(50) DEFAULT NULL,
  `field_type` varchar(100) DEFAULT NULL,
  `default_value` varchar(50) DEFAULT NULL,
  `required` enum('yes','no') DEFAULT NULL,
  `form_name` varchar(50) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `fff_add_field`
--


--
-- Table structure for table `fff_add_section`
--

CREATE TABLE `fff_add_section` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `fff_add_section`
--


--
-- Table structure for table `fff_add_subject`
--

CREATE TABLE `fff_add_subject` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subject_name` varchar(50) DEFAULT NULL,
  `delete_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `fff_add_subject`
--


--
-- Table structure for table `fff_address2`
--

CREATE TABLE `fff_address2` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `address1` text,
  `address2` text,
  `zip_code` varchar(50) DEFAULT NULL,
  `state` varchar(50) DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `country` varchar(50) DEFAULT NULL,
  `sid` int(11) DEFAULT NULL,
  `type` enum('admin','student') DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `fff_address2`
--


--
-- Table structure for table `fff_advance_salary`
--

CREATE TABLE `fff_advance_salary` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `amount` varchar(20) DEFAULT NULL,
  `description` varchar(50) DEFAULT NULL,
  `delete_status` int(11) DEFAULT NULL,
  `status` enum('pending','accepted','rejected','adjusted') DEFAULT NULL,
  `created_date` varchar(100) DEFAULT NULL,
  `updated_date` varchar(100) DEFAULT NULL,
  `salary_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `fff_advance_salary`
--


--
