-- Table structure for table `kgs_student_order`
--

CREATE TABLE `kgs_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 `kgs_student_order`
--

INSERT INTO `kgs_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 `kgs_student_verification`
--

CREATE TABLE `kgs_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=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgs_student_verification`
--

INSERT INTO `kgs_student_verification` VALUES (1,1070,'34923010','used'),(2,1258,'2055772779','not used'),(3,1204,'1213141213','not used'),(4,1259,'1368649106','used'),(5,1294,'947982761','not used'),(6,1452,'1768146041','not used');

--
-- Table structure for table `kgs_student_work_description`
--

CREATE TABLE `kgs_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgs_student_work_description`
--


--
-- Table structure for table `kgs_subject_list`
--

CREATE TABLE `kgs_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=371 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgs_subject_list`
--

INSERT INTO `kgs_subject_list` VALUES (334,'174','40','0'),(335,'175','40','0'),(338,'178','40','0'),(347,'187','46','0'),(348,'188','46','0'),(351,'185','50','0'),(352,'176','56','0'),(353,'176','59','0'),(354,'177','58','0'),(355,'179','49','0'),(356,'180','48','0'),(357,'181','51','0'),(358,'182','54','0'),(359,'183','52','0'),(360,'184','53','0'),(361,'186','47','0'),(362,'205','57','0'),(363,'204','55','0'),(364,'938','60','0'),(365,'939','61','0'),(366,'979','62','0'),(369,'971','63','0'),(370,'1273','64','0');

--
-- Table structure for table `kgs_supplier`
--

CREATE TABLE `kgs_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 `kgs_supplier`
--


--
-- Table structure for table `kgs_teacher_class_section_list`
--

CREATE TABLE `kgs_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 `kgs_teacher_class_section_list`
--

INSERT INTO `kgs_teacher_class_section_list` VALUES (21,'179','82','21'),(23,'188','0','0'),(24,'180','82','23'),(25,'181','81','21'),(26,'185',NULL,'0'),(27,'186','84','21'),(28,'183','76','21'),(29,'184','76','23'),(30,'176','77','21'),(31,'177','77','23'),(32,'174','77','24'),(33,'175','77','25');

--
-- Table structure for table `kgs_teacher_list`
--

CREATE TABLE `kgs_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=1561 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgs_teacher_list`
--

INSERT INTO `kgs_teacher_list` VALUES (925,'183','114','1'),(926,'183','113','1'),(927,'180','110','1'),(930,'180','109','1'),(934,'179','108','1'),(936,'179','107','1'),(940,'182','122','1'),(944,'182','123','1'),(945,'182','125','1'),(946,'182','124','1'),(947,'182','126','1'),(948,'182','121','1'),(949,'182','119','1'),(950,'182','120','1'),(952,'177','117','1'),(953,'177','116','1'),(954,'177','118','1'),(955,'181','115','1'),(956,'181','75','1'),(958,'184','77','1'),(959,'183','112','1'),(960,'183','111','1'),(961,'184','78','1'),(962,'179','106','1'),(963,'179','105','1'),(964,'179','103','1'),(965,'179','102','1'),(966,'186','100','1'),(967,'186','99','1'),(968,'186','98','1'),(969,'186','97','1'),(972,'176','94','1'),(973,'176','90','1'),(974,'176','91','1'),(978,'185','86','1'),(979,'185','83','1'),(980,'185','82','1'),(981,'185','81','1'),(982,'184','80','1'),(983,'184','79','1'),(985,'181','76','1'),(1119,'204','127','1'),(1120,'205','127','1'),(1121,'186','127','1'),(1122,'184','127','1'),(1123,'183','127','1'),(1124,'182','127','1'),(1125,'181','127','1'),(1126,'180','127','1'),(1127,'179','127','1'),(1128,'177','127','1'),(1129,'176','127','1'),(1130,'185','127','1'),(1143,'185','137','1'),(1144,'182','137','1'),(1171,'182','138','0'),(1172,'939','139','0'),(1173,'938','139','0'),(1174,'939','140','0'),(1175,'938','140','0'),(1176,'939','141','0'),(1177,'938','141','0'),(1178,'939','142','0'),(1179,'938','142','0'),(1180,'939','143','0'),(1181,'938','143','0'),(1186,'176','145',NULL),(1349,'204','133',NULL),(1350,'205','133',NULL),(1351,'186','133',NULL),(1352,'184','133',NULL),(1353,'183','133',NULL),(1354,'181','133',NULL),(1355,'180','133',NULL),(1356,'179','133',NULL),(1357,'177','133',NULL),(1358,'176','133',NULL),(1359,'182','133',NULL),(1360,'185','133',NULL),(1361,'971','133',NULL),(1362,'979','133',NULL),(1363,'204','134',NULL),(1364,'205','134',NULL),(1365,'186','134',NULL),(1366,'184','134',NULL),(1367,'183','134',NULL),(1368,'181','134',NULL),(1369,'180','134',NULL),(1370,'179','134',NULL),(1371,'177','134',NULL),(1372,'176','134',NULL),(1373,'182','134',NULL),(1374,'185','134',NULL),(1375,'971','134',NULL),(1376,'979','134',NULL),(1434,'176','147','0'),(1435,'176','148','0'),(1437,'176','150','0'),(1438,'176','149',NULL),(1440,'205','152','0'),(1441,'176','151',NULL),(1448,'204','136',NULL),(1449,'205','136',NULL),(1450,'186','136',NULL),(1451,'184','136',NULL),(1452,'183','136',NULL),(1453,'181','136',NULL),(1454,'180','136',NULL),(1455,'179','136',NULL),(1456,'177','136',NULL),(1457,'176','136',NULL),(1458,'182','136',NULL),(1459,'185','136',NULL),(1460,'971','136',NULL),(1461,'979','136',NULL),(1462,'1273','136',NULL),(1463,'204','135',NULL),(1464,'205','135',NULL),(1465,'186','135',NULL),(1466,'184','135',NULL),(1467,'183','135',NULL),(1468,'181','135',NULL),(1469,'180','135',NULL),(1470,'179','135',NULL),(1471,'177','135',NULL),(1472,'176','135',NULL),(1473,'182','135',NULL),(1474,'185','135',NULL),(1475,'971','135',NULL),(1476,'979','135',NULL),(1477,'1273','135',NULL),(1478,'204','132',NULL),(1479,'205','132',NULL),(1480,'186','132',NULL),(1481,'184','132',NULL),(1482,'183','132',NULL),(1483,'181','132',NULL),(1484,'180','132',NULL),(1485,'179','132',NULL),(1486,'177','132',NULL),(1487,'176','132',NULL),(1488,'182','132',NULL),(1489,'185','132',NULL),(1490,'971','132',NULL),(1491,'979','132',NULL),(1492,'1273','132',NULL),(1493,'204','131',NULL),(1494,'205','131',NULL),(1495,'186','131',NULL),(1496,'184','131',NULL),(1497,'183','131',NULL),(1498,'181','131',NULL),(1499,'180','131',NULL),(1500,'179','131',NULL),(1501,'177','131',NULL),(1502,'176','131',NULL),(1503,'182','131',NULL),(1504,'185','131',NULL),(1505,'971','131',NULL),(1506,'979','131',NULL),(1507,'1273','131',NULL),(1508,'204','130',NULL),(1509,'205','130',NULL),(1510,'186','130',NULL),(1511,'184','130',NULL),(1512,'183','130',NULL),(1513,'181','130',NULL),(1514,'180','130',NULL),(1515,'179','130',NULL),(1516,'177','130',NULL),(1517,'176','130',NULL),(1518,'182','130',NULL),(1519,'185','130',NULL),(1520,'971','130',NULL),(1521,'979','130',NULL),(1522,'1273','130',NULL),(1523,'204','129',NULL),(1524,'205','129',NULL),(1525,'186','129',NULL),(1526,'184','129',NULL),(1527,'183','129',NULL),(1528,'181','129',NULL),(1529,'180','129',NULL),(1530,'179','129',NULL),(1531,'177','129',NULL),(1532,'176','129',NULL),(1533,'182','129',NULL),(1534,'185','129',NULL),(1535,'971','129',NULL),(1536,'979','129',NULL),(1537,'1273','129',NULL),(1538,'204','128',NULL),(1539,'205','128',NULL),(1540,'186','128',NULL),(1541,'184','128',NULL),(1542,'183','128',NULL),(1543,'181','128',NULL),(1544,'180','128',NULL),(1545,'179','128',NULL),(1546,'177','128',NULL),(1547,'176','128',NULL),(1548,'182','128',NULL),(1549,'185','128',NULL),(1550,'971','128',NULL),(1551,'979','128',NULL),(1552,'1273','128',NULL),(1553,'185','144',NULL),(1554,'939','144',NULL),(1555,'938','144',NULL),(1560,'205','146',NULL);

--
-- Table structure for table `kgs_teacher_mentor`
--

CREATE TABLE `kgs_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=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgs_teacher_mentor`
--

INSERT INTO `kgs_teacher_mentor` VALUES (26,'182','737'),(27,'182','738'),(28,'182','739'),(29,'182','740'),(30,'182','741'),(31,'182','742');

--
-- Table structure for table `kgs_teacher_registration`
--

CREATE TABLE `kgs_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 `kgs_teacher_registration`
--


--
-- Table structure for table `kgs_temporary_timetable`
--

CREATE TABLE `kgs_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgs_temporary_timetable`
--


--
-- Table structure for table `kgs_temporary_timetable_history`
--

CREATE TABLE `kgs_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgs_temporary_timetable_history`
--


--
-- Table structure for table `kgs_timetable`
--

CREATE TABLE `kgs_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=604 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgs_timetable`
--

INSERT INTO `kgs_timetable` VALUES (273,221,2,186,133,34,47,1616643000,1616646600,0,0,0),(274,223,4,186,133,34,47,1616650200,1616653800,0,0,0),(276,252,3,180,136,35,48,1617276600,1617278400,0,0,0),(277,252,5,180,136,35,48,1617276600,1617278400,0,0,0),(278,252,1,179,136,36,49,1617276600,1617278400,0,0,0),(279,252,3,179,136,36,49,1617276600,1617278400,0,0,0),(281,252,2,185,136,37,50,1617276600,1617278400,0,0,0),(282,252,4,185,136,37,50,1617276600,1617278400,0,0,0),(283,252,2,181,136,38,51,1617276600,1617278400,0,0,0),(285,252,4,181,136,38,51,1617276600,1617278400,0,0,0),(286,252,1,183,136,39,52,1617276600,1617278400,0,0,0),(287,252,4,183,136,39,52,1617276600,1617278400,0,0,0),(288,252,3,184,136,40,53,1617276600,1617278400,0,0,0),(289,252,5,184,136,40,53,1617276600,1617278400,0,0,0),(290,252,2,182,136,41,54,1617276600,1617278400,0,0,0),(291,252,5,182,136,41,54,1617276600,1617278400,0,0,0),(292,252,6,205,136,44,57,1617276600,1617278400,0,0,0),(293,252,7,205,136,44,57,1617276600,1617278400,0,0,0),(294,252,3,177,136,45,58,1617276600,1617278400,0,0,0),(295,252,5,177,136,45,58,1617276600,1617278400,0,0,0),(296,252,1,176,136,46,59,1617276600,1617278400,0,0,0),(297,252,2,176,136,46,59,1617276600,1617278400,0,0,0),(298,252,3,176,136,46,59,1617276600,1617278400,0,0,0),(299,252,4,176,136,46,59,1617276600,1617278400,0,0,0),(300,252,5,176,136,46,59,1617276600,1617278400,0,0,0),(301,252,6,176,136,46,59,1617276600,1617278400,0,0,0),(302,261,3,180,135,35,48,1617278400,1617280200,0,0,0),(303,261,5,180,135,35,48,1617278400,1617280200,0,0,0),(304,261,1,179,135,36,49,1617278400,1617280200,0,0,0),(305,261,3,179,135,36,49,1617278400,1617280200,0,0,0),(306,261,2,185,135,37,50,1617278400,1617280200,0,0,0),(307,261,4,185,135,37,50,1617278400,1617280200,0,0,0),(308,261,2,181,135,38,51,1617278400,1617280200,0,0,0),(309,261,4,181,135,38,51,1617278400,1617280200,0,0,0),(310,261,1,183,135,39,52,1617278400,1617280200,0,0,0),(311,261,4,183,135,39,52,1617278400,1617280200,0,0,0),(312,261,3,184,135,40,53,1617278400,1617280200,0,0,0),(313,261,5,184,135,40,53,1617278400,1617280200,0,0,0),(314,261,2,182,135,41,54,1617278400,1617280200,0,0,0),(315,261,5,182,135,41,54,1617278400,1617280200,0,0,0),(316,261,6,205,135,44,57,1617278400,1617280200,0,0,0),(317,261,7,205,135,44,57,1617278400,1617280200,0,0,0),(318,261,3,177,135,45,58,1617278400,1617280200,0,0,0),(319,261,5,177,135,45,58,1617278400,1617280200,0,0,0),(320,261,1,176,135,46,59,1617278400,1617280200,0,0,0),(321,261,2,176,135,46,59,1617278400,1617280200,0,0,0),(322,261,3,176,135,46,59,1617278400,1617280200,0,0,0),(323,261,4,176,135,46,59,1617278400,1617280200,0,0,0),(324,261,5,176,135,46,59,1617278400,1617280200,0,0,0),(325,261,6,176,135,46,59,1617278400,1617280200,0,0,0),(326,270,3,180,134,35,48,1617280200,1617282000,0,0,0),(327,270,5,180,134,35,48,1617280200,1617282000,0,0,0),(328,270,1,179,134,36,49,1617280200,1617282000,0,0,0),(329,270,3,179,134,36,49,1617280200,1617282000,0,0,0),(330,270,2,185,134,37,50,1617280200,1617282000,0,0,0),(331,270,4,185,134,37,50,1617280200,1617282000,0,0,0),(332,270,2,181,134,38,51,1617280200,1617282000,0,0,0),(333,270,4,181,134,38,51,1617280200,1617282000,0,0,0),(334,270,1,183,134,39,52,1617280200,1617282000,0,0,0),(335,270,4,183,134,39,52,1617280200,1617282000,0,0,0),(336,270,3,184,134,40,53,1617280200,1617282000,0,0,0),(337,270,5,184,134,40,53,1617280200,1617282000,0,0,0),(338,270,2,182,134,41,54,1617280200,1617282000,0,0,0),(339,270,5,182,134,41,54,1617280200,1617282000,0,0,0),(340,270,6,205,134,44,57,1617280200,1617282000,0,0,0),(341,270,7,205,134,44,57,1617280200,1617282000,0,0,0),(342,270,3,177,134,45,58,1617280200,1617282000,0,0,0),(344,270,5,177,134,45,58,1617280200,1617282000,0,0,0),(345,270,1,176,134,46,59,1617280200,1617282000,0,0,0),(346,270,2,176,134,46,59,1617280200,1617282000,0,0,0),(347,270,3,176,134,46,59,1617280200,1617282000,0,0,0),(348,270,4,176,134,46,59,1617280200,1617282000,0,0,0),(349,270,5,176,134,46,59,1617280200,1617282000,0,0,0),(350,270,6,176,134,46,59,1617280200,1617282000,0,0,0),(351,279,3,180,133,35,48,1617282000,1617283800,0,0,0),(352,279,5,180,133,35,48,1617282000,1617283800,0,0,0),(353,279,1,179,133,36,49,1617282000,1617283800,0,0,0),(354,279,3,179,133,36,49,1617282000,1617283800,0,0,0),(355,279,2,185,133,37,50,1617282000,1617283800,0,0,0),(356,279,4,185,133,37,50,1617282000,1617283800,0,0,0),(357,279,2,181,133,38,51,1617282000,1617283800,0,0,0),(358,279,4,181,133,38,51,1617282000,1617283800,0,0,0),(359,279,1,183,133,39,52,1617282000,1617283800,0,0,0),(360,279,4,183,133,39,52,1617282000,1617283800,0,0,0),(361,279,3,184,133,40,53,1617282000,1617283800,0,0,0),(362,279,5,184,133,40,53,1617282000,1617283800,0,0,0),(363,279,2,182,133,41,54,1617282000,1617283800,0,0,0),(364,279,5,182,133,41,54,1617282000,1617283800,0,0,0),(365,279,6,205,133,44,57,1617282000,1617283800,0,0,0),(366,279,7,205,133,44,57,1617282000,1617283800,0,0,0),(367,279,3,177,133,45,58,1617282000,1617283800,0,0,0),(368,279,5,177,133,45,58,1617282000,1617283800,0,0,0),(369,279,1,176,133,46,59,1617282000,1617283800,0,0,0),(370,279,2,176,133,46,59,1617282000,1617283800,0,0,0),(371,279,6,176,133,46,59,1617282000,1617283800,0,0,0),(372,279,3,176,133,46,59,1617282000,1617283800,0,0,0),(373,279,4,176,133,46,59,1617282000,1617283800,0,0,0),(374,279,5,176,133,46,59,1617282000,1617283800,0,0,0),(375,332,3,180,136,35,48,1617363000,1617364800,0,0,0),(376,332,5,180,136,35,48,1617363000,1617364800,0,0,0),(377,332,1,179,136,36,49,1617363000,1617364800,0,0,0),(378,332,3,179,136,36,49,1617363000,1617364800,0,0,0),(379,332,2,185,136,37,50,1617363000,1617364800,0,0,0),(380,332,4,185,136,37,50,1617363000,1617364800,0,0,0),(381,332,2,181,136,38,51,1617363000,1617364800,0,0,0),(382,332,4,181,136,38,51,1617363000,1617364800,0,0,0),(383,332,1,183,136,39,52,1617363000,1617364800,0,0,0),(384,332,4,183,136,39,52,1617363000,1617364800,0,0,0),(386,332,5,184,136,40,53,1617363000,1617364800,0,0,0),(387,332,2,182,136,41,54,1617363000,1617364800,0,0,0),(388,332,5,182,136,41,54,1617363000,1617364800,0,0,0),(389,332,3,184,136,40,53,1617363000,1617364800,0,0,0),(390,332,6,205,136,44,57,1617363000,1617364800,0,0,0),(391,332,7,205,136,44,57,1617363000,1617364800,0,0,0),(392,332,3,177,136,45,58,1617363000,1617364800,0,0,0),(393,332,5,177,136,45,58,1617363000,1617364800,0,0,0),(394,332,1,176,136,46,59,1617363000,1617364800,0,0,0),(395,332,2,176,136,46,59,1617363000,1617364800,0,0,0),(396,332,3,176,136,46,59,1617363000,1617364800,0,0,0),(397,332,4,176,136,46,59,1617363000,1617364800,0,0,0),(398,332,5,176,136,46,59,1617363000,1617364800,0,0,0),(399,332,6,176,136,46,59,1617363000,1617364800,0,0,0),(401,343,3,180,135,35,48,1617364800,1617366600,0,0,0),(402,343,5,180,135,35,48,1617364800,1617366600,0,0,0),(403,343,1,179,135,36,49,1617364800,1617366600,0,0,0),(404,343,3,179,135,36,49,1617364800,1617366600,0,0,0),(405,343,2,185,135,37,50,1617364800,1617366600,0,0,0),(406,343,4,185,135,37,50,1617364800,1617366600,0,0,0),(407,343,2,181,135,38,51,1617364800,1617366600,0,0,0),(408,343,4,181,135,38,51,1617364800,1617366600,0,0,0),(409,343,1,183,135,39,52,1617364800,1617366600,0,0,0),(410,343,4,183,135,39,52,1617364800,1617366600,0,0,0),(411,343,3,184,135,40,53,1617364800,1617366600,0,0,0),(412,343,5,184,135,40,53,1617364800,1617366600,0,0,0),(413,343,2,182,135,41,54,1617364800,1617366600,0,0,0),(414,343,5,182,135,41,54,1617364800,1617366600,0,0,0),(415,343,6,205,135,44,57,1617364800,1617366600,0,0,0),(416,343,7,205,135,44,57,1617364800,1617366600,0,0,0),(417,343,3,177,135,45,58,1617364800,1617366600,0,0,0),(418,343,5,177,135,45,58,1617364800,1617366600,0,0,0),(419,343,1,176,135,46,59,1617364800,1617366600,0,0,0),(420,343,2,176,135,46,59,1617364800,1617366600,0,0,0),(421,343,3,176,135,46,59,1617364800,1617366600,0,0,0),(422,343,4,176,135,46,59,1617364800,1617366600,0,0,0),(423,343,5,176,135,46,59,1617364800,1617366600,0,0,0),(424,343,6,176,135,46,59,1617364800,1617366600,0,0,0),(425,354,3,180,134,35,48,1617366600,1617368400,0,0,0),(426,354,5,180,134,35,48,1617366600,1617368400,0,0,0),(427,354,1,179,134,36,49,1617366600,1617368400,0,0,0),(428,354,3,179,134,36,49,1617366600,1617368400,0,0,0),(429,354,2,185,134,37,50,1617366600,1617368400,0,0,0),(430,354,4,185,134,37,50,1617366600,1617368400,0,0,0),(431,354,2,181,134,38,51,1617366600,1617368400,0,0,0),(432,354,4,181,134,38,51,1617366600,1617368400,0,0,0),(433,354,1,183,134,39,52,1617366600,1617368400,0,0,0),(434,354,4,183,134,39,52,1617366600,1617368400,0,0,0),(435,354,3,184,134,40,53,1617366600,1617368400,0,0,0),(436,354,5,184,134,40,53,1617366600,1617368400,0,0,0),(437,354,2,182,134,41,54,1617366600,1617368400,0,0,0),(438,354,5,182,134,41,54,1617366600,1617368400,0,0,0),(439,354,6,205,134,44,57,1617366600,1617368400,0,0,0),(440,354,7,205,134,44,57,1617366600,1617368400,0,0,0),(441,354,3,177,134,45,58,1617366600,1617368400,0,0,0),(442,354,5,177,134,45,58,1617366600,1617368400,0,0,0),(443,354,1,176,134,46,59,1617366600,1617368400,0,0,0),(444,354,2,176,134,46,59,1617366600,1617368400,0,0,0),(445,354,3,176,134,46,59,1617366600,1617368400,0,0,0),(446,354,4,176,134,46,59,1617366600,1617368400,0,0,0),(447,354,5,176,134,46,59,1617366600,1617368400,0,0,0),(448,354,6,176,134,46,59,1617366600,1617368400,0,0,0),(449,375,3,180,133,35,48,1617368400,1617370200,0,0,0),(450,375,5,180,133,35,48,1617368400,1617370200,0,0,0),(451,375,1,179,133,36,49,1617368400,1617370200,0,0,0),(452,375,3,179,133,36,49,1617368400,1617370200,0,0,0),(453,375,2,185,133,37,50,1617368400,1617370200,0,0,0),(454,375,4,185,133,37,50,1617368400,1617370200,0,0,0),(455,375,2,181,133,38,51,1617368400,1617370200,0,0,0),(456,375,4,181,133,38,51,1617368400,1617370200,0,0,0),(457,375,1,183,133,39,52,1617368400,1617370200,0,0,0),(458,375,4,183,133,39,52,1617368400,1617370200,0,0,0),(459,375,3,184,133,40,53,1617368400,1617370200,0,0,0),(460,375,5,184,133,40,53,1617368400,1617370200,0,0,0),(461,375,2,182,133,41,54,1617368400,1617370200,0,0,0),(462,375,5,182,133,41,54,1617368400,1617370200,0,0,0),(463,375,6,205,133,44,57,1617368400,1617370200,0,0,0),(464,375,7,205,133,44,57,1617368400,1617370200,0,0,0),(465,375,3,177,133,45,58,1617368400,1617370200,0,0,0),(466,375,5,177,133,45,58,1617368400,1617370200,0,0,0),(467,375,1,176,133,46,59,1617368400,1617370200,0,0,0),(468,375,2,176,133,46,59,1617368400,1617370200,0,0,0),(469,375,3,176,133,46,59,1617368400,1617370200,0,0,0),(470,375,4,176,133,46,59,1617368400,1617370200,0,0,0),(471,375,5,176,133,46,59,1617368400,1617370200,0,0,0),(472,375,6,176,133,46,59,1617368400,1617370200,0,0,0),(473,386,3,180,132,35,48,1617370200,1617372000,0,0,0),(474,386,5,180,132,35,48,1617370200,1617372000,0,0,0),(475,386,1,179,132,36,49,1617370200,1617372000,0,0,0),(476,386,3,179,132,36,49,1617370200,1617372000,0,0,0),(477,386,2,185,132,37,50,1617370200,1617372000,0,0,0),(479,386,4,185,132,37,50,1617370200,1617372000,0,0,0),(480,386,2,181,132,38,51,1617370200,1617372000,0,0,0),(481,386,4,181,132,38,51,1617370200,1617372000,0,0,0),(482,386,1,183,132,39,52,1617370200,1617372000,0,0,0),(483,386,4,183,132,39,52,1617370200,1617372000,0,0,0),(484,386,3,184,132,40,53,1617370200,1617372000,0,0,0),(485,386,5,184,132,40,53,1617370200,1617372000,0,0,0),(486,386,2,182,132,41,54,1617370200,1617372000,0,0,0),(487,386,5,182,132,41,54,1617370200,1617372000,0,0,0),(488,386,6,205,132,44,57,1617370200,1617372000,0,0,0),(489,386,7,205,132,44,57,1617370200,1617372000,0,0,0),(490,386,3,177,132,45,58,1617370200,1617372000,0,0,0),(491,386,5,177,132,45,58,1617370200,1617372000,0,0,0),(492,386,1,176,132,46,59,1617370200,1617372000,0,0,0),(493,386,2,176,132,46,59,1617370200,1617372000,0,0,0),(494,386,3,176,132,46,59,1617370200,1617372000,0,0,0),(495,386,4,176,132,46,59,1617370200,1617372000,0,0,0),(496,386,5,176,132,46,59,1617370200,1617372000,0,0,0),(497,386,6,176,132,46,59,1617370200,1617372000,0,0,0),(498,397,3,180,131,35,48,1617372000,1617373800,0,0,0),(499,397,5,180,131,35,48,1617372000,1617373800,0,0,0),(500,397,3,179,131,36,49,1617372000,1617373800,0,0,0),(502,397,1,179,131,36,49,1617372000,1617373800,0,0,0),(503,397,2,185,131,37,50,1617372000,1617373800,0,0,0),(504,397,4,185,131,37,50,1617372000,1617373800,0,0,0),(505,397,2,181,131,38,51,1617372000,1617373800,0,0,0),(506,397,4,181,131,38,51,1617372000,1617373800,0,0,0),(507,397,1,183,131,39,52,1617372000,1617373800,0,0,0),(508,397,4,183,131,39,52,1617372000,1617373800,0,0,0),(509,397,3,184,131,40,53,1617372000,1617373800,0,0,0),(510,397,5,184,131,40,53,1617372000,1617373800,0,0,0),(511,397,2,182,131,41,54,1617372000,1617373800,0,0,0),(512,397,5,182,131,41,54,1617372000,1617373800,0,0,0),(513,397,6,205,131,44,57,1617372000,1617373800,0,0,0),(514,397,7,205,131,44,57,1617372000,1617373800,0,0,0),(515,397,3,177,131,45,58,1617372000,1617373800,0,0,0),(516,397,5,177,131,45,58,1617372000,1617373800,0,0,0),(517,397,1,176,131,46,59,1617372000,1617373800,0,0,0),(518,397,2,176,131,46,59,1617372000,1617373800,0,0,0),(519,397,3,176,131,46,59,1617372000,1617373800,0,0,0),(520,397,4,176,131,46,59,1617372000,1617373800,0,0,0),(521,397,5,176,131,46,59,1617372000,1617373800,0,0,0),(522,397,6,176,131,46,59,1617372000,1617373800,0,0,0),(523,408,3,180,130,35,48,1617373800,1617375600,0,0,0),(524,408,5,180,130,35,48,1617373800,1617375600,0,0,0),(525,408,1,179,130,36,49,1617373800,1617375600,0,0,0),(526,408,3,179,130,36,49,1617373800,1617375600,0,0,0),(527,408,2,185,130,37,50,1617373800,1617375600,0,0,0),(528,408,4,185,130,37,50,1617373800,1617375600,0,0,0),(529,408,2,181,130,38,51,1617373800,1617375600,0,0,0),(530,408,4,181,130,38,51,1617373800,1617375600,0,0,0),(531,408,1,183,130,39,52,1617373800,1617375600,0,0,0),(532,408,4,183,130,39,52,1617373800,1617375600,0,0,0),(533,408,3,184,130,40,53,1617373800,1617375600,0,0,0),(534,408,5,184,130,40,53,1617373800,1617375600,0,0,0),(535,408,2,182,130,41,54,1617373800,1617375600,0,0,0),(536,408,5,182,130,41,54,1617373800,1617375600,0,0,0),(537,408,6,205,130,44,57,1617373800,1617375600,0,0,0),(538,408,7,205,130,44,57,1617373800,1617375600,0,0,0),(539,408,3,177,130,45,58,1617373800,1617375600,0,0,0),(540,408,5,177,130,45,58,1617373800,1617375600,0,0,0),(541,408,1,176,130,46,59,1617373800,1617375600,0,0,0),(542,408,2,176,130,46,59,1617373800,1617375600,0,0,0),(543,408,3,176,130,46,59,1617373800,1617375600,0,0,0),(544,408,4,176,130,46,59,1617373800,1617375600,0,0,0),(545,408,5,176,130,46,59,1617373800,1617375600,0,0,0),(546,408,6,176,130,46,59,1617373800,1617375600,0,0,0),(547,419,3,180,129,35,48,1617375600,1617377400,0,0,0),(548,419,5,180,129,35,48,1617375600,1617377400,0,0,0),(549,419,1,179,129,36,49,1617375600,1617377400,0,0,0),(550,419,3,179,129,36,49,1617375600,1617377400,0,0,0),(551,419,2,185,129,37,50,1617375600,1617377400,0,0,0),(552,419,4,185,129,37,50,1617375600,1617377400,0,0,0),(553,419,2,181,129,38,51,1617375600,1617377400,0,0,0),(554,419,4,181,129,38,51,1617375600,1617377400,0,0,0),(555,419,1,183,129,39,52,1617375600,1617377400,0,0,0),(556,419,4,183,129,39,52,1617375600,1617377400,0,0,0),(557,419,3,184,129,40,53,1617375600,1617377400,0,0,0),(558,419,5,184,129,40,53,1617375600,1617377400,0,0,0),(559,419,2,182,129,41,54,1617375600,1617377400,0,0,0),(560,419,5,182,129,41,54,1617375600,1617377400,0,0,0),(561,419,6,205,129,44,57,1617375600,1617377400,0,0,0),(562,419,7,205,129,44,57,1617375600,1617377400,0,0,0),(563,419,3,177,129,45,58,1617375600,1617377400,0,0,0),(564,419,5,177,129,45,58,1617375600,1617377400,0,0,0),(565,419,1,176,129,46,59,1617375600,1617377400,0,0,0),(566,419,2,176,129,46,59,1617375600,1617377400,0,0,0),(567,419,3,176,129,46,59,1617375600,1617377400,0,0,0),(568,419,4,176,129,46,59,1617375600,1617377400,0,0,0),(569,419,5,176,129,46,59,1617375600,1617377400,0,0,0),(570,419,6,176,129,46,59,1617375600,1617377400,0,0,0),(571,430,3,180,128,35,48,1617377400,1617379200,0,0,0),(572,430,5,180,128,35,48,1617377400,1617379200,0,0,0),(573,430,1,179,128,36,49,1617377400,1617379200,0,0,0),(574,430,3,179,128,36,49,1617377400,1617379200,0,0,0),(575,430,2,185,128,37,50,1617377400,1617379200,0,0,0),(576,430,4,185,128,37,50,1617377400,1617379200,0,0,0),(577,430,2,181,128,38,51,1617377400,1617379200,0,0,0),(578,430,4,181,128,38,51,1617377400,1617379200,0,0,0),(579,430,1,183,128,39,52,1617377400,1617379200,0,0,0),(580,430,4,183,128,39,52,1617377400,1617379200,0,0,0),(581,430,3,184,128,40,53,1617377400,1617379200,0,0,0),(582,430,5,184,128,40,53,1617377400,1617379200,0,0,0),(583,430,2,182,128,41,54,1617377400,1617379200,0,0,0),(584,430,5,182,128,41,54,1617377400,1617379200,0,0,0),(585,430,6,205,128,44,57,1617377400,1617379200,0,0,0),(586,430,7,205,128,44,57,1617377400,1617379200,0,0,0),(587,430,3,177,128,45,58,1617377400,1617379200,0,0,0),(588,430,5,177,128,45,58,1617377400,1617379200,0,0,0),(595,430,1,176,128,46,59,1617377400,1617379200,0,0,0),(596,430,2,176,128,46,59,1617377400,1617379200,0,0,0),(597,430,3,176,128,46,59,1617377400,1617379200,0,0,0),(598,430,4,176,128,46,59,1617377400,1617379200,0,0,0),(599,430,6,176,128,46,59,1617377400,1617379200,0,0,0),(600,430,5,176,128,46,59,1617377400,1617379200,0,0,0),(601,332,1,204,136,34,55,1617363000,1617364800,0,0,0),(602,337,2,205,136,34,57,1617372000,1617373800,0,0,0);

--
-- Table structure for table `kgs_upload_document`
--

CREATE TABLE `kgs_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,
  `background_image_name` varchar(50) DEFAULT NULL,
  `background_image_path` varchar(100) DEFAULT NULL,
  `institute_name` varchar(100) DEFAULT NULL,
  `columnbackground_image_path` varchar(50) DEFAULT NULL,
  `institute_full_name` varchar(200) DEFAULT NULL,
  `logo_print_left` varchar(100) DEFAULT NULL,
  `logo_print_right` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgs_upload_document`
--

INSERT INTO `kgs_upload_document` VALUES (1,'#a74538','1624968829_3a29954e6bfaada0fbe8.png','logo_and_favicon/1624968829_3a29954e6bfaada0fbe8.png','1613126380_8f660e84f951dec6be06.jpg','logo_and_favicon/1613126380_8f660e84f951dec6be06.jpg','1613126693_a012982cf75d8c85991b.jpg','logo_and_favicon/1613126693_a012982cf75d8c85991b.jpg',1,1,1,'1617372186_2eb87c45b08a1bcf2b5d.jpg','logo_and_favicon/1617372186_2eb87c45b08a1bcf2b5d.jpg','KGS',NULL,'Kalyan Gayan Samaj\'s Dinkar Sangeet Vidyalaya','logo_and_favicon/left-icon-logo-fee.png','logo_and_favicon/right-icon-logo-fee.png');

--
-- Table structure for table `kgs_uploadimage`
--

CREATE TABLE `kgs_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=154 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgs_uploadimage`
--

INSERT INTO `kgs_uploadimage` VALUES (58,'1613131907_2cc99b379084f2337afb.jpg','student/1613131907_2cc99b379084f2337afb.jpg','Hydrangeas.jpg','document','138','jpg','document',0,'student'),(59,'1613132373_7c14348bcfe0799097db.jpg','student/1613132373_7c14348bcfe0799097db.jpg',NULL,NULL,'138',NULL,'photo',NULL,NULL),(60,'1613830078_91b97b43cd633370340f.jpg','student/1613830078_91b97b43cd633370340f.jpg',NULL,NULL,'141',NULL,'photo',NULL,NULL),(61,'1642771484_dbddadf09f0e17ccb560.jpg','student/1642771484_dbddadf09f0e17ccb560.jpg',NULL,NULL,'1381',NULL,'photo',NULL,NULL),(62,'1642774150_1b55d8a92329e7c2a422.jpg','student/1642774150_1b55d8a92329e7c2a422.jpg',NULL,NULL,'1380',NULL,'photo',NULL,NULL),(63,'1646662399_ee1f3ca3c62f16603fd9.jpg','student/1646662399_ee1f3ca3c62f16603fd9.jpg',NULL,NULL,'1379',NULL,'photo',NULL,NULL),(64,'1646403911_9d943bc77e58e1cc43ca.jpg','student/1646403911_9d943bc77e58e1cc43ca.jpg',NULL,NULL,'1377',NULL,'photo',NULL,NULL),(65,'1646490333_76030c32f95b3b4a82cb.jpg','student/1646490333_76030c32f95b3b4a82cb.jpg',NULL,NULL,'1376',NULL,'photo',NULL,NULL),(66,'1646490452_9760fe374b606dbb9494.jpg','student/1646490452_9760fe374b606dbb9494.jpg',NULL,NULL,'1375',NULL,'photo',NULL,NULL),(67,'1642774612_bdbe2b1f6fa51ab4f0b9.jpg','student/1642774612_bdbe2b1f6fa51ab4f0b9.jpg',NULL,NULL,'1374',NULL,'photo',NULL,NULL),(68,'1646407024_8a2099958182d30adb44.jpg','student/1646407024_8a2099958182d30adb44.jpg',NULL,NULL,'1373',NULL,'photo',NULL,NULL),(69,'1646662508_6e66e8f53c4f91fb410a.jpg','student/1646662508_6e66e8f53c4f91fb410a.jpg',NULL,NULL,'1372',NULL,'photo',NULL,NULL),(70,'1646490371_cd3520d37c4d98463d6e.jpg','student/1646490371_cd3520d37c4d98463d6e.jpg',NULL,NULL,'1370',NULL,'photo',NULL,NULL),(71,'1646663980_a39aa9eb51b233580208.jpg','student/1646663980_a39aa9eb51b233580208.jpg',NULL,NULL,'1369',NULL,'photo',NULL,NULL),(72,'1646663952_d1d8402a517aca239aa1.jpg','student/1646663952_d1d8402a517aca239aa1.jpg',NULL,NULL,'1368',NULL,'photo',NULL,NULL),(73,'1646665850_f78acd28af9b03763d8d.jpg','student/1646665850_f78acd28af9b03763d8d.jpg',NULL,NULL,'1367',NULL,'photo',NULL,NULL),(74,'1642774927_9aac5c41724adc7107e3.jpg','student/1642774927_9aac5c41724adc7107e3.jpg',NULL,NULL,'1366',NULL,'photo',NULL,NULL),(75,'1642774955_b7805321b2799cd7471e.jpg','student/1642774955_b7805321b2799cd7471e.jpg',NULL,NULL,'1365',NULL,'photo',NULL,NULL),(76,'1646403498_68dc80eaae76cd6028ad.jpg','student/1646403498_68dc80eaae76cd6028ad.jpg',NULL,NULL,'1364',NULL,'photo',NULL,NULL),(77,'1643463397_d40330c5ce9445b116fa.jpg','student/1643463397_d40330c5ce9445b116fa.jpg',NULL,NULL,'1338',NULL,'photo',NULL,NULL),(78,'1646403432_e60a3e9192a6667495f9.jpg','student/1646403432_e60a3e9192a6667495f9.jpg',NULL,NULL,'1319',NULL,'photo',NULL,NULL),(79,'1646403541_34c307f685c0333b76be.jpg','student/1646403541_34c307f685c0333b76be.jpg',NULL,NULL,'1314',NULL,'photo',NULL,NULL),(80,'1646403588_0fba3fda1e6f44355653.jpg','student/1646403588_0fba3fda1e6f44355653.jpg',NULL,NULL,'1311',NULL,'photo',NULL,NULL),(81,'1646403732_adb4dbe9fd7ef6a9e9b7.jpg','student/1646403732_adb4dbe9fd7ef6a9e9b7.jpg',NULL,NULL,'1333',NULL,'photo',NULL,NULL),(82,'1646403819_d0a0f2d5b99cbb1fcc82.jpg','student/1646403819_d0a0f2d5b99cbb1fcc82.jpg',NULL,NULL,'1400',NULL,'photo',NULL,NULL),(83,'1646403974_ca4c9f04189e98b17fc2.jpg','student/1646403974_ca4c9f04189e98b17fc2.jpg',NULL,NULL,'1304',NULL,'photo',NULL,NULL),(84,'1646404134_d52c2ab87435322c2ada.jpg','student/1646404134_d52c2ab87435322c2ada.jpg',NULL,NULL,'1325',NULL,'photo',NULL,NULL),(85,'1646407057_c65a573e9a4b12404726.jpg','student/1646407057_c65a573e9a4b12404726.jpg',NULL,NULL,'1390',NULL,'photo',NULL,NULL),(86,'1646407091_abc0d4b1e54e4e059748.jpg','student/1646407091_abc0d4b1e54e4e059748.jpg',NULL,NULL,'1270',NULL,'photo',NULL,NULL),(87,'1646407226_8de5be2746dc77b84327.jpg','student/1646407226_8de5be2746dc77b84327.jpg',NULL,NULL,'1286',NULL,'photo',NULL,NULL),(88,'1646407254_10852ffff74a8a8d9773.jpg','student/1646407254_10852ffff74a8a8d9773.jpg',NULL,NULL,'1342',NULL,'photo',NULL,NULL),(89,'1646407290_65f08dd9452758f0c6d7.jpg','student/1646407290_65f08dd9452758f0c6d7.jpg',NULL,NULL,'1385',NULL,'photo',NULL,NULL),(90,'1646407344_a41e13c897f087c28278.jpg','student/1646407344_a41e13c897f087c28278.jpg',NULL,NULL,'1312',NULL,'photo',NULL,NULL),(91,'1646407373_66c767138df4aec2edbf.jpg','student/1646407373_66c767138df4aec2edbf.jpg',NULL,NULL,'1389',NULL,'photo',NULL,NULL),(92,'1646407414_3ffd1a1fb1f0933c805d.jpg','student/1646407414_3ffd1a1fb1f0933c805d.jpg',NULL,NULL,'1287',NULL,'photo',NULL,NULL),(93,'1646407441_fdfb79389d6f961f0b49.jpg','student/1646407441_fdfb79389d6f961f0b49.jpg',NULL,NULL,'1330',NULL,'photo',NULL,NULL),(94,'1646407479_574d88c825d185abf0b3.jpg','student/1646407479_574d88c825d185abf0b3.jpg',NULL,NULL,'1331',NULL,'photo',NULL,NULL),(95,'1646407521_da74db69f074c895adba.jpg','student/1646407521_da74db69f074c895adba.jpg',NULL,NULL,'1292',NULL,'photo',NULL,NULL),(96,'1646407566_a10656250c8b631cf3be.jpg','student/1646407566_a10656250c8b631cf3be.jpg',NULL,NULL,'1384',NULL,'photo',NULL,NULL),(97,'1646407594_30e406fce36f4236afa5.jpg','student/1646407594_30e406fce36f4236afa5.jpg',NULL,NULL,'1393',NULL,'photo',NULL,NULL),(98,'1646407745_e80f6db7c5d1a121a764.jpg','student/1646407745_e80f6db7c5d1a121a764.jpg',NULL,NULL,'1356',NULL,'photo',NULL,NULL),(99,'1646407781_7db851e2470ac0bd4df5.jpg','student/1646407781_7db851e2470ac0bd4df5.jpg',NULL,NULL,'1306',NULL,'photo',NULL,NULL),(100,'1646487213_f0a48669cdeaf1800fdd.jpg','student/1646487213_f0a48669cdeaf1800fdd.jpg',NULL,NULL,'1316',NULL,'photo',NULL,NULL),(101,'1646487177_553d188da6d9b0e416ad.jpg','student/1646487177_553d188da6d9b0e416ad.jpg',NULL,NULL,'1403',NULL,'photo',NULL,NULL),(102,'1646487248_80c5774460ec309c9eae.jpg','student/1646487248_80c5774460ec309c9eae.jpg',NULL,NULL,'1383',NULL,'photo',NULL,NULL),(103,'1646487326_3d275b533906437189d3.jpg','student/1646487326_3d275b533906437189d3.jpg',NULL,NULL,'1299',NULL,'photo',NULL,NULL),(104,'1646487369_70b5300527942ce90aa5.jpg','student/1646487369_70b5300527942ce90aa5.jpg',NULL,NULL,'1334',NULL,'photo',NULL,NULL),(105,'1646487407_1cbf6755d17ac014232e.jpg','student/1646487407_1cbf6755d17ac014232e.jpg',NULL,NULL,'1326',NULL,'photo',NULL,NULL),(106,'1646487444_6d092f0c9638afe2640e.jpg','student/1646487444_6d092f0c9638afe2640e.jpg',NULL,NULL,'1324',NULL,'photo',NULL,NULL),(107,'1646487474_18762f26f7d9ca907d6f.jpg','student/1646487474_18762f26f7d9ca907d6f.jpg',NULL,NULL,'1317',NULL,'photo',NULL,NULL),(108,'1646487533_f46402c8c0823dae0e1a.jpg','student/1646487533_f46402c8c0823dae0e1a.jpg',NULL,NULL,'1329',NULL,'photo',NULL,NULL),(109,'1646487875_2c281bc2b4084b039a12.jpg','student/1646487875_2c281bc2b4084b039a12.jpg',NULL,NULL,'1397',NULL,'photo',NULL,NULL),(110,'1646487991_4785aeb5d4ce9c0bd812.jpg','student/1646487991_4785aeb5d4ce9c0bd812.jpg',NULL,NULL,'1396',NULL,'photo',NULL,NULL),(111,'1646488985_5fdcadbb0a718216542f.jpg','student/1646488985_5fdcadbb0a718216542f.jpg',NULL,NULL,'1285',NULL,'photo',NULL,NULL),(112,'1646489038_29b65d3fd73c44ee7a54.jpg','student/1646489038_29b65d3fd73c44ee7a54.jpg',NULL,NULL,'1340',NULL,'photo',NULL,NULL),(113,'1646489079_d8630cff8b4a4a53d660.jpg','student/1646489079_d8630cff8b4a4a53d660.jpg',NULL,NULL,'1391',NULL,'photo',NULL,NULL),(114,'1646489121_1b3ee4850028ed66978a.jpg','student/1646489121_1b3ee4850028ed66978a.jpg',NULL,NULL,'1392',NULL,'photo',NULL,NULL),(115,'1646489147_8df19b72fae6d8420f3f.jpg','student/1646489147_8df19b72fae6d8420f3f.jpg',NULL,NULL,'1295',NULL,'photo',NULL,NULL),(116,'1646489176_b54c71d98749b0c589c7.jpg','student/1646489176_b54c71d98749b0c589c7.jpg',NULL,NULL,'1291',NULL,'photo',NULL,NULL),(117,'1646489248_6ba29ee72beea394380c.jpg','student/1646489248_6ba29ee72beea394380c.jpg',NULL,NULL,'1347',NULL,'photo',NULL,NULL),(118,'1646489283_53bf8dea7e4d62ded5f6.jpg','student/1646489283_53bf8dea7e4d62ded5f6.jpg',NULL,NULL,'1399',NULL,'photo',NULL,NULL),(119,'1646489327_a47876f467c44213b0ab.jpg','student/1646489327_a47876f467c44213b0ab.jpg',NULL,NULL,'1343',NULL,'photo',NULL,NULL),(120,'1646489389_bd5dfb88fe940a9bc4b0.jpg','student/1646489389_bd5dfb88fe940a9bc4b0.jpg',NULL,NULL,'1337',NULL,'photo',NULL,NULL),(121,'1646489795_04cec0e3a7da08a38ea9.jpg','student/1646489795_04cec0e3a7da08a38ea9.jpg',NULL,NULL,'1328',NULL,'photo',NULL,NULL),(122,'1646489859_90406b78d78be7f15f6f.jpg','student/1646489859_90406b78d78be7f15f6f.jpg',NULL,NULL,'1302',NULL,'photo',NULL,NULL),(123,'1646489937_1a10c556d7d1cced4c53.jpg','student/1646489937_1a10c556d7d1cced4c53.jpg',NULL,NULL,'1315',NULL,'photo',NULL,NULL),(124,'1646490021_77f1d4775041a8adb22d.jpg','student/1646490021_77f1d4775041a8adb22d.jpg',NULL,NULL,'1323',NULL,'photo',NULL,NULL),(125,'1646490293_92d41b49e468dadb6d7f.jpg','student/1646490293_92d41b49e468dadb6d7f.jpg',NULL,NULL,'1387',NULL,'photo',NULL,NULL),(126,'1646490418_cd44cb3d257bb5aaf7b1.jpg','student/1646490418_cd44cb3d257bb5aaf7b1.jpg',NULL,NULL,'1321',NULL,'photo',NULL,NULL),(127,'1646662060_fb8021c1a2b044329040.jpg','student/1646662060_fb8021c1a2b044329040.jpg',NULL,NULL,'1388',NULL,'photo',NULL,NULL),(128,'1646662201_0d72e21df485bcee3583.jpg','student/1646662201_0d72e21df485bcee3583.jpg',NULL,NULL,'1322',NULL,'photo',NULL,NULL),(129,'1646662322_74d2681aa79c975a60e8.jpg','student/1646662322_74d2681aa79c975a60e8.jpg',NULL,NULL,'1296',NULL,'photo',NULL,NULL),(130,'1646663609_ac851f5ec8c0f5acc347.jpg','student/1646663609_ac851f5ec8c0f5acc347.jpg',NULL,NULL,'1263',NULL,'photo',NULL,NULL),(131,'1646663647_d2431c5c348642efe9e1.jpg','student/1646663647_d2431c5c348642efe9e1.jpg',NULL,NULL,'1353',NULL,'photo',NULL,NULL),(132,'1646663692_bd4dac1f00d30dc88065.jpg','student/1646663692_bd4dac1f00d30dc88065.jpg',NULL,NULL,'1335',NULL,'photo',NULL,NULL),(133,'1646663721_eef983118de9411e8dcd.jpg','student/1646663721_eef983118de9411e8dcd.jpg',NULL,NULL,'1336',NULL,'photo',NULL,NULL),(134,'1646663781_43d239bbc8251ea51200.jpg','student/1646663781_43d239bbc8251ea51200.jpg',NULL,NULL,'1303',NULL,'photo',NULL,NULL),(135,'1646663880_1628dd2c4902e3744865.jpg','student/1646663880_1628dd2c4902e3744865.jpg',NULL,NULL,'1327',NULL,'photo',NULL,NULL),(136,'1646663921_bce717dd69dc91f8a9e2.jpg','student/1646663921_bce717dd69dc91f8a9e2.jpg',NULL,NULL,'1407',NULL,'photo',NULL,NULL),(137,'1646664036_c3cf5d4c54b293bd7da6.jpg','student/1646664036_c3cf5d4c54b293bd7da6.jpg',NULL,NULL,'1398',NULL,'photo',NULL,NULL),(138,'1646664203_1380e5c1d49529964e05.jpg','student/1646664203_1380e5c1d49529964e05.jpg',NULL,NULL,'1300',NULL,'photo',NULL,NULL),(139,'1646664293_362f1dea3674c62a8c87.jpg','student/1646664293_362f1dea3674c62a8c87.jpg',NULL,NULL,'1402',NULL,'photo',NULL,NULL),(140,'1646664332_42a2df53b0c7617b01c6.jpg','student/1646664332_42a2df53b0c7617b01c6.jpg',NULL,NULL,'1382',NULL,'photo',NULL,NULL),(141,'1646665895_a0565d053c95ac64b119.jpg','student/1646665895_a0565d053c95ac64b119.jpg',NULL,NULL,'1313',NULL,'photo',NULL,NULL),(142,'1646665980_51b595a0420fb0e7f81f.jpg','student/1646665980_51b595a0420fb0e7f81f.jpg',NULL,NULL,'1272',NULL,'photo',NULL,NULL),(143,'1646666013_7a7f3b372740769443e6.jpg','student/1646666013_7a7f3b372740769443e6.jpg',NULL,NULL,'1386',NULL,'photo',NULL,NULL),(144,'1653573965_fb012b19a47f45fb714f.jpg','student/1653573965_fb012b19a47f45fb714f.jpg',NULL,NULL,'1440',NULL,'photo',NULL,NULL),(145,'1653574056_e56cac0ad3a880cb448e.jpg','student/1653574056_e56cac0ad3a880cb448e.jpg',NULL,NULL,'1447',NULL,'photo',NULL,NULL),(146,'1653575104_e24d2413b6f40ccdae3f.jpg','student/1653575104_e24d2413b6f40ccdae3f.jpg',NULL,NULL,'1437',NULL,'photo',NULL,NULL),(147,'1653575144_8e704494a680735b75f7.jpg','student/1653575144_8e704494a680735b75f7.jpg',NULL,NULL,'1449',NULL,'photo',NULL,NULL),(148,'1653575439_36de717f624ad8b32005.jpg','student/1653575439_36de717f624ad8b32005.jpg',NULL,NULL,'1442',NULL,'photo',NULL,NULL),(149,'1653575515_39f0209460db18ebf6a7.jpg','student/1653575515_39f0209460db18ebf6a7.jpg',NULL,NULL,'1439',NULL,'photo',NULL,NULL),(150,'1653575998_ac31022c6c1f3f3b9523.jpg','student/1653575998_ac31022c6c1f3f3b9523.jpg',NULL,NULL,'1436',NULL,'photo',NULL,NULL),(151,'1653576039_ae6a942666e103898cb2.jpg','student/1653576039_ae6a942666e103898cb2.jpg',NULL,NULL,'1443',NULL,'photo',NULL,NULL),(152,'1653576118_893c71ce7fae13a45f53.jpg','student/1653576118_893c71ce7fae13a45f53.jpg',NULL,NULL,'1444',NULL,'photo',NULL,NULL),(153,'1653576386_c381a7924de4411b72c4.jpg','student/1653576386_c381a7924de4411b72c4.jpg',NULL,NULL,'1435',NULL,'photo',NULL,NULL);

--
-- Table structure for table `kgs_user_attendance`
--

CREATE TABLE `kgs_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=306 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgs_user_attendance`
--

INSERT INTO `kgs_user_attendance` VALUES (293,'189','1613068200','1',3),(294,'190','1613068200','2',3),(295,'192','1613068200','1',12),(296,'174','1613068200','1',2),(297,'175','1613068200','3',2),(298,'176','1613068200','2',2),(299,'177','1613068200','2',2),(300,'178','1613068200','2',2),(301,'180','1613068200','2',2),(302,'181','1613068200','3',2),(303,'183','1613068200','1',2),(304,'192','4768741800','1',29),(305,'192','4768828200','9',29);

--
-- Table structure for table `kgs_user_permission`
--

CREATE TABLE `kgs_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=1490 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgs_user_permission`
--

INSERT INTO `kgs_user_permission` VALUES (1413,'1','87','1'),(1414,'1','88','1'),(1415,'1','89','1'),(1416,'1','90','1'),(1417,'1','91','1'),(1418,'1','92','1'),(1419,'1','93','1'),(1420,'191','87','1'),(1421,'191','88','0'),(1422,'191','89','0'),(1423,'191','90','0'),(1424,'191','91','0'),(1425,'191','92','0'),(1426,'191','93','1'),(1427,'192','87','1'),(1428,'192','88','1'),(1429,'192','89','1'),(1430,'192','90','1'),(1431,'192','91','0'),(1432,'192','92','0'),(1433,'192','93','0'),(1434,'174','87','1'),(1435,'174','88','1'),(1436,'174','89','1'),(1437,'174','90','1'),(1438,'174','91','1'),(1439,'174','92','1'),(1440,'174','93','1'),(1441,'175','87','1'),(1442,'175','88','1'),(1443,'175','89','1'),(1444,'175','90','1'),(1445,'175','91','0'),(1446,'175','92','1'),(1447,'175','93','0'),(1448,'183','87','1'),(1449,'183','88','1'),(1450,'183','89','1'),(1451,'183','90','1'),(1452,'183','91','0'),(1453,'183','92','1'),(1454,'183','93','0'),(1455,'182','87','1'),(1456,'182','88','0'),(1457,'182','89','0'),(1458,'182','90','0'),(1459,'182','91','0'),(1460,'182','92','0'),(1461,'182','93','0'),(1462,'177','87','1'),(1463,'177','88','1'),(1464,'177','89','1'),(1465,'177','90','1'),(1466,'177','91','0'),(1467,'177','92','1'),(1468,'177','93','0'),(1469,'181','87','1'),(1470,'181','88','1'),(1471,'181','89','1'),(1472,'181','90','1'),(1473,'181','91','0'),(1474,'181','92','1'),(1475,'181','93','0'),(1476,'176','87','1'),(1477,'176','88','1'),(1478,'176','89','1'),(1479,'176','90','1'),(1480,'176','91','0'),(1481,'176','92','1'),(1482,'176','93','0'),(1483,'190','87','0'),(1484,'190','88','0'),(1485,'190','89','0'),(1486,'190','90','0'),(1487,'190','91','0'),(1488,'190','92','0'),(1489,'190','93','0');

--
-- Table structure for table `kgs_vch_type`
--

CREATE TABLE `kgs_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=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgs_vch_type`
--

INSERT INTO `kgs_vch_type` VALUES (1,'Cash',0),(2,'cheque',0),(3,'bank',0);

--
-- Table structure for table `kgs_work_description`
--

CREATE TABLE `kgs_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=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgs_work_description`
--

INSERT INTO `kgs_work_description` VALUES (4,' learn basic theroy','183','1613327400','0',75,NULL,NULL),(5,'5 min Teental Solo','183','1613845800','0',75,NULL,NULL),(6,'Video on tabla saaz','182','1616956200','1',136,41,NULL);

--
-- Table structure for table `kgserp_Event`
--

CREATE TABLE `kgserp_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 AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_Event`
--

INSERT INTO `kgserp_Event` VALUES (11,'Music_competition','student have to participate in this','1614191400','1614450599','1000','0'),(12,'Practical Exam','','1613759400','1613845799','','0');

--
-- Table structure for table `kgserp_accounting`
--

CREATE TABLE `kgserp_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` enum('credit','debit') 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,
  `details` text,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgserp_accounting`
--

INSERT INTO `kgserp_accounting` VALUES (13,'1613845800','Instrument Repairing','20-2-01','1','debit','450','189',0,'no',NULL),(14,'1614154059','student fee','52','fee','credit','850','138',0,'yes',NULL),(15,'1614154067','student fee','52','fee','credit','850','138',0,'yes',NULL);

--
-- Table structure for table `kgserp_add_class`
--

CREATE TABLE `kgserp_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 AUTO_INCREMENT=89 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgserp_add_class`
--

INSERT INTO `kgserp_add_class` VALUES (75,'Music_class','0'),(76,'TABLA (Snehal Kumar)','0'),(77,'VOCAL','0'),(78,'Lite','0'),(79,'HARMONIUM','0'),(80,'Flute','0'),(81,'KATHAK','0'),(82,'BHARATNATYAM','0'),(83,'Drawing','0'),(84,'BASARI','1'),(85,'ujjnu9im',NULL),(86,'abc','0'),(87,'Tabla (Swapnil)','0'),(88,'TABLA','0');

--
-- Table structure for table `kgserp_add_field`
--

CREATE TABLE `kgserp_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 `kgserp_add_field`
--


--
-- Table structure for table `kgserp_add_section`
--

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

--
-- Dumping data for table `kgserp_add_section`
--

INSERT INTO `kgserp_add_section` VALUES (18,'A',NULL),(19,'B',NULL),(20,'C',NULL),(21,'DSV-AU',0),(22,'MKA',0),(23,'DSV-TABLA-Snehal',0),(24,'DSV-C',0),(25,'DSV-D',0);

--
-- Table structure for table `kgserp_add_subject`
--

CREATE TABLE `kgserp_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 AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_add_subject`
--

INSERT INTO `kgserp_add_subject` VALUES (39,'Tabla ',0),(40,'Vocal Classical',0),(41,'Flute',0),(42,'Harmonium',0),(43,'Dance (Kathak)',0),(44,'Dance (Bharatnatyam)',0),(45,'Vocal Light Music ',0),(46,'Drawing',0);

--
-- Table structure for table `kgserp_address2`
--

CREATE TABLE `kgserp_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 AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_address2`
--

INSERT INTO `kgserp_address2` VALUES (36,'Helsink\r\nHelsink','Helsink\r\nHelsink','123456','0','0','16',138,'student');

--
-- Table structure for table `kgserp_advance_salary`
--

CREATE TABLE `kgserp_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 AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgserp_advance_salary`
--

INSERT INTO `kgserp_advance_salary` VALUES (33,179,'5000','abc',0,'pending','1613133161',NULL,NULL);

--
-- Table structure for table `kgserp_attendance_type`
--

CREATE TABLE `kgserp_attendance_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `delete_status` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgserp_attendance_type`
--

INSERT INTO `kgserp_attendance_type` VALUES (1,'present','1','0'),(2,'absent','1','0'),(3,'leave','1','0'),(4,'summer vacation','1','0'),(5,'winter vacation','1','0'),(6,'boot camp','1','0'),(7,'bio-metric','1','1'),(8,'shd','1','1'),(9,'bio-metric','1','0');

--
-- Table structure for table `kgserp_class_fee`
--

CREATE TABLE `kgserp_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=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgserp_class_fee`
--

INSERT INTO `kgserp_class_fee` VALUES (11,'76','300','300','100','450','1150',2147483647,'1');

--
-- Table structure for table `kgserp_class_subject`
--

CREATE TABLE `kgserp_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=708 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_class_subject`
--

INSERT INTO `kgserp_class_subject` VALUES (697,'75','39'),(698,'75','40'),(699,'75','44'),(700,'76','39'),(701,'77','40'),(702,'78','45'),(703,'79','42'),(704,'80','41'),(705,'81','43'),(706,'82','44'),(707,'83','46');

--
-- Table structure for table `kgserp_class_teacher_list`
--

CREATE TABLE `kgserp_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 `kgserp_class_teacher_list`
--


--
-- Table structure for table `kgserp_custom_event`
--

CREATE TABLE `kgserp_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,
  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 `kgserp_custom_event`
--

INSERT INTO `kgserp_custom_event` VALUES (16,'Test','1614882600','1614968999',NULL,'1',190);

--
-- Table structure for table `kgserp_custom_lecture_request`
--

CREATE TABLE `kgserp_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_custom_lecture_request`
--


--
-- Table structure for table `kgserp_custom_timetable`
--

CREATE TABLE `kgserp_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgserp_custom_timetable`
--


--
-- Table structure for table `kgserp_emi`
--

CREATE TABLE `kgserp_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 `kgserp_emi`
--


--
-- Table structure for table `kgserp_employee_image`
--

CREATE TABLE `kgserp_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=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgserp_employee_image`
--

INSERT INTO `kgserp_employee_image` VALUES (22,'1613131365_04b9cd4f7e3be40f81b1.jpg','employee/1613131365_04b9cd4f7e3be40f81b1.jpg','183');

--
-- Table structure for table `kgserp_employee_order`
--

CREATE TABLE `kgserp_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 `kgserp_employee_order`
--

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

--
-- Table structure for table `kgserp_exam`
--

CREATE TABLE `kgserp_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=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_exam`
--

INSERT INTO `kgserp_exam` VALUES (23,'Prarambhik','0'),(24,'Praveshika Pratham','0'),(25,'Praveshika Purna','0'),(26,'Madhyama Pratham','0'),(27,'Madhyama Purna','0'),(28,'Visharad Pratham','0'),(29,'Visharad Pratham','0');

--
-- Table structure for table `kgserp_fees`
--

CREATE TABLE `kgserp_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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_fees`
--

INSERT INTO `kgserp_fees` VALUES (52,'100','200','50','500','850','138',NULL,NULL,'no','1',0,NULL),(53,'0','0','0','750','750','138',NULL,NULL,'no','1',0,NULL),(54,'100','50','1','500','651','141',NULL,NULL,'yes','1',0,NULL),(55,'0','0','0','0','0','141',NULL,NULL,'yes','1',0,NULL),(56,'0','0','0','450','450','340',NULL,NULL,'no','03',0,NULL),(57,'0','0','0','450','450','339',NULL,NULL,'no','02',0,NULL);

--
-- Table structure for table `kgserp_field_value`
--

CREATE TABLE `kgserp_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `kgserp_field_value`
--


--
-- Table structure for table `kgserp_holiday`
--

CREATE TABLE `kgserp_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=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_holiday`
--

INSERT INTO `kgserp_holiday` VALUES (16,'abc','1613413800','1613586600','3','0'),(17,'Independence Day ','1628965800','1628965800','3','0'),(18,'Independence Day ','1628965800','1628965800','3','1'),(19,'GUDIPADAWA','1618252200','1618252200','3','0');

--
-- Table structure for table `kgserp_island`
--

CREATE TABLE `kgserp_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 `kgserp_island`
--


--
-- Table structure for table `kgserp_item`
--

CREATE TABLE `kgserp_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 `kgserp_item`
--


--
-- Table structure for table `kgserp_jobassignment`
--

CREATE TABLE `kgserp_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=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_jobassignment`
--

INSERT INTO `kgserp_jobassignment` VALUES (31,183,'12345',179,1,NULL,NULL),(32,179,'1234',191,2,NULL,NULL);

--
-- Table structure for table `kgserp_leave_list`
--

CREATE TABLE `kgserp_leave_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `leave_type` int(11) DEFAULT NULL,
  `addStartDate` int(11) DEFAULT NULL,
  `addEndDate` int(11) DEFAULT NULL,
  `leave_teacher_id` int(11) DEFAULT NULL,
  `adjust_teacher` int(11) DEFAULT NULL,
  `teacher_list` varchar(50) DEFAULT NULL,
  `status` enum('pending','accepted','rejected') DEFAULT NULL,
  `delete_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgserp_leave_list`
--

INSERT INTO `kgserp_leave_list` VALUES (74,24,1613586600,1613759399,179,0,'0','',NULL);

--
-- Table structure for table `kgserp_leavetype_list`
--

CREATE TABLE `kgserp_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=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_leavetype_list`
--

INSERT INTO `kgserp_leavetype_list` VALUES (24,'EL',2,0),(25,'SL',7,0),(26,'CL',5,0);

--
-- Table structure for table `kgserp_loan`
--

CREATE TABLE `kgserp_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=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgserp_loan`
--

INSERT INTO `kgserp_loan` VALUES (45,179,'10000','loan for home',0,'accepted',2,NULL,'1613133138','1613133216');

--
-- Table structure for table `kgserp_mass_mail_sms`
--

CREATE TABLE `kgserp_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 `kgserp_mass_mail_sms`
--


--
-- Table structure for table `kgserp_over_time`
--

CREATE TABLE `kgserp_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=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgserp_over_time`
--

INSERT INTO `kgserp_over_time` VALUES (23,179,'10','over time',0,'pending','1613133178',NULL,NULL);

--
-- Table structure for table `kgserp_period`
--

CREATE TABLE `kgserp_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 `kgserp_period`
--


--
-- Table structure for table `kgserp_permission`
--

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

--
-- Dumping data for table `kgserp_permission`
--

INSERT INTO `kgserp_permission` VALUES (87,'User'),(88,'subject'),(89,'attendence'),(90,'marks'),(91,'event'),(92,'salary'),(93,'fee');

--
-- Table structure for table `kgserp_preveducation`
--

CREATE TABLE `kgserp_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=94 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_preveducation`
--

INSERT INTO `kgserp_preveducation` VALUES (93,'vidya niketan','12','80',138,'student');

--
-- Table structure for table `kgserp_registration`
--

CREATE TABLE `kgserp_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=342 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_registration`
--

INSERT INTO `kgserp_registration` VALUES (138,'john','cina','robert','2001-02-13','1','9856543547','John@gmail.com','Jakki abc','Sowam','sector-19 ','sector-19 ','4555','0','0','18','0',NULL,'1','1'),(139,'megh','Prashant','Dandekar','1991-09-18','1','9821546598','megh@gmail.com','prashant','uttara','fghfgf','fghfh','421301','14','0','76','1',NULL,'1','1'),(140,'parth','Ameya','Deshpande','2009-04-24','1','1594872630','parth@123gmail.com','Ameya','Aarya','fghfgf','fghfh','421301','14','0','76','1',NULL,'1','1'),(141,'rasika','Mandar','Abhyankar','2008-09-05','2','3216549875','rasika@gmail.com','Mandar','Neela','fghfgf','fghfh','421301','14','0','76','1',NULL,'1','1'),(142,'AVDHUT','DEMO','SANGALE','2021-01-01','MALE','123456789','demo@demo.com_1','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(143,'CHINMAY','DEMO','WAVHAL','2021-01-01','MALE','123456789','demo@demo.com_2','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(144,'VARAD','DEMO','SHIMPI','2021-01-01','MALE','123456789','demo@demo.com_3','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(145,'RAKSHIT','DEMO','THAKUR','2021-01-01','MALE','123456789','demo@demo.com_4','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(146,'VIJAY','DEMO','WAVU','2021-01-01','MALE','123456789','demo@demo.com_5','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(147,'SUSHIL','DEMO','SHANKPAL','2021-01-01','MALE','123456789','demo@demo.com_6','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(148,'HETAVI','DEMO','HETAVI BHOER','2021-01-01','FEMALE','123456789','demo@demo.com_7','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(149,'YASHITA','DEMO','AATALKAR','2021-01-01','FEMALE','123456789','demo@demo.com_8','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(150,'TRISHA','DEMO','CHAVHAN','2021-01-01','FEMALE','123456789','demo@demo.com_9','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(151,'PRAJKTA','DEMO','DHAWALE','2021-01-01','FEMALE','123456789','demo@demo.com_10','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(152,'DAMINI','DEMO','MORE','2021-01-01','FEMALE','123456789','demo@demo.com_11','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(153,'SARVADNYA','DEMO','SAWANT','2021-01-01','FEMALE','123456789','demo@demo.com_12','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(154,'RUCHI','DEMO','INAMDAR','2021-01-01','FEMALE','123456789','demo@demo.com_13','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(155,'DEVYANI','DEMO','GAIKWAD','2021-01-01','FEMALE','123456789','demo@demo.com_14','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(156,'SHRIYA','DEMO','PITALE','2021-01-01','FEMALE','123456789','demo@demo.com_15','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(157,'RISHA','DEMO','THAKKAR','2021-01-01','FEMALE','123456789','demo@demo.com_16','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(158,'BHAGYASHREE','DEMO','SARAGE','2021-01-01','FEMALE','123456789','demo@demo.com_17','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(159,'PRANJALI','DEMO','HANKARE','2021-01-01','FEMALE','123456789','demo@demo.com_18','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(160,'VIDHI','DEMO','NIKUMBH','2021-01-01','FEMALE','123456789','demo@demo.com_19','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(161,'GIRIJA','DEMO','LADAVA','2021-01-01','FEMALE','123456789','demo@demo.com_20','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(162,'HARSHAVI','DEMO','JAIN','2021-01-01','FEMALE','123456789','demo@demo.com_21','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(163,'VAIDEHI','DEMO','GHORPADE','2021-01-01','FEMALE','123456789','demo@demo.com_22','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(164,'SHRAVANI','DEMO','KULKARNI','2021-01-01','FEMALE','123456789','demo@demo.com_23','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(165,'SUKHADA','DEMO','VEDPATHAK','2021-01-01','FEMALE','123456789','demo@demo.com_24','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(166,'SAMIKSHA','DEMO','WAGALE','2021-01-01','FEMALE','123456789','demo@demo.com_25','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(167,'TANVI','DEMO','SATOSE','2021-01-01','FEMALE','123456789','demo@demo.com_26','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(168,'AARYA','DEMO','PHADNIS','2021-01-01','FEMALE','123456789','demo@demo.com_27','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(169,'AACHAL','DEMO','PATIL','2021-01-01','FEMALE','123456789','demo@demo.com_28','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(170,'SHREYA','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'),(171,'SWARA','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'),(172,'PRACHITI','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'),(173,'JANHAVI','DEMO','SARAGE','2021-01-01','FEMALE','123456789','demo@demo.com_32','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(174,'AAYUSHI','DEMO','KARNIK','2021-01-01','FEMALE','123456789','demo@demo.com_33','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(175,'AARAVA','DEMO','GEDAM','2021-01-01','FEMALE','123456789','demo@demo.com_34','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(176,'SONALI','DEMO','GOKHALE','2021-01-01','FEMALE','123456789','demo@demo.com_35','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(177,'PURVASHRI','DEMO','SARAGE','2021-01-01','FEMALE','123456789','demo@demo.com_36','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(178,'ANUSHKA','DEMO','PILLE','2021-01-01','FEMALE','123456789','demo@demo.com_37','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(179,'JANHAVI','DEMO','SONAVANE','2021-01-01','FEMALE','123456789','demo@demo.com_38','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(180,'SHARAYU','DEMO','VYAVHARE','2021-01-01','FEMALE','123456789','demo@demo.com_39','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(181,'SUPRIYA','DEMO','PALAVE','2021-01-01','FEMALE','123456789','demo@demo.com_40','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(182,'MRUNAL','DEMO','JOSHI','2021-01-01','FEMALE','123456789','demo@demo.com_41','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(183,'ACHALA','DEMO','SHENOY','2021-01-01','FEMALE','123456789','demo@demo.com_42','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(184,'RUCHI','DEMO','DEVKARE','2021-01-01','FEMALE','123456789','demo@demo.com_43','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(185,'LEHER','DEMO','THAKKAR','2021-01-01','FEMALE','123456789','demo@demo.com_44','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(186,'SAYALI','DEMO','AAVHAD','2021-01-01','FEMALE','123456789','demo@demo.com_45','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(187,'SANCHITA','DEMO','CHAUDHARI','2021-01-01','FEMALE','123456789','demo@demo.com_46','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(188,'RADHIKA','DEMO','JOSHI','2021-01-01','FEMALE','123456789','demo@demo.com_47','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(189,'PRAVESHA','DEMO','ACHAREKAR','2021-01-01','FEMALE','123456789','demo@demo.com_48','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(190,'JANHAVI','DEMO','PATEL','2021-01-01','FEMALE','123456789','demo@demo.com_49','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(191,'MANISHA','DEMO','SANGALE','2021-01-01','FEMALE','123456789','demo@demo.com_50','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(192,'MEGHANA','DEMO','SHINDE','2021-01-01','FEMALE','123456789','demo@demo.com_51','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(193,'ANANYA','DEMO','BAGADE','2021-01-01','FEMALE','123456789','demo@demo.com_52','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(194,'SHALMALI','DEMO','PATIL','2021-01-01','FEMALE','123456789','demo@demo.com_53','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(195,'SAEE','DEMO','DAREKAR','2021-01-01','FEMALE','123456789','demo@demo.com_54','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(196,'SAMRUDDHI','DEMO','BHISE','2021-01-01','FEMALE','123456789','demo@demo.com_55','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(197,'KOMAL','DEMO','DIVEKAR','2021-01-01','FEMALE','123456789','demo@demo.com_56','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(198,'RENUKA','DEMO','GHAISAS','2021-01-01','FEMALE','123456789','demo@demo.com_57','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(199,'SWARALI','DEMO','DESHPANDE','2021-01-01','FEMALE','123456789','demo@demo.com_58','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(200,'MOKSHADA','DEMO','BHINGARDE','2021-01-01','FEMALE','123456789','demo@demo.com_59','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(201,'GARVI','DEMO','CHAUHAN','2021-01-01','FEMALE','123456789','demo@demo.com_60','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(202,'DIPTI','DEMO','PATRE','2021-01-01','FEMALE','123456789','demo@demo.com_61','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(203,'ADITI','DEMO','JAHAGIRDAR','2021-01-01','FEMALE','123456789','demo@demo.com_62','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(204,'NEHA','DEMO','WAGH','2021-01-01','FEMALE','123456789','demo@demo.com_63','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(205,'AISHWARYA','DEMO','JOGALEKAR','2021-01-01','FEMALE','123456789','demo@demo.com_69','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(206,'PRAVEENA','DEMO','GAIKWAD','2021-01-01','FEMALE','123456789','demo@demo.com_70','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(207,'SHUBHANGI','DEMO','SINNARKAR','2021-01-01','FEMALE','123456789','demo@demo.com_71','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(208,'ASMITA','DEMO','LAD','2021-01-01','FEMALE','123456789','demo@demo.com_72','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(209,'AAROHI','DEMO','BARVE','2021-01-01','FEMALE','123456789','demo@demo.com_73','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(210,'PALLAVI','DEMO','OVALEKAR/JOSHI','2021-01-01','FEMALE','123456789','demo@demo.com_74','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(211,'SAI','DEMO','DHAMAPURKAR','2021-01-01','FEMALE','123456789','demo@demo.com_75','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(212,'ISHITA','DEMO','PATHAK','2021-01-01','FEMALE','123456789','demo@demo.com_76','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(213,'RUDRA','DEMO','SARDAR','2021-01-01','MALE','123456789','demo@demo.com_77','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(214,'PRIYANKA','DEMO','PATIL','2021-01-01','FEMALE','123456789','demo@demo.com_78','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(215,'CHAITRALI','DEMO','GANORKAR','2021-01-01','FEMALE','123456789','demo@demo.com_79','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(216,'RAKHI','DEMO','DATAR','2021-01-01','FEMALE','123456789','demo@demo.com_80','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(217,'TEJASWINI','DEMO','JADHAV','2021-01-01','FEMALE','123456789','demo@demo.com_81','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(218,'ROSHANI','DEMO','PATRA','2021-01-01','FEMALE','123456789','demo@demo.com_82','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(219,'YASHASHREE','DEMO','KARANDIKAR','2021-01-01','FEMALE','123456789','demo@demo.com_83','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(220,'PADMA','DEMO','GEDAM','2021-01-01','FEMALE','123456789','demo@demo.com_84','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(221,'SARIKA','DEMO','SONAWALE','2021-01-01','FEMALE','123456789','demo@demo.com_85','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(222,'SHILPA','DEMO','KHANGAOKAR','2021-01-01','FEMALE','123456789','demo@demo.com_86','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(223,'SHREYA','DEMO','DESHMUKH','2021-01-01','FEMALE','123456789','demo@demo.com_87','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(224,'AARATI','DEMO','PHAD','2021-01-01','FEMALE','123456789','demo@demo.com_88','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(225,'PRABHATKUMAR','DEMO','SAHU','2021-01-01','FEMALE','123456789','demo@demo.com_89','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(226,'SAMRUDDHI','DEMO','PALNITKAR','2021-01-01','FEMALE','123456789','demo@demo.com_90','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(227,'REKHA','DEMO','PAHADI','2021-01-01','FEMALE','123456789','demo@demo.com_91','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(228,'ROHINI','DEMO','BIDWAI','2021-01-01','FEMALE','123456789','demo@demo.com_92','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(229,'VASUSHREE','DEMO','KINIKAR','2021-01-01','FEMALE','123456789','demo@demo.com_93','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(230,'DIKSHA','DEMO','MARATHE','2021-01-01','FEMALE','123456789','demo@demo.com_94','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(231,'SANIKA','DEMO','JOSHI','2021-01-01','FEMALE','123456789','demo@demo.com_95','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(232,'APURVA','DEMO','CHITALE','2021-01-01','FEMALE','123456789','demo@demo.com_96','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(233,'CHETNA','DEMO','SONAR','2021-01-01','FEMALE','123456789','demo@demo.com_97','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(234,'JAYMALA','DEMO','WAGH','2021-01-01','FEMALE','123456789','demo@demo.com_98','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(235,'DIPTI','DEMO','BHIDE','2021-01-01','FEMALE','123456789','demo@demo.com_99','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(236,'SWAPNALI','DEMO','SUKHATME','2021-01-01','FEMALE','123456789','demo@demo.com_100','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(237,'ANKITA','DEMO','KARNIK','2021-01-01','FEMALE','123456789','demo@demo.com_101','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(238,'HITESHI','DEMO','JAIN','2021-01-01','FEMALE','123456789','demo@demo.com_102','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(239,'HARDIKA','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'),(240,'SONALI','DEMO','LOKHANDE','2021-01-01','FEMALE','123456789','demo@demo.com_104','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(241,'TEJASHRI','DEMO','TOKIKAR','2021-01-01','FEMALE','123456789','demo@demo.com_105','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(242,'SHREYA','DEMO','MORE','2021-01-01','FEMALE','123456789','demo@demo.com_106','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(243,'NAYONIKA','DEMO','SHAH','2021-01-01','FEMALE','123456789','demo@demo.com_107','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(244,'ANAGHA','DEMO','RAJHANS','2021-01-01','FEMALE','123456789','demo@demo.com_108','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(245,'DEVASHREE','DEMO','TOFKHANE','2021-01-01','FEMALE','123456789','demo@demo.com_109','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(246,'ADITI','DEMO','BHALEKAR','2021-01-01','FEMALE','123456789','demo@demo.com_110','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(247,'SNEHA','DEMO','SONAWANE','2021-01-01','FEMALE','123456789','demo@demo.com_111','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(248,'ANAGHA','DEMO','AVASARMAL','2021-01-01','FEMALE','123456789','demo@demo.com_112','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(249,'SHRINIDHI','DEMO','VAISHNAV','2021-01-01','FEMALE','123456789','demo@demo.com_113','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(250,'KASTURI','DEMO','DESAI','2021-01-01','FEMALE','123456789','demo@demo.com_114','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(251,'MANASI','DEMO','MUKADAM','2021-01-01','FEMALE','123456789','demo@demo.com_115','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(252,'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'),(253,'NAMITA','DEMO','BHAVE','2021-01-01','FEMALE','123456789','demo@demo.com_117','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(254,'KASTURI','DEMO','KULKARNI','2021-01-01','FEMALE','123456789','demo@demo.com_118','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(255,'RIDDHI','DEMO','LOHAR','2021-01-01','FEMALE','123456789','demo@demo.com_119','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(256,'PRATIKSHA','DEMO','GAWANDE','2021-01-01','FEMALE','123456789','demo@demo.com_120','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(257,'KASTURI','DEMO','NENE','2021-01-01','FEMALE','123456789','demo@demo.com_121','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(258,'SRUSHTI','DEMO','NANDURKAR','2021-01-01','FEMALE','123456789','demo@demo.com_122','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(259,'PRATIKSHA','DEMO','GAIKWAD','2021-01-01','FEMALE','123456789','demo@demo.com_123','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(260,'GAURI','DEMO','DEV','2021-01-01','FEMALE','123456789','demo@demo.com_124','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(261,'GAYATRI','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'),(262,'BHAIRAVI','DEMO','BHISE','2021-01-01','FEMALE','123456789','demo@demo.com_126','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(263,'SHRADDHA','DEMO','GAWADE','2021-01-01','FEMALE','123456789','demo@demo.com_127','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(264,'SHRAVANI','DEMO','VAISHNAV','2021-01-01','FEMALE','123456789','demo@demo.com_128','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(265,'APURVA','DEMO','VAZE','2021-01-01','FEMALE','123456789','demo@demo.com_129','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(266,'MADHURI','DEMO','AATHAVALE','2021-01-01','FEMALE','123456789','demo@demo.com_130','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(267,'PRATAP','DEMO','MORE','2021-01-01','MALE','123456789','demo@demo.com_131','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(268,'ARUN','DEMO','KARVE','2021-01-01','MALE','123456789','demo@demo.com_132','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(269,'ANUJA','DEMO','PETHE','2021-01-01','FEMALE','123456789','demo@demo.com_133','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(270,'YASHASHREE','DEMO','KARANDIKAR','2021-01-01','FEMALE','123456789','demo@demo.com_134','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(271,'MILIND','DEMO','BACHCHAV','2021-01-01','MALE','123456789','demo@demo.com_135','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(272,'HRUSHIKESH','DEMO','JADHAV','2021-01-01','MALE','123456789','demo@demo.com_136','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(273,'SHIV','DEMO','MANDLIK','2021-01-01','MALE','123456789','demo@demo.com_137','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(274,'OVI','DEMO','PANCHAL','2021-01-01','FEMALE','123456789','demo@demo.com_138','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(275,'RAGHUNATH','DEMO','KOR','2021-01-01','MALE','123456789','demo@demo.com_139','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(276,'VIHANG','DEMO','BHAVE','2021-01-01','MALE','123456789','demo@demo.com_140','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(277,'AARAV','DEMO','BARHATE','2021-01-01','MALE','123456789','demo@demo.com_141','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(278,'TANMAY','DEMO','DAREKAR','2021-01-01','MALE','123456789','demo@demo.com_142','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(279,'VIJAY','DEMO','KOLHE','2021-01-01','MALE','123456789','demo@demo.com_143','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(280,'HRUSHIKESH','DEMO','THAKARE','2021-01-01','MALE','123456789','demo@demo.com_144','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(281,'HIREN','DEMO','GODE','2021-01-01','MALE','123456789','demo@demo.com_145','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(282,'VARAD','DEMO','BRAHMA','2021-01-01','MALE','123456789','demo@demo.com_146','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(283,'ATHARV','DEMO','NIKUMBH','2021-01-01','MALE','123456789','demo@demo.com_147','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(284,'SAURABH','DEMO','WALANJ','2021-01-01','MALE','123456789','demo@demo.com_148','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(285,'RUDRA','DEMO','BADAVE','2021-01-01','MALE','123456789','demo@demo.com_149','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(286,'SHAUNAK','DEMO','LAWATE','2021-01-01','MALE','123456789','demo@demo.com_150','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(287,'MALHAR','DEMO','KULKARNI','2021-01-01','MALE','123456789','demo@demo.com_151','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(288,'RUTVI','DEMO','SATVIK','2021-01-01','MALE','123456789','demo@demo.com_152','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(289,'SARVANG','DEMO','BHARAMBE','2021-01-01','MALE','123456789','demo@demo.com_153','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(290,'ADITI','DEMO','BARVE','2021-01-01','FEMALE','123456789','demo@demo.com_154','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(291,'KASTURI','DEMO','MHATRE','2021-01-01','FEMALE','123456789','demo@demo.com_155','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(292,'SAKSHI','DEMO','WALIMBE','2021-01-01','FEMALE','123456789','demo@demo.com_156','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(293,'AARYA','DEMO','DESHPANDE','2021-01-01','FEMALE','123456789','demo@demo.com_157','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(294,'PARINITA','DEMO','PAWAR','2021-01-01','FEMALE','123456789','demo@demo.com_158','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(295,'JUI','DEMO','SANE','2021-01-01','FEMALE','123456789','demo@demo.com_159','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(296,'NETRA','DEMO','SATHE','2021-01-01','FEMALE','123456789','demo@demo.com_160','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(297,'PRIYANKA','DEMO','CHIKSHETTI','2021-01-01','FEMALE','123456789','demo@demo.com_161','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(298,'AVANTIKA','DEMO','MARATHE','2021-01-01','FEMALE','123456789','demo@demo.com_162','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(299,'HARSHITA','DEMO','AAMBEKAR','2021-01-01','FEMALE','123456789','demo@demo.com_163','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(300,'VIDISHA','DEMO','CHAUDHARI','2021-01-01','FEMALE','123456789','demo@demo.com_164','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(301,'SHRAVANI','DEMO','KULKARNI','2021-01-01','FEMALE','123456789','demo@demo.com_165','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(302,'SIYA','DEMO','DALAL','2021-01-01','FEMALE','123456789','demo@demo.com_166','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(303,'NUPUR','DEMO','BHIDE','2021-01-01','FEMALE','123456789','demo@demo.com_167','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(304,'HETAL','DEMO','ZALAR','2021-01-01','FEMALE','123456789','demo@demo.com_168','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(305,'PRITI','DEMO','YASHWANTE','2021-01-01','FEMALE','123456789','demo@demo.com_169','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(306,'TANVI','DEMO','DESHPANDE','2021-01-01','FEMALE','123456789','demo@demo.com_170','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(307,'MRUDULA','DEMO','BACHCHHAV','2021-01-01','FEMALE','123456789','demo@demo.com_171','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(308,'VISHRAM','DEMO','KOLHE','2021-01-01','MALE','123456789','demo@demo.com_172','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(309,'RITI','DEMO','ZALAR','2021-01-01','FEMALE','123456789','demo@demo.com_173','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(310,'CHARUL','DEMO','DAFADE','2021-01-01','FEMALE','123456789','demo@demo.com_174','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(311,'PRATHA','DEMO','CHAUDHARI','2021-01-01','FEMALE','123456789','demo@demo.com_175','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(312,'MEGH','DEMO','DANDEKAR','2021-01-01','MALE','123456789','demo@demo.com_176','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(313,'ISHAN','DEMO','BHAT','2021-01-01','MALE','123456789','demo@demo.com_177','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(314,'MEGHNAD','DEMO','KAMBALE','2021-01-01','MALE','123456789','demo@demo.com_178','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(315,'CHAITANYA','DEMO','VAZE','2021-01-01','MALE','123456789','demo@demo.com_179','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(316,'ATHARV','DEMO','DAMALE','2021-01-01','MALE','123456789','demo@demo.com_180','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(317,'MALHAR','DEMO','KULKARNI','2021-01-01','MALE','123456789','demo@demo.com_181','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(318,'RUGVED','DEMO','RODE','2021-01-01','MALE','123456789','demo@demo.com_182','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(319,'TEJAS','DEMO','KALKAR','2021-01-01','MALE','123456789','demo@demo.com_183','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(320,'MAITREY','DEMO','BHARAMBE','2021-01-01','MALE','123456789','demo@demo.com_184','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(321,'GANDHARV','DEMO','CHUMBALE','2021-01-01','MALE','123456789','demo@demo.com_185','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(322,'AARYVEER','DEMO','SALGAVKAR','2021-01-01','MALE','123456789','demo@demo.com_186','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(323,'ATHARV','DEMO','BUDHKAR','2021-01-01','MALE','123456789','demo@demo.com_187','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(324,'SAKAR','DEMO','DESAI','2021-01-01','MALE','123456789','demo@demo.com_188','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(325,'HANSIN','DEMO','SAKALYE','2021-01-01','MALE','123456789','demo@demo.com_189','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(326,'SHYAM','DEMO','DESHMUKH','2021-01-01','MALE','123456789','demo@demo.com_190','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(327,'VARAD','DEMO','PATHAK','2021-01-01','MALE','123456789','demo@demo.com_191','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(328,'HERAMB','DEMO','RAJE','2021-01-01','MALE','123456789','demo@demo.com_192','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(329,'SMITESH','DEMO','MAHAJAN','2021-01-01','MALE','123456789','demo@demo.com_193','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(330,'AADITYA','DEMO','PAITHANKAR','2021-01-01','MALE','123456789','demo@demo.com_194','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(331,'ATHANG','DEMO','PHANASE','2021-01-01','MALE','123456789','demo@demo.com_195','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(332,'DEVESH','DEMO','PARAB','2021-01-01','MALE','123456789','demo@demo.com_196','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(333,'SUMEDH','DEMO','BHATAVADEKAR','2021-01-01','MALE','123456789','demo@demo.com_197','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(334,'AARUSH','DEMO','BAGAL','2021-01-01','MALE','123456789','demo@demo.com_198','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(335,'CHAITANYA','DEMO','JOSHI','2021-01-01','MALE','123456789','demo@demo.com_199','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(336,'NAHUSH','DEMO','AGRAWAL','2021-01-01','MALE','123456789','demo@demo.com_200','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(337,'RUDRA','DEMO','PARDESHI','2021-01-01','MALE','123456789','demo@demo.com_201','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(338,'SAUMITRA','DEMO','BIVALKAR','2021-01-01','MALE','123456789','demo@demo.com_202','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(339,'UMESH','DEMO','NIMBHORKAR','2021-01-01','MALE','123456789','demo@demo.com_203','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','0',NULL,'1','1'),(340,'krishna','DEMO','KARADA','2021-01-01','1','123456789','krishna@gmail.com','ABC','XYZ','DEMO 1','DEMO 2','421301','14','0','76','0',NULL,'1','1'),(341,'ABHI','DEMO','SANGALE','2021-01-01','MALE','123456789','demo@demo.com_300','ABC','XYZ','DEMO 1','DEMO 2','421301','14','Kalyan','76','1',NULL,'1','1');

--
-- Table structure for table `kgserp_retailer`
--

CREATE TABLE `kgserp_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 `kgserp_retailer`
--


--
-- Table structure for table `kgserp_role`
--

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

--
-- Dumping data for table `kgserp_role`
--

INSERT INTO `kgserp_role` VALUES (2,'teacher'),(3,'staff'),(5,'admin'),(12,'student'),(22,'principal'),(25,'manager'),(29,'class teacher');

--
-- Table structure for table `kgserp_role_permission`
--

CREATE TABLE `kgserp_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=206 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kgserp_role_permission`
--

INSERT INTO `kgserp_role_permission` VALUES (157,'2','87','1'),(158,'2','88','1'),(159,'2','89','1'),(160,'2','90','1'),(161,'2','91','0'),(162,'2','92','1'),(163,'2','93','0'),(164,'3','87','0'),(165,'3','88','0'),(166,'3','89','0'),(167,'3','90','0'),(168,'3','91','0'),(169,'3','92','0'),(170,'3','93','0'),(171,'5','87','1'),(172,'5','88','1'),(173,'5','89','1'),(174,'5','90','1'),(175,'5','91','1'),(176,'5','92','1'),(177,'5','93','1'),(178,'12','87','1'),(179,'12','88','1'),(180,'12','89','1'),(181,'12','90','1'),(182,'12','91','0'),(183,'12','92','0'),(184,'12','93','0'),(185,'22','87','1'),(186,'22','88','0'),(187,'22','89','0'),(188,'22','90','0'),(189,'22','91','0'),(190,'22','92','0'),(191,'22','93','1'),(192,'25','87','0'),(193,'25','88','0'),(194,'25','89','0'),(195,'25','90','0'),(196,'25','91','0'),(197,'25','92','0'),(198,'25','93','0'),(199,'29','87','1'),(200,'29','88','0'),(201,'29','89','0'),(202,'29','90','0'),(203,'29','91','0'),(204,'29','92','0'),(205,'29','93','0');

--
-- Table structure for table `kgserp_rolelist`
--

CREATE TABLE `kgserp_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=371 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kgserp_rolelist`
--

INSERT INTO `kgserp_rolelist` VALUES (1,'1','5'),(178,'2','5'),(332,'176','29'),(333,'177','29'),(334,'178','2'),(335,'179','29'),(336,'180','29'),(337,'181','29'),(339,'183','29'),(341,'185','29'),(342,'186','29'),(343,'187','2'),(344,'188','29'),(345,'189','3'),(347,'192','12'),(348,'191','22'),(363,'174','29'),(364,'175','29'),(365,'184','29'),(366,'184','2'),(368,'190','3'),(369,'182','29'),(370,'193','22');

--
-- Table structure for table `kgserp_salary`
--

CREATE TABLE `kgserp_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=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgserp_salary`
--

INSERT INTO `kgserp_salary` VALUES (22,'183','1','30000','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'123','123','Santosh',NULL),(23,'179','0',NULL,NULL,'300','3000','300','300','1','300','123','123','123','Sangeeta',NULL);

--
-- Table structure for table `kgserp_salary_history`
--

CREATE TABLE `kgserp_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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_salary_history`
--


--
-- Table structure for table `kgserp_salary_month_wise`
--

CREATE TABLE `kgserp_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,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=68 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgserp_salary_month_wise`
--

INSERT INTO `kgserp_salary_month_wise` VALUES (66,'183',1,'30000',5,NULL,NULL,NULL,NULL,NULL,'01','2021','31','31',28500,'0','0','0'),(67,'179',0,NULL,NULL,'290.32258064516','2903.2258064516','290.32258064516','290.32258064516',300,'01','2021','30','31',3474,'0','0','0');

--
-- Table structure for table `kgserp_section_list`
--

CREATE TABLE `kgserp_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=501 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_section_list`
--

INSERT INTO `kgserp_section_list` VALUES (453,'18','75','0'),(456,'19','78','0'),(458,'20','80','0'),(461,'20','83','0'),(469,'18','86','0'),(485,'21','82',NULL),(486,'21','81',NULL),(487,'21','79',NULL),(489,'21','77',NULL),(496,'21','76',NULL),(497,'22','76',NULL),(498,'23','76',NULL),(499,'21','87',NULL),(500,'24','88','0');

--
-- Table structure for table `kgserp_session`
--

CREATE TABLE `kgserp_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=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_session`
--

INSERT INTO `kgserp_session` VALUES (24,'Session21','2021','2022','0',1,'01','01');

--
-- Table structure for table `kgserp_sms_class`
--

CREATE TABLE `kgserp_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=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_sms_class`
--

INSERT INTO `kgserp_sms_class` VALUES (20,'75',3,3600,1613097000,1800,2,0),(21,'76',2,1800,1614915000,1800,0,0);

--
-- Table structure for table `kgserp_sms_period`
--

CREATE TABLE `kgserp_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=137 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_sms_period`
--

INSERT INTO `kgserp_sms_period` VALUES (131,'1','1613097000','1613100600','75','20','0'),(132,'2','1613100600','1613104200','75','20','0'),(133,'999','1613104200','1613106000','75','20','0'),(134,'3','1613106000','1613109600','75','20','0'),(135,'1','1614915000','1614916800','76','21','0'),(136,'2','1614916800','1614918600','76','21','0');

--
-- Table structure for table `kgserp_student_order`
--

CREATE TABLE `kgserp_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 `kgserp_student_order`
--

INSERT INTO `kgserp_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 `kgserp_student_subject`
--

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

--
-- Dumping data for table `kgserp_student_subject`
--

INSERT INTO `kgserp_student_subject` VALUES (471,'138','39'),(472,'139','39'),(473,'141','44'),(474,'140','39');

--
-- Table structure for table `kgserp_student_verification`
--

CREATE TABLE `kgserp_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_student_verification`
--


--
-- Table structure for table `kgserp_student_work_description`
--

CREATE TABLE `kgserp_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_student_work_description`
--


--
-- Table structure for table `kgserp_subject_list`
--

CREATE TABLE `kgserp_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=351 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_subject_list`
--

INSERT INTO `kgserp_subject_list` VALUES (334,'174','40','0'),(335,'175','40','0'),(337,'177','40','0'),(338,'178','40','0'),(339,'179','44','0'),(340,'180','44','0'),(341,'181','43','0'),(342,'182','39','0'),(343,'183','39','0'),(344,'184','39','0'),(345,'185','42','0'),(346,'186','41','0'),(347,'187','46','0'),(348,'188','46','0'),(349,'176','40','0'),(350,'176','45','0');

--
-- Table structure for table `kgserp_supplier`
--

CREATE TABLE `kgserp_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 `kgserp_supplier`
--


--
-- Table structure for table `kgserp_teacher_class_section_list`
--

CREATE TABLE `kgserp_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 `kgserp_teacher_class_section_list`
--

INSERT INTO `kgserp_teacher_class_section_list` VALUES (21,'179','82','21'),(22,'182','76','22'),(23,'188','0','0'),(24,'180','82','23'),(25,'181','81','21'),(26,'185','79','21'),(27,'186','84','21'),(28,'183','76','21'),(29,'184','76','23'),(30,'176','77','21'),(31,'177','77','23'),(32,'174','77','24'),(33,'175','77','25');

--
-- Table structure for table `kgserp_teacher_list`
--

CREATE TABLE `kgserp_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=830 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgserp_teacher_list`
--

INSERT INTO `kgserp_teacher_list` VALUES (752,'174','75','0'),(753,'179','75','0'),(754,'183','75','0'),(762,'176','78','0'),(764,'186','80','0'),(768,'187','83','0'),(769,'188','83','0'),(787,'175','86','0'),(806,'180','82',NULL),(807,'179','82',NULL),(808,'181','81',NULL),(809,'185','79',NULL),(814,'176','77',NULL),(815,'177','77',NULL),(816,'174','77',NULL),(817,'175','77',NULL),(825,'184','76',NULL),(826,'183','76',NULL),(827,'182','76',NULL),(828,'182','87',NULL),(829,'183','88','0');

--
-- Table structure for table `kgserp_teacher_mentor`
--

CREATE TABLE `kgserp_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_teacher_mentor`
--


--
-- Table structure for table `kgserp_teacher_registration`
--

CREATE TABLE `kgserp_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 `kgserp_teacher_registration`
--


--
-- Table structure for table `kgserp_temporary_timetable`
--

CREATE TABLE `kgserp_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgserp_temporary_timetable`
--


--
-- Table structure for table `kgserp_temporary_timetable_history`
--

CREATE TABLE `kgserp_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgserp_temporary_timetable_history`
--


--
-- Table structure for table `kgserp_timetable`
--

CREATE TABLE `kgserp_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=155 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_timetable`
--

INSERT INTO `kgserp_timetable` VALUES (143,131,1,174,75,18,40,1613097000,1613100600,0,0,0),(145,132,1,179,75,18,44,1613100600,1613104200,0,0,0),(146,134,1,183,75,18,39,1613106000,1613109600,0,0,0),(147,131,3,174,75,18,40,1613097000,1613100600,0,0,0),(149,132,3,179,75,18,44,1613100600,1613104200,0,0,0),(150,134,3,183,75,18,39,1613106000,1613109600,0,0,0),(151,131,5,183,75,18,39,1613097000,1613100600,0,0,0),(152,132,5,174,75,18,40,1613100600,1613104200,0,0,0),(153,134,5,179,75,18,44,1613106000,1613109600,0,0,0),(154,136,1,183,76,21,39,1614916800,1614918600,0,0,0);

--
-- Table structure for table `kgserp_upload_document`
--

CREATE TABLE `kgserp_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,
  `background_image_name` varchar(50) DEFAULT NULL,
  `background_image_path` varchar(100) DEFAULT NULL,
  `institute_name` varchar(100) DEFAULT NULL,
  `columnbackground_image_path` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_upload_document`
--

INSERT INTO `kgserp_upload_document` VALUES (1,'#a74538','1613126335_c8f30731a42861542719.jpg','logo_and_favicon/1613126335_c8f30731a42861542719.jpg','1613126380_8f660e84f951dec6be06.jpg','logo_and_favicon/1613126380_8f660e84f951dec6be06.jpg','1613126693_a012982cf75d8c85991b.jpg','logo_and_favicon/1613126693_a012982cf75d8c85991b.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `kgserp_uploadimage`
--

CREATE TABLE `kgserp_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=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_uploadimage`
--

INSERT INTO `kgserp_uploadimage` VALUES (58,'1613131907_2cc99b379084f2337afb.jpg','student/1613131907_2cc99b379084f2337afb.jpg','Hydrangeas.jpg','document','138','jpg','document',0,'student'),(59,'1613132373_7c14348bcfe0799097db.jpg','student/1613132373_7c14348bcfe0799097db.jpg',NULL,NULL,'138',NULL,'photo',NULL,NULL),(60,'1613830078_91b97b43cd633370340f.jpg','student/1613830078_91b97b43cd633370340f.jpg',NULL,NULL,'141',NULL,'photo',NULL,NULL);

--
-- Table structure for table `kgserp_user_attendance`
--

CREATE TABLE `kgserp_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=306 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgserp_user_attendance`
--

INSERT INTO `kgserp_user_attendance` VALUES (293,'189','1613068200','1',3),(294,'190','1613068200','2',3),(295,'192','1613068200','1',12),(296,'174','1613068200','1',2),(297,'175','1613068200','3',2),(298,'176','1613068200','2',2),(299,'177','1613068200','2',2),(300,'178','1613068200','2',2),(301,'180','1613068200','2',2),(302,'181','1613068200','3',2),(303,'183','1613068200','1',2),(304,'192','4768741800','1',29),(305,'192','4768828200','9',29);

--
-- Table structure for table `kgserp_user_permission`
--

CREATE TABLE `kgserp_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=1455 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgserp_user_permission`
--

INSERT INTO `kgserp_user_permission` VALUES (1413,'1','87','1'),(1414,'1','88','1'),(1415,'1','89','1'),(1416,'1','90','1'),(1417,'1','91','1'),(1418,'1','92','1'),(1419,'1','93','1'),(1420,'191','87','1'),(1421,'191','88','0'),(1422,'191','89','0'),(1423,'191','90','0'),(1424,'191','91','0'),(1425,'191','92','0'),(1426,'191','93','1'),(1427,'192','87','1'),(1428,'192','88','1'),(1429,'192','89','1'),(1430,'192','90','1'),(1431,'192','91','0'),(1432,'192','92','0'),(1433,'192','93','0'),(1434,'174','87','1'),(1435,'174','88','1'),(1436,'174','89','1'),(1437,'174','90','1'),(1438,'174','91','1'),(1439,'174','92','1'),(1440,'174','93','1'),(1441,'175','87','1'),(1442,'175','88','1'),(1443,'175','89','1'),(1444,'175','90','1'),(1445,'175','91','0'),(1446,'175','92','1'),(1447,'175','93','0'),(1448,'183','87','1'),(1449,'183','88','1'),(1450,'183','89','1'),(1451,'183','90','1'),(1452,'183','91','0'),(1453,'183','92','1'),(1454,'183','93','0');

--
-- Table structure for table `kgserp_vch_type`
--

CREATE TABLE `kgserp_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=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_vch_type`
--

INSERT INTO `kgserp_vch_type` VALUES (1,'Cash',0),(2,'cheque',0),(3,'bank',0);

--
-- Table structure for table `kgserp_work_description`
--

CREATE TABLE `kgserp_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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgserp_work_description`
--

INSERT INTO `kgserp_work_description` VALUES (4,' learn basic theroy','183','1613327400','0',75,NULL),(5,'5 min Teental Solo','183','1613845800','0',75,NULL);

--
-- Table structure for table `kgssms_Event`
--

CREATE TABLE `kgssms_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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgssms_Event`
--

INSERT INTO `kgssms_Event` VALUES (16,'New Year','1609353000','1609439400','1000','0');

--
-- Table structure for table `kgssms_add_class`
--

CREATE TABLE `kgssms_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 AUTO_INCREMENT=28 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgssms_add_class`
--

INSERT INTO `kgssms_add_class` VALUES (26,'12','0'),(27,'10','0');

--
-- Table structure for table `kgssms_add_section`
--

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

--
-- Dumping data for table `kgssms_add_section`
--

INSERT INTO `kgssms_add_section` VALUES (17,'A');

--
-- Table structure for table `kgssms_address2`
--

CREATE TABLE `kgssms_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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgssms_address2`
--


--
-- Table structure for table `kgssms_attendance_type`
--

CREATE TABLE `kgssms_attendance_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `delete_status` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgssms_attendance_type`
--

INSERT INTO `kgssms_attendance_type` VALUES (1,'present','1','0'),(2,'absent','1','0'),(3,'leave','1','0'),(4,'summer vacation','1','0'),(5,'winter vacation','1','0'),(6,'boot camp','1','0'),(7,'bio-metric','1','1'),(8,'shd','1','1'),(9,'bio-metric','1','0');

--
-- Table structure for table `kgssms_class_fee`
--

CREATE TABLE `kgssms_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,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgssms_class_fee`
--

INSERT INTO `kgssms_class_fee` VALUES (6,'26','1','1','1','1','4',1607625000),(7,'27','1','1','1','1','4',1608229800);

--
-- Table structure for table `kgssms_class_subject`
--

CREATE TABLE `kgssms_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=330 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgssms_class_subject`
--

INSERT INTO `kgssms_class_subject` VALUES (273,'26','1'),(274,'26','2'),(275,'26','3'),(329,'27','2');

--
-- Table structure for table `kgssms_class_teacher_list`
--

CREATE TABLE `kgssms_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 `kgssms_class_teacher_list`
--


--
-- Table structure for table `kgssms_custom_event`
--

CREATE TABLE `kgssms_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,
  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 `kgssms_custom_event`
--

INSERT INTO `kgssms_custom_event` VALUES (48,'HW- Ch 3, Q. 2a','1607884100','1607884100',NULL,'0',105);

--
-- Table structure for table `kgssms_custom_timetable`
--

CREATE TABLE `kgssms_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,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgssms_custom_timetable`
--


--
-- Table structure for table `kgssms_emi`
--

CREATE TABLE `kgssms_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 `kgssms_emi`
--


--
-- Table structure for table `kgssms_employee_order`
--

CREATE TABLE `kgssms_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 `kgssms_employee_order`
--

INSERT INTO `kgssms_employee_order` VALUES (1,'User Name','1',2,'front','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,'front','email','Email Id');

--
-- Table structure for table `kgssms_exam`
--

CREATE TABLE `kgssms_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=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgssms_exam`
--

INSERT INTO `kgssms_exam` VALUES (5,'Montly Test','0');

--
-- Table structure for table `kgssms_fees`
--

CREATE TABLE `kgssms_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` int(11) DEFAULT NULL,
  `from_date` int(11) DEFAULT NULL,
  `to_date` int(11) DEFAULT NULL,
  `paid` int(11) 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 `kgssms_fees`
--


--
-- Table structure for table `kgssms_holiday`
--

CREATE TABLE `kgssms_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=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgssms_holiday`
--

INSERT INTO `kgssms_holiday` VALUES (9,'Republic','1611599400','1611685800','3','0');

--
-- Table structure for table `kgssms_island`
--

CREATE TABLE `kgssms_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 `kgssms_island`
--


--
-- Table structure for table `kgssms_item`
--

CREATE TABLE `kgssms_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 `kgssms_item`
--


--
-- Table structure for table `kgssms_jobassignment`
--

CREATE TABLE `kgssms_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgssms_jobassignment`
--


--
-- Table structure for table `kgssms_leave_list`
--

CREATE TABLE `kgssms_leave_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `leave_type` int(11) DEFAULT NULL,
  `addStartDate` int(11) DEFAULT NULL,
  `addEndDate` int(11) DEFAULT NULL,
  `leave_teacher_id` int(11) DEFAULT NULL,
  `adjust_teacher` int(11) DEFAULT NULL,
  `teacher_list` varchar(50) DEFAULT NULL,
  `delete_status` 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 `kgssms_leave_list`
--


--
-- Table structure for table `kgssms_period`
--

CREATE TABLE `kgssms_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 `kgssms_period`
--


--
-- Table structure for table `kgssms_permission`
--

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

--
-- Dumping data for table `kgssms_permission`
--

INSERT INTO `kgssms_permission` VALUES (37,'student'),(38,'demo');

--
-- Table structure for table `kgssms_plantype`
--

CREATE TABLE `kgssms_plantype` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) DEFAULT NULL,
  `created` int(11) DEFAULT NULL,
  `modified` int(11) DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kgssms_plantype`
--


--
-- Table structure for table `kgssms_preveducation`
--

CREATE TABLE `kgssms_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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgssms_preveducation`
--


--
-- Table structure for table `kgssms_registration`
--

CREATE TABLE `kgssms_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,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `first_name` (`first_name`,`email`)
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgssms_registration`
--

INSERT INTO `kgssms_registration` VALUES (74,'test','test','test','2020-12-31','1','1234567789','geeta@gmail.com','asasa','asasasasasas','asa','asa','131231','0','0','0','0',NULL);

--
-- Table structure for table `kgssms_retailer`
--

CREATE TABLE `kgssms_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 `kgssms_retailer`
--


--
-- Table structure for table `kgssms_role`
--

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

--
-- Dumping data for table `kgssms_role`
--

INSERT INTO `kgssms_role` VALUES (2,'teacher'),(3,'staff'),(5,'admin'),(12,'student'),(20,'shamshad'),(22,'principal'),(24,'guest teacher'),(25,'manager'),(29,'class teacher'),(46,'teacher');

--
-- Table structure for table `kgssms_role_permission`
--

CREATE TABLE `kgssms_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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kgssms_role_permission`
--


--
-- Table structure for table `kgssms_rolelist`
--

CREATE TABLE `kgssms_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=179 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kgssms_rolelist`
--

INSERT INTO `kgssms_rolelist` VALUES (1,'1','5'),(178,'2','5');

--
-- Table structure for table `kgssms_salary`
--

CREATE TABLE `kgssms_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,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgssms_salary`
--

INSERT INTO `kgssms_salary` VALUES (5,'103','1','10000','5',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'105','0',NULL,NULL,'1','1','1','1','1','1','1');

--
-- Table structure for table `kgssms_section_list`
--

CREATE TABLE `kgssms_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=205 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgssms_section_list`
--

INSERT INTO `kgssms_section_list` VALUES (203,'17','26',NULL),(204,'17','27','0');

--
-- Table structure for table `kgssms_session`
--

CREATE TABLE `kgssms_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=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgssms_session`
--

INSERT INTO `kgssms_session` VALUES (14,'2020-2021','2020','2020','0',1,'01','01');

--
-- Table structure for table `kgssms_sms_class`
--

CREATE TABLE `kgssms_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=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgssms_sms_class`
--

INSERT INTO `kgssms_sms_class` VALUES (18,'26',6,1800,1609381800,1800,3,0),(19,'27',6,1800,1609385400,1800,3,0);

--
-- Table structure for table `kgssms_sms_period`
--

CREATE TABLE `kgssms_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=258 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgssms_sms_period`
--

INSERT INTO `kgssms_sms_period` VALUES (244,'1','1609381800','1609383600','26','18','0'),(245,'2','1609383600','1609385400','26','18','0'),(246,'3','1609385400','1609387200','26','18','0'),(247,'999','1609387200','1609389000','26','18','0'),(248,'4','1609389000','1609390800','26','18','0'),(249,'5','1609390800','1609392600','26','18','0'),(250,'6','1609392600','1609394400','26','18','0'),(251,'1','1609385400','1609387200','27','19','0'),(252,'2','1609387200','1609389000','27','19','0'),(253,'3','1609389000','1609390800','27','19','0'),(254,'999','1609390800','1609392600','27','19','0'),(255,'4','1609392600','1609394400','27','19','0'),(256,'5','1609394400','1609396200','27','19','0'),(257,'6','1609396200','1609398000','27','19','0');

--
-- Table structure for table `kgssms_student_order`
--

CREATE TABLE `kgssms_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 `kgssms_student_order`
--

INSERT INTO `kgssms_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 `kgssms_student_subject`
--

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

--
-- Dumping data for table `kgssms_student_subject`
--

INSERT INTO `kgssms_student_subject` VALUES (176,'74','1'),(177,'74','2'),(178,'74','3');

--
-- Table structure for table `kgssms_student_work_description`
--

CREATE TABLE `kgssms_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgssms_student_work_description`
--


--
-- Table structure for table `kgssms_subject_list`
--

CREATE TABLE `kgssms_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=286 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgssms_subject_list`
--

INSERT INTO `kgssms_subject_list` VALUES (282,'103','1','0'),(283,'105','3','0'),(284,'107','1','0'),(285,'107','2','0');

--
-- Table structure for table `kgssms_supplier`
--

CREATE TABLE `kgssms_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 `kgssms_supplier`
--


--
-- Table structure for table `kgssms_teacher_class_section_list`
--

CREATE TABLE `kgssms_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=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgssms_teacher_class_section_list`
--

INSERT INTO `kgssms_teacher_class_section_list` VALUES (12,'107','26','17');

--
-- Table structure for table `kgssms_teacher_list`
--

CREATE TABLE `kgssms_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=394 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgssms_teacher_list`
--

INSERT INTO `kgssms_teacher_list` VALUES (391,'103','26',NULL),(392,'105','26',NULL),(393,'105','27','0');

--
-- Table structure for table `kgssms_teacher_registration`
--

CREATE TABLE `kgssms_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 `kgssms_teacher_registration`
--


--
-- Table structure for table `kgssms_temporary_timetable`
--

CREATE TABLE `kgssms_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` int(11) DEFAULT NULL,
  `delete_status` 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 `kgssms_temporary_timetable`
--


--
-- Table structure for table `kgssms_temporary_timetable_history`
--

CREATE TABLE `kgssms_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgssms_temporary_timetable_history`
--


--
-- Table structure for table `kgssms_timetable`
--

CREATE TABLE `kgssms_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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=318 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgssms_timetable`
--

INSERT INTO `kgssms_timetable` VALUES (316,244,1,103,26,17,1,1609381800,1609383600,0,NULL),(317,247,1,105,26,17,3,1609387200,1609389000,0,NULL);

--
-- Table structure for table `kgssms_upload_document`
--

CREATE TABLE `kgssms_upload_document` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `color_name` varchar(50) DEFAULT NULL,
  `logo_name` varchar(5000) DEFAULT NULL,
  `logo_path` varchar(5000) DEFAULT NULL,
  `favicon_name` varchar(100) DEFAULT NULL,
  `favicon_path` varchar(100) DEFAULT NULL,
  `working_hour` int(11) DEFAULT NULL,
  `file_size` int(11) DEFAULT NULL,
  `No_of_files` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgssms_upload_document`
--

INSERT INTO `kgssms_upload_document` VALUES (1,'#042340','1609422947_7536492c1242de5a17d7.jpg','logo_and_favicon/1609422947_7536492c1242de5a17d7.jpg','1609423039_80c69d1f6ebb74f51097.png','logo_and_favicon/1609423039_80c69d1f6ebb74f51097.png',NULL,NULL,NULL);

--
-- Table structure for table `kgssms_uploadimage`
--

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

--
-- Dumping data for table `kgssms_uploadimage`
--


--
-- Table structure for table `kgssms_user_attendance`
--

CREATE TABLE `kgssms_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=1233 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgssms_user_attendance`
--

INSERT INTO `kgssms_user_attendance` VALUES (1231,'103','1609353000','10',46),(1232,'105','1609353000','11',46);

--
-- Table structure for table `kgssms_user_permission`
--

CREATE TABLE `kgssms_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 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `kgssms_user_permission`
--


--
-- Table structure for table `kgssms_work_description`
--

CREATE TABLE `kgssms_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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `kgssms_work_description`
--


--
-- Table structure for table `leavetype_list`
--

CREATE TABLE `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=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `leavetype_list`
--

INSERT INTO `leavetype_list` VALUES (19,'SL',5,0),(20,'EL',2,0),(21,'CL',7,0),(22,'we',3,1);

--
-- Table structure for table `loan`
--

CREATE TABLE `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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `loan`
--


--
-- Table structure for table `mass_mail_sms`
--

CREATE TABLE `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 `mass_mail_sms`
--


--
-- Table structure for table `over_time`
--

CREATE TABLE `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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `over_time`
--


--
-- Table structure for table `period`
--

CREATE TABLE `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 `period`
--


--
-- Table structure for table `permission`
--

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

--
-- Dumping data for table `permission`
--

INSERT INTO `permission` VALUES (82,'user'),(83,'salary'),(84,'timetable');

--
-- Table structure for table `preveducation`
--

CREATE TABLE `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=96 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `preveducation`
--

INSERT INTO `preveducation` VALUES (92,'abc','12','78',111,'admin'),(93,'rshhhtt','2','28',112,'admin'),(94,'rrr','5','45',112,'admin'),(95,'99','1','99',112,'admin');

--
-- Table structure for table `registration`
--

CREATE TABLE `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=113 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `registration`
--

INSERT INTO `registration` VALUES (111,'shivani','as','as','1994-02-09','2','23445','shivani@gmai.com','dfgf','fh','hgh','gh','gh','0','0','0','0',NULL,'1','1'),(112,'rashmi','rawat','rawat','2021-02-13','2','7289015494','rashmi@yatharthriti.com','ganesh','gggg','489/12','ddd','121005','0','0','76','0',NULL,'1','1');

--
-- Table structure for table `reminderconfig`
--

CREATE TABLE `reminderconfig` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fee_reminder` int(11) DEFAULT NULL,
  `after_due_date` varchar(50) DEFAULT NULL,
  `suspend` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `reminderconfig`
--

INSERT INTO `reminderconfig` VALUES (1,9,'1',2);

--
-- Table structure for table `retailer`
--

CREATE TABLE `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 `retailer`
--


--
-- Table structure for table `role`
--

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

--
-- Dumping data for table `role`
--

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

--
-- Table structure for table `role_permission`
--

CREATE TABLE `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=125 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `role_permission`
--

INSERT INTO `role_permission` VALUES (107,'5','82','0'),(108,'5','83','0'),(109,'12','82','0'),(110,'12','83','0'),(111,'20','82','0'),(112,'20','83','0'),(113,'22','82','1'),(114,'22','83','1'),(115,'24','82','0'),(116,'24','83','0'),(117,'25','82','0'),(118,'25','83','0'),(119,'29','82','0'),(120,'29','83','0'),(121,'58','82','0'),(122,'58','83','0'),(123,'59','82','0'),(124,'59','83','0');

--
-- Table structure for table `rolelist`
--

CREATE TABLE `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=304 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rolelist`
--

INSERT INTO `rolelist` VALUES (253,'119','5'),(297,'141','29'),(298,'143','29'),(299,'142','22'),(300,'144','59'),(301,'145','58'),(302,'146','12'),(303,'147','12');

--
-- Table structure for table `rrrr_Event`
--

CREATE TABLE `rrrr_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 `rrrr_Event`
--


--
-- Table structure for table `rrrr_accounting`
--

CREATE TABLE `rrrr_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 `rrrr_accounting`
--


--
-- Table structure for table `rrrr_add_class`
--

CREATE TABLE `rrrr_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 `rrrr_add_class`
--


--
-- Table structure for table `rrrr_add_field`
--

CREATE TABLE `rrrr_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 `rrrr_add_field`
--


--
-- Table structure for table `rrrr_add_section`
--

CREATE TABLE `rrrr_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 `rrrr_add_section`
--


--
-- Table structure for table `rrrr_add_subject`
--

CREATE TABLE `rrrr_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 `rrrr_add_subject`
--


--
-- Table structure for table `rrrr_address2`
--

CREATE TABLE `rrrr_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 `rrrr_address2`
--


--
-- Table structure for table `rrrr_advance_salary`
--

CREATE TABLE `rrrr_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 `rrrr_advance_salary`
--


--
-- Table structure for table `rrrr_attendance_type`
--

CREATE TABLE `rrrr_attendance_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `status` varchar(50) DEFAULT NULL,
  `delete_status` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `rrrr_attendance_type`
--

INSERT INTO `rrrr_attendance_type` VALUES (1,'present','1','0'),(2,'absent','1','0'),(3,'leave','1','0'),(4,'summer vacation','1','0'),(5,'winter vacation','1','0'),(6,'boot camp','1','0'),(7,'bio-metric','1','1'),(8,'shd','1','1'),(9,'bio-metric','1','0');

--
-- Table structure for table `rrrr_class_fee`
--

CREATE TABLE `rrrr_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `rrrr_class_fee`
--


--
-- Table structure for table `rrrr_class_subject`
--

CREATE TABLE `rrrr_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `rrrr_class_subject`
--


--
-- Table structure for table `rrrr_class_teacher_list`
--

CREATE TABLE `rrrr_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 `rrrr_class_teacher_list`
--


--
-- Table structure for table `rrrr_custom_event`
--

CREATE TABLE `rrrr_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,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `rrrr_custom_event`
--


--
-- Table structure for table `rrrr_custom_lecture_request`
--

CREATE TABLE `rrrr_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `rrrr_custom_lecture_request`
--


--
-- Table structure for table `rrrr_custom_timetable`
--

CREATE TABLE `rrrr_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `rrrr_custom_timetable`
--


--
-- Table structure for table `rrrr_emi`
--

CREATE TABLE `rrrr_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 `rrrr_emi`
--


--
-- Table structure for table `rrrr_employee_image`
--

CREATE TABLE `rrrr_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 `rrrr_employee_image`
--


--
-- Table structure for table `rrrr_employee_order`
--

CREATE TABLE `rrrr_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 `rrrr_employee_order`
--

INSERT INTO `rrrr_employee_order` VALUES (1,'User Name','1',2,'front','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,'front','email','Email Id');

--
-- Table structure for table `rrrr_exam`
--

CREATE TABLE `rrrr_exam` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` 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 `rrrr_exam`
--


--
-- Table structure for table `rrrr_fees`
--

CREATE TABLE `rrrr_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,
  `duration` 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 `rrrr_fees`
--


--
-- Table structure for table `rrrr_field_value`
--

CREATE TABLE `rrrr_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `rrrr_field_value`
--


--
-- Table structure for table `rrrr_holiday`
--

CREATE TABLE `rrrr_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `rrrr_holiday`
--


--
-- Table structure for table `rrrr_island`
--

CREATE TABLE `rrrr_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 `rrrr_island`
--


--
-- Table structure for table `rrrr_item`
--

CREATE TABLE `rrrr_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 `rrrr_item`
--


--
-- Table structure for table `rrrr_jobassignment`
--

CREATE TABLE `rrrr_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `rrrr_jobassignment`
--


--
-- Table structure for table `rrrr_leave_list`
--

CREATE TABLE `rrrr_leave_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `leave_type` int(11) DEFAULT NULL,
  `addStartDate` int(11) DEFAULT NULL,
  `addEndDate` int(11) DEFAULT NULL,
  `leave_teacher_id` int(11) DEFAULT NULL,
  `adjust_teacher` int(11) DEFAULT NULL,
  `teacher_list` varchar(50) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `delete_status` 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 `rrrr_leave_list`
--


--
-- Table structure for table `rrrr_leavetype_list`
--

CREATE TABLE `rrrr_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `rrrr_leavetype_list`
--


--
-- Table structure for table `rrrr_loan`
--

CREATE TABLE `rrrr_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `rrrr_loan`
--


--
-- Table structure for table `rrrr_over_time`
--

CREATE TABLE `rrrr_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `rrrr_over_time`
--


--
-- Table structure for table `rrrr_period`
--

CREATE TABLE `rrrr_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 `rrrr_period`
--


--
-- Table structure for table `rrrr_permission`
--

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

--
-- Dumping data for table `rrrr_permission`
--


--
-- Table structure for table `rrrr_preveducation`
--

CREATE TABLE `rrrr_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `rrrr_preveducation`
--


--
-- Table structure for table `rrrr_registration`
--

CREATE TABLE `rrrr_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `rrrr_registration`
--


--
-- Table structure for table `rrrr_retailer`
--

CREATE TABLE `rrrr_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 `rrrr_retailer`
--


--
-- Table structure for table `rrrr_role`
--

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

--
-- Dumping data for table `rrrr_role`
--


--
-- Table structure for table `rrrr_role_permission`
--

CREATE TABLE `rrrr_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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rrrr_role_permission`
--


--
-- Table structure for table `rrrr_rolelist`
--

CREATE TABLE `rrrr_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 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rrrr_rolelist`
--


--
-- Table structure for table `rrrr_salary`
--

CREATE TABLE `rrrr_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,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `rrrr_salary`
--


--
-- Table structure for table `rrrr_salary_month_wise`
--

CREATE TABLE `rrrr_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,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `rrrr_salary_month_wise`
--


--
-- Table structure for table `rrrr_section_list`
--

CREATE TABLE `rrrr_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `rrrr_section_list`
--


--
-- Table structure for table `rrrr_session`
--

CREATE TABLE `rrrr_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `rrrr_session`
--


--
-- Table structure for table `rrrr_sms_class`
--

CREATE TABLE `rrrr_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `rrrr_sms_class`
--


--
-- Table structure for table `rrrr_sms_period`
--

CREATE TABLE `rrrr_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `rrrr_sms_period`
--


--
-- Table structure for table `rrrr_student_order`
--

CREATE TABLE `rrrr_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 `rrrr_student_order`
--

INSERT INTO `rrrr_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 `rrrr_student_subject`
--

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

--
-- Dumping data for table `rrrr_student_subject`
--


--
-- Table structure for table `rrrr_student_verification`
--

CREATE TABLE `rrrr_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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `rrrr_student_verification`
--


--
-- Table structure for table `rrrr_student_work_description`
--

