('2023-03-21',1617,3,1,2565,'C','3341500771599','2023-03-27 09:03:42'),('2023-03-21',1621,3,1,2565,'C','3341500771599','2023-03-27 09:03:42'),('2023-03-21',1622,3,1,2565,'C','3341500771599','2023-03-27 09:03:42'),('2023-03-21',1619,4,1,2565,'C','3341500771599','2023-03-27 09:03:53'),('2023-03-21',1610,5,1,2565,'C','3341500771599','2023-03-27 09:03:08'),('2023-03-21',1623,5,1,2565,'C','3341500771599','2023-03-27 09:03:08'),('2023-03-21',1624,5,1,2565,'C','3341500771599','2023-03-27 09:03:08'),('2023-03-21',1618,6,1,2565,'C','3341500771599','2023-03-27 09:03:19'),('2023-03-21',1606,7,1,2565,'C','3341500771599','2023-03-27 09:03:30'),('2023-03-21',1607,7,1,2565,'C','3341500771599','2023-03-27 09:03:30'),('2023-03-21',1604,9,1,2565,'C','3341500771599','2023-03-27 09:03:44'),('2023-03-21',1615,9,1,2565,'C','3341500771599','2023-03-27 09:03:44'),('2023-03-22',1620,2,1,2565,'C','3341500771599','2023-03-27 09:03:57'),('2023-03-22',1617,3,1,2565,'C','3341500771599','2023-03-27 09:03:08'),('2023-03-22',1621,3,1,2565,'C','3341500771599','2023-03-27 09:03:08'),('2023-03-22',1622,3,1,2565,'C','3341500771599','2023-03-27 09:03:08'),('2023-03-22',1619,4,1,2565,'C','3341500771599','2023-03-27 09:03:21'),('2023-03-22',1610,5,1,2565,'C','3341500771599','2023-03-27 09:03:31'),('2023-03-22',1623,5,1,2565,'C','3341500771599','2023-03-27 09:03:31'),('2023-03-22',1624,5,1,2565,'C','3341500771599','2023-03-27 09:03:31'),('2023-03-22',1618,6,1,2565,'C','3341500771599','2023-03-27 09:03:43'),('2023-03-22',1606,7,1,2565,'C','3341500771599','2023-03-27 09:03:59'),('2023-03-22',1607,7,1,2565,'C','3341500771599','2023-03-27 09:03:59'),('2023-03-22',1604,9,1,2565,'C','3341500771599','2023-03-27 09:03:11'),('2023-03-22',1615,9,1,2565,'C','3341500771599','2023-03-27 09:03:11'),('2023-03-23',1620,2,1,2565,'C','3341500771599','2023-03-27 09:03:26'),('2023-03-23',1617,3,1,2565,'C','3341500771599','2023-03-27 09:03:37'),('2023-03-23',1621,3,1,2565,'C','3341500771599','2023-03-27 09:03:37'),('2023-03-23',1622,3,1,2565,'C','3341500771599','2023-03-27 09:03:37'),('2023-03-23',1619,4,1,2565,'C','3341500771599','2023-03-27 09:03:47'),('2023-03-23',1610,5,1,2565,'C','3341500771599','2023-03-27 09:03:57'),('2023-03-23',1623,5,1,2565,'C','3341500771599','2023-03-27 09:03:57'),('2023-03-23',1624,5,1,2565,'C','3341500771599','2023-03-27 09:03:57'),('2023-03-23',1618,6,1,2565,'C','3341500771599','2023-03-27 09:03:08'),('2023-03-23',1606,7,1,2565,'C','3341500771599','2023-03-27 09:03:17'),('2023-03-23',1607,7,1,2565,'C','3341500771599','2023-03-27 09:03:17'),('2023-03-23',1604,9,1,2565,'C','3341500771599','2023-03-27 09:03:28'),('2023-03-23',1615,9,1,2565,'C','3341500771599','2023-03-27 09:03:28'),('2023-03-24',1620,2,1,2565,'C','3341500771599','2023-03-27 09:03:41'),('2023-03-24',1617,3,1,2565,'C','3341500771599','2023-03-27 09:03:56'),('2023-03-24',1621,3,1,2565,'C','3341500771599','2023-03-27 09:03:56'),('2023-03-24',1622,3,1,2565,'C','3341500771599','2023-03-27 09:03:56'),('2023-03-27',1619,4,1,2565,'C','3341500771599','2023-03-27 09:03:08'),('2023-03-24',1619,4,1,2565,'C','3341500771599','2023-03-27 09:03:22'),('2023-03-24',1610,5,1,2565,'C','3341500771599','2023-03-27 09:03:39'),('2023-03-24',1623,5,1,2565,'C','3341500771599','2023-03-27 09:03:39'),('2023-03-24',1624,5,1,2565,'C','3341500771599','2023-03-27 09:03:39'),('2023-03-24',1618,6,1,2565,'C','3341500771599','2023-03-27 09:03:55'),('2023-03-27',1606,7,1,2565,'C','3341500771599','2023-03-27 09:03:06'),('2023-03-27',1607,7,1,2565,'C','3341500771599','2023-03-27 09:03:06'),('2023-03-27',1604,9,1,2565,'C','3341500771599','2023-03-27 09:03:17'),('2023-03-27',1615,9,1,2565,'C','3341500771599','2023-03-27 09:03:17'),('2023-05-16',1620,2,1,2565,'C','3341500771599','2023-05-26 08:05:18'),('2023-10-24',1620,3,1,2566,'C','3341500771599','2023-10-24 07:10:35'),('2023-10-24',1621,4,1,2566,'C','3341500771599','2023-10-24 07:10:42'),('2023-10-24',1622,4,1,2566,'C','3341500771599','2023-10-24 07:10:42'),('2023-10-24',1619,5,1,2566,'C','3341500771599','2023-10-24 07:10:38'),('2023-10-24',1610,6,1,2566,'C','3341500771599','2023-10-24 07:10:46'),('2023-10-24',1623,6,1,2566,'C','3341500771599','2023-10-24 07:10:46'),('2023-10-24',1624,6,1,2566,'C','3341500771599','2023-10-24 07:10:46'),('2023-10-24',1618,7,1,2566,'C','3341500771599','2023-10-24 07:10:56'),('2023-10-24',1606,8,1,2566,'C','3341500771599','2023-10-24 07:10:04'),('2023-10-24',1607,8,1,2566,'C','3341500771599','2023-10-24 07:10:04'),('2023-10-24',1625,8,1,2566,'C','3341500771599','2023-10-24 07:10:04');

--
-- 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,'3349800155637',2558),(3,1,'3349800155637',2558),(4,1,'1311190001611',2558),(5,1,'1311190001611',2558),(6,1,'3349800168551',2558),(7,1,'3349800168551',2558),(8,1,'3330500134466',2558),(9,1,'3330500134466',2558),(7,1,'1311190001611',2559),(8,1,'3330500134466',2559),(9,1,'3330500134466',2559),(6,1,'3349800168551',2559),(2,1,'3341500771599',2559),(3,1,'3341500771599',2559),(4,1,'3341500771599',2559),(5,1,'3341500771599',2559),(6,1,'3341500771599',2559),(8,1,'3341500771599',2559),(9,1,'3341500771599',2559),(2,1,'3349800155637',2561),(2,1,'3341500771599',2561),(3,1,'3349800155637',2561),(3,1,'3341500771599',2561),(4,1,'3349800155637',2561),(4,1,'3341500771599',2561),(5,1,'3349800155637',2561),(5,1,'3341500771599',2561),(6,1,'3349800155637',2561),(6,1,'3341500771599',2561),(8,1,'3330500134466',2561),(8,1,'3341500771599',2561),(9,1,'3330500134466',2561),(9,1,'3341500771599',2561),(2,1,'3349800155637',2563),(2,1,'3341500771599',2563),(4,1,'3349800155637',2563),(4,1,'3341500771599',2563),(6,1,'3349800155637',2563),(6,1,'3341500771599',2563),(7,1,'1339900429554',2563),(7,1,'3341500771599',2563),(8,1,'1339900429554',2563),(8,1,'3341500771599',2563),(9,1,'1339900429554',2563),(9,1,'3341500771599',2563),(5,1,'3349800155637',2563),(5,1,'3341500771599',2563),(3,1,'3349800155637',2563),(3,1,'3341500771599',2563),(2,1,'3341500771599',2564),(3,1,'3349800155637',2564),(3,1,'3341500771599',2564),(2,1,'3349800155637',2564),(4,1,'3349800155637',2564),(4,1,'3341500771599',2564),(5,1,'3349800155637',2564),(5,1,'3341500771599',2564),(6,1,'3349800155637',2564),(6,1,'3341500771599',2564),(7,1,'3349800155637',2564),(7,1,'3341500771599',2564),(8,1,'3349800155637',2564),(8,1,'3341500771599',2564),(9,1,'3349800155637',2564),(9,1,'3341500771599',2564),(2,1,'3341500771599',2565),(3,1,'3341500771599',2565),(4,1,'3341500771599',2565),(5,1,'3341500771599',2565),(6,1,'3341500771599',2565),(7,1,'3341500771599',2565),(9,1,'3341500771599',2565),(2,1,'3341500771599',2566),(3,1,'3341500771599',2566),(4,1,'3341500771599',2566),(5,1,'3341500771599',2566),(6,1,'3341500771599',2566),(7,1,'3341500771599',2566),(9,1,'3341500771599',2566),(8,1,'3341500771599',2566);

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

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

INSERT INTO `student_check_year` VALUES (1,2558,0),(2,2559,0),(3,2561,0),(4,2563,0),(5,2564,0),(6,2565,0),(7,2566,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=66 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `student_main` VALUES (64,'1625',3,'เด็กหญิง','อังคณา','สวัสดี','1349901901427',2,'',9,1,2,2567,'3341500771599','2023-09-22'),(63,'1624',1,'เด็กชาย','พณภัทร','จันทร์แจ่มศรี','1819900998511',1,'',8,1,0,NULL,'3341500771599','2023-02-02'),(62,'1623',2,'เด็กชาย','ธนพล','สุวรรณา','1347600093656',1,'',7,1,2,2567,'3341500771599','2022-09-19'),(61,'1622',1,'เด็กชาย','นนทวัฒน์','บุญมั่น','1340300202054',1,'',6,1,0,NULL,'3341500771599','2022-06-13'),(57,'1614',4,'เด็กหญิง','จิดาภา','จำรักษา','1341501517207',2,'',9,1,1,2564,'3341500771599','2020-11-02'),(56,'1595',3,'เด็กชาย','ดนัย','ธรรมวงค์','1341501448418',1,'',9,1,1,2564,'3341500771599','2020-11-02'),(55,'1598',4,'เด็กหญิง','ภัณฑิรา','รัตนภักดี','1349901675737',2,'',8,1,2,2564,'3341500771599','2020-11-02'),(54,'1590',3,'เด็กหญิง','พิมพ์ตะวัน','นวลนาค','1341501516979',2,'',8,1,2,2564,'3341500771599','2020-11-02'),(53,'1588',2,'เด็กชาย','ธนโชติ','กิราวัลย์','1103704523281',1,'',9,1,1,2564,'3341500771599','2020-11-02'),(58,'1615',2,'เด็กหญิง','ชณิตา','ไทยเจริญ','1349901748670',2,'',9,1,1,2565,'3341500771599','2022-01-20'),(52,'1578',1,'เด็กชาย','ศกลวัฒน์','เข็มนางรอง','1348900221502',1,'',9,1,1,2564,'3341500771599','2020-11-02'),(59,'1620',1,'เด็กชาย','เทพพิทักษ์','ผลนา','1341501618879',1,'',5,1,0,NULL,'3341500771599','2022-06-13'),(49,'1605',1,'เด็กหญิง','กระวิตรา','ไชยโกษ','1349901804596',2,'',7,1,2,2565,'3341500771599','2020-11-02'),(48,'1607',2,'เด็กชาย','วัชรพล','แก้วนนท์','1349901884719',1,'',9,1,1,2567,'3341500771599','2020-11-02'),(47,'1606',1,'เด็กชาย','ศรัณยู','บุญอุ่น','1349901913778',1,'',9,1,1,2567,'3341500771599','2020-11-02'),(46,'1618',1,'เด็กชาย','อภิวัฒน์','เชื้อบัณฑิต','1341501560404',1,'',8,1,2,2567,'3341500771599','2020-11-02'),(45,'1610',1,'เด็กชาย','วีรพล','แก้วนนท์','1349901984845',1,'',7,1,2,2567,'3341500771599','2020-11-02'),(44,'1619',1,'เด็กชาย','เพียงขวัญ','บุญอุ่น','1341501587434',1,'',7,1,0,NULL,'3341500771599','2020-11-02'),(43,'1616',2,'เด็กชาย','ณัฏฐกฤต','สดรัมย์','1248100140151',1,'',3,1,2,2563,'3341500771599','2020-11-02'),(42,'1617',1,'เด็กหญิง','ปุณณดา','วงษ์เพ็ญ','1341501597260',2,'',4,1,2,2565,'3341500771599','2020-11-02'),(50,'1604',1,'เด็กหญิง','สุภาพร','แก้วนนท์','1349901659570',2,'',9,1,1,2565,'3341500771599','2020-11-02'),(60,'1621',2,'เด็กหญิง','ทิพย์สุดา','หลวงแพ่ง','1349902125960',2,'',5,1,2,2567,'3341500771599','2022-06-13'),(65,'1626',2,'เด็กชาย','กฤษดา','โยโพธิ์','1860201186480',1,'',7,1,0,NULL,'3341500771599','2025-11-18');

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

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

INSERT INTO `student_main_classlog` VALUES (1,2561,'1593',0,2,1,'3341500771599','2018-11-14'),(2,2561,'1594',0,2,1,'3341500771599','2018-11-14'),(3,2561,'1587',0,3,1,'3341500771599','2018-11-14'),(4,2561,'1588',0,3,1,'3341500771599','2018-11-14'),(5,2561,'1590',0,3,1,'3341500771599','2018-11-14'),(6,2561,'1580',0,4,1,'3341500771599','2018-11-14'),(7,2561,'1583',0,4,1,'3341500771599','2018-11-14'),(8,2561,'1592',0,4,1,'3341500771599','2018-11-14'),(9,2561,'1595',0,4,1,'3341500771599','2018-11-14'),(10,2561,'1573',0,5,1,'3341500771599','2018-11-14'),(11,2561,'1574',0,5,1,'3341500771599','2018-11-14'),(12,2561,'1575',0,5,1,'3341500771599','2018-11-14'),(13,2561,'1563',0,6,1,'3341500771599','2018-11-14'),(14,2561,'1564',0,6,1,'3341500771599','2018-11-14'),(15,2561,'1565',0,6,1,'3341500771599','2018-11-14'),(16,2561,'1566',0,6,1,'3341500771599','2018-11-14'),(17,2561,'1567',0,6,1,'3341500771599','2018-11-14'),(18,2561,'1568',0,6,1,'3341500771599','2018-11-14'),(19,2561,'1569',0,6,1,'3341500771599','2018-11-14'),(20,2561,'1570',0,6,1,'3341500771599','2018-11-14'),(21,2561,'1571',0,6,1,'3341500771599','2018-11-14'),(22,2561,'1572',0,6,1,'3341500771599','2018-11-14'),(23,2561,'1554',0,7,1,'3341500771599','2018-11-14'),(24,2561,'1579',0,7,1,'3341500771599','2018-11-14'),(25,2561,'1496',0,8,1,'3341500771599','2018-11-14'),(26,2561,'1523',0,8,1,'3341500771599','2018-11-14'),(27,2561,'1524',0,8,1,'3341500771599','2018-11-14'),(28,2561,'1526',0,8,1,'3341500771599','2018-11-14'),(29,2561,'1527',0,8,1,'3341500771599','2018-11-14'),(30,2561,'1528',0,8,1,'3341500771599','2018-11-14'),(31,2561,'1530',0,8,1,'3341500771599','2018-11-14'),(32,2561,'1532',0,8,1,'3341500771599','2018-11-14'),(33,2561,'1551',0,8,1,'3341500771599','2018-11-14'),(34,2561,'1578',0,8,1,'3341500771599','2018-11-14'),(35,2561,'1441',0,9,1,'3341500771599','2018-11-14'),(36,2561,'1513',0,9,1,'3341500771599','2018-11-14'),(37,2561,'1517',0,9,1,'3341500771599','2018-11-14'),(38,2561,'1518',0,9,1,'3341500771599','2018-11-14'),(39,2561,'1522',0,9,1,'3341500771599','2018-11-14'),(40,2561,'1560',0,9,1,'3341500771599','2018-11-14'),(41,2562,'1593',0,2,1,'3341500771599','2019-07-11'),(42,2562,'1594',0,2,1,'3341500771599','2019-07-11'),(43,2562,'1580',0,4,1,'3341500771599','2019-07-11'),(44,2562,'1583',0,4,1,'3341500771599','2019-07-11'),(45,2562,'1592',0,4,1,'3341500771599','2019-07-11'),(46,2562,'1563',0,6,1,'3341500771599','2019-07-11'),(47,2562,'1596',0,6,1,'3341500771599','2019-07-11'),(48,2562,'1554',0,7,1,'3341500771599','2019-07-11'),(49,2562,'1579',0,7,1,'3341500771599','2019-07-11'),(50,2562,'1587',0,7,1,'3341500771599','2019-07-11'),(51,2562,'1588',0,7,1,'3341500771599','2019-07-11'),(52,2562,'1590',0,7,1,'3341500771599','2019-07-11'),(53,2562,'1595',0,7,1,'3341500771599','2019-07-11'),(54,2562,'1524',0,8,1,'3341500771599','2019-07-11'),(55,2562,'1526',0,8,1,'3341500771599','2019-07-11'),(56,2562,'1527',0,8,1,'3341500771599','2019-07-11'),(57,2562,'1528',0,8,1,'3341500771599','2019-07-11'),(58,2562,'1530',0,8,1,'3341500771599','2019-07-11'),(59,2562,'1532',0,8,1,'3341500771599','2019-07-11'),(60,2562,'1551',0,8,1,'3341500771599','2019-07-11'),(61,2562,'1578',0,8,1,'3341500771599','2019-07-11'),(62,2562,'1441',0,9,1,'3341500771599','2019-07-11'),(63,2562,'1496',0,9,1,'3341500771599','2019-07-11'),(64,2562,'1513',0,9,1,'3341500771599','2019-07-11'),(65,2562,'1517',0,9,1,'3341500771599','2019-07-11'),(66,2562,'1518',0,9,1,'3341500771599','2019-07-11'),(67,2562,'1522',0,9,1,'3341500771599','2019-07-11'),(68,2562,'1523',0,9,1,'3341500771599','2019-07-11'),(69,2562,'1560',0,9,1,'3341500771599','2019-07-11'),(70,2562,'1564',0,9,1,'3341500771599','2019-07-11'),(71,2562,'1565',0,9,1,'3341500771599','2019-07-11'),(72,2562,'1566',0,9,1,'3341500771599','2019-07-11'),(73,2562,'1567',0,9,1,'3341500771599','2019-07-11'),(74,2562,'1568',0,9,1,'3341500771599','2019-07-11'),(75,2562,'1569',0,9,1,'3341500771599','2019-07-11'),(76,2562,'1570',0,9,1,'3341500771599','2019-07-11'),(77,2562,'1571',0,9,1,'3341500771599','2019-07-11'),(78,2562,'1572',0,9,1,'3341500771599','2019-07-11'),(79,2562,'1573',0,9,1,'3341500771599','2019-07-11'),(80,2562,'1574',0,9,1,'3341500771599','2019-07-11'),(81,2562,'1575',0,9,1,'3341500771599','2019-07-11'),(82,2563,'1617',1,2,1,'3341500771599','2020-11-02'),(83,2563,'1616',2,3,1,'3341500771599','2020-11-03'),(84,2563,'1619',3,3,1,'3341500771599','2020-11-03'),(85,2563,'1610',1,3,1,'3341500771599','2020-11-02'),(86,2563,'1618',1,4,1,'3341500771599','2020-11-02'),(87,2563,'1606',1,5,1,'3341500771599','2020-11-02'),(88,2563,'1607',2,5,1,'3341500771599','2020-11-02'),(89,2563,'1605',1,6,1,'3341500771599','2020-11-02'),(90,2563,'1604',1,7,1,'3341500771599','2020-11-02'),(112,2564,'1615',2,8,1,'3341500771599','2022-01-20'),(92,2563,'1578',1,8,1,'3341500771599','2020-11-02'),(93,2563,'1588',2,8,1,'3341500771599','2020-11-02'),(94,2563,'1590',3,8,1,'3341500771599','2020-11-02'),(95,2563,'1598',4,8,1,'3341500771599','2020-11-02'),(96,2563,'1595',5,8,1,'3341500771599','2020-11-02'),(97,2563,'1614',6,8,1,'3341500771599','2020-11-02'),(98,2564,'1610',1,4,1,'3341500771599','2022-01-20'),(99,2564,'1618',1,5,1,'3341500771599','2022-01-20'),(100,2564,'1606',1,6,1,'3341500771599','2022-01-20'),(101,2564,'1607',2,6,1,'3341500771599','2022-01-20'),(102,2564,'1604',1,8,1,'3341500771599','2022-01-20'),(103,2564,'1605',1,7,1,'3341500771599','2022-01-20'),(104,2564,'1578',1,9,1,'3341500771599','2022-01-20'),(105,2564,'1588',2,9,1,'3341500771599','2022-01-20'),(106,2564,'1590',3,8,1,'3341500771599','2021-06-29'),(107,2564,'1598',4,8,1,'3341500771599','2021-06-29'),(108,2564,'1595',3,9,1,'3341500771599','2022-01-20'),(109,2564,'1614',4,9,1,'3341500771599','2022-01-20'),(110,2564,'1619',1,3,1,'3341500771599','2022-01-20'),(111,2564,'1617',1,2,1,'3341500771599','2022-01-20'),(113,2565,'1617',1,4,1,'3341500771599','2023-05-26'),(114,2565,'1619',1,5,1,'3341500771599','2023-05-26'),(115,2565,'1610',1,6,1,'3341500771599','2023-05-26'),(116,2565,'1618',1,7,1,'3341500771599','2023-05-26'),(117,2565,'1607',2,8,1,'3341500771599','2023-05-26'),(118,2565,'1606',1,8,1,'3341500771599','2023-05-26'),(119,2565,'1604',1,9,1,'3341500771599','2022-06-13'),(120,2565,'1615',2,9,1,'3341500771599','2022-06-13'),(121,2565,'1605',1,7,1,'3341500771599','2022-06-13'),(122,2565,'1620',1,3,1,'3341500771599','2023-05-26'),(123,2565,'1621',2,4,1,'3341500771599','2023-05-26'),(124,2565,'1622',3,4,1,'3341500771599','2023-05-26'),(125,2565,'1623',2,6,1,'3341500771599','2023-05-26'),(126,2565,'1624',3,6,1,'3341500771599','2023-05-26'),(127,2566,'1621',2,4,1,'3341500771599','2023-09-20'),(128,2566,'1625',3,8,1,'3341500771599','2023-09-22'),(129,2567,'1620',1,4,1,'3341500771599','2024-05-17'),(130,2567,'1621',2,5,1,'3341500771599','2024-05-17'),(131,2567,'1619',1,6,1,'3341500771599','2024-05-17'),(132,2567,'1610',1,7,1,'3341500771599','2024-05-17'),(133,2567,'1623',2,7,1,'3341500771599','2024-05-17'),(134,2567,'1624',1,7,1,'3341500771599','2024-09-19'),(135,2567,'1618',1,8,1,'3341500771599','2024-05-17'),(136,2567,'1607',2,9,1,'3341500771599','2024-05-17'),(137,2567,'1625',3,9,1,'3341500771599','2024-05-17'),(138,2567,'1606',1,9,1,'3341500771599','2024-05-17'),(139,2567,'1622',1,5,1,'3341500771599','2024-09-19'),(140,2568,'1622',1,6,1,'3341500771599','2025-10-22'),(141,2568,'1619',1,7,1,'3341500771599','2025-10-22'),(142,2568,'1620',1,5,1,'3341500771599','2025-10-22'),(143,2568,'1626',2,7,1,'3341500771599','2025-11-18'),(144,2568,'1624',1,8,1,'3341500771599','2025-11-18');

--
-- 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=10 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),(5,2564,0),(6,2565,0),(7,2566,0),(8,2567,0),(9,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=14 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `student_main_expand1` VALUES (1,'1341501587434','Peangkhan','Boonaun','2015-11-05','','','','','2025-11-18'),(2,'1341501597260','Poonnada','Wongpen','2016-07-18','','','','','2022-01-20'),(3,'1349901984845','Weerapon','Kaewnon','2014-06-13','','','','','2022-01-20'),(4,'1341501560404','Apiwat','Chueabandit','2013-10-27','','','','','2022-01-20'),(5,'1349901913778','Saranyoo','Boon-aun','2013-05-15','','','','','2022-01-20'),(6,'1349901884719','Watcharapon','Kaewnon','2012-12-12','','','','','2022-01-20'),(7,'1349901804596','Kawitra','Chaiyakod','2011-11-20','','','','','2022-01-20'),(8,'1349901659570','Supaporn','Kaewnon','2009-10-27','','','','','2022-01-20'),(9,'1348900221502','Sakonwut','Khemnanangrong','2009-07-27','','','','','2022-01-20'),(10,'1103704523281','Tanachot','Girawan','2010-03-19','','','','','2022-01-20'),(11,'1341501448418','Danai','Tammawong','2004-06-29','','','','','2022-01-20'),(12,'1341501517207','CHIDAPHA','CHAMRAKSA','2010-02-01','','','','','2022-01-20'),(13,'1819900998511','','','2014-11-17','','','','','2024-01-15');

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

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

INSERT INTO `student_main_permission` VALUES (1,'3341500771599',1,'3341500771599','2018-11-14');

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

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

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

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

INSERT INTO `system_module_admin` VALUES (9,'1311190001611','health','7777','2015-10-27'),(2,'1311190001611','student_check','7777','2015-10-27'),(3,'1311190001611','savings','7777','2015-10-27'),(14,'1311190001611','person','7777','2015-10-27'),(12,'1311190001611','mail','7777','2015-10-27'),(11,'1311190001611','la','7777','2015-10-27'),(13,'1311190001611','permission','7777','2015-10-27'),(15,'1311190001611','plan','7777','2015-10-27'),(17,'1311190001611','standard','7777','2015-10-27'),(21,'1311190001611','bookregister','7777','2015-10-27'),(22,'3330500134466','plan','1311190001611','2016-07-23'),(23,'3349800155637','budget','1311190001611','2016-07-23'),(24,'3330500134466','budget','3330500134466','2016-07-23'),(25,'3341500771599','book','7777','2018-11-14'),(26,'3341500771599','bookregister','7777','2018-11-14'),(27,'3341500771599','student_main','7777','2018-11-14'),(28,'3341500771599','person','7777','2018-11-14'),(29,'3341500771599','work','7777','2018-11-14'),(30,'3341500771599','student_check','7777','2018-11-14'),(31,'3341500771599','permission','7777','2018-11-14'),(32,'3341500771599','mail','7777','2018-11-14'),(33,'3341500771599','health','7777','2018-11-14'),(34,'3341500771599','bets','7777','2018-11-14'),(35,'3341500771599','amss_opportunity','7777','2018-11-14'),(36,'3341500771599','amss_bets','7777','2018-11-14'),(37,'3341500771599','la','7777','2018-11-14'),(38,'3341500771599','meeting','7777','2018-11-14'),(39,'3341500771599','plan','7777','2018-11-14'),(40,'3341500771599','achievement','7777','2018-11-14'),(41,'3341500771599','budget','7777','2018-11-14'),(42,'3341500771599','affair','7777','2018-11-14'),(43,'3341500771599','amss_mail','7777','2018-11-14'),(44,'3341500771599','amss_supervision','7777','2018-11-14'),(45,'3341500771599','cabinet','7777','2018-11-14'),(46,'3341500771599','delegate','7777','2018-11-14'),(47,'3341500771599','savings','7777','2018-11-14'),(48,'3349800155637','plan','3340701263671','2020-11-14'),(50,'1499900222991','permission','3341500771599','2022-07-23'),(51,'1499900222991','la','3341500771599','2022-07-23'),(52,'1499900222991','amss_supervision','3341500771599','2022-07-23'),(54,'1499900222991','delegate','3341500771599','2022-07-23'),(55,'1499900222991','budget','3341500771599','2022-07-23'),(56,'3349900613700','delegate','3341500771599','2025-11-14'),(57,'1103703414780','student_check','3341500771599','2025-11-14');

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

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

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

INSERT INTO `system_school_name` VALUES (1,'โรงเรียนบ้านกุดปลาขาว',0);

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

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

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

INSERT INTO `system_sync_code` VALUES (3,'34040042','amssplus','34040042','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=122 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `work_main` VALUES (1,'2015-10-27','3340701263671',1,NULL,'2015-10-27 14:04:34','1311190001611'),(2,'2015-10-27','3349800192851',1,NULL,'2015-10-27 14:04:34','1311190001611'),(3,'2015-10-27','3349800168551',1,NULL,'2015-10-27 14:04:34','1311190001611'),(4,'2015-10-27','3349800155637',1,NULL,'2015-10-27 14:04:34','1311190001611'),(5,'2015-10-27','3349900515279',1,NULL,'2015-10-27 14:04:34','1311190001611'),(6,'2015-10-27','3330500134466',1,NULL,'2015-10-27 14:04:34','1311190001611'),(7,'2015-10-27','1311190001611',1,NULL,'2015-10-27 14:04:34','1311190001611'),(8,'2015-10-27','3341100640144',1,NULL,'2015-10-27 14:04:34','1311190001611'),(9,'2015-10-26','3340701263671',2,NULL,'2015-10-27 14:05:25','1311190001611'),(10,'2015-10-26','3349800192851',1,NULL,'2015-10-27 14:05:25','1311190001611'),(11,'2015-10-26','3349800168551',1,NULL,'2015-10-27 14:05:25','1311190001611'),(12,'2015-10-26','3349800155637',1,NULL,'2015-10-27 14:05:25','1311190001611'),(13,'2015-10-26','3349900515279',1,NULL,'2015-10-27 14:05:25','1311190001611'),(14,'2015-10-26','3330500134466',1,NULL,'2015-10-27 14:05:25','1311190001611'),(15,'2015-10-26','1311190001611',2,NULL,'2015-10-27 14:05:25','1311190001611'),(16,'2015-10-26','3341100640144',2,NULL,'2015-10-27 14:05:25','1311190001611'),(17,'2018-11-26','3340701263671',1,NULL,'2018-11-26 14:35:13','3341500771599'),(18,'2018-11-26','3349800155637',1,NULL,'2018-11-26 14:35:13','3341500771599'),(19,'2018-11-26','3330500134466',1,NULL,'2018-11-26 14:35:13','3341500771599'),(20,'2018-11-26','3341100640144',1,NULL,'2018-11-26 14:35:13','3341500771599'),(21,'2018-11-26','3341500771599',1,NULL,'2018-11-26 14:35:13','3341500771599'),(22,'2018-11-01','3340701263671',1,NULL,'2018-11-26 14:27:24','3341500771599'),(23,'2018-11-01','3349800155637',1,NULL,'2018-11-26 14:27:24','3341500771599'),(24,'2018-11-01','3330500134466',1,NULL,'2018-11-26 14:27:24','3341500771599'),(25,'2018-11-01','3341100640144',1,NULL,'2018-11-26 14:27:24','3341500771599'),(26,'2018-11-01','3341500771599',1,NULL,'2018-11-26 14:27:24','3341500771599'),(27,'2018-11-02','3340701263671',1,NULL,'2018-11-26 14:27:59','3341500771599'),(28,'2018-11-02','3349800155637',1,NULL,'2018-11-26 14:27:59','3341500771599'),(29,'2018-11-02','3330500134466',1,NULL,'2018-11-26 14:27:59','3341500771599'),(30,'2018-11-02','3341100640144',1,NULL,'2018-11-26 14:27:59','3341500771599'),(31,'2018-11-02','3341500771599',1,NULL,'2018-11-26 14:27:59','3341500771599'),(32,'2018-11-05','3340701263671',1,NULL,'2018-11-26 14:28:51','3341500771599'),(33,'2018-11-05','3349800155637',4,NULL,'2018-11-26 14:28:51','3341500771599'),(34,'2018-11-05','3330500134466',1,NULL,'2018-11-26 14:28:51','3341500771599'),(35,'2018-11-05','3341100640144',1,NULL,'2018-11-26 14:28:51','3341500771599'),(36,'2018-11-05','3341500771599',1,NULL,'2018-11-26 14:28:51','3341500771599'),(37,'2018-11-06','3340701263671',1,NULL,'2018-11-26 14:29:11','3341500771599'),(38,'2018-11-06','3349800155637',1,NULL,'2018-11-26 14:29:11','3341500771599'),(39,'2018-11-06','3330500134466',1,NULL,'2018-11-26 14:29:11','3341500771599'),(40,'2018-11-06','3341100640144',1,NULL,'2018-11-26 14:29:11','3341500771599'),(41,'2018-11-06','3341500771599',1,NULL,'2018-11-26 14:29:11','3341500771599'),(42,'2018-11-07','3340701263671',1,NULL,'2018-11-26 14:29:30','3341500771599'),(43,'2018-11-07','3349800155637',1,NULL,'2018-11-26 14:29:30','3341500771599'),(44,'2018-11-07','3330500134466',1,NULL,'2018-11-26 14:29:30','3341500771599'),(45,'2018-11-07','3341100640144',1,NULL,'2018-11-26 14:29:30','3341500771599'),(46,'2018-11-07','3341500771599',1,NULL,'2018-11-26 14:29:30','3341500771599'),(47,'2018-11-08','3340701263671',1,NULL,'2018-11-26 14:29:49','3341500771599'),(48,'2018-11-08','3349800155637',1,NULL,'2018-11-26 14:29:49','3341500771599'),(49,'2018-11-08','3330500134466',1,NULL,'2018-11-26 14:29:49','3341500771599'),(50,'2018-11-08','3341100640144',1,NULL,'2018-11-26 14:29:49','3341500771599'),(51,'2018-11-08','3341500771599',1,NULL,'2018-11-26 14:29:49','3341500771599'),(52,'2018-11-09','3340701263671',1,NULL,'2018-11-26 14:30:07','3341500771599'),(53,'2018-11-09','3349800155637',1,NULL,'2018-11-26 14:30:07','3341500771599'),(54,'2018-11-09','3330500134466',1,NULL,'2018-11-26 14:30:07','3341500771599'),(55,'2018-11-09','3341100640144',1,NULL,'2018-11-26 14:30:07','3341500771599'),(56,'2018-11-09','3341500771599',1,NULL,'2018-11-26 14:30:07','3341500771599'),(57,'2018-11-12','3340701263671',1,NULL,'2018-11-26 14:30:29','3341500771599'),(58,'2018-11-12','3349800155637',1,NULL,'2018-11-26 14:30:29','3341500771599'),(59,'2018-11-12','3330500134466',1,NULL,'2018-11-26 14:30:29','3341500771599'),(60,'2018-11-12','3341100640144',1,NULL,'2018-11-26 14:30:29','3341500771599'),(61,'2018-11-12','3341500771599',1,NULL,'2018-11-26 14:30:29','3341500771599'),(62,'2018-11-13','3340701263671',1,NULL,'2018-11-26 14:31:55','3341500771599'),(63,'2018-11-13','3349800155637',1,NULL,'2018-11-26 14:31:55','3341500771599'),(64,'2018-11-13','3330500134466',1,NULL,'2018-11-26 14:31:55','3341500771599'),(65,'2018-11-13','3341100640144',1,NULL,'2018-11-26 14:31:55','3341500771599'),(66,'2018-11-13','3341500771599',2,NULL,'2018-11-26 14:31:55','3341500771599'),(67,'2018-11-14','3340701263671',1,NULL,'2018-11-26 14:32:31','3341500771599'),(68,'2018-11-14','3349800155637',1,NULL,'2018-11-26 14:32:31','3341500771599'),(69,'2018-11-14','3330500134466',1,NULL,'2018-11-26 14:32:31','3341500771599'),(70,'2018-11-14','3341100640144',1,NULL,'2018-11-26 14:32:31','3341500771599'),(71,'2018-11-14','3341500771599',2,NULL,'2018-11-26 14:32:31','3341500771599'),(72,'2018-11-15','3340701263671',1,NULL,'2018-11-26 14:32:49','3341500771599'),(73,'2018-11-15','3349800155637',1,NULL,'2018-11-26 14:32:49','3341500771599'),(74,'2018-11-15','3330500134466',1,NULL,'2018-11-26 14:32:49','3341500771599'),(75,'2018-11-15','3341100640144',1,NULL,'2018-11-26 14:32:49','3341500771599'),(76,'2018-11-15','3341500771599',1,NULL,'2018-11-26 14:32:49','3341500771599'),(77,'2018-11-16','3340701263671',1,NULL,'2018-11-26 14:33:15','3341500771599'),(78,'2018-11-16','3349800155637',1,NULL,'2018-11-26 14:33:15','3341500771599'),(79,'2018-11-16','3330500134466',1,NULL,'2018-11-26 14:33:15','3341500771599'),(80,'2018-11-16','3341100640144',1,NULL,'2018-11-26 14:33:15','3341500771599'),(81,'2018-11-16','3341500771599',1,NULL,'2018-11-26 14:33:15','3341500771599'),(82,'2018-11-19','3340701263671',1,NULL,'2018-11-26 14:33:44','3341500771599'),(83,'2018-11-19','3349800155637',1,NULL,'2018-11-26 14:33:44','3341500771599'),(84,'2018-11-19','3330500134466',1,NULL,'2018-11-26 14:33:44','3341500771599'),(85,'2018-11-19','3341100640144',1,NULL,'2018-11-26 14:33:44','3341500771599'),(86,'2018-11-19','3341500771599',1,NULL,'2018-11-26 14:33:44','3341500771599'),(87,'2018-11-20','3340701263671',1,NULL,'2018-11-26 14:33:59','3341500771599'),(88,'2018-11-20','3349800155637',1,NULL,'2018-11-26 14:33:59','3341500771599'),(89,'2018-11-20','3330500134466',1,NULL,'2018-11-26 14:33:59','3341500771599'),(90,'2018-11-20','3341100640144',1,NULL,'2018-11-26 14:33:59','3341500771599'),(91,'2018-11-20','3341500771599',1,NULL,'2018-11-26 14:33:59','3341500771599'),(92,'2018-11-21','3340701263671',1,NULL,'2018-11-26 14:34:15','3341500771599'),(93,'2018-11-21','3349800155637',1,NULL,'2018-11-26 14:34:15','3341500771599'),(94,'2018-11-21','3330500134466',1,NULL,'2018-11-26 14:34:15','3341500771599'),(95,'2018-11-21','3341100640144',1,NULL,'2018-11-26 14:34:15','3341500771599'),(96,'2018-11-21','3341500771599',1,NULL,'2018-11-26 14:34:15','3341500771599'),(97,'2018-11-22','3340701263671',1,NULL,'2018-11-26 14:34:35','3341500771599'),(98,'2018-11-22','3349800155637',1,NULL,'2018-11-26 14:34:35','3341500771599'),(99,'2018-11-22','3330500134466',1,NULL,'2018-11-26 14:34:35','3341500771599'),(100,'2018-11-22','3341100640144',1,NULL,'2018-11-26 14:34:35','3341500771599'),(101,'2018-11-22','3341500771599',1,NULL,'2018-11-26 14:34:35','3341500771599'),(102,'2018-11-23','3340701263671',1,NULL,'2018-11-26 14:34:55','3341500771599'),(103,'2018-11-23','3349800155637',1,NULL,'2018-11-26 14:34:55','3341500771599'),(104,'2018-11-23','3330500134466',1,NULL,'2018-11-26 14:34:55','3341500771599'),(105,'2018-11-23','3341100640144',1,NULL,'2018-11-26 14:34:55','3341500771599'),(106,'2018-11-23','3341500771599',1,NULL,'2018-11-26 14:34:55','3341500771599'),(107,'2018-11-27','3340701263671',1,NULL,'2018-11-27 18:22:21','3341500771599'),(108,'2018-11-27','3349800155637',1,NULL,'2018-11-27 18:22:21','3341500771599'),(109,'2018-11-27','3330500134466',1,NULL,'2018-11-27 18:22:21','3341500771599'),(110,'2018-11-27','3341100640144',1,NULL,'2018-11-27 18:22:21','3341500771599'),(111,'2018-11-27','3341500771599',1,NULL,'2018-11-27 18:22:21','3341500771599'),(112,'2018-11-28','3340701263671',1,NULL,'2018-11-28 15:17:25','3341500771599'),(113,'2018-11-28','3349800155637',1,NULL,'2018-11-28 15:17:25','3341500771599'),(114,'2018-11-28','3330500134466',1,NULL,'2018-11-28 15:17:25','3341500771599'),(115,'2018-11-28','3341100640144',1,NULL,'2018-11-28 15:17:25','3341500771599'),(116,'2018-11-28','3341500771599',1,NULL,'2018-11-28 15:17:25','3341500771599'),(117,'2018-11-29','3340701263671',1,NULL,'2018-11-29 08:42:47','3341500771599'),(118,'2018-11-29','3349800155637',1,NULL,'2018-11-29 08:42:47','3341500771599'),(119,'2018-11-29','3330500134466',1,NULL,'2018-11-29 08:42:47','3341500771599'),(120,'2018-11-29','3341100640144',1,NULL,'2018-11-29 08:42:47','3341500771599'),(121,'2018-11-29','3341500771599',2,NULL,'2018-11-29 08:42:47','3341500771599');

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

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

INSERT INTO `work_permission` VALUES (1,'1311190001611',1,'1311190001611','2015-10-27'),(2,'3341500771599',1,'3341500771599','2018-11-14');


