
--
-- 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,'3341901425675',2558),(3,1,'3341901425675',2558),(4,1,'3341901425675',2558),(5,1,'3341901425675',2558),(6,1,'3341901425675',2558),(7,1,'3341901425675',2558),(8,1,'3341901425675',2558),(9,1,'3341901425675',2558),(2,1,'3341500574416',2558),(4,1,'3341500574416',2558),(4,1,'1471200116784',2558),(3,1,'1471200116784',2558),(3,1,'3341500574416',2558),(5,1,'1471200116784',2558),(6,1,'3349900749512',2558),(6,1,'1471200116784',2558),(7,1,'3349900749512',2558),(7,1,'1471200116784',2558),(8,1,'3341500574416',2558),(8,1,'1471200116784',2558),(9,1,'3341500574416',2558),(9,1,'1471200116784',2558),(2,1,'1471200116784',2558),(5,1,'3349900749512',2558),(3,1,'3341500574416',2559),(4,1,'3341500574416',2559),(5,1,'3349900749512',2559),(6,1,'3349900749512',2559),(7,1,'3349900749512',2559),(8,1,'3341500574416',2559),(9,1,'3341500574416',2559),(5,1,'5341100001679',2562),(6,1,'5341100001679',2561),(7,1,'5341100001679',2561),(8,1,'5341100001679',2561),(5,0,'3349900749512',2562),(6,1,'5341100001679',2562),(7,1,'5341100001679',2562),(8,1,'5341100001679',2562),(5,0,'3340400689792',2562),(6,1,'3340400689792',2562),(7,1,'3340400689792',2562),(8,1,'3340400689792',2562),(9,1,'5341100001679',2562),(9,1,'3340400689792',2562),(5,1,'3340400689792',2562),(4,1,'3340400689792',2563),(4,1,'3349900749512',2563),(4,1,'3341500574416',2563),(4,1,'5341100001679',2563),(5,1,'3340400689792',2563),(5,1,'3349900749512',2563),(5,1,'3341500574416',2563),(5,1,'5341100001679',2563),(6,1,'3340400689792',2563),(6,1,'3349900749512',2563),(6,1,'3341500574416',2563),(6,1,'5341100001679',2563),(7,1,'3340400689792',2563),(7,1,'3349900749512',2563),(7,1,'3341500574416',2563),(7,1,'5341100001679',2563),(8,1,'3340400689792',2563),(8,1,'3349900749512',2563),(8,1,'3341500574416',2563),(8,1,'5341100001679',2563),(9,1,'3340400689792',2563),(9,1,'3349900749512',2563),(9,1,'3341500574416',2563),(9,1,'5341100001679',2563),(2,1,'3340400689792',2563),(2,1,'3349900749512',2563),(2,1,'3341500574416',2563),(2,1,'5341100001679',2563),(3,1,'3340400689792',2564),(3,1,'3309900179716',2564),(3,1,'5341100001679',2564),(4,0,'3340400689792',2564),(4,0,'3309900179716',2564),(4,0,'5341100001679',2564),(4,1,'3340400689792',2564),(4,1,'3309900179716',2564),(4,1,'5341100001679',2564),(5,1,'3340400689792',2564),(5,1,'3309900179716',2564),(5,1,'5341100001679',2564),(6,1,'3340400689792',2564),(6,1,'3309900179716',2564),(6,1,'5341100001679',2564),(7,0,'3340400689792',2564),(7,0,'3309900179716',2564),(7,0,'5341100001679',2564),(7,1,'3340400689792',2564),(7,1,'3309900179716',2564),(7,1,'5341100001679',2564),(8,0,'3340400689792',2564),(8,0,'3309900179716',2564),(8,0,'5341100001679',2564),(8,1,'3340400689792',2564),(8,1,'3309900179716',2564),(8,1,'5341100001679',2564),(9,1,'3340400689792',2564),(9,1,'3309900179716',2564),(9,1,'5341100001679',2564),(4,1,'3340400689792',2566),(4,1,'3309900179716',2566),(4,1,'5341100001679',2566),(5,1,'3340400689792',2566),(5,1,'3309900179716',2566),(5,1,'5341100001679',2566),(6,1,'3340400689792',2566),(6,1,'3309900179716',2566),(6,1,'5341100001679',2566),(7,1,'3340400689792',2566),(7,1,'3309900179716',2566),(7,1,'5341100001679',2566),(8,1,'3340400689792',2566),(8,1,'3309900179716',2566),(8,1,'5341100001679',2566),(9,1,'3340400689792',2566),(9,1,'3309900179716',2566),(9,1,'5341100001679',2566),(4,1,'5341100001679',2567),(5,1,'5341100001679',2567),(7,1,'5341100001679',2567),(8,1,'5341100001679',2567),(9,1,'5341100001679',2567);

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

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

INSERT INTO `student_check_year` VALUES (2,2558,0),(3,2559,0),(5,2561,0),(6,2562,0),(7,2563,0),(9,2564,0),(10,2566,0),(11,2567,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=47 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `student_main` VALUES (1,'833',1,'เด็กหญิง','ธันย์ชยา','สวัสดี','1347600045694',2,'modules/student_main/picture/pic_833.PNG',9,1,1,2565,'5341100001679','0000-00-00'),(2,'834',1,'เด็กหญิง','มุกจิตตา','พันโท','1341501510156',2,NULL,9,1,1,2564,'5341100001679','0000-00-00'),(46,'859',1,'เด็กหญิง','ปิ่นดาว','ไทยงูเหลือม','1349902226715',2,'',5,1,0,NULL,'5341100001679','2024-09-19'),(28,'846',2,'เด็กหญิง','อรอุมา','จิตนานนท์','1349901929470',2,'',9,1,0,NULL,'5341100001679','2020-07-10'),(29,'845',1,'เด็กชาย','ธนากร','วงษา','1341501548455',1,'',9,1,1,2567,'5341100001679','2020-07-10'),(30,'842',4,'เด็กชาย','ธนภัทร','นาปัดสี','1129902241414',1,'',9,1,1,2565,'5341100001679','2020-07-10'),(44,'856',3,'เด็กชาย','กิตติศักดิ์','นักคำพันธ์','1349901770764',1,'',8,1,2,2566,'5341100001679','2022-09-12'),(34,'841',2,'เด็กชาย','ธนากร','สุณูพัฒ','1341501570230',1,'',9,1,0,NULL,'5341100001679','2020-07-11'),(43,'857',3,'เด็กชาย','ภูวเดช','สํญญเดช','1347600078932',1,'',9,1,1,2567,'5341100001679','2022-09-12'),(39,'848',4,'เด็กหญิง','พรสุดา ','ไขแสง','1100801683413',2,'',9,1,1,2565,'5341100001679','2021-06-09'),(24,'837',2,'เด็กชาย','ยศพร','สุญพัฒ','1349901756061',1,'',9,1,1,2565,'5341100001679','2019-06-20'),(36,'851',1,'เด็กหญิง','พรลดา','ไขแสง','1100704578074',2,'',8,1,0,NULL,'5341100001679','2021-06-09'),(27,'843',1,'เด็กชาย','สุรชัย','พุฒทอง','1341501555834',2,'',9,1,0,NULL,'5341100001679','2020-07-10'),(40,'853',3,'เด็กชาย','ธนพล','นาปัดสี','1347600096973',1,'',8,1,0,NULL,'5341100001679','2021-06-22'),(41,'854',2,'เด็กหญิง','ธิดาวรรณ','พาลัง','1341501594325',2,'',4,1,2,2566,'5341100001679','2022-09-12'),(45,'858',1,'เด็กหญิง','วราภรณ์','ภูคำสันต์','1103705224686',2,'',6,1,0,NULL,'5341100001679','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=11 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

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

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

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

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

INSERT INTO `student_main_classlog` VALUES (1,2560,'833',0,4,1,'5341100001679','2018-11-14'),(2,2560,'834',0,4,1,'5341100001679','2018-11-14'),(3,2560,'831',0,5,1,'5341100001679','2018-11-14'),(4,2560,'824',0,6,1,'5341100001679','2018-11-14'),(5,2560,'829',0,6,1,'5341100001679','2018-11-14'),(6,2560,'830',0,6,1,'5341100001679','2018-11-14'),(7,2560,'818',0,7,1,'5341100001679','2018-11-14'),(8,2560,'820',0,7,1,'5341100001679','2018-11-14'),(9,2560,'821',0,7,1,'5341100001679','2018-11-14'),(10,2560,'825',0,7,1,'5341100001679','2018-11-14'),(11,2560,'826',0,7,1,'5341100001679','2018-11-14'),(12,2561,'833',0,5,1,'5341100001679','2018-11-24'),(13,2561,'834',0,5,1,'5341100001679','2018-11-24'),(14,2561,'831',0,6,1,'5341100001679','2018-11-24'),(15,2561,'824',0,7,1,'5341100001679','2018-11-24'),(16,2561,'829',0,7,1,'5341100001679','2018-11-24'),(17,2561,'830',0,7,1,'5341100001679','2018-11-24'),(18,2561,'835',0,7,1,'5341100001679','2018-11-24'),(19,2561,'806',0,8,1,'5341100001679','2018-11-24'),(20,2561,'818',0,8,1,'5341100001679','2018-11-24'),(21,2561,'819',0,8,1,'5341100001679','2018-11-24'),(22,2561,'820',0,8,1,'5341100001679','2018-11-24'),(23,2561,'821',0,8,1,'5341100001679','2018-11-24'),(24,2561,'825',0,8,1,'5341100001679','2018-11-24'),(25,2561,'826',0,8,1,'5341100001679','2018-11-24'),(26,2561,'827',0,8,1,'5341100001679','2018-11-24'),(27,2561,'807',0,9,1,'5341100001679','2018-11-24'),(28,2561,'811',0,9,1,'5341100001679','2018-11-24'),(29,2561,'812',0,9,1,'5341100001679','2018-11-24'),(30,2561,'814',0,9,1,'5341100001679','2018-11-24'),(31,2562,'836',1,5,1,'5341100001679','2019-07-15'),(32,2562,'833',1,6,1,'5341100001679','2019-07-15'),(33,2562,'834',1,7,1,'5341100001679','2019-07-15'),(34,2562,'831',1,8,1,'5341100001679','2019-07-15'),(35,2562,'824',1,9,1,'5341100001679','2019-07-15'),(43,2563,'846',2,4,1,'5341100001679','2020-07-10'),(38,2561,'836',1,4,0,'5341100001679','2019-06-11'),(39,2562,'837',2,6,1,'5341100001679','2019-07-15'),(42,2563,'843',1,4,1,'5341100001679','2020-07-10'),(41,2562,'839',3,6,1,'5341100001679','2020-02-07'),(44,2563,'845',1,5,1,'5341100001679','2020-07-10'),(45,2563,'836',1,6,1,'5341100001679','2020-07-11'),(46,2563,'837',2,7,1,'5341100001679','2020-07-10'),(47,2563,'839',3,7,1,'5341100001679','2020-07-10'),(48,2563,'831',1,9,1,'5341100001679','2020-07-10'),(49,2563,'834',1,8,1,'5341100001679','2020-07-10'),(50,2563,'842',4,7,1,'5341100001679','2020-07-10'),(51,2563,'847',2,5,1,'5341100001679','2020-07-15'),(52,2563,'833',1,7,1,'5341100001679','2020-07-10'),(53,2563,'844',1,2,1,'5341100001679','2020-07-11'),(54,2563,'840',1,4,1,'5341100001679','2020-07-31'),(55,2563,'841',2,4,1,'5341100001679','2020-07-31'),(56,2564,'844',1,3,1,'5341100001679','2021-06-09'),(57,2564,'840',1,5,1,'5341100001679','2021-11-10'),(58,2564,'843',1,5,1,'5341100001679','2021-11-10'),(59,2564,'841',2,5,1,'5341100001679','2021-11-10'),(60,2564,'846',2,5,1,'5341100001679','2021-11-10'),(61,2564,'847',2,6,1,'5341100001679','2021-11-10'),(62,2564,'845',1,6,1,'5341100001679','2021-11-10'),(63,2564,'836',1,7,1,'5341100001679','2021-11-10'),(64,2564,'833',1,8,1,'5341100001679','2021-11-10'),(65,2564,'837',2,8,1,'5341100001679','2021-11-10'),(66,2564,'834',1,9,1,'5341100001679','2021-11-10'),(67,2564,'842',4,8,1,'5341100001679','2021-11-10'),(68,2564,'852',2,4,1,'5341100001679','2021-11-10'),(69,2564,'851',1,4,1,'5341100001679','2021-11-10'),(70,2564,'849',2,7,1,'5341100001679','2021-11-10'),(71,2564,'850',3,7,1,'5341100001679','2021-11-10'),(72,2564,'848',4,8,1,'5341100001679','2021-11-10'),(73,2564,'853',3,4,1,'5341100001679','2021-11-10'),(74,2565,'854',2,4,1,'5341100001679','2022-09-12'),(75,2565,'855',3,4,1,'5341100001679','2022-09-12'),(76,2565,'857',3,7,1,'5341100001679','2022-09-12'),(77,2565,'0',3,8,1,'5341100001679','2022-09-12'),(78,2565,'856',3,8,1,'5341100001679','2022-09-12'),(79,2565,'833',1,9,1,'5341100001679','2023-09-12'),(80,2565,'837',2,9,1,'5341100001679','2023-09-12'),(81,2565,'842',4,9,1,'5341100001679','2023-09-12'),(82,2565,'848',4,9,1,'5341100001679','2023-09-12'),(83,2566,'854',2,4,1,'5341100001679','2023-09-12'),(84,2566,'856',3,8,1,'5341100001679','2023-09-12'),(85,2565,'844',1,4,1,'5341100001679','2023-09-12'),(86,2565,'851',1,5,1,'5341100001679','2023-09-12'),(87,2565,'852',2,5,1,'5341100001679','2023-09-12'),(88,2565,'853',3,5,1,'5341100001679','2023-09-12'),(89,2565,'843',1,6,1,'5341100001679','2023-09-12'),(90,2565,'841',2,6,1,'5341100001679','2023-09-12'),(91,2565,'846',2,6,1,'5341100001679','2023-09-12'),(92,2565,'845',1,7,1,'5341100001679','2023-09-12'),(93,2565,'847',2,7,1,'5341100001679','2023-09-12'),(94,2565,'836',1,8,1,'5341100001679','2023-09-12'),(95,2565,'849',2,8,1,'5341100001679','2023-09-12'),(96,2566,'858',1,4,1,'5341100001679','2023-09-12'),(97,2567,'858',1,4,1,'5341100001679','2024-09-19'),(111,2566,'844',1,5,1,'5341100001679','2024-09-19'),(100,2567,'851',1,7,1,'5341100001679','2024-09-19'),(127,2568,'858',1,6,1,'3340400689792','2025-10-20'),(102,2567,'853',3,6,1,'5341100001679','2024-09-19'),(103,2567,'843',1,7,1,'5341100001679','2024-09-19'),(104,2567,'841',2,7,1,'5341100001679','2024-09-19'),(105,2567,'846',2,7,1,'5341100001679','2024-09-19'),(106,2567,'845',1,8,1,'5341100001679','2024-09-19'),(126,2568,'859',1,5,1,'3340400689792','2025-10-20'),(108,2567,'857',3,8,1,'5341100001679','2024-09-19'),(112,2566,'855',3,5,1,'5341100001679','2024-09-19'),(113,2566,'851',1,6,1,'5341100001679','2024-09-19'),(114,2566,'852',2,6,1,'5341100001679','2024-09-19'),(115,2566,'853',3,6,1,'5341100001679','2024-09-19'),(116,2566,'843',1,7,1,'5341100001679','2024-09-19'),(117,2566,'841',2,7,1,'5341100001679','2024-09-19'),(118,2566,'846',2,7,1,'5341100001679','2024-09-19'),(119,2566,'845',1,8,1,'5341100001679','2024-09-19'),(120,2566,'847',2,8,1,'5341100001679','2024-09-19'),(121,2566,'857',3,8,1,'5341100001679','2024-09-19'),(122,2566,'836',1,9,1,'5341100001679','2024-09-19'),(123,2566,'849',2,9,1,'5341100001679','2024-09-19'),(124,2567,'1349902',1,4,0,'5341100001679','2024-09-19'),(125,2567,'859',1,4,1,'5341100001679','2024-11-26'),(128,2568,'851',1,8,1,'3340400689792','2025-10-20'),(129,2568,'853',3,8,1,'3340400689792','2025-10-20'),(130,2568,'843',1,9,1,'3340400689792','2025-10-20'),(131,2568,'841',2,9,1,'3340400689792','2025-10-20'),(132,2568,'846',2,9,1,'3340400689792','2025-10-20');

--
-- 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,2559,0),(4,2561,0),(5,2562,0),(6,2563,0),(7,2564,0),(8,2565,0),(9,2566,0),(10,2567,0),(11,2568,1);

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

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

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

INSERT INTO `student_main_expand1` VALUES (1,'1341501541469','kachakorn','Walaijai','2012-02-01','-','ไทย','ไทย','พุทธ','2020-07-11'),(2,'1349901756061','yutsapron','suyaput','2011-03-23','-','ไทย','ไทย','พุทธ','2020-07-11'),(3,'1347600045694','Thanchaya','Sawatdi','2010-07-14','-','ไทย','ไทย','พุทธ','2020-07-11'),(4,'1341501510156','mukchitta','phantho','2009-04-28','-','ไทย','ไทย','พุทธ','2020-07-11'),(5,'1347600030140','Natthachaya','Sawatdi','2008-12-11','-','ไทย','ไทย','พุทธ','2020-07-11'),(6,'1341501501432','Phonchanok','Naknuan','2008-04-21','-','ไทย','ไทย','พุทธ','2020-02-07'),(7,'1341501495025','Keson','Uthaikon','2007-08-22','-','ไทย','ไทย','พุทธ','2020-02-07');

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

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

INSERT INTO `student_main_permission` VALUES (3,'3309900179716',1,'5341100001679','2022-07-20'),(2,'5341100001679',1,'5341100001679','2018-11-14'),(4,'1339900620815',1,'5341100001679','2025-06-11');

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

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

INSERT INTO `system_module_admin` VALUES (121,'1339900620815','amss_safety','5341100001679','2025-01-06'),(129,'1339900620815','mail','5341100001679','2025-01-06'),(125,'1339900620815','delegate','5341100001679','2025-01-06'),(128,'1339900620815','la','5341100001679','2025-01-06'),(127,'1339900620815','idplan','5341100001679','2025-01-06'),(106,'5341100001679','delegate','5341100001679','2018-11-14'),(126,'1339900620815','health','5341100001679','2025-01-06'),(122,'1339900620815','amss_spacial_student','5341100001679','2025-01-06'),(123,'1339900620815','amss_supervision','5341100001679','2025-01-06'),(105,'5341100001679','cabinet','5341100001679','2018-11-14'),(120,'1339900620815','amss_mail','5341100001679','2025-01-06'),(102,'5341100001679','amss_mail','5341100001679','2018-11-14'),(104,'5341100001679','affair','5341100001679','2018-11-14'),(103,'5341100001679','permission','5341100001679','2018-11-14'),(133,'3340400689792','affair','5341100001679','2025-08-02'),(130,'1339900620815','meeting','5341100001679','2025-01-06'),(119,'1339900620815','amss_budget','5341100001679','2025-01-06'),(124,'1339900620815','cabinet','5341100001679','2025-01-06'),(118,'1339900620815','affair','5341100001679','2025-01-06'),(131,'1339900620815','permission','5341100001679','2025-01-06'),(132,'1339900620815','warroom','5341100001679','2025-01-06'),(83,'5341100001679','achievement','7777','2018-11-11'),(84,'5341100001679','amss_bets','7777','2018-11-11'),(85,'5341100001679','amss_budget','7777','2018-11-11'),(86,'5341100001679','amss_opportunity','7777','2018-11-11'),(87,'5341100001679','amss_spacial_student','7777','2018-11-11'),(88,'5341100001679','amss_supervision','7777','2018-11-11'),(89,'5341100001679','bets','7777','2018-11-11'),(90,'5341100001679','book','7777','2018-11-11'),(91,'5341100001679','bookregister','7777','2018-11-11'),(92,'5341100001679','budget','7777','2018-11-11'),(93,'5341100001679','health','7777','2018-11-11'),(94,'5341100001679','la','7777','2018-11-11'),(95,'5341100001679','person','7777','2018-11-11'),(96,'5341100001679','plan','7777','2018-11-11'),(97,'5341100001679','savings','7777','2018-11-11'),(98,'5341100001679','standard','7777','2018-11-11'),(99,'5341100001679','student_check','7777','2018-11-11'),(100,'5341100001679','student_main','7777','2018-11-11'),(101,'5341100001679','work','7777','2018-11-11'),(109,'1339900620815','amss_bets','5341100001679','2025-01-06'),(110,'1339900620815','amss_opportunity','5341100001679','2025-01-06'),(111,'1339900620815','student_main','5341100001679','2025-01-06'),(112,'1339900620815','book','5341100001679','2025-01-06'),(113,'1339900620815','bookregister','5341100001679','2025-01-06'),(114,'1339900620815','budget','5341100001679','2025-01-06'),(115,'1339900620815','person','5341100001679','2025-01-06'),(116,'1339900620815','questionnaire','5341100001679','2025-01-06'),(117,'1339900620815','student_check','5341100001679','2025-01-06'),(134,'3340400689792','amss_budget','5341100001679','2025-08-02');

--
-- 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,'34040057','amssplus','34040057','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=74 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `work_main` VALUES (21,'2018-11-14','3341500574416',1,NULL,'2018-11-14 11:30:58','5341100001679'),(22,'2018-11-14','3349900749512',1,NULL,'2018-11-14 11:30:58','5341100001679'),(23,'2018-11-14','5341100001679',1,NULL,'2018-11-14 11:30:58','5341100001679'),(24,'2018-11-14','3341501365624',1,NULL,'2018-11-14 11:30:58','5341100001679'),(25,'2018-11-13','3341500574416',1,NULL,'2018-11-14 11:32:31','5341100001679'),(26,'2018-11-13','3349900749512',1,NULL,'2018-11-14 11:32:31','5341100001679'),(27,'2018-11-13','5341100001679',2,NULL,'2018-11-14 11:32:31','5341100001679'),(28,'2018-11-13','3341501365624',1,NULL,'2018-11-14 11:32:31','5341100001679'),(29,'2019-05-16','3340400689792',1,NULL,'2019-06-16 19:08:32','5341100001679'),(30,'2019-05-16','3341500574416',1,NULL,'2019-06-16 19:08:32','5341100001679'),(31,'2019-05-16','3349900749512',1,NULL,'2019-06-16 19:08:32','5341100001679'),(32,'2019-05-16','5341100001679',1,NULL,'2019-06-16 19:08:32','5341100001679'),(33,'2019-05-16','3341501365624',1,NULL,'2019-06-16 19:08:32','5341100001679'),(34,'2019-05-17','3340400689792',1,NULL,'2019-06-16 19:08:48','5341100001679'),(35,'2019-05-17','3341500574416',1,NULL,'2019-06-16 19:08:48','5341100001679'),(36,'2019-05-17','3349900749512',1,NULL,'2019-06-16 19:08:48','5341100001679'),(37,'2019-05-17','5341100001679',1,NULL,'2019-06-16 19:08:48','5341100001679'),(38,'2019-05-17','3341501365624',1,NULL,'2019-06-16 19:08:48','5341100001679'),(39,'2019-06-14','3340400689792',2,NULL,'2019-06-16 19:09:25','5341100001679'),(40,'2019-06-14','3341500574416',1,NULL,'2019-06-16 19:09:25','5341100001679'),(41,'2019-06-14','3349900749512',1,NULL,'2019-06-16 19:09:25','5341100001679'),(42,'2019-06-14','5341100001679',2,NULL,'2019-06-16 19:09:25','5341100001679'),(43,'2019-06-14','3341501365624',1,NULL,'2019-06-16 19:09:25','5341100001679'),(44,'2019-06-13','3340400689792',1,NULL,'2019-06-16 19:09:35','5341100001679'),(45,'2019-06-13','3341500574416',1,NULL,'2019-06-16 19:09:35','5341100001679'),(46,'2019-06-13','3349900749512',1,NULL,'2019-06-16 19:09:35','5341100001679'),(47,'2019-06-13','5341100001679',1,NULL,'2019-06-16 19:09:35','5341100001679'),(48,'2019-06-13','3341501365624',1,NULL,'2019-06-16 19:09:35','5341100001679'),(49,'2019-06-12','3340400689792',1,NULL,'2019-06-16 19:10:02','5341100001679'),(50,'2019-06-12','3341500574416',1,NULL,'2019-06-16 19:10:02','5341100001679'),(51,'2019-06-12','3349900749512',1,NULL,'2019-06-16 19:10:02','5341100001679'),(52,'2019-06-12','5341100001679',1,NULL,'2019-06-16 19:10:02','5341100001679'),(53,'2019-06-12','3341501365624',1,NULL,'2019-06-16 19:10:02','5341100001679'),(54,'2019-06-20','3340400689792',2,NULL,'2019-06-20 12:50:39','5341100001679'),(55,'2019-06-20','3341500574416',1,NULL,'2019-06-20 12:50:39','5341100001679'),(56,'2019-06-20','3349900749512',2,NULL,'2019-06-20 12:50:39','5341100001679'),(57,'2019-06-20','5341100001679',1,NULL,'2019-06-20 12:50:39','5341100001679'),(58,'2019-06-20','3341501365624',1,NULL,'2019-06-20 12:50:39','5341100001679'),(59,'2019-07-15','3340400689792',2,NULL,'2019-07-15 11:02:29','5341100001679'),(60,'2019-07-15','3341500574416',1,NULL,'2019-07-15 11:02:29','5341100001679'),(61,'2019-07-15','3349900749512',1,NULL,'2019-07-15 11:02:29','5341100001679'),(62,'2019-07-15','5341100001679',1,NULL,'2019-07-15 11:02:29','5341100001679'),(63,'2019-07-15','3341501365624',1,NULL,'2019-07-15 11:02:29','5341100001679'),(64,'2019-07-12','3340400689792',1,NULL,'2019-07-15 11:02:59','5341100001679'),(65,'2019-07-12','3341500574416',1,NULL,'2019-07-15 11:02:59','5341100001679'),(66,'2019-07-12','3349900749512',1,NULL,'2019-07-15 11:02:59','5341100001679'),(67,'2019-07-12','5341100001679',1,NULL,'2019-07-15 11:02:59','5341100001679'),(68,'2019-07-12','3341501365624',1,NULL,'2019-07-15 11:02:59','5341100001679'),(69,'2019-07-11','3340400689792',2,NULL,'2019-07-15 11:03:13','5341100001679'),(70,'2019-07-11','3341500574416',1,NULL,'2019-07-15 11:03:13','5341100001679'),(71,'2019-07-11','3349900749512',1,NULL,'2019-07-15 11:03:13','5341100001679'),(72,'2019-07-11','5341100001679',1,NULL,'2019-07-15 11:03:13','5341100001679'),(73,'2019-07-11','3341501365624',1,NULL,'2019-07-15 11:03:13','5341100001679');

--
-- 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 (3,'5341100001679',1,'5341100001679','2018-11-14');


