
--
-- Table structure for table `student_inclass_part`
--

CREATE TABLE `student_inclass_part` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ed_year` int(11) NOT NULL,
  `part` tinyint(4) NOT NULL,
  `start_date` date NOT NULL,
  `stop_date` date NOT NULL,
  `rec_date` date NOT NULL,
  `officer` varchar(13) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `student_inclass_part`
--

INSERT INTO `student_inclass_part` VALUES (5,2563,1,'2020-07-01','2020-11-23','2020-07-23','3349900295767'),(4,2562,2,'2019-11-06','2019-11-06','2019-11-06','3349900295767'),(3,2562,1,'2019-05-16','2019-10-10','2019-09-02','3349900295767'),(8,2564,1,'2022-05-17','2022-10-10','2022-07-25','3349900295767'),(7,2564,1,'2021-06-14','2021-10-10','2021-06-28','3349900295767'),(9,2566,1,'2023-05-16','2024-03-31','2023-05-22','3349900295767');

--
-- Table structure for table `student_inclass_permission`
--

CREATE TABLE `student_inclass_permission` (
  `class_now` tinyint(4) NOT NULL,
  `room_now` tinyint(4) NOT NULL,
  `person_id` varchar(13) NOT NULL,
  `student_check_year` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `student_inclass_permission`
--

INSERT INTO `student_inclass_permission` VALUES (7,0,'3349900295767',2559),(8,0,'3341500042309',2559),(7,0,'1349900777382',2562),(6,0,'3349900295716',2559),(5,0,'3341500042309',2559),(4,0,'3349900291231',2559),(3,0,'3349900291231',2559),(2,0,'3349900291231',2559),(2,0,'3349900291231',2562),(8,0,'3349900295767',2559),(9,0,'3349900291231',2559),(5,0,'1349900777382',2562),(4,0,'3349900291231',2562),(8,0,'3349900295767',2562),(6,0,'3349900291231',2562),(3,0,'3349900291231',2562),(9,0,'3349900295767',2562),(8,0,'1100800287646',2564),(5,0,'3349900291231',2563),(6,0,'3341501649584',2563),(7,0,'3349900295767',2563),(8,0,'1100800287646',2563),(9,0,'1100800287646',2563),(3,0,'3341501649584',2563),(2,0,'3341501649584',2563),(2,0,'3349900291231',2563),(3,0,'3349900291231',2563),(2,0,'3349900291231',2564),(2,0,'3349900295767',2564),(3,0,'3349900291231',2564),(3,0,'3349900295767',2564),(4,0,'1349900777382',2564),(5,0,'3341501649584',2564),(5,0,'3349900295767',2564),(6,0,'3341501649584',2564),(7,0,'3349900295767',2564),(4,0,'3349900295767',2564),(8,0,'3349900295767',2564),(9,0,'3349900291231',2564),(9,0,'3349900295767',2564),(3,0,'3349900295767',2566),(4,0,'1349900777382',2566),(5,0,'3349900295767',2566),(6,0,'1349901027085',2566),(7,0,'1349900857696',2566),(8,0,'1349900857696',2566),(9,0,'1100800287646',2566),(4,1,'1349900777382',2566);

--
-- Table structure for table `student_inclass_ref`
--

CREATE TABLE `student_inclass_ref` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ref_id` varchar(50) NOT NULL,
  `ed_day` varchar(10) NOT NULL,
  `period` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=247 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `student_inclass_ref`
--

INSERT INTO `student_inclass_ref` VALUES (1,'14670153031092204559','Monday',1),(2,'14670153401420173898','Monday',2),(3,'1467015478701557865','Monday',3),(4,'1467015516567598541','Monday',5),(216,'1467015583877526992','Monday',6),(6,'1467015635914816180','Tuesday',1),(7,'14670156711437166471','Tuesday',2),(8,'1467015707873237941','Tuesday',3),(9,'146701577358487295','Tuesday',5),(10,'1467015839650843998','Tuesday',6),(11,'1467015939621718094','Wednesday',1),(12,'14670159991107830876','Wednesday',2),(13,'14670160291227131813','Wednesday',3),(14,'14670160702134672867','Monday',1),(15,'14670161231309688464','Wednesday',5),(16,'1467016125792736083','Monday',2),(17,'14670161581096332067','Wednesday',6),(18,'1467016162958918194','Monday',3),(19,'1467016190129474430','Monday',5),(20,'1467016191318863709','Thursday',1),(21,'1467016230245129038','Monday',6),(22,'1467016240480432507','Thursday',2),(23,'14670162551173894771','Tuesday',1),(24,'14670162751236503805','Tuesday',2),(25,'1467016286388079622','Thursday',3),(26,'14670162962071519829','Monday',3),(27,'1467016314858403293','Tuesday',5),(28,'1467016325186990514','Thursday',5),(29,'14670163441345678105','Tuesday',6),(30,'1467016389524777419','Thursday',6),(31,'14670163931262220435','Wednesday',1),(32,'146701642441498429','Wednesday',2),(33,'14670164261711593379','Friday',1),(34,'14670164541940519551','Friday',2),(35,'14670164592009735854','Wednesday',3),(36,'1467016483326813875','Wednesday',5),(37,'14670164942074410063','Friday',3),(38,'14670165071241325959','Wednesday',6),(39,'14670165332079146876','Thursday',1),(40,'14670165511914985992','Friday',5),(41,'1467016560191655593','Thursday',2),(42,'146701658021710646','Thursday',3),(217,'1467016604889124766','Friday',6),(44,'1467016608396830571','Thursday',5),(45,'1467016640408640581','Thursday',6),(46,'1467016664851489731','Friday',1),(47,'1467016715683219871','Friday',2),(48,'1467016733625953576','Friday',3),(49,'14670167552032059821','Friday',5),(50,'14670167821865950548','Friday',6),(51,'14670170681677222106','Monday',1),(52,'14670171511441449384','Monday',2),(53,'1467017231245591261','Monday',3),(54,'1467017277359676955','Monday',5),(55,'14670173101423487458','Monday',6),(56,'14670173381859875903','Tuesday',1),(57,'1467017366917706966','Tuesday',2),(58,'1467017389573989574','Tuesday',3),(59,'14670174162004407263','Tuesday',5),(60,'1467017433345471738','Tuesday',6),(61,'14670174661676845046','Wednesday',1),(62,'14670175551926876491','Wednesday',2),(63,'1467017577866355124','Wednesday',3),(64,'146701760392269073','Wednesday',5),(65,'14670176271962792224','Wednesday',6),(66,'14670176691725068091','Thursday',1),(67,'14670176941269214472','Thursday',2),(68,'14670177242145207900','Thursday',3),(69,'14670177521565737444','Thursday',5),(70,'1467017794129552600','Thursday',6),(71,'14670178512047573294','Friday',1),(72,'14670178741020571415','Friday',2),(73,'14670178941567909769','Friday',3),(74,'14670180151598634880','Friday',5),(75,'14670180501283840317','Friday',6),(76,'1467094753247915778','Monday',1),(77,'14670948271545040554','Monday',2),(78,'1467094941913306698','Monday',3),(79,'146709501318573316','Monday',5),(121,'1467096256140633518','Friday',3),(120,'1467096208735401684','Friday',2),(119,'1467096159272750350','Friday',1),(118,'14670950702005054207','Tuesday',1),(123,'1467096388681300773','Monday',1),(122,'1467096286108030150','Friday',5),(117,'14670951091904389647','Tuesday',2),(125,'1467096556810879801','Monday',3),(124,'14670964842093380136','Monday',2),(116,'14670951431265832111','Tuesday',3),(129,'14670966801674488541','Tuesday',3),(126,'14670965981819688905','Monday',5),(127,'1467096619444016602','Tuesday',1),(128,'14670966452135327403','Tuesday',2),(112,'14670953491906882609','Tuesday',5),(100,'1467095389488237263','Wednesday',1),(101,'14670954621813156882','Wednesday',2),(102,'14670955291754797782','Wednesday',3),(103,'1467095577173408512','Wednesday',5),(104,'1467095664982054915','Thursday',1),(105,'1467095732474399726','Thursday',2),(106,'146709575834814548','Thursday',3),(107,'1467095788547621072','Thursday',5),(130,'1467096706195571919','Tuesday',5),(131,'14670967241174079148','Wednesday',5),(132,'1467096757264012585','Wednesday',3),(133,'14670967871727486243','Wednesday',2),(134,'1467096812694366563','Wednesday',1),(135,'14670968651414183933','Thursday',1),(136,'14670968941797166344','Thursday',2),(137,'1467096939515126645','Thursday',3),(138,'146709696286302640','Thursday',5),(139,'1467096987836716805','Friday',5),(140,'1467097012799810305','Friday',3),(141,'1467097043843402115','Friday',2),(142,'14670970692136038323','Friday',1),(224,'1467609860438359947','Friday',1),(223,'1467609860438359947','Thursday',3),(222,'1467609860438359947','Wednesday',2),(221,'1467609860438359947','Monday',1),(148,'14672077261580934090','Monday',2),(149,'14672077261580934090','Tuesday',1),(150,'14672077261580934090','Wednesday',1),(151,'14672077261580934090','Thursday',3),(152,'14672077261580934090','Friday',2),(184,'1467208108471334816','Friday',1),(183,'1467208108471334816','Thursday',2),(182,'1467208108471334816','Wednesday',3),(181,'1467208108471334816','Tuesday',2),(180,'1467208108471334816','Monday',1),(186,'1467208268886592161','Friday',3),(160,'1467208346593157957','Wednesday',2),(161,'1467208346593157957','Friday',5),(162,'1467208741172107020','Monday',5),(163,'1467208741172107020','Wednesday',5),(164,'14672094041205254203','Tuesday',3),(165,'1467209472118550219','Monday',5),(166,'1467209607629749193','Monday',6),(167,'1467209607629749193','Thursday',1),(168,'1467209721337464496','Monday',3),(174,'14672100441553960783','Tuesday',6),(175,'14672100441553960783','Wednesday',6),(176,'14672100441553960783','Thursday',6),(177,'14672100441553960783','Friday',6),(185,'1467208268886592161','Thursday',5),(187,'14672956101983141596','Monday',1),(188,'14672956101983141596','Tuesday',5),(189,'14672956101983141596','Wednesday',2),(190,'14672956101983141596','Thursday',1),(191,'14672956101983141596','Friday',3),(192,'1467295694713030765','Monday',2),(193,'1467295694713030765','Tuesday',3),(194,'1467295694713030765','Wednesday',1),(195,'1467295694713030765','Thursday',3),(196,'1467295694713030765','Friday',2),(197,'14672958411249438389','Tuesday',2),(198,'14672958411249438389','Friday',1),(199,'1467295923566776864','Monday',6),(200,'1467295923566776864','Thursday',2),(201,'1467296055745870403','Monday',3),(202,'1467296055745870403','Wednesday',6),(203,'14672961401765507859','Monday',5),(204,'14672961401765507859','Thursday',5),(205,'1467296197687752392','Wednesday',5),(206,'14672962932124787697','Tuesday',1),(207,'14672962932124787697','Wednesday',3),(208,'1467296724939325156','Friday',5),(209,'14672967741558376767','Tuesday',6),(210,'14672967741558376767','Wednesday',6),(211,'14672967741558376767','Thursday',6),(212,'14672967741558376767','Friday',6),(225,'14676100731421995801','Monday',3),(226,'14676100731421995801','Tuesday',2),(227,'14676100731421995801','Thursday',1),(228,'14676100731421995801','Friday',2),(229,'14676101922013463873','Tuesday',5),(230,'14676101922013463873','Thursday',2),(231,'14676103422084279513','Monday',2),(232,'14676103422084279513','Wednesday',1),(233,'14676104081622953491','Thursday',5),(234,'14676105011435562149','Monday',5),(235,'14676105011435562149','Tuesday',3),(236,'1467610563857462301','Friday',3),(237,'14676106332094977892','Monday',6),(238,'14676106332094977892','Wednesday',5),(239,'14676107561684563816','Tuesday',1),(240,'14676107561684563816','Wednesday',3),(241,'1467610810976378525','Friday',5),(242,'14676121272044742057','Tuesday',6),(243,'14676121272044742057','Wednesday',6),(244,'14676121272044742057','Thursday',6),(245,'14676121272044742057','Friday',6),(246,'14678996091994954647','Monday',3);

--
-- Table structure for table `student_inclass_subject`
--

CREATE TABLE `student_inclass_subject` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ed_year` int(11) NOT NULL,
  `part` tinyint(4) NOT NULL,
  `subject` varchar(100) NOT NULL,
  `std_class` tinyint(4) NOT NULL,
  `room` tinyint(4) NOT NULL,
  `ref_id` varchar(50) NOT NULL,
  `officer` varchar(13) NOT NULL,
  `rec_date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=154 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `student_inclass_subject`
--

INSERT INTO `student_inclass_subject` VALUES (1,2559,1,'คณิตศาสตร์',8,0,'14670153031092204559','3341500042309','2016-06-27'),(2,2559,1,'ภาษาอังกฤษ',8,0,'14670153401420173898','3341500042309','2016-06-27'),(3,2559,1,'ดนตรี-นาฏศิลป์',8,0,'1467015478701557865','3341500042309','2016-06-27'),(4,2559,1,'ภาษาไทย',8,0,'1467015516567598541','3341500042309','2016-06-27'),(5,2559,1,'วิทยาศาสตร์',8,0,'1467015583877526992','3341500042309','2016-06-27'),(6,2559,1,'ภาษาไทย',8,0,'1467015635914816180','3341500042309','2016-06-27'),(7,2559,1,'ทัศนศิลป์',8,0,'14670156711437166471','3341500042309','2016-06-27'),(8,2559,1,'คณิตศาสตร์',8,0,'1467015707873237941','3341500042309','2016-06-27'),(9,2559,1,'ประวัติศาสตร์',8,0,'146701577358487295','3341500042309','2016-06-27'),(10,2559,1,'ภาษาพาเพลิน',8,0,'1467015839650843998','3341500042309','2016-06-27'),(11,2559,1,'วิทยาศาสตร์',8,0,'1467015939621718094','3341500042309','2016-06-27'),(12,2559,1,'คณิตศาสตร์',8,0,'14670159991107830876','3341500042309','2016-06-27'),(13,2559,1,'ภาษาไทย',8,0,'14670160291227131813','3341500042309','2016-06-27'),(14,2559,1,'สังคมศึกษา',7,0,'14670160702134672867','3349900295767','2016-06-27'),(15,2559,1,'สังคมศึกษา',8,0,'14670161231309688464','3341500042309','2016-06-27'),(16,2559,1,'ดนตรี นาฏศิลป์',7,0,'1467016125792736083','3349900295767','2016-06-27'),(17,2559,1,'คำนวณชวนคิด',8,0,'14670161581096332067','3341500042309','2016-06-27'),(18,2559,1,'ภาษาไทย',7,0,'1467016162958918194','3349900295767','2016-06-27'),(19,2559,1,'วิทยาศาสตร์',7,0,'1467016190129474430','3349900295767','2016-06-27'),(20,2559,1,'ภาษาอังกฤษ',8,0,'1467016191318863709','3341500042309','2016-06-27'),(21,2559,1,'ภาษาอังกฤษเพิ่มเติม',7,0,'1467016230245129038','3349900295767','2016-06-27'),(22,2559,1,'ภาษาไทย',8,0,'1467016240480432507','3341500042309','2016-06-27'),(23,2559,1,'คณิตศาสต์',7,0,'14670162551173894771','3349900295767','2016-06-27'),(24,2559,1,'ภาษาไทย',7,0,'14670162751236503805','3349900295767','2016-06-27'),(25,2559,1,'สุขศึกษาและพลศึกษา',8,0,'1467016286388079622','3341500042309','2016-06-27'),(26,2559,1,'ประวัติศาสตร์',7,0,'14670162962071519829','3349900295767','2016-06-27'),(27,2559,1,'ศิลปะ',7,0,'1467016314858403293','3349900295767','2016-06-27'),(28,2559,1,'คอมพิวเตอร์',8,0,'1467016325186990514','3341500042309','2016-06-27'),(29,2559,1,'ภาษาพาเพลิน',7,0,'14670163441345678105','3349900295767','2016-06-27'),(30,2559,1,'เรียนรู้ก้าวไกลกับict',8,0,'1467016389524777419','3341500042309','2016-06-27'),(31,2559,1,'ภาาาไทย',7,0,'14670163931262220435','3349900295767','2016-06-27'),(32,2559,1,'ภาษาอังกฤษ',7,0,'146701642441498429','3349900295767','2016-06-27'),(33,2559,1,'คณิตศาสตร์',8,0,'14670164261711593379','3341500042309','2016-06-27'),(34,2559,1,'สังคมศึกษา',8,0,'14670164541940519551','3341500042309','2016-06-27'),(35,2559,1,'คณิตศาสต์',7,0,'14670164592009735854','3349900295767','2016-06-27'),(36,2559,1,'คอมพิวเตอร์',7,0,'1467016483326813875','3349900295767','2016-06-27'),(37,2559,1,'ภาษาอังกฤษเพิ่มเติม',8,0,'14670164942074410063','3341500042309','2016-06-27'),(38,2559,1,'คำนวณชวนคิด',7,0,'14670165071241325959','3349900295767','2016-06-27'),(39,2559,1,'วิทยาศาสตร์',7,0,'14670165332079146876','3349900295767','2016-06-27'),(40,2559,1,'การงานอาชีพและเทคโนโลยี',8,0,'14670165511914985992','3341500042309','2016-06-27'),(41,2559,1,'คณิตศาสต์',7,0,'1467016560191655593','3349900295767','2016-06-27'),(42,2559,1,'กอท',7,0,'146701658021710646','3349900295767','2016-06-27'),(43,2559,1,'นักวิทยาศาสตร์น้อย',8,0,'1467016604889124766','3341500042309','2016-06-27'),(44,2559,1,'สุขศึกษาพละศึกษา',7,0,'1467016608396830571','3349900295767','2016-06-27'),(45,2559,1,'ICT',7,0,'1467016640408640581','3349900295767','2016-06-27'),(46,2559,1,'ภาษาอังกฤษ',7,0,'1467016664851489731','3349900295767','2016-06-27'),(47,2559,1,'ภาษาไทย',7,0,'1467016715683219871','3349900295767','2016-06-27'),(48,2559,1,'คณิตศาสต์',7,0,'1467016733625953576','3349900295767','2016-06-27'),(49,2559,1,'สังคมศึกษา',7,0,'14670167552032059821','3349900295767','2016-06-27'),(50,2559,1,'นักวิทยาศาสตร์น้อย',7,0,'14670167821865950548','3349900295767','2016-06-27'),(51,2559,1,'วิทยาศาสตร์',5,0,'14670170681677222106','3341500042309','2016-06-27'),(52,2559,1,'ดนตรี-นาฏศิลป์',5,0,'14670171511441449384','3341500042309','2016-06-27'),(53,2559,1,'คณิตศาสตร์',5,0,'1467017231245591261','3341500042309','2016-06-27'),(54,2559,1,'ภาษาไทย',5,0,'1467017277359676955','3341500042309','2016-06-27'),(55,2559,1,'สุขศึกษาและพลศึกษา',5,0,'14670173101423487458','3341500042309','2016-06-27'),(56,2559,1,'คณิตศาสตร์',5,0,'14670173381859875903','3341500042309','2016-06-27'),(57,2559,1,'ภาษาไทย',5,0,'1467017366917706966','3341500042309','2016-06-27'),(58,2559,1,'วิทยาศาสตร์',5,0,'1467017389573989574','3341500042309','2016-06-27'),(59,2559,1,'ภาษาอังกฤษ',5,0,'14670174162004407263','3341500042309','2016-06-27'),(60,2559,1,'ภาษาพาเพลิน',5,0,'1467017433345471738','3341500042309','2016-06-27'),(61,2559,1,'ภาษาอังกฤษ',5,0,'14670174661676845046','3341500042309','2016-06-27'),(62,2559,1,'คณิตศาสตร์',5,0,'14670175551926876491','3341500042309','2016-06-27'),(63,2559,1,'ภาษาไทย',5,0,'1467017577866355124','3341500042309','2016-06-27'),(64,2559,1,'สังคมศึกษา',5,0,'146701760392269073','3341500042309','2016-06-27'),(65,2559,1,'คำนวณชวนคิด',5,0,'14670176271962792224','3341500042309','2016-06-27'),(66,2559,1,'คณิตศาสตร์',5,0,'14670176691725068091','3341500042309','2016-06-27'),(67,2559,1,'ภาษาไทย',5,0,'14670176941269214472','3341500042309','2016-06-27'),(68,2559,1,'สังคมศึกษา',5,0,'14670177242145207900','3341500042309','2016-06-27'),(69,2559,1,'การงานอาชีพและเทคโนโลยี',5,0,'14670177521565737444','3341500042309','2016-06-27'),(70,2559,1,'I C T',5,0,'1467017794129552600','3341500042309','2016-06-27'),(71,2559,1,'ภาษาไทย',5,0,'14670178512047573294','3341500042309','2016-06-27'),(72,2559,1,'ประวัติศาสตร์',5,0,'14670178741020571415','3341500042309','2016-06-27'),(73,2559,1,'คณิตศาสตร์',5,0,'14670178941567909769','3341500042309','2016-06-27'),(74,2559,1,'ทัศนศิลป์',5,0,'14670180151598634880','3341500042309','2016-06-27'),(75,2559,1,'นักวิทยาศาสตร์น้อย',5,0,'14670180501283840317','3341500042309','2016-06-27'),(76,2559,1,'กิจกรรมเคลื่นไหวเข้าจังหวะ',2,0,'1467094753247915778','3349900291231','2016-06-28'),(77,2559,1,'กิจกรรมเสริมประสบการณ์',2,0,'14670948271545040554','3349900291231','2016-06-28'),(78,2559,1,'กิจกรรมสร้างสรรค์/กิจกรรมเสรี',2,0,'1467094941913306698','3349900291231','2016-06-28'),(79,2559,1,'เกมส์การศึกษา/สรุป',2,0,'146709501318573316','3349900291231','2016-06-28'),(80,2559,1,'กิจกรรมเคลื่นไหวเข้าจังหวะ',2,0,'14670950702005054207','3349900291231','2016-06-28'),(81,2559,1,'กิจกรรมเสริมประสบการณ์',2,0,'14670951091904389647','3349900291231','2016-06-28'),(82,2559,1,'กิจกรรมสร้างสรรค์/กิจกรรมเสรี',2,0,'14670951431265832111','3349900291231','2016-06-28'),(93,2559,1,'กิจกรรมเคลื่นไหวเข้าจังหวะ',2,0,'1467096159272750350','3349900291231','2016-06-28'),(84,2559,1,'เกมส์การศึกษา/สรุป',2,0,'14670953491906882609','3349900291231','2016-06-28'),(85,2559,1,'กิจกรรมเคลื่นไหวเข้าจังหวะ',2,0,'1467095389488237263','3349900291231','2016-06-28'),(86,2559,1,'กิจกรรมเสริมประสบการณ์',2,0,'14670954621813156882','3349900291231','2016-06-28'),(87,2559,1,'กิจกรรมสร้างสรรค์/กิจกรรมเสรี',2,0,'14670955291754797782','3349900291231','2016-06-28'),(88,2559,1,'เกมส์การศึกษา/สรุป',2,0,'1467095577173408512','3349900291231','2016-06-28'),(89,2559,1,'กิจกรรมเคลื่อนไหวเข้าจังหวะ',2,0,'1467095664982054915','3349900291231','2016-06-28'),(90,2559,1,'กิจกรรมเสริมประสบการณ์',2,0,'1467095732474399726','3349900291231','2016-06-28'),(91,2559,1,'กิจกรรมสร้างสรรค์/กิจกรรมเสรี',2,0,'146709575834814548','3349900291231','2016-06-28'),(92,2559,1,'เกมส์การศึกษา/สรุป',2,0,'1467095788547621072','3349900291231','2016-06-28'),(94,2559,1,'กิจกรรมเสริมประสบการณ์',2,0,'1467096208735401684','3349900291231','2016-06-28'),(95,2559,1,'กิจกรรมสร้างสรรค์/กิจกรรมเสรี',2,0,'1467096256140633518','3349900291231','2016-06-28'),(96,2559,1,'เกมส์การศึกษา/สรุป',2,0,'1467096286108030150','3349900291231','2016-06-28'),(97,2559,1,'กิจกรรมเคลื่นไหวเข้าจังหวะ',3,0,'1467096388681300773','3349900291231','2016-06-28'),(98,2559,1,'กิจกรรมเสริมประสบการณ์',3,0,'14670964842093380136','3349900291231','2016-06-28'),(99,2559,1,'กิจกรรมสร้างสรรค์/กิจกรรมเสรี',3,0,'1467096556810879801','3349900291231','2016-06-28'),(100,2559,1,'เกมส์การศึกษา/สรุป',3,0,'14670965981819688905','3349900291231','2016-06-28'),(101,2559,1,'กิจกรรมเคลื่นไหวเข้าจังหวะ',3,0,'1467096619444016602','3349900291231','2016-06-28'),(102,2559,1,'กิจกรรมเสริมประสบการณ์',3,0,'14670966452135327403','3349900291231','2016-06-28'),(103,2559,1,'กิจกรรมสร้างสรรค์/กิจกรรมเสรี',3,0,'14670966801674488541','3349900291231','2016-06-28'),(104,2559,1,'เกมส์การศึกษา/สรุป',3,0,'1467096706195571919','3349900291231','2016-06-28'),(105,2559,1,'เกมส์การศึกษา/สรุป',3,0,'14670967241174079148','3349900291231','2016-06-28'),(106,2559,1,'กิจกรรมสร้างสรรค์/กิจกรรมเสรี',3,0,'1467096757264012585','3349900291231','2016-06-28'),(107,2559,1,'กิจกรรมเสริมประสบการณ์',3,0,'14670967871727486243','3349900291231','2016-06-28'),(108,2559,1,'กิจกรรมเคลื่นไหวเข้าจังหวะ',3,0,'1467096812694366563','3349900291231','2016-06-28'),(109,2559,1,'กิจกรรมเคลื่นไหวเข้าจังหวะ',3,0,'14670968651414183933','3349900291231','2016-06-28'),(110,2559,1,'กิจกรรมเสริมประสบการณ์',3,0,'14670968941797166344','3349900291231','2016-06-28'),(111,2559,1,'กิจกรรมสร้างสรรค์/กิจกรรมเสรี',3,0,'1467096939515126645','3349900291231','2016-06-28'),(112,2559,1,'เกมส์การศึกษา/สรุป',3,0,'146709696286302640','3349900291231','2016-06-28'),(113,2559,1,'เกมส์การศึกษา/สรุป',3,0,'1467096987836716805','3349900291231','2016-06-28'),(114,2559,1,'กิจกรรมสร้างสรรค์/กิจกรรมเสรี',3,0,'1467097012799810305','3349900291231','2016-06-28'),(115,2559,1,'กิจกรรมเสริมประสบการณ์',3,0,'1467097043843402115','3349900291231','2016-06-28'),(116,2559,1,'กิจกรรมเคลื่นไหวเข้าจังหวะ',3,0,'14670970692136038323','3349900291231','2016-06-28'),(146,2559,1,'ประวัติศาสตร์',9,0,'14676104081622953491','5340100006289','2016-07-04'),(145,2559,1,'สังคมศึกษา',9,0,'14676103422084279513','5340100006289','2016-07-04'),(144,2559,1,'วิทยาศาสตร์',9,0,'14676101922013463873','5340100006289','2016-07-04'),(143,2559,1,'คณิตศาสตร์',9,0,'14676100731421995801','5340100006289','2016-07-04'),(142,2559,1,'ภาษาไทย',9,0,'1467609860438359947','5340100006289','2016-07-04'),(122,2559,1,'ภาษาไทย',4,0,'14672077261580934090','3349900291231','2016-06-29'),(123,2559,1,'คณฺ๖สาสตร์',4,0,'1467208108471334816','3349900291231','2016-06-29'),(124,2559,1,'วิทยาศาสตร์',4,0,'1467208268886592161','3349900291231','2016-06-29'),(125,2559,1,'สังคมศึกษา',4,0,'1467208346593157957','3349900291231','2016-06-29'),(126,2559,1,'สุขศึกษาพลศึกษา',4,0,'1467208741172107020','3349900291231','2016-06-29'),(127,2559,1,'ประวัติศาสตร์',4,0,'14672094041205254203','3349900291231','2016-06-29'),(128,2559,1,'กอท.',4,0,'1467209472118550219','3349900291231','2016-06-29'),(129,2559,1,'อังกฤษ',4,0,'1467209607629749193','3349900291231','2016-06-29'),(130,2559,1,'ศิลปะ',4,0,'1467209721337464496','3349900291231','2016-06-29'),(131,2559,1,'เพิ่มเวลารู้',4,0,'14672100441553960783','3349900291231','2016-06-29'),(132,2559,1,'ภาษาไทย',6,0,'14672956101983141596','3349900295716','2016-06-30'),(133,2559,1,'คณิตศาสตร์',6,0,'1467295694713030765','3349900295716','2016-06-30'),(134,2559,1,'วิทยาศาสตร์',6,0,'14672958411249438389','3349900295716','2016-06-30'),(135,2559,1,'สังคมศึกษา',6,0,'1467295923566776864','3349900295716','2016-06-30'),(136,2559,1,'สุขศึกษาพลศึกษา',6,0,'1467296055745870403','3349900295716','2016-06-30'),(137,2559,1,'ศิลปะ',6,0,'14672961401765507859','3349900295716','2016-06-30'),(138,2559,1,'ประวัติศาสตร์',6,0,'1467296197687752392','3349900295716','2016-06-30'),(139,2559,1,'ภาษาอังกฤษ',6,0,'14672962932124787697','3349900295716','2016-06-30'),(140,2559,1,'การงานอาชีพ',6,0,'1467296724939325156','3349900295716','2016-06-30'),(141,2559,1,'เพิ่มเวลารู้',6,0,'14672967741558376767','3349900295716','2016-06-30'),(147,2559,1,'ศิลปะ',9,0,'14676105011435562149','5340100006289','2016-07-04'),(148,2559,1,'สุขศึกษาและพลศึกษา',9,0,'1467610563857462301','5340100006289','2016-07-04'),(149,2559,1,'การงานอาชีพและเทคโนโลยี',9,0,'14676106332094977892','5340100006289','2016-07-04'),(150,2559,1,'ภาษาอังกฤษ',9,0,'14676107561684563816','5340100006289','2016-07-04'),(151,2559,1,'ภาษาอังกฤษเพิ่มเติม',9,0,'1467610810976378525','5340100006289','2016-07-04'),(152,2559,1,'เพิ่มเวลารู้',9,0,'14676121272044742057','5340100006289','2016-07-04'),(153,2559,1,'ดนตรี-นาฏศิลป์',4,0,'14678996091994954647','3349900291231','2016-07-07');

--
-- Table structure for table `student_inclass_year`
--

CREATE TABLE `student_inclass_year` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_check_year` int(11) NOT NULL,
  `num_period` int(2) NOT NULL,
  `lunch_period` int(2) NOT NULL,
  `year_active` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `student_inclass_year`
--

INSERT INTO `student_inclass_year` VALUES (1,2559,6,4,0),(2,2562,6,4,0),(3,2563,6,4,0),(4,2564,6,4,0),(5,2566,6,4,1);

--
-- Table structure for table `student_main`
--

CREATE TABLE `student_main` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` varchar(7) NOT NULL,
  `student_number` int(11) DEFAULT NULL,
  `prename` varchar(20) NOT NULL,
  `name` varchar(50) NOT NULL,
  `surname` varchar(50) NOT NULL,
  `person_id` varchar(20) DEFAULT NULL,
  `sex` tinyint(4) NOT NULL DEFAULT 0,
  `pic` varchar(150) DEFAULT NULL,
  `class_now` tinyint(4) DEFAULT NULL,
  `room` tinyint(4) NOT NULL DEFAULT 0,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `out_edyear` int(11) DEFAULT NULL,
  `officer` varchar(13) NOT NULL,
  `rec_date` date NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `student_number` (`student_id`),
  KEY `class_now` (`class_now`),
  KEY `room` (`room`)
) ENGINE=MyISAM AUTO_INCREMENT=155 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `student_main`
--

INSERT INTO `student_main` VALUES (1,'832',0,'เด็กชาย','ฐิติพงศ์','ศิลาล้อม','1349901711831',1,NULL,9,0,1,2565,'1342200097242','0000-00-00'),(2,'833',0,'เด็กชาย','คชาชาต','ซิงห์','1342200154815',1,NULL,3,0,2,2561,'','0000-00-00'),(3,'834',0,'เด็กชาย','กันตพัฒน์','แก้วคำกอง','1342200154823',1,NULL,9,0,1,2565,'1342200097242','0000-00-00'),(4,'835',0,'เด็กชาย','พีรภัทร','วงษาบุตร','1349901722450',1,NULL,9,0,1,2565,'1342200097242','0000-00-00'),(137,'943',8,'เด็กชาย','กันต์นวัฒน์','ทาระศรี','1341501609748',1,'',6,0,0,NULL,'3349900295767','2025-05-23'),(6,'837',0,'เด็กชาย','พงศกร','พิลาศาสตร์','1342200155269',1,NULL,9,0,1,2565,'1342200097242','0000-00-00'),(7,'838',0,'เด็กชาย','ภาคิน','ช่วงชัย','1349901749510',1,NULL,9,0,1,2565,'1342200097242','0000-00-00'),(8,'839',0,'เด็กชาย','ธนกร','เจริญทัศน์','1209000574834',1,NULL,9,0,1,2565,'1342200097242','0000-00-00'),(9,'840',0,'เด็กชาย','จักรกฤษ','อินทร์แก้ว','1349901785613',1,NULL,9,0,1,2566,'3349900295767','0000-00-00'),(10,'841',0,'เด็กชาย','ตะวัน','สีมาทอง','1349901768085',1,NULL,3,0,2,2561,'','0000-00-00'),(11,'842',0,'เด็กชาย','วรากร','นวลสุข','1199901398026',1,NULL,9,0,1,2566,'3349900295767','0000-00-00'),(12,'843',0,'เด็กหญิง','ธนภรณ์','จันทะบาล','1349901745051',2,NULL,9,0,1,2565,'1342200097242','0000-00-00'),(13,'844',0,'เด็กหญิง','ณัฐธิดา','ปัดทุมมา','1342200156851',2,NULL,9,0,1,2566,'3349900295767','0000-00-00'),(14,'845',0,'เด็กหญิง','เพ็ญพิชชา','ภรณ์ฐิตินันท์','1342200158250',2,NULL,9,0,1,2566,'3349900295767','0000-00-00'),(15,'848',4,'เด็กหญิง','ชมพูนุช','ศิริโชติ','1349901842447',2,NULL,9,0,1,2567,'3349900295767','0000-00-00'),(16,'849',0,'เด็กชาย','ธีรชัย','ปราบจันดี','1342200157083',1,NULL,9,0,1,2566,'3349900295767','0000-00-00'),(17,'854',0,'เด็กชาย','ธีระศักดิ์','ศรีลาทิพย์','1349901775596',1,NULL,9,0,1,2566,'3349900295767','0000-00-00'),(18,'855',0,'เด็กหญิง','ฑิฆัมพร','ตั้งตระกูล','1342200158896',2,NULL,9,0,1,2566,'3349900295767','0000-00-00'),(116,'902',4,'เด็กหญิง','จิรัญญา','ตระการจันทร์','1349902137496',2,'',3,0,2,2565,'3349900295767','2021-06-29'),(115,'901',2,'เด็กชาย','ทินภัทร','พรมเภา','1349902149214',1,'modules/student_main/picture/pic_901.jpg',6,0,0,NULL,'3349900295767','2021-06-29'),(114,'900',2,'เด็กชาย','วุฒิภัทร','นำสุย','1489900853371',1,'',3,0,2,2565,'3349900295767','2021-06-29'),(113,'899',1,'เด็กชาย','ณัชพล','ภาระสันต์','1341501609152',1,'modules/student_main/picture/pic_899.jpg',6,0,0,NULL,'3349900295767','2021-06-29'),(26,'824',0,'เด็กหญิง','วัชราภรณ์','ป้องกัน','1342200149617',2,NULL,5,0,2,2561,'','0000-00-00'),(112,'907',10,'เด็กชาย','นราวิชญ์','อินทร์แก้ว','1341501588481	',1,'',4,0,2,2565,'3349900295767','2021-06-29'),(28,'795',0,'เด็กชาย','พาลินทิ์','ซิงห์','1347600016759',1,NULL,6,0,2,2561,'','0000-00-00'),(29,'796',0,'เด็กหญิง','นิภาธร','ปราบจันดี','1104301073687',2,NULL,6,0,2,2561,'','0000-00-00'),(30,'798',0,'เด็กชาย','พงศกร','สุขสุลี','1342200146821',1,NULL,9,0,1,2562,'','0000-00-00'),(31,'799',0,'เด็กชาย','จักรพรรดิ์','แก้วคำบ้ง','1240401202450',1,NULL,9,0,1,2562,'','0000-00-00'),(32,'801',0,'เด็กชาย','อภิศิต','สิมาวัน','1347600017194',1,NULL,9,0,2,2562,'','0000-00-00'),(33,'802',0,'เด็กชาย','ธนกร','เกลี้ยงเกลา','1349901519158',1,NULL,9,0,1,2562,'1342200097242','0000-00-00'),(34,'803',0,'เด็กชาย','ธนา','จิตรแสวง','1349901531671',1,NULL,9,0,1,2562,'','0000-00-00'),(35,'805',0,'เด็กชาย','ศิวะพงษ์','ทะคำวงค์','1342200147339',1,NULL,9,0,1,2562,'','0000-00-00'),(36,'807',0,'เด็กหญิง','อาริษา','ทาระทราย','1342200144992',2,NULL,9,0,1,2562,'','0000-00-00'),(37,'808',0,'เด็กหญิง','จิราพร','สะอาด','1342200145034',2,NULL,9,0,1,2562,'','0000-00-00'),(38,'809',0,'เด็กหญิง','พิมพ์ลภัส','บุญเพียร','1342200145760',2,NULL,9,0,1,2562,'','0000-00-00'),(39,'810',0,'เด็กหญิง','ปาวดี','แสงกล้า','1342200146626',2,NULL,9,0,1,2562,'','0000-00-00'),(40,'811',0,'เด็กหญิง','อรนันท์','คำภาคต','1342200147045',2,NULL,9,0,1,2562,'','0000-00-00'),(41,'812',0,'เด็กหญิง','พิมพ์ชนก','สร้อยมาลุน','1349901550047',2,NULL,9,0,1,2562,'','0000-00-00'),(42,'814',0,'เด็กหญิง','ถิรดา','เจริญทัศน์','1342200147240',2,NULL,9,0,1,2562,'','0000-00-00'),(43,'780',0,'เด็กชาย','พีระเพชร','สิมาวัน','1319800465982',1,NULL,9,0,1,2562,'','0000-00-00'),(44,'789',0,'เด็กชาย','บุญมี','เลือกนารี','1279800232717',1,NULL,9,0,1,2562,'1342200097242','0000-00-00'),(45,'790',0,'เด็กชาย','อรรถชัย','เลือกนารี','1342200141641',1,NULL,9,0,1,2562,'','0000-00-00'),(46,'791',0,'เด็กชาย','ภานุวัฒน์','วรรณรัตน์','1342200142655',1,NULL,9,0,1,2562,'','0000-00-00'),(47,'793',0,'เด็กหญิง','ธิดาวัลย์','บุสภาค','1349901495399',2,NULL,9,0,1,2562,'','0000-00-00'),(48,'794',0,'เด็กหญิง','รสริน','บุญสิงห์','1349901449516',2,NULL,9,0,1,2562,'','0000-00-00'),(49,'779',0,'เด็กหญิง','กัลยรัตน์','ใจภักดี','1349901346881',2,NULL,9,0,1,2561,'','0000-00-00'),(50,'781',0,'เด็กชาย','ธนากร','พิลาศาสตร์','1349901415166',1,NULL,9,0,1,2561,'','0000-00-00'),(51,'783',0,'เด็กชาย','ณภัทร','กุลบุญญา','1342200141756',1,NULL,9,0,1,2561,'','0000-00-00'),(52,'784',0,'เด็กหญิง','ชัญญานุช','ทาคำห่อ','1342200139417',2,NULL,9,0,1,2561,'','0000-00-00'),(53,'785',0,'เด็กหญิง','สุวนันท์','ป้องกัน','1342200141217',2,NULL,9,0,1,2561,'','0000-00-00'),(54,'786',0,'เด็กหญิง','พิมพ์ชนก','ธรรมวัติ','1342200141926',2,NULL,9,0,1,2561,'','0000-00-00'),(55,'787',0,'เด็กหญิง','ปริชญา','ทาคำห่อ','1342200142086',2,NULL,9,0,1,2561,'','0000-00-00'),(56,'830',0,'เด็กชาย','สราวุธ','เลือกนารี','1349901346245',1,NULL,9,0,1,2561,'','0000-00-00'),(57,'846',0,'เด็กชาย','ศุภกิจ','ศรชัย','1347600003550',1,NULL,9,0,1,2561,'','0000-00-00'),(58,'771',0,'เด็กชาย','อิสรา','ศรีมาบุตร','1342200135560',1,NULL,9,0,1,2561,'','0000-00-00'),(59,'772',0,'เด็กชาย','พีรพล','ทองแดง','1342200135683',1,NULL,9,0,1,2561,'','0000-00-00'),(60,'773',0,'เด็กหญิง','วรานิษฐ์','ภรณ์ฐิตินันท์','1342200135357',2,NULL,9,0,1,2561,'','0000-00-00'),(61,'774',0,'เด็กหญิง','ปัณณพร','กุลธิ','1342200136931',2,NULL,9,0,1,2561,'','0000-00-00'),(62,'775',0,'เด็กหญิง','สิริยากรณ์','บุสภาค','1341501452032',2,NULL,9,0,1,2561,'','0000-00-00'),(63,'778',0,'เด็กชาย','ปิยราช','ชาติดำรงค์','1418800018232',1,NULL,9,0,1,2561,'','0000-00-00'),(64,'826',2,'เด็กหญิง','วรัญญา','ทาคำห่อ','1349901680773',2,'',4,0,2,2561,'3349900295767','2016-06-27'),(65,'823',1,'เด็กชาย','พัฒนกูร','ธรรมวัติ','1342200151379',1,'',4,0,2,2561,'3349900295767','2016-06-27'),(66,'851',0,'เด็กหญิง','ปภาดา','ศรีชื่น','1347600044337',2,'',9,0,1,2565,'1342200097242','2016-06-27'),(67,'852',0,'เด็กชาย','ธีรชาติ','วิชามูล','1349700329769',1,'',9,0,2,2561,'3349900295767','2016-06-27'),(68,'853',0,'เด็กชาย','ธนาวุฒิ','วิชามูล','1349700351870',1,'',9,0,2,2561,'3349900295767','2016-06-27'),(69,'850',0,'เด็กชาย','กษิดิ์เดช','ณ  สมบูรณ์','1347600051732',1,'',9,0,1,2565,'1342200097242','2016-06-27'),(70,'860',1,'เด็กชาย','พงษ์ศักดิ์ดา','กันยามัย','1349901633902',1,'',9,0,1,2564,'3349900295767','2018-11-16'),(71,'861',2,'เด็กชาย','นพรัตน์','คำลี','1342200152316',1,'',9,0,1,2564,'3349900295767','2018-11-16'),(72,'873',11,'เด็กหญิง','สิริยากร','สัมมาปราบ','1342200154581',2,'',9,0,1,2565,'3349900295767','2018-11-16'),(73,'869',8,'เด็กหญิง','นิชาภา','สัมมาปราบ','1349901840541',2,'',9,0,1,2566,'3349900295767','2018-11-16'),(74,'857',1,'เด็กชาย','อนันต์สิทธิ์','แพงพรมมา','1342200159850',1,'',3,0,2,2562,'1342200097242','2018-11-16'),(75,'858',2,'เด็กชาย','พิซิตพงค์','คำมาโฮม','1349901881884',1,'',9,0,1,2567,'3349900295767','2018-11-16'),(76,'859',3,'เด็กหญิง','พิชญ์สินี','เลือกนารี','1349901858378',2,'',7,0,2,2564,'1342200097242','2018-11-16'),(77,'862',1,'เด็กหญิง','พรนภา','บัวเงิน','1342200162320',2,'',9,0,0,NULL,'3349900295767','2018-11-16'),(79,'864',3,'เด็กชาย','จิรภัทร','บุญไพโรจน์','1342200162061',1,'',9,0,0,NULL,'3349900295767','2018-11-16'),(80,'865',4,'เด็กชาย','อณน','สายแก้ว','1259300041629',1,'',9,0,0,NULL,'3349900295767','2018-11-16'),(81,'866',5,'เด็กชาย','วชิระ','ตะริวงษ์','1342200162672',1,'',9,0,0,NULL,'3349900295767','2018-11-16'),(82,'867',6,'เด็กชาย','สงกรานต์','อนุลุน','1342200162761',1,'',9,0,0,NULL,'3349900295767','2018-11-16'),(83,'868',7,'เด็กหญิง','ณัฐธิสา','ปัดทุมมา','1342200162206',2,'',9,0,0,NULL,'3349900295767','2018-11-16'),(84,'870',8,'เด็กชาย','อติเทพ','สิมาวัน','1349901964798',1,'',9,0,0,NULL,'3349900295767','2018-11-16'),(127,'924',7,'เด็กชาย','ภคพงค์','มั่นการ','1349902161168',1,'modules/student_main/picture/pic_924.jpg',6,0,0,NULL,'3349900295767','2023-09-11'),(86,'872',10,'เด็กชาย','ศุภกฤษ','ิอินทร์แก้ว','1349901982044',1,'',8,0,0,NULL,'3349900295767','2018-11-16'),(87,'883',11,'เด็กชาย','พีรพัฒน์','เจริญทัศน์','1342200157369',1,'',9,0,1,2566,'3349900295767','2019-07-23'),(88,'885',10,'เด็กหญิง','จันทกานต์','ไพรหงษ์','1342200156974',2,'',9,0,1,2566,'1342200097242','2019-07-23'),(89,'884',9,'เด็กหญิง','ศศิวิมล','คำแพงจีน','1342200156940',2,'',9,0,1,2566,'1342200097242','2019-07-23'),(90,'874',1,'เด็กชาย','พัชรพงษ์','พลทะรักษา','1349901914138',1,'',9,0,1,2567,'3349900295767','2019-07-23'),(91,'875',5,'เด็กหญิง','ชนรดี','กัญญาพันธ์','1347600076948',2,'',5,0,2,2563,'1342200097242','2019-07-23'),(92,'876',2,'เด็กหญิง','บันฑิตา','สุขสุลี','1349901987283',2,'',8,0,0,NULL,'3349900295767','2019-07-23'),(93,'877',3,'เด็กหญิง','ไอรดา','ทองไสล','1349901996622',2,'',8,0,0,NULL,'3349900295767','2019-07-23'),(94,'882',4,'เด็กชาย','เกียรติภูมิ','โจมสติ','1349902023903',1,'',8,0,0,NULL,'3349900295767','2019-07-23'),(95,'880',5,'เด็กชาย','ทวีศักดิ์','มังคะการ','1342200163881',1,'',6,0,2,2566,'3349900295767','2019-07-23'),(96,'879',6,'เด็กชาย','ณัฐพัฒน์','ธงกลาง','1349902005085',1,'',8,0,0,NULL,'3349900295767','2019-07-23'),(97,'878',7,'เด็กชาย','ก้องภพ','ตาติจันทร์','1342200163261',1,'',8,0,0,NULL,'3349900295767','2019-07-23'),(98,'881',8,'เด็กชาย','มานพ','นามปัญญา','1349902016621',1,'',8,0,0,NULL,'3349900295767','2019-07-23'),(99,'886',5,'เด็กหญิง','อัญมณี','สมบัติหลาย','1347600054812',2,'',9,0,1,2565,'1342200097242','2019-07-23'),(100,'887',10,'เด็กชาย','ปริวัตร','ธุสาวัน','1348700068760',1,'',8,0,2,2562,'1342200097242','2019-07-23'),(101,'888',13,'เด็กชาย','ชัยวัฒน์','ทาระศรี','1339600221729',1,'',9,0,1,2565,'3349900295767','2019-11-12'),(102,'898',9,'เด็กหญิง','กมลพร','วงษ์ธนโชต','1100704573170',2,'',8,0,0,NULL,'3349900295767','2020-07-30'),(103,'889',1,'เด็กชาย','นันทกร','ทองไสล','1349902089564',1,'',4,0,2,2565,'3349900295767','2020-07-30'),(104,'890',2,'เด็กชาย','นฤบดินทร์','อำไพพิษ','1342200164853',1,'',7,0,0,NULL,'3349900295767','2020-07-30'),(105,'891',3,'เด็กชาย','ณัฐภัทร','แก้วคำกอง','1100202191033',1,'',5,0,2,2566,'3349900295767','2020-07-30'),(106,'892',4,'เด็กชาย','ภานุพงศ์','พรบำรุงสุข','1342200165876',1,'',7,0,0,NULL,'1342200091643','2020-07-30'),(107,'893',5,'เด็กหญิง','กนกพร','เจริญทัศน์','1341501584044',2,'',7,0,0,NULL,'3349900295767','2020-07-30'),(108,'894',6,'เด็กหญิง','มัทนา','คำมาโฮม','1342200164721',2,'',7,0,0,NULL,'3349900295767','2020-07-30'),(109,'895',7,'เด็กหญิง','นริสรา','คำลี','1349902089025',2,'',7,0,0,NULL,'3349900295767','2020-07-30'),(110,'896',8,'เด็กหญิง','พรสุดา','ศรีพลาย','1349902086727',2,'',7,0,0,NULL,'3349900295767','2020-07-30'),(111,'897',9,'เด็กหญิง','พัชรวลัย','นันทริน','1347600115030',2,'',7,0,0,NULL,'3349900295767','2020-07-30'),(117,'903',3,'เด็กหญิง','นริศรา','สิมมาวัน','1341501596956',2,'modules/student_main/picture/pic_903.jpg',6,0,0,NULL,'3349900295767','2021-06-29'),(118,'904',4,'เด็กหญิง','ศิรินดา','จิตรแสวง','1349902152444',2,'modules/student_main/picture/pic_904.jpg',6,0,0,NULL,'3349900295767','2021-06-29'),(119,'905',7,'เด็กหญิง','รัญชิดา','เต่าทอง','1219901684923',2,'',3,0,2,2565,'3349900295767','2021-06-29'),(120,'906',5,'เด็กหญิง','อรปรียานุช','คำภาคต','1341501596506',2,'modules/student_main/picture/pic_906.jpg',6,0,0,NULL,'3349900295767','2021-06-29'),(136,'935',8,'เด็กชาย','สหชัย','คำพะทา','1349901915509',1,'',9,0,0,NULL,'3349900295767','2025-05-06'),(122,'909',4,'เด็กชาย','อดุลวิทย์','ทาคำห่อ','1347600077081',1,'',9,0,1,2567,'3349900295767','2021-06-29'),(123,'910',5,'เด็กหญิง','ศิรัญญา','คำมาโฮม','1347600080783',2,'',9,0,1,2567,'3349900295767','2021-06-29'),(126,'918',9,'เด็กหญิง','ณัฐวรา','ศรีบุรินทร์','1420501280264',2,'',7,0,0,NULL,'3349900295767','2023-03-07'),(128,'920',1,'เด็กชาย','วรรณชัย','อุดบุญ','1349902264315',1,'',4,0,0,NULL,'3349900295767','2023-09-22'),(129,'921',2,'เด็กชาย','ณัฐภูมิ','ธงกลาง','1341501631654',1,'',4,0,0,NULL,'3349900295767','2023-09-22'),(130,'922',3,'เด็กชาย','จอมพล','วงษ์ธนโชค','1100704770021',1,'',4,0,0,NULL,'3349900295767','2023-09-22'),(131,'923',4,'เด็กชาย','ปุณณภัทร์','สัมมาปราบ','1341501630755',1,'',4,0,0,NULL,'3349900295767','2023-09-22'),(132,'912',1,'เด็กหญิง','นริศรา','อำไพพิษ','1342200167119',2,'',5,0,0,NULL,'3349900295767','2023-09-22'),(133,'914',2,'เด็กชาย','ณัฐพัฒน์','ฉัตรสุวรรณ','1341501610304',1,'',5,0,0,NULL,'3349900295767','2023-09-22'),(134,'916',3,'เด็กชาย','ชุมพล','ทาดาวงค์ศา','1341501623686',1,'',5,0,0,NULL,'3349900295767','2023-09-22'),(135,'933',4,'เด็กชาย','ธนกร','ประอางค์','1341501612323',1,'',5,0,0,NULL,'3349900295767','2024-06-10'),(138,'945',9,'เด็กหญิง','เพ็ญนภา','วงค์คำ','1349200163497',2,'',7,0,0,NULL,'3349900295767','2025-05-23'),(139,'944',5,'เด็กหญิง','สุภาสินี','สัมมาปราบ','1341501642796',2,'',4,0,0,NULL,'3349900295767','2025-05-23'),(140,'936',1,'เด็กชาย','จีระวัฒน์','เจริญทัศน์','1346400011507',1,'',2,0,0,NULL,'3349900295767','2025-05-23'),(141,'937',2,'เด็กชาย','เจษฎา','ผ่องศรี','1339901572067',1,'',2,0,0,NULL,'3349900295767','2025-05-23'),(142,'938',3,'เด็กหญิง','จิรัชญา','ทาคำห่อ','1346400013267',2,'',2,0,0,NULL,'3349900295767','2025-05-23'),(143,'939',4,'เด็กหญิง','กัญญาณัฐ','สิงห์แจ่ม','1346400003253',2,'',2,0,0,NULL,'3349900295767','2025-05-23'),(144,'940',5,'เด็กหญิง','อภิรดา','ธุสาวัน','1342200169847',2,'',2,0,0,NULL,'3349900295767','2025-05-23'),(145,'941',6,'เด็กหญิง','นิขานันท์','เลขสัน','1349902339340',2,'',2,0,0,NULL,'3349900295767','2025-05-23'),(146,'942',0,'เด็กหญิง','กันยาพร','สิมาทอง','1346400006139',2,'',2,0,0,NULL,'3349900295767','2025-05-23'),(147,'925',1,'เด็กหญิง','ภัชศอร','พึ่งศุจริต','1341501644152',2,'',3,0,0,NULL,'3349900295767','2025-05-23'),(148,'926',2,'เด็กหญิง','ชุติกาญจน์','ตาติจันทร์','1342200169383',2,'',3,0,0,NULL,'3349900295767','2025-05-23'),(149,'927',3,'เด็กหญิง','เกวลี','คำมาโฮม','1348900503796',2,'',3,0,0,NULL,'3349900295767','2025-05-23'),(150,'928',4,'เด็กชาย','กวินท์ธรรศ','สายโสม','1341501657220',1,'',3,0,0,NULL,'3349900295767','2025-05-23'),(151,'929',5,'เด็กชาย','ศุภกร','เจริญทัศน์','1342200169073',1,'',3,0,0,NULL,'3349900295767','2025-05-23'),(152,'930',6,'เด็กชาย','จักรพงษ์','เจริญทัศน์','1349902326965',1,'',3,0,0,NULL,'3349900295767','2025-05-23'),(153,'931',0,'เด็กชาย','อนันดา','เจริญทัศน์','1349902326957',1,'',3,0,0,NULL,'3349900295767','2025-05-23'),(154,'932',8,'เด็กชาย','นันทิพัฒน์','ทำคำห่อ','1200901950684',1,'',3,0,0,NULL,'3349900295767','2025-05-23');

--
-- Table structure for table `student_main_class`
--

CREATE TABLE `student_main_class` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `class_code` tinyint(4) NOT NULL,
  `class_name` varchar(150) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `class_code` (`class_code`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `student_main_class`
--

INSERT INTO `student_main_class` VALUES (1,2,'อนุบาล2'),(2,3,'อนุุบาล3'),(3,4,'ประถมศึกษาปีที่1'),(4,5,'ประถมศึกษาปีที่2'),(5,6,'ประถมศึกษาปีที่3'),(6,7,'ประถมศึกษาปีที่4'),(7,8,'ประถมศึกษาปีที่5'),(8,9,'ประถมศึกษาปีที่6');

--
-- Table structure for table `student_main_classlog`
--

CREATE TABLE `student_main_classlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ed_year` int(11) NOT NULL,
  `student_id` varchar(7) NOT NULL,
  `student_number` int(11) DEFAULT NULL,
  `class_code` tinyint(4) NOT NULL,
  `room` tinyint(4) DEFAULT 0,
  `officer` varchar(13) NOT NULL,
  `rec_date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=516 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `student_main_classlog`
--

INSERT INTO `student_main_classlog` VALUES (1,2558,'840',0,3,0,'3349900295767','2016-06-27'),(2,2558,'842',0,3,0,'3349900295767','2016-06-27'),(3,2558,'844',0,3,0,'3349900295767','2016-06-27'),(4,2558,'845',0,3,0,'3349900295767','2016-06-27'),(5,2558,'848',0,3,0,'3349900295767','2016-06-27'),(6,2558,'849',0,3,0,'3349900295767','2016-06-27'),(7,2558,'854',0,3,0,'3349900295767','2016-06-27'),(8,2558,'855',0,3,0,'3349900295767','2016-06-27'),(9,2561,'771',0,9,0,'1342200097242','2018-11-16'),(10,2561,'772',0,9,0,'1342200097242','2018-11-16'),(11,2561,'773',0,9,0,'1342200097242','2018-11-16'),(12,2561,'774',0,9,0,'1342200097242','2018-11-16'),(13,2561,'775',0,9,0,'1342200097242','2018-11-16'),(14,2561,'778',0,9,0,'1342200097242','2018-11-16'),(15,2560,'779',0,8,0,'1342200097242','2018-11-16'),(16,2560,'781',0,8,0,'1342200097242','2018-11-16'),(17,2560,'783',0,8,0,'1342200097242','2018-11-16'),(18,2560,'784',0,8,0,'1342200097242','2018-11-16'),(19,2560,'785',0,8,0,'1342200097242','2018-11-16'),(20,2560,'786',0,8,0,'1342200097242','2018-11-16'),(21,2560,'787',0,8,0,'1342200097242','2018-11-16'),(22,2560,'830',0,8,0,'1342200097242','2018-11-16'),(23,2560,'846',0,8,0,'1342200097242','2018-11-16'),(24,2560,'853',0,8,0,'1342200097242','2018-11-16'),(25,2561,'779',0,9,0,'1342200097242','2018-11-16'),(26,2561,'781',0,9,0,'1342200097242','2018-11-16'),(27,2561,'783',0,9,0,'1342200097242','2018-11-16'),(28,2561,'784',0,9,0,'1342200097242','2018-11-16'),(29,2561,'785',0,9,0,'1342200097242','2018-11-16'),(30,2561,'786',0,9,0,'1342200097242','2018-11-16'),(31,2561,'787',0,9,0,'1342200097242','2018-11-16'),(32,2561,'830',0,9,0,'1342200097242','2018-11-16'),(33,2561,'846',0,9,0,'1342200097242','2018-11-16'),(34,2561,'852',0,9,0,'1342200097242','2018-11-16'),(35,2561,'853',0,9,0,'1342200097242','2018-11-16'),(36,2560,'780',0,7,0,'1342200097242','2018-11-16'),(37,2560,'789',0,7,0,'1342200097242','2018-11-16'),(38,2560,'790',0,7,0,'1342200097242','2018-11-16'),(39,2560,'791',0,7,0,'1342200097242','2018-11-16'),(40,2560,'793',0,7,0,'1342200097242','2018-11-16'),(41,2560,'794',0,7,0,'1342200097242','2018-11-16'),(42,2561,'833',0,3,0,'1342200097242','2018-11-16'),(43,2561,'824',0,5,0,'1342200097242','2018-11-16'),(44,2561,'795',0,6,0,'1342200097242','2018-11-16'),(45,2561,'796',0,6,0,'1342200097242','2018-11-16'),(46,2560,'798',0,6,0,'1342200097242','2018-11-16'),(47,2560,'799',0,6,0,'1342200097242','2018-11-16'),(48,2560,'801',0,6,0,'1342200097242','2018-11-16'),(49,2560,'802',0,6,0,'1342200097242','2018-11-16'),(50,2560,'803',0,6,0,'1342200097242','2018-11-16'),(51,2560,'805',0,6,0,'1342200097242','2018-11-16'),(52,2560,'807',0,6,0,'1342200097242','2018-11-16'),(53,2560,'808',0,6,0,'1342200097242','2018-11-16'),(54,2560,'809',0,6,0,'1342200097242','2018-11-16'),(55,2560,'810',0,6,0,'1342200097242','2018-11-16'),(56,2560,'811',0,6,0,'1342200097242','2018-11-16'),(57,2560,'812',0,6,0,'1342200097242','2018-11-16'),(58,2560,'814',0,6,0,'1342200097242','2018-11-16'),(59,2561,'841',0,3,0,'1342200097242','2018-11-16'),(60,2561,'823',1,4,0,'1342200097242','2018-11-16'),(61,2561,'826',2,4,0,'1342200097242','2018-11-16'),(62,2560,'806',0,5,0,'1342200097242','2018-11-16'),(63,2560,'813',0,5,0,'1342200097242','2018-11-16'),(64,2560,'815',0,5,0,'1342200097242','2018-11-16'),(65,2560,'816',0,5,0,'1342200097242','2018-11-16'),(66,2560,'819',0,5,0,'1342200097242','2018-11-16'),(67,2560,'821',0,5,0,'1342200097242','2018-11-16'),(68,2560,'822',0,5,0,'1342200097242','2018-11-16'),(69,2560,'847',0,5,0,'1342200097242','2018-11-16'),(70,2560,'832',0,3,0,'1342200097242','2018-11-16'),(71,2560,'834',0,3,0,'1342200097242','2018-11-16'),(72,2560,'835',0,3,0,'1342200097242','2018-11-16'),(73,2560,'836',0,3,0,'1342200097242','2018-11-16'),(74,2560,'837',0,3,0,'1342200097242','2018-11-16'),(75,2560,'838',0,3,0,'1342200097242','2018-11-16'),(76,2560,'839',0,3,0,'1342200097242','2018-11-16'),(77,2560,'843',0,3,0,'1342200097242','2018-11-16'),(78,2560,'850',0,3,0,'1342200097242','2018-11-16'),(79,2560,'851',0,3,0,'1342200097242','2018-11-16'),(80,2560,'840',0,2,0,'1342200097242','2018-11-16'),(81,2560,'842',0,2,0,'1342200097242','2018-11-16'),(82,2560,'844',0,2,0,'1342200097242','2018-11-16'),(83,2560,'845',0,2,0,'1342200097242','2018-11-16'),(84,2560,'849',0,2,0,'1342200097242','2018-11-16'),(85,2560,'854',0,2,0,'1342200097242','2018-11-16'),(86,2560,'855',0,2,0,'1342200097242','2018-11-16'),(87,2560,'848',0,2,0,'1342200097242','2018-11-16'),(88,2561,'780',0,9,0,'1342200097242','2019-05-16'),(89,2561,'789',0,9,0,'1342200097242','2019-05-16'),(90,2561,'790',0,9,0,'1342200097242','2019-05-16'),(91,2561,'791',0,9,0,'1342200097242','2019-05-16'),(92,2561,'793',0,9,0,'1342200097242','2019-05-16'),(93,2561,'794',0,9,0,'1342200097242','2019-05-16'),(94,2562,'780',0,9,0,'1342200097242','2019-05-16'),(95,2562,'789',0,9,0,'1342200097242','2019-05-16'),(96,2562,'790',0,9,0,'1342200097242','2019-05-16'),(97,2562,'791',0,9,0,'1342200097242','2019-05-16'),(98,2562,'793',0,9,0,'1342200097242','2019-05-16'),(99,2562,'794',0,9,0,'1342200097242','2019-05-16'),(100,2561,'801',0,8,0,'1342200097242','2019-05-16'),(101,2561,'802',0,8,0,'1342200097242','2019-05-16'),(102,2561,'803',0,8,0,'1342200097242','2019-05-16'),(103,2561,'805',0,8,0,'1342200097242','2019-05-16'),(104,2561,'807',0,8,0,'1342200097242','2019-05-16'),(105,2561,'808',0,8,0,'1342200097242','2019-05-16'),(106,2561,'809',0,8,0,'1342200097242','2019-05-16'),(107,2561,'810',0,8,0,'1342200097242','2019-05-16'),(108,2561,'811',0,8,0,'1342200097242','2019-05-16'),(109,2561,'812',0,8,0,'1342200097242','2019-05-16'),(110,2561,'814',0,8,0,'1342200097242','2019-05-16'),(111,2561,'799',0,8,0,'3349900295767','2019-06-10'),(112,2561,'798',0,8,0,'3349900295767','2019-06-10'),(113,2561,'806',0,7,0,'3349900295767','2019-06-10'),(114,2561,'813',0,7,0,'3349900295767','2019-06-10'),(115,2561,'815',0,7,0,'3349900295767','2019-06-10'),(116,2561,'816',0,7,0,'3349900295767','2019-06-10'),(117,2561,'819',0,7,0,'3349900295767','2019-06-10'),(118,2561,'821',0,7,0,'3349900295767','2019-06-10'),(119,2561,'822',0,7,0,'3349900295767','2019-06-10'),(120,2561,'847',0,7,0,'3349900295767','2019-06-10'),(121,2561,'840',0,4,0,'3349900295767','2019-06-10'),(122,2561,'842',0,4,0,'3349900295767','2019-06-10'),(123,2561,'844',0,4,0,'3349900295767','2019-06-10'),(124,2561,'845',0,4,0,'3349900295767','2019-06-10'),(125,2561,'849',0,4,0,'3349900295767','2019-06-10'),(126,2561,'854',0,4,0,'3349900295767','2019-06-10'),(127,2561,'855',0,4,0,'3349900295767','2019-06-10'),(128,2561,'869',8,4,0,'3349900295767','2019-06-10'),(129,2562,'801',0,9,0,'1342200097242','2019-07-23'),(130,2562,'857',1,3,0,'1342200097242','2019-07-23'),(131,2562,'887',10,8,0,'1342200097242','2019-08-20'),(132,2562,'871',9,3,0,'1342200097242','2019-11-07'),(133,2562,'888',13,6,0,'1342200097242','2019-11-13'),(134,2562,'860',1,7,0,'3349900295767','2020-07-29'),(135,2562,'861',2,7,0,'3349900295767','2020-07-29'),(136,2562,'806',0,8,0,'3349900295767','2020-07-29'),(137,2562,'813',0,8,0,'3349900295767','2020-07-29'),(138,2562,'815',0,8,0,'3349900295767','2020-07-29'),(139,2562,'816',0,8,0,'3349900295767','2020-07-29'),(140,2562,'819',0,8,0,'3349900295767','2020-07-29'),(141,2562,'821',0,8,0,'3349900295767','2020-07-29'),(142,2562,'822',0,8,0,'3349900295767','2020-07-29'),(143,2562,'847',0,8,0,'3349900295767','2020-07-29'),(144,2562,'798',0,9,0,'3349900295767','2020-07-29'),(145,2562,'799',0,9,0,'3349900295767','2020-07-29'),(146,2562,'802',0,9,0,'3349900295767','2020-07-29'),(147,2562,'803',0,9,0,'3349900295767','2020-07-29'),(148,2562,'805',0,9,0,'3349900295767','2020-07-29'),(149,2562,'807',0,9,0,'3349900295767','2020-07-29'),(150,2562,'808',0,9,0,'3349900295767','2020-07-29'),(151,2562,'809',0,9,0,'3349900295767','2020-07-29'),(152,2562,'810',0,9,0,'3349900295767','2020-07-29'),(153,2562,'811',0,9,0,'3349900295767','2020-07-29'),(154,2562,'812',0,9,0,'3349900295767','2020-07-29'),(155,2562,'814',0,9,0,'3349900295767','2020-07-29'),(156,2562,'876',2,2,0,'3349900295767','2020-07-29'),(157,2562,'877',3,2,0,'3349900295767','2020-07-29'),(158,2562,'882',4,2,0,'3349900295767','2020-07-29'),(159,2562,'880',5,2,0,'3349900295767','2020-07-29'),(160,2562,'879',6,2,0,'3349900295767','2020-07-29'),(161,2562,'878',7,2,0,'3349900295767','2020-07-29'),(162,2562,'881',8,2,0,'3349900295767','2020-07-29'),(163,2562,'872',10,2,0,'3349900295767','2020-07-29'),(164,2562,'862',1,3,0,'3349900295767','2020-07-29'),(165,2562,'863',2,3,0,'3349900295767','2020-07-29'),(166,2562,'864',3,3,0,'3349900295767','2020-07-29'),(167,2562,'865',4,3,0,'3349900295767','2020-07-29'),(168,2562,'866',5,3,0,'3349900295767','2020-07-29'),(169,2562,'867',6,3,0,'3349900295767','2020-07-29'),(170,2562,'868',7,3,0,'3349900295767','2020-07-29'),(171,2562,'870',8,3,0,'3349900295767','2020-07-29'),(172,2562,'874',1,4,0,'3349900295767','2020-07-29'),(173,2562,'858',2,4,0,'3349900295767','2020-07-29'),(174,2562,'859',3,4,0,'3349900295767','2020-07-29'),(175,2562,'848',4,4,0,'3349900295767','2020-07-29'),(176,2562,'875',5,4,0,'3349900295767','2020-07-29'),(177,2562,'840',0,5,0,'3349900295767','2020-07-29'),(178,2562,'842',0,5,0,'3349900295767','2020-07-29'),(179,2562,'844',0,5,0,'3349900295767','2020-07-29'),(180,2562,'845',0,5,0,'3349900295767','2020-07-29'),(181,2562,'849',0,5,0,'3349900295767','2020-07-29'),(182,2562,'854',0,5,0,'3349900295767','2020-07-29'),(183,2562,'855',0,5,0,'3349900295767','2020-07-29'),(184,2562,'869',8,5,0,'3349900295767','2020-07-29'),(185,2562,'884',9,5,0,'3349900295767','2020-07-29'),(186,2562,'885',10,5,0,'3349900295767','2020-07-29'),(187,2562,'883',11,5,0,'3349900295767','2020-07-29'),(188,2562,'832',0,6,0,'3349900295767','2020-07-29'),(189,2562,'834',0,6,0,'3349900295767','2020-07-29'),(190,2562,'835',0,6,0,'3349900295767','2020-07-29'),(191,2562,'836',0,6,0,'3349900295767','2020-07-29'),(192,2562,'837',0,6,0,'3349900295767','2020-07-29'),(193,2562,'838',0,6,0,'3349900295767','2020-07-29'),(194,2562,'839',0,6,0,'3349900295767','2020-07-29'),(195,2562,'843',0,6,0,'3349900295767','2020-07-29'),(196,2562,'850',0,6,0,'3349900295767','2020-07-29'),(197,2562,'851',0,6,0,'3349900295767','2020-07-29'),(198,2562,'886',5,6,0,'3349900295767','2020-07-29'),(199,2562,'873',11,6,0,'3349900295767','2020-07-29'),(200,2563,'861',2,8,0,'3349900295767','2020-07-29'),(201,2563,'860',1,8,0,'3349900295767','2020-07-29'),(202,2563,'875',5,5,0,'3349900295767','2020-07-29'),(203,2563,'898',9,3,0,'3349900295767','2020-07-30'),(204,2563,'889',1,2,0,'3349900295767','2020-07-30'),(205,2563,'890',2,2,0,'3349900295767','2020-07-30'),(206,2563,'891',3,2,0,'3349900295767','2020-07-30'),(207,2563,'892',4,2,0,'3349900295767','2020-07-30'),(208,2563,'893',5,2,0,'3349900295767','2020-07-30'),(209,2563,'894',6,2,0,'3349900295767','2020-07-30'),(210,2563,'895',7,2,0,'3349900295767','2020-07-30'),(211,2563,'896',8,2,0,'3349900295767','2020-07-30'),(212,2563,'897',9,2,0,'3349900295767','2020-07-30'),(213,2563,'876',2,3,0,'3349900295767','2021-06-29'),(214,2563,'877',3,3,0,'3349900295767','2021-06-29'),(215,2563,'882',4,3,0,'3349900295767','2021-06-29'),(216,2563,'880',5,3,0,'3349900295767','2021-06-29'),(217,2563,'879',6,3,0,'3349900295767','2021-06-29'),(218,2563,'878',7,3,0,'3349900295767','2021-06-29'),(219,2563,'881',8,3,0,'3349900295767','2021-06-29'),(220,2563,'872',10,3,0,'3349900295767','2021-06-29'),(221,2563,'862',1,4,0,'3349900295767','2021-06-29'),(222,2563,'863',2,4,0,'3349900295767','2021-06-29'),(223,2563,'864',3,4,0,'3349900295767','2021-06-29'),(224,2563,'865',4,4,0,'3349900295767','2021-06-29'),(225,2563,'866',5,4,0,'3349900295767','2021-06-29'),(226,2563,'867',6,4,0,'3349900295767','2021-06-29'),(227,2563,'868',7,4,0,'3349900295767','2021-06-29'),(228,2563,'870',8,4,0,'3349900295767','2021-06-29'),(229,2563,'874',1,5,0,'3349900295767','2021-06-29'),(230,2563,'858',2,5,0,'3349900295767','2021-06-29'),(231,2563,'859',3,5,0,'3349900295767','2021-06-29'),(232,2563,'848',4,5,0,'3349900295767','2021-06-29'),(233,2563,'840',0,6,0,'3349900295767','2021-06-29'),(234,2563,'842',0,6,0,'3349900295767','2021-06-29'),(235,2563,'844',0,6,0,'3349900295767','2021-06-29'),(236,2563,'845',0,6,0,'3349900295767','2021-06-29'),(237,2563,'849',0,6,0,'3349900295767','2021-06-29'),(238,2563,'854',0,6,0,'3349900295767','2021-06-29'),(239,2563,'855',0,6,0,'3349900295767','2021-06-29'),(240,2563,'869',8,6,0,'3349900295767','2021-06-29'),(241,2563,'884',9,6,0,'3349900295767','2021-06-29'),(242,2563,'885',10,6,0,'3349900295767','2021-06-29'),(243,2563,'883',11,6,0,'3349900295767','2021-06-29'),(244,2563,'832',0,7,0,'3349900295767','2021-06-29'),(245,2563,'834',0,7,0,'3349900295767','2021-06-29'),(246,2563,'835',0,7,0,'3349900295767','2021-06-29'),(247,2563,'836',0,7,0,'3349900295767','2021-06-29'),(248,2563,'837',0,7,0,'3349900295767','2021-06-29'),(249,2563,'838',0,7,0,'3349900295767','2021-06-29'),(250,2563,'839',0,7,0,'3349900295767','2021-06-29'),(251,2563,'843',0,7,0,'3349900295767','2021-06-29'),(252,2563,'850',0,7,0,'3349900295767','2021-06-29'),(253,2563,'851',0,7,0,'3349900295767','2021-06-29'),(254,2563,'886',5,7,0,'3349900295767','2021-06-29'),(255,2564,'844',0,7,0,'3349900295767','2021-06-29'),(256,2564,'845',0,7,0,'3349900295767','2021-06-29'),(257,2564,'842',0,7,0,'3349900295767','2021-06-29'),(258,2564,'840',0,7,0,'3349900295767','2021-06-29'),(259,2564,'849',0,7,0,'3349900295767','2021-06-29'),(260,2564,'854',0,7,0,'3349900295767','2021-06-29'),(261,2564,'855',0,7,0,'3349900295767','2021-06-29'),(262,2564,'860',1,9,0,'3349900295767','2021-06-29'),(263,2564,'861',2,9,0,'3349900295767','2021-06-29'),(265,2564,'869',8,7,0,'3349900295767','2021-06-29'),(266,2564,'888',13,8,0,'3349900295767','2021-06-29'),(267,2564,'874',1,6,0,'3349900295767','2021-06-29'),(268,2564,'862',1,5,0,'3349900295767','2021-06-29'),(269,2564,'865',4,5,0,'3349900295767','2021-06-29'),(270,2564,'866',5,5,0,'3349900295767','2021-06-29'),(271,2564,'863',2,5,0,'3349900295767','2021-06-29'),(272,2564,'867',6,5,0,'3349900295767','2021-06-29'),(273,2564,'868',7,5,0,'3349900295767','2021-06-29'),(274,2564,'864',3,5,0,'3349900295767','2021-06-29'),(275,2564,'870',8,5,0,'3349900295767','2021-06-29'),(276,2564,'858',2,6,0,'3349900295767','2021-06-29'),(277,2564,'877',3,4,0,'3349900295767','2021-06-29'),(278,2564,'882',4,4,0,'3349900295767','2021-06-29'),(279,2564,'880',5,4,0,'3349900295767','2021-06-29'),(280,2564,'879',6,4,0,'3349900295767','2021-06-29'),(281,2564,'881',8,4,0,'3349900295767','2021-06-29'),(282,2564,'878',7,4,0,'3349900295767','2021-06-29'),(283,2564,'898',9,4,0,'3349900295767','2021-06-29'),(284,2564,'872',10,4,0,'3349900295767','2021-06-29'),(285,2564,'876',2,4,0,'3349900295767','2021-06-29'),(286,2564,'859',3,7,0,'3349900295767','2021-06-29'),(287,2564,'848',4,6,0,'3349900295767','2021-06-29'),(288,2564,'889',1,3,0,'3349900295767','2021-06-29'),(289,2564,'890',2,3,0,'3349900295767','2021-06-29'),(290,2564,'891',3,3,0,'3349900295767','2021-06-29'),(291,2564,'892',4,3,0,'3349900295767','2021-06-29'),(292,2564,'893',5,3,0,'3349900295767','2021-06-29'),(293,2564,'894',6,3,0,'3349900295767','2021-06-29'),(294,2564,'895',7,3,0,'3349900295767','2021-06-29'),(295,2564,'896',8,3,0,'3349900295767','2021-06-29'),(296,2564,'897',9,3,0,'3349900295767','2021-06-29'),(297,2564,'873',11,8,0,'3349900295767','2021-06-29'),(298,2564,'907',10,3,0,'3349900295767','2021-06-29'),(299,2564,'899',1,2,0,'3349900295767','2021-06-29'),(300,2564,'900',2,2,0,'3349900295767','2021-06-29'),(301,2564,'901',3,2,0,'3349900295767','2021-06-29'),(302,2564,'902',4,2,0,'3349900295767','2021-06-29'),(303,2564,'903',5,2,0,'3349900295767','2021-06-29'),(304,2564,'904',0,2,0,'3349900295767','2021-06-29'),(305,2564,'905',7,2,0,'3349900295767','2021-06-29'),(306,2564,'906',8,2,0,'3349900295767','2021-06-29'),(307,2564,'908',9,5,0,'3349900295767','2021-06-29'),(308,2564,'909',4,6,0,'3349900295767','2021-06-29'),(309,2564,'910',5,6,0,'3349900295767','2021-06-29'),(310,2564,'884',9,7,0,'3349900295767','2022-07-25'),(311,2564,'885',10,7,0,'3349900295767','2022-07-25'),(312,2564,'883',11,7,0,'3349900295767','2022-07-25'),(313,2564,'832',0,8,0,'3349900295767','2022-07-25'),(314,2564,'834',0,8,0,'3349900295767','2022-07-25'),(315,2564,'835',0,8,0,'3349900295767','2022-07-25'),(316,2564,'836',0,8,0,'3349900295767','2022-07-25'),(317,2564,'837',0,8,0,'3349900295767','2022-07-25'),(318,2564,'838',0,8,0,'3349900295767','2022-07-25'),(319,2564,'839',0,8,0,'3349900295767','2022-07-25'),(320,2564,'843',0,8,0,'3349900295767','2022-07-25'),(321,2564,'850',0,8,0,'3349900295767','2022-07-25'),(322,2564,'851',0,8,0,'3349900295767','2022-07-25'),(323,2564,'886',5,8,0,'3349900295767','2022-07-25'),(324,2565,'902',4,3,0,'3349900295767','2022-09-16'),(325,2565,'889',1,4,0,'3349900295767','2022-09-16'),(326,2565,'905',7,3,0,'3349900295767','2022-09-16'),(337,2565,'883',11,8,0,'3349900295767','2023-05-23'),(328,2565,'907',10,4,0,'3349900295767','2022-09-17'),(329,2565,'900',2,3,0,'3349900295767','2022-10-07'),(330,2565,'904',0,3,0,'3349900295767','2022-10-07'),(331,2565,'899',1,3,0,'3349900295767','2022-10-07'),(332,2565,'903',5,3,0,'3349900295767','2022-10-07'),(333,2565,'901',3,3,0,'3349900295767','2022-10-07'),(334,2565,'906',8,3,0,'3349900295767','2022-10-07'),(335,2565,'911',6,3,0,'3349900295767','2022-10-07'),(336,2565,'918',9,4,0,'3349900295767','2023-03-07'),(338,2565,'832',0,9,0,'3349900295767','2023-05-23'),(339,2565,'834',0,9,0,'3349900295767','2023-05-23'),(340,2565,'835',0,9,0,'3349900295767','2023-05-23'),(341,2565,'837',0,9,0,'3349900295767','2023-05-23'),(342,2565,'838',0,9,0,'3349900295767','2023-05-23'),(343,2565,'839',0,9,0,'3349900295767','2023-05-23'),(344,2565,'843',0,9,0,'3349900295767','2023-05-23'),(345,2565,'850',0,9,0,'3349900295767','2023-05-23'),(346,2565,'851',0,9,0,'3349900295767','2023-05-23'),(347,2565,'886',5,9,0,'3349900295767','2023-05-23'),(348,2565,'873',11,9,0,'3349900295767','2023-05-23'),(349,2565,'888',13,9,0,'3349900295767','2023-05-23'),(350,2565,'869',8,8,0,'1100800287646','2023-05-23'),(351,2565,'884',9,8,0,'1100800287646','2023-05-23'),(352,2565,'885',10,8,0,'1100800287646','2023-05-23'),(353,2565,'890',2,4,0,'1100800287646','2023-05-23'),(354,2565,'891',3,4,0,'1100800287646','2023-05-23'),(355,2565,'892',4,4,0,'1100800287646','2023-05-23'),(356,2565,'893',5,4,0,'1100800287646','2023-05-23'),(357,2565,'894',6,4,0,'1100800287646','2023-05-23'),(358,2565,'895',7,4,0,'1100800287646','2023-05-23'),(359,2565,'896',8,4,0,'1100800287646','2023-05-23'),(360,2565,'897',9,4,0,'1100800287646','2023-05-23'),(361,2565,'876',2,5,0,'1100800287646','2023-05-23'),(362,2565,'877',3,5,0,'1100800287646','2023-05-23'),(363,2565,'882',4,5,0,'1100800287646','2023-05-23'),(364,2565,'880',5,5,0,'1100800287646','2023-05-23'),(365,2565,'879',6,5,0,'1100800287646','2023-05-23'),(366,2565,'878',7,5,0,'1100800287646','2023-05-23'),(367,2565,'881',8,5,0,'1100800287646','2023-05-23'),(368,2565,'898',9,5,0,'1100800287646','2023-05-23'),(369,2565,'872',10,5,0,'1100800287646','2023-05-23'),(370,2565,'862',1,6,0,'1100800287646','2023-05-23'),(371,2565,'863',2,6,0,'1100800287646','2023-05-23'),(372,2565,'864',3,6,0,'1100800287646','2023-05-23'),(373,2565,'865',4,6,0,'1100800287646','2023-05-23'),(374,2565,'866',5,6,0,'1100800287646','2023-05-23'),(375,2565,'867',6,6,0,'1100800287646','2023-05-23'),(376,2565,'868',7,6,0,'1100800287646','2023-05-23'),(377,2565,'870',8,6,0,'1100800287646','2023-05-23'),(378,2565,'908',9,6,0,'1100800287646','2023-05-23'),(379,2565,'874',1,7,0,'1100800287646','2023-05-23'),(380,2565,'858',2,7,0,'1100800287646','2023-05-23'),(381,2565,'848',4,7,0,'1100800287646','2023-05-23'),(382,2565,'909',4,7,0,'1100800287646','2023-05-23'),(383,2565,'910',5,7,0,'1100800287646','2023-05-23'),(384,2565,'840',0,8,0,'1100800287646','2023-05-23'),(385,2565,'842',0,8,0,'1100800287646','2023-05-23'),(386,2565,'844',0,8,0,'1100800287646','2023-05-23'),(387,2565,'845',0,8,0,'1100800287646','2023-05-23'),(388,2565,'849',0,8,0,'1100800287646','2023-05-23'),(389,2565,'854',0,8,0,'1100800287646','2023-05-23'),(390,2565,'855',0,8,0,'1100800287646','2023-05-23'),(391,2566,'891',3,5,0,'1342200091643','2023-06-13'),(392,2566,'880',5,6,0,'1342200091643','2023-06-13'),(393,2566,'883',11,9,0,'3349900295767','2023-08-25'),(394,2566,'924',7,4,1,'1349900777382','2023-09-20'),(395,2566,'904',4,4,1,'1349900777382','2023-09-20'),(396,2566,'901',2,4,1,'1349900777382','2023-09-20'),(397,2566,'903',3,4,1,'1349900777382','2023-09-20'),(398,2566,'906',5,4,1,'1349900777382','2023-09-20'),(399,2566,'911',6,4,1,'1349900777382','2023-09-20'),(400,2566,'899',1,4,1,'1349900777382','2023-09-20'),(401,2566,'920',1,2,0,'3349900295767','2023-09-22'),(402,2566,'921',2,2,0,'3349900295767','2023-09-22'),(403,2566,'922',3,2,0,'3349900295767','2023-09-22'),(404,2566,'923',4,2,0,'3349900295767','2023-09-22'),(405,2566,'912',1,3,0,'3349900295767','2023-09-22'),(406,2566,'914',2,3,0,'3349900295767','2023-09-22'),(407,2566,'916',3,3,0,'3349900295767','2023-09-22'),(408,2566,'842',0,9,0,'3349900295767','2024-03-29'),(409,2566,'844',0,9,0,'3349900295767','2024-03-29'),(410,2566,'845',0,9,0,'3349900295767','2024-03-29'),(411,2566,'849',0,9,0,'3349900295767','2024-03-29'),(412,2566,'854',0,9,0,'3349900295767','2024-03-29'),(413,2566,'855',0,9,0,'3349900295767','2024-03-29'),(414,2566,'869',8,9,0,'3349900295767','2024-03-29'),(415,2566,'884',9,9,0,'3349900295767','2024-03-29'),(416,2566,'885',10,9,0,'3349900295767','2024-03-29'),(417,2566,'840',0,9,0,'3349900295767','2024-03-29'),(418,2566,'874',1,8,0,'3349900295767','2024-05-24'),(419,2566,'858',2,8,0,'3349900295767','2024-05-24'),(420,2566,'848',4,8,0,'3349900295767','2024-05-24'),(421,2566,'909',4,8,0,'3349900295767','2024-05-24'),(422,2566,'910',5,8,0,'3349900295767','2024-05-24'),(423,2566,'876',2,6,0,'3349900295767','2024-05-24'),(424,2566,'877',3,6,0,'3349900295767','2024-05-24'),(425,2566,'882',4,6,0,'3349900295767','2024-05-24'),(426,2566,'879',6,6,0,'3349900295767','2024-05-24'),(427,2566,'878',7,6,0,'3349900295767','2024-05-24'),(428,2566,'881',8,6,0,'3349900295767','2024-05-24'),(429,2566,'898',9,6,0,'3349900295767','2024-05-24'),(430,2566,'872',10,6,0,'3349900295767','2024-05-24'),(431,2566,'862',1,7,0,'3349900295767','2024-05-24'),(432,2566,'863',2,7,0,'3349900295767','2024-05-24'),(433,2566,'864',3,7,0,'3349900295767','2024-05-24'),(434,2566,'865',4,7,0,'3349900295767','2024-05-24'),(435,2566,'866',5,7,0,'3349900295767','2024-05-24'),(436,2566,'867',6,7,0,'3349900295767','2024-05-24'),(437,2566,'868',7,7,0,'3349900295767','2024-05-24'),(438,2566,'870',8,7,0,'3349900295767','2024-05-24'),(439,2566,'890',2,5,0,'3349900295767','2024-05-24'),(440,2566,'892',4,5,0,'3349900295767','2024-05-24'),(441,2566,'893',5,5,0,'3349900295767','2024-05-24'),(442,2566,'894',6,5,0,'3349900295767','2024-05-24'),(443,2566,'895',7,5,0,'3349900295767','2024-05-24'),(444,2566,'896',8,5,0,'3349900295767','2024-05-24'),(445,2566,'897',9,5,0,'3349900295767','2024-05-24'),(446,2566,'918',9,5,0,'3349900295767','2024-05-24'),(447,2567,'933',4,4,0,'3349900295767','2024-06-10'),(448,2566,'908',9,7,0,'3349900295767','2024-06-13'),(449,2567,'935',8,8,0,'3349900295767','2025-05-06'),(450,2567,'874',1,9,0,'3349900295767','2025-05-23'),(451,2567,'858',2,9,0,'3349900295767','2025-05-23'),(452,2567,'848',4,9,0,'3349900295767','2025-05-23'),(453,2567,'909',4,9,0,'3349900295767','2025-05-23'),(454,2567,'910',5,9,0,'3349900295767','2025-05-23'),(455,2567,'862',1,8,0,'3349900295767','2025-05-23'),(456,2567,'864',3,8,0,'3349900295767','2025-05-23'),(457,2567,'865',4,8,0,'3349900295767','2025-05-23'),(458,2567,'866',5,8,0,'3349900295767','2025-05-23'),(459,2567,'867',6,8,0,'3349900295767','2025-05-23'),(460,2567,'868',7,8,0,'3349900295767','2025-05-23'),(461,2567,'870',8,8,0,'3349900295767','2025-05-23'),(462,2567,'876',2,7,0,'3349900295767','2025-05-23'),(463,2567,'877',3,7,0,'3349900295767','2025-05-23'),(464,2567,'882',4,7,0,'3349900295767','2025-05-23'),(465,2567,'879',6,7,0,'3349900295767','2025-05-23'),(466,2567,'878',7,7,0,'3349900295767','2025-05-23'),(467,2567,'881',8,7,0,'3349900295767','2025-05-23'),(468,2567,'898',9,7,0,'3349900295767','2025-05-23'),(469,2567,'872',10,7,0,'3349900295767','2025-05-23'),(470,2567,'890',2,6,0,'3349900295767','2025-05-23'),(471,2567,'892',4,6,0,'3349900295767','2025-05-23'),(472,2567,'893',5,6,0,'3349900295767','2025-05-23'),(473,2567,'894',6,6,0,'3349900295767','2025-05-23'),(474,2567,'895',7,6,0,'3349900295767','2025-05-23'),(475,2567,'896',8,6,0,'3349900295767','2025-05-23'),(476,2567,'897',9,6,0,'3349900295767','2025-05-23'),(477,2567,'918',9,6,0,'3349900295767','2025-05-23'),(478,2567,'912',1,4,0,'3349900295767','2025-05-23'),(479,2567,'914',2,4,0,'3349900295767','2025-05-23'),(480,2567,'916',3,4,0,'3349900295767','2025-05-23'),(481,2567,'920',1,2,0,'3349900295767','2025-05-23'),(482,2567,'921',2,2,0,'3349900295767','2025-05-23'),(483,2567,'922',3,2,0,'3349900295767','2025-05-23'),(484,2567,'923',4,2,0,'3349900295767','2025-05-23'),(485,2567,'899',1,5,1,'3349900295767','2025-05-23'),(486,2567,'901',2,5,1,'3349900295767','2025-05-23'),(487,2567,'903',3,5,1,'3349900295767','2025-05-23'),(488,2567,'904',4,5,1,'3349900295767','2025-05-23'),(489,2567,'906',5,5,1,'3349900295767','2025-05-23'),(490,2567,'924',7,5,1,'3349900295767','2025-05-23'),(491,2568,'943',8,6,0,'3349900295767','2025-05-23'),(492,2568,'945',9,7,0,'3349900295767','2025-05-23'),(493,2568,'944',5,4,0,'3349900295767','2025-05-23'),(494,2568,'936',1,2,0,'3349900295767','2025-05-23'),(495,2568,'937',2,2,0,'3349900295767','2025-05-23'),(496,2568,'938',3,2,0,'3349900295767','2025-05-23'),(497,2568,'939',4,2,0,'3349900295767','2025-05-23'),(498,2568,'940',5,2,0,'3349900295767','2025-05-23'),(499,2568,'941',6,2,0,'3349900295767','2025-05-23'),(500,2568,'942',0,2,0,'3349900295767','2025-05-23'),(501,2568,'925',1,3,0,'3349900295767','2025-05-23'),(502,2568,'926',2,3,0,'3349900295767','2025-05-23'),(503,2568,'927',3,3,0,'3349900295767','2025-05-23'),(504,2568,'928',4,3,0,'3349900295767','2025-05-23'),(505,2568,'929',5,3,0,'3349900295767','2025-05-23'),(506,2568,'930',6,3,0,'3349900295767','2025-05-23'),(507,2568,'931',0,3,0,'3349900295767','2025-05-23'),(508,2568,'932',8,3,0,'3349900295767','2025-05-23'),(509,2568,'899',1,6,0,'3349900295767','2025-05-23'),(510,2568,'901',2,6,0,'3349900295767','2025-05-23'),(511,2568,'903',3,6,0,'3349900295767','2025-05-23'),(512,2568,'904',4,6,0,'3349900295767','2025-05-23'),(513,2568,'906',5,6,0,'3349900295767','2025-05-23'),(514,2568,'924',7,6,0,'3349900295767','2025-05-23'),(515,2568,'892',4,7,0,'1342200091643','2025-06-11');

--
-- Table structure for table `student_main_edyear`
--

CREATE TABLE `student_main_edyear` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ed_year` int(11) NOT NULL,
  `year_active` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ed_year` (`ed_year`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `student_main_edyear`
--

INSERT INTO `student_main_edyear` VALUES (1,2561,0),(2,2562,0),(3,2563,0),(4,2564,0),(5,2565,0),(6,2566,0),(7,2567,0),(8,2568,1);

--
-- Table structure for table `student_main_expand1`
--

CREATE TABLE `student_main_expand1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `person_id` varchar(13) NOT NULL,
  `e_name` varchar(50) NOT NULL,
  `e_surname` varchar(50) NOT NULL,
  `birthday` date NOT NULL,
  `blood` varchar(2) NOT NULL,
  `race` varchar(30) NOT NULL,
  `nationlity` varchar(30) NOT NULL,
  `religion` varchar(30) NOT NULL,
  `rec_date` date NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `person_id` (`person_id`)
) ENGINE=MyISAM AUTO_INCREMENT=64 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `student_main_expand1`
--

INSERT INTO `student_main_expand1` VALUES (1,'1349901982044','Supakrit','Phuangthaisong','2014-05-29','','','','','2022-07-23'),(2,'1342200163261','-','-','2014-08-28','','','','','2022-07-23'),(3,'1349902005085','-','-','2014-09-26','','','','','2022-07-23'),(4,'1342200163881','-','-','2014-12-13','','','','','2022-07-23'),(5,'1349902023903','-','-','2015-01-01','','','','','2022-07-23'),(6,'1349902016621','-','-','2014-11-21','','','','','2022-07-23'),(7,'1349901996622','-','-','2014-08-19','','','','','2022-07-23'),(8,'1349901987283','-','-','2014-07-02','','','','','2022-07-23'),(9,'1342200162061','Jirapat','Boonpairoot','2014-01-02','','','','','2022-07-23'),(10,'1349901940201','Anun','Chaipon','2013-10-09','','','','','2022-07-23'),(11,'1342200162672','Wachira','Tariwong','2014-05-04','','','','','2022-07-23'),(12,'1259300041629','Anon','Saykaew','2014-01-19','','','','','2022-07-23'),(13,'1342200162761','Songkan','Anuloon','2014-05-16','','','','','2022-07-23'),(14,'1349901964798','Atithep','Simawan','2014-02-21','','','','','2022-07-23'),(15,'1342200162320','Phornapa','Buangoen','2014-03-02','','','','','2022-07-23'),(16,'1342200162206','Nuttisa','Patthoomma','2014-02-05','','','','','2022-07-23'),(17,'1349901881884','Pichitpong','Kammahom','2012-11-29','','','','','2022-07-23'),(18,'1349901914138','PACHARAPONG','PONTHARAKSAR','2012-05-17','','','','','2022-07-23'),(19,'1349901842447','Chomphunut','Sirichot','2012-06-01','','','','','2022-07-23'),(20,'1349901858378','Pichsinee','lueaknaree','2012-08-14','-','ไทย','ไทย','พุทธ','2020-07-30'),(21,'1349901785613','Jakkrit','in-keaw','2011-08-26','','','','','2022-07-23'),(22,'1199901398026','Warakorn','Nuansuk','2011-12-12','','','','','2022-07-23'),(23,'1342200157083','Theerachai','Parbjandee','2011-07-10','','','','','2022-07-23'),(24,'1349901775596','Threerasak','Srirathib','2011-07-09','','','','','2022-07-23'),(25,'1342200157369','-','-','2011-08-24','','','','','2022-07-23'),(26,'1342200156851','Natthida','Pattumma','2011-06-08','','','','','2022-07-23'),(27,'1342200158250','Phenphitcha','Phornthitinun','2012-01-19','','','','','2022-07-23'),(28,'1342200158896','Thikamporn','Tungtakurn','2012-05-09','','','','','2022-07-23'),(29,'1349901840541','Nichapa','Sammaparb','2012-05-22','','','','','2022-07-23'),(30,'1342200156974','Jantakan','Paihong','2011-06-28','','','','','2022-07-23'),(31,'1342200156940','-','-','2011-06-23','','','','','2022-07-23'),(32,'1349901711831','Thitipong','siralom','2010-07-23','','','','','2022-07-23'),(33,'1342200154823','Kantapat','Keawkamkong','2010-09-10','','','','','2022-07-23'),(34,'1349901722450','Phiraphat','Wongsabut','2010-09-19','','','','','2022-07-23'),(35,'1342200155145','Songdet','Thongsalai','2010-10-22','','','','','2022-07-23'),(36,'1342200155269','Phongsaton','Phirasan','2010-11-08','','','','','2022-07-23'),(37,'1209000574834','Thanakorn','Jaroenthat','2011-02-14','','','','','2022-07-23'),(38,'1349901749510','Phakin','Chuangching','2011-02-12','','','','','2022-07-23'),(39,'1347600051732','Kasidej','Na Sompoon','2011-01-28','','','','','2022-07-23'),(40,'1349901745051','Thanaporn','Janthaban','2011-01-17','','','','','2022-07-23'),(41,'1347600044337','Papada','Srichuen','2010-05-21','','','','','2022-07-23'),(42,'1342200154581','Siriyakorn','Sammaparb','2010-08-13','','','','','2022-07-23'),(43,'1347600054812','-','-','2011-05-10','','','','','2022-07-23'),(44,'1342200152316','Nopparat','Kumlee','2009-10-11','-','ไทย','ไทย','พุทธ','2020-07-30'),(45,'1349901633902','Pongsakda','Kunyamaiy','2009-06-26','-','ไทย','ไทย','พุทธ','2020-07-30'),(46,'1349901607359','SITTICHOT','SUKSULEE','2009-02-04','B','ไทย','ไทย','พุทธ','2020-07-30'),(47,'1342200148971','JIRAPON','PADNAPUN','2008-10-27','-','ไทย','ไทย','พุทธ','2020-07-30'),(48,'2342200037256','NUTTAPONG','KUMMAHOM','2009-04-03','-','ไทย','ไทย','พุทธ','2020-07-30'),(49,'1342200150593','NUTTAPON','JARENTUD','2009-04-22','-','ไทย','ไทย','พุทธ','2020-07-30'),(50,'1342200147266','ANUSSARA','KUMLEE','2008-03-30','-','ไทย','ไทย','พุทธ','2020-07-30'),(51,'1342200150526','WARANYA','KEAWKUMKONG','2009-04-09','-','ไทย','ไทย','พุทธ','2020-07-30'),(52,'1342200148921','MONNAPA','TONGDANG','2008-10-17','-','ไทย','ไทย','พุทธ','2020-07-30'),(53,'1349901593838','Phatrida','Phontharaksa','2008-11-22','-','ไทย','ไทย','พุทธ','2020-07-30'),(54,'1347600115030','Phatcharawalai','Nantarin','2015-11-23','','','','','2022-07-23'),(55,'1341501584044','Kanokphon','Jaroenthat','2015-08-27','','','','','2022-07-23'),(56,'1349902086727','Phonsuda','Sriphai','2015-12-26','','','','','2022-07-23'),(57,'1349902089564','Nanthakon','Thongsalai','2016-01-11','','','','','2022-07-23'),(58,'1349902089025','Narissara','Khamlee','2015-12-29','','','','','2022-07-23'),(59,'1342200164721','Matthana','Khammahom','2015-06-21','','','','','2022-07-23'),(60,'1342200164853','Narubordin','Umpaipit','2015-07-15','','','','','2022-07-23'),(61,'1100202191033','Nutthapat','Kaewkumkoing','2015-12-16','','','','','2022-07-23'),(62,'1100704573170','Kamonporn','Wongthanachok','2015-08-06','','','','','2022-07-23'),(63,'1339600221729','-','-','2010-06-08','','','','','2022-07-23');

--
-- Table structure for table `student_main_permission`
--

CREATE TABLE `student_main_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `person_id` varchar(13) NOT NULL,
  `p1` tinyint(4) NOT NULL,
  `officer` varchar(13) NOT NULL,
  `rec_date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `student_main_permission`
--

INSERT INTO `student_main_permission` VALUES (1,'3349900295767',1,'3349900295767','2016-06-26'),(8,'1342200091643',1,'1342200091643','2022-07-23'),(9,'1349900857696',1,'3349900295767','2023-08-25'),(10,'1349900777382',1,'3349900295767','2023-08-25'),(11,'1100800287646',1,'3349900295767','2023-08-25'),(12,'1349901027085',1,'3349900295767','2024-05-24');

--
-- Table structure for table `system_ed_year`
--

CREATE TABLE `system_ed_year` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ed_year` int(11) NOT NULL,
  `active_ed_year` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `ed_year` (`ed_year`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `system_ed_year`
--


--
-- Table structure for table `system_export_list`
--

CREATE TABLE `system_export_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data_name` varchar(50) NOT NULL,
  `thai_dataname` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `data_name` (`data_name`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `system_export_list`
--

INSERT INTO `system_export_list` VALUES (1,'person','ข้อมูลครูและบุคลากร'),(2,'student','ข้อมูลพื้นฐานนักเรียน'),(3,'onet','ผลสอบ O-NET'),(4,'plan','แผนปฏิบัติการประจำปี'),(5,'student_check','การมาเรียน'),(6,'health','สุขภาพผู้เรียน');

--
-- Table structure for table `system_export_log`
--

CREATE TABLE `system_export_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `computer_ip` varchar(25) NOT NULL,
  `requester` varchar(50) NOT NULL,
  `login_time` datetime NOT NULL,
  `data` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=152 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `system_export_log`
--

INSERT INTO `system_export_log` VALUES (1,'61.19.124.234','amssplus','2018-09-28 16:32:13','person'),(2,'61.19.124.234','amssplus','2019-08-27 11:38:51','student'),(3,'61.19.124.234','amssplus','2019-08-27 11:39:01','student'),(4,'61.19.124.234','amssplus','2019-08-27 11:39:23','student_check'),(5,'61.19.124.234','amssplus','2019-08-27 11:39:32','student_check'),(6,'61.19.124.234','amssplus','2019-08-27 11:39:34','student_check'),(7,'61.19.124.234','amssplus','2019-08-27 11:39:59','health'),(8,'61.19.124.234','amssplus','2019-08-27 11:40:06','health'),(9,'61.19.124.234','amssplus','2019-10-03 08:26:53','student_check'),(10,'61.19.124.234','amssplus','2019-10-08 13:53:31','student_check'),(11,'61.19.124.234','amssplus','2019-10-08 14:36:20','student_check'),(12,'122.155.223.9','amssplus','2020-03-30 14:45:59','student_check'),(13,'122.155.223.9','amssplus','2020-08-05 09:39:37','student'),(14,'192.168.1.6','amssplus','2021-05-29 11:02:47','student'),(15,'192.168.1.6','amssplus','2021-05-29 11:03:52','student'),(16,'192.168.1.6','amssplus','2021-05-29 11:54:27','student'),(17,'192.168.1.6','amssplus','2021-05-29 11:57:24','student'),(18,'192.168.1.6','amssplus','2021-05-29 11:58:25','student'),(19,'192.168.1.6','amssplus','2021-05-29 12:12:59','student'),(20,'192.168.1.6','amssplus','2021-05-29 12:22:10','student'),(21,'192.168.1.6','amssplus','2021-05-29 12:23:56','student'),(22,'192.168.1.6','amssplus','2021-05-29 12:44:04','student'),(23,'192.168.1.6','amssplus','2021-05-29 12:50:50','student'),(24,'192.168.1.6','amssplus','2021-05-29 12:57:25','student'),(25,'192.168.1.6','amssplus','2021-05-29 12:58:30','student'),(26,'192.168.1.6','amssplus','2021-05-29 14:27:43','student'),(27,'192.168.1.6','amssplus','2021-05-29 14:28:17','student'),(28,'192.168.1.6','amssplus','2021-05-29 14:28:45','student'),(29,'192.168.1.6','amssplus','2021-05-29 14:29:23','student'),(30,'192.168.1.6','amssplus','2021-05-29 14:31:56','student'),(31,'10.1.1.3','amssplus','2021-10-06 10:31:17','student'),(32,'10.1.1.3','amssplus','2022-02-09 06:03:00','student'),(33,'10.1.1.3','amssplus','2022-02-09 06:03:22','student'),(34,'10.1.1.3','amssplus','2022-03-16 09:02:12','student'),(35,'10.1.1.3','amssplus','2022-09-07 14:40:43','student'),(36,'10.1.1.3','amssplus','2022-09-20 05:21:50','student'),(37,'10.1.1.3','amssplus','2022-09-20 14:07:44','student'),(38,'10.1.1.3','amssplus','2022-10-07 14:16:34','student'),(39,'','amssplus','2023-01-02 14:23:40','student_check'),(40,'','amssplus','2023-01-02 17:52:54','student_check'),(41,'','amssplus','2023-01-02 17:54:30','student_check'),(42,'','amssplus','2023-01-02 17:55:04','student_check'),(43,'10.1.1.3','amssplus','2023-01-22 00:23:52','student'),(44,'127.0.0.1','amssplus','2023-02-16 09:21:26','student_check'),(45,'127.0.0.1','amssplus','2023-02-16 09:22:08','student_check'),(46,'127.0.0.1','amssplus','2023-02-16 09:33:02','student_check'),(47,'10.1.1.3','amssplus','2023-02-20 14:05:25','health'),(48,'10.1.1.3','amssplus','2023-02-20 14:05:47','plan'),(49,'10.1.1.3','amssplus','2023-02-20 14:08:06','student'),(50,'10.1.1.3','amssplus','2023-02-20 14:42:34','health'),(51,'10.1.1.3','amssplus','2023-02-20 14:42:38','health'),(52,'10.1.1.3','amssplus','2023-02-20 14:42:50','plan'),(53,'10.1.1.3','amssplus','2023-04-05 09:48:16','student_check'),(54,'10.1.1.3','amssplus','2023-04-05 22:38:09','student_check'),(55,'10.1.1.3','amssplus','2023-04-06 10:24:16','student_check'),(56,'10.1.1.3','amssplus','2023-04-06 10:25:06','student_check'),(57,'10.1.1.3','amssplus','2023-04-06 10:47:27','student_check'),(58,'10.1.1.3','amssplus','2023-04-06 13:13:41','student_check'),(59,'10.1.1.3','amssplus','2023-06-15 10:20:19','student_check'),(60,'10.1.1.3','amssplus','2023-06-15 10:57:21','student'),(61,'10.1.1.3','amssplus','2023-06-16 15:17:31','student'),(62,'10.1.1.3','amssplus','2023-07-04 11:26:09','student'),(63,'127.0.0.1','amssplus','2023-07-09 13:17:01','student_check'),(64,'127.0.0.1','amssplus','2023-07-09 13:18:59','student_check'),(65,'127.0.0.1','amssplus','2023-07-09 13:19:46','student_check'),(66,'127.0.0.1','amssplus','2023-07-09 13:20:13','student_check'),(67,'127.0.0.1','amssplus','2023-07-09 13:20:45','student_check'),(68,'127.0.0.1','amssplus','2023-07-09 13:21:39','student_check'),(69,'127.0.0.1','amssplus','2023-07-09 13:21:43','student_check'),(70,'127.0.0.1','amssplus','2023-07-09 13:27:58','student_check'),(71,'127.0.0.1','amssplus','2023-07-09 13:29:13','student_check'),(72,'127.0.0.1','amssplus','2023-07-09 13:31:14','student_check'),(73,'127.0.0.1','amssplus','2023-07-09 13:36:11','student_check'),(74,'127.0.0.1','amssplus','2023-07-09 13:37:17','student_check'),(75,'127.0.0.1','amssplus','2023-07-09 13:37:39','student_check'),(76,'127.0.0.1','amssplus','2023-07-09 13:39:11','student_check'),(77,'127.0.0.1','amssplus','2023-07-09 13:41:18','student_check'),(78,'127.0.0.1','amssplus','2023-07-09 13:42:39','student_check'),(79,'127.0.0.1','amssplus','2023-07-09 13:43:38','student_check'),(80,'127.0.0.1','amssplus','2023-07-09 13:47:33','student_check'),(81,'127.0.0.1','amssplus','2023-07-09 13:59:30','student_check'),(82,'127.0.0.1','amssplus','2023-07-09 14:08:13','student_check'),(83,'127.0.0.1','amssplus','2023-07-09 14:17:26','student_check'),(84,'127.0.0.1','amssplus','2023-07-11 07:57:56','student_check'),(85,'127.0.0.1','amssplus','2023-07-11 08:00:00','student_check'),(86,'127.0.0.1','amssplus','2023-07-11 08:13:00','student_check'),(87,'127.0.0.1','amssplus','2023-07-11 08:13:51','student_check'),(88,'127.0.0.1','amssplus','2023-07-11 08:14:42','student_check'),(89,'127.0.0.1','amssplus','2023-07-26 13:58:49','student_check'),(90,'127.0.0.1','amssplus','2023-07-26 14:00:31','student_check'),(91,'127.0.0.1','amssplus','2023-07-26 14:02:05','student_check'),(92,'127.0.0.1','amssplus','2023-07-26 14:52:47','student_check'),(93,'127.0.0.1','amssplus','2023-07-26 14:58:23','student_check'),(94,'127.0.0.1','amssplus','2023-07-26 15:09:05','student_check'),(95,'127.0.0.1','amssplus','2023-07-26 15:10:59','student_check'),(96,'127.0.0.1','amssplus','2023-07-26 15:11:58','student_check'),(97,'127.0.0.1','amssplus','2023-07-26 15:18:35','student_check'),(98,'127.0.0.1','amssplus','2023-07-26 15:22:30','student_check'),(99,'127.0.0.1','amssplus','2023-07-26 15:27:21','student_check'),(100,'127.0.0.1','amssplus','2023-07-26 15:31:01','student_check'),(101,'127.0.0.1','amssplus','2023-07-26 15:32:09','student_check'),(102,'127.0.0.1','amssplus','2023-07-26 15:33:05','student_check'),(103,'127.0.0.1','amssplus','2023-07-26 15:45:42','student_check'),(104,'127.0.0.1','amssplus','2023-07-26 15:48:56','student_check'),(105,'127.0.0.1','amssplus','2023-07-26 15:50:53','student_check'),(106,'127.0.0.1','amssplus','2023-07-26 15:52:40','student_check'),(107,'127.0.0.1','amssplus','2023-07-26 15:57:12','student_check'),(108,'127.0.0.1','amssplus','2023-07-26 17:13:51','student_check'),(109,'127.0.0.1','amssplus','2023-07-26 17:19:40','student_check'),(110,'127.0.0.1','amssplus','2023-07-26 17:26:32','student_check'),(111,'127.0.0.1','amssplus','2023-07-26 17:28:07','student_check'),(112,'127.0.0.1','amssplus','2023-07-26 17:42:09','student_check'),(113,'10.1.1.3','amssplus','2023-08-24 09:05:27','student_check'),(114,'10.1.1.3','amssplus','2023-08-31 09:02:45','student_check'),(115,'10.1.1.3','amssplus','2023-08-31 09:03:18','student_check'),(116,'10.1.1.3','amssplus','2023-08-31 09:03:39','student_check'),(117,'10.1.1.3','amssplus','2023-09-15 20:09:21','student'),(118,'','amssplus','2023-10-25 14:28:42','student_check'),(119,'','amssplus','2023-10-25 14:28:46','student_check'),(120,'','amssplus','2023-10-25 14:28:48','student_check'),(121,'10.255.199.107','amssplus','2023-11-29 08:55:48','student_check'),(122,'10.255.199.107','amssplus','2023-12-15 12:15:49','student_check'),(123,'10.255.199.107','amssplus','2024-01-25 03:50:22','student_check'),(124,'10.255.199.107','amssplus','2024-06-10 11:59:24','student'),(125,'10.255.199.107','amssplus','2024-06-10 12:33:11','student'),(126,'10.255.199.107','amssplus','2024-06-14 10:46:03','student'),(127,'10.255.199.107','amssplus','2024-06-14 10:52:05','student'),(128,'10.255.199.107','amssplus','2024-06-17 04:37:32','person'),(129,'10.255.199.107','amssplus','2024-06-17 04:39:47','person'),(130,'10.255.199.107','amssplus','2024-06-20 04:51:34','student_check'),(131,'10.255.199.107','amssplus','2025-03-11 07:57:42','student_check'),(132,'10.255.199.107','amssplus','2025-03-11 07:58:04','student_check'),(133,'10.255.199.107','amssplus','2025-03-28 01:48:38','student_check'),(134,'10.255.199.107','amssplus','2025-05-29 08:10:42','person'),(135,'10.255.199.107','amssplus','2025-05-29 08:11:30','person'),(136,'10.255.199.107','amssplus','2025-06-08 04:35:52','student'),(137,'10.255.199.107','amssplus','2025-07-30 08:33:27','student_check'),(138,'10.255.199.107','amssplus','2025-08-01 22:22:45','student_check'),(139,'10.255.199.107','amssplus','2025-08-01 22:22:49','student_check'),(140,'10.255.199.107','amssplus','2025-08-14 04:22:05','person'),(141,'10.255.199.107','amssplus','2025-08-14 04:23:15','person'),(142,'10.255.199.107','amssplus','2025-08-25 03:03:49','student'),(143,'10.255.199.107','amssplus','2025-08-29 02:40:17','student_check'),(144,'10.255.199.107','amssplus','2025-09-13 05:43:36','student_check'),(145,'10.255.199.107','amssplus','2025-09-13 05:54:44','student_check'),(146,'10.255.199.107','amssplus','2025-10-22 07:01:54','student_check'),(147,'10.255.199.107','amssplus','2025-10-22 07:01:54','student_check'),(148,'10.255.199.107','amssplus','2025-10-22 07:01:54','student_check'),(149,'10.255.199.107','amssplus','2025-10-22 07:54:03','student_check'),(150,'10.255.199.107','amssplus','2025-10-22 07:54:03','student_check'),(151,'10.255.199.107','amssplus','2025-10-22 07:54:03','student_check');

--
-- Table structure for table `system_export_permission`
--

CREATE TABLE `system_export_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `requester` varchar(50) NOT NULL,
  `data_name` varchar(50) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `system_export_permission`
--

INSERT INTO `system_export_permission` VALUES (1,'amssplus','plan',1),(2,'amssplus','onet',1),(3,'amssplus','student',1),(4,'amssplus','person',1),(5,'amssplus','student_check',1),(6,'amssplus','health',1);

--
-- Table structure for table `system_module`
--

CREATE TABLE `system_module` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `module` varchar(50) NOT NULL,
  `module_desc` varchar(100) NOT NULL,
  `workgroup` tinyint(4) DEFAULT NULL,
  `module_active` tinyint(4) DEFAULT NULL,
  `module_order` int(11) NOT NULL,
  `web_link` tinyint(4) DEFAULT NULL,
  `url` varchar(150) DEFAULT NULL,
  `where_work` tinyint(4) NOT NULL DEFAULT 0,
  `menu_pic` varchar(25) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=118 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `system_module`
--

INSERT INTO `system_module` VALUES (1,'budget','การเงินและบัญชี',2,1,27,NULL,NULL,0,'fab fa-btc'),(32,'person','ข้อมูลพื้นฐานครูและบุคลากร',3,1,31,0,'',0,'fa fa-user-circle'),(36,'standard','มาตรฐานการศึกษา',1,1,23,NULL,NULL,0,''),(49,'health','ตรวจสุขภาพนักเรียน',1,1,5,NULL,NULL,1,''),(50,'student_check','การมาเรียน',1,1,1,NULL,NULL,0,'fa fa-child'),(70,'work','﻿การปฏิบัติราชการ',4,1,49,NULL,NULL,0,''),(48,'savings','ออมทรัพย์นักเรียน',1,1,3,NULL,NULL,1,'fab fa-btc'),(45,'student_main','ข้อมูลพื้นฐานนักเรียน',1,1,7,NULL,NULL,0,'fa fa-child'),(47,'plan','การวางแผน',2,1,25,NULL,NULL,0,''),(73,'la','﻿การลา',4,1,47,NULL,NULL,0,''),(80,'mail','ไปรษณีย์_โรงเรียน',4,1,38,0,'',0,'fa fa-envelope'),(75,'meeting','﻿จองห้องประชุม',4,1,51,NULL,NULL,0,''),(76,'permission','﻿ขออนุญาตไปราชการ',4,1,45,NULL,NULL,0,''),(81,'achievement','﻿ผลสัมฤทธิ์ทางการเรียน',1,1,21,NULL,NULL,0,'fa fa-graduation-cap'),(83,'cabinet','﻿ตู้เอกสาร',4,1,53,NULL,NULL,0,''),(99,'bookregister','﻿ทะเบียนหนังสือราชการ',4,1,35,0,'',0,'fa fa-book'),(104,'bets','ทดสอบการศึกษา_โรงเรียน',1,1,9,0,'',1,'fa fa-graduation-cap'),(103,'student_inclass','﻿การเข้าชั้นเรียน',1,1,19,0,'',0,'fa fa-child'),(105,'delegate','﻿การรักษาราชการแทน',3,1,33,0,'',0,''),(106,'affair','﻿ภารกิจผู้อำนวยการ',4,1,43,0,'',0,''),(107,'amss_bets','﻿ทดสอบการศึกษา_สพท.',1,1,11,0,'',1,'fa fa-graduation-cap'),(108,'amss_budget','﻿การบริหารงบประมาณ_สพท.',2,1,29,0,'',0,'fab fa-btc'),(109,'amss_mail','﻿ไปรษณีย์_สพท.',4,1,39,0,'',0,'fa fa-envelope'),(110,'amss_opportunity','﻿สิทธิและโอกาสทางการศึกษา',1,1,15,0,'',0,'fa fa-child'),(111,'amss_spacial_student','﻿นักเรียนพิเศษ',1,1,17,0,'',0,'fa fa-child'),(112,'amss_supervision','﻿นิเทศ ติดตาม ประเมินผล',1,1,13,0,'',0,'fa fa-graduation-cap'),(113,'book','﻿รับส่งหนังสือราชการ',4,1,37,0,'',0,'fa fa-book'),(114,'warroom','﻿วิเคราะห์สภาพการณ์',1,1,0,0,'',0,'fa fa-filter'),(115,'questionnaire','﻿แบบสอบถาม',4,1,0,0,'',0,''),(116,'idplan','﻿ข้อมูลครูและบุคลากร(ส่วนเพิ่ม)',3,1,0,0,'',0,''),(117,'amss_safety','สถานศึกษาปลอดภัย',1,1,0,0,'',0,'');

--
-- Table structure for table `system_module_admin`
--

CREATE TABLE `system_module_admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `person_id` varchar(13) NOT NULL,
  `module` varchar(30) NOT NULL,
  `officer` varchar(13) NOT NULL,
  `rec_date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=116 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `system_module_admin`
--

INSERT INTO `system_module_admin` VALUES (72,'1100800287646','budget','7777','2020-10-03'),(2,'3349900295767','achievement','7777','2016-06-26'),(3,'3349900295767','bets','7777','2016-06-26'),(4,'3349900295767','bookregister','7777','2016-06-26'),(5,'3349900295767','budget','7777','2016-06-26'),(6,'3349900295767','cabinet','7777','2016-06-26'),(7,'3349900295767','delegate','7777','2016-06-26'),(8,'3349900295767','health','7777','2016-06-26'),(9,'3349900295767','la','7777','2016-06-26'),(10,'3349900295767','mail','7777','2016-06-26'),(11,'3349900295767','meeting','7777','2016-06-26'),(12,'3349900295767','permission','7777','2016-06-26'),(13,'3349900295767','person','7777','2016-06-26'),(14,'3349900295767','plan','7777','2016-06-26'),(15,'3349900295767','savings','7777','2016-06-26'),(16,'3349900295767','standard','7777','2016-06-26'),(17,'3349900295767','student_check','7777','2016-06-26'),(18,'3349900295767','student_inclass','7777','2016-06-26'),(19,'1100800287646','student_main','7777','2020-06-29'),(20,'3349900295767','work','7777','2016-06-26'),(76,'3341501649584','plan','7777','2020-10-03'),(23,'3349900291231','budget','3341500254349','2016-07-24'),(24,'3349900291231','plan','3349900295716','2016-07-24'),(78,'1349900777382','student_check','3349900295767','2021-06-23'),(26,'1100800287646','plan','7777','2020-06-29'),(74,'1342200091643','budget','7777','2020-10-03'),(75,'1349900777382','plan','7777','2020-10-03'),(35,'1100800287646','work','7777','2020-06-29'),(30,'1100800287646','student_check','7777','2020-06-29'),(31,'1100800287646','achievement','7777','2020-06-29'),(32,'1100800287646','bets','7777','2020-06-29'),(34,'1100800287646','person','7777','2020-06-29'),(51,'3341501649584','health','7777','2020-07-01'),(36,'1100800287646','permission','7777','2020-06-29'),(37,'1100800287646','savings','7777','2020-06-29'),(38,'1100800287646','health','7777','2020-06-29'),(77,'3349900295767','questionnaire','3349900295767','2021-06-23'),(40,'1100800287646','la','7777','2020-06-29'),(41,'1100800287646','book','7777','2020-06-29'),(65,'1342200091643','mail','3349900295767','2020-07-02'),(66,'1342200091643','meeting','3349900295767','2020-07-02'),(67,'1342200091643','permission','3349900295767','2020-07-02'),(68,'1342200091643','amss_mail','3349900295767','2020-07-02'),(73,'1342200091643','plan','7777','2020-10-03'),(48,'1100800287646','amss_bets','7777','2020-06-29'),(70,'1349900777382','budget','7777','2020-10-03'),(71,'3341501649584','budget','7777','2020-10-03'),(52,'3341501649584','book','7777','2020-07-01'),(53,'3349900295767','book','7777','2020-07-01'),(54,'3341501649584','student_check','7777','2020-07-01'),(55,'1342200091643','amss_bets','7777','2020-07-02'),(56,'1342200091643','amss_opportunity','7777','2020-07-02'),(57,'1342200091643','amss_supervision','7777','2020-07-02'),(58,'1342200091643','book','7777','2020-07-02'),(59,'1342200091643','bookregister','7777','2020-07-02'),(60,'1342200091643','health','7777','2020-07-02'),(61,'1342200091643','savings','7777','2020-07-02'),(62,'1342200091643','student_check','7777','2020-07-02'),(63,'1342200091643','student_inclass','7777','2020-07-02'),(64,'1342200091643','student_main','7777','2020-07-02'),(79,'1349900777382','student_inclass','3349900295767','2021-06-23'),(80,'1349900777382','savings','3349900295767','2021-06-23'),(81,'1349900857696','amss_bets','3349900295767','2022-05-10'),(82,'1349900857696','amss_budget','3349900295767','2022-05-10'),(83,'1349900857696','amss_mail','3349900295767','2022-05-10'),(84,'1349900857696','amss_opportunity','3349900295767','2022-05-10'),(85,'1349900857696','amss_supervision','3349900295767','2022-05-10'),(86,'1349900857696','bets','3349900295767','2022-05-10'),(87,'1349900857696','book','3349900295767','2022-05-10'),(88,'1349900857696','bookregister','3349900295767','2022-05-10'),(89,'1349900857696','budget','3349900295767','2022-05-10'),(90,'1349900857696','health','3349900295767','2022-05-10'),(91,'1349900857696','la','3349900295767','2022-05-10'),(92,'1349900857696','savings','3349900295767','2022-05-10'),(93,'1349900857696','student_main','3349900295767','2022-05-10'),(94,'1349900857696','person','3349900295767','2022-05-10'),(95,'1349900857696','work','3349900295767','2022-05-10'),(96,'1349900857696','standard','3349900295767','2022-05-10'),(97,'3349900295767','student_main','3349900295767','2023-05-23'),(98,'1349901027085','amss_bets','3349900295767','2023-12-08'),(99,'1349901027085','amss_opportunity','3349900295767','2023-12-08'),(100,'1349901027085','student_inclass','3349900295767','2023-12-08'),(101,'3340900576849','delegate','3349900295767','2023-12-08'),(102,'1349901027085','bookregister','3349900295767','2023-12-08'),(103,'1349901027085','book','3349900295767','2023-12-08'),(104,'1349901027085','bets','3349900295767','2023-12-08'),(105,'1349901027085','amss_supervision','3349900295767','2023-12-08'),(106,'1349901027085','amss_mail','3349900295767','2023-12-08'),(107,'1349901027085','budget','3349900295767','2023-12-08'),(108,'1349901027085','work','3349900295767','2023-12-08'),(109,'1349901027085','health','3349900295767','2023-12-08'),(110,'1349901027085','standard','3349900295767','2023-12-08'),(111,'1349901027085','student_main','3349900295767','2023-12-08'),(112,'1349901027085','permission','3349900295767','2023-12-08'),(113,'1349901027085','person','3349900295767','2023-12-08'),(114,'1349901027085','achievement','3349900295767','2023-12-08'),(115,'1349901027085','amss_budget','3349900295767','2023-12-08');

--
-- Table structure for table `system_school_name`
--

CREATE TABLE `system_school_name` (
  `id` tinyint(4) NOT NULL,
  `school_name` varchar(200) NOT NULL,
  `school_type` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `system_school_name`
--

INSERT INTO `system_school_name` VALUES (1,'โรงเรียนบ้านหนองสองห้อง(อ.สำโรง)',0);

--
-- Table structure for table `system_sync_code`
--

CREATE TABLE `system_sync_code` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `office_code` varchar(10) NOT NULL,
  `system_name` varchar(50) NOT NULL,
  `sync_code` varchar(50) NOT NULL,
  `amssplus_url` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `system_name` (`system_name`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `system_sync_code`
--

INSERT INTO `system_sync_code` VALUES (3,'34040107','amssplus','34040107','http://10.255.199.107/amssplus');

--
-- Table structure for table `system_version`
--

CREATE TABLE `system_version` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `smss_version` varchar(100) NOT NULL,
  `status1` int(11) DEFAULT NULL,
  `status2` int(11) DEFAULT NULL,
  `status3` int(11) DEFAULT NULL,
  `status4` int(11) DEFAULT NULL,
  `status5` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `system_version`
--

INSERT INTO `system_version` VALUES (1,'6.4',1,0,0,0,0);

--
-- Table structure for table `system_workgroup`
--

CREATE TABLE `system_workgroup` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `workgroup` tinyint(4) NOT NULL,
  `workgroup_desc` varchar(50) NOT NULL,
  `workgroup_order` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `workgroup` (`workgroup`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `system_workgroup`
--

INSERT INTO `system_workgroup` VALUES (1,1,'บริหารวิชาการ',2),(2,2,'บริหารงบประมาณ',3),(3,3,'บริหารงานบุคคล',4),(4,4,'บริหารทั่วไป',8);

--
-- Table structure for table `work_main`
--

CREATE TABLE `work_main` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `work_date` date NOT NULL,
  `person_id` varchar(13) NOT NULL,
  `work` tinyint(4) NOT NULL DEFAULT 0,
  `comment` varchar(150) DEFAULT NULL,
  `rec_date` datetime NOT NULL,
  `officer` varchar(13) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `work_date` (`work_date`),
  KEY `person_id` (`person_id`)
) ENGINE=MyISAM AUTO_INCREMENT=346 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `work_main`
--

INSERT INTO `work_main` VALUES (1,'2016-06-29','3341500042309',1,NULL,'2016-06-29 08:17:35','3349900295767'),(2,'2016-06-28','3341500042309',1,NULL,'2016-06-29 08:17:55','3349900295767'),(3,'2016-06-27','3341500042309',1,NULL,'2016-06-29 08:18:06','3349900295767'),(4,'2016-06-29','3349900295767',1,NULL,'2016-06-29 08:17:35','3349900295767'),(5,'2016-06-28','3349900295767',1,NULL,'2016-06-29 08:17:55','3349900295767'),(6,'2016-06-27','3349900295767',1,NULL,'2016-06-29 08:18:06','3349900295767'),(7,'2016-06-30','3349900295767',1,NULL,'2016-06-30 13:34:43','3349900295767'),(8,'2016-07-01','3341500254349',2,NULL,'2016-07-01 10:41:50','5340100006289'),(9,'2016-07-01','3341500042309',1,NULL,'2016-07-01 10:41:50','5340100006289'),(10,'2016-07-01','5340100006289',1,NULL,'2016-07-01 10:41:50','5340100006289'),(11,'2016-07-01','3349900291231',1,NULL,'2016-07-01 10:41:50','5340100006289'),(12,'2016-07-01','3349900295716',1,NULL,'2016-07-01 10:41:50','5340100006289'),(13,'2016-07-01','3341500514421',1,NULL,'2016-07-01 10:41:50','5340100006289'),(14,'2016-07-01','3349900295767',2,NULL,'2016-07-01 10:41:50','5340100006289'),(15,'2016-07-01','3100400126650',1,NULL,'2016-07-01 10:41:50','5340100006289'),(16,'2016-07-05','3349900295767',1,NULL,'2016-07-08 14:22:51','3349900295716'),(17,'2016-07-06','3341500042309',1,NULL,'2016-07-08 14:22:25','3349900295716'),(18,'2016-07-07','3349900295767',1,NULL,'2016-07-08 14:22:10','3349900295716'),(19,'2016-07-06','3349900295767',1,NULL,'2016-07-08 14:22:25','3349900295716'),(20,'2016-07-08','3349900295716',1,NULL,'2016-07-08 14:17:42','3341500042309'),(21,'2016-07-08','3341500042309',1,NULL,'2016-07-08 14:17:42','3341500042309'),(22,'2016-07-07','3341500042309',1,NULL,'2016-07-08 14:22:10','3349900295716'),(23,'2016-07-05','3341500042309',1,NULL,'2016-07-08 14:22:51','3349900295716'),(24,'2016-07-04','3341500042309',1,NULL,'2016-07-08 14:23:04','3349900295716'),(25,'2016-07-07','3349900295716',1,NULL,'2016-07-08 14:22:10','3349900295716'),(26,'2016-07-06','3349900295716',1,NULL,'2016-07-08 14:22:25','3349900295716'),(27,'2016-07-05','3349900295716',1,NULL,'2016-07-08 14:22:51','3349900295716'),(28,'2016-07-04','3349900295716',1,NULL,'2016-07-08 14:23:04','3349900295716'),(29,'2018-11-15','3341500254349',1,NULL,'2018-11-15 11:39:19','1342200097242'),(30,'2018-11-15','3341500042309',1,NULL,'2018-11-15 11:39:19','1342200097242'),(31,'2018-11-15','5340100006289',1,NULL,'2018-11-15 11:39:19','1342200097242'),(32,'2018-11-15','3349900291231',1,NULL,'2018-11-15 11:39:19','1342200097242'),(33,'2018-11-15','3349900295767',1,NULL,'2018-11-15 11:39:19','1342200097242'),(34,'2018-11-15','1342200097242',2,NULL,'2018-11-15 11:39:19','1342200097242'),(35,'2018-11-14','3341500254349',1,NULL,'2018-11-15 11:39:51','1342200097242'),(36,'2018-11-14','3341500042309',1,NULL,'2018-11-15 11:39:51','1342200097242'),(37,'2018-11-14','5340100006289',1,NULL,'2018-11-15 11:39:51','1342200097242'),(38,'2018-11-14','3349900291231',1,NULL,'2018-11-15 11:39:51','1342200097242'),(39,'2018-11-14','3349900295767',1,NULL,'2018-11-15 11:39:51','1342200097242'),(40,'2018-11-14','1342200097242',1,NULL,'2018-11-15 11:39:51','1342200097242'),(41,'2018-11-13','3341500254349',1,NULL,'2018-11-15 11:40:29','1342200097242'),(42,'2018-11-13','3341500042309',1,NULL,'2018-11-15 11:40:29','1342200097242'),(43,'2018-11-13','5340100006289',1,NULL,'2018-11-15 11:40:29','1342200097242'),(44,'2018-11-13','3349900291231',1,NULL,'2018-11-15 11:40:29','1342200097242'),(45,'2018-11-13','3349900295767',1,NULL,'2018-11-15 11:40:29','1342200097242'),(46,'2018-11-13','1342200097242',2,NULL,'2018-11-15 11:40:29','1342200097242'),(47,'2018-11-16','3341500254349',1,NULL,'2018-11-16 08:15:42','1342200097242'),(48,'2018-11-16','3341500042309',1,NULL,'2018-11-16 08:15:42','1342200097242'),(49,'2018-11-16','5340100006289',1,NULL,'2018-11-16 08:15:42','1342200097242'),(50,'2018-11-16','3349900291231',1,NULL,'2018-11-16 08:15:42','1342200097242'),(51,'2018-11-16','3349900295767',1,NULL,'2018-11-16 08:15:42','1342200097242'),(52,'2018-11-16','1342200097242',1,NULL,'2018-11-16 08:15:42','1342200097242'),(53,'2018-11-19','3341500254349',1,NULL,'2018-11-19 10:10:48','1342200097242'),(54,'2018-11-19','3341500042309',1,NULL,'2018-11-19 10:10:48','1342200097242'),(55,'2018-11-19','5340100006289',1,NULL,'2018-11-19 10:10:48','1342200097242'),(56,'2018-11-19','3349900291231',1,NULL,'2018-11-19 10:10:48','1342200097242'),(57,'2018-11-19','3349900295767',1,NULL,'2018-11-19 10:10:48','1342200097242'),(58,'2018-11-19','1342200097242',1,NULL,'2018-11-19 10:10:48','1342200097242'),(59,'2018-11-12','3341500254349',1,NULL,'2018-11-19 10:11:42','1342200097242'),(60,'2018-11-12','3341500042309',1,NULL,'2018-11-19 10:11:42','1342200097242'),(61,'2018-11-12','5340100006289',1,NULL,'2018-11-19 10:11:42','1342200097242'),(62,'2018-11-12','3349900291231',1,NULL,'2018-11-19 10:11:42','1342200097242'),(63,'2018-11-12','3349900295767',1,NULL,'2018-11-19 10:11:42','1342200097242'),(64,'2018-11-12','1342200097242',1,NULL,'2018-11-19 10:11:42','1342200097242'),(65,'2018-11-09','3341500254349',1,NULL,'2018-11-19 10:11:51','1342200097242'),(66,'2018-11-09','3341500042309',1,NULL,'2018-11-19 10:11:51','1342200097242'),(67,'2018-11-09','5340100006289',1,NULL,'2018-11-19 10:11:51','1342200097242'),(68,'2018-11-09','3349900291231',1,NULL,'2018-11-19 10:11:51','1342200097242'),(69,'2018-11-09','3349900295767',1,NULL,'2018-11-19 10:11:51','1342200097242'),(70,'2018-11-09','1342200097242',1,NULL,'2018-11-19 10:11:51','1342200097242'),(71,'2018-11-08','3341500254349',1,NULL,'2018-11-19 10:11:58','1342200097242'),(72,'2018-11-08','3341500042309',1,NULL,'2018-11-19 10:11:58','1342200097242'),(73,'2018-11-08','5340100006289',1,NULL,'2018-11-19 10:11:58','1342200097242'),(74,'2018-11-08','3349900291231',1,NULL,'2018-11-19 10:11:58','1342200097242'),(75,'2018-11-08','3349900295767',1,NULL,'2018-11-19 10:11:58','1342200097242'),(76,'2018-11-08','1342200097242',1,NULL,'2018-11-19 10:11:58','1342200097242'),(77,'2018-11-07','3341500254349',1,NULL,'2018-11-19 10:12:05','1342200097242'),(78,'2018-11-07','3341500042309',1,NULL,'2018-11-19 10:12:05','1342200097242'),(79,'2018-11-07','5340100006289',1,NULL,'2018-11-19 10:12:05','1342200097242'),(80,'2018-11-07','3349900291231',1,NULL,'2018-11-19 10:12:05','1342200097242'),(81,'2018-11-07','3349900295767',1,NULL,'2018-11-19 10:12:05','1342200097242'),(82,'2018-11-07','1342200097242',1,NULL,'2018-11-19 10:12:05','1342200097242'),(83,'2018-11-06','3341500254349',1,NULL,'2018-11-19 10:12:14','1342200097242'),(84,'2018-11-06','3341500042309',1,NULL,'2018-11-19 10:12:14','1342200097242'),(85,'2018-11-06','5340100006289',1,NULL,'2018-11-19 10:12:14','1342200097242'),(86,'2018-11-06','3349900291231',1,NULL,'2018-11-19 10:12:14','1342200097242'),(87,'2018-11-06','3349900295767',1,NULL,'2018-11-19 10:12:14','1342200097242'),(88,'2018-11-06','1342200097242',1,NULL,'2018-11-19 10:12:14','1342200097242'),(89,'2018-11-05','3341500254349',1,NULL,'2018-11-19 10:12:20','1342200097242'),(90,'2018-11-05','3341500042309',1,NULL,'2018-11-19 10:12:20','1342200097242'),(91,'2018-11-05','5340100006289',1,NULL,'2018-11-19 10:12:20','1342200097242'),(92,'2018-11-05','3349900291231',1,NULL,'2018-11-19 10:12:20','1342200097242'),(93,'2018-11-05','3349900295767',1,NULL,'2018-11-19 10:12:20','1342200097242'),(94,'2018-11-05','1342200097242',1,NULL,'2018-11-19 10:12:20','1342200097242'),(95,'2018-11-02','3341500254349',1,NULL,'2018-11-19 10:12:30','1342200097242'),(96,'2018-11-02','3341500042309',1,NULL,'2018-11-19 10:12:30','1342200097242'),(97,'2018-11-02','5340100006289',1,NULL,'2018-11-19 10:12:30','1342200097242'),(98,'2018-11-02','3349900291231',1,NULL,'2018-11-19 10:12:30','1342200097242'),(99,'2018-11-02','3349900295767',1,NULL,'2018-11-19 10:12:30','1342200097242'),(100,'2018-11-02','1342200097242',1,NULL,'2018-11-19 10:12:30','1342200097242'),(101,'2018-11-01','3341500254349',1,NULL,'2018-11-19 10:12:37','1342200097242'),(102,'2018-11-01','3341500042309',1,NULL,'2018-11-19 10:12:37','1342200097242'),(103,'2018-11-01','5340100006289',1,NULL,'2018-11-19 10:12:37','1342200097242'),(104,'2018-11-01','3349900291231',1,NULL,'2018-11-19 10:12:37','1342200097242'),(105,'2018-11-01','3349900295767',1,NULL,'2018-11-19 10:12:37','1342200097242'),(106,'2018-11-01','1342200097242',1,NULL,'2018-11-19 10:12:37','1342200097242'),(107,'2018-11-20','3341500254349',1,NULL,'2018-11-20 08:05:33','1342200097242'),(108,'2018-11-20','3341500042309',1,NULL,'2018-11-20 08:05:33','1342200097242'),(109,'2018-11-20','5340100006289',1,NULL,'2018-11-20 08:05:33','1342200097242'),(110,'2018-11-20','3349900291231',1,NULL,'2018-11-20 08:05:33','1342200097242'),(111,'2018-11-20','3349900295767',1,NULL,'2018-11-20 08:05:33','1342200097242'),(112,'2018-11-20','1342200097242',1,NULL,'2018-11-20 08:05:33','1342200097242'),(113,'2018-11-21','3341500254349',1,NULL,'2018-11-21 09:34:08','1342200097242'),(114,'2018-11-21','3341500042309',1,NULL,'2018-11-21 09:34:08','1342200097242'),(115,'2018-11-21','5340100006289',1,NULL,'2018-11-21 09:34:08','1342200097242'),(116,'2018-11-21','3349900291231',1,NULL,'2018-11-21 09:34:08','1342200097242'),(117,'2018-11-21','3349900295767',1,NULL,'2018-11-21 09:34:08','1342200097242'),(118,'2018-11-21','1342200097242',1,NULL,'2018-11-21 09:34:08','1342200097242'),(119,'2018-11-22','3341500254349',1,NULL,'2018-11-22 08:45:10','1342200097242'),(120,'2018-11-22','3341500042309',1,NULL,'2018-11-22 08:45:10','1342200097242'),(121,'2018-11-22','5340100006289',1,NULL,'2018-11-22 08:45:10','1342200097242'),(122,'2018-11-22','3349900291231',1,NULL,'2018-11-22 08:45:10','1342200097242'),(123,'2018-11-22','3349900295767',1,NULL,'2018-11-22 08:45:10','1342200097242'),(124,'2018-11-22','1342200097242',1,NULL,'2018-11-22 08:45:10','1342200097242'),(125,'2018-11-23','3341500254349',1,NULL,'2018-11-23 13:03:10','1342200097242'),(126,'2018-11-23','3341500042309',1,NULL,'2018-11-23 13:03:10','1342200097242'),(127,'2018-11-23','5340100006289',1,NULL,'2018-11-23 13:03:10','1342200097242'),(128,'2018-11-23','3349900291231',1,NULL,'2018-11-23 13:03:10','1342200097242'),(129,'2018-11-23','3349900295767',1,NULL,'2018-11-23 13:03:10','1342200097242'),(130,'2018-11-23','1342200097242',1,NULL,'2018-11-23 13:03:10','1342200097242'),(131,'2018-11-26','3341500254349',1,NULL,'2018-11-26 07:56:19','1342200097242'),(132,'2018-11-26','3341500042309',1,NULL,'2018-11-26 07:56:19','1342200097242'),(133,'2018-11-26','5340100006289',1,NULL,'2018-11-26 07:56:19','1342200097242'),(134,'2018-11-26','3349900291231',1,NULL,'2018-11-26 07:56:19','1342200097242'),(135,'2018-11-26','3349900295767',1,NULL,'2018-11-26 07:56:19','1342200097242'),(136,'2018-11-26','1342200097242',1,NULL,'2018-11-26 07:56:19','1342200097242'),(137,'2018-11-27','3341500254349',1,NULL,'2018-11-27 10:07:25','1342200097242'),(138,'2018-11-27','3341500042309',1,NULL,'2018-11-27 10:07:25','1342200097242'),(139,'2018-11-27','5340100006289',1,NULL,'2018-11-27 10:07:25','1342200097242'),(140,'2018-11-27','3349900291231',1,NULL,'2018-11-27 10:07:25','1342200097242'),(141,'2018-11-27','3349900295767',1,NULL,'2018-11-27 10:07:25','1342200097242'),(142,'2018-11-27','1342200097242',1,NULL,'2018-11-27 10:07:25','1342200097242'),(143,'2018-11-28','3341500254349',1,NULL,'2018-11-29 07:57:47','1342200097242'),(144,'2018-11-28','3341500042309',1,NULL,'2018-11-29 07:57:47','1342200097242'),(145,'2018-11-28','5340100006289',1,NULL,'2018-11-29 07:57:47','1342200097242'),(146,'2018-11-28','3349900291231',3,NULL,'2018-11-29 07:57:47','1342200097242'),(147,'2018-11-28','3349900295767',1,NULL,'2018-11-29 07:57:47','1342200097242'),(148,'2018-11-28','1342200097242',1,NULL,'2018-11-29 07:57:47','1342200097242'),(149,'2018-11-29','3341500254349',1,NULL,'2018-11-29 13:30:36','1342200097242'),(150,'2018-11-29','3341500042309',4,NULL,'2018-11-29 13:30:36','1342200097242'),(151,'2018-11-29','5340100006289',1,NULL,'2018-11-29 13:30:36','1342200097242'),(152,'2018-11-29','3349900291231',1,NULL,'2018-11-29 13:30:36','1342200097242'),(153,'2018-11-29','3349900295767',1,NULL,'2018-11-29 13:30:36','1342200097242'),(154,'2018-11-29','1342200097242',1,NULL,'2018-11-29 13:30:36','1342200097242'),(155,'2018-11-30','3341500254349',1,NULL,'2018-12-11 09:26:33','1342200097242'),(156,'2018-11-30','3341500042309',1,NULL,'2018-12-11 09:26:33','1342200097242'),(157,'2018-11-30','5340100006289',1,NULL,'2018-12-11 09:26:33','1342200097242'),(158,'2018-11-30','3349900291231',1,NULL,'2018-12-11 09:26:33','1342200097242'),(159,'2018-11-30','3349900295767',1,NULL,'2018-12-11 09:26:33','1342200097242'),(160,'2018-11-30','1342200097242',1,NULL,'2018-12-11 09:26:33','1342200097242'),(161,'2018-12-03','3341500254349',1,NULL,'2018-12-11 09:26:47','1342200097242'),(162,'2018-12-03','3341500042309',1,NULL,'2018-12-11 09:26:47','1342200097242'),(163,'2018-12-03','5340100006289',1,NULL,'2018-12-11 09:26:47','1342200097242'),(164,'2018-12-03','3349900291231',1,NULL,'2018-12-11 09:26:47','1342200097242'),(165,'2018-12-03','3349900295767',1,NULL,'2018-12-11 09:26:47','1342200097242'),(166,'2018-12-03','1342200097242',1,NULL,'2018-12-11 09:26:47','1342200097242'),(167,'2018-12-04','3341500254349',1,NULL,'2018-12-11 09:26:58','1342200097242'),(168,'2018-12-04','3341500042309',1,NULL,'2018-12-11 09:26:58','1342200097242'),(169,'2018-12-04','5340100006289',1,NULL,'2018-12-11 09:26:58','1342200097242'),(170,'2018-12-04','3349900291231',1,NULL,'2018-12-11 09:26:58','1342200097242'),(171,'2018-12-04','3349900295767',1,NULL,'2018-12-11 09:26:58','1342200097242'),(172,'2018-12-04','1342200097242',1,NULL,'2018-12-11 09:26:58','1342200097242'),(173,'2018-12-06','3341500254349',2,NULL,'2018-12-11 09:27:21','1342200097242'),(174,'2018-12-06','3341500042309',2,NULL,'2018-12-11 09:27:21','1342200097242'),(175,'2018-12-06','5340100006289',2,NULL,'2018-12-11 09:27:21','1342200097242'),(176,'2018-12-06','3349900291231',2,NULL,'2018-12-11 09:27:21','1342200097242'),(177,'2018-12-06','3349900295767',2,NULL,'2018-12-11 09:27:21','1342200097242'),(178,'2018-12-06','1342200097242',2,NULL,'2018-12-11 09:27:21','1342200097242'),(179,'2018-12-07','3341500254349',1,NULL,'2018-12-11 09:27:33','1342200097242'),(180,'2018-12-07','3341500042309',1,NULL,'2018-12-11 09:27:33','1342200097242'),(181,'2018-12-07','5340100006289',1,NULL,'2018-12-11 09:27:33','1342200097242'),(182,'2018-12-07','3349900295767',1,NULL,'2018-12-11 09:27:33','1342200097242'),(183,'2018-12-07','1342200097242',2,NULL,'2018-12-11 09:27:33','1342200097242'),(184,'2018-12-11','3341500254349',1,NULL,'2018-12-11 09:27:40','1342200097242'),(185,'2018-12-11','3341500042309',1,NULL,'2018-12-11 09:27:40','1342200097242'),(186,'2018-12-11','5340100006289',1,NULL,'2018-12-11 09:27:40','1342200097242'),(187,'2018-12-11','3349900291231',1,NULL,'2018-12-11 09:27:40','1342200097242'),(188,'2018-12-11','3349900295767',1,NULL,'2018-12-11 09:27:40','1342200097242'),(189,'2018-12-11','1342200097242',1,NULL,'2018-12-11 09:27:40','1342200097242'),(190,'2018-12-12','3341500254349',1,NULL,'2018-12-17 10:35:04','1342200097242'),(191,'2018-12-12','3341500042309',1,NULL,'2018-12-17 10:35:04','1342200097242'),(192,'2018-12-12','5340100006289',1,NULL,'2018-12-17 10:35:04','1342200097242'),(193,'2018-12-12','3349900291231',1,NULL,'2018-12-17 10:35:04','1342200097242'),(194,'2018-12-12','3349900295767',1,NULL,'2018-12-17 10:35:04','1342200097242'),(195,'2018-12-12','1342200097242',1,NULL,'2018-12-17 10:35:04','1342200097242'),(196,'2018-12-13','3341500254349',1,NULL,'2018-12-17 10:35:12','1342200097242'),(197,'2018-12-13','3341500042309',1,NULL,'2018-12-17 10:35:12','1342200097242'),(198,'2018-12-13','5340100006289',1,NULL,'2018-12-17 10:35:12','1342200097242'),(199,'2018-12-13','3349900291231',1,NULL,'2018-12-17 10:35:12','1342200097242'),(200,'2018-12-13','3349900295767',1,NULL,'2018-12-17 10:35:12','1342200097242'),(201,'2018-12-13','1342200097242',1,NULL,'2018-12-17 10:35:12','1342200097242'),(202,'2018-12-14','3341500254349',1,NULL,'2018-12-17 10:39:18','1342200097242'),(203,'2018-12-14','3341500042309',1,NULL,'2018-12-17 10:39:18','1342200097242'),(204,'2018-12-14','5340100006289',1,NULL,'2018-12-17 10:39:18','1342200097242'),(205,'2018-12-14','3349900291231',1,NULL,'2018-12-17 10:39:18','1342200097242'),(206,'2018-12-14','3349900295767',1,NULL,'2018-12-17 10:39:18','1342200097242'),(207,'2018-12-14','1342200097242',1,NULL,'2018-12-17 10:39:18','1342200097242'),(208,'2018-12-17','3341500254349',1,NULL,'2018-12-17 10:47:25','1342200097242'),(209,'2018-12-17','3341500042309',1,NULL,'2018-12-17 10:47:25','1342200097242'),(210,'2018-12-17','5340100006289',1,NULL,'2018-12-17 10:47:25','1342200097242'),(211,'2018-12-17','3349900291231',1,NULL,'2018-12-17 10:47:25','1342200097242'),(212,'2018-12-17','3349900295767',1,NULL,'2018-12-17 10:47:25','1342200097242'),(213,'2018-12-17','1342200097242',1,NULL,'2018-12-17 10:47:25','1342200097242'),(214,'2018-12-18','3341500254349',1,NULL,'2018-12-18 09:10:14','1342200097242'),(215,'2018-12-18','3341500042309',1,NULL,'2018-12-18 09:10:14','1342200097242'),(216,'2018-12-18','5340100006289',1,NULL,'2018-12-18 09:10:14','1342200097242'),(217,'2018-12-18','3349900291231',1,NULL,'2018-12-18 09:10:14','1342200097242'),(218,'2018-12-18','3349900295767',1,NULL,'2018-12-18 09:10:14','1342200097242'),(219,'2018-12-18','1342200097242',1,NULL,'2018-12-18 09:10:14','1342200097242'),(220,'2018-12-19','3341500254349',1,NULL,'2018-12-19 09:03:18','1342200097242'),(221,'2018-12-19','3341500042309',1,NULL,'2018-12-19 09:03:18','1342200097242'),(222,'2018-12-19','5340100006289',1,NULL,'2018-12-19 09:03:18','1342200097242'),(223,'2018-12-19','3349900291231',1,NULL,'2018-12-19 09:03:18','1342200097242'),(224,'2018-12-19','3349900295767',1,NULL,'2018-12-19 09:03:18','1342200097242'),(225,'2018-12-19','1342200097242',1,NULL,'2018-12-19 09:03:18','1342200097242'),(226,'2018-12-20','3341500254349',1,NULL,'2018-12-26 08:24:14','1342200097242'),(227,'2018-12-20','3341500042309',1,NULL,'2018-12-26 08:24:14','1342200097242'),(228,'2018-12-20','5340100006289',1,NULL,'2018-12-26 08:24:14','1342200097242'),(229,'2018-12-20','3349900291231',1,NULL,'2018-12-26 08:24:14','1342200097242'),(230,'2018-12-20','3349900295767',1,NULL,'2018-12-26 08:24:14','1342200097242'),(231,'2018-12-20','1342200097242',1,NULL,'2018-12-26 08:24:14','1342200097242'),(232,'2018-12-21','3341500254349',1,NULL,'2018-12-26 08:24:22','1342200097242'),(233,'2018-12-21','3341500042309',1,NULL,'2018-12-26 08:24:22','1342200097242'),(234,'2018-12-21','5340100006289',1,NULL,'2018-12-26 08:24:22','1342200097242'),(235,'2018-12-21','3349900291231',1,NULL,'2018-12-26 08:24:22','1342200097242'),(236,'2018-12-21','3349900295767',1,NULL,'2018-12-26 08:24:22','1342200097242'),(237,'2018-12-21','1342200097242',1,NULL,'2018-12-26 08:24:22','1342200097242'),(238,'2018-12-24','3341500254349',1,NULL,'2018-12-26 08:24:31','1342200097242'),(239,'2018-12-24','3341500042309',1,NULL,'2018-12-26 08:24:31','1342200097242'),(240,'2018-12-24','5340100006289',1,NULL,'2018-12-26 08:24:31','1342200097242'),(241,'2018-12-24','3349900291231',1,NULL,'2018-12-26 08:24:31','1342200097242'),(242,'2018-12-24','3349900295767',1,NULL,'2018-12-26 08:24:31','1342200097242'),(243,'2018-12-24','1342200097242',1,NULL,'2018-12-26 08:24:31','1342200097242'),(244,'2018-12-25','3341500254349',1,NULL,'2018-12-26 08:24:38','1342200097242'),(245,'2018-12-25','3341500042309',1,NULL,'2018-12-26 08:24:38','1342200097242'),(246,'2018-12-25','5340100006289',1,NULL,'2018-12-26 08:24:38','1342200097242'),(247,'2018-12-25','3349900291231',1,NULL,'2018-12-26 08:24:38','1342200097242'),(248,'2018-12-25','3349900295767',1,NULL,'2018-12-26 08:24:38','1342200097242'),(249,'2018-12-25','1342200097242',1,NULL,'2018-12-26 08:24:38','1342200097242'),(250,'2018-12-26','3341500254349',1,NULL,'2018-12-26 08:24:48','1342200097242'),(251,'2018-12-26','3341500042309',1,NULL,'2018-12-26 08:24:48','1342200097242'),(252,'2018-12-26','5340100006289',1,NULL,'2018-12-26 08:24:48','1342200097242'),(253,'2018-12-26','3349900291231',1,NULL,'2018-12-26 08:24:48','1342200097242'),(254,'2018-12-26','3349900295767',1,NULL,'2018-12-26 08:24:48','1342200097242'),(255,'2018-12-26','1342200097242',1,NULL,'2018-12-26 08:24:48','1342200097242'),(256,'2018-12-27','3341500254349',1,NULL,'2019-01-02 10:53:18','1342200097242'),(257,'2018-12-27','3341500042309',1,NULL,'2019-01-02 10:53:18','1342200097242'),(258,'2018-12-27','5340100006289',1,NULL,'2019-01-02 10:53:18','1342200097242'),(259,'2018-12-27','3349900291231',1,NULL,'2019-01-02 10:53:18','1342200097242'),(260,'2018-12-27','3349900295767',1,NULL,'2019-01-02 10:53:18','1342200097242'),(261,'2018-12-27','1342200097242',1,NULL,'2019-01-02 10:53:18','1342200097242'),(262,'2018-12-28','3341500254349',1,NULL,'2019-01-02 10:53:25','1342200097242'),(263,'2018-12-28','3341500042309',1,NULL,'2019-01-02 10:53:25','1342200097242'),(264,'2018-12-28','5340100006289',1,NULL,'2019-01-02 10:53:25','1342200097242'),(265,'2018-12-28','3349900291231',1,NULL,'2019-01-02 10:53:25','1342200097242'),(266,'2018-12-28','3349900295767',1,NULL,'2019-01-02 10:53:25','1342200097242'),(267,'2018-12-28','1342200097242',1,NULL,'2019-01-02 10:53:25','1342200097242'),(268,'2019-01-02','3341500254349',2,NULL,'2019-01-02 10:53:44','1342200097242'),(269,'2019-01-02','3341500042309',1,NULL,'2019-01-02 10:53:44','1342200097242'),(270,'2019-01-02','5340100006289',1,NULL,'2019-01-02 10:53:44','1342200097242'),(271,'2019-01-02','3349900291231',1,NULL,'2019-01-02 10:53:44','1342200097242'),(272,'2019-01-02','3349900295767',1,NULL,'2019-01-02 10:53:44','1342200097242'),(273,'2019-01-02','1342200097242',1,NULL,'2019-01-02 10:53:44','1342200097242'),(274,'2019-01-03','3341500254349',1,NULL,'2019-01-04 09:07:05','1342200097242'),(275,'2019-01-03','3341500042309',1,NULL,'2019-01-04 09:07:05','1342200097242'),(276,'2019-01-03','5340100006289',1,NULL,'2019-01-04 09:07:05','1342200097242'),(277,'2019-01-03','3349900291231',1,NULL,'2019-01-04 09:07:05','1342200097242'),(278,'2019-01-03','3349900295767',1,NULL,'2019-01-04 09:07:05','1342200097242'),(279,'2019-01-03','1342200097242',1,NULL,'2019-01-04 09:07:05','1342200097242'),(280,'2019-01-04','3341500254349',1,NULL,'2019-01-04 09:07:15','1342200097242'),(281,'2019-01-04','3341500042309',1,NULL,'2019-01-04 09:07:15','1342200097242'),(282,'2019-01-04','5340100006289',1,NULL,'2019-01-04 09:07:15','1342200097242'),(283,'2019-01-04','3349900291231',1,NULL,'2019-01-04 09:07:15','1342200097242'),(284,'2019-01-04','3349900295767',1,NULL,'2019-01-04 09:07:15','1342200097242'),(285,'2019-01-04','1342200097242',1,NULL,'2019-01-04 09:07:15','1342200097242'),(286,'2019-01-07','3341500254349',1,NULL,'2019-01-08 13:16:03','1342200097242'),(287,'2019-01-07','3341500042309',1,NULL,'2019-01-08 13:16:03','1342200097242'),(288,'2019-01-07','5340100006289',1,NULL,'2019-01-08 13:16:03','1342200097242'),(289,'2019-01-07','3349900291231',1,NULL,'2019-01-08 13:16:03','1342200097242'),(290,'2019-01-07','3349900295767',1,NULL,'2019-01-08 13:16:03','1342200097242'),(291,'2019-01-07','1342200097242',1,NULL,'2019-01-08 13:16:03','1342200097242'),(292,'2019-01-08','3341500254349',1,NULL,'2019-01-08 13:16:14','1342200097242'),(293,'2019-01-08','3341500042309',1,NULL,'2019-01-08 13:16:14','1342200097242'),(294,'2019-01-08','5340100006289',1,NULL,'2019-01-08 13:16:14','1342200097242'),(295,'2019-01-08','3349900291231',1,NULL,'2019-01-08 13:16:14','1342200097242'),(296,'2019-01-08','3349900295767',1,NULL,'2019-01-08 13:16:14','1342200097242'),(297,'2019-01-08','1342200097242',1,NULL,'2019-01-08 13:16:14','1342200097242'),(298,'2019-01-09','3341500254349',1,NULL,'2019-01-09 08:37:58','1342200097242'),(299,'2019-01-09','3341500042309',1,NULL,'2019-01-09 08:37:58','1342200097242'),(300,'2019-01-09','5340100006289',4,NULL,'2019-01-09 08:37:58','1342200097242'),(301,'2019-01-09','3349900291231',1,NULL,'2019-01-09 08:37:58','1342200097242'),(302,'2019-01-09','3349900295767',1,NULL,'2019-01-09 08:37:58','1342200097242'),(303,'2019-01-09','1342200097242',1,NULL,'2019-01-09 08:37:58','1342200097242'),(304,'2019-01-10','3341500254349',1,NULL,'2019-01-17 08:33:56','1342200097242'),(305,'2019-01-10','3341500042309',1,NULL,'2019-01-17 08:33:56','1342200097242'),(306,'2019-01-10','5340100006289',1,NULL,'2019-01-17 08:33:56','1342200097242'),(307,'2019-01-10','3349900291231',1,NULL,'2019-01-17 08:33:56','1342200097242'),(308,'2019-01-10','3349900295767',1,NULL,'2019-01-17 08:33:56','1342200097242'),(309,'2019-01-10','1342200097242',1,NULL,'2019-01-17 08:33:56','1342200097242'),(310,'2019-01-11','3341500254349',1,NULL,'2019-01-17 08:34:04','1342200097242'),(311,'2019-01-11','3341500042309',1,NULL,'2019-01-17 08:34:04','1342200097242'),(312,'2019-01-11','5340100006289',1,NULL,'2019-01-17 08:34:04','1342200097242'),(313,'2019-01-11','3349900291231',1,NULL,'2019-01-17 08:34:04','1342200097242'),(314,'2019-01-11','3349900295767',1,NULL,'2019-01-17 08:34:04','1342200097242'),(315,'2019-01-11','1342200097242',1,NULL,'2019-01-17 08:34:04','1342200097242'),(316,'2019-01-14','3341500254349',1,NULL,'2019-01-17 08:34:13','1342200097242'),(317,'2019-01-14','3341500042309',1,NULL,'2019-01-17 08:34:13','1342200097242'),(318,'2019-01-14','5340100006289',1,NULL,'2019-01-17 08:34:13','1342200097242'),(319,'2019-01-14','3349900291231',1,NULL,'2019-01-17 08:34:13','1342200097242'),(320,'2019-01-14','3349900295767',1,NULL,'2019-01-17 08:34:13','1342200097242'),(321,'2019-01-14','1342200097242',1,NULL,'2019-01-17 08:34:13','1342200097242'),(322,'2019-01-15','3341500254349',1,NULL,'2019-01-17 08:34:20','1342200097242'),(323,'2019-01-15','3341500042309',1,NULL,'2019-01-17 08:34:20','1342200097242'),(324,'2019-01-15','5340100006289',1,NULL,'2019-01-17 08:34:20','1342200097242'),(325,'2019-01-15','3349900291231',1,NULL,'2019-01-17 08:34:20','1342200097242'),(326,'2019-01-15','3349900295767',1,NULL,'2019-01-17 08:34:20','1342200097242'),(327,'2019-01-15','1342200097242',1,NULL,'2019-01-17 08:34:20','1342200097242'),(328,'2019-01-16','3341500254349',1,NULL,'2019-01-17 08:34:27','1342200097242'),(329,'2019-01-16','3341500042309',1,NULL,'2019-01-17 08:34:27','1342200097242'),(330,'2019-01-16','5340100006289',1,NULL,'2019-01-17 08:34:27','1342200097242'),(331,'2019-01-16','3349900291231',1,NULL,'2019-01-17 08:34:27','1342200097242'),(332,'2019-01-16','3349900295767',1,NULL,'2019-01-17 08:34:27','1342200097242'),(333,'2019-01-16','1342200097242',1,NULL,'2019-01-17 08:34:27','1342200097242'),(334,'2019-01-17','3341500254349',1,NULL,'2019-01-17 08:34:34','1342200097242'),(335,'2019-01-17','3341500042309',1,NULL,'2019-01-17 08:34:34','1342200097242'),(336,'2019-01-17','5340100006289',1,NULL,'2019-01-17 08:34:34','1342200097242'),(337,'2019-01-17','3349900291231',1,NULL,'2019-01-17 08:34:34','1342200097242'),(338,'2019-01-17','3349900295767',1,NULL,'2019-01-17 08:34:34','1342200097242'),(339,'2019-01-17','1342200097242',1,NULL,'2019-01-17 08:34:34','1342200097242'),(340,'2019-01-18','3341500254349',1,NULL,'2019-01-18 07:57:32','1342200097242'),(341,'2019-01-18','3341500042309',1,NULL,'2019-01-18 07:57:32','1342200097242'),(342,'2019-01-18','5340100006289',1,NULL,'2019-01-18 07:57:32','1342200097242'),(343,'2019-01-18','3349900291231',1,NULL,'2019-01-18 07:57:32','1342200097242'),(344,'2019-01-18','3349900295767',1,NULL,'2019-01-18 07:57:32','1342200097242'),(345,'2019-01-18','1342200097242',1,NULL,'2019-01-18 07:57:32','1342200097242');

--
-- Table structure for table `work_permission`
--

CREATE TABLE `work_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `person_id` varchar(13) NOT NULL,
  `p1` tinyint(4) NOT NULL,
  `officer` varchar(13) NOT NULL,
  `rec_date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `work_permission`
--

INSERT INTO `work_permission` VALUES (2,'3349900291231',1,'3349900295767','2016-06-26'),(10,'1349900777382',1,'1342200097242','2020-01-29'),(4,'3349900295767',1,'3349900295767','2016-06-26'),(9,'1342200097242',1,'1342200097242','2018-11-15');


