
--
-- 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 (2,1,'3650800096192',2557),(3,1,'3650800096192',2557),(4,1,'3341500267939',2557),(5,1,'3349800079248',2557),(4,1,'1349900600075',2561),(2,1,'3650800096192',2561),(3,1,'3650800096192',2561),(3,1,'1349900600075',2561),(2,1,'1349900600075',2561),(4,1,'3341500267939',2561),(5,1,'3349800079248',2561),(5,1,'1349900600075',2561),(6,1,'1349900722561',2561),(6,1,'1349900600075',2561),(7,1,'3349800081951',2561),(7,1,'1349900600075',2561),(8,1,'1341900313156',2561),(8,1,'1349900600075',2561),(9,1,'1349900580635',2561),(9,1,'1349900600075',2561),(2,1,'3349800079248',2562),(2,1,'1349900600075',2562),(3,1,'3349800079248',2562),(3,1,'1349900600075',2562),(4,1,'3341500267939',2562),(4,1,'1349900600075',2562),(5,1,'3341900313156',2562),(5,1,'1349900600075',2562),(6,1,'3341501372591',2562),(6,1,'3341500267939',2562),(6,1,'3341900313156',2562),(6,1,'3349800079248',2562),(6,1,'3349800081951',2562),(6,1,'1349900722561',2562),(6,1,'1349900600075',2562),(7,1,'3349800081951',2562),(7,1,'1349900600075',2562),(8,1,'1349900722561',2562),(8,1,'1349900600075',2562),(9,1,'1349900722561',2562),(9,1,'1349900600075',2562),(2,1,'3349800081951',2563),(2,1,'1349900600075',2563),(3,1,'3349800081951',2563),(3,1,'1349900600075',2563),(4,1,'3349800081951',2563),(4,1,'1349900600075',2563),(5,1,'3341900313156',2563),(5,1,'1349900600075',2563),(6,1,'3341900313156',2563),(6,1,'1349900600075',2563),(7,1,'3349800081951',2563),(7,1,'1349900600075',2563),(8,1,'1349900722561',2563),(8,1,'1349900600075',2563),(9,1,'1349900722561',2563),(9,1,'1349900600075',2563);

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

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

INSERT INTO `student_check_year` VALUES (1,2557,0),(2,2561,0),(3,2562,0),(4,2563,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=176 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `student_main` VALUES (1,'1455',0,'เด็กหญิง','ปพิชญา','กุลพร','1349901194950',2,NULL,9,1,1,2557,'','0000-00-00'),(2,'1414',0,'เด็กหญิง','นุชนาฎ','มูลเพ็ชร','1349901213296',2,NULL,9,1,1,2557,'','0000-00-00'),(3,'1411',0,'เด็กหญิง','เกวลิน','รอดคำทุย','1349901159003',2,NULL,9,1,1,2557,'','0000-00-00'),(4,'1483',0,'เด็กชาย','อภิมุข','พันธ์วัตร','1349901205587',1,NULL,9,1,1,2557,'','0000-00-00'),(5,'1469',0,'เด็กชาย','สินธนา','วระพุฒ','1342136540126',1,NULL,9,1,1,2557,'','0000-00-00'),(6,'1453',0,'เด็กชาย','ชิราวุธ','บึงใส','1341501424292',1,NULL,9,1,1,2557,'','0000-00-00'),(7,'1437',0,'เด็กชาย','พิสิษฐ์','แก้วบัวขาว','1349901192035',1,NULL,9,1,1,2557,'','0000-00-00'),(8,'1410',0,'เด็กชาย','อภินันท์','พุดด้วงเงิน','1349901200003',1,NULL,9,1,1,2557,'','0000-00-00'),(9,'1409',0,'เด็กชาย','ธีรวัฒน์','พยารัตน์','1341501421269',1,NULL,9,1,1,2557,'','0000-00-00'),(10,'1404',0,'เด็กชาย','ฤทธิเดช','ก้องเสียง','1349901165356',1,NULL,9,1,1,2557,'','0000-00-00'),(11,'1403',0,'เด็กชาย','ฤทธิชัย','ก้องเสียง','1349901165364',1,NULL,9,1,1,2557,'','0000-00-00'),(12,'1402',0,'เด็กชาย','วรรณชัย','กล้าหาญ','1341501418152',1,NULL,9,1,1,2557,'','0000-00-00'),(13,'1401',0,'เด็กชาย','ตระการ','ชะคำรอด','1349901181041',1,NULL,9,1,1,2557,'','0000-00-00'),(14,'1394',0,'เด็กชาย','ยอดชัย','ผาละพรม','1349901158198',1,NULL,9,1,1,2557,'','0000-00-00'),(15,'1426',0,'เด็กหญิง','สุขธิดา','ญาณะพันธ์','1341501429308',2,NULL,9,1,1,2557,'','0000-00-00'),(16,'1425',0,'เด็กหญิง','วรนุช','มลเทียรอาจ','1341501440301',2,NULL,9,1,1,2557,'','0000-00-00'),(17,'1424',0,'เด็กหญิง','พลอยไพลิน','โสภาภาค','1349901274635',2,NULL,9,1,1,2557,'','0000-00-00'),(18,'1423',0,'เด็กหญิง','กานติมา','อุทุเป','1349901279319',2,NULL,9,1,1,2557,'','0000-00-00'),(19,'1488',0,'เด็กชาย','อภิวัฒน์','เรืองธรรม','1341501430110',1,NULL,9,1,1,2557,'','0000-00-00'),(20,'1472',0,'เด็กชาย','วรวิทย์','ไกรรักษ์','1349901213041',1,NULL,9,1,1,2557,'','0000-00-00'),(21,'1447',0,'เด็กชาย','พีระพัฒน์','สระคุณ','1349901224841',1,NULL,9,1,1,2557,'','0000-00-00'),(22,'1422',0,'เด็กชาย','อนุวัฒน์','ผาละพรม','1349901268121',1,NULL,9,1,1,2557,'','0000-00-00'),(23,'1421',0,'เด็กชาย','สรนันท์','บุระดำ','1341501438013',1,NULL,9,1,1,2557,'','0000-00-00'),(24,'1435',0,'เด็กหญิง','ธนาภรณ์','บุระดำ','1349901299883',2,NULL,8,1,1,2557,'','0000-00-00'),(25,'1503',0,'เด็กชาย','ทศวรรษ','บุญชุน','1341501439591',1,NULL,8,1,1,2557,'','0000-00-00'),(26,'1470',0,'เด็กชาย','ธนกร','สาวิจารย์','3341512873692',1,NULL,8,1,1,2557,'','0000-00-00'),(27,'1434',0,'เด็กชาย','ศุภชัย','คงนิล','1349901357093',1,NULL,7,1,1,2561,'','0000-00-00'),(28,'1431',0,'เด็กชาย','ณัฐภูมิ','มาคำผุย','1349901348337',1,NULL,7,1,1,2561,'','0000-00-00'),(29,'1430',0,'เด็กชาย','ชนะชัย','อุ่นวงษ์','1341501466947',1,NULL,7,1,1,2561,'','0000-00-00'),(30,'1482',0,'เด็กหญิง','ภัคจิราภรณ์','พันธ์วัตร','1341401264510',2,NULL,6,1,1,2561,'','0000-00-00'),(31,'1473',0,'เด็กหญิง','จุฑาทิพย์','เดชา','1118700079941',2,NULL,6,1,1,2561,'','0000-00-00'),(32,'1442',0,'เด็กหญิง','พรทิพย์','ศรีนวล','1349901387103',2,NULL,6,1,1,2561,'','0000-00-00'),(33,'1441',0,'เด็กหญิง','วริษา','กล้าหาญ','1341501475229',2,NULL,6,1,1,2561,'','0000-00-00'),(34,'1484',0,'เด็กชาย','สุกฤษฎิ์','สนทะวิน','1218800035929',1,NULL,6,1,1,2561,'','0000-00-00'),(35,'1440',0,'เด็กชาย','วีรภัทร','โลมากาล','1349901371878',1,NULL,6,1,1,2561,'','0000-00-00'),(36,'1502',11,'เด็กหญิง','รัชนีกร','เหลาทอง','1341501496064',2,NULL,9,1,1,2562,'1349900600075','0000-00-00'),(37,'1501',10,'เด็กหญิง','พัชชา','เหนี่ยวพันธุ์','1341501491216',2,NULL,9,1,1,2562,'1349900600075','0000-00-00'),(38,'1463',8,'เด็กหญิง','วันนิสา','แก้วบัวขาว','1349901493302',2,NULL,9,1,1,2562,'1349900600075','0000-00-00'),(39,'1462',7,'เด็กหญิง','พิรดา','รุ่งมณี','1719900748061',2,NULL,9,1,1,2562,'1349900600075','0000-00-00'),(40,'1461',6,'เด็กหญิง','นันทิวา','วงมาเกษ','1349901491903',2,NULL,9,1,1,2562,'1349900600075','0000-00-00'),(41,'1460',5,'เด็กหญิง','ปิ่นมุก','แก้วตา','1139900538924',2,NULL,9,1,1,2562,'1349900600075','0000-00-00'),(42,'1459',4,'เด็กหญิง','จิรัชยา','อุทุเป','1349901481746',2,NULL,9,1,1,2562,'1349900600075','0000-00-00'),(43,'1500',0,'เด็กชาย','อธิบดี','ช้างคง','1103704223694',1,NULL,9,1,2,2561,'','0000-00-00'),(44,'1458',3,'เด็กชาย','ศรนรินทร์','อุทุเป','1349901432753',1,NULL,9,1,1,2562,'1349900600075','0000-00-00'),(45,'1471',9,'เด็กชาย','วุฒิกร','สาวิจารย์','3341536542586',1,NULL,9,1,1,2562,'1349900600075','0000-00-00'),(46,'1457',2,'เด็กชาย','ไพศาล','ปัสสามั่น','1349901465538',1,NULL,9,1,1,2562,'1349900600075','0000-00-00'),(47,'1456',1,'เด็กชาย','นิพนธ์','แก้วบัวขาว','1314501486590',1,NULL,9,1,1,2562,'1349900600075','0000-00-00'),(48,'1499',5,'เด็กหญิง','กัลย์สุดา','สารีมูล','1347600025103',2,NULL,9,1,1,2564,'1349900600075','0000-00-00'),(49,'1498',4,'เด็กหญิง','อชิรญา','โลมากาล','1347600031839',2,NULL,9,1,1,2564,'1349900600075','0000-00-00'),(50,'1497',4,'เด็กหญิง','สนะฤพร','มาศีลา','1341501502960',2,NULL,7,1,2,2562,'1349900600075','0000-00-00'),(51,'1496',3,'เด็กหญิง','นีระภา','บุญรมย์','1349901606891',2,NULL,9,1,1,2564,'3341501372591','0000-00-00'),(52,'1495',0,'เด็กชาย','อธิการ','ช้างคง','1102900189290',1,NULL,7,1,2,2561,'3341501372591','0000-00-00'),(53,'1493',2,'เด็กชาย','ธันวา','นันทะชัย','1347600030182',1,NULL,9,1,1,2564,'3341501372591','0000-00-00'),(54,'1492',1,'เด็กชาย','จักรกฤษ์','จำปีทูล','1341501503788',1,NULL,9,1,1,2564,'3341501372591','0000-00-00'),(56,'1475',1,'เด็กชาย','สุรวุธ','ชะคำรอด','1349901533908',1,NULL,9,1,1,2562,'3341501372591','0000-00-00'),(57,'1476',2,'เด็กหญิง','กัญญาภัทร','คงนิล','1349901518054',2,NULL,9,1,1,2562,'3341501372591','0000-00-00'),(58,'1477',3,'เด็กหญิง','ปุณยาพร','กุลพร','1729900779071',2,NULL,9,1,1,2562,'3341501372591','0000-00-00'),(60,'1479',0,'เด็กหญิง','มินยดา','วระพุฒ','1849901940487',2,NULL,8,1,2,2561,'3341501372591','0000-00-00'),(61,'1480',5,'เด็กหญิง','ศศิชา','ชะคำรอด','1347600018689',2,NULL,9,1,1,2562,'3341501372591','0000-00-00'),(62,'1481',5,'เด็กหญิง','สุภาพร','มูลเพ็ชร','1341501499845',2,NULL,9,1,1,2562,'3341501372591','0000-00-00'),(63,'1504',6,'เด็กหญิง','อาคัมสิริ','โพธิ์นัน','1319901177371',2,NULL,9,1,1,2562,'3341501372591','0000-00-00'),(64,'1507',7,'เด็กหญิง','ปรางทิพย์','ดีสำโรง','1349901516736',2,NULL,9,1,1,2562,'3341501372591','0000-00-00'),(65,'1508',1,'เด็กชาย','พงศกร','คำกอก','1349901669753',1,NULL,8,1,1,2564,'1349900600075','0000-00-00'),(66,'1509',2,'เด็กชาย','ศุภกานต์','ผาละพรม','1349901653938',1,NULL,8,1,1,2564,'1349900600075','0000-00-00'),(67,'1510',0,'เด็กชาย','อานนท์','แสงตา','1349901635166',1,NULL,6,1,2,2561,'3341501372591','0000-00-00'),(68,'1511',3,'เด็กหญิง','ชลลดา','ฉัตรวิไล','1348900228108',2,NULL,8,1,1,2564,'1349900600075','0000-00-00'),(69,'1512',4,'เด็กหญิง','นิชาภา','สาวิจารย์','1341501511225',2,NULL,8,1,1,2564,'1349900600075','0000-00-00'),(70,'1513',5,'เด็กหญิง','ปนัดดา','นิลบารันต์','1349901664085',2,NULL,8,1,1,2564,'1349900600075','0000-00-00'),(72,'1506',0,'เด็กชาย','ธีรภัทร','ป่วนคำ','1369900609889',1,NULL,9,1,1,2557,'','0000-00-00'),(97,'1568',1,'เด็กหญิง','กินรี','อาจฉกรรจ์','1341501565473',2,'',7,1,0,NULL,'1349900600075','2018-11-23'),(73,'1534',1,'เด็กชาย','พงศ์เพชร','แก้วตา','1341501544328',1,'',9,1,0,NULL,'1349900600075','2018-11-02'),(74,'1535',2,'เด็กหญิง','เนตรนภา','สารีมูล','1347600058214',2,'',9,1,0,NULL,'1349900600075','2018-11-23'),(75,'1536',3,'เด็กหญิง','ลลิตพรรณ','โลมากาล','1349901829149',2,'',9,1,0,NULL,'1349900600075','2018-11-23'),(76,'1537',4,'เด็กหญิง','สุวรรณี','แก้วสว่าง','1347600060758',2,'',9,1,0,NULL,'1349900600075','2018-11-23'),(77,'1565',5,'เด็กชาย','พีรณัฐ','ญาติวงค์','1341501536317',1,'',9,1,0,NULL,'1349900600075','2018-11-23'),(78,'1566',6,'เด็กหญิง','ณัฐธิดา','จำปีทูล','1341501540497',2,'',9,1,0,NULL,'1349900600075','2018-11-23'),(79,'1567',7,'เด็กหญิง','ปุณยดา','บัวชื่น','1341501539383',2,'',9,1,0,NULL,'1349900600075','2018-11-23'),(80,'1572',8,'เด็กชาย','ภัทรภณ','โสมแผ้ว','1349901788256',1,'',4,1,2,2562,'1349900600075','2018-11-23'),(81,'1519',1,'เด็กชาย','จิรายุทธ','อุทุเป','1349901741365',1,'',9,1,1,2565,'1349900600075','2018-11-23'),(82,'1520',2,'เด็กชาย','นพดล','แก้วบัวขาว','1339901091255',1,'',9,1,1,2565,'1349900600075','2018-11-23'),(83,'1522',3,'เด็กชาย','พินิช','นุพิศรี','1341501524386',1,'',9,1,1,2565,'1349900600075','2018-11-23'),(84,'1523',4,'เด็กชาย','สุธี','วงมาเกษ','1349901700774',1,'',9,1,1,2565,'1349900600075','2018-11-23'),(85,'1525',5,'เด็กหญิง','ชุติกาญจน์','บัวหอม','1347600052674',2,'',9,1,1,2565,'1349900600075','2018-11-23'),(86,'1527',6,'เด็กหญิง','รัชฏาภรณ์','สายเบาะ','1349901750895',2,'',9,1,1,2565,'3341501372591','2018-11-23'),(87,'1528',7,'เด็กหญิง','อัญฑิชา','บุญรมย์','1349901712152',2,'',9,1,2,2565,'1349900600075','2018-11-23'),(88,'1554',8,'เด็กชาย','พีระพัต','วิจารณ์','1349901694481',1,'',9,1,1,2565,'1349900600075','2018-11-23'),(89,'1555',9,'เด็กชาย','วฤทธิ','เรืองธรรม','1349901757491',1,'',9,1,1,2565,'1349900600075','2018-11-23'),(90,'1556',10,'เด็กชาย','ศุภชัย','ชะคำรอด','1347611154642',1,'',9,1,1,2565,'1349900600075','2018-11-23'),(91,'1531',6,'เด็กชาย','ทะนะกริต','คำมีเซื้อ','1347600042580',1,'',8,1,1,2564,'1349900600075','2018-11-23'),(92,'1532',7,'เด็กหญิง','สิริกัญญา','ตะนะโส','1341501519099',2,'',8,1,2,2563,'3341501372591','2018-11-23'),(93,'1533',7,'เด็กชาย','ไชยวัฒน์','เรืองธรรม','1349901643525',1,'',8,1,1,2564,'1349900600075','2018-11-23'),(94,'1516',6,'เด็กหญิง','สู่ขวัญ','เซื้อทอง','1347600032631',2,'',9,1,1,2564,'1349900600075','2018-11-23'),(95,'1518',7,'เด็กชาย','สุทธิรักษ์','พยารัตน์','1341501505357',1,'',9,1,1,2564,'1349900600075','2018-11-23'),(96,'1538',8,'เด็กชาย','วุฒิกรณ์','โคตจันคำ','1349700392410',1,'',9,1,1,2564,'1349900600075','2018-11-23'),(98,'1569',2,'เด็กหญิง','วราสินี','นรชาญ','1349901965476',2,'',7,1,0,NULL,'1349900600075','2018-11-23'),(99,'1570',3,'เด็กหญิง','ศศิประภา','ตะนะโส','1341501561541',2,'',4,1,2,2563,'3341501372591','2018-11-23'),(100,'1571',3,'เด็กหญิง','อินรุ่ง','จันทาพุฒ','1347600084011',2,'',7,1,0,NULL,'1349900600075','2018-11-23'),(101,'1539',1,'เด็กชาย','กฤณพงธ์','บรรเทาทัน','1341501547416',1,'',8,1,0,NULL,'1349900600075','2018-11-23'),(102,'1540',2,'เด็กชาย','ปกรณ์','โลมากาล','1347600071296',1,'',3,1,2,2562,'1349900600075','2018-11-23'),(103,'1541',2,'เด็กชาย','ไพรวัลย์','ปัสสามั่น','1349901905945',1,'',8,1,0,NULL,'1349900600075','2018-11-23'),(104,'1544',4,'เด็กชาย','วิทวัส','ถุงคำแก้ว','1341501546592',1,'',3,1,2,2562,'1349900600075','2018-11-23'),(105,'1545',3,'เด็กชาย','วรยุทธ','ทอฃคำสุข','1341501550361',1,'',8,1,0,NULL,'1349900600075','2018-11-23'),(106,'1547',4,'เด็กชาย','สิรภพ','พูลสว่าง','1349901904345',1,'',8,1,0,NULL,'1349900600075','2018-11-23'),(107,'1548',5,'เด็กหญิง','กัญญาณัฐ','คงนิล','1349901889508',2,'',8,1,0,NULL,'1349900600075','2018-11-23'),(108,'1549',6,'เด็กหญิง','ปนิดา','ผาละพรม','1341501554234',2,'',7,1,2,2566,'1349900600075','2018-11-23'),(109,'1550',14,'เด็กหญิง','หทัยพร','มาศีลา','1341501550221',2,'',8,1,0,NULL,'1349900600075','2018-11-23'),(110,'1551',7,'เด็กหญิง','หิรัญยา','พรงาม','1339600272111',2,'',8,1,0,NULL,'1349900600075','2018-11-23'),(111,'1578',9,'เด็กชาย','อมรเทพ','สิมมา','1348900193568',1,'',9,1,1,2564,'3341501372591','2020-01-24'),(112,'1585',11,'เด็กชาย','ศักดิ์สิทธิ์','ปิ่นแคน','1341501524726',1,'',9,1,2,2565,'1349900600075','2020-01-24'),(113,'1577',8,'เด็กชาย','โรจนศักดิ์','สิมมา ','1348900270279',1,'',9,1,0,NULL,'1349900600075','2020-01-24'),(114,'1583',9,'เด็กชาย','ธีฆายุ','พันธ์จันดี','1348900243603',1,'',8,1,2,2566,'1349900600075','2020-01-24'),(115,'1573',8,'เด็กหญิง ','จิรนันท์','พุดด้วงเงิน','1341501554528',2,'',8,1,0,NULL,'1349900600075','2020-01-24'),(116,'1574',9,'เด็กชาย','ภัทรพล','ผาละพรม','1359200117631',1,'',8,1,0,NULL,'1349900600075','2020-01-24'),(117,'1575',10,'เด็กชาย','ธนพัชร์','เรืองธรรม','1347600072667	',1,'',8,1,0,NULL,'1349900600075','2020-01-24'),(118,'1576',11,'เด็กชาย','วีระพล','สายใจ','1349901857321',1,'',8,1,0,NULL,'1349900600075','2020-01-24'),(119,'1584',12,'เด็กหญิง','บัวชมพู','ปิ่นแคน','1341501548846',2,'',7,1,2,2565,'1349900600075','2020-01-24'),(120,'1586',13,'เด็กชาย','จิรันธนินทร์	','แจ่มจำรัส','1739902607928',1,'',7,1,2,2565,'1349900600075','2020-01-24'),(121,'1587',5,'เด็กชาย','ธฤติพันธ์','เเจ่มจำรัส','1739902688197',1,'',6,1,2,2565,'1349900600075','2020-01-24'),(122,'1588',4,'เด็กหญิง','นันทิยา','ราชคฤห์','1305300087471',2,'',7,1,0,NULL,'1349900600075','2020-01-24'),(123,'1579',1,'เด็กหญิง','มนัสนัน','ชะคำรอด','1347600099468',2,'',6,1,0,NULL,'1349900600075','2020-01-24'),(124,'1580',2,'เด็กชาย','ธนกร','บุญชุน','1341501575088',1,'',6,1,0,NULL,'1349900600075','2020-01-24'),(125,'1581',3,'เด็กชาย','ธนเทพ','ทองโชติ','1349902024675',1,'',6,1,0,NULL,'1349900600075','2020-01-24'),(126,'1582',4,'เด็กชาย','อภิสิทธิ์','ทวีคูณ','1341501576874',1,'',6,1,0,NULL,'1349900600075','2020-01-24'),(127,'1590',5,'เด็กหญิง','เบญจมาภรณ์','สายจันทร์','1341501574537	',2,'',6,1,0,NULL,'1349900600075','2020-01-24'),(128,'1591',1,'เด็กหญิง ','ธัญญาพร','แก้วสว่าง','1341501592403',2,'',5,1,0,NULL,'1349900600075','2020-08-05'),(129,'1592',2,'เด็กหญิง','อริสรา','กันหาไชย','1341501581584',2,'',5,1,0,NULL,'1349900600075','2020-08-05'),(130,'1593',3,'เด็กชาย','ธนายุทธ','ประทุมพิมพ์','1459901676058',1,'',5,1,0,NULL,'1349900600075','2020-08-05'),(131,'1594',5,'เด็กชาย','ชัยพงศ์','ดีสำโรง','1341501559457',1,'',7,1,0,NULL,'1349900600075','2020-08-05'),(132,'1595',15,'เด็กหญิง','ณัฐมน  ','แก้วบุญเรือง','1259500198688',2,'',7,1,2,2566,'1349900600075','2020-08-05'),(133,'1596',6,'เด็กชาย','ชิษณุพงศ์','เบ้างาม','1347600093907',1,'',7,1,0,NULL,'1349900600075','2020-08-05'),(134,'1598',12,'เด็กชาย','จิตติพัฒน์','คำภา','1379900442283',1,'',9,1,2,2565,'1349900600075','2021-01-13'),(135,'1597',8,'เด็กหญิง','ศุภิสรา','คำภา','1379900551139',2,'',6,1,2,2566,'1349900600075','2021-01-13'),(136,'1618',1,'เด็กหญิง','ชาลินี','คงนิล','1341501619263',2,'',3,1,0,NULL,'1349900600075','2022-09-17'),(137,'1620',2,'เด็กชาย','ภูวดล','ผาละพรม','1341501612358',1,'',3,1,0,NULL,'1349900600075','2022-09-17'),(138,'1621',3,'เด็กชาย','ภูวนัย','ผาละพรม','1341501612340',1,'',3,1,0,NULL,'1349900600075','2022-09-17'),(139,'1623',4,'เด็กหญิง','วนิดา','นุพิศรี ','1349902218640',2,'',3,1,0,NULL,'1349900600075','2022-09-17'),(140,'1600',1,'เด็กชาย','นนท์ชัย','ผาละพรม','1341501609586',1,'',4,1,0,NULL,'1349900600075','2022-09-17'),(141,'1601',2,'เด็กชาย','ปองคุณ','คงงาม ','1341501601542',1,'',4,1,0,NULL,'1349900600075','2022-09-17'),(142,'1602',3,'เด็กชาย','ศักดิเดช','ธุตาสิทธิ์','1341501599432',1,'',4,1,0,NULL,'1349900600075','2022-09-17'),(143,'1603',4,'เด็กชาย','ศุภกิตติ์','โมระดา','1341501608164',1,'',4,1,0,NULL,'1349900600075','2022-09-17'),(144,'1604',5,'เด็กชาย','แสนยากร','ผาละพรม','1341501605661',1,'',4,1,0,NULL,'1349900600075','2022-09-17'),(145,'1605',6,'เด็กหญิง','จิตติมา','สิงห์นา','1409904527142',1,'',4,1,0,NULL,'1349900600075','2022-09-17'),(146,'1611',7,'เด็กหญิง','มนคำ','ทองฤทธิ์','G653400002334',2,'',4,1,0,NULL,'1349900600075','2022-09-17'),(147,'1616',8,'เด็กชาย','กฤษฎา','กุดดวงแก้ว','1341501603740',1,'',4,1,0,NULL,'1349900600075','2022-09-17'),(148,'1622',4,'เด็กหญิง','ขวัญฤทัย','หอมฟุ้ง','1709902116134',2,'',5,1,0,NULL,'1349900600075','2022-09-17'),(149,'1612',5,'เด็กหญิง','ขวัญหทัย','หอมฟุ้ง','1709902116142',2,'',5,1,0,NULL,'1349900600075','2022-09-17'),(150,'1613',6,'เด็กหญิง','วิลาวัณย์','บุระดำ','1341501584650',2,'',5,1,0,NULL,'1349900600075','2022-09-17'),(151,'1614',7,'เด็กชาย','ภควัต','อุ่นจันทร์','1209000912039',1,'',5,1,0,NULL,'1349900600075','2022-09-17'),(152,'1615',8,'เด็กชาย','ธนกร','พิมพ์ทราย','1341501589348',1,'',5,1,0,NULL,'1349900600075','2022-09-17'),(153,'1599',6,'เด็กชาย','ธนธร','ศรีโคตร','1348900345783',1,'',6,1,0,NULL,'1349900600075','2022-09-17'),(154,'1607',7,'เด็กชาย','ชนะภัย','สิงห์นา ','1409400046132',1,'',6,1,0,NULL,'1349900600075','2022-09-17'),(155,'1609',8,'เด็กหญิง','นภาพร','สิงห์ซอม','1341501577021',2,'',6,1,0,NULL,'1349900600075','2022-09-17'),(156,'1624',9,'เด็กชาย','ลัทธพล','สุเพ็ญ','1349901796585',1,'',9,1,0,NULL,'1349900600075','2022-09-17'),(157,'1626',1,'เด็กชาย ','ศรัณย์ภัทร','สมบูรณ์','1341501640742',1,'',2,1,0,NULL,'1349900600075','2023-09-12'),(158,'1627',2,'เด็กชาย','ถิรวัฒน์','กล้าหาญ','1341501642206',1,'',2,1,0,NULL,'1349900600075','2023-09-12'),(159,'1628',3,'เด็กชาย','ธนเดช','รัตพันธ์','1349700565292',1,'',2,1,0,NULL,'1349900600075','2023-09-12'),(160,'1629',4,'เด็กชาย','กิตติ์ธนา','พุดด้วงเงิน','1341501637377',1,'',2,1,0,NULL,'1349900600075','2023-09-12'),(161,'1630',5,'เด็กหญิง ','น้ำทิพย์','เชื้อทอง','1347600144951',2,'',2,1,0,NULL,'1349900600075','2023-09-12'),(162,'1631',6,'เด็กหญิง','ขนิษฐา','เบ้างาม ','1341501640653',2,'',2,1,0,NULL,'1349900600075','2023-09-12'),(163,'1632',7,'เด็กหญิง','ภาวดี','บุระดำ ','1341501631093',2,'',2,1,0,NULL,'1349900600075','2023-09-12'),(164,'1633',8,'เด็กหญิง','เอมฤดี','แก้วสว่าง','1341501634114',2,'',2,1,0,NULL,'1349900600075','2023-09-12'),(165,'1625',5,'เด็กชาย','รัชชานนท์','แสงตา','1341501619603',1,'',3,1,0,NULL,'1349900600075','2023-09-12'),(166,'1634',6,'เด็กหญิง','สิรารมย์','พุ่มแก้ว','1349700550155',2,'',3,1,0,NULL,'1349900600075','2023-09-12'),(167,'1635',9,'เด็กชาย','กิตติพงศ์','ญาติวงค์','1341501602034',1,'',4,1,0,NULL,'1349900600075','2023-09-12'),(168,'1636',10,'เด็กชาย','อภินันท์','นิลลิ','1349902158540',1,'',4,1,0,NULL,'1349900600075','2023-09-12'),(169,'1637',11,'เด็กหญิง','วรรณดา','ป้องสีดา','1341501609195',2,'',4,1,0,NULL,'1349900600075','2023-09-12'),(170,'1638',12,'เด็กหญิง','พรทิวา','ผาละพรม','1341501603812',2,'',4,1,0,NULL,'1349900600075','2023-09-12'),(171,'1639',13,'เด็กชาย','จิรายุ','นามโสภา','1347600127585',1,'',4,1,0,NULL,'1349900600075','2023-09-12'),(172,'1640',9,'เด็กชาย','พลกฤต','ฝ้ายอิ่ม','1349902100711',1,'',5,1,0,NULL,'1349900600075','2023-09-12'),(173,'1641',9,'เด็กชาย','ภูวิศ','ฝ้ายอิ่ม','1749901537381',1,'',6,1,0,NULL,'1349900600075','2023-09-12'),(174,'1642',10,'เด็กหญิง','สุจิตรา','อาจสาลี','1339901278924',2,'',6,1,0,NULL,'1349900600075','2023-09-12'),(175,'1610',7,'เด็กชาย','ธนบดี','เพ็ชรลิน','1348900314888',1,'',7,1,0,NULL,'1349900600075','2023-09-12');

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

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

INSERT INTO `student_main_classlog` VALUES (1,2557,'1394',0,9,1,'3341501372591','2018-09-22'),(2,2557,'1401',0,9,1,'3341501372591','2018-09-22'),(3,2557,'1402',0,9,1,'3341501372591','2018-09-22'),(4,2557,'1403',0,9,1,'3341501372591','2018-09-22'),(5,2557,'1404',0,9,1,'3341501372591','2018-09-22'),(6,2557,'1409',0,9,1,'3341501372591','2018-09-22'),(7,2557,'1410',0,9,1,'3341501372591','2018-09-22'),(8,2557,'1411',0,9,1,'3341501372591','2018-09-22'),(9,2557,'1414',0,9,1,'3341501372591','2018-09-22'),(10,2557,'1437',0,9,1,'3341501372591','2018-09-22'),(11,2557,'1453',0,9,1,'3341501372591','2018-09-22'),(12,2557,'1455',0,9,1,'3341501372591','2018-09-22'),(13,2557,'1469',0,9,1,'3341501372591','2018-09-22'),(14,2557,'1483',0,9,1,'3341501372591','2018-09-22'),(15,2557,'1506',0,9,1,'3341501372591','2018-09-22'),(16,2556,'1435',0,7,1,'3341501372591','2018-09-22'),(17,2556,'1470',0,7,1,'3341501372591','2018-09-22'),(18,2556,'1503',0,7,1,'3341501372591','2018-09-22'),(19,2556,'1421',0,8,1,'3341501372591','2018-09-22'),(20,2556,'1422',0,8,1,'3341501372591','2018-09-22'),(21,2556,'1423',0,8,1,'3341501372591','2018-09-22'),(22,2556,'1424',0,8,1,'3341501372591','2018-09-22'),(23,2556,'1425',0,8,1,'3341501372591','2018-09-22'),(24,2556,'1426',0,8,1,'3341501372591','2018-09-22'),(25,2556,'1447',0,8,1,'3341501372591','2018-09-22'),(26,2556,'1472',0,8,1,'3341501372591','2018-09-22'),(27,2556,'1488',0,8,1,'3341501372591','2018-09-22'),(28,2557,'1435',0,8,1,'3341501372591','2018-09-22'),(29,2557,'1470',0,8,1,'3341501372591','2018-09-22'),(30,2557,'1503',0,8,1,'3341501372591','2018-09-22'),(31,2557,'1421',0,9,1,'3341501372591','2018-09-22'),(32,2557,'1422',0,9,1,'3341501372591','2018-09-22'),(33,2557,'1423',0,9,1,'3341501372591','2018-09-22'),(34,2557,'1424',0,9,1,'3341501372591','2018-09-22'),(35,2557,'1425',0,9,1,'3341501372591','2018-09-22'),(36,2557,'1426',0,9,1,'3341501372591','2018-09-22'),(37,2557,'1447',0,9,1,'3341501372591','2018-09-22'),(38,2557,'1472',0,9,1,'3341501372591','2018-09-22'),(39,2557,'1488',0,9,1,'3341501372591','2018-09-22'),(40,2561,'1430',0,7,1,'3341501372591','2018-09-22'),(41,2561,'1431',0,7,1,'3341501372591','2018-09-22'),(42,2561,'1434',0,7,1,'3341501372591','2018-09-22'),(43,2561,'1440',0,6,1,'1349900600075','2018-09-22'),(44,2561,'1441',0,6,1,'3341501372591','2018-09-22'),(45,2561,'1442',0,6,1,'3341501372591','2018-09-22'),(46,2561,'1473',0,6,1,'3341501372591','2018-09-22'),(47,2561,'1482',0,6,1,'3341501372591','2018-09-22'),(48,2561,'1484',0,6,1,'3341501372591','2018-09-22'),(49,2560,'1456',0,5,1,'3341501372591','2018-09-22'),(50,2560,'1457',0,5,1,'3341501372591','2018-09-22'),(51,2560,'1458',0,5,1,'3341501372591','2018-09-22'),(52,2560,'1459',0,5,1,'3341501372591','2018-09-22'),(53,2560,'1460',0,5,1,'3341501372591','2018-09-22'),(54,2560,'1461',0,5,1,'3341501372591','2018-09-22'),(55,2560,'1462',0,5,1,'3341501372591','2018-09-22'),(56,2560,'1463',0,5,1,'3341501372591','2018-09-22'),(57,2560,'1471',0,5,1,'3341501372591','2018-09-22'),(58,2560,'1500',0,5,1,'3341501372591','2018-09-22'),(59,2560,'1501',0,5,1,'3341501372591','2018-09-22'),(60,2560,'1502',0,5,1,'3341501372591','2018-09-22'),(61,2561,'1500',0,9,1,'3341501372591','2018-09-22'),(62,2561,'1510',0,6,1,'3341501372591','2018-09-22'),(63,2561,'1495',0,7,1,'3341501372591','2018-09-22'),(64,2561,'1479',0,8,1,'3341501372591','2018-09-22'),(65,2561,'1480',0,8,1,'3341501372591','2018-09-22'),(66,2561,'1534',1,4,1,'1349900600075','2018-11-23'),(67,2561,'1508',0,6,1,'1349900600075','2018-11-23'),(68,2561,'1509',0,6,1,'1349900600075','2018-11-23'),(69,2561,'1511',0,6,1,'1349900600075','2018-11-23'),(70,2561,'1512',0,6,1,'1349900600075','2018-11-23'),(71,2561,'1513',0,6,1,'1349900600075','2018-11-23'),(72,2561,'1514',0,6,1,'1349900600075','2018-11-23'),(73,2561,'1492',0,7,1,'1349900600075','2018-11-23'),(74,2561,'1493',0,7,1,'1349900600075','2018-11-23'),(75,2561,'1496',0,7,1,'1349900600075','2018-11-23'),(76,2561,'1497',0,7,1,'1349900600075','2018-11-23'),(77,2561,'1498',0,7,1,'1349900600075','2018-11-23'),(78,2561,'1499',0,7,1,'1349900600075','2018-11-23'),(79,2561,'1474',0,8,1,'1349900600075','2018-11-23'),(80,2561,'1475',0,8,1,'1349900600075','2018-11-23'),(81,2561,'1476',0,8,1,'1349900600075','2018-11-23'),(82,2561,'1477',0,8,1,'1349900600075','2018-11-23'),(83,2561,'1478',0,8,1,'1349900600075','2018-11-23'),(84,2561,'1481',0,8,1,'1349900600075','2018-11-23'),(85,2561,'1504',0,8,1,'1349900600075','2018-11-23'),(86,2561,'1507',0,8,1,'1349900600075','2018-11-23'),(87,2561,'1456',0,9,1,'1349900600075','2018-11-23'),(88,2561,'1457',0,9,1,'1349900600075','2018-11-23'),(89,2561,'1458',0,9,1,'1349900600075','2018-11-23'),(90,2561,'1459',0,9,1,'1349900600075','2018-11-23'),(91,2561,'1460',0,9,1,'1349900600075','2018-11-23'),(92,2561,'1461',0,9,1,'1349900600075','2018-11-23'),(93,2561,'1462',0,9,1,'1349900600075','2018-11-23'),(94,2561,'1463',0,9,1,'1349900600075','2018-11-23'),(95,2561,'1471',0,9,1,'1349900600075','2018-11-23'),(96,2561,'1501',0,9,1,'1349900600075','2018-11-23'),(97,2561,'1502',0,9,1,'1349900600075','2018-11-23'),(98,2562,'1456',1,9,1,'3341501372591','2020-01-24'),(99,2562,'1457',2,9,1,'3341501372591','2020-01-24'),(100,2562,'1458',3,9,1,'3341501372591','2020-01-24'),(101,2562,'1459',4,9,1,'3341501372591','2020-01-24'),(102,2562,'1460',5,9,1,'3341501372591','2020-01-24'),(103,2562,'1461',6,9,1,'3341501372591','2020-01-24'),(104,2562,'1462',7,9,1,'3341501372591','2020-01-24'),(105,2562,'1463',8,9,1,'3341501372591','2020-01-24'),(106,2562,'1471',9,9,1,'3341501372591','2020-01-24'),(107,2562,'1501',10,9,1,'3341501372591','2020-01-24'),(108,2562,'1502',11,9,1,'3341501372591','2020-01-24'),(109,2562,'1507',7,9,1,'3341501372591','2020-01-24'),(110,2562,'1475',1,9,1,'3341501372591','2020-01-24'),(111,2562,'1476',2,9,1,'3341501372591','2020-01-24'),(112,2562,'1477',3,9,1,'3341501372591','2020-01-24'),(113,2562,'1480',5,9,1,'3341501372591','2020-01-24'),(114,2562,'1481',5,9,1,'3341501372591','2020-01-24'),(115,2562,'1504',6,9,1,'3341501372591','2020-01-24'),(116,2562,'1497',4,7,1,'3341501372591','2020-01-24'),(117,2562,'1578',9,8,1,'3341501372591','2020-01-24'),(118,2562,'1492',1,8,1,'3341501372591','2020-01-24'),(119,2562,'1493',2,8,1,'3341501372591','2020-01-24'),(120,2562,'1496',3,8,1,'3341501372591','2020-01-24'),(121,2562,'1498',5,8,1,'3341501372591','2020-01-24'),(122,2562,'1499',6,8,1,'3341501372591','2020-01-24'),(123,2562,'1516',7,8,1,'3341501372591','2020-01-24'),(124,2562,'1518',8,8,1,'3341501372591','2020-01-24'),(125,2562,'1538',9,8,1,'3341501372591','2020-01-24'),(126,2562,'1508',1,7,1,'3341501372591','2020-01-24'),(127,2562,'1509',2,7,1,'3341501372591','2020-01-24'),(128,2562,'1511',3,7,1,'3341501372591','2020-01-24'),(129,2562,'1512',4,7,1,'3341501372591','2020-01-24'),(130,2562,'1513',5,7,1,'3341501372591','2020-01-24'),(131,2562,'1531',6,7,1,'3341501372591','2020-01-24'),(132,2562,'1532',7,7,1,'3341501372591','2020-01-24'),(133,2562,'1533',8,8,1,'3341501372591','2020-01-24'),(134,2562,'1585',11,6,1,'3341501372591','2020-01-24'),(135,2562,'1519',1,6,1,'3341501372591','2020-01-24'),(136,2562,'1520',2,6,1,'3341501372591','2020-01-24'),(137,2562,'1522',3,6,1,'3341501372591','2020-01-24'),(138,2562,'1523',4,6,1,'3341501372591','2020-01-24'),(139,2562,'1525',5,6,1,'3341501372591','2020-01-24'),(140,2562,'1527',6,7,1,'3341501372591','2020-01-24'),(141,2562,'1556',10,6,1,'3341501372591','2020-01-24'),(142,2562,'1555',9,6,1,'3341501372591','2020-01-24'),(143,2562,'1554',8,6,1,'3341501372591','2020-01-24'),(144,2562,'1528',7,6,1,'3341501372591','2020-01-24'),(145,2562,'1572',8,4,1,'3341501372591','2020-01-24'),(146,2562,'1577',8,5,1,'3341501372591','2020-01-24'),(147,2562,'1534',1,5,1,'3341501372591','2020-01-24'),(148,2562,'1535',2,5,1,'3341501372591','2020-01-24'),(149,2562,'1536',3,5,1,'3341501372591','2020-01-24'),(150,2562,'1537',4,5,1,'3341501372591','2020-01-24'),(151,2562,'1565',5,5,1,'3341501372591','2020-01-24'),(152,2562,'1566',6,5,1,'3341501372591','2020-01-24'),(153,2562,'1567',7,5,1,'3341501372591','2020-01-24'),(154,2562,'1583',9,5,1,'3341501372591','2020-01-24'),(155,2562,'1540',2,3,1,'3341501372591','2020-01-24'),(156,2562,'1544',4,3,1,'3341501372591','2020-01-24'),(157,2562,'1550',14,4,1,'3341501372591','2020-01-24'),(158,2562,'1539',1,4,1,'3341501372591','2020-01-24'),(159,2562,'1541',2,4,1,'3341501372591','2020-01-24'),(160,2562,'1545',3,4,1,'3341501372591','2020-01-24'),(161,2562,'1547',4,4,1,'3341501372591','2020-01-24'),(162,2562,'1548',5,4,1,'3341501372591','2020-01-24'),(163,2562,'1549',6,4,1,'3341501372591','2020-01-24'),(164,2562,'1551',7,4,1,'3341501372591','2020-01-24'),(165,2562,'1573',8,4,1,'3341501372591','2020-01-24'),(166,2562,'1574',9,4,1,'3341501372591','2020-01-24'),(167,2562,'1575',10,4,1,'3341501372591','2020-01-24'),(168,2562,'1576',11,4,1,'3341501372591','2020-01-24'),(169,2562,'1584',12,4,1,'3341501372591','2020-01-24'),(170,2562,'1586',13,4,1,'1349900600075','2020-02-18'),(171,2562,'1587',5,3,1,'3341501372591','2020-01-24'),(172,2562,'1588',6,3,1,'3341501372591','2020-01-24'),(173,2562,'1568',1,3,1,'3341501372591','2020-01-24'),(174,2562,'1569',2,3,1,'3341501372591','2020-01-24'),(175,2562,'1570',3,3,1,'3341501372591','2020-01-24'),(176,2562,'1571',4,3,1,'3341501372591','2020-01-24'),(177,2562,'1579',1,2,1,'3341501372591','2020-01-24'),(178,2562,'1580',2,2,1,'3341501372591','2020-01-24'),(179,2562,'1581',3,2,1,'3341501372591','2020-01-24'),(180,2562,'1582',4,2,1,'3341501372591','2020-01-24'),(181,2562,'1590',5,2,1,'3341501372591','2020-01-24'),(182,2563,'1591',1,2,1,'1349900600075','2020-08-05'),(183,2563,'1592',2,2,1,'1349900600075','2020-08-05'),(184,2563,'1593',3,2,1,'1349900600075','2020-08-05'),(185,2563,'1570',3,4,1,'1349900600075','2020-08-05'),(186,2563,'1532',7,8,1,'1349900600075','2020-08-05'),(187,2563,'1594',6,4,1,'1349900600075','2020-08-05'),(188,2563,'1595',15,5,1,'1349900600075','2020-08-05'),(189,2563,'1509',2,8,1,'1349900600075','2020-08-05'),(190,2563,'1511',3,8,1,'1349900600075','2020-08-05'),(191,2563,'1512',4,8,1,'1349900600075','2020-08-05'),(192,2563,'1531',6,8,1,'1349900600075','2020-08-05'),(193,2563,'1528',7,7,1,'1349900600075','2020-08-05'),(194,2563,'1554',8,7,1,'1349900600075','2020-08-05'),(195,2563,'1585',11,7,1,'1349900600075','2020-08-05'),(196,2563,'1508',1,8,1,'1349900600075','2020-08-05'),(197,2563,'1533',7,8,1,'1349900600075','2020-08-05'),(198,2563,'1596',7,4,1,'1349900600075','2020-08-05'),(199,2562,'1591',1,2,1,'1349900600075','2020-08-05'),(200,2562,'1592',2,2,1,'1349900600075','2020-08-05'),(201,2562,'1593',3,2,1,'1349900600075','2020-08-05'),(202,2562,'1594',6,4,1,'1349900600075','2020-08-05'),(203,2562,'1596',7,4,1,'1349900600075','2020-08-05'),(204,2562,'1595',15,5,1,'1349900600075','2020-08-05'),(205,2563,'1579',1,3,1,'1349900600075','2020-08-05'),(206,2563,'1580',2,3,1,'1349900600075','2020-08-05'),(207,2563,'1581',3,3,1,'1349900600075','2020-08-05'),(208,2563,'1582',4,3,1,'1349900600075','2020-08-05'),(209,2563,'1590',5,3,1,'1349900600075','2020-08-05'),(210,2563,'1568',1,4,1,'1349900600075','2020-08-05'),(211,2563,'1569',2,4,1,'1349900600075','2020-08-05'),(212,2563,'1571',4,4,1,'1349900600075','2020-08-05'),(213,2563,'1587',5,4,1,'1349900600075','2020-08-05'),(214,2563,'1588',6,4,1,'1349900600075','2020-08-05'),(215,2563,'1539',1,5,1,'1349900600075','2020-08-05'),(216,2563,'1541',2,5,1,'1349900600075','2020-08-05'),(217,2563,'1545',3,5,1,'1349900600075','2020-08-05'),(218,2563,'1547',4,5,1,'1349900600075','2020-08-05'),(219,2563,'1548',5,5,1,'1349900600075','2020-08-05'),(220,2563,'1551',7,5,1,'1349900600075','2020-08-05'),(221,2563,'1566',6,6,1,'1349900600075','2020-08-05'),(222,2563,'1573',8,5,1,'1349900600075','2020-08-05'),(223,2563,'1574',9,5,1,'1349900600075','2020-08-05'),(224,2563,'1575',10,5,1,'1349900600075','2020-08-05'),(225,2563,'1576',11,5,1,'1349900600075','2020-08-05'),(226,2563,'1584',12,5,1,'1349900600075','2020-08-05'),(227,2563,'1586',13,5,1,'1349900600075','2020-08-05'),(228,2563,'1550',14,5,1,'1349900600075','2020-08-05'),(229,2563,'1534',1,6,1,'1349900600075','2020-08-05'),(230,2563,'1535',2,6,1,'1349900600075','2020-08-05'),(231,2563,'1536',3,6,1,'1349900600075','2020-08-05'),(232,2563,'1537',4,6,1,'1349900600075','2020-08-05'),(233,2563,'1565',5,6,1,'1349900600075','2020-08-05'),(234,2563,'1567',7,6,1,'1349900600075','2020-08-05'),(235,2563,'1577',8,6,1,'1349900600075','2020-08-05'),(236,2563,'1555',9,7,1,'1349900600075','2020-08-05'),(237,2563,'1583',9,6,1,'1349900600075','2020-08-05'),(238,2563,'1556',10,7,1,'1349900600075','2020-08-05'),(239,2563,'1519',1,7,1,'1349900600075','2020-08-05'),(240,2563,'1520',2,7,1,'1349900600075','2020-08-05'),(241,2563,'1522',3,7,1,'1349900600075','2020-08-05'),(242,2563,'1525',5,7,1,'1349900600075','2020-08-05'),(243,2563,'1549',6,5,1,'1349900600075','2020-08-05'),(244,2563,'1523',4,7,1,'1349900600075','2020-08-05'),(245,2563,'1513',5,8,1,'1349900600075','2020-08-05'),(246,2563,'1498',4,9,1,'1349900600075','2020-08-05'),(247,2563,'1499',5,9,1,'1349900600075','2020-08-05'),(248,2563,'1516',6,9,1,'1349900600075','2020-08-05'),(249,2563,'1518',7,9,1,'1349900600075','2020-08-05'),(250,2563,'1538',8,9,1,'1349900600075','2020-08-05'),(251,2563,'1598',12,7,1,'1349900600075','2021-01-13'),(252,2563,'1597',8,4,1,'1349900600075','2021-01-13'),(253,2564,'1492',1,9,1,'1349900600075','2022-09-17'),(254,2564,'1493',2,9,1,'1349900600075','2022-09-17'),(255,2564,'1496',3,9,1,'1349900600075','2022-09-17'),(256,2564,'1498',4,9,1,'1349900600075','2022-09-17'),(257,2564,'1499',5,9,1,'1349900600075','2022-09-17'),(258,2564,'1516',6,9,1,'1349900600075','2022-09-17'),(259,2564,'1518',7,9,1,'1349900600075','2022-09-17'),(260,2564,'1538',8,9,1,'1349900600075','2022-09-17'),(261,2564,'1578',9,9,1,'1349900600075','2022-09-17'),(262,2564,'1508',1,8,1,'1349900600075','2022-09-17'),(263,2564,'1509',2,8,1,'1349900600075','2022-09-17'),(264,2564,'1511',3,8,1,'1349900600075','2022-09-17'),(265,2564,'1512',4,8,1,'1349900600075','2022-09-17'),(266,2564,'1513',5,8,1,'1349900600075','2022-09-17'),(267,2564,'1531',6,8,1,'1349900600075','2022-09-17'),(268,2564,'1533',7,8,1,'1349900600075','2022-09-17'),(269,2564,'1527',6,7,1,'1349900600075','2022-09-17'),(270,2564,'1528',7,7,1,'1349900600075','2022-09-17'),(271,2564,'1554',8,7,1,'1349900600075','2022-09-17'),(272,2564,'1555',9,7,1,'1349900600075','2022-09-17'),(273,2564,'1556',10,7,1,'1349900600075','2022-09-17'),(274,2564,'1585',11,7,1,'1349900600075','2022-09-17'),(275,2564,'1598',12,7,1,'1349900600075','2022-09-17'),(276,2564,'1591',1,2,1,'1349900600075','2022-09-17'),(277,2564,'1592',2,2,1,'1349900600075','2022-09-17'),(278,2564,'1593',3,2,1,'1349900600075','2022-09-17'),(279,2564,'1579',1,3,1,'1349900600075','2022-09-17'),(280,2564,'1580',2,3,1,'1349900600075','2022-09-17'),(281,2564,'1581',3,3,1,'1349900600075','2022-09-17'),(282,2564,'1582',4,3,1,'1349900600075','2022-09-17'),(283,2564,'1590',5,3,1,'1349900600075','2022-09-17'),(284,2564,'1568',1,4,1,'1349900600075','2022-09-17'),(285,2564,'1569',2,4,1,'1349900600075','2022-09-17'),(286,2564,'1571',4,4,1,'1349900600075','2022-09-17'),(287,2564,'1587',5,4,1,'1349900600075','2022-09-17'),(288,2564,'1588',6,4,1,'1349900600075','2022-09-17'),(289,2564,'1594',6,4,1,'1349900600075','2022-09-17'),(290,2564,'1596',7,4,1,'1349900600075','2022-09-17'),(291,2564,'1597',8,4,1,'1349900600075','2022-09-17'),(292,2564,'1539',1,5,1,'1349900600075','2022-09-17'),(293,2564,'1541',2,5,1,'1349900600075','2022-09-17'),(294,2564,'1545',3,5,1,'1349900600075','2022-09-17'),(295,2564,'1547',4,5,1,'1349900600075','2022-09-17'),(296,2564,'1548',5,5,1,'1349900600075','2022-09-17'),(297,2564,'1549',6,5,1,'1349900600075','2022-09-17'),(298,2564,'1551',7,5,1,'1349900600075','2022-09-17'),(299,2564,'1573',8,5,1,'1349900600075','2022-09-17'),(300,2564,'1574',9,5,1,'1349900600075','2022-09-17'),(301,2564,'1575',10,5,1,'1349900600075','2022-09-17'),(302,2564,'1576',11,5,1,'1349900600075','2022-09-17'),(303,2564,'1584',12,5,1,'1349900600075','2022-09-17'),(304,2564,'1586',13,5,1,'1349900600075','2022-09-17'),(305,2564,'1550',14,5,1,'1349900600075','2022-09-17'),(306,2564,'1595',15,5,1,'1349900600075','2022-09-17'),(307,2564,'1534',1,6,1,'1349900600075','2022-09-17'),(308,2564,'1535',2,6,1,'1349900600075','2022-09-17'),(309,2564,'1536',3,6,1,'1349900600075','2022-09-17'),(310,2564,'1537',4,6,1,'1349900600075','2022-09-17'),(311,2564,'1565',5,6,1,'1349900600075','2022-09-17'),(312,2564,'1566',6,6,1,'1349900600075','2022-09-17'),(313,2564,'1567',7,6,1,'1349900600075','2022-09-17'),(314,2564,'1577',8,6,1,'1349900600075','2022-09-17'),(315,2564,'1583',9,6,1,'1349900600075','2022-09-17'),(316,2564,'1519',1,7,1,'1349900600075','2022-09-17'),(317,2564,'1520',2,7,1,'1349900600075','2022-09-17'),(318,2564,'1522',3,7,1,'1349900600075','2022-09-17'),(319,2564,'1523',4,7,1,'1349900600075','2022-09-17'),(320,2564,'1525',5,7,1,'1349900600075','2022-09-17'),(321,2565,'1618',1,2,1,'1349900600075','2022-09-17'),(322,2565,'1620',2,2,1,'1349900600075','2022-09-17'),(323,2565,'1621',3,2,1,'1349900600075','2022-09-17'),(324,2565,'1623',4,2,1,'1349900600075','2022-09-17'),(325,2565,'1600',1,3,1,'1349900600075','2022-09-17'),(326,2565,'1601',2,3,1,'1349900600075','2022-09-17'),(327,2565,'1602',3,3,1,'1349900600075','2022-09-17'),(328,2565,'1603',4,3,1,'1349900600075','2022-09-17'),(329,2565,'1604',5,3,1,'1349900600075','2022-09-17'),(330,2565,'1605',6,3,1,'1349900600075','2022-09-17'),(331,2565,'1611',7,3,1,'1349900600075','2022-09-17'),(332,2565,'1616',8,3,1,'1349900600075','2022-09-17'),(333,2565,'1622',4,4,1,'1349900600075','2022-09-17'),(334,2565,'1612',5,4,1,'1349900600075','2022-09-17'),(335,2565,'1613',6,4,1,'1349900600075','2022-09-17'),(336,2565,'1614',7,4,1,'1349900600075','2022-09-17'),(337,2565,'1615',8,4,1,'1349900600075','2022-09-17'),(338,2565,'1599',6,5,1,'1349900600075','2022-09-17'),(339,2565,'1607',7,5,1,'1349900600075','2022-09-17'),(340,2565,'1609',8,5,1,'1349900600075','2022-09-17'),(341,2565,'1587',5,6,1,'1349900600075','2022-09-17'),(342,2565,'1584',12,7,1,'1349900600075','2022-09-17'),(343,2565,'1586',13,7,1,'1349900600075','2022-09-17'),(344,2565,'1624',10,8,1,'1349900600075','2022-09-17'),(345,2565,'1585',11,9,1,'1349900600075','2022-09-17'),(346,2565,'1528',7,9,1,'1349900600075','2022-12-19'),(347,2565,'1598',12,9,1,'1349900600075','2022-12-19'),(348,2565,'1519',1,9,1,'1349900600075','2023-09-12'),(349,2565,'1520',2,9,1,'1349900600075','2023-09-12'),(350,2565,'1522',3,9,1,'1349900600075','2023-09-12'),(351,2565,'1523',4,9,1,'1349900600075','2023-09-12'),(352,2565,'1525',5,9,1,'1349900600075','2023-09-12'),(353,2565,'1527',6,9,1,'1349900600075','2023-09-12'),(354,2565,'1554',8,9,1,'1349900600075','2023-09-12'),(355,2565,'1555',9,9,1,'1349900600075','2023-09-12'),(356,2565,'1556',10,9,1,'1349900600075','2023-09-12'),(357,2566,'1583',9,8,1,'1349900600075','2023-09-12'),(358,2566,'1597',8,6,1,'1349900600075','2023-09-12'),(359,2566,'1549',6,7,1,'1349900600075','2023-09-12'),(360,2566,'1595',15,7,1,'1349900600075','2023-09-12'),(361,2565,'1534',1,8,1,'1349900600075','2023-09-12'),(362,2565,'1535',2,8,1,'1349900600075','2023-09-12'),(363,2565,'1536',3,8,1,'1349900600075','2023-09-12'),(364,2565,'1537',4,8,1,'1349900600075','2023-09-12'),(365,2565,'1565',5,8,1,'1349900600075','2023-09-12'),(366,2565,'1566',6,8,1,'1349900600075','2023-09-12'),(367,2565,'1567',7,8,1,'1349900600075','2023-09-12'),(368,2565,'1577',8,8,1,'1349900600075','2023-09-12'),(369,2565,'1591',1,4,1,'1349900600075','2023-09-12'),(370,2565,'1592',2,4,1,'1349900600075','2023-09-12'),(371,2565,'1593',3,4,1,'1349900600075','2023-09-12'),(372,2565,'1579',1,5,1,'1349900600075','2023-09-12'),(373,2565,'1580',2,5,1,'1349900600075','2023-09-12'),(374,2565,'1581',3,5,1,'1349900600075','2023-09-12'),(375,2565,'1582',4,5,1,'1349900600075','2023-09-12'),(376,2565,'1590',5,5,1,'1349900600075','2023-09-12'),(377,2565,'1568',1,6,1,'1349900600075','2023-09-12'),(378,2565,'1569',2,6,1,'1349900600075','2023-09-12'),(379,2565,'1571',4,6,1,'1349900600075','2023-09-12'),(380,2565,'1588',6,6,1,'1349900600075','2023-09-12'),(381,2565,'1594',6,6,1,'1349900600075','2023-09-12'),(382,2565,'1596',7,6,1,'1349900600075','2023-09-12'),(383,2565,'1539',1,7,1,'1349900600075','2023-09-12'),(384,2565,'1541',2,7,1,'1349900600075','2023-09-12'),(385,2565,'1545',3,7,1,'1349900600075','2023-09-12'),(386,2565,'1547',4,7,1,'1349900600075','2023-09-12'),(387,2565,'1548',5,7,1,'1349900600075','2023-09-12'),(388,2565,'1551',7,7,1,'1349900600075','2023-09-12'),(389,2565,'1573',8,7,1,'1349900600075','2023-09-12'),(390,2565,'1574',9,7,1,'1349900600075','2023-09-12'),(391,2565,'1575',10,7,1,'1349900600075','2023-09-12'),(392,2565,'1576',11,7,1,'1349900600075','2023-09-12'),(393,2565,'1550',14,7,1,'1349900600075','2023-09-12'),(394,2566,'1626',1,2,1,'1349900600075','2023-09-12'),(395,2566,'1627',2,2,1,'1349900600075','2023-09-12'),(396,2566,'1628',3,2,1,'1349900600075','2023-09-12'),(397,2566,'1629',4,2,1,'1349900600075','2023-09-12'),(398,2566,'1630',5,2,1,'1349900600075','2023-09-12'),(399,2566,'1631',6,2,1,'1349900600075','2023-09-12'),(400,2566,'1632',7,2,1,'1349900600075','2023-09-12'),(401,2566,'1633',8,2,1,'1349900600075','2023-09-12'),(402,2566,'1625',5,3,1,'1349900600075','2023-09-12'),(403,2566,'1634',6,3,1,'1349900600075','2023-09-12'),(404,2566,'1635',9,4,1,'1349900600075','2023-09-12'),(405,2566,'1636',10,4,1,'1349900600075','2023-09-12'),(406,2566,'1637',11,4,1,'1349900600075','2023-09-12'),(407,2566,'1638',12,4,1,'1349900600075','2023-09-12'),(408,2566,'1639',13,4,1,'1349900600075','2023-09-12'),(409,2566,'1640',9,5,1,'1349900600075','2023-09-12'),(410,2566,'1641',9,6,1,'1349900600075','2023-09-12'),(411,2566,'1642',10,6,1,'1349900600075','2023-09-12'),(412,2566,'1571',3,7,1,'1349900600075','2023-09-12'),(413,2566,'1588',4,7,1,'1349900600075','2023-09-12'),(414,2566,'1594',5,7,1,'1349900600075','2023-09-12'),(415,2566,'1596',6,7,1,'1349900600075','2023-09-12'),(416,2566,'1610',7,7,1,'1349900600075','2023-09-12'),(417,2566,'1624',9,9,1,'1349900600075','2023-09-12');

--
-- 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,2558,0),(3,2559,0),(4,2560,0),(5,2561,0),(6,2562,0),(7,2563,0),(8,2564,0),(9,2565,0),(10,2566,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 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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


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

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

INSERT INTO `student_main_permission` VALUES (1,'3341700207034',1,'3341700207034','2025-08-17'),(2,'1341500246153',1,'3341700207034','2025-08-17');

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

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

INSERT INTO `system_module_admin` VALUES (2,'3650800096192','achievement','7777','2014-09-14'),(66,'3349900180731','bookregister','3341900313156','2014-09-14'),(4,'3349800158318','budget','7777','2014-09-14'),(54,'3650800096192','la','3341900313156','2014-09-14'),(53,'3341900313156','la','3341900313156','2014-09-14'),(86,'1349900228036','savings','3341900313156','2014-09-14'),(84,'3650800096192','permission','3341900313156','2014-09-14'),(85,'3341501372591','plan','3341900313156','2014-09-14'),(11,'3349800079248','person','7777','2014-09-14'),(12,'3349800081951','plan','7777','2014-09-14'),(13,'3341900313156','savings','7777','2014-09-14'),(14,'3341500267939','standard','7777','2014-09-14'),(15,'3349800081951','student_check','7777','2014-09-14'),(16,'3650800096192','student_main','7777','2014-09-14'),(17,'3341501372591','work','7777','2014-09-14'),(18,'3341900313156','achievement','7777','2014-09-14'),(64,'3349800158318','bookregister','3341900313156','2014-09-14'),(20,'3341900313156','budget','7777','2014-09-14'),(37,'3650800096192','health','3341900313156','2014-09-14'),(34,'3341500267939','cabinet','3341900313156','2014-09-14'),(33,'3341900313156','cabinet','3341900313156','2014-09-14'),(35,'3341900313156','health','3341900313156','2014-09-14'),(82,'3650800096192','mail','3341900313156','2014-09-14'),(49,'3650800096192','meeting','3341900313156','2014-09-14'),(50,'3349800081951','permission','3341900313156','2014-09-14'),(51,'3341501372591','person','3341900313156','2014-09-14'),(55,'3349900180731','achievement','3341900313156','2014-09-14'),(65,'3341900313156','bookregister','3341900313156','2014-09-14'),(67,'3349900180731','cabinet','3341900313156','2014-09-14'),(68,'341500100680','health','3341900313156','2014-09-14'),(69,'3349900180731','la','3341900313156','2014-09-14'),(83,'3341900313156','mail','3341900313156','2014-09-14'),(87,'3341501372591','standard','3341900313156','2014-09-14'),(88,'3341501372591','budget','3341900313156','2014-09-14'),(89,'3349800158318','plan','7777','2015-08-09'),(90,'3341900313156','plan','7777','2015-08-09'),(91,'3349800158318','budget','7777','2015-08-09'),(92,'3341900313156','budget','7777','2015-08-09'),(93,'3349900180731','book','3349900180731','2018-09-22'),(94,'3341501372591','book','3349900180731','2018-09-22'),(95,'1349900600075','book','7777','2018-11-02'),(96,'1349900600075','achievement','7777','2018-11-02'),(97,'1349900600075','amss_bets','7777','2018-11-02'),(98,'1349900600075','amss_budget','7777','2018-11-02'),(99,'1349900600075','amss_mail','7777','2018-11-02'),(100,'1349900600075','amss_opportunity','7777','2018-11-02'),(101,'1349900600075','amss_spacial_student','7777','2018-11-02'),(102,'1349900600075','amss_supervision','7777','2018-11-02'),(103,'1349900600075','bookregister','7777','2018-11-02'),(104,'1349900600075','budget','7777','2018-11-02'),(105,'1349900600075','cabinet','7777','2018-11-02'),(106,'1349900600075','la','7777','2018-11-02'),(107,'1349900600075','mail','7777','2018-11-02'),(108,'1349900600075','meeting','7777','2018-11-02'),(109,'1349900600075','permission','7777','2018-11-02'),(110,'1349900600075','person','7777','2018-11-02'),(111,'1349900600075','work','1349900600075','2018-11-14'),(112,'1349900600075','savings','1349900600075','2018-11-14'),(113,'1349900600075','health','1349900600075','2018-11-14'),(114,'1349900600075','bets','1349900600075','2018-11-14'),(115,'1349900600075','student_main','7777','2018-11-14'),(116,'1349900600075','student_check','7777','2018-11-14'),(117,'1349900600075','affair','7777','2018-11-14'),(118,'1349900600075','delegate','7777','2018-11-14'),(119,'1349900600075','plan','7777','2018-11-14'),(120,'1349900580635','student_check','7777','2018-11-23'),(121,'3650800096192','student_check','7777','2018-11-23'),(122,'3341500267939','student_check','7777','2018-11-23'),(123,'1349900722561','student_check','7777','2018-11-23'),(124,'1341900313156','student_check','7777','2018-11-23'),(125,'3349800079248','student_check','7777','2018-11-23');

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

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

INSERT INTO `system_sync_code` VALUES (4,'34040054','amssplus','34040054','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,'บริหารวิชาการ',4),(2,2,'บริหารงบประมาณ',6),(3,3,'บริหารงานบุคคล',8),(4,4,'บริหารทั่วไป',10);

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

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

INSERT INTO `work_main` VALUES (1,'2018-09-21','3341501372591',1,NULL,'2018-09-22 13:44:38','3341501372591'),(2,'2018-09-21','3650800096192',1,NULL,'2018-09-22 13:44:38','3341501372591'),(3,'2018-09-21','3349800081951',1,NULL,'2018-09-22 13:44:38','3341501372591'),(4,'2018-09-21','3341500267939',1,NULL,'2018-09-22 13:44:38','3341501372591'),(5,'2018-09-21','3349800079248',1,NULL,'2018-09-22 13:44:38','3341501372591'),(6,'2018-09-21','3341900313156',1,NULL,'2018-09-22 13:44:38','3341501372591'),(7,'2018-09-21','3341500214401',1,NULL,'2018-09-22 13:44:38','3341501372591'),(8,'2018-09-21','3349900180731',1,NULL,'2018-09-22 13:44:38','3341501372591'),(9,'2018-10-01','3341501372591',1,NULL,'2018-10-01 11:36:58','3349900180731'),(10,'2018-10-01','3650800096192',1,NULL,'2018-10-01 11:36:58','3349900180731'),(11,'2018-10-01','3349800081951',1,NULL,'2018-10-01 11:36:58','3349900180731'),(12,'2018-10-01','3341500267939',1,NULL,'2018-10-01 11:36:58','3349900180731'),(13,'2018-10-01','3349800079248',1,NULL,'2018-10-01 11:36:58','3349900180731'),(14,'2018-10-01','3341900313156',1,NULL,'2018-10-01 11:36:58','3349900180731'),(15,'2018-10-01','3341500214401',1,NULL,'2018-10-01 11:36:58','3349900180731'),(16,'2018-10-01','3349900180731',1,NULL,'2018-10-01 11:36:58','3349900180731'),(17,'2018-10-02','3341501372591',1,NULL,'2018-10-02 09:40:04','3349900180731'),(18,'2018-10-02','3650800096192',1,NULL,'2018-10-02 09:40:04','3349900180731'),(19,'2018-10-02','3349800081951',1,NULL,'2018-10-02 09:40:04','3349900180731'),(20,'2018-10-02','3341500267939',1,NULL,'2018-10-02 09:40:04','3349900180731'),(21,'2018-10-02','3349800079248',1,NULL,'2018-10-02 09:40:04','3349900180731'),(22,'2018-10-02','3341900313156',1,NULL,'2018-10-02 09:40:04','3349900180731'),(23,'2018-10-02','3341500214401',1,NULL,'2018-10-02 09:40:04','3349900180731'),(24,'2018-10-02','3349900180731',1,NULL,'2018-10-02 09:40:04','3349900180731'),(25,'2018-11-02','3341501372591',1,NULL,'2018-11-02 12:40:05','3341501372591'),(26,'2018-11-02','3650800096192',1,NULL,'2018-11-02 12:40:05','3341501372591'),(27,'2018-11-02','3349800081951',1,NULL,'2018-11-02 12:40:05','3341501372591'),(28,'2018-11-02','3341500267939',1,NULL,'2018-11-02 12:40:05','3341501372591'),(29,'2018-11-02','3349800079248',1,NULL,'2018-11-02 12:40:05','3341501372591'),(30,'2018-11-02','3341900313156',1,NULL,'2018-11-02 12:40:05','3341501372591'),(31,'2018-11-02','3341500214401',1,NULL,'2018-11-02 12:40:05','3341501372591'),(32,'2018-11-02','1349900600075',1,NULL,'2018-11-02 12:40:05','3341501372591'),(33,'2018-11-02','3349900180731',1,NULL,'2018-11-02 12:40:05','3341501372591'),(34,'2018-11-14','3341501372591',1,NULL,'2018-11-14 11:32:35','1349900600075'),(35,'2018-11-14','3349800079248',1,NULL,'2018-11-14 11:32:35','1349900600075'),(36,'2018-11-14','3349800081951',1,NULL,'2018-11-14 11:32:35','1349900600075'),(37,'2018-11-14','3341500267939',1,NULL,'2018-11-14 11:32:35','1349900600075'),(38,'2018-11-14','3650800096192',1,NULL,'2018-11-14 11:32:35','1349900600075'),(39,'2018-11-14','3341900313156',1,NULL,'2018-11-14 11:32:35','1349900600075'),(40,'2018-11-14','3341500214401',1,NULL,'2018-11-14 11:32:35','1349900600075'),(41,'2018-11-14','3349900180731',1,NULL,'2018-11-14 11:32:35','1349900600075'),(42,'2018-11-14','1349900600075',1,NULL,'2018-11-14 11:32:35','1349900600075');

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

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

INSERT INTO `work_permission` VALUES (1,'3341700207034',1,'3341700207034','2025-08-17'),(2,'3349900180731',1,'3341501372591','2018-09-22'),(3,'1349900600075',1,'3341501372591','2018-11-02');


