-- Table structure for table `demo_teacher_registration`
--

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

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


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

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

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

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

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

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

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

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

--
-- Table structure for table `demo_tenant`
--

CREATE TABLE `demo_tenant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tenant_name` varchar(20) DEFAULT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `delete_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ;

--
-- Dumping data for table `demo_tenant`
--


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Table structure for table `demo_users`
--

CREATE TABLE `demo_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uname` varchar(255) DEFAULT NULL,
  `firstname` varchar(255) NOT NULL,
  `lastname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `subject_name` varchar(255) NOT NULL,
  `std_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `firstname` (`firstname`,`email`)
) ENGINE=InnoDB AUTO_INCREMENT=277 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `demo_users`
--

INSERT INTO `demo_users` VALUES (119,'admin','admin','admin','Admin@Gmail.Com','ab233b682ec355648e7891e66c54191b','1','1',NULL),(141,'Maria','Maria','Futterkiste','Maria@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(142,'ana1','anak','demo','ana1@gmail.com','ab233b682ec355648e7891e66c54191b','1','1',NULL),(143,'management','Thomas ','Horn','Thomas@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(144,'backendoffice','Martín ','Sommer','Martin@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(145,'Kayla','kayla1','mathew1','kayla@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(147,'teila','teila','jorg','sadhna1@yatharthriti.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(149,'Lino ','Lino ','Rodriguez','Lino@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(150,'Howard ','Howard 1','Snyder1','Howard@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(151,'Mario ','Mario1','Pontes1','Mario@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(152,'Yoshi Latimer','Yoshi','Latimer','Yoshi@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(153,'donald','donald','trump','donald@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(154,'barack','barack','obama','barack@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(156,'principal','john','cena','john@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(157,'narry','narry','john','naresh@yatharthriti.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(158,'sandy','sandy','Roulet','sandeepkuma1r@yatharthriti.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(159,'Paula@gmail.com','Paula','Parente','Paula@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','114'),(160,'Karl@gmail.com','Karl','Jablonsk','Karl@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','113'),(161,'Wilman@gmail.com','Wilman','Kala','Wilman@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','112'),(163,'sadhna123@yatharthriti.com','helen ','','','e10adc3949ba59abbe56e057f20f883e','1','','115'),(164,'Peter@gmail.com','Peter Franken','Franken','Peter@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','131'),(166,'Janine@gmail.com','Janine','Labrune','Janine@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','129'),(167,'Victoria@gmail.com','Victoria','Ashworth','Victoria@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','128'),(168,'Yang@gmail.com','Yang1','Wang1','Yang@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','127'),(169,'Jose@gmail.com','Jose','Freyre','Jose@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','132'),(170,'Philipi@gmail.com','Philip','Cramer','Philipi@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','134'),(171,'Daniel@gmail.com','Daniel','Tonini','Daniel@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','135'),(172,'Alexander@gmail.com','Alexander','Feuer','Alexander@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','136'),(173,'Georg@gmail.com','Georg','Pipps','Georg@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','137'),(174,'Hanna@gmail.com','Hanna','gfg','Hanna@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','126'),(175,'shamshad@yatharthriti.com',' sammy','Parente','','d41d8cd98f00b204e9800998ecf8427e','1','','138'),(177,'sandeepkumar@yatharthriti.com','sandeep','sharma','sandeepkumar@yatharthriti.com','d41d8cd98f00b204e9800998ecf8427e','1','','142'),(180,'Jonas@gmail.com','Jonas','Bergulfsen','Jonas@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','124'),(181,'diva@yatharthriti.com','diva','robert','sadhna70@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(182,'sadhna70625@gmail.com','tom','Karttunen','sadhna70652@gmail.com','d41d8cd98f00b204e9800998ecf8427e','1','','150'),(183,'SANTOSH ','SANTOSH ',' PATILth','SANTOSH@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(184,'TANMAI','TANMAI ',' APTE','TANMAI@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(185,'SANGITA ','SANGITASATHE',' SATHE','SANGITA@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(186,'PRASHANT ','PRASHANT ',' BANIYA','PRASHANT@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(187,'MANISHA ','MANISHA GHARPURE','GHARPURE','MANISHA@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(188,'SMITA ','SMITABANE',' BANE','SMITA@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(189,'MEGHANA','MEGHANA','DESAI','MEGHANA@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(190,'ANIRUDDHA ','ANIRUDDHA GOSAVI','GOSAVI','ANIRUDDHA@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(191,'SNEHALKUMAR','SNEHALKUMAR',' DHAMAPURKAR','SNEHALKUMAR@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(192,'KSHITIJA ','KSHITIJA','MATE','KSHITIJA@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(193,'SWATI','SWATI',' MUJUMDAR','SWATI@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(194,'SWAPNIL BHATE','SWAPNIL','SWAPNIL BHATE','SWAPNIL@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(195,'albert','dsd','dsdf','zxz@ggmail.com','277fa9f6a833e33a2007d09d2137fbf5','1','',NULL),(196,'ravi','ravi','sharma','shivani@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(197,'dhruvk333@gmail.com','dhruv','cv','dhruvk3331@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','731'),(198,'mansee@gmail.com','mansee','sulodiya','mansee@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','739'),(199,'alla','alla','sharma','demo_3@demo.com','25f9e794323b453885f5181f1b624d0b','1','','736'),(200,'naresh','naresh','test','test@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',''),(201,'sv419459@gmail.com','jacky','SANGALE','sv419459@gmail.com','ab233b682ec355648e7891e66c54191b','1','','734'),(202,'Olivia@gmail.com','Olivia','abc','Olivia1@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','741'),(203,'Ava@gmail.com','Ava','demo','Ava@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','742'),(204,'Dora@gmail.com','Dora','sharma','Dora1@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','743'),(205,'Ceila@gmail.com','ceila','Cruz','Ceila1@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','744'),(206,'Fanny@gmail.com','Fanny','demo','Fanny1@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','745'),(207,'demo@yatharthriti.com','abhi','kumar s','demo1@yatharthriti.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(208,'riya sharma','riya','sharma','riya@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(209,'shivi@gmail.com','shivani','sulodiya','shivai@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','746'),(210,'robby@gmail.com','robby','demo','robby11@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','747'),(211,'james','james','luise','james@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(212,'sadhna','emily','desoza','sadhna7065@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','748'),(213,'kevin','kevin','filip','kevin@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(214,'Zac','Zac','luise','Zac@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(215,'Nora','Nora','demo','Nora@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(216,'eliza','eliza','demo','eliza@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(217,'nova@gmail.com','Nova','sharma','nova1@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','752'),(218,'mya@gmail.com','Mya','demo','mya1@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','751'),(219,'melina@gmail.com','Melina','demo','melina1@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','750'),(220,'kuldeepbanga@gmail.com','Eva','demo','kuldeepbanga@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','749'),(221,'Ameliya@gmail.com','Ameliya','demo','Ameliya1@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','753'),(222,'ana','ana','demo','ana@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(223,'chitra@gmail.com','chitra','demo','chitra1@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','754'),(224,'divyamisra25@gmail.com','shivi','demo','divyamisra25@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','755'),(225,'divya@yatharthriti.com','divya','luice','divya@yatharthriti.com','25f9e794323b453885f5181f1b624d0b','1','','145'),(226,'richa@gmail.com','richa','sharma','richa@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(228,'Mangy@gmail.com','mangy','robrt','mangy@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(229,'mia','mia','sharma','mia@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(230,'emma@gmail.com','emma','luise','emma@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','770'),(231,'sadhna37@yatharthriti.com','sadhna','yadav','sadhna37@yatharthriti.com','25f9e794323b453885f5181f1b624d0b','1','','771'),(232,'sandya@yatharthriti.com','sandya','yadav','sandya@yatharthriti.com','01acb6ec38fa3805ff4c3a785b0cff30','1','','772'),(233,'sadhna@yatharthriti.com','samya','Parente','sadhna@yatharthriti.com','25f9e794323b453885f5181f1b624d0b','1','','773'),(234,'Marry@gmail.com','marry','Karttunen','Marry@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','774'),(235,'subject@gmail.com','subjectm','Karttunen','subject@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','775'),(236,'Matti@gmail.com','sandeepsubject','Karttunen','Matti@gmail.com','980a042a819af0174e075cc91b55bc83','1','','776'),(237,'richard@gmail.com','richard','Parente','richard@gmail.com','25f9e794323b453885f5181f1b624d0b','0','','777'),(238,'s1@yatharthriti.com','sadhna','yadav','s1@yatharthriti.com','9da825c4f83607130bad84ee638a9315','1','','778'),(239,'s11@yatharthriti.com','sadhna','yadav','s11@yatharthriti.com','09f8f968429d9850ff004fb9484e4747','1','','779'),(240,'s12@yatharthriti.com','sadhna','yadav','s12@yatharthriti.com','3cb2c0cbd8b8bc9307632e6de4ce5f98','1','','780'),(241,'sanya@gmail.com','sanya','yadav','sanya@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','781'),(242,'sreya@gmail.com','sreya','yadav','sreya@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','782'),(243,'sreya@yatharthriti.com','sreya','yadav','sreya@yatharthriti.com','d84b788432d8e065e10ff8bd9ce3663e','1','','783'),(244,'s1123@yatharthriti.com','sreya','yadav','s1123@yatharthriti.com','c47524504f3187ba5edf44e4970b85ad','1','','784'),(245,'s123@yatharthriti.com','sreya1','yadav1','s123@yatharthriti.com','832dc661c7ff8fb1247289f6901cf72b','1','','785'),(247,'demo@demo.com_2','AVDHUT','SANGALE','demo@demo.com_2','f973f20e9c797059f289fb176b2d913c','1','','786'),(248,'xyz@gmail.com','xyz','yadav','xyz@gmail.com','af7e566821ead9715dc0cdce851a98f9','1','','787'),(249,'xyz1@gmail.com','xyz','yadav','xyz1@gmail.com','a48d8b1126f9e89fe7307a7f72c45c1a','1','','788'),(250,'harry@gmail.com','Harry','james','harry@gmail.com','b98e12e9d21647a5d39032dedcd18755','1','','789'),(251,'suresh','suresh','Yadav','suresh@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(252,'Nick','nick','johna','nick@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(253,'niya@gmail.com','niya','sharma','niya@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','790'),(254,'ava','ava','peetr','avapeter@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(255,'Ella','Ella df','demo','ella@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(256,'miaa@gmail.com','mia','jorg','miaa@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','791'),(257,'daisy@gmail.com','daisy','demo','daisy@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','792'),(258,'aryab@gmail.com','aryab','demo','aryab@gmail.com','748cbd1f35d2f2621bb5034f230f624d','1','','793'),(259,'sarry@gmail.com','sarry','james','sarry@gmail.com','04c7c18d0d44fad7731e4635fcc03779','1','','794'),(260,'sarry1@gmail.com','sarry','james','sarry1@gmail.com','19505bf92d4a5f247390a4acd7b8de7e','1','','795'),(261,'sarry12@gmail.com','sarry','demo','sarry12@gmail.com','ff5c8413cf887c8fe22178f60edd09b8','1','','796'),(262,'sarry23@gmail.com','sarry','demo','sarry23@gmail.com','74f76a3c4091f6ee7a11d9f82d423555','1','','797'),(263,'micky@gmail.com','micky','demo','micky@gmail.com','a030e26cd77efd66e9d5125e63a94c50','1','','798'),(264,'ayeesha@gmail.com','ayeesha','safi','ayeesha@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','799'),(265,'ritu@gmail.com','ritu','sharma','ritu@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','800'),(266,'jyoti@gmail.com','jyoti','kumari','jyoti@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','801'),(267,'mansee','mansee','sulodiya','manse@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(268,'poonam','poonam','kumari','poonam@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(269,'anjali','anjali','sharma','anjali@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(270,'priya@gmail.com','priya','sharma','priya@gmail.com','25f9e794323b453885f5181f1b624d0b','1','',NULL),(271,'scott@gmail.com','scott','layton','scott@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','802'),(272,'skyla@gmail.com','skyla','kimber','skyla@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','803'),(273,'zeke@gmail.com','zeke','liberty','zeke@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','804'),(274,'nelson@gmail.com','nelson','devon','nelson@gmail.com','25d55ad283aa400af464c76d713c07ad','1','','805'),(275,'sandeepking1015@gmail.com','ayansh','Yadav','sandeepking1015@gmail.com','25f9e794323b453885f5181f1b624d0b','1','','806'),(276,'gut','yu','uk','Victoria44@gmail.com','a0e05d246cbc3eb81f1cdc67aa7fb5db','1','',NULL);

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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


--
-- Table structure for table `fff_attendance_type`
--

CREATE TABLE `fff_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 `fff_attendance_type`
--

INSERT INTO `fff_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 `fff_class_and_section_list`
--

CREATE TABLE `fff_class_and_section_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) DEFAULT NULL,
  `class_id` varchar(50) DEFAULT NULL,
  `section_id` varchar(50) DEFAULT NULL,
  `session_id` varchar(50) DEFAULT NULL,
  `delete_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `fff_class_and_section_list`
--


--
-- Table structure for table `fff_class_fee`
--

CREATE TABLE `fff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `fff_class_fee`
--


--
-- Table structure for table `fff_class_subject`
--

CREATE TABLE `fff_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 ;

--
-- Dumping data for table `fff_class_subject`
--


--
-- Table structure for table `fff_class_teacher_list`
--

CREATE TABLE `fff_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 ;

--
-- Dumping data for table `fff_class_teacher_list`
--


--
-- Table structure for table `fff_custom_event`
--

CREATE TABLE `fff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `fff_custom_event`
--


--
-- Table structure for table `fff_custom_lecture_request`
--

CREATE TABLE `fff_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 ;

--
-- Dumping data for table `fff_custom_lecture_request`
--


--
-- Table structure for table `fff_custom_timetable`
--

CREATE TABLE `fff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `fff_custom_timetable`
--


--
-- Table structure for table `fff_emi`
--

CREATE TABLE `fff_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 ;

--
-- Dumping data for table `fff_emi`
--


--
-- Table structure for table `fff_employee_image`
--

CREATE TABLE `fff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `fff_employee_image`
--


--
-- Table structure for table `fff_employee_order`
--

CREATE TABLE `fff_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 `fff_employee_order`
--

INSERT INTO `fff_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 `fff_exam`
--

CREATE TABLE `fff_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 ;

--
-- Dumping data for table `fff_exam`
--


--
-- Table structure for table `fff_fees`
--

CREATE TABLE `fff_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 ;

--
-- Dumping data for table `fff_fees`
--


--
-- Table structure for table `fff_field_value`
--

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

--
-- Dumping data for table `fff_field_value`
--


--
-- Table structure for table `fff_holiday`
--

CREATE TABLE `fff_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 ;

--
-- Dumping data for table `fff_holiday`
--


--
-- Table structure for table `fff_island`
--

CREATE TABLE `fff_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 `fff_island`
--


--
-- Table structure for table `fff_item`
--

CREATE TABLE `fff_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 `fff_item`
--


--
-- Table structure for table `fff_jobassignment`
--

CREATE TABLE `fff_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 ;

--
-- Dumping data for table `fff_jobassignment`
--


--
-- Table structure for table `fff_leave_list`
--

CREATE TABLE `fff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `fff_leave_list`
--


--
-- Table structure for table `fff_leavetype_list`
--

CREATE TABLE `fff_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 ;

--
-- Dumping data for table `fff_leavetype_list`
--


--
-- Table structure for table `fff_loan`
--

CREATE TABLE `fff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `fff_loan`
--


--
-- Table structure for table `fff_over_time`
--

CREATE TABLE `fff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `fff_over_time`
--


--
-- Table structure for table `fff_period`
--

CREATE TABLE `fff_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 `fff_period`
--


--
-- Table structure for table `fff_permission`
--

CREATE TABLE `fff_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 `fff_permission`
--


--
-- Table structure for table `fff_preveducation`
--

CREATE TABLE `fff_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 ;

--
-- Dumping data for table `fff_preveducation`
--


--
-- Table structure for table `fff_registration`
--

CREATE TABLE `fff_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 ;

--
-- Dumping data for table `fff_registration`
--


--
-- Table structure for table `fff_retailer`
--

CREATE TABLE `fff_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 `fff_retailer`
--


--
-- Table structure for table `fff_role`
--

CREATE TABLE `fff_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 `fff_role`
--


--
-- Table structure for table `fff_role_permission`
--

CREATE TABLE `fff_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 `fff_role_permission`
--


--
-- Table structure for table `fff_rolelist`
--

CREATE TABLE `fff_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 `fff_rolelist`
--


--
-- Table structure for table `fff_salary`
--

CREATE TABLE `fff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `fff_salary`
--


--
-- Table structure for table `fff_salary_month_wise`
--

CREATE TABLE `fff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `fff_salary_month_wise`
--


--
-- Table structure for table `fff_sandy`
--

CREATE TABLE `fff_sandy` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ;

--
-- Dumping data for table `fff_sandy`
--


--
-- Table structure for table `fff_section_list`
--

CREATE TABLE `fff_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 ;

--
-- Dumping data for table `fff_section_list`
--


--
-- Table structure for table `fff_session`
--

CREATE TABLE `fff_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 ;

--
-- Dumping data for table `fff_session`
--


--
-- Table structure for table `fff_sms_class`
--

CREATE TABLE `fff_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 ;

--
-- Dumping data for table `fff_sms_class`
--


--
-- Table structure for table `fff_sms_period`
--

CREATE TABLE `fff_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 ;

--
-- Dumping data for table `fff_sms_period`
--


--
-- Table structure for table `fff_student_marks`
--

CREATE TABLE `fff_student_marks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` varchar(50) NOT NULL DEFAULT '0',
  `session_id` varchar(50) NOT NULL DEFAULT '0',
  `exam_id` varchar(50) NOT NULL DEFAULT '0',
  `subject_id` varchar(50) NOT NULL DEFAULT '0',
  `subject_marks` varchar(50) NOT NULL DEFAULT '0',
  `total` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ;

--
-- Dumping data for table `fff_student_marks`
--


--
-- Table structure for table `fff_student_order`
--

CREATE TABLE `fff_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 `fff_student_order`
--

INSERT INTO `fff_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 `fff_student_subject`
--

CREATE TABLE `fff_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 ;

--
-- Dumping data for table `fff_student_subject`
--


--
-- Table structure for table `fff_student_verification`
--

CREATE TABLE `fff_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 ;

--
-- Dumping data for table `fff_student_verification`
--


--
-- Table structure for table `fff_student_work_description`
--

CREATE TABLE `fff_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 ;

--
-- Dumping data for table `fff_student_work_description`
--


--
-- Table structure for table `fff_subject_list`
--

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

--
-- Dumping data for table `fff_subject_list`
--


--
-- Table structure for table `fff_supplier`
--

CREATE TABLE `fff_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 `fff_supplier`
--


--
-- Table structure for table `fff_teacher_class_section_list`
--

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

--
-- Dumping data for table `fff_teacher_class_section_list`
--


--
-- Table structure for table `fff_teacher_list`
--

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

--
-- Dumping data for table `fff_teacher_list`
--


--
-- Table structure for table `fff_teacher_registration`
--

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

--
-- Dumping data for table `fff_teacher_registration`
--


--
-- Table structure for table `fff_temporary_timetable`
--

CREATE TABLE `fff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `fff_temporary_timetable`
--


--
-- Table structure for table `fff_temporary_timetable_history`
--

CREATE TABLE `fff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `fff_temporary_timetable_history`
--


--
-- Table structure for table `fff_tenant`
--

CREATE TABLE `fff_tenant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tenant_name` varchar(20) DEFAULT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `delete_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ;

--
-- Dumping data for table `fff_tenant`
--


--
-- Table structure for table `fff_timetable`
--

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

--
-- Dumping data for table `fff_timetable`
--


--
-- Table structure for table `fff_upload_document`
--

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

--
-- Dumping data for table `fff_upload_document`
--


--
-- Table structure for table `fff_uploadimage`
--

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

--
-- Dumping data for table `fff_uploadimage`
--


--
-- Table structure for table `fff_user_attendance`
--

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

--
-- Dumping data for table `fff_user_attendance`
--


--
-- Table structure for table `fff_user_permission`
--

CREATE TABLE `fff_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 `fff_user_permission`
--


--
-- Table structure for table `fff_users`
--

CREATE TABLE `fff_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uname` varchar(255) DEFAULT NULL,
  `firstname` varchar(255) NOT NULL,
  `lastname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `subject_name` varchar(255) NOT NULL,
  `std_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `firstname` (`firstname`,`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `fff_users`
--

INSERT INTO `fff_users` VALUES (1,'admin','admin','admin','admin','ab233b682ec355648e7891e66c54191b','1','test','1');

--
-- Table structure for table `fff_work_description`
--

CREATE TABLE `fff_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 ;

--
-- Dumping data for table `fff_work_description`
--


--
-- Table structure for table `ffff_Event`
--

CREATE TABLE `ffff_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 ;

--
-- Dumping data for table `ffff_Event`
--


--
-- Table structure for table `ffff_accounting`
--

CREATE TABLE `ffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffff_accounting`
--


--
-- Table structure for table `ffff_add_class`
--

CREATE TABLE `ffff_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 `ffff_add_class`
--


--
-- Table structure for table `ffff_add_field`
--

CREATE TABLE `ffff_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 ;

--
-- Dumping data for table `ffff_add_field`
--


--
-- Table structure for table `ffff_add_section`
--

CREATE TABLE `ffff_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 `ffff_add_section`
--


--
-- Table structure for table `ffff_add_subject`
--

CREATE TABLE `ffff_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 ;

--
-- Dumping data for table `ffff_add_subject`
--


--
-- Table structure for table `ffff_address2`
--

CREATE TABLE `ffff_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 ;

--
-- Dumping data for table `ffff_address2`
--


--
-- Table structure for table `ffff_advance_salary`
--

CREATE TABLE `ffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffff_advance_salary`
--


--
-- Table structure for table `ffff_attendance_type`
--

CREATE TABLE `ffff_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 `ffff_attendance_type`
--

INSERT INTO `ffff_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 `ffff_class_and_section_list`
--

CREATE TABLE `ffff_class_and_section_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) DEFAULT NULL,
  `class_id` varchar(50) DEFAULT NULL,
  `section_id` varchar(50) DEFAULT NULL,
  `session_id` varchar(50) DEFAULT NULL,
  `delete_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffff_class_and_section_list`
--


--
-- Table structure for table `ffff_class_fee`
--

CREATE TABLE `ffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffff_class_fee`
--


--
-- Table structure for table `ffff_class_subject`
--

CREATE TABLE `ffff_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 ;

--
-- Dumping data for table `ffff_class_subject`
--


--
-- Table structure for table `ffff_class_teacher_list`
--

CREATE TABLE `ffff_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 ;

--
-- Dumping data for table `ffff_class_teacher_list`
--


--
-- Table structure for table `ffff_custom_event`
--

CREATE TABLE `ffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffff_custom_event`
--


--
-- Table structure for table `ffff_custom_lecture_request`
--

CREATE TABLE `ffff_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 ;

--
-- Dumping data for table `ffff_custom_lecture_request`
--


--
-- Table structure for table `ffff_custom_timetable`
--

CREATE TABLE `ffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffff_custom_timetable`
--


--
-- Table structure for table `ffff_emi`
--

CREATE TABLE `ffff_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 ;

--
-- Dumping data for table `ffff_emi`
--


--
-- Table structure for table `ffff_employee_image`
--

CREATE TABLE `ffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffff_employee_image`
--


--
-- Table structure for table `ffff_employee_order`
--

CREATE TABLE `ffff_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 `ffff_employee_order`
--

INSERT INTO `ffff_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 `ffff_exam`
--

CREATE TABLE `ffff_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 ;

--
-- Dumping data for table `ffff_exam`
--


--
-- Table structure for table `ffff_fees`
--

CREATE TABLE `ffff_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 ;

--
-- Dumping data for table `ffff_fees`
--


--
-- Table structure for table `ffff_field_value`
--

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

--
-- Dumping data for table `ffff_field_value`
--


--
-- Table structure for table `ffff_holiday`
--

CREATE TABLE `ffff_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 ;

--
-- Dumping data for table `ffff_holiday`
--


--
-- Table structure for table `ffff_island`
--

CREATE TABLE `ffff_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 `ffff_island`
--


--
-- Table structure for table `ffff_item`
--

CREATE TABLE `ffff_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 `ffff_item`
--


--
-- Table structure for table `ffff_jobassignment`
--

CREATE TABLE `ffff_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 ;

--
-- Dumping data for table `ffff_jobassignment`
--


--
-- Table structure for table `ffff_leave_list`
--

CREATE TABLE `ffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffff_leave_list`
--


--
-- Table structure for table `ffff_leavetype_list`
--

CREATE TABLE `ffff_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 ;

--
-- Dumping data for table `ffff_leavetype_list`
--


--
-- Table structure for table `ffff_loan`
--

CREATE TABLE `ffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffff_loan`
--


--
-- Table structure for table `ffff_over_time`
--

CREATE TABLE `ffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffff_over_time`
--


--
-- Table structure for table `ffff_period`
--

CREATE TABLE `ffff_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 `ffff_period`
--


--
-- Table structure for table `ffff_permission`
--

CREATE TABLE `ffff_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 `ffff_permission`
--


--
-- Table structure for table `ffff_preveducation`
--

CREATE TABLE `ffff_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 ;

--
-- Dumping data for table `ffff_preveducation`
--


--
-- Table structure for table `ffff_registration`
--

CREATE TABLE `ffff_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 ;

--
-- Dumping data for table `ffff_registration`
--


--
-- Table structure for table `ffff_retailer`
--

CREATE TABLE `ffff_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 `ffff_retailer`
--


--
-- Table structure for table `ffff_role`
--

CREATE TABLE `ffff_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 `ffff_role`
--


--
-- Table structure for table `ffff_role_permission`
--

CREATE TABLE `ffff_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 `ffff_role_permission`
--


--
-- Table structure for table `ffff_rolelist`
--

CREATE TABLE `ffff_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 `ffff_rolelist`
--


--
-- Table structure for table `ffff_salary`
--

CREATE TABLE `ffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffff_salary`
--


--
-- Table structure for table `ffff_salary_month_wise`
--

CREATE TABLE `ffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffff_salary_month_wise`
--


--
-- Table structure for table `ffff_sandy`
--

CREATE TABLE `ffff_sandy` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ;

--
-- Dumping data for table `ffff_sandy`
--


--
-- Table structure for table `ffff_section_list`
--

CREATE TABLE `ffff_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 ;

--
-- Dumping data for table `ffff_section_list`
--


--
-- Table structure for table `ffff_session`
--

CREATE TABLE `ffff_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 ;

--
-- Dumping data for table `ffff_session`
--


--
-- Table structure for table `ffff_sms_class`
--

CREATE TABLE `ffff_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 ;

--
-- Dumping data for table `ffff_sms_class`
--


--
-- Table structure for table `ffff_sms_period`
--

CREATE TABLE `ffff_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 ;

--
-- Dumping data for table `ffff_sms_period`
--


--
-- Table structure for table `ffff_student_marks`
--

CREATE TABLE `ffff_student_marks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` varchar(50) NOT NULL DEFAULT '0',
  `session_id` varchar(50) NOT NULL DEFAULT '0',
  `exam_id` varchar(50) NOT NULL DEFAULT '0',
  `subject_id` varchar(50) NOT NULL DEFAULT '0',
  `subject_marks` varchar(50) NOT NULL DEFAULT '0',
  `total` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ;

--
-- Dumping data for table `ffff_student_marks`
--


--
-- Table structure for table `ffff_student_order`
--

CREATE TABLE `ffff_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 `ffff_student_order`
--

INSERT INTO `ffff_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 `ffff_student_subject`
--

CREATE TABLE `ffff_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 ;

--
-- Dumping data for table `ffff_student_subject`
--


--
-- Table structure for table `ffff_student_verification`
--

CREATE TABLE `ffff_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 ;

--
-- Dumping data for table `ffff_student_verification`
--


--
-- Table structure for table `ffff_student_work_description`
--

CREATE TABLE `ffff_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 ;

--
-- Dumping data for table `ffff_student_work_description`
--


--
-- Table structure for table `ffff_subject_list`
--

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

--
-- Dumping data for table `ffff_subject_list`
--


--
-- Table structure for table `ffff_supplier`
--

CREATE TABLE `ffff_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 `ffff_supplier`
--


--
-- Table structure for table `ffff_teacher_class_section_list`
--

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

--
-- Dumping data for table `ffff_teacher_class_section_list`
--


--
-- Table structure for table `ffff_teacher_list`
--

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

--
-- Dumping data for table `ffff_teacher_list`
--


--
-- Table structure for table `ffff_teacher_registration`
--

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

--
-- Dumping data for table `ffff_teacher_registration`
--


--
-- Table structure for table `ffff_temporary_timetable`
--

CREATE TABLE `ffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffff_temporary_timetable`
--


--
-- Table structure for table `ffff_temporary_timetable_history`
--

CREATE TABLE `ffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffff_temporary_timetable_history`
--


--
-- Table structure for table `ffff_tenant`
--

CREATE TABLE `ffff_tenant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tenant_name` varchar(20) DEFAULT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `delete_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ;

--
-- Dumping data for table `ffff_tenant`
--


--
-- Table structure for table `ffff_timetable`
--

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

--
-- Dumping data for table `ffff_timetable`
--


--
-- Table structure for table `ffff_upload_document`
--

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

--
-- Dumping data for table `ffff_upload_document`
--


--
-- Table structure for table `ffff_uploadimage`
--

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

--
-- Dumping data for table `ffff_uploadimage`
--


--
-- Table structure for table `ffff_user_attendance`
--

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

--
-- Dumping data for table `ffff_user_attendance`
--


--
-- Table structure for table `ffff_user_permission`
--

CREATE TABLE `ffff_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 `ffff_user_permission`
--


--
-- Table structure for table `ffff_users`
--

CREATE TABLE `ffff_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uname` varchar(255) DEFAULT NULL,
  `firstname` varchar(255) NOT NULL,
  `lastname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `subject_name` varchar(255) NOT NULL,
  `std_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `firstname` (`firstname`,`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ffff_users`
--

INSERT INTO `ffff_users` VALUES (1,'admin','admin','admin','admin','ab233b682ec355648e7891e66c54191b','1','test','1');

--
-- Table structure for table `ffff_work_description`
--

CREATE TABLE `ffff_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 ;

--
-- Dumping data for table `ffff_work_description`
--


--
-- Table structure for table `ffffffffffff_Event`
--

CREATE TABLE `ffffffffffff_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 ;

--
-- Dumping data for table `ffffffffffff_Event`
--


--
-- Table structure for table `ffffffffffff_accounting`
--

CREATE TABLE `ffffffffffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffffffffffff_accounting`
--


--
-- Table structure for table `ffffffffffff_add_class`
--

CREATE TABLE `ffffffffffff_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 `ffffffffffff_add_class`
--


--
-- Table structure for table `ffffffffffff_add_field`
--

CREATE TABLE `ffffffffffff_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 ;

--
-- Dumping data for table `ffffffffffff_add_field`
--


--
-- Table structure for table `ffffffffffff_add_section`
--

CREATE TABLE `ffffffffffff_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 `ffffffffffff_add_section`
--


--
-- Table structure for table `ffffffffffff_add_subject`
--

CREATE TABLE `ffffffffffff_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 ;

--
-- Dumping data for table `ffffffffffff_add_subject`
--


--
-- Table structure for table `ffffffffffff_address2`
--

CREATE TABLE `ffffffffffff_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 ;

--
-- Dumping data for table `ffffffffffff_address2`
--


--
-- Table structure for table `ffffffffffff_advance_salary`
--

CREATE TABLE `ffffffffffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffffffffffff_advance_salary`
--


--
-- Table structure for table `ffffffffffff_attendance_type`
--

CREATE TABLE `ffffffffffff_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 `ffffffffffff_attendance_type`
--

INSERT INTO `ffffffffffff_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 `ffffffffffff_class_and_section_list`
--

CREATE TABLE `ffffffffffff_class_and_section_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) DEFAULT NULL,
  `class_id` varchar(50) DEFAULT NULL,
  `section_id` varchar(50) DEFAULT NULL,
  `session_id` varchar(50) DEFAULT NULL,
  `delete_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffffffffffff_class_and_section_list`
--


--
-- Table structure for table `ffffffffffff_class_fee`
--

CREATE TABLE `ffffffffffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffffffffffff_class_fee`
--


--
-- Table structure for table `ffffffffffff_class_subject`
--

CREATE TABLE `ffffffffffff_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 ;

--
-- Dumping data for table `ffffffffffff_class_subject`
--


--
-- Table structure for table `ffffffffffff_class_teacher_list`
--

CREATE TABLE `ffffffffffff_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 ;

--
-- Dumping data for table `ffffffffffff_class_teacher_list`
--


--
-- Table structure for table `ffffffffffff_custom_event`
--

CREATE TABLE `ffffffffffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffffffffffff_custom_event`
--


--
-- Table structure for table `ffffffffffff_custom_lecture_request`
--

CREATE TABLE `ffffffffffff_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 ;

--
-- Dumping data for table `ffffffffffff_custom_lecture_request`
--


--
-- Table structure for table `ffffffffffff_custom_timetable`
--

CREATE TABLE `ffffffffffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffffffffffff_custom_timetable`
--


--
-- Table structure for table `ffffffffffff_emi`
--

CREATE TABLE `ffffffffffff_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 ;

--
-- Dumping data for table `ffffffffffff_emi`
--


--
-- Table structure for table `ffffffffffff_employee_image`
--

CREATE TABLE `ffffffffffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffffffffffff_employee_image`
--


--
-- Table structure for table `ffffffffffff_employee_order`
--

CREATE TABLE `ffffffffffff_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 `ffffffffffff_employee_order`
--

INSERT INTO `ffffffffffff_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 `ffffffffffff_exam`
--

CREATE TABLE `ffffffffffff_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 ;

--
-- Dumping data for table `ffffffffffff_exam`
--


--
-- Table structure for table `ffffffffffff_fees`
--

CREATE TABLE `ffffffffffff_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 ;

--
-- Dumping data for table `ffffffffffff_fees`
--


--
-- Table structure for table `ffffffffffff_field_value`
--

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

--
-- Dumping data for table `ffffffffffff_field_value`
--


--
-- Table structure for table `ffffffffffff_holiday`
--

CREATE TABLE `ffffffffffff_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 ;

--
-- Dumping data for table `ffffffffffff_holiday`
--


--
-- Table structure for table `ffffffffffff_island`
--

CREATE TABLE `ffffffffffff_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 `ffffffffffff_island`
--


--
-- Table structure for table `ffffffffffff_item`
--

CREATE TABLE `ffffffffffff_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 `ffffffffffff_item`
--


--
-- Table structure for table `ffffffffffff_jobassignment`
--

CREATE TABLE `ffffffffffff_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 ;

--
-- Dumping data for table `ffffffffffff_jobassignment`
--


--
-- Table structure for table `ffffffffffff_leave_list`
--

CREATE TABLE `ffffffffffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffffffffffff_leave_list`
--


--
-- Table structure for table `ffffffffffff_leavetype_list`
--

CREATE TABLE `ffffffffffff_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 ;

--
-- Dumping data for table `ffffffffffff_leavetype_list`
--


--
-- Table structure for table `ffffffffffff_loan`
--

CREATE TABLE `ffffffffffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffffffffffff_loan`
--


--
-- Table structure for table `ffffffffffff_over_time`
--

CREATE TABLE `ffffffffffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffffffffffff_over_time`
--


--
-- Table structure for table `ffffffffffff_period`
--

CREATE TABLE `ffffffffffff_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 `ffffffffffff_period`
--


--
-- Table structure for table `ffffffffffff_permission`
--

CREATE TABLE `ffffffffffff_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 `ffffffffffff_permission`
--


--
-- Table structure for table `ffffffffffff_preveducation`
--

CREATE TABLE `ffffffffffff_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 ;

--
-- Dumping data for table `ffffffffffff_preveducation`
--


--
-- Table structure for table `ffffffffffff_registration`
--

CREATE TABLE `ffffffffffff_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 ;

--
-- Dumping data for table `ffffffffffff_registration`
--


--
-- Table structure for table `ffffffffffff_retailer`
--

CREATE TABLE `ffffffffffff_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 `ffffffffffff_retailer`
--


--
-- Table structure for table `ffffffffffff_role`
--

CREATE TABLE `ffffffffffff_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 `ffffffffffff_role`
--


--
-- Table structure for table `ffffffffffff_role_permission`
--

CREATE TABLE `ffffffffffff_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 `ffffffffffff_role_permission`
--


--
-- Table structure for table `ffffffffffff_rolelist`
--

CREATE TABLE `ffffffffffff_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 `ffffffffffff_rolelist`
--


--
-- Table structure for table `ffffffffffff_salary`
--

CREATE TABLE `ffffffffffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffffffffffff_salary`
--


--
-- Table structure for table `ffffffffffff_salary_month_wise`
--

CREATE TABLE `ffffffffffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffffffffffff_salary_month_wise`
--


--
-- Table structure for table `ffffffffffff_sandy`
--

CREATE TABLE `ffffffffffff_sandy` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ;

--
-- Dumping data for table `ffffffffffff_sandy`
--


--
-- Table structure for table `ffffffffffff_section_list`
--

CREATE TABLE `ffffffffffff_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 ;

--
-- Dumping data for table `ffffffffffff_section_list`
--


--
-- Table structure for table `ffffffffffff_session`
--

CREATE TABLE `ffffffffffff_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 ;

--
-- Dumping data for table `ffffffffffff_session`
--


--
-- Table structure for table `ffffffffffff_sms_class`
--

CREATE TABLE `ffffffffffff_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 ;

--
-- Dumping data for table `ffffffffffff_sms_class`
--


--
-- Table structure for table `ffffffffffff_sms_period`
--

CREATE TABLE `ffffffffffff_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 ;

--
-- Dumping data for table `ffffffffffff_sms_period`
--


--
-- Table structure for table `ffffffffffff_student_marks`
--

CREATE TABLE `ffffffffffff_student_marks` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` varchar(50) NOT NULL DEFAULT '0',
  `session_id` varchar(50) NOT NULL DEFAULT '0',
  `exam_id` varchar(50) NOT NULL DEFAULT '0',
  `subject_id` varchar(50) NOT NULL DEFAULT '0',
  `subject_marks` varchar(50) NOT NULL DEFAULT '0',
  `total` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ;

--
-- Dumping data for table `ffffffffffff_student_marks`
--


--
-- Table structure for table `ffffffffffff_student_order`
--

CREATE TABLE `ffffffffffff_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 `ffffffffffff_student_order`
--

INSERT INTO `ffffffffffff_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 `ffffffffffff_student_subject`
--

CREATE TABLE `ffffffffffff_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 ;

--
-- Dumping data for table `ffffffffffff_student_subject`
--


--
-- Table structure for table `ffffffffffff_student_verification`
--

CREATE TABLE `ffffffffffff_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 ;

--
-- Dumping data for table `ffffffffffff_student_verification`
--


--
-- Table structure for table `ffffffffffff_student_work_description`
--

CREATE TABLE `ffffffffffff_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 ;

--
-- Dumping data for table `ffffffffffff_student_work_description`
--


--
-- Table structure for table `ffffffffffff_subject_list`
--

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

--
-- Dumping data for table `ffffffffffff_subject_list`
--


--
-- Table structure for table `ffffffffffff_supplier`
--

CREATE TABLE `ffffffffffff_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 `ffffffffffff_supplier`
--


--
-- Table structure for table `ffffffffffff_teacher_class_section_list`
--

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

--
-- Dumping data for table `ffffffffffff_teacher_class_section_list`
--


--
-- Table structure for table `ffffffffffff_teacher_list`
--

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

--
-- Dumping data for table `ffffffffffff_teacher_list`
--


--
-- Table structure for table `ffffffffffff_teacher_registration`
--

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

--
-- Dumping data for table `ffffffffffff_teacher_registration`
--


--
-- Table structure for table `ffffffffffff_temporary_timetable`
--

CREATE TABLE `ffffffffffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffffffffffff_temporary_timetable`
--


--
-- Table structure for table `ffffffffffff_temporary_timetable_history`
--

CREATE TABLE `ffffffffffff_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffffffffffff_temporary_timetable_history`
--


--
-- Table structure for table `ffffffffffff_tenant`
--

CREATE TABLE `ffffffffffff_tenant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tenant_name` varchar(20) DEFAULT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `delete_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ;

--
-- Dumping data for table `ffffffffffff_tenant`
--


--
-- Table structure for table `ffffffffffff_timetable`
--

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

--
-- Dumping data for table `ffffffffffff_timetable`
--


--
-- Table structure for table `ffffffffffff_upload_document`
--

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

--
-- Dumping data for table `ffffffffffff_upload_document`
--


--
-- Table structure for table `ffffffffffff_uploadimage`
--

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

--
-- Dumping data for table `ffffffffffff_uploadimage`
--


--
-- Table structure for table `ffffffffffff_user_attendance`
--

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

--
-- Dumping data for table `ffffffffffff_user_attendance`
--


--
-- Table structure for table `ffffffffffff_user_permission`
--

CREATE TABLE `ffffffffffff_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 `ffffffffffff_user_permission`
--


--
-- Table structure for table `ffffffffffff_users`
--

CREATE TABLE `ffffffffffff_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uname` varchar(255) DEFAULT NULL,
  `firstname` varchar(255) NOT NULL,
  `lastname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `subject_name` varchar(255) NOT NULL,
  `std_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `firstname` (`firstname`,`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ffffffffffff_users`
--

INSERT INTO `ffffffffffff_users` VALUES (1,'admin','admin','admin','admin','ab233b682ec355648e7891e66c54191b','1','test','1');

--
-- Table structure for table `ffffffffffff_work_description`
--

CREATE TABLE `ffffffffffff_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 ;

--
-- Dumping data for table `ffffffffffff_work_description`
--


--
-- Table structure for table `ffffg_Event`
--

CREATE TABLE `ffffg_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 ;

--
-- Dumping data for table `ffffg_Event`
--


--
-- Table structure for table `ffffg_accounting`
--

CREATE TABLE `ffffg_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffffg_accounting`
--


--
-- Table structure for table `ffffg_add_class`
--

CREATE TABLE `ffffg_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 `ffffg_add_class`
--


--
-- Table structure for table `ffffg_add_field`
--

CREATE TABLE `ffffg_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 ;

--
-- Dumping data for table `ffffg_add_field`
--


--
-- Table structure for table `ffffg_add_section`
--

CREATE TABLE `ffffg_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 `ffffg_add_section`
--


--
-- Table structure for table `ffffg_add_subject`
--

CREATE TABLE `ffffg_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 ;

--
-- Dumping data for table `ffffg_add_subject`
--


--
-- Table structure for table `ffffg_address2`
--

CREATE TABLE `ffffg_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 ;

--
-- Dumping data for table `ffffg_address2`
--


--
-- Table structure for table `ffffg_advance_salary`
--

CREATE TABLE `ffffg_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffffg_advance_salary`
--


--
-- Table structure for table `ffffg_attendance_type`
--

CREATE TABLE `ffffg_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 `ffffg_attendance_type`
--

INSERT INTO `ffffg_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 `ffffg_class_and_section_list`
--

CREATE TABLE `ffffg_class_and_section_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) DEFAULT NULL,
  `class_id` varchar(50) DEFAULT NULL,
  `section_id` varchar(50) DEFAULT NULL,
  `session_id` varchar(50) DEFAULT NULL,
  `delete_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffffg_class_and_section_list`
--


--
-- Table structure for table `ffffg_class_fee`
--

CREATE TABLE `ffffg_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffffg_class_fee`
--


--
-- Table structure for table `ffffg_class_subject`
--

CREATE TABLE `ffffg_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 ;

--
-- Dumping data for table `ffffg_class_subject`
--


--
-- Table structure for table `ffffg_class_teacher_list`
--

CREATE TABLE `ffffg_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 ;

--
-- Dumping data for table `ffffg_class_teacher_list`
--


--
-- Table structure for table `ffffg_custom_event`
--

CREATE TABLE `ffffg_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffffg_custom_event`
--


--
-- Table structure for table `ffffg_custom_lecture_request`
--

CREATE TABLE `ffffg_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 ;

--
-- Dumping data for table `ffffg_custom_lecture_request`
--


--
-- Table structure for table `ffffg_custom_timetable`
--

CREATE TABLE `ffffg_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffffg_custom_timetable`
--


--
-- Table structure for table `ffffg_emi`
--

CREATE TABLE `ffffg_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 ;

--
-- Dumping data for table `ffffg_emi`
--


--
-- Table structure for table `ffffg_employee_image`
--

CREATE TABLE `ffffg_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  ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `ffffg_employee_image`
--


--
-- Table structure for table `ffffg_employee_order`
--

CREATE TABLE `ffffg_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 `ffffg_employee_order`
--

INSERT INTO `ffffg_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 `ffffg_exam`
--

CREATE TABLE `ffffg_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 ;

--
-- Dumping data for table `ffffg_exam`
--


--
-- Table structure for table `ffffg_fees`
--

CREATE TABLE `ffffg_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 ;

--
-- Dumping data for table `ffffg_fees`
--

