-- Table structure for table `student_check_permission`
--

CREATE TABLE `student_check_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_check_permission`
--

INSERT INTO `student_check_permission` VALUES (3,1,'3341500030807',2561),(3,1,'1349900961108',2568),(9,1,'3341500526446',2561),(5,1,'3349900943319',2563),(1,1,'1349900490091',2568),(5,1,'5341590011668',2561),(5,1,'3349800244567',2561),(8,1,'3341500526446',2561),(6,1,'3349800244567',2561),(3,1,'3320300013231',2568),(4,1,'3349900943319',2563),(1,0,'3349800244567',2563),(6,1,'3341500526446',2561),(2,1,'1349900490091',2568),(6,1,'3341500526446',2565),(4,1,'1330700123801',2565),(4,1,'1330700123801',2563),(3,1,'3341500030807',2562),(3,0,'3349800244567',2563),(1,1,'1349900961108',2568),(6,1,'3341500526446',2562),(9,1,'1342200067581',2562),(5,1,'1330700123801',2563),(8,1,'1342200067581',2562),(1,1,'3341500030807',2562),(4,1,'1330700123801',2566),(2,1,'1349900961108',2568),(1,0,'3349800244567',2562),(4,1,'1330700123801',2562),(5,1,'1349900490091',2565),(1,1,'3349900943319',2565),(2,0,'3349800244567',2563),(1,1,'3320300013231',2568),(5,1,'3349900943319',2562),(1,1,'3349900943319',2562),(2,1,'3349900943319',2562),(3,1,'3349900943319',2562),(4,1,'3349900943319',2562),(6,1,'3349900943319',2562),(7,1,'3349900943319',2562),(8,1,'3349900943319',2562),(9,1,'3349900943319',2562),(6,1,'3341500526446',2563),(6,1,'3349900943319',2563),(7,1,'3349900943319',2563),(4,1,'3349800244567',2568),(8,1,'3349900943319',2563),(8,1,'1342200067581',2563),(9,1,'3349900943319',2563),(9,1,'1342200067581',2563),(4,1,'3320300013231',2568),(2,1,'3320300013231',2568),(5,1,'3349800244567',2567),(4,1,'1330700123801',2564),(5,1,'1330700123801',2564),(6,1,'3341500526446',2564),(5,1,'3341500526446',2564),(8,1,'3341500008836',2564),(9,1,'3341500008836',2564),(4,1,'3349800244567',2567),(9,1,'3341500008836',2565),(8,1,'3341500008836',2565),(7,1,'3341500526446',2565),(5,1,'1330700123801',2565),(3,1,'1349900490091',2568),(5,1,'1330700123801',2566),(5,1,'1349900490091',2566),(6,1,'3341500526446',2566),(9,1,'1349900490091',2566),(7,1,'3341500526446',2566),(7,1,'1349900490091',2566),(8,1,'3341500008836',2566),(4,1,'1349900490091',2566),(9,1,'3341500008836',2566),(2,1,'1349900490091',2566),(8,1,'1349900490091',2566),(6,1,'1349900490091',2566),(3,1,'1349900490091',2566),(1,1,'1349900490091',2566),(1,1,'1349900961108',2567),(1,1,'1349900490091',2567),(2,1,'1349900961108',2567),(2,1,'1349900490091',2567),(3,1,'1349900961108',2567),(3,1,'1349900490091',2567),(4,1,'3320300013231',2567),(4,1,'1349900490091',2567),(1,1,'3320300013231',2567),(2,1,'3320300013231',2567),(3,1,'3320300013231',2567),(5,1,'3320300013231',2567),(5,1,'1349900490091',2567),(6,1,'3320300013231',2567),(6,1,'3341500526446',2567),(6,1,'1349900490091',2567),(7,1,'3320300013231',2567),(7,1,'3341500526446',2567),(7,1,'1349900490091',2567),(8,1,'3320300013231',2567),(8,1,'3341500008836',2567),(8,1,'1349900490091',2567),(9,1,'3320300013231',2567),(9,1,'3341500008836',2567),(9,1,'1349900490091',2567),(4,1,'1349900490091',2568),(5,1,'3320300013231',2568),(5,1,'3349800244567',2568),(5,1,'1349900490091',2568),(6,1,'3320300013231',2568),(6,1,'3341500526446',2568),(6,1,'1349900490091',2568),(7,1,'3320300013231',2568),(7,1,'3341500526446',2568),(7,1,'1349900490091',2568),(8,1,'3320300013231',2568),(8,1,'3341500008836',2568),(8,1,'1349900490091',2568),(9,1,'3320300013231',2568),(9,1,'3341500008836',2568),(9,1,'1349900490091',2568);

--
-- Table structure for table `student_check_year`
--

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

--
-- Dumping data for table `student_check_year`
--

INSERT INTO `student_check_year` 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`
--

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=174 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `student_main` VALUES (2,'653',0,'เด็กชาย','นันธิวัฒน์','กาเมือง','2324400024136',1,NULL,9,1,1,2561,'','0000-00-00'),(3,'585',0,'เด็กชาย','อนุชา','โมลานิล','1342200117511',1,NULL,9,1,1,2561,'','0000-00-00'),(4,'584',0,'เด็กชาย','อมรเทพ','ศิระพรหม','1342200115941',1,NULL,9,1,1,2561,'','0000-00-00'),(5,'583',0,'เด็กชาย','วรยุทธ','คำโสภา','2342200024120',1,NULL,9,1,1,2561,'','0000-00-00'),(6,'581',0,'เด็กชาย','จีระประวัติ','พันจำนงค์','1349901202723',1,NULL,9,1,1,2561,'','0000-00-00'),(7,'605',0,'เด็กหญิง','สุทธิดา','พิลารัตน์','1342200118843',2,NULL,8,1,1,2561,'','0000-00-00'),(8,'594',0,'เด็กหญิง','เจตนิพิฐ','วงษ์ลา','1342200134008',2,NULL,8,1,1,2561,'','0000-00-00'),(9,'593',0,'เด็กหญิง','บังอร','พันธมาต','1342200118479',2,NULL,8,1,1,2561,'','0000-00-00'),(10,'592',0,'เด็กหญิง','สมฤดี','บุดดาลี','1342200118690',2,NULL,8,1,1,2561,'','0000-00-00'),(11,'591',0,'เด็กหญิง','สุนิษา','บุญช่วย','1342200119238',2,NULL,8,1,1,2561,'','0000-00-00'),(12,'590',0,'เด็กหญิง','วรดา','จันทาโทอ่อน','1342200119467',2,NULL,8,1,1,2561,'','0000-00-00'),(13,'589',0,'เด็กหญิง','สุภัสสร','พรมจันทร์','1342200133842',2,NULL,8,1,1,2561,'','0000-00-00'),(14,'588',0,'เด็กชาย','ประวันวิทย์','ดวงงอก','1342200134148',1,NULL,8,1,1,2561,'','0000-00-00'),(15,'587',0,'เด็กชาย','อภิวัฒน์','พรมจันทร์','1342200119378',1,NULL,8,1,1,2561,'','0000-00-00'),(16,'603',0,'เด็กหญิง','สายชล','ทัดเทียม','1349901352814',2,NULL,8,1,1,2561,'','0000-00-00'),(17,'601',0,'เด็กหญิง','จิราพร','วงษา','1100401242096',2,NULL,8,1,1,2561,'','0000-00-00'),(18,'604',0,'เด็กชาย','ธนวัฒน์','โพธิยา','1349901356461',1,NULL,8,1,1,2561,'','0000-00-00'),(19,'600',0,'เด็กชาย','อนุชา','บัวคำ','1342200136566',1,NULL,8,1,1,2561,'','0000-00-00'),(20,'599',0,'เด็กชาย','ภูวเดช','พิมเสนา','1349901343289',1,NULL,8,1,1,2561,'','0000-00-00'),(21,'618',0,'เด็กหญิง','อารีญา','บรรดาเทา','1349901455583',2,NULL,6,1,1,2561,'','0000-00-00'),(22,'617',0,'เด็กหญิง','บุษบา','บัวแก้ว','1349901409301',2,NULL,6,1,1,2561,'','0000-00-00'),(23,'615',0,'เด็กหญิง','ศรีประภา','นินเนตร','1349901358651',2,NULL,6,1,1,2561,'','0000-00-00'),(24,'614',0,'เด็กหญิง','ชนิกานต์','บุญเลิศ','1342200142311',2,NULL,6,1,1,2561,'','0000-00-00'),(25,'613',0,'เด็กหญิง','ประภัสสร','สุพล','1342200142558',2,NULL,6,1,1,2561,'','0000-00-00'),(26,'612',0,'เด็กชาย','อภิสิทธิ์','บุญใหญ่','1342200141284',1,NULL,6,1,1,2561,'','0000-00-00'),(27,'610',0,'เด็กชาย','สมศักดิ์','คำโสภา','1342200142744',1,NULL,6,1,1,2561,'','0000-00-00'),(28,'609',0,'เด็กชาย','ศิรชัช','ตั้งสุข','1339600130111',1,NULL,6,1,1,2561,'','0000-00-00'),(30,'623',0,'เด็กหญิง','ศุภรัตน์ดา','หงษ์คำ','1349901530593',2,NULL,9,1,1,2561,'','0000-00-00'),(31,'622',0,'เด็กหญิง','อริยา','โพธิบา','1349901517759',2,NULL,9,1,1,2561,'','0000-00-00'),(89,'699',5,'เด็กชาย','ชญานนท์','สุพล','1342200143562',1,'',9,0,1,2561,'1349900490091','2018-12-20'),(33,'723',9,'เด็กชาย','ณัฐพงษ์','คำด้วง','1101801640936',1,NULL,9,1,1,2564,'1349900490091','0000-00-00'),(34,'621',0,'เด็กชาย','สราวุธ','พันธมาต','1342200145166',1,NULL,9,1,1,2561,'','0000-00-00'),(35,'619',0,'เด็กชาย','สมคิด','นามลี','1349901488309',1,NULL,9,1,1,2561,'','0000-00-00'),(37,'649',6,'เด็กหญิง','ธัญชนก','พิมพ์วงค์','1349901660900',2,NULL,9,1,1,2564,'1349900490091','0000-00-00'),(38,'646',4,'เด็กหญิง','กนกวรรณ','แสงจันทร์','1349901632591',2,NULL,9,1,1,2564,'3349900943319','0000-00-00'),(39,'640',3,'เด็กหญิง','แตงไท','พันธมาต','1909803411071',2,NULL,9,1,1,2563,'3349800244567','0000-00-00'),(40,'630',0,'เด็กหญิง','ทักษอร','นิลธิราช','1349901617419',2,NULL,3,1,2,2561,'','0000-00-00'),(41,'629',2,'เด็กหญิง','อภิญญา','ดีแสง','1341501508861',2,NULL,9,1,1,2563,'3349800244567','0000-00-00'),(42,'652',0,'เด็กชาย','ณัฐกิตต์','มณีสังข์','1342200151298',1,NULL,3,1,2,2561,'','0000-00-00'),(110,'645',3,'เด็กชาย','สุธินันท์','คำภานิล','1342200152049',1,'',9,1,1,2564,'3349900943319','2019-07-03'),(44,'644',0,'เด็กชาย','ณัฐกรณ์','โทมนตรี','1349901649043',1,NULL,3,1,2,2561,'','0000-00-00'),(45,'643',2,'เด็กชาย','สุชาติ','สาระนัน','1342200151522',1,NULL,9,1,1,2564,'3349900943319','0000-00-00'),(46,'642',1,'เด็กชาย','รัฐภูมิ','บุตรวงษ์','1342200150917',1,NULL,9,1,1,2564,'1330700123801','0000-00-00'),(47,'628',0,'เด็กชาย','อนุกูล','สีหาบุตร','1342200150615',1,NULL,3,1,2,2561,'','0000-00-00'),(48,'627',1,'เด็กชาย','ปัญญพนต์','สีดาล้อม','1349901069998',1,NULL,9,1,1,2563,'3349800244567','0000-00-00'),(49,'626',0,'เด็กชาย','ฟ้าใส','ดวงงอก','1342200150607',1,NULL,3,1,2,2561,'','0000-00-00'),(50,'620',0,'เด็กชาย','ฉลองศักดิ์','พันธมาต','1909803172204',1,'',9,1,1,2561,'3341500526446','2018-08-16'),(51,'676',3,'เด็กหญิง','สุนิตา','ทองเต็ม','1342200015754',2,'',9,1,1,2566,'1349900490091','2018-08-17'),(70,'633',0,'เด็กหญิง','กัญญพัชร','ทับทิม','1349901580870',2,'',9,1,1,2562,'3341500526446','2018-08-17'),(53,'674',1,'เด็กชาย','พัชรพล','พรมจันทร์','1347600064290',1,'',9,1,1,2566,'3349900943319','2018-08-17'),(54,'687',5,'เด็กชาย','ยศกร','กํ้าเกี้ยง','1348900277346',1,'',9,1,1,2566,'3341500526446','2018-08-17'),(55,'661',1,'เด็กชาย','ธนะเทพ','พิมพ์วงค์','1349901744402',1,'',9,1,1,2565,'3349900943319','2018-08-17'),(56,'662',2,'เด็กชาย','ธีรชัย','สืบสีมา','1342200156567',1,'',9,1,1,2565,'3349900943319','2018-08-17'),(57,'663',3,'เด็กหญิง','ปาณัทดา','ดวงงอก','1342200154114',2,'',9,1,1,2565,'3349900943319','2018-08-17'),(58,'666',6,'เด็กหญิง','จินต์จุฑา','เทพวอน','1342200155170',2,'',9,1,1,2565,'3349900943319','2018-08-17'),(59,'668',7,'เด็กหญิง','ณดา','พีรี','1342200155196',2,'',9,1,1,2565,'3349900943319','2018-08-17'),(60,'670',8,'เด็กหญิง','กวิสรา','สุวรรณศิล','1347600045414',2,'',9,1,1,2565,'3349900943319','2018-08-17'),(61,'671',9,'เด็กหญิง','จริษา','พรรณลา','1342200154408',2,'',9,1,1,2565,'3349900943319','2018-08-17'),(63,'685',1,'เด็กชาย','วิชชากร','เถาว์ทุมมา','1342200161447',1,'',9,1,0,NULL,'1349900490091','2018-08-17'),(64,'688',2,'เด็กหญิง','วีรดา','วิสูงเล','1342200161536',2,'',9,1,0,NULL,'1349900490091','2018-08-17'),(69,'659',8,'เด็กชาย','พงษ์พิทักษ์','พันธมาต','1718800146785',1,'',9,1,1,2564,'3349900943319','2018-08-17'),(66,'648',5,'เด็กเญิง','ตรีเพชร','ปลื้มจิตร์','1342200151999',2,'',9,1,1,2564,'3349900943319','2018-08-17'),(67,'655',7,'เด็กเญิง','อิศริยา','สืบสีมา','1342200152481',2,'',9,1,1,2564,'3349900943319','2018-08-17'),(146,'749',6,'เด็กหญิง','ณัฐิดา','โทมนตรี','1341501641536',2,'',4,1,0,NULL,'1349900490091','2022-11-01'),(72,'634',0,'เด็กหญิง','เกวลิน','นารีสา','1342200149145',2,'',9,1,1,2562,'3341500526446','2018-08-17'),(73,'690',1,'เด็กชาย','พงศภัค','สีดาล้อม','1260401290481',1,'',8,1,0,NULL,'1349900490091','2018-08-17'),(74,'635',0,'เด็กหญิง','พัชรี','กาเมือง','1342200147070',2,'',9,1,1,2562,'3341500526446','2018-08-17'),(75,'691',2,'เด็กชาย','รัชชานนท์','บุตรวงษ์','1342200163857',1,'',8,1,0,NULL,'1349900490091','2018-08-17'),(76,'637',0,'เด็กหญิง','วิชญาดา','เอมโอษฐ์','1349901550357',2,'',9,1,1,2562,'3341500526446','2018-08-17'),(77,'692',3,'เด็กหญิง','กชมน','โมลานิล','1200901765445',2,'',8,1,0,NULL,'1349900490091','2018-08-17'),(78,'693',4,'เด็กหญิง','ษริษา','คำด้วง','1342200163610',2,'',8,1,0,NULL,'1349900490091','2018-08-17'),(79,'638',0,'เด็กชาย','กรวิชญ์','จันทาโทอ่อน','1349901567861',1,'',9,1,1,2562,'3341500526446','2018-08-17'),(80,'694',5,'เด็กหญิง','ไพลิน','พันธมาต','1909804064006',2,'',8,1,0,NULL,'1349900490091','2018-08-17'),(81,'639',0,'เด็กชาย','กันตภัทร','เถาว์ทุมมา','1349901584707',1,'',9,1,1,2562,'3341500526446','2018-08-17'),(82,'695',6,'เด็กชาย','สิทธิพล','อาจสาลี','1342200163491',1,'',8,1,0,NULL,'1349900490091','2018-08-17'),(83,'696',7,'เด็กหญิง','ขวัญข้าว','สุวรรณศิล','1349901982494',2,'',8,1,0,0,'1349900490091','2018-08-17'),(84,'677',4,'เด็กหญิง','นภัสสร','สาระนัน','1342200158233',2,'',9,1,1,2566,'3341500526446','2018-08-17'),(85,'675',2,'เด็กชาย','สุรศักดิ์','คำโสภา','1342200157130',1,'',9,1,1,2566,'3349800244567','2018-08-17'),(135,'738',3,'เด็กหญิง','ณภารัตน์','สุวรรณะเพ็ญ','1342200167933',2,'',4,1,0,NULL,'1349900490091','2022-05-17'),(87,'698',8,'เด็กชาย','ฐิติศักดิ์','คำโสภา','1349902044889',1,'',8,1,0,NULL,'1349900490091','2018-08-20'),(88,'664',4,'เด็กหญิง','ณัฐณิชา','สุพันธมาต','1349901753070',2,'',9,1,1,2565,'3349900943319','2018-08-20'),(90,'710',5,'เด็กหญิง','สโรชา','บุญมานัน','1349901966448',2,'',9,1,0,NULL,'1349900490091','2019-05-28'),(91,'701',1,'เด็กชาย','ประวิทย์','ดวงงอก','1342200165477',1,'',7,1,0,NULL,'1349900490091','2019-05-29'),(162,'746',5,'เด็กหญิง','จารุพิชญา','ธรรมนาม','132900149818',2,'',4,1,0,NULL,'1349900490091','2024-12-03'),(95,'705',2,'เด็กชาย','จิรพนธ์','อินปากดี','1342200164632',1,'',7,1,0,NULL,'1349900490091','2019-05-29'),(96,'706',3,'เด็กหญิง','จิรัชญา','นามลี','1341501584699',2,'',7,1,0,NULL,'1349900490091','2019-05-29'),(97,'707',4,'เด็กหญิง','จรรยพร','พรรณลา','1349902081911',2,'',7,1,0,0,'1349900490091','2019-05-29'),(111,'700',3,'เด็กหญิง','ปิยะฉัตร','เจริญทัศน์','1331800037959',2,'',9,1,0,NULL,'1349900490091','2019-07-03'),(99,'709',4,'เด็กหญิง','กษมา','วรรณเวช','1342200162303',2,'',9,1,0,NULL,'1349900490091','2019-05-29'),(100,'711',9,'เด็กหญิง','ณัฐชยา','หล่าอุดม','1850400131502',2,'',8,1,0,NULL,'1349900490091','2019-05-29'),(102,'679',2,'เด็กชาย','ทวีวัฒน์','บัวเเก้ว','1342200159981',1,'',9,1,1,2567,'1349900490091','2019-05-29'),(103,'680',3,'เด็กชาย','ธีรพล','ไชยหงส์','1348900309299',1,'',9,1,1,2567,'1349900490091','2019-05-29'),(105,'682',5,'เด็กหญิง','ดาริน','พันธมาต','1909803386598',2,'',9,1,1,2567,'1349900490091','2019-05-29'),(107,'665',5,'เด็กหญิง','สุภาพร','สีลากุล','1409600489861',2,'',9,1,1,2565,'3349900943319','2019-05-29'),(108,'669',10,'เด็กหญิง','สุกัญญา','สัมพันเพ็ง','1218500043462',2,'',9,1,1,2565,'3349900943319','2019-05-29'),(109,'712',10,'เด็กชาย','พุทธคุณ','มังคะการ','1349901994905',1,'',8,1,0,NULL,'1349900490091','2019-06-12'),(172,'781',7,'เด็กหญิง','สุพรรณสา','ทองแท้','1601001142279',2,'',7,1,0,NULL,'1349900490091','2025-05-16'),(114,'716',1,'เด็กชาย','ธนภัทร','สีดาล้อม','1342200166074',1,'',6,1,0,NULL,'1349900490091','2020-07-07'),(115,'717',2,'เด็กชาย','ธนวินท์','หล่าอุดม','1859400045566',1,'',6,1,0,NULL,'1349900490091','2020-07-07'),(116,'718',3,'เด็กชาย','นฤบดินทร์','ปลื้มจิตร์','1341501596221',1,'',6,1,0,NULL,'1349900490091','2020-07-07'),(117,'720',4,'เด็กชาย','ศักรินทร์','สุขอินทร์','1349902157501',1,'',6,1,0,NULL,'1349900490091','2020-07-07'),(160,'761',5,'เด็กชาย','ธนดล','เอมโอษฐ์','1346400005043',1,'',2,1,0,NULL,'1349900490091','2024-05-27'),(119,'721',6,'เด็กหญิง','อรวรรณ','พรมจันทร์','1342200166643',2,'',6,1,0,NULL,'1349900490091','2020-07-07'),(120,'719',7,'เด็กหญิง','พรวิภาดา','ตรงเมธี','1349902166925',2,'',6,1,0,NULL,'1349900490091','2020-07-07'),(123,'724',6,'เด็กชาย','ธนะเทพ','นามโคตร','1308900050694',1,'',9,1,1,2566,'3349900943319','2020-07-07'),(136,'739',2,'เด็กหญิง','จิรณัฐ','สืบสีมา','1349902230194',2,'',4,1,0,NULL,'1349900490091','2022-05-17'),(128,'730',5,'เด็กชาย','ยุทธนา','ชูแสง','1349902131056',1,'',6,1,0,NULL,'1349900490091','2020-11-30'),(131,'734',8,'เด็กหญิง','เอมอร','ศิระพรหม','1349902119382',2,'',6,1,0,NULL,'1349900490091','2021-06-17'),(132,'731',3,'เด็กหญิง','ปภาวรินทร์','สุพันธมาต','1101501618722',2,'',5,1,0,NULL,'1349900490091','2021-06-17'),(133,'732',1,'เด็กหญิง','กมลทิพย์','พวงจำปา','1341501622604',2,'',5,1,0,NULL,'1349900490091','2021-06-17'),(134,'733',2,'เด็กหญิง','กมลรัตน์','แพไธสง','1311300128696',2,'',5,1,0,NULL,'1349900490091','2021-06-17'),(137,'740',1,'เด็กชาย','ชนาธิป','จันทาโทอ่อน','1341501628025',1,'',4,1,0,NULL,'1349900490091','2022-05-17'),(148,'751',2,'เด็กชาย','ธนกร','พรมจันทร์','1341501653071',1,'',3,1,0,NULL,'1349900490091','2023-05-16'),(139,'742',4,'เด็กหญิง','ศรัญญา','พงศ์ประเสริฐ','1341501642737',2,'',4,1,0,NULL,'1349900490091','2022-05-17'),(140,'744',4,'เด็กหญิง','จันทร์จิรา','สิงห์แจ่ม','1342200167054',2,'',5,1,0,NULL,'1349900490091','2022-05-17'),(141,'745',5,'เด็กชาย','ธนกฤต','สุ่มมาตย์','1342200167267',1,'',5,1,0,NULL,'1349900490091','2022-05-17'),(147,'750',1,'เด็กชาย','ธีธิธร','คำจันลา','1209703340187',1,'',3,1,0,NULL,'1349900490091','2023-05-16'),(143,'743',9,'เด็กหญิง','อรดา','คุณเวียญ','1102004803654',2,'',6,1,0,NULL,'1349900490091','2022-05-19'),(144,'747',11,'เด็กชาย','พสิษฐ์','มาตมุนโท','1102004616781',1,'',8,1,0,NULL,'1349900490091','2022-05-25'),(149,'752',3,'เด็กชาย','ธนโชติ','อาจสาลี','1342200169448',1,'',3,1,0,NULL,'1349900490091','2023-05-16'),(150,'753',4,'เด็กชาย','ธนภัทร์','โพธิจักร์','1209001139309',1,'',3,1,0,NULL,'1349900490091','2023-05-16'),(151,'754',5,'เด็กหญิง','ธัญนิศญาน์','ขาวประเสริฐ','1341501652562',2,'',3,1,0,NULL,'1349900490091','2023-05-16'),(152,'708',5,'เด็กหญิง','วิราตรี','ไมตรีพันธ์','1349902099144',2,'',7,1,0,NULL,'1349900490091','2023-05-19'),(161,'729',6,'เด็กชาย','กฤษฎา','ทำสะอาด','1348900287864',1,'',9,1,0,NULL,'1349900490091','2024-11-15'),(155,'713',8,'เด็กหญิง','สุชาดา','กล้าหาญ','1349902072475',2,'',7,1,0,NULL,'1349900490091','2024-01-08'),(156,'757',1,'เด็กหญิง','ชุติมา  ','พันธมาต','1342200170454',2,'',2,1,0,NULL,'1349900490091','2024-05-16'),(157,'758',2,'เด็กหญิง','ณิชาภา','พระกะทำ','1349902353164',2,'',2,1,0,NULL,'1349900490091','2024-05-16'),(158,'759',3,'เด็กหญิง','พัชรพร ','บาทสุวรรณ์','1349902358671',2,'',2,1,0,NULL,'1349900490091','2024-05-16'),(159,'760',4,'เด็กหญิง','เปมิกา','ขอเหล็กกลาง','1346400012821',2,'',2,1,0,NULL,'1349900490091','2024-05-16'),(163,'762',7,'เด็กชาย','จิราวัฒน์','พุดพวง','1341501628335',1,'',4,1,0,NULL,'1349900490091','2024-12-13'),(164,'755',6,'เด็กหญิง','อภิสรา',' โพธิบา','1342200164772',2,'',7,1,0,NULL,'1349900490091','2024-12-19'),(165,'768',6,'เด็กชาย','รัชตะ','นาอุดม','1318300042658',1,'',2,1,0,NULL,'1349900490091','2025-05-15'),(166,'769',7,'เด็กชาย','ภูวดล','คำภานิล','1470801534946',1,'',2,1,0,NULL,'1349900490091','2025-05-15'),(167,'766',1,'เด็กชาย','ณัฐภูมิ  ','คำภานิล','1349902385759',1,'',1,1,0,NULL,'1349900490091','2025-05-15'),(168,'763',2,'เด็กหญิง','กนกกาญจน์   ','ดอนพลัด','1342200170756',2,'',1,1,0,NULL,'1349900490091','2025-05-15'),(169,'765',3,'เด็กหญิง','ณัฐธิดา','ก่ำเกี้ยง','1342200171256',2,'',1,1,0,NULL,'1349900490091','2025-05-15'),(170,'767',4,'เด็กหญิง','ธัญญาพร ','จันทสาร','1349902418436',2,'',1,1,0,NULL,'1349900490091','2025-05-15'),(173,'0',6,'เด็กหญิง','รุ่งทิวา','อินยาพงษ์','1103200490451',2,'',3,1,0,NULL,'1349900490091','2025-11-10');

--
-- 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=10 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

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

--
-- 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=600 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `student_main_classlog` VALUES (1,2561,'602',0,6,1,'3341500526446','2018-08-02'),(2,2561,'609',0,6,1,'3341500526446','2018-08-02'),(3,2561,'610',0,6,1,'3341500526446','2018-08-02'),(4,2561,'612',0,6,1,'3341500526446','2018-08-02'),(5,2561,'613',0,6,1,'3341500526446','2018-08-02'),(6,2561,'614',0,6,1,'3341500526446','2018-08-02'),(7,2561,'615',0,6,1,'3341500526446','2018-08-02'),(8,2561,'617',0,6,1,'3341500526446','2018-08-02'),(9,2561,'618',0,6,1,'3341500526446','2018-08-02'),(10,2560,'611',0,5,1,'3341500526446','2018-08-02'),(11,2560,'619',0,5,1,'3341500526446','2018-08-02'),(12,2560,'621',0,5,1,'3341500526446','2018-08-02'),(13,2560,'622',0,5,1,'3341500526446','2018-08-02'),(14,2560,'623',0,5,1,'3341500526446','2018-08-02'),(15,2560,'657',0,5,1,'3341500526446','2018-08-02'),(16,2560,'662',0,5,1,'3341500526446','2018-08-02'),(17,2560,'599',0,7,1,'3341500526446','2018-08-02'),(18,2560,'600',0,7,1,'3341500526446','2018-08-02'),(19,2560,'601',0,7,1,'3341500526446','2018-08-02'),(20,2560,'603',0,7,1,'3341500526446','2018-08-02'),(21,2560,'604',0,7,1,'3341500526446','2018-08-02'),(22,2561,'587',0,8,1,'3341500526446','2018-08-02'),(23,2561,'588',0,8,1,'3341500526446','2018-08-02'),(24,2561,'589',0,8,1,'3341500526446','2018-08-02'),(25,2561,'590',0,8,1,'3341500526446','2018-08-02'),(26,2561,'591',0,8,1,'3341500526446','2018-08-02'),(27,2561,'592',0,8,1,'3341500526446','2018-08-02'),(28,2561,'593',0,8,1,'3341500526446','2018-08-02'),(29,2561,'594',0,8,1,'3341500526446','2018-08-02'),(30,2561,'599',0,8,1,'3341500526446','2018-08-02'),(31,2561,'600',0,8,1,'3341500526446','2018-08-02'),(32,2561,'601',0,8,1,'3341500526446','2018-08-02'),(33,2561,'603',0,8,1,'3341500526446','2018-08-02'),(34,2561,'604',0,8,1,'3341500526446','2018-08-02'),(35,2561,'605',0,8,1,'3341500526446','2018-08-02'),(36,2561,'657',0,8,1,'3341500526446','2018-08-02'),(57,2561,'621',0,9,1,'3349900943319','2019-05-27'),(38,2561,'581',0,9,1,'3341500526446','2018-08-02'),(39,2561,'583',0,9,1,'3341500526446','2018-08-02'),(40,2561,'584',0,9,1,'3341500526446','2018-08-02'),(41,2561,'585',0,9,1,'3341500526446','2018-08-02'),(42,2561,'653',0,9,1,'3341500526446','2018-08-02'),(43,2561,'664',0,9,1,'3341500526446','2018-08-02'),(44,2560,'627',0,3,1,'3341500526446','2018-08-02'),(45,2560,'629',0,3,1,'3341500526446','2018-08-02'),(46,2560,'640',0,3,1,'3341500526446','2018-08-02'),(47,2561,'626',0,3,1,'3341500526446','2018-08-02'),(48,2561,'628',0,3,1,'3341500526446','2018-08-02'),(49,2561,'630',0,3,1,'3341500526446','2018-08-02'),(50,2561,'644',0,3,1,'3341500526446','2018-08-02'),(51,2561,'645',0,3,1,'3341500526446','2018-08-02'),(52,2561,'652',0,3,1,'3341500526446','2018-08-02'),(53,2560,'642',0,3,1,'3341500526446','2018-08-02'),(54,2560,'643',0,3,1,'3341500526446','2018-08-02'),(55,2560,'646',0,3,1,'3341500526446','2018-08-02'),(56,2560,'649',0,3,1,'3341500526446','2018-08-02'),(58,2561,'622',0,9,1,'3349900943319','2019-05-27'),(59,2561,'623',0,9,1,'3349900943319','2019-05-27'),(60,2561,'696',0,2,1,'3349900943319','2019-05-27'),(61,2561,'697',0,2,1,'3349900943319','2019-05-27'),(62,2561,'688',1,2,1,'3349900943319','2019-05-27'),(63,2561,'689',2,2,1,'3349900943319','2019-05-27'),(64,2561,'690',3,2,1,'3349900943319','2019-05-27'),(65,2561,'691',4,2,1,'3349900943319','2019-05-27'),(66,2561,'692',5,2,1,'3349900943319','2019-05-27'),(67,2561,'693',6,2,1,'3349900943319','2019-05-27'),(68,2561,'694',7,2,1,'3349900943319','2019-05-27'),(69,2561,'695',8,2,1,'3349900943319','2019-05-27'),(70,2561,'685',1,3,1,'3349900943319','2019-05-27'),(71,2561,'686',2,3,1,'3349900943319','2019-05-27'),(72,2561,'687',3,3,1,'3349900943319','2019-05-27'),(73,2561,'674',1,4,1,'3349900943319','2019-05-27'),(74,2561,'675',2,4,1,'3349900943319','2019-05-27'),(75,2561,'676',3,4,1,'3349900943319','2019-05-27'),(76,2561,'677',4,4,1,'3349900943319','2019-05-27'),(77,2561,'684',5,4,1,'3349900943319','2019-05-27'),(78,2561,'666',0,5,1,'3349900943319','2019-05-27'),(79,2561,'668',0,5,1,'3349900943319','2019-05-27'),(80,2561,'671',0,5,1,'3349900943319','2019-05-27'),(81,2561,'658',1,5,1,'3349900943319','2019-05-27'),(82,2561,'667',2,5,1,'3349900943319','2019-05-27'),(83,2561,'661',3,5,1,'3349900943319','2019-05-27'),(84,2561,'663',4,5,1,'3349900943319','2019-05-27'),(85,2561,'698',5,5,1,'3349900943319','2019-05-27'),(86,2561,'642',0,6,1,'3349900943319','2019-05-27'),(87,2561,'643',0,6,1,'3349900943319','2019-05-27'),(88,2561,'646',0,6,1,'3349900943319','2019-05-27'),(89,2561,'648',0,6,1,'3349900943319','2019-05-27'),(90,2561,'649',0,6,1,'3349900943319','2019-05-27'),(91,2561,'655',0,6,1,'3349900943319','2019-05-27'),(92,2561,'659',0,6,1,'3349900943319','2019-05-27'),(93,2561,'627',1,7,1,'3349900943319','2019-05-27'),(94,2561,'629',2,7,1,'3349900943319','2019-05-27'),(95,2561,'640',3,7,1,'3349900943319','2019-05-27'),(96,2561,'633',0,8,1,'3349900943319','2019-05-27'),(97,2561,'634',0,8,1,'3349900943319','2019-05-27'),(98,2561,'635',0,8,1,'3349900943319','2019-05-27'),(99,2561,'637',0,8,1,'3349900943319','2019-05-27'),(100,2561,'638',0,8,1,'3349900943319','2019-05-27'),(101,2561,'639',0,8,1,'3349900943319','2019-05-27'),(102,2561,'699',5,9,0,'3349900943319','2019-05-27'),(103,2561,'619',0,9,1,'3349900943319','2019-05-27'),(104,2561,'620',0,9,1,'3349900943319','2019-05-27'),(105,2562,'2147483',0,2,1,'3349800244567','2019-09-30'),(106,2562,'712',0,2,1,'3349900943319','2019-11-19'),(107,2562,'713',0,2,1,'3349900943319','2019-11-19'),(108,2562,'714',0,2,1,'3349900943319','2019-11-19'),(109,2562,'1',1,2,1,'3341500526446','2019-11-19'),(110,2562,'2',2,2,1,'3341500526446','2019-11-19'),(111,2562,'3',3,2,1,'3341500526446','2019-11-19'),(112,2562,'4',4,2,1,'3341500526446','2019-11-19'),(113,2562,'5',5,2,1,'3341500526446','2019-11-19'),(114,2562,'6',6,2,1,'3341500526446','2019-11-19'),(115,2562,'7',7,2,1,'3341500526446','2019-11-19'),(116,2562,'8',8,2,1,'3341500526446','2019-11-19'),(117,2562,'9',1,3,1,'3341500526446','2019-11-19'),(118,2562,'10',2,3,1,'3341500526446','2019-11-19'),(119,2562,'11',3,3,1,'3341500526446','2019-11-19'),(120,2562,'12',5,5,1,'3341500526446','2019-11-19'),(121,2562,'13',1,6,1,'3341500526446','2019-11-19'),(122,2562,'14',2,6,1,'3341500526446','2019-11-19'),(123,2562,'15',3,6,1,'3341500526446','2019-11-19'),(124,2562,'0',5,6,1,'3341500526446','2019-11-19'),(125,2562,'662',3,6,1,'3341500526446','2019-11-19'),(126,2562,'661',2,6,1,'3341500526446','2019-11-19'),(127,2562,'670',1,6,1,'3341500526446','2019-11-19'),(128,2562,'687',5,5,1,'3341500526446','2019-11-19'),(129,2562,'688',3,3,1,'3341500526446','2019-11-19'),(130,2562,'685',2,3,1,'3341500526446','2019-11-19'),(131,2562,'684',1,4,1,'1330700123801','2020-10-27'),(132,2562,'696',8,2,1,'3341500526446','2019-11-19'),(133,2562,'695',7,2,1,'3341500526446','2019-11-19'),(134,2562,'694',6,2,1,'3341500526446','2019-11-19'),(135,2562,'693',5,2,1,'3341500526446','2019-11-19'),(136,2562,'692',4,2,1,'3341500526446','2019-11-19'),(137,2562,'691',3,2,1,'3341500526446','2019-11-19'),(138,2562,'690',2,2,1,'3341500526446','2019-11-19'),(139,2562,'689',1,2,1,'3341500526446','2019-11-19'),(140,2562,'698',0,2,1,'3341500526446','2019-11-19'),(141,2562,'697',0,2,1,'3341500526446','2019-11-19'),(142,2562,'664',5,6,1,'3341500526446','2019-11-19'),(143,2562,'701',1,1,1,'3349900943319','2020-05-19'),(144,2562,'702',2,1,1,'3349900943319','2020-05-19'),(145,2562,'703',3,1,1,'3349900943319','2020-05-19'),(146,2562,'704',4,1,1,'3349900943319','2020-05-19'),(147,2562,'705',5,1,1,'3349900943319','2020-05-19'),(148,2562,'706',6,1,1,'3349900943319','2020-05-19'),(149,2562,'707',7,1,1,'3349900943319','2020-05-19'),(150,2562,'633',0,9,1,'3349900943319','2020-05-19'),(151,2562,'634',0,9,1,'3349900943319','2020-05-19'),(152,2562,'635',0,9,1,'3349900943319','2020-05-19'),(153,2562,'637',0,9,1,'3349900943319','2020-05-19'),(154,2562,'638',0,9,1,'3349900943319','2020-05-19'),(155,2562,'639',0,9,1,'3349900943319','2020-05-19'),(156,2562,'627',1,8,1,'3349900943319','2020-05-19'),(157,2562,'629',2,8,1,'3349900943319','2020-05-19'),(158,2562,'640',3,8,1,'3349900943319','2020-05-19'),(159,2562,'642',0,7,1,'3349900943319','2020-05-19'),(160,2562,'643',0,7,1,'3349900943319','2020-05-19'),(161,2562,'646',0,7,1,'3349900943319','2020-05-19'),(162,2562,'648',0,7,1,'3349900943319','2020-05-19'),(163,2562,'649',0,7,1,'3349900943319','2020-05-19'),(164,2562,'655',0,7,1,'3349900943319','2020-05-19'),(165,2562,'659',0,7,1,'3349900943319','2020-05-19'),(166,2562,'645',5,7,1,'3349900943319','2020-05-19'),(167,2562,'669',10,6,1,'3349900943319','2020-05-19'),(168,2562,'665',0,6,1,'3349900943319','2020-05-19'),(169,2562,'666',0,6,1,'3349900943319','2020-05-19'),(170,2562,'668',0,6,1,'3349900943319','2020-05-19'),(171,2562,'671',0,6,1,'3349900943319','2020-05-19'),(172,2562,'663',4,6,1,'3349900943319','2020-05-19'),(173,2562,'711',0,2,1,'3349900943319','2020-05-19'),(174,2562,'700',0,3,1,'3349900943319','2020-05-19'),(175,2562,'709',0,3,1,'3349900943319','2020-05-19'),(176,2562,'710',0,3,1,'3349900943319','2020-05-19'),(177,2562,'678',1,4,1,'3349900943319','2020-05-19'),(178,2562,'679',2,4,1,'3349900943319','2020-05-19'),(179,2562,'680',3,4,1,'3349900943319','2020-05-19'),(180,2562,'681',4,4,1,'3349900943319','2020-05-19'),(181,2562,'682',5,4,1,'3349900943319','2020-05-19'),(182,2562,'683',6,4,1,'3349900943319','2020-05-19'),(183,2562,'674',1,5,1,'3349900943319','2020-05-19'),(184,2562,'675',2,5,1,'3349900943319','2020-05-19'),(185,2562,'676',3,5,1,'3349900943319','2020-05-19'),(186,2562,'677',4,5,1,'3349900943319','2020-05-19'),(187,2563,'701',1,2,1,'1342200067581','2020-07-13'),(188,2563,'702',2,2,1,'1349900490091','2020-07-17'),(189,2563,'674',1,6,1,'1342200067581','2020-07-13'),(190,2563,'703',3,2,1,'1342200067581','2020-07-13'),(191,2563,'707',6,2,1,'3349900943319','2021-04-07'),(231,2563,'725',12,3,1,'1349900490091','2020-07-15'),(193,2563,'705',4,2,1,'3349900943319','2021-04-07'),(194,2563,'706',5,2,1,'3349900943319','2021-04-07'),(195,2563,'669',10,7,1,'1342200067581','2020-07-13'),(196,2563,'645',3,8,1,'1342200067581','2020-07-13'),(197,2563,'642',1,8,1,'1342200067581','2020-07-13'),(198,2563,'643',2,8,1,'1342200067581','2020-07-13'),(199,2563,'646',4,8,1,'1342200067581','2020-07-13'),(200,2563,'648',5,8,1,'1342200067581','2020-07-13'),(201,2563,'659',8,8,1,'1342200067581','2020-07-13'),(202,2563,'649',6,8,1,'1342200067581','2020-07-13'),(203,2563,'655',7,8,1,'1342200067581','2020-07-13'),(204,2563,'662',2,7,1,'1342200067581','2020-07-13'),(205,2563,'661',1,7,1,'1342200067581','2020-07-13'),(206,2563,'663',3,7,1,'1342200067581','2020-07-13'),(207,2563,'664',4,7,1,'1342200067581','2020-07-13'),(208,2563,'665',5,7,1,'1342200067581','2020-07-13'),(209,2563,'666',6,7,1,'1342200067581','2020-07-13'),(210,2563,'668',7,7,1,'1342200067581','2020-07-13'),(211,2563,'670',8,7,1,'1342200067581','2020-07-13'),(212,2563,'671',9,7,1,'1342200067581','2020-07-13'),(213,2563,'676',3,6,1,'1342200067581','2020-07-13'),(214,2563,'700',4,4,1,'1342200067581','2020-07-13'),(215,2563,'709',5,4,1,'1330700123801','2020-12-08'),(216,2563,'710',6,4,1,'1349900490091','2020-07-17'),(257,2563,'0',11,7,1,'1349900490091','2020-07-16'),(218,2563,'698',9,3,1,'1349900490091','2020-07-15'),(219,2563,'711',10,3,1,'1349900490091','2020-07-15'),(220,2563,'712',11,3,1,'1349900490091','2020-07-15'),(221,2563,'715',8,2,1,'3349900943319','2021-04-07'),(222,2563,'714',1,1,1,'3349900943319','2020-07-13'),(223,2563,'716',2,1,1,'1342200067581','2020-07-13'),(224,2563,'717',3,1,1,'1342200067581','2020-07-13'),(258,2563,'723',9,8,1,'1349900490091','2020-07-15'),(226,2563,'720',5,1,1,'1342200067581','2020-07-13'),(227,2563,'722',7,1,1,'1342200067581','2020-07-13'),(228,2563,'721',8,1,1,'3349900943319','2020-07-13'),(229,2563,'719',9,1,1,'1342200067581','2020-07-13'),(230,2563,'713',7,2,1,'3349900943319','2021-04-07'),(232,2563,'724',6,6,1,'1342200067581','2020-07-13'),(233,2563,'718',4,1,1,'1342200067581','2020-07-13'),(234,2563,'696',8,3,1,'1342200067581','2020-07-13'),(235,2563,'689',1,3,1,'1342200067581','2020-07-13'),(236,2563,'690',2,3,1,'1342200067581','2020-07-13'),(237,2563,'691',3,3,1,'1342200067581','2020-07-13'),(238,2563,'692',4,3,1,'3349900943319','2020-07-24'),(239,2563,'693',5,3,1,'1342200067581','2020-07-13'),(240,2563,'694',6,3,1,'1342200067581','2020-07-13'),(241,2563,'695',7,3,1,'1342200067581','2020-07-13'),(242,2563,'684',1,4,1,'1342200067581','2020-07-13'),(243,2563,'685',2,4,1,'1342200067581','2020-07-13'),(244,2563,'688',3,4,1,'1342200067581','2020-07-13'),(245,2563,'678',1,5,1,'1342200067581','2020-07-13'),(246,2563,'679',2,5,1,'1342200067581','2020-07-13'),(247,2563,'680',3,5,1,'1342200067581','2020-07-13'),(248,2563,'681',4,5,1,'1342200067581','2020-07-13'),(249,2563,'682',5,5,1,'1342200067581','2020-07-13'),(250,2563,'683',6,5,1,'1342200067581','2020-07-13'),(251,2563,'675',2,6,1,'1342200067581','2020-07-13'),(252,2563,'677',4,6,1,'1342200067581','2020-07-13'),(253,2563,'687',5,6,1,'1342200067581','2020-07-13'),(254,2563,'627',1,9,1,'1342200067581','2020-07-13'),(255,2563,'629',2,9,1,'1342200067581','2020-07-13'),(256,2563,'640',3,9,1,'1342200067581','2020-07-13'),(259,2563,'726',10,2,1,'1349900490091','2021-04-05'),(260,2563,'727',11,7,1,'3349900943319','2020-07-24'),(261,2562,'728',8,2,1,'1349900490091','2020-11-03'),(262,2562,'729',7,4,1,'1349900490091','2020-11-02'),(263,2562,'730',11,1,1,'1349900490091','2020-11-30'),(264,2563,'729',7,4,1,'3349900943319','2021-04-30'),(265,2563,'730',11,1,1,'3349900943319','2021-04-30'),(266,2564,'705',4,3,1,'3349900943319','2021-05-11'),(267,2564,'693',5,4,1,'3349900943319','2021-05-11'),(268,2564,'726',9,3,1,'3349900943319','2021-05-11'),(269,2564,'730',6,2,1,'3349900943319','2021-05-11'),(270,2564,'735',7,6,1,'1349900490091','2021-06-17'),(271,2564,'736',8,6,1,'3341500526446','2021-06-21'),(272,2564,'734',10,2,1,'1349900490091','2021-06-17'),(273,2564,'731',1,1,1,'1349900490091','2021-06-17'),(274,2564,'732',2,1,1,'1349900490091','2021-06-17'),(275,2564,'733',3,1,1,'1349900490091','2021-06-17'),(276,2564,'694',6,4,1,'1330700123801','2021-07-15'),(277,2564,'649',6,9,1,'1349900490091','2021-10-04'),(278,2564,'676',3,7,1,'1349900490091','2021-10-07'),(279,2564,'729',7,5,1,'1349900490091','2022-01-19'),(280,2564,'696',8,4,1,'1330700123801','2022-03-23'),(281,2564,'642',1,9,1,'1330700123801','2022-03-31'),(282,2564,'643',2,9,1,'3349900943319','2022-03-31'),(283,2564,'645',3,9,1,'3349900943319','2022-03-31'),(284,2564,'646',4,9,1,'3349900943319','2022-03-31'),(285,2564,'648',5,9,1,'3349900943319','2022-03-31'),(286,2564,'655',7,9,1,'3349900943319','2022-03-31'),(287,2564,'659',8,9,1,'3349900943319','2022-03-31'),(288,2564,'723',9,9,1,'3349900943319','2022-03-31'),(289,2564,'714',1,2,1,'3349900943319','2022-04-18'),(290,2564,'716',2,2,1,'3349900943319','2022-04-18'),(291,2564,'717',3,2,1,'3349900943319','2022-04-18'),(292,2564,'718',4,2,1,'3349900943319','2022-04-18'),(293,2564,'720',5,2,1,'3349900943319','2022-04-18'),(294,2564,'722',7,2,1,'3349900943319','2022-04-18'),(295,2564,'721',8,2,1,'3349900943319','2022-04-18'),(296,2564,'719',9,2,1,'3349900943319','2022-04-18'),(297,2564,'701',1,3,1,'3349900943319','2022-04-18'),(298,2564,'702',2,3,1,'3349900943319','2022-04-18'),(299,2564,'703',3,3,1,'3349900943319','2022-04-18'),(300,2564,'706',5,3,1,'3349900943319','2022-04-18'),(301,2564,'707',6,3,1,'3349900943319','2022-04-18'),(302,2564,'713',7,3,1,'3349900943319','2022-04-18'),(303,2564,'715',8,3,1,'3349900943319','2022-04-18'),(304,2564,'689',1,4,1,'3349900943319','2022-04-18'),(305,2564,'690',2,4,1,'3349900943319','2022-04-18'),(306,2564,'691',3,4,1,'3349900943319','2022-04-18'),(307,2564,'692',4,4,1,'3349900943319','2022-04-18'),(308,2564,'695',7,4,1,'3349900943319','2022-04-18'),(309,2564,'698',9,4,1,'3349900943319','2022-04-18'),(310,2564,'711',10,4,1,'3349900943319','2022-04-18'),(311,2564,'712',11,4,1,'3349900943319','2022-04-18'),(312,2564,'725',12,4,1,'3349900943319','2022-04-18'),(313,2564,'684',1,5,1,'3349900943319','2022-04-18'),(314,2564,'685',2,5,1,'3349900943319','2022-04-18'),(315,2564,'688',3,5,1,'3349900943319','2022-04-18'),(316,2564,'700',4,5,1,'3349900943319','2022-04-18'),(317,2564,'709',5,5,1,'3349900943319','2022-04-18'),(318,2564,'710',6,5,1,'3349900943319','2022-04-18'),(319,2564,'678',1,6,1,'3349900943319','2022-04-18'),(320,2564,'679',2,6,1,'3349900943319','2022-04-18'),(321,2564,'680',3,6,1,'3349900943319','2022-04-18'),(322,2564,'681',4,6,1,'3349900943319','2022-04-18'),(323,2564,'682',5,6,1,'3349900943319','2022-04-18'),(324,2564,'675',2,7,1,'3349900943319','2022-04-18'),(325,2564,'677',4,7,1,'3349900943319','2022-04-18'),(326,2564,'687',5,7,1,'3349900943319','2022-04-18'),(327,2564,'724',6,7,1,'3349900943319','2022-04-18'),(328,2564,'661',1,8,1,'3349900943319','2022-04-18'),(329,2564,'662',2,8,1,'3349900943319','2022-04-18'),(330,2564,'663',3,8,1,'3349900943319','2022-04-18'),(331,2564,'664',4,8,1,'3349900943319','2022-04-18'),(332,2564,'665',5,8,1,'3349900943319','2022-04-18'),(333,2564,'666',6,8,1,'3349900943319','2022-04-18'),(334,2564,'668',7,8,1,'3349900943319','2022-04-18'),(335,2564,'670',8,8,1,'3349900943319','2022-04-18'),(336,2564,'671',9,8,1,'3349900943319','2022-04-18'),(337,2564,'669',10,8,1,'3349900943319','2022-04-18'),(338,2565,'732',1,2,1,'3349900943319','2022-04-18'),(339,2565,'733',2,2,1,'3349900943319','2022-04-18'),(340,2565,'680',3,7,1,'3349900943319','2022-04-18'),(341,2565,'679',2,7,1,'3349900943319','2022-04-18'),(342,2565,'681',4,7,1,'3349900943319','2022-04-18'),(343,2565,'682',5,7,1,'3349900943319','2022-04-18'),(344,2565,'683',6,7,1,'3349900943319','2022-04-18'),(345,2565,'735',7,7,1,'3349900943319','2022-04-18'),(346,2565,'736',8,7,1,'3349900943319','2022-04-18'),(347,2565,'674',1,8,1,'3349900943319','2022-04-18'),(348,2565,'731',3,2,1,'3349900943319','2022-04-18'),(349,2565,'738',5,1,1,'1330700123801','2022-05-20'),(350,2565,'739',3,1,1,'1330700123801','2022-05-20'),(351,2565,'740',1,1,1,'1330700123801','2022-05-20'),(352,2565,'741',4,1,1,'1349900490091','2022-05-17'),(353,2565,'742',6,1,1,'1349900490091','2022-11-07'),(354,2565,'744',4,2,1,'1349900490091','2022-05-17'),(355,2565,'0',8,1,0,'1349900490091','2022-11-01'),(356,2565,'746',2,1,1,'1330700123801','2022-05-20'),(357,2565,'743',11,3,1,'1349900490091','2022-05-19'),(358,2565,'747',13,5,1,'1349900490091','2022-05-25'),(359,2565,'748',7,1,1,'1349900490091','2022-06-02'),(360,2565,'745',5,2,1,'3349900943319','2022-06-07'),(361,2565,'750',8,1,1,'1349900490091','2022-11-02'),(362,2565,'685',2,6,1,'1349900490091','2023-03-27'),(363,2565,'688',3,6,1,'1349900490091','2023-03-27'),(364,2565,'700',4,6,1,'1349900490091','2023-03-27'),(365,2565,'709',5,6,1,'1349900490091','2023-03-27'),(366,2565,'710',6,6,1,'1349900490091','2023-03-27'),(367,2565,'729',7,6,1,'1349900490091','2023-03-27'),(368,2565,'678',1,7,1,'1349900490091','2023-03-27'),(369,2565,'675',2,8,1,'1349900490091','2023-03-27'),(370,2565,'676',3,8,1,'1349900490091','2023-03-27'),(371,2565,'677',4,8,1,'1349900490091','2023-03-27'),(372,2565,'687',5,8,1,'1349900490091','2023-03-27'),(373,2565,'724',6,8,1,'1349900490091','2023-03-27'),(374,2565,'661',1,9,1,'1349900490091','2023-03-27'),(375,2565,'662',2,9,1,'1349900490091','2023-03-27'),(376,2565,'663',3,9,1,'1349900490091','2023-03-27'),(377,2565,'664',4,9,1,'1349900490091','2023-03-27'),(378,2565,'665',5,9,1,'1349900490091','2023-03-27'),(379,2565,'666',6,9,1,'1349900490091','2023-03-27'),(380,2565,'668',7,9,1,'1349900490091','2023-03-27'),(381,2565,'670',8,9,1,'1349900490091','2023-03-27'),(382,2565,'671',9,9,1,'1349900490091','2023-03-27'),(383,2565,'669',10,9,1,'1349900490091','2023-03-27'),(384,2565,'707',6,4,1,'1349900490091','2023-04-07'),(385,2565,'696',8,5,1,'1349900490091','2023-04-07'),(386,2565,'714',1,3,1,'1349900490091','2023-04-07'),(387,2565,'716',2,3,1,'1349900490091','2023-04-07'),(388,2565,'717',3,3,1,'1349900490091','2023-04-07'),(389,2565,'718',4,3,1,'1349900490091','2023-04-07'),(390,2565,'720',5,3,1,'1349900490091','2023-04-07'),(391,2565,'730',6,3,1,'1349900490091','2023-04-07'),(392,2565,'722',7,3,1,'1349900490091','2023-04-07'),(393,2565,'721',8,3,1,'1349900490091','2023-04-07'),(394,2565,'719',9,3,1,'1349900490091','2023-04-07'),(395,2565,'734',10,3,1,'1349900490091','2023-04-07'),(396,2565,'701',1,4,1,'1349900490091','2023-04-07'),(397,2565,'702',2,4,1,'1349900490091','2023-04-07'),(398,2565,'703',3,4,1,'1349900490091','2023-04-07'),(399,2565,'705',4,4,1,'1349900490091','2023-04-07'),(400,2565,'706',5,4,1,'1349900490091','2023-04-07'),(401,2565,'713',7,4,1,'1349900490091','2023-04-07'),(402,2565,'715',8,4,1,'1349900490091','2023-04-07'),(403,2565,'690',2,5,1,'1349900490091','2023-04-07'),(404,2565,'691',3,5,1,'1349900490091','2023-04-07'),(405,2565,'692',4,5,1,'1349900490091','2023-04-07'),(406,2565,'693',5,5,1,'1349900490091','2023-04-07'),(407,2565,'694',6,5,1,'1349900490091','2023-04-07'),(408,2565,'695',7,5,1,'1349900490091','2023-04-07'),(409,2565,'698',9,5,1,'1349900490091','2023-04-07'),(410,2565,'711',10,5,1,'1349900490091','2023-04-07'),(411,2565,'712',11,5,1,'1349900490091','2023-04-07'),(412,2565,'725',12,5,1,'1349900490091','2023-04-07'),(414,2566,'679',2,8,1,'1349900490091','2023-04-07'),(415,2566,'680',3,8,1,'1349900490091','2023-04-07'),(420,2566,'682',5,8,1,'1349900490091','2023-04-07'),(421,2566,'685',2,7,1,'1349900490091','2023-04-07'),(422,2566,'688',3,7,1,'1349900490091','2023-04-07'),(423,2566,'700',4,7,1,'1349900490091','2023-04-07'),(424,2566,'710',6,7,1,'1349900490091','2023-04-07'),(425,2566,'709',5,7,1,'1349900490091','2023-04-07'),(426,2566,'729',7,7,1,'1349900490091','2023-04-07'),(427,2566,'721',8,4,1,'1349900490091','2023-04-07'),(428,2566,'719',9,4,1,'1349900490091','2023-04-07'),(429,2566,'734',10,4,1,'1349900490091','2023-04-07'),(430,2566,'743',11,4,1,'1349900490091','2023-04-07'),(431,2566,'722',7,4,1,'1349900490091','2023-04-07'),(432,2566,'730',6,4,1,'1349900490091','2023-04-07'),(433,2566,'742',6,2,1,'1349900490091','2023-04-07'),(434,2566,'720',5,4,1,'1349900490091','2023-04-07'),(435,2566,'748',7,2,1,'1349900490091','2023-04-07'),(436,2566,'738',5,2,1,'1349900490091','2023-04-07'),(453,2566,'751',1,1,1,'1330700123801','2023-12-18'),(438,2566,'718',4,4,1,'1349900490091','2023-04-07'),(439,2566,'739',3,2,1,'1349900490091','2023-04-07'),(440,2566,'717',3,4,1,'1349900490091','2023-04-07'),(441,2566,'732',1,3,1,'1349900490091','2023-04-07'),(442,2566,'733',2,3,1,'1349900490091','2023-04-07'),(443,2566,'731',3,3,1,'1349900490091','2023-04-07'),(444,2566,'745',5,3,1,'1349900490091','2023-04-07'),(445,2566,'744',4,3,1,'1349900490091','2023-04-07'),(446,2566,'714',1,4,1,'1349900490091','2023-04-07'),(447,2566,'716',2,4,1,'1349900490091','2023-04-07'),(452,2566,'0',8,5,1,'1349900490091','2023-12-21'),(449,2566,'750',8,2,1,'1330700123801','2023-12-18'),(450,2566,'684',1,7,1,'1349900490091','2023-04-07'),(451,2566,'740',1,2,1,'1349900490091','2024-01-09'),(454,2566,'752',2,1,1,'1330700123801','2023-12-18'),(455,2566,'753',3,1,1,'1330700123801','2023-12-18'),(456,2566,'754',4,1,1,'1330700123801','2023-12-18'),(457,2566,'755',5,1,1,'1330700123801','2023-12-18'),(458,2566,'708',7,5,1,'1349900490091','2023-12-21'),(461,2566,'749',8,2,1,'1330700123801','2023-12-18'),(462,2566,'756',8,5,1,'1349900490091','2023-12-21'),(463,2566,'713',9,5,1,'1349900490091','2024-03-06'),(464,2566,'690',2,6,1,'1349900490091','2024-05-16'),(465,2566,'691',3,6,1,'1349900490091','2024-05-16'),(466,2566,'692',4,6,1,'1349900490091','2024-05-16'),(467,2566,'693',5,6,1,'1349900490091','2024-05-16'),(468,2566,'694',6,6,1,'1349900490091','2024-05-16'),(469,2566,'695',7,6,1,'1349900490091','2024-05-16'),(470,2566,'696',8,6,1,'1349900490091','2024-05-16'),(471,2566,'698',9,6,1,'1349900490091','2024-05-16'),(472,2566,'711',10,6,1,'1349900490091','2024-05-16'),(473,2566,'712',11,6,1,'1349900490091','2024-05-16'),(474,2566,'725',12,6,1,'1349900490091','2024-05-16'),(475,2566,'747',13,6,1,'1349900490091','2024-05-16'),(476,2566,'701',1,5,1,'1349900490091','2024-05-16'),(477,2566,'702',2,5,1,'1349900490091','2024-05-16'),(478,2566,'703',3,5,1,'1349900490091','2024-05-16'),(479,2566,'705',4,5,1,'1349900490091','2024-05-16'),(480,2566,'706',5,5,1,'1349900490091','2024-05-16'),(481,2566,'707',6,5,1,'1349900490091','2024-05-16'),(482,2567,'757',1,2,1,'1349900490091','2025-05-15'),(483,2567,'0',5,1,0,'1349900490091','2024-05-27'),(484,2567,'759',3,2,1,'1349900490091','2025-05-15'),(485,2566,'674',1,9,1,'1349900490091','2024-05-16'),(486,2566,'675',2,9,1,'1349900490091','2024-05-16'),(487,2566,'676',3,9,1,'1349900490091','2024-05-16'),(488,2566,'677',4,9,1,'1349900490091','2024-05-16'),(489,2566,'687',5,9,1,'1349900490091','2024-05-16'),(490,2566,'724',6,9,1,'1349900490091','2024-05-16'),(491,2567,'758',2,2,1,'1349900490091','2025-05-15'),(492,2567,'760',4,2,1,'1349900490091','2025-05-15'),(493,2566,'757',1,1,0,'1349900490091','2024-05-16'),(494,2566,'758',2,1,0,'1349900490091','2024-05-16'),(495,2566,'759',3,1,0,'1349900490091','2024-05-16'),(496,2566,'760',4,1,0,'1349900490091','2024-05-16'),(497,2567,'709',5,8,1,'1330700123801','2024-05-17'),(498,2567,'710',6,9,1,'1349900490091','2025-05-15'),(499,2567,'700',4,9,1,'1349900490091','2025-05-15'),(500,2567,'688',3,8,1,'1330700123801','2024-05-17'),(501,2567,'685',2,9,1,'1349900490091','2025-05-15'),(502,2567,'684',1,9,1,'1349900490091','2025-05-15'),(503,2567,'747',13,8,1,'1349900490091','2025-05-15'),(504,2567,'712',11,8,1,'1349900490091','2025-05-15'),(505,2567,'711',10,8,1,'1349900490091','2025-05-15'),(506,2567,'698',9,8,1,'1349900490091','2025-05-15'),(507,2567,'696',8,8,1,'1349900490091','2025-05-15'),(508,2567,'695',7,8,1,'1349900490091','2025-05-15'),(509,2567,'691',3,8,1,'1349900490091','2025-05-15'),(510,2567,'694',6,8,1,'1349900490091','2025-05-15'),(511,2567,'693',5,8,1,'1349900490091','2025-05-15'),(512,2567,'690',2,8,1,'1349900490091','2025-05-15'),(513,2567,'692',4,7,1,'1330700123801','2024-05-17'),(514,2567,'751',2,3,1,'1349900490091','2025-05-15'),(515,2567,'752',3,3,1,'1349900490091','2025-05-15'),(516,2567,'753',4,3,1,'1349900490091','2025-05-15'),(517,2567,'754',5,3,1,'1349900490091','2025-05-15'),(518,2567,'755',8,7,1,'1349900490091','2025-05-15'),(519,2567,'740',1,4,1,'1349900490091','2025-05-15'),(520,2567,'739',2,4,1,'1349900490091','2025-05-15'),(521,2567,'750',1,3,1,'1349900490091','2025-05-15'),(522,2567,'738',3,4,1,'1349900490091','2025-05-15'),(523,2567,'742',4,4,1,'1349900490091','2025-05-15'),(524,2567,'748',6,4,1,'1349900490091','2025-05-15'),(525,2567,'732',1,5,1,'1349900490091','2025-05-15'),(526,2567,'733',2,5,1,'1349900490091','2025-05-15'),(527,2567,'745',5,5,1,'1349900490091','2025-05-15'),(528,2567,'744',4,5,1,'1349900490091','2025-05-15'),(529,2567,'731',3,5,1,'1349900490091','2025-05-15'),(530,2567,'756',8,6,1,'1330700123801','2024-05-17'),(531,2567,'708',7,7,1,'1349900490091','2025-05-15'),(532,2567,'707',6,6,1,'1330700123801','2024-05-17'),(533,2567,'706',5,7,1,'1349900490091','2025-05-15'),(534,2567,'703',3,7,1,'1349900490091','2025-05-15'),(535,2567,'705',4,7,1,'1349900490091','2025-05-15'),(536,2567,'701',1,7,1,'1349900490091','2025-05-15'),(537,2567,'743',11,6,1,'1349900490091','2025-05-15'),(538,2567,'721',8,6,1,'1349900490091','2025-05-15'),(539,2567,'714',1,6,1,'1349900490091','2025-05-15'),(540,2567,'716',2,6,1,'1349900490091','2025-05-15'),(541,2567,'717',3,6,1,'1349900490091','2025-05-15'),(542,2567,'718',4,6,1,'1349900490091','2025-05-15'),(543,2567,'730',6,6,1,'1349900490091','2025-05-15'),(544,2567,'720',5,6,1,'1349900490091','2025-05-15'),(545,2567,'719',9,6,1,'1349900490091','2025-05-15'),(546,2567,'734',10,6,1,'1349900490091','2025-05-15'),(547,2567,'713',9,7,1,'1349900490091','2025-05-15'),(548,2567,'761',5,2,1,'1349900490091','2025-05-15'),(549,2567,'729',7,9,1,'1349900490091','2025-05-15'),(550,2567,'746',5,4,1,'1349900490091','2025-05-15'),(551,2567,'726',8,3,1,'1349900490091','2024-12-13'),(552,2567,'749',7,4,1,'1349900490091','2025-05-15'),(553,2567,'762',8,4,1,'1349900490091','2025-05-15'),(554,2567,'679',2,9,1,'1349900490091','2025-05-15'),(555,2567,'680',3,9,1,'1349900490091','2025-05-15'),(556,2567,'682',5,9,1,'1349900490091','2025-05-15'),(557,2568,'707',4,7,1,'1349900490091','2025-05-16'),(558,2568,'692',3,8,1,'1349900490091','2025-05-16'),(559,2568,'688',2,9,1,'1349900490091','2025-05-16'),(560,2568,'709',4,9,1,'1349900490091','2025-05-16'),(561,2568,'768',6,2,1,'1349900490091','2025-05-15'),(562,2568,'0',6,3,1,'1349900490091','2025-11-10'),(563,2568,'766',1,1,1,'1349900490091','2025-05-15'),(564,2568,'763',2,1,1,'1349900490091','2025-05-15'),(565,2568,'765',3,1,1,'1349900490091','2025-05-15'),(566,2568,'767',4,1,1,'1349900490091','2025-05-15'),(567,2568,'769',7,2,1,'1349900490091','2025-05-22'),(568,2568,'781',7,7,1,'1349900490091','2025-05-16'),(569,2568,'705',2,7,1,'1349900490091','2025-05-16'),(570,2568,'706',3,7,1,'1349900490091','2025-05-16'),(571,2568,'708',5,7,1,'1349900490091','2025-05-16'),(572,2568,'755',6,7,1,'1349900490091','2025-05-16'),(573,2568,'749',6,4,1,'1349900490091','2025-05-16'),(574,2568,'762',7,4,1,'1349900490091','2025-05-16'),(575,2568,'716',1,6,1,'1349900490091','2025-05-16'),(576,2568,'717',2,6,1,'1349900490091','2025-05-16'),(577,2568,'718',3,6,1,'1349900490091','2025-05-16'),(578,2568,'720',4,6,1,'1349900490091','2025-05-16'),(579,2568,'730',5,6,1,'1349900490091','2025-05-16'),(580,2568,'721',6,6,1,'1349900490091','2025-05-16'),(581,2568,'719',7,6,1,'1349900490091','2025-05-16'),(582,2568,'734',8,6,1,'1349900490091','2025-05-16'),(583,2568,'743',9,6,1,'1349900490091','2025-05-16'),(584,2568,'713',8,7,1,'1349900490091','2025-05-16'),(585,2568,'690',1,8,1,'1349900490091','2025-05-16'),(586,2568,'691',2,8,1,'1349900490091','2025-05-16'),(587,2568,'693',4,8,1,'1349900490091','2025-05-16'),(588,2568,'694',5,8,1,'1349900490091','2025-05-16'),(589,2568,'695',6,8,1,'1349900490091','2025-05-16'),(590,2568,'696',7,8,1,'1349900490091','2025-05-16'),(591,2568,'698',8,8,1,'1349900490091','2025-05-16'),(592,2568,'711',9,8,1,'1349900490091','2025-05-16'),(593,2568,'712',10,8,1,'1349900490091','2025-05-16'),(594,2568,'747',11,8,1,'1349900490091','2025-05-16'),(595,2568,'685',1,9,1,'1349900490091','2025-05-16'),(596,2568,'700',3,9,1,'1349900490091','2025-05-16'),(597,2568,'710',5,9,1,'1349900490091','2025-05-16'),(598,2568,'729',6,9,1,'1349900490091','2025-05-16'),(599,2568,'780',5,1,1,'1349900490091','2025-05-22');

--
-- 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=12 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `student_main_edyear` VALUES (1,2557,0),(2,2561,0),(3,2562,0),(4,2563,0),(6,2564,0),(7,2565,0),(8,2566,0),(9,2567,0),(11,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=60 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `student_main_expand1` VALUES (1,'1342200165477','Prawit','dwnangok','2015-12-10','-','ไทย','ไทย','พุทธ','2020-07-13'),(2,'1342200165221','Tnisorn','padee','2015-10-14','-','ไทย','ไทย','พุทธ','2020-07-13'),(3,'1347600113932','nrid','kamnahom','2015-10-25','-','ไทย','ไทย','พุทธ','2020-07-13'),(4,'1342200164632','jirapon','inparkdee','2015-05-24','-','ไทย','ไทย','พุทธ','2020-07-13'),(5,'1341501584699','jirutchaya','namlee','2015-09-10','-','ไทย','ไทย','พุทธ','2020-07-13'),(6,'1349902081911','janyapon','punnala','2015-11-30','-','ไทย','ไทย','พุทธ','2020-07-13'),(7,'1260401290481','Pongsak','Sida','2015-01-05','-','ไทย','ไทย','พุทธ','2020-07-13'),(8,'1342200163857','RATCHANON','Wongs son','2014-12-06','-','ไทย','ไทย','พุทธ','2020-07-13'),(9,'1342200163491','sittiphon','artsaree','2014-09-26','-','ไทย','ไทย','พุทธ','2020-07-13'),(10,'1349902044889','thitisak','kansopa','2015-05-15','-','ไทย','ไทย','พุทธ','2020-07-13'),(11,'1102004616781','Pith','Mathamundo','2014-11-18','-','ไทย','ไทย','พุทธ','2020-07-13'),(12,'1349901994905','phutthakhoon','mangkhakan','2014-08-11','-','ไทย','ไทย','พุทธ','2020-07-13'),(13,'1648900198451','threerapuch','prommajan','2015-02-12','-','ไทย','ไทย','พุทธ','2020-07-13'),(14,'1200901765445','Hmm','Molinol','2014-12-08','-','ไทย','ไทย','พุทธ','2020-07-13'),(15,'1342200163610','sarisa','kamdoung','2014-10-24','-','ไทย','ไทย','พุทธ','2020-07-13'),(16,'1909804064006','payrin','punthamach','2014-09-11','-','ไทย','ไทย','พุทธ','2020-07-13'),(17,'1342200161668','autthawat','khamsopa','2013-10-09','-','ไทย','ไทย','พุทธ','2020-07-13'),(18,'1342200161447','witchakorn','thouwtoomma','2013-08-22','-','ไทย','ไทย','พุทธ','2020-07-13'),(19,'1342200161536','weerada','wisoonglae','2013-09-01','-','ไทย','ไทย','พุทธ','2020-07-13'),(20,'1331800037959','piyachat','jaroentad','2013-10-18','A','ไทย','ไทย','พุทธ','2020-07-13'),(21,'1342200162303','kasama','wannweat','2014-02-25','-','ไทย','ไทย','พุทธ','2020-07-13'),(22,'1349901966448','nattanan','bunmanan','2014-03-03','-','ไทย','ไทย','พุทธ','2020-07-13'),(23,'1349901850423','watcharaspol','donplad','2012-07-12','-','ไทย','ไทย','พุทธ','2020-07-13'),(24,'1342200159981','thaveewatch','bouwkeaw','2012-10-22','-','ไทย','ไทย','พุทธ','2020-07-13'),(25,'1348900309299','Threeraphol','chaiyahong','2013-04-01','-','ไทย','ไทย','พุทธ','2020-07-13'),(26,'1349901881981','julalak','khampoopool','2012-11-30','-','ไทย','ไทย','พุทธ','2020-07-13'),(27,'1347600079611','nuchthinee','soymaloon','2013-03-08','-','ไทย','ไทย','พุทธ','2020-07-13'),(28,'1347600064290','phatcharapol','phommajan','2012-01-24','-','ไทย','ไทย','พุทธ','2020-07-13'),(29,'1342200157130','surasak','kamshopha','2011-07-19','-','ไทย','ไทย','พุทธ','2020-07-13'),(30,'1348900277346','Rank','Kwang Yong','2012-03-16','-','ไทย','ไทย','พุทธ','2020-07-13'),(31,'1342200158233','napatsorn','saranan','2012-01-12','-','ไทย','ไทย','พุทธ','2020-07-13'),(32,'1349901744402','tanathep','pimwong','2011-01-12','-','ไทย','ไทย','พุทธ','2020-07-13'),(33,'1342200156567','teerachai','suebseema','2011-05-02','-','ไทย','ไทย','พุทธ','2020-07-13'),(34,'1342200154114','parnutda','doungngog','2010-06-04','-','ไทย','ไทย','พุทธ','2020-07-13'),(35,'1342200155170','jinjuta','thepwon','2010-10-26','-','ไทย','ไทย','พุทธ','2020-07-13'),(36,'1409600489861','supaporn','seerakool','2010-11-10','-','ไทย','ไทย','พุทธ','2020-07-13'),(37,'1342200155196','nada','peeree','2010-10-28','-','ไทย','ไทย','พุทธ','2020-07-13'),(38,'1347600045414','kavissara','suwannasil','2010-07-08','-','ไทย','ไทย','พุทธ','2020-07-13'),(39,'1342200154408','jarisha','phanlar','2010-07-20','-','ไทย','ไทย','พุทธ','2020-07-13'),(40,'1218500043462','sukanya','sumpunpeng','2010-09-04','-','ไทย','ไทย','พุทธ','2020-07-13'),(41,'1342200150917','RATHAPOOM','BOOTWONG','2009-05-24','-','ไทย','ไทย','พุทธ','2020-07-13'),(42,'1342200151522','SACHAT','SARANAN','2009-08-03','-','ไทย','ไทย','พุทธ','2020-07-13'),(43,'1342200152049','SUTHINAN','KAMPHANIN','2009-09-23','-','ไทย','ไทย','พุทธ','2020-07-13'),(44,'1718800146785','pongpituk','phunthamart','2010-03-22','-','ไทย','ไทย','พุทธ','2020-07-13'),(45,'1349901632591','KANOKWAN','SEANGJAN','2009-06-22','-','ไทย','ไทย','พุทธ','2020-07-13'),(46,'1342200151999','TREEPECH','PEUNJIT','2009-09-19','-','ไทย','ไทย','พุทธ','2020-07-13'),(47,'1349901660900','THANCHANOK','PHOMAJAN','2008-11-02','-','ไทย','ไทย','พุทธ','2020-07-13'),(48,'1342200152481','AISSARIYA','SUEBSEEMA','2009-10-15','-','ไทย','ไทย','พุทธ','2020-07-13'),(49,'1341501508861','APINYA','DEESAANG','2009-02-17','O','ไทย','ไทย','พุทธ','2020-07-13'),(50,'1909803411071','THANGTAI','PHANTHAMAT','2009-03-03','-','ไทย','ไทย','พุทธ','2020-07-13'),(51,'1342200015754','','','2011-10-01','','','','','2022-09-21'),(52,'1308900050694','','','2011-01-01','','','','','2022-09-21'),(53,'1349901753070','','','2011-03-04','','','','','2022-09-21'),(54,'1209703340187','Teetit0rn','khamjanla','2020-01-17','','ไทย','ไทย','พุทธ','2023-05-19'),(55,'1341501653071','Thanakorn','Promjan','2020-01-20','','ไทย','ไทย','พุทธ','2023-05-19'),(56,'1342200169448','Thanachote','Aadsalee','2020-03-18','','ไทย','ไทย','พุทธ','2023-05-19'),(57,'1209001139309','Thanapat','Photijak','2019-05-20','','ไทย','ไทย','พุทธ','2023-05-19'),(58,'1341501652562','Thunnisaya','khawprasert','2020-01-04','','ไทย','ไทย','พุทธ','2023-05-19'),(59,'1349902099144','wiratri','Maitripan','2016-03-10','','ไทย','ไทย','พุทธ','2023-05-19');

--
-- 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=12 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `student_main_permission` VALUES (1,'1349900490091',1,'1349900490091','2018-11-15'),(3,'3349800244567',1,'1349900961108','2024-07-25'),(5,'3341500526446',1,'1349900490091','2018-11-15'),(9,'3320300013231',1,'3320300013231','2025-05-28'),(8,'3341500008836',1,'3349900943319','2019-09-01'),(11,'1349900961108',1,'1349900490091','2024-07-25');

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

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

INSERT INTO `system_module` VALUES (1,'budget','การเงินและบัญชี',2,1,23,NULL,NULL,0,'fab fa-btc'),(2,'person','ข้อมูลพื้นฐานครูและบุคลากร',3,1,27,NULL,NULL,0,'fa fa-user-circle'),(3,'standard','มาตรฐานการศึกษา',1,1,19,NULL,NULL,0,''),(4,'health','ตรวจสุขภาพนักเรียน',1,1,5,NULL,NULL,0,''),(5,'student_check','การมาเรียน',1,1,1,NULL,NULL,0,'fa fa-child'),(6,'work','﻿การปฏิบัติราชการ',4,1,45,NULL,NULL,0,''),(7,'news','﻿รายงานข่าว',4,1,51,0,'',0,''),(8,'savings','ออมทรัพย์นักเรียน',1,1,3,NULL,NULL,0,'fab fa-btc'),(9,'student_main','ข้อมูลพื้นฐานนักเรียน',1,1,7,NULL,NULL,0,'fa fa-child'),(10,'plan','การวางแผน',2,1,21,NULL,NULL,0,''),(11,'la','﻿การลา',4,1,43,NULL,NULL,0,''),(12,'mail','ไปรษณีย์_โรงเรียน',4,1,34,NULL,NULL,0,'fa fa-envelope'),(13,'meeting','﻿จองห้องประชุม',4,1,47,NULL,NULL,0,''),(14,'permission','﻿ขออนุญาตไปราชการ',4,1,41,NULL,NULL,0,''),(15,'achievement','﻿ผลสัมฤทธิ์ทางการเรียน',1,1,17,NULL,NULL,0,'fa fa-graduation-cap'),(16,'cabinet','﻿ตู้เอกสาร',4,1,49,NULL,NULL,0,''),(17,'bookregister','﻿ทะเบียนหนังสือราชการ',4,1,31,NULL,NULL,0,'fa fa-book'),(18,'affair','﻿ภารกิจผู้อำนวยการ',4,1,39,0,'',0,''),(19,'amss_bets','﻿ทดสอบการศึกษา_สพท.',1,1,9,0,'',1,'fa fa-graduation-cap'),(20,'amss_budget','﻿การบริหารงบประมาณ_สพท.',2,1,25,0,'',0,'fab fa-btc'),(21,'amss_mail','﻿ไปรษณีย์_สพท.',4,1,35,0,'',0,'fa fa-envelope'),(22,'amss_opportunity','﻿สิทธิและโอกาสทางการศึกษา',1,1,13,0,'',0,'fa fa-child'),(23,'amss_spacial_student','﻿นักเรียนพิเศษ',1,1,15,0,'',0,'fa fa-child'),(24,'amss_supervision','﻿นิเทศ ติดตาม ประเมินผล',1,1,11,0,'',0,'fa fa-graduation-cap'),(25,'book','﻿รับส่งหนังสือราชการ',4,1,33,0,'',0,'fa fa-book'),(26,'delegate','﻿รักษาการในตำแหน่ง',3,1,29,0,'',0,''),(27,'bets','﻿ระบบทดสอบ_โรงเรียน',1,1,0,0,'',1,'fa fa-graduation-cap'),(28,'warroom','﻿วิเคราะห์สภาพการณ์',1,1,0,0,'',0,'fa fa-filter'),(29,'questionnaire','﻿แบบสอบถาม',4,1,0,0,'',0,''),(30,'idplan','﻿ข้อมูลครูและบุคลากร(ส่วนเพิ่ม)',3,1,0,0,'',0,''),(31,'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=123 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `system_module_admin` VALUES (7,'3349800244567','plan','7777','2018-08-02'),(4,'5341590011668','budget','7777','2018-08-02'),(5,'3341500526446','budget','7777','2015-10-01'),(6,'3341500526446','plan','7777','2015-10-01'),(8,'3349800244567','student_check','7777','2015-10-01'),(9,'3341500030807','student_check','7777','2018-08-02'),(10,'3349800244567','savings','7777','2015-10-01'),(11,'3341500526446','savings','7777','2018-08-02'),(12,'3341500526446','health','7777','2018-08-02'),(13,'3349800244567','health','7777','2015-10-01'),(14,'3341500526446','student_main','7777','2018-08-02'),(15,'3349800244567','student_main','7777','2015-10-01'),(16,'3341500526446','achievement','7777','2018-08-02'),(17,'3349800244567','achievement','7777','2015-10-01'),(18,'5341590011668','standard','7777','2018-08-02'),(19,'3349800244567','standard','7777','2015-10-01'),(20,'3349800244567','person','7777','2018-08-02'),(21,'3341500526446','person','7777','2018-08-02'),(22,'3349800244567','bookregister','7777','2018-08-02'),(23,'5341590011668','bookregister','7777','2015-10-01'),(24,'3349800244567','mail','7777','2018-08-02'),(25,'1330700123801','mail','1330700123801','2022-10-21'),(26,'3349800244567','permission','7777','2018-08-02'),(27,'5341590011668','permission','7777','2015-10-01'),(28,'3341500526446','la','7777','2018-08-02'),(29,'3349800244567','la','1330700123801','2022-10-21'),(30,'3349800244567','work','7777','2018-08-02'),(31,'5341590011668','work','7777','2015-10-01'),(32,'3349800244567','meeting','7777','2018-08-02'),(33,'5341590011668','meeting','7777','2015-10-01'),(34,'3349800244567','cabinet','1330700123801','2022-10-21'),(35,'1330700123801','cabinet','1330700123801','2022-10-21'),(36,'3341500526446','student_check','3341500526446','2018-08-02'),(37,'3349800244567','book','7777','2018-09-22'),(38,'1349900490091','bookregister','7777','2018-11-05'),(39,'1349900490091','amss_mail','7777','2018-11-05'),(40,'1349900490091','book','7777','2018-11-05'),(41,'1349900490091','amss_supervision','3341500526446','2018-11-13'),(42,'1349900490091','work','3341500526446','2018-11-13'),(43,'1349900490091','permission','7777','2018-11-15'),(44,'1349900490091','person','1349900490091','2018-11-15'),(45,'1349900490091','student_main','1349900490091','2018-11-15'),(46,'1349900490091','student_check','1349900490091','2018-11-15'),(47,'1349900490091','savings','1349900490091','2018-11-15'),(48,'3349800244567','affair','7777','2018-11-15'),(49,'1349900490091','affair','7777','2018-11-15'),(50,'1349900490091','la','1349900490091','2018-11-15'),(51,'1349900490091','achievement','1349900490091','2018-11-15'),(52,'1349900490091','amss_budget','1349900490091','2018-11-15'),(53,'1349900490091','amss_spacial_student','1349900490091','2018-11-15'),(54,'1349900490091','standard','1349900490091','2018-11-15'),(55,'1349900490091','delegate','1349900490091','2018-11-15'),(56,'1349900490091','mail','1349900490091','2018-11-15'),(57,'1349900490091','amss_bets','1349900490091','2018-11-15'),(58,'1349900490091','amss_opportunity','1349900490091','2018-11-15'),(59,'1349900490091','cabinet','1349900490091','2018-11-15'),(60,'1349900490091','plan','1349900490091','2018-11-15'),(61,'1349900490091','budget','1349900490091','2018-11-15'),(62,'1349900490091','bets','1349900490091','2018-11-15'),(63,'1330700123801','book','1330700123801','2019-12-16'),(64,'1330700123801','bookregister','1330700123801','2019-12-16'),(65,'1330700123801','plan','1330700123801','2020-10-02'),(66,'1330700123801','person','1330700123801','2020-10-02'),(67,'1330700123801','budget','1330700123801','2020-10-02'),(68,'1330700123801','idplan','1330700123801','2020-10-02'),(69,'1330700123801','student_check','1330700123801','2020-10-02'),(70,'1330700123801','amss_supervision','1330700123801','2021-02-07'),(71,'1330700123801','health','1330700123801','2021-03-18'),(72,'1330700123801','savings','1330700123801','2021-06-16'),(73,'','','1330700123801','2021-06-16'),(74,'1330700123801','amss_opportunity','1330700123801','2023-05-19'),(75,'3320300013231','achievement','1349900490091','2023-10-25'),(76,'3320300013231','affair','1330700123801','2023-10-30'),(77,'3320300013231','amss_bets','1330700123801','2023-10-30'),(78,'3320300013231','amss_budget','1330700123801','2023-10-30'),(79,'3320300013231','amss_supervision','1330700123801','2023-10-30'),(80,'3320300013231','bets','1330700123801','2023-10-30'),(81,'3320300013231','book','1330700123801','2023-10-30'),(82,'3320300013231','bookregister','1330700123801','2023-10-30'),(83,'3320300013231','idplan','1330700123801','2023-10-30'),(84,'3320300013231','mail','1330700123801','2023-10-30'),(85,'3320300013231','budget','1330700123801','2023-10-30'),(86,'3320300013231','permission','1330700123801','2023-10-30'),(87,'1330700123801','permission','1330700123801','2023-10-30'),(88,'3320300013231','student_check','1330700123801','2023-10-30'),(89,'1330700123801','warroom','1330700123801','2023-10-30'),(90,'3320300013231','person','1330700123801','2023-10-30'),(91,'3320300013231','meeting','1330700123801','2023-10-30'),(92,'3341500008836','health','1330700123801','2024-03-13'),(93,'1349900961108','bookregister','1342200067581','2024-07-25'),(94,'1349900961108','student_main','1342200067581','2024-07-25'),(95,'1349900961108','work','1342200067581','2024-07-25'),(96,'1349900961108','student_check','1342200067581','2024-07-25'),(97,'1349900961108','book','1342200067581','2024-07-25'),(98,'1349900961108','achievement','1342200067581','2024-07-25'),(99,'1349900961108','amss_bets','1342200067581','2024-07-25'),(100,'1349900961108','amss_budget','1342200067581','2024-07-25'),(101,'1349900961108','amss_mail','1342200067581','2024-07-25'),(102,'1349900961108','amss_opportunity','1342200067581','2024-07-25'),(103,'1349900961108','amss_safety','1342200067581','2024-07-25'),(104,'1349900961108','amss_supervision','1342200067581','2024-07-25'),(105,'1349900961108','bets','1342200067581','2024-07-25'),(106,'1349900961108','budget','1342200067581','2024-07-25'),(107,'1349900961108','cabinet','1342200067581','2024-07-25'),(108,'1349900961108','delegate','1342200067581','2024-07-25'),(109,'1349900961108','health','1342200067581','2024-07-25'),(110,'1349900961108','idplan','1342200067581','2024-07-25'),(111,'1349900961108','la','1342200067581','2024-07-25'),(112,'1349900961108','mail','1342200067581','2024-07-25'),(113,'1349900961108','meeting','1342200067581','2024-07-25'),(114,'1349900961108','news','1342200067581','2024-07-25'),(115,'1349900961108','permission','1342200067581','2024-07-25'),(116,'1349900961108','person','1342200067581','2024-07-25'),(117,'1349900961108','warroom','1342200067581','2024-07-25'),(118,'1349900961108','savings','1342200067581','2024-07-25'),(119,'1349900961108','questionnaire','1342200067581','2024-07-25'),(120,'1349900961108','plan','1342200067581','2024-07-25'),(121,'1349900961108','amss_spacial_student','1342200067581','2024-07-25'),(122,'1349900961108','standard','1342200067581','2024-07-25');

--
-- 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,
  PRIMARY KEY (`id`)
) 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,'34040070','amssplus','34040070','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,'บริหารวิชาการ',1),(2,2,'บริหารงบประมาณ',2),(3,3,'บริหารงานบุคคล',6),(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=328 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

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

--
-- 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=5 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `work_permission` VALUES (1,'1349900490091',1,'1349900490091','2018-11-16'),(2,'3341500030807',1,'1349900490091','2018-11-16'),(3,'3349800244567',1,'1349900490091','2018-11-16'),(4,'3341500526446',1,'1349900490091','2018-11-16');


