-- 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 (1,1,'1342200025586',2562),(2,1,'1342200025586',2562),(3,1,'1342200025586',2562),(4,1,'1342200025586',2562),(5,1,'1342200025586',2562),(6,1,'1342200025586',2562),(7,1,'1342200025586',2562),(8,1,'1342200025586',2562),(1,0,'1342200025586',2562),(2,0,'1342200025586',2562),(3,0,'1342200025586',2562),(4,0,'1342200025586',2562),(5,0,'1342200025586',2562),(7,0,'1342200025586',2562),(8,0,'1342200025586',2562),(6,0,'1342200025586',2562),(1,1,'1342200025586',2563),(2,0,'1342200025586',2563),(3,0,'1342200025586',2563),(4,0,'1342200025586',2563),(5,0,'1342200025586',2563),(6,0,'1342200025586',2563),(7,0,'1342200025586',2563),(8,0,'1342200025586',2563),(1,0,'1342200025586',2564),(2,0,'1342200025586',2564),(3,0,'1342200025586',2564),(4,0,'1342200025586',2564),(5,0,'1342200025586',2564),(6,0,'1342200025586',2564),(7,0,'1342200025586',2564),(8,0,'1342200025586',2564),(1,0,'3331300239176',2566),(1,0,'3331300239176',2568),(4,0,'1330900316051',2568),(5,0,'1450600184140',2566),(3,0,'3341500551700',2568),(7,0,'1339900362409',2566),(2,0,'1349900710032',2568),(1,0,'3331300239176',2567),(2,0,'1349900710032',2567),(3,0,'3341500551700',2567),(4,0,'1330900316051',2567),(5,0,'1450600184140',2567),(6,0,'3341500520154',2567),(7,0,'1339900362409',2567),(8,0,'1341500264062',2567),(5,0,'1450600184140',2568),(6,0,'3341500520154',2568),(7,0,'1339900362409',2568),(8,0,'1341500264062',2568);

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

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

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

INSERT INTO `student_check_year` VALUES (7,2567,0),(5,2566,0),(8,2568,1);

--
-- Table structure for table `student_inclass_main`
--

CREATE TABLE `student_inclass_main` (
  `check_date` date NOT NULL COMMENT 'วันที่บันทึก',
  `student_id` int(11) NOT NULL COMMENT 'รหัสนักเรียน',
  `class_now` tinyint(4) NOT NULL COMMENT 'ชั้นเรียนปัจจุบันที่บันทึก',
  `room_now` tinyint(4) NOT NULL COMMENT 'ห้องเรียนปัจจุบันที่บันทึก',
  `student_check_year` int(11) NOT NULL COMMENT 'ปีการศึกษาที่บันทึก',
  `check_val` varchar(50) NOT NULL COMMENT 'ค่าการเช็ค',
  `check_person_id` varchar(13) NOT NULL COMMENT 'ผู้ทำรายการ',
  `save_date` datetime NOT NULL COMMENT 'วันที่ทำรายการบันทึก'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `student_inclass_main`
--

INSERT INTO `student_inclass_main` VALUES ('2016-08-02',3554,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:52'),('2016-08-02',3564,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:52'),('2016-08-02',3563,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:52'),('2016-08-02',3562,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-02 09:08:55'),('2016-08-02',3560,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:52'),('2016-08-02',3559,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:52'),('2016-08-02',3558,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:52'),('2016-08-02',3557,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:52'),('2016-08-02',3556,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:52'),('2016-08-02',3612,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:52'),('2016-08-03',3589,7,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:24'),('2016-08-03',3609,7,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:24'),('2016-08-03',3607,7,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:24'),('2016-08-03',3606,7,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:24'),('2016-08-03',3603,7,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:24'),('2016-08-03',3602,7,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:24'),('2016-08-03',3601,7,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:24'),('2016-08-03',3599,7,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:24'),('2016-08-03',3598,7,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:24'),('2016-08-03',3597,7,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:24'),('2016-08-03',3596,7,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:24'),('2016-08-03',3595,7,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:24'),('2016-08-03',3594,7,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:24'),('2016-08-03',3593,7,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:24'),('2016-08-03',3592,7,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:24'),('2016-08-03',3591,7,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:24'),('2016-08-03',3590,7,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:24'),('2016-08-03',3610,7,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:24'),('2016-08-03',3554,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:44'),('2016-08-03',3556,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:44'),('2016-08-03',3557,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:44'),('2016-08-03',3558,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:44'),('2016-08-03',3559,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:44'),('2016-08-03',3560,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:44'),('2016-08-03',3563,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:44'),('2016-08-03',3564,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:44'),('2016-08-03',3612,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:44'),('2016-08-01',3554,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:02'),('2016-08-01',3556,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:02'),('2016-08-01',3557,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:02'),('2016-08-01',3558,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:02'),('2016-08-01',3559,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:02'),('2016-08-01',3560,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:02'),('2016-08-01',3563,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:02'),('2016-08-01',3564,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:02'),('2016-08-01',3612,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:02'),('2016-08-03',3690,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:44'),('2016-08-02',3690,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:52'),('2016-08-01',3690,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-03 11:08:02'),('2016-08-01',3568,8,0,2559,'0:-,1:C,2:-,3:T,4:-,5:-,6:-,','3341500520154','2016-08-03 11:08:29'),('2016-08-01',3586,8,0,2559,'0:-,1:C,2:-,3:T,4:-,5:-,6:-,','3341500520154','2016-08-03 11:08:29'),('2016-08-01',3585,8,0,2559,'0:-,1:C,2:-,3:T,4:-,5:-,6:-,','3341500520154','2016-08-03 11:08:29'),('2016-08-01',3583,8,0,2559,'0:-,1:C,2:-,3:T,4:-,5:-,6:-,','3341500520154','2016-08-03 11:08:29'),('2016-08-01',3582,8,0,2559,'0:-,1:C,2:-,3:T,4:-,5:-,6:-,','3341500520154','2016-08-03 11:08:29'),('2016-08-01',3581,8,0,2559,'0:-,1:C,2:-,3:T,4:-,5:-,6:-,','3341500520154','2016-08-03 11:08:29'),('2016-08-01',3580,8,0,2559,'0:-,1:C,2:-,3:T,4:-,5:-,6:-,','3341500520154','2016-08-03 11:08:29'),('2016-08-01',3579,8,0,2559,'0:-,1:C,2:-,3:T,4:-,5:-,6:-,','3341500520154','2016-08-03 11:08:29'),('2016-08-01',3578,8,0,2559,'0:-,1:C,2:-,3:T,4:-,5:-,6:-,','3341500520154','2016-08-03 11:08:29'),('2016-08-01',3577,8,0,2559,'0:-,1:C,2:-,3:T,4:-,5:-,6:-,','3341500520154','2016-08-03 11:08:29'),('2016-08-01',3576,8,0,2559,'0:-,1:C,2:-,3:T,4:-,5:-,6:-,','3341500520154','2016-08-03 11:08:29'),('2016-08-01',3574,8,0,2559,'0:-,1:C,2:-,3:T,4:-,5:-,6:-,','3341500520154','2016-08-03 11:08:29'),('2016-08-01',3573,8,0,2559,'0:-,1:C,2:-,3:T,4:-,5:-,6:-,','3341500520154','2016-08-03 11:08:29'),('2016-08-01',3570,8,0,2559,'0:-,1:C,2:-,3:T,4:-,5:-,6:-,','3341500520154','2016-08-03 11:08:29'),('2016-08-01',3653,8,0,2559,'0:-,1:C,2:-,3:T,4:-,5:-,6:-,','3341500520154','2016-08-03 11:08:29'),('2016-08-17',3554,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:57'),('2016-08-17',3564,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:57'),('2016-08-17',3563,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:57'),('2016-08-17',3560,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:57'),('2016-08-17',3559,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:57'),('2016-08-17',3558,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:57'),('2016-08-17',3557,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:57'),('2016-08-17',3556,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:57'),('2016-08-17',3612,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:57'),('2016-08-17',3690,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:57'),('2016-08-16',3554,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:01'),('2016-08-16',3564,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:01'),('2016-08-16',3563,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:01'),('2016-08-16',3560,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:01'),('2016-08-16',3559,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:01'),('2016-08-16',3558,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:01'),('2016-08-16',3557,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:01'),('2016-08-16',3556,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:01'),('2016-08-16',3612,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:01'),('2016-08-16',3690,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:01'),('2016-08-15',3554,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:43'),('2016-08-15',3564,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:43'),('2016-08-15',3563,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:43'),('2016-08-15',3560,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:43'),('2016-08-15',3559,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:43'),('2016-08-15',3558,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:43'),('2016-08-15',3557,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:43'),('2016-08-15',3556,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:43'),('2016-08-15',3612,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:43'),('2016-08-15',3690,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:43'),('2016-08-11',3554,9,0,2559,'0:L,1:L,2:L,3:T,4:L,5:L,6:L,','3341500520154','2016-08-17 10:08:35'),('2016-08-11',3564,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:35'),('2016-08-11',3563,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:35'),('2016-08-11',3560,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:35'),('2016-08-11',3559,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:35'),('2016-08-11',3558,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:35'),('2016-08-11',3557,9,0,2559,'0:L,1:L,2:L,3:T,4:L,5:L,6:L,','3341500520154','2016-08-17 10:08:35'),('2016-08-11',3556,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:35'),('2016-08-11',3612,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:35'),('2016-08-11',3690,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:35'),('2016-08-10',3554,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:53'),('2016-08-10',3564,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:53'),('2016-08-10',3563,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:53'),('2016-08-10',3560,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:53'),('2016-08-10',3559,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:53'),('2016-08-10',3558,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:53'),('2016-08-10',3557,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:53'),('2016-08-10',3556,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:53'),('2016-08-10',3612,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:53'),('2016-08-10',3690,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:53'),('2016-08-09',3554,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:10'),('2016-08-09',3564,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:10'),('2016-08-09',3563,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:10'),('2016-08-09',3560,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:10'),('2016-08-09',3559,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:10'),('2016-08-09',3558,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:10'),('2016-08-09',3557,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:10'),('2016-08-09',3556,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:10'),('2016-08-09',3612,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:10'),('2016-08-09',3690,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:10'),('2016-08-08',3554,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:26'),('2016-08-08',3564,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:26'),('2016-08-08',3563,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:26'),('2016-08-08',3560,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:26'),('2016-08-08',3559,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:26'),('2016-08-08',3558,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:26'),('2016-08-08',3557,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:26'),('2016-08-08',3556,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:26'),('2016-08-08',3612,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:26'),('2016-08-08',3690,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:26'),('2016-08-05',3554,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:44'),('2016-08-05',3564,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:44'),('2016-08-05',3563,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:44'),('2016-08-05',3560,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:44'),('2016-08-05',3559,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:44'),('2016-08-05',3558,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:44'),('2016-08-05',3557,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:44'),('2016-08-05',3556,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:44'),('2016-08-05',3612,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:44'),('2016-08-05',3690,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:44'),('2016-08-04',3554,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:01'),('2016-08-04',3564,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:01'),('2016-08-04',3563,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:01'),('2016-08-04',3560,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:01'),('2016-08-04',3559,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:01'),('2016-08-04',3558,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:01'),('2016-08-04',3557,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:01'),('2016-08-04',3556,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:01'),('2016-08-04',3612,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:01'),('2016-08-04',3690,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-17 10:08:01'),('2016-08-24',3554,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:10'),('2016-08-24',3564,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:10'),('2016-08-24',3563,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:10'),('2016-08-24',3560,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:10'),('2016-08-24',3559,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:10'),('2016-08-24',3558,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:10'),('2016-08-24',3557,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:10'),('2016-08-24',3556,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:10'),('2016-08-24',3612,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:10'),('2016-08-24',3690,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:10'),('2016-08-22',3554,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:54'),('2016-08-22',3564,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:54'),('2016-08-22',3563,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:54'),('2016-08-22',3560,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:54'),('2016-08-22',3559,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:54'),('2016-08-22',3558,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:54'),('2016-08-22',3557,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:54'),('2016-08-22',3556,9,0,2559,'0:L,1:L,2:L,3:T,4:L,5:L,6:L,','3341500520154','2016-08-24 04:08:54'),('2016-08-22',3612,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:54'),('2016-08-22',3690,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:54'),('2016-08-23',3554,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:09'),('2016-08-23',3564,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:09'),('2016-08-23',3563,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:09'),('2016-08-23',3560,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:09'),('2016-08-23',3559,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:09'),('2016-08-23',3558,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:09'),('2016-08-23',3557,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:09'),('2016-08-23',3556,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:09'),('2016-08-23',3612,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:09'),('2016-08-23',3690,9,0,2559,'0:C,1:C,2:C,3:T,4:C,5:C,6:C,','3341500520154','2016-08-24 04:08:09');

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

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

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

INSERT INTO `student_inclass_part` VALUES (1,2559,1,'2016-05-16','2016-10-10','2016-06-26','3341500650821'),(2,2566,2,'2024-11-01','2024-03-29','2024-03-04','3341500520154'),(3,2566,1,'2023-05-16','2024-10-10','2024-03-29','3341500520154');

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

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

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

INSERT INTO `student_inclass_permission` VALUES (3,0,'3349800004957',2559),(5,0,'3341501553595',2559),(6,0,'3340400252599',2559),(7,0,'3421000149936',2559),(8,0,'3341800228874',2559),(9,0,'3341500520154',2559),(2,1,'3349800025792',2559),(4,1,'4341500010537',2559),(8,0,'3341500520154',2566),(5,0,'1450600184140',2566),(6,0,'1341500264062',2566),(7,0,'1339900362409',2566),(4,0,'3341500551700',2566),(3,0,'1329900406678',2566),(2,0,'3331300239176',2566),(1,0,'3331300239176',2566);

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

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

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

INSERT INTO `student_inclass_ref` VALUES (1,'1466921747521349711','Monday',2),(2,'1466921747521349711','Tuesday',1),(3,'1466921747521349711','Wednesday',3),(4,'1466921747521349711','Thursday',2),(5,'1466921747521349711','Friday',3),(18,'1470146514555247469','Thursday',1),(17,'1470146514555247469','Monday',2),(19,'147014655276628633','Tuesday',1),(21,'1470149746691067399','Wednesday',5),(24,'14701497811403124608','Friday',3),(23,'14701497811403124608','Wednesday',7),(12,'14701498011931128903','Wednesday',7),(13,'14701498011931128903','Thursday',3),(26,'14701498371028774606','Monday',5),(15,'1470146467819044117','Wednesday',2),(16,'1470146467819044117','Friday',1),(20,'147014655276628633','Wednesday',3),(22,'1470149746691067399','Thursday',2),(25,'14701498211361821658','Wednesday',5),(27,'14701498371028774606','Wednesday',3);

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

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

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

INSERT INTO `student_inclass_subject` VALUES (1,2559,1,'คณิตศาสตร์',7,0,'1466921747521349711','3341500650821','2016-06-26'),(2,2559,1,'ภาษาอังกฤษ',7,0,'1470146467819044117','3341500520154','2016-08-02'),(3,2559,1,'ภาษาอังกฤษ',8,0,'1470146514555247469','3341500520154','2016-08-02'),(4,2559,1,'ภาษาอังกฤษ',9,0,'147014655276628633','3341500520154','2016-08-02'),(5,2559,1,'วิทยาศาสตร์',9,0,'1470149746691067399','3341500520154','2016-08-02'),(6,2559,1,'สุขศึกษาและพลศึกษา',9,0,'14701497811403124608','3341500520154','2016-08-02'),(7,2559,1,'สุขศึกษาและพลศึกษา',8,0,'14701498011931128903','3341500520154','2016-08-02'),(8,2559,1,'การงานอาชีพและเทคโนโลยี',9,0,'14701498211361821658','3341500520154','2016-08-02'),(9,2559,1,'ศิลปะ',9,0,'14701498371028774606','3341500520154','2016-08-02');

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

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

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

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

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

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

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

INSERT INTO `student_main` VALUES (193,'3780',4,'เด็กชาย','ณัฐกรณ์','กุลพิลา','1103705195961',1,'',5,0,0,NULL,'3341500520154','2021-06-14'),(194,'3787',5,'เด็กชาย','วุฒิชัย','บุญเชื้อ','1341501603081',1,'',5,0,0,NULL,'3341500520154','2021-06-14'),(195,'3781',6,'เด็กชาย','ทินกร','อาษาดี','1349902141035',1,'',5,0,0,NULL,'3341500520154','2021-06-14'),(276,'3841',3,'เด็กชาย','ยศกร','บุญเชื้อ','1341501657611',1,'',1,0,0,NULL,'3341500520154','2025-05-20'),(272,'3778',7,'เด็กชาย','เมธาสิทธิ์','อินจันทร์','1347500104461',1,'',7,0,0,NULL,'3341500520154','2024-05-28'),(273,'3777',10,'เด็กหญิง','เมธาสินี','อินจันทร์','1349902082233',2,'',6,0,0,NULL,'3341500520154','2024-05-28'),(208,'3797',6,'เด็กชาย','ภาวัช','ปรัสพันธ์','1349901984489',1,'',7,0,0,NULL,'3341500520154','2021-11-16'),(230,'3796',10,'เด็กชาย','ดรัณภพ','ปรัสพันธ์','1349902143054',1,'',5,0,0,NULL,'3341500520154','2023-03-28'),(256,'3823',9,'เด็กหญิง','กฤตยา','สาระพันธ์','1349902273616',2,'',3,0,0,NULL,'3341500520154','2024-05-28'),(278,'3843',5,'เด็กชาย','อัษศดิณย์','จำปาสี','1347600162607',1,'',1,0,0,NULL,'3341500520154','2025-05-20'),(244,'3817',2,'เด็กชาย','ปิยะวัฒน์','ยานสิริ','1342200168549',1,'',3,0,0,NULL,'3341500520154','2023-07-13'),(281,'3846',8,'เด็กหญิง','ณัฐณิชา','ชาภักดี','1349902363917',2,'',1,0,0,NULL,'3341500520154','2025-05-20'),(229,'3763',2,'เด็กชาย','กันตพัชร','สายสิงห์','1349902056143',1,'',6,0,0,NULL,'3341500520154','2023-03-28'),(184,'3766',9,'เด็กชาย','ภคภูมิ','พ่อค้า','1119902901864',1,'',6,0,0,NULL,'3341500520154','2020-08-05'),(192,'3785',3,'เด็กชาย','วรินทร','ใยสูบ','1342200166619',1,'',5,0,0,NULL,'3341500520154','2021-06-14'),(182,'3769',8,'เด็กชาย','นะโม','ทองอุ่นลา','1119902874183',1,'',6,0,0,NULL,'3341500520154','2020-08-05'),(137,'3753',2,'เด็กชาย','ชนาภัทร','แก้วคันโท','1349902026074',1,'',7,0,0,NULL,'3341500520154','2019-05-28'),(138,'3754',4,'เด็กชาย','ธนวัฒน์','วงษ์เอี่ยม','1629901077641',1,'',1,0,2,2562,'3341501718799','2019-05-28'),(139,'3755',3,'เด็กชาย','บวรรัตน์','มรรคพิมพ์','1349902024845',1,'',7,0,0,NULL,'3341500520154','2019-05-28'),(140,'3756',4,'เด็กหญิง','ปุณยาพร','อินทหอม','1349700503084',2,'',7,0,0,NULL,'3341500520154','2019-05-28'),(141,'3757',5,'เด็กหญิง','สิริลักษณ์','ผ่านผล','1342200164519',2,'',7,0,0,NULL,'3341500520154','2019-05-28'),(286,'3851',10,'เด็กชาย','ธนวัต','เกตุวัตร์','1342200169227',1,'',2,0,0,NULL,'3341500520154','2025-05-27'),(283,'3848',10,'เด็กหญิง','อรินดา','เชื้อชัย','1349902373718',2,'',1,0,0,NULL,'3341500520154','2025-05-20'),(284,'3849',11,'เด็กหญิง','อลิสา','บุญบุตร','1346400006783',2,'',1,0,0,NULL,'3341500520154','2025-05-20'),(235,'3801',2,'เด็กชาย','ภาธร','คำเพราะ','1347600136142',1,'',4,0,0,NULL,'3341500520154','2023-03-28'),(236,'3805',3,'เด็กชาย','อนุภัทร','จันทะแพง','1349902199599',1,'',4,0,0,NULL,'3341500520154','2023-03-28'),(285,'3850',12,'เด็กหญิง','สิรินดา','แพงบุดดี','1346400002401',2,'',1,0,0,NULL,'1342200025586','2025-05-20'),(282,'3847',9,'เด็กหญิง','ธัญรดา','หาญยิ่ง','1346400009316',2,'',1,0,0,NULL,'3341500520154','2025-05-20'),(249,'3822',7,'เด็กหญิง','นริศรา','วารีย์','1101000672163',2,'',3,0,0,NULL,'3341500520154','2023-07-13'),(136,'3752',1,'เด็กชาย','ชนาธิป','บุญมางำ','1349902035529',1,'',7,0,0,NULL,'3341500520154','2019-05-28'),(248,'3820',6,'เด็กหญิง','กนกวรรณ','ผลมาก','1349902263092',2,'',3,0,0,NULL,'3341500520154','2023-07-13'),(199,'3793',9,'เด็กหญิง','กวินธิดา','ศิริบูรณ์','1349902153530',2,'',5,0,0,NULL,'3341500520154','2021-06-14'),(200,'3792',11,'เด็กหญิง','นิชาภา','พันธ์กิ่งทิพย์','1349902171406',2,'',5,0,0,NULL,'3341500520154','2021-06-14'),(181,'3771',7,'เด็กหญิง','ธนาภา','ขันพนม','1347600117024',2,'',6,0,0,NULL,'3341500520154','2020-08-05'),(180,'3770',6,'เด็กหญิง','กัญจนพร','บรรมณี','1342200165281',2,'',6,0,0,NULL,'3341500520154','2020-08-05'),(179,'3773',5,'เด็กหญิง','วรรณวิษา','สุพรม','1349902047306',2,'',6,0,0,NULL,'3341500520154','2020-08-05'),(257,'3836',10,'เด็กหญิง','สุทธิดา','โอชพัด','1331300160301',2,'',3,0,0,NULL,'3341500520154','2024-05-28'),(177,'3764',4,'เด็กชาย','จิรโชติ','หอมดวงศรี','1349902108054',1,'',6,0,0,NULL,'3341500520154','2020-08-05'),(176,'3767',3,'เด็กชาย','วิทวัฒน์','นามพรม','1349902054019',1,'',6,0,0,NULL,'3341500520154','2020-08-05'),(175,'3768',1,'เด็กชาย','ศิรสิทธิ์','อุระวงค์','1341501592683',1,'',6,0,0,NULL,'3341500520154','2020-08-05'),(275,'3840',2,'เด็กชาย','เดชาธร','พาชื่น','1349902350548',1,'',1,0,0,NULL,'3341500520154','2025-05-20'),(259,'3825',1,'เด็กชาย','ธนกฤติ','สีดา','1349902284448',1,'',2,0,0,NULL,'3341500520154','2024-05-28'),(260,'3826',2,'เด็กชาย','วงศธร','อินทหอม','1349700593709',1,'',2,0,0,NULL,'3341500520154','2024-05-28'),(261,'3827',3,'เด็กชาย','ธีรวัฒน์','จันทะแพง','1341501652929',1,'',2,0,0,NULL,'3341500520154','2024-05-28'),(262,'3828',4,'เด็กชาย','ธนภัทร','สุวรรณมาโจ','1341501654743',1,'',2,0,0,NULL,'3341500520154','2024-05-28'),(263,'3829',5,'เด็กชาย','พลกร','ภูเงิน','1200601627578',1,'',2,0,0,NULL,'3341500520154','2024-05-28'),(274,'3839',1,'เด็กชาย','ธนากร','บัวเงิน','1346400012171',1,'',1,0,0,NULL,'3341500520154','2025-05-20'),(265,'3831',6,'เด็กหญิง','นัฐรดา','นันทะบุตร','1349902287030',2,'',2,0,0,NULL,'3341500520154','2024-05-28'),(266,'3832',7,'เด็กหญิง','กมลวรรณ','จันทิมา','1341501654735',2,'',2,0,0,NULL,'3341500520154','2024-05-28'),(267,'3833',8,'เด็กหญิง','วีรวรรณ','ศรีคำอินทร์','1349902318512',2,'',2,0,0,NULL,'3341500520154','2024-05-28'),(268,'3834',9,'เด็กหญิง','กมลชนก','สารภาพ','1349902326051',2,'',2,0,0,NULL,'3341500520154','2024-05-28'),(270,'3790',12,'เด็กหญิง','ฑิฆัมพร','ผุยสุ','1103705216098',2,'',5,0,0,NULL,'3341500520154','2024-05-28'),(279,'3844',6,'เด็กชาย','พีรวิชญ์','สุระดะนัย','1139600997281',1,'',1,0,0,NULL,'3341500520154','2025-05-20'),(234,'3800',1,'เด็กชาย','ธราธิป','สิวะสุภาพร','1348900447217',1,'',4,0,0,NULL,'3341500520154','2023-03-28'),(245,'3815',3,'เด็กชาย','ทินกร','เชื้อพรมทำ','1342200168433',1,'',3,0,0,NULL,'3341500520154','2023-07-13'),(222,'3810',11,'เด็กหญิง','สุพิชญา','ทาธิสา','1341501586420',2,'',6,0,0,NULL,'3341500520154','2022-09-16'),(250,'3821',8,'เด็กหญิง','ฐิติรัตน์','โททอง','1341501631891',2,'',3,0,0,NULL,'3341500520154','2023-07-13'),(280,'3845',7,'เด็กหญิง','ณิชานันท์','นามเวช','134220170225',2,'',1,0,0,NULL,'3341500520154','2025-05-20'),(237,'3802',4,'เด็กหญิง','พิมพ์ชนก','บุญสาลี','1342200167445',2,'',4,0,0,NULL,'3341500520154','2023-03-28'),(238,'3803',5,'เด็กหญิง','กานต์ธิดา','ลาธุลี','1347600136631',2,'',4,0,0,NULL,'3341500520154','2023-03-28'),(239,'3804',6,'เด็กหญิง','ณัฏฐณิชา','พรมสว่าง','1349902221403',2,'',4,0,0,NULL,'3341500520154','2023-03-28'),(240,'3806',7,'เด็กหญิง','ปาลิตา','ทะคำวงค์','1349902184354',2,'',4,0,0,NULL,'3341500520154','2023-03-28'),(171,'3759',12,'เด็กหญิง','ชลธิชา','นวลอนันต์','1347600091203',2,'',8,0,0,NULL,'3341500520154','2020-02-24'),(153,'3730',1,'เด็กชาย','กายทิพย์','วิไลวงษ์','1349901933418',1,'',8,0,0,NULL,'3341500520154','2019-05-28'),(154,'3731',2,'เด็กชาย','ณภัทร','พวงจำปา','1342200161234',1,'',8,0,0,NULL,'3341500520154','2019-05-28'),(155,'3732',3,'เด็กชาย','ณัฐธวัช','ดีมิตร','1342200161056',1,'',8,0,0,NULL,'3341500520154','2019-05-28'),(157,'3734',4,'เด็กชาย','รัชชานนท์','เกาะแก้ว','1749800608755',1,'',8,0,0,NULL,'3341500520154','2019-05-28'),(158,'3735',5,'เด็กชาย','อุดมศักดิ์','ผลมาก','1349901942522',1,'',8,0,0,NULL,'3341500520154','2019-05-28'),(159,'3736',6,'เด็กหญิง','ปภาดา','พรมสวัสดิ์','1349901914987',2,'',8,0,0,NULL,'3341500520154','2019-05-28'),(160,'3737',7,'เด็กหญิง','พรนัชชา','ชัยธรรม','1342200161285',2,'',8,0,0,NULL,'3341500520154','2019-05-28'),(161,'3738',8,'เด็กหญิง','อุรัสญา','มุ่งสิน','1349901919571',2,'',8,0,0,NULL,'3341500520154','2019-05-28'),(162,'3745',9,'เด็กหญิง','อรกัญญา','นันทะบัน','1110301571039',2,'',8,0,0,NULL,'3341500520154','2019-05-28'),(163,'3750',10,'เด็กชาย','กวี','บุญสาลี','1342200162397',1,'',8,0,0,NULL,'3341500520154','2019-05-28'),(164,'3758',11,'เด็กหญิง','สุกัลยา','ผองพุฒ','1104000337910',2,'',8,0,0,NULL,'3341500520154','2019-05-28'),(241,'3807',8,'เด็กหญิง','ลลิตา','ทะคำวงค์','1349902184362',2,'',4,0,0,NULL,'3341500520154','2023-03-28'),(246,'3818',4,'เด็กชาย','ณชภณ','เพ็ญนุ','1469500086756',1,'',3,0,0,NULL,'3341500520154','2023-07-13'),(190,'3783',1,'เด็กชาย','ภานุวัฒน์','ทุมมานาม','1347600125809',1,'',5,0,0,NULL,'3341500520154','2021-06-14'),(191,'3786',2,'เด็กชาย','วีรภัทร','บัวเงิน','1342200166236',1,'',5,0,0,NULL,'3341500520154','2021-06-14'),(252,'3788',8,'เด็กหญิง','เกวรินทร์','แดงนาเพียง','1347600121854',2,'',5,0,0,NULL,'3341500520154','2024-03-05');

--
-- 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,'อนุบาล2'),(2,2,'อนุุบาล3'),(3,3,'ประถมศึกษาปีที่1'),(4,4,'ประถมศึกษาปีที่2'),(5,5,'ประถมศึกษาปีที่3'),(6,6,'ประถมศึกษาปีที่4'),(7,7,'ประถมศึกษาปีที่5'),(8,8,'ประถมศึกษาปีที่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=749 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

INSERT INTO `student_main_classlog` VALUES (1,2559,'3675',0,3,0,'3341500520154','2016-08-02'),(2,2559,'3676',0,3,0,'3341500520154','2016-08-02'),(3,2559,'3677',0,3,0,'3341500520154','2016-08-02'),(4,2559,'3678',0,3,0,'3341500650821','2016-06-26'),(5,2559,'3679',0,3,0,'3341500520154','2016-08-02'),(6,2559,'3680',0,3,0,'3341500520154','2016-08-02'),(7,2559,'3681',0,3,0,'3341500520154','2016-08-02'),(8,2559,'3682',0,3,0,'3341500520154','2016-08-02'),(9,2559,'3683',0,3,0,'3341500520154','2016-08-02'),(10,2559,'3684',0,3,0,'3341500520154','2016-08-02'),(11,2559,'3685',0,3,0,'3341500650821','2016-06-26'),(12,2559,'3686',0,3,0,'3341500520154','2016-08-02'),(13,2559,'3687',0,3,0,'3341500520154','2016-08-02'),(14,2559,'3688',0,3,0,'3341500520154','2016-08-02'),(15,2559,'3635',0,5,0,'3341500520154','2016-08-02'),(16,2559,'3636',0,5,0,'3341500520154','2016-08-02'),(17,2559,'3637',0,5,0,'3341500520154','2016-08-02'),(18,2559,'3638',0,5,0,'3341500520154','2016-08-02'),(19,2559,'3640',0,5,0,'3341500520154','2016-08-02'),(20,2559,'3642',0,5,0,'3341500520154','2016-08-02'),(21,2559,'3643',0,5,0,'3341500520154','2016-08-02'),(22,2559,'3644',0,5,0,'3341500520154','2016-08-02'),(23,2559,'3645',0,5,0,'3341500520154','2016-08-02'),(24,2559,'3646',0,5,0,'3341500520154','2016-08-02'),(25,2559,'3647',0,5,0,'3341500650821','2016-06-26'),(26,2559,'3648',0,5,0,'3341500520154','2016-08-02'),(27,2559,'3649',0,5,0,'3341500520154','2016-08-02'),(28,2559,'3650',0,5,0,'3341500520154','2016-08-02'),(29,2559,'3651',0,5,0,'3341500520154','2016-08-02'),(30,2559,'3652',0,5,0,'3341500520154','2016-08-02'),(31,2559,'3689',0,5,0,'3341500520154','2016-08-02'),(32,2559,'3616',0,6,0,'3341500520154','2016-08-02'),(33,2559,'3617',0,6,0,'3341500520154','2016-08-02'),(34,2559,'3618',0,6,0,'3341500520154','2016-08-02'),(35,2559,'3619',0,6,0,'3341500520154','2016-08-02'),(36,2559,'3620',0,6,0,'3341500520154','2016-08-02'),(37,2559,'3621',0,6,0,'3341500520154','2016-08-02'),(38,2559,'3622',0,6,0,'3341500520154','2016-08-02'),(39,2559,'3623',0,6,0,'3341500520154','2016-08-02'),(40,2559,'3624',0,6,0,'3341500520154','2016-08-02'),(41,2559,'3628',0,6,0,'3341500520154','2016-08-02'),(42,2559,'3629',0,6,0,'3341500520154','2016-08-02'),(43,2559,'3630',0,6,0,'3341500520154','2016-08-02'),(44,2559,'3631',0,6,0,'3341500520154','2016-08-02'),(45,2559,'3632',0,6,0,'3341500520154','2016-08-02'),(46,2559,'3633',0,6,0,'3341500520154','2016-08-02'),(47,2559,'3671',0,6,0,'3341500520154','2016-08-02'),(48,2559,'3672',0,6,0,'3341500520154','2016-08-02'),(49,2559,'3589',0,7,0,'3341500520154','2016-08-02'),(50,2559,'3590',0,7,0,'3341500520154','2016-08-02'),(51,2559,'3591',0,7,0,'3341500520154','2016-08-02'),(52,2559,'3592',0,7,0,'3341500520154','2016-08-02'),(53,2559,'3593',0,7,0,'3341500520154','2016-08-02'),(54,2559,'3594',0,7,0,'3341500520154','2016-08-02'),(55,2559,'3595',0,7,0,'3341500520154','2016-08-02'),(56,2559,'3596',0,7,0,'3341500520154','2016-08-02'),(57,2559,'3597',0,7,0,'3341500520154','2016-08-02'),(58,2559,'3598',0,7,0,'3341500520154','2016-08-02'),(59,2559,'3599',0,7,0,'3341500520154','2016-08-02'),(60,2559,'3601',0,7,0,'3341500520154','2016-08-02'),(61,2559,'3602',0,7,0,'3341500520154','2016-08-02'),(62,2559,'3603',0,7,0,'3341500520154','2016-08-02'),(63,2559,'3606',0,7,0,'3341500520154','2016-08-02'),(64,2559,'3607',0,7,0,'3341500520154','2016-08-02'),(65,2559,'3608',0,7,0,'3341500650821','2016-06-26'),(66,2559,'3609',0,7,0,'3341500520154','2016-08-02'),(67,2559,'3610',0,7,0,'3341500520154','2016-08-02'),(68,2559,'3673',0,7,0,'3341500650821','2016-06-26'),(69,2559,'3568',0,8,0,'3341500520154','2016-08-02'),(70,2559,'3570',0,8,0,'3341500520154','2016-08-02'),(71,2559,'3573',0,8,0,'3341500520154','2016-08-02'),(72,2559,'3574',0,8,0,'3341500520154','2016-08-02'),(73,2559,'3576',0,8,0,'3341500520154','2016-08-02'),(74,2559,'3577',0,8,0,'3341500520154','2016-08-02'),(75,2559,'3578',0,8,0,'3341500520154','2016-08-02'),(76,2559,'3579',0,8,0,'3341500520154','2016-08-02'),(77,2559,'3580',0,8,0,'3341500520154','2016-08-02'),(78,2559,'3581',0,8,0,'3341500520154','2016-08-02'),(79,2559,'3582',0,8,0,'3341500520154','2016-08-02'),(80,2559,'3583',0,8,0,'3341500520154','2016-08-02'),(81,2559,'3585',0,8,0,'3341500520154','2016-08-02'),(82,2559,'3586',0,8,0,'3341500520154','2016-08-02'),(83,2559,'3653',0,8,0,'3341500520154','2016-08-02'),(84,2559,'3554',0,9,0,'3341500520154','2016-08-02'),(85,2559,'3556',0,9,0,'3341500520154','2016-08-02'),(86,2559,'3557',0,9,0,'3341500520154','2016-08-02'),(87,2559,'3558',0,9,0,'3341500520154','2016-08-02'),(88,2559,'3559',0,9,0,'3341500520154','2016-08-02'),(89,2559,'3560',0,9,0,'3341500520154','2016-08-02'),(90,2559,'3562',0,9,0,'3341500650821','2016-06-26'),(91,2559,'3563',0,9,0,'3341500520154','2016-08-02'),(92,2559,'3564',0,9,0,'3341500520154','2016-08-02'),(93,2559,'3612',0,9,0,'3341500520154','2016-08-02'),(94,2559,'3694',1,2,1,'3341500520154','2016-08-02'),(95,2559,'3695',2,2,1,'3341500520154','2016-08-02'),(96,2559,'3696',3,2,1,'3341500520154','2016-08-02'),(97,2559,'3697',4,2,1,'3341500520154','2016-08-02'),(98,2559,'3698',5,2,1,'3341500520154','2016-08-02'),(99,2559,'3699',6,2,1,'3341500520154','2016-08-02'),(100,2559,'3700',7,2,1,'3341500520154','2016-08-02'),(101,2559,'3701',8,2,1,'3341500520154','2016-08-02'),(102,2559,'3702',9,2,1,'3341500520154','2016-08-02'),(103,2559,'3703',10,2,1,'3341500520154','2016-08-02'),(104,2559,'3704',11,2,1,'3341500520154','2016-08-02'),(105,2559,'3705',12,2,1,'3341500520154','2016-08-02'),(106,2559,'3706',13,2,1,'3341500520154','2016-08-02'),(107,2559,'3707',14,2,1,'3341500520154','2016-08-02'),(108,2559,'3708',15,2,1,'3341500520154','2016-08-02'),(109,2559,'3709',16,2,1,'3341500520154','2016-08-02'),(110,2559,'3710',17,2,1,'3341500520154','2016-08-02'),(111,2559,'3711',18,2,1,'3341500520154','2016-08-02'),(112,2559,'3655',1,4,1,'3341500520154','2016-08-02'),(113,2559,'3656',2,4,1,'3341500520154','2016-08-02'),(114,2559,'3657',3,4,1,'3341500520154','2016-08-02'),(115,2559,'3658',4,4,1,'3341500520154','2016-08-02'),(116,2559,'3659',5,4,1,'3341500520154','2016-08-02'),(117,2559,'3660',6,4,1,'3341500520154','2016-08-02'),(118,2559,'3661',7,4,1,'3341500520154','2016-08-02'),(119,2559,'3662',8,4,1,'3341500520154','2016-08-02'),(120,2559,'3663',9,4,1,'3341500520154','2016-08-02'),(121,2559,'3664',10,4,1,'3341500520154','2016-08-02'),(122,2559,'3665',11,4,1,'3341500520154','2016-08-02'),(123,2559,'3666',12,4,1,'3341500520154','2016-08-02'),(124,2559,'3667',13,4,1,'3341500520154','2016-08-02'),(125,2559,'3668',14,4,1,'3341500520154','2016-08-02'),(126,2559,'3669',15,4,1,'3341500520154','2016-08-02'),(127,2559,'3690',10,9,1,'3341500520154','2016-08-02'),(128,2562,'3754',4,1,0,'3341500520154','2019-09-12'),(129,2562,'3755',4,1,0,'3341500520154','2019-09-12'),(130,2562,'3756',5,1,0,'3341500520154','2019-09-12'),(131,2562,'3757',6,1,0,'3341500520154','2019-09-12'),(137,2562,'3759',13,2,0,'3341500520154','2020-02-24'),(133,2562,'3761',12,3,0,'3341500520154','2020-02-17'),(136,2562,'3763',18,7,0,'3341500520154','2020-02-13'),(135,2562,'3762',18,6,0,'3341500520154','2020-02-13'),(138,2563,'3751',1,2,0,'3341500520154','2020-08-05'),(139,2563,'3752',2,2,0,'3341500520154','2020-08-05'),(140,2563,'3753',3,2,0,'3341500520154','2020-08-05'),(141,2563,'3755',4,2,0,'3341500520154','2020-08-05'),(142,2563,'3756',5,2,0,'3341500520154','2020-08-05'),(143,2563,'3757',6,2,0,'3341500520154','2020-08-05'),(144,2563,'3730',1,3,0,'3341500520154','2020-08-05'),(145,2563,'3732',3,3,0,'3341500520154','2020-08-05'),(146,2563,'3733',4,3,0,'3341500520154','2020-08-05'),(147,2563,'3734',5,3,0,'3341500520154','2020-08-05'),(148,2563,'3735',6,3,0,'3341500520154','2020-08-05'),(149,2563,'3736',7,3,0,'3341500520154','2020-08-05'),(150,2563,'3737',8,3,0,'3341500520154','2020-08-05'),(151,2563,'3738',9,3,0,'3341500520154','2020-08-05'),(152,2563,'3745',10,3,0,'3341500520154','2020-08-05'),(153,2563,'3750',11,3,0,'3341500520154','2020-08-05'),(154,2563,'3758',12,3,0,'3341500520154','2020-08-05'),(155,2563,'3759',13,3,0,'3341500520154','2020-08-05'),(156,2563,'3731',2,3,0,'3341500520154','2020-08-05'),(157,2563,'3715',1,4,0,'3341500520154','2020-08-05'),(158,2563,'3716',2,4,0,'3341500520154','2020-08-05'),(159,2563,'3718',3,4,0,'3341500520154','2020-08-05'),(160,2563,'3719',4,4,0,'3341500520154','2020-08-05'),(161,2563,'3720',5,4,0,'3341500520154','2020-08-05'),(162,2563,'3721',6,4,0,'3341500520154','2020-08-05'),(163,2563,'3722',7,4,0,'3341500520154','2020-08-05'),(164,2563,'3723',8,4,0,'3341500520154','2020-08-05'),(165,2563,'3725',9,4,0,'3341500520154','2020-08-05'),(166,2563,'3739',10,4,0,'3341500520154','2020-08-05'),(247,2563,'3778',12,1,0,'3341500520154','2021-01-15'),(168,2563,'3694',1,5,0,'3341500520154','2020-08-05'),(169,2563,'3695',2,5,0,'3341500520154','2020-08-05'),(170,2563,'3696',3,5,0,'3341500520154','2020-08-05'),(171,2563,'3697',4,5,0,'3341500520154','2020-08-05'),(172,2563,'3698',5,5,0,'3341500520154','2020-08-05'),(173,2563,'3699',6,5,0,'3341500520154','2020-08-05'),(174,2563,'3700',7,5,0,'3341500520154','2020-08-05'),(175,2563,'3702',8,5,0,'3341500520154','2020-08-05'),(176,2563,'3703',9,5,0,'3341500520154','2020-08-05'),(177,2563,'3705',10,5,0,'3341500520154','2020-08-05'),(178,2563,'3706',11,5,0,'3341500520154','2020-08-05'),(179,2563,'3707',12,5,0,'3341500520154','2020-08-05'),(180,2563,'3708',13,5,0,'3341500520154','2020-08-05'),(181,2563,'3709',14,5,0,'3341500520154','2020-08-05'),(182,2563,'3710',15,5,0,'3341500520154','2020-08-05'),(183,2563,'3743',16,5,0,'3341500520154','2020-08-05'),(184,2563,'3675',1,6,0,'3341500520154','2020-08-05'),(185,2563,'3676',2,6,0,'3341500520154','2020-08-05'),(186,2563,'3677',3,6,0,'3341500520154','2020-08-05'),(187,2563,'3679',4,6,0,'3341500520154','2020-08-05'),(188,2563,'3680',5,6,0,'3341500520154','2020-08-05'),(189,2563,'3681',6,6,0,'3341500520154','2020-08-05'),(190,2563,'3682',7,6,0,'3341500520154','2020-08-05'),(191,2563,'3683',8,6,0,'3341500520154','2020-08-05'),(192,2563,'3684',9,6,0,'3341500520154','2020-08-05'),(193,2563,'3686',10,6,0,'3341500520154','2020-08-05'),(194,2563,'3687',11,6,0,'3341500520154','2020-08-05'),(195,2563,'3688',12,6,0,'3341500520154','2020-08-05'),(196,2563,'3774',17,5,1,'3341500520154','2020-08-05'),(197,2563,'3655',1,7,0,'3341500520154','2020-08-05'),(198,2563,'3656',2,7,0,'3341500520154','2020-08-05'),(199,2563,'3657',3,7,0,'3341500520154','2020-08-05'),(200,2563,'3658',4,7,0,'3341500520154','2020-08-05'),(201,2563,'3659',5,7,0,'3341500520154','2020-08-05'),(202,2563,'3660',6,7,0,'3341500520154','2020-08-05'),(203,2563,'3661',7,7,0,'3341500520154','2020-08-05'),(204,2563,'3662',8,7,0,'3341500520154','2020-08-05'),(205,2563,'3663',9,7,0,'3341500520154','2020-08-05'),(206,2563,'3664',10,7,0,'3341500520154','2020-08-05'),(207,2563,'3665',11,7,0,'3341500520154','2020-08-05'),(208,2563,'3666',12,7,0,'3341500520154','2020-08-05'),(209,2563,'3667',13,7,0,'3341500520154','2020-08-05'),(210,2563,'3668',14,7,0,'3341500520154','2020-08-05'),(211,2563,'3669',15,7,0,'3341500520154','2020-08-05'),(212,2563,'3728',16,7,0,'3341500520154','2020-08-05'),(213,2563,'3741',17,7,0,'3341500520154','2020-08-05'),(214,2563,'3776',13,6,1,'3341500520154','2020-08-05'),(215,2563,'3635',1,8,0,'3341500520154','2020-08-05'),(216,2563,'3636',2,8,0,'3341500520154','2020-08-05'),(217,2563,'3637',3,8,0,'3341500520154','2020-08-05'),(218,2563,'3638',4,8,0,'3341500520154','2020-08-05'),(219,2563,'3640',5,8,0,'3341500520154','2020-08-05'),(220,2563,'3642',6,8,0,'3341500520154','2020-08-05'),(221,2563,'3643',7,8,0,'3341500520154','2020-08-05'),(222,2563,'3644',8,8,0,'3341500520154','2020-08-05'),(223,2563,'3645',9,8,0,'3341500520154','2020-08-05'),(224,2563,'3646',10,8,0,'3341500520154','2020-08-05'),(225,2563,'3648',11,8,0,'3341500520154','2020-08-05'),(226,2563,'3649',12,8,0,'3341500520154','2020-08-05'),(227,2563,'3650',13,8,0,'3341500520154','2020-08-05'),(228,2563,'3651',14,8,0,'3341500520154','2020-08-05'),(229,2563,'3652',15,8,0,'3341500520154','2020-08-05'),(230,2563,'3714',16,8,0,'3341500520154','2020-08-05'),(231,2563,'3742',17,8,0,'3341500520154','2020-08-05'),(232,2563,'3763',18,8,0,'3341500520154','2020-08-05'),(233,2563,'3775',18,7,1,'3341500520154','2020-08-05'),(234,2563,'3768',1,1,1,'3341500520154','2020-08-05'),(235,2563,'13767',3,1,1,'3341500520154','2020-08-05'),(236,2563,'3764',4,1,1,'3341500520154','2020-08-05'),(237,2563,'3772',5,1,1,'3341500520154','2020-08-05'),(238,2563,'3773',6,1,1,'3341500520154','2020-08-05'),(239,2563,'3770',7,1,1,'3341500520154','2020-08-05'),(240,2563,'3771',8,1,1,'3341500520154','2020-08-05'),(241,2563,'3769',9,1,1,'3341500520154','2020-08-05'),(242,2563,'3765',10,1,1,'3341500520154','2020-08-05'),(243,2563,'3766',11,1,1,'3341500520154','2020-08-05'),(244,2563,'3777',2,1,1,'3341500520154','2020-08-05'),(245,2563,'3726',12,4,1,'3341500520154','2020-08-19'),(246,2563,'3767',3,1,1,'3341500520154','2020-08-06'),(248,2563,'3779',7,2,0,'3341500520154','2021-01-15'),(249,2564,'3768',1,2,0,'3341500520154','2021-06-14'),(250,2564,'3777',2,2,0,'3341500520154','2021-06-14'),(251,2564,'3767',3,2,0,'3341500520154','2021-06-14'),(252,2564,'3764',4,2,0,'3341500520154','2021-06-14'),(253,2564,'3772',5,2,0,'3341500520154','2021-06-14'),(254,2564,'3773',6,2,0,'3341500520154','2021-06-14'),(255,2564,'3770',7,2,0,'3341500520154','2021-06-14'),(256,2564,'3771',8,2,0,'3341500520154','2021-06-14'),(257,2564,'3769',9,2,0,'3341500520154','2021-06-14'),(265,2564,'3655',1,8,0,'3341500520154','2021-06-14'),(259,2564,'3766',10,2,0,'3341500520154','2021-06-14'),(260,2564,'3751',1,3,0,'3341500520154','2021-06-14'),(261,2564,'3752',2,3,0,'3341500520154','2021-06-14'),(262,2564,'3756',5,3,0,'3341500520154','2021-11-08'),(263,2564,'3755',4,3,0,'3341500520154','2021-06-14'),(264,2564,'3757',6,3,0,'3341500520154','2021-06-14'),(266,2564,'3656',2,8,0,'3341500520154','2021-06-14'),(267,2564,'3657',3,8,0,'3341500520154','2021-06-14'),(268,2564,'3658',4,8,0,'3341500520154','2021-06-14'),(269,2564,'3659',5,8,0,'3341500520154','2021-06-14'),(270,2564,'3660',6,8,0,'3341500520154','2021-06-14'),(271,2564,'3661',7,8,0,'3341500520154','2021-06-14'),(272,2564,'3662',8,8,0,'3341500520154','2021-06-14'),(273,2564,'3663',9,8,0,'3341500520154','2021-06-14'),(274,2564,'3664',10,8,0,'3341500520154','2021-06-14'),(275,2564,'3665',11,8,0,'3341500520154','2021-06-14'),(276,2564,'3666',12,8,0,'3341500520154','2021-06-14'),(277,2564,'3667',13,8,0,'3341500520154','2021-06-14'),(278,2564,'3668',14,8,0,'3341500520154','2021-06-14'),(279,2564,'3669',15,8,0,'3341500520154','2021-06-14'),(280,2564,'3728',16,8,0,'3341500520154','2021-06-14'),(281,2564,'3741',17,8,0,'3341500520154','2021-06-14'),(282,2564,'3775',18,8,1,'3341500520154','2021-06-14'),(283,2564,'3675',1,7,0,'3341500520154','2021-06-14'),(284,2564,'3676',2,7,0,'3341500520154','2021-06-14'),(285,2564,'3677',3,7,0,'3341500520154','2021-06-14'),(286,2564,'3679',4,7,0,'3341500520154','2021-06-14'),(287,2564,'3680',5,7,0,'3341500520154','2021-06-14'),(288,2564,'3681',6,7,0,'3341500520154','2021-06-14'),(289,2564,'3682',7,7,0,'3341500520154','2021-06-14'),(290,2564,'3683',8,7,0,'3341500520154','2021-06-14'),(291,2564,'3684',9,7,0,'3341500520154','2021-06-14'),(292,2564,'3686',10,7,0,'3341500520154','2021-06-14'),(293,2564,'3687',11,7,0,'3341500520154','2021-06-14'),(294,2564,'3688',12,7,0,'3341500520154','2021-06-14'),(295,2564,'3776',13,7,0,'3341500520154','2021-06-14'),(296,2564,'3774',17,6,0,'3341500520154','2021-06-14'),(297,2564,'3743',16,6,0,'3341500520154','2021-06-14'),(298,2564,'3710',15,6,0,'3341500520154','2021-06-14'),(299,2564,'3709',14,6,0,'3341500520154','2021-06-14'),(300,2564,'3708',13,6,0,'3341500520154','2021-06-14'),(301,2564,'3707',12,6,0,'3341500520154','2021-06-14'),(302,2564,'3706',11,6,0,'3341500520154','2021-06-14'),(303,2564,'3705',10,6,0,'3341500520154','2021-06-14'),(304,2564,'3703',9,6,0,'3341500520154','2021-06-14'),(305,2564,'3702',8,6,0,'3341500520154','2021-06-14'),(306,2564,'3700',7,6,0,'3341500520154','2021-06-14'),(307,2564,'3699',6,6,0,'3341500520154','2021-06-14'),(308,2564,'3698',5,6,0,'3341500520154','2021-06-14'),(309,2564,'3697',4,6,0,'3341500520154','2021-06-14'),(310,2564,'3696',3,6,0,'3341500520154','2021-06-14'),(311,2564,'3695',2,6,0,'3341500520154','2021-06-14'),(312,2564,'3694',1,6,0,'3341500520154','2021-06-14'),(313,2564,'3726',12,5,0,'3341500520154','2021-06-14'),(314,2564,'3739',10,5,0,'3341500520154','2021-06-14'),(315,2564,'3725',9,5,0,'3341500520154','2021-06-14'),(316,2564,'3723',8,5,0,'3341500520154','2021-06-14'),(317,2564,'3722',7,5,0,'3341500520154','2021-06-14'),(318,2564,'3721',6,5,0,'3341500520154','2021-06-14'),(319,2564,'3720',5,5,0,'3341500520154','2021-06-14'),(320,2564,'3719',4,5,0,'3341500520154','2021-06-14'),(321,2564,'3718',3,5,0,'3341500520154','2021-06-14'),(322,2564,'3716',2,5,0,'3341500520154','2021-06-14'),(323,2564,'3715',1,5,0,'3341500520154','2021-06-14'),(324,2564,'3759',13,4,0,'3341500520154','2021-06-14'),(325,2564,'3758',12,4,0,'3341500520154','2021-06-14'),(326,2564,'3750',11,4,0,'3341500520154','2021-06-14'),(327,2564,'3745',10,4,0,'3341500520154','2021-06-14'),(328,2564,'3738',9,4,0,'3341500520154','2021-06-14'),(329,2564,'3737',8,4,0,'3341500520154','2021-06-14'),(330,2564,'3736',7,4,0,'3341500520154','2021-06-14'),(331,2564,'3735',6,4,0,'3341500520154','2021-06-14'),(332,2564,'3734',5,4,0,'3341500520154','2021-06-14'),(333,2564,'3730',1,4,0,'3341500520154','2021-06-14'),(334,2564,'3731',2,4,0,'3341500520154','2021-06-14'),(335,2564,'3732',3,4,0,'3341500520154','2021-06-14'),(336,2564,'3733',4,4,0,'3341500520154','2021-06-14'),(337,2564,'3753',3,3,0,'3341500520154','2021-06-14'),(338,2564,'3782',1,1,0,'3341500520154','2021-06-14'),(339,2564,'3783',2,1,0,'3341500520154','2021-11-08'),(340,2564,'3786',3,1,0,'3341500520154','2021-06-14'),(341,2564,'3785',4,1,0,'3341500520154','2021-06-14'),(342,2564,'3780',5,1,0,'3341500520154','2021-06-14'),(343,2564,'3787',6,1,0,'3341500520154','2021-06-14'),(344,2564,'3781',7,1,0,'3341500520154','2021-06-14'),(345,2564,'3784',8,1,0,'3341500520154','2021-06-14'),(346,2564,'3789',9,1,0,'3341500520154','2021-06-14'),(347,2564,'3788',10,1,0,'3341500520154','2021-06-14'),(348,2564,'3793',11,1,0,'3341500520154','2021-06-14'),(349,2564,'3792',12,1,0,'3341500520154','2021-06-14'),(350,2564,'3791',13,1,0,'3341500520154','2021-06-14'),(355,2564,'3798',15,1,0,'3341501718799','2021-11-16'),(352,2564,'3779',15,1,0,'3341500520154','2021-06-14'),(353,2564,'3794',11,2,0,'3341500520154','2021-06-14'),(354,2564,'3795',14,7,0,'3341500520154','2021-06-14'),(356,2564,'3797',12,2,0,'3341501718799','2021-11-16'),(357,2564,'3799',7,3,0,'3341501718799','2021-11-16'),(358,2564,'3796',8,3,0,'3341501718799','2021-11-16'),(359,2564,'3800',12,5,0,'3341501718799','2021-12-08'),(360,2564,'3801',19,8,0,'3341500520154','2022-02-01'),(361,2565,'3782',1,2,0,'3341500520154','2022-05-26'),(362,2565,'3783',2,2,0,'3341500520154','2022-05-26'),(363,2565,'3786',3,2,0,'3341500520154','2022-05-26'),(364,2565,'3785',4,2,0,'3341500520154','2022-05-26'),(365,2565,'3780',5,2,0,'3341500520154','2022-05-26'),(366,2565,'3787',6,2,0,'3341500520154','2022-05-26'),(367,2565,'3781',7,2,0,'3341500520154','2022-05-26'),(368,2565,'3784',8,2,0,'3341500520154','2022-05-26'),(369,2565,'3789',9,2,0,'3341500520154','2022-05-26'),(370,2565,'3788',10,2,0,'3341500520154','2022-05-26'),(371,2565,'3793',11,2,0,'3341500520154','2022-05-26'),(372,2565,'3792',12,2,0,'3341500520154','2022-05-26'),(481,2565,'3806',7,1,0,'3341500520154','2023-03-28'),(374,2565,'3779',14,2,0,'3341500520154','2022-05-26'),(474,2565,'3777',8,4,0,'3341500520154','2023-03-28'),(472,2565,'3798',12,6,0,'3341500520154','2023-03-28'),(377,2565,'3768',1,3,0,'3341500520154','2022-05-26'),(378,2565,'3767',3,3,0,'3341500520154','2022-05-26'),(379,2565,'3764',4,3,0,'3341500520154','2022-05-26'),(380,2565,'3772',5,3,0,'3341500520154','2022-05-26'),(381,2565,'3773',6,3,0,'3341500520154','2022-05-26'),(382,2565,'3770',7,3,0,'3341500520154','2022-05-26'),(383,2565,'3771',8,3,0,'3341500520154','2022-05-26'),(384,2565,'3769',9,3,0,'3341500520154','2022-05-26'),(385,2565,'3766',10,3,0,'3341500520154','2022-05-26'),(469,2565,'3814',18,7,0,'3341500520154','2023-03-28'),(387,2565,'3751',1,4,0,'3341500520154','2022-05-26'),(388,2565,'3752',2,4,0,'3341500520154','2022-05-26'),(473,2565,'3797',7,4,0,'3341500520154','2023-03-28'),(390,2565,'3755',4,4,0,'3341500520154','2022-05-26'),(391,2565,'3753',3,4,0,'3341500520154','2022-05-26'),(392,2565,'3756',5,4,0,'3341500520154','2022-05-26'),(393,2565,'3757',6,4,0,'3341500520154','2022-05-26'),(394,2565,'3799',7,4,0,'3341500520154','2022-05-26'),(395,2565,'3730',1,5,0,'3341500520154','2022-05-26'),(396,2565,'3731',2,5,0,'3341500520154','2022-05-26'),(397,2565,'3732',3,5,0,'3341500520154','2022-05-26'),(398,2565,'3733',4,5,0,'3341500520154','2022-05-26'),(399,2565,'3736',7,5,0,'3341500520154','2022-05-27'),(400,2565,'3737',8,5,0,'3341500520154','2022-05-27'),(401,2565,'3795',14,8,0,'3341500520154','2022-05-27'),(402,2565,'3776',13,8,0,'3341500520154','2022-05-27'),(403,2565,'3688',12,8,0,'3341500520154','2022-05-27'),(404,2565,'3687',11,8,0,'3341500520154','2022-05-27'),(405,2565,'3686',10,8,0,'3341500520154','2022-05-27'),(406,2565,'3684',9,8,0,'3341500520154','2022-05-27'),(407,2565,'3683',8,8,0,'3341500520154','2022-05-27'),(408,2565,'3682',7,8,0,'3341500520154','2022-05-27'),(409,2565,'3681',6,8,0,'3341500520154','2022-05-27'),(410,2565,'3680',5,8,0,'3341500520154','2022-05-27'),(411,2565,'3679',4,8,0,'3341500520154','2022-05-27'),(412,2565,'3677',3,8,0,'3341500520154','2022-05-27'),(413,2565,'3676',2,8,0,'3341500520154','2022-05-27'),(414,2565,'3675',1,8,0,'3341500520154','2022-05-27'),(415,2565,'3774',17,7,0,'3341500520154','2022-05-27'),(416,2565,'3694',1,7,0,'3341500520154','2022-05-27'),(417,2565,'3695',2,7,0,'3341500520154','2022-05-27'),(418,2565,'3696',3,7,0,'3341500520154','2022-05-27'),(419,2565,'3697',4,7,0,'3341500520154','2022-05-27'),(420,2565,'3698',5,7,0,'3341500520154','2022-05-27'),(421,2565,'3699',6,7,0,'3341500520154','2022-05-27'),(422,2565,'3700',7,7,0,'3341500520154','2022-05-27'),(423,2565,'3702',8,7,0,'3341500520154','2022-05-27'),(424,2565,'3703',9,7,0,'3341500520154','2022-05-27'),(425,2565,'3705',10,7,0,'3341500520154','2023-03-28'),(426,2565,'3706',11,7,0,'3341500520154','2022-05-27'),(427,2565,'3707',12,7,0,'3341500520154','2022-09-28'),(428,2565,'3743',16,7,0,'3341500520154','2022-05-27'),(429,2565,'3710',15,7,0,'3341500520154','2022-05-27'),(430,2565,'3709',14,7,0,'3341500520154','2022-05-27'),(431,2565,'3708',13,7,0,'3341500520154','2022-05-27'),(432,2565,'3800',1,1,0,'3341500520154','2023-03-28'),(433,2565,'3726',11,6,0,'3341500520154','2022-09-13'),(434,2565,'3739',10,6,0,'3341500520154','2022-05-27'),(435,2565,'3725',9,6,0,'3341500520154','2022-05-27'),(475,2565,'3778',11,3,0,'3341500520154','2023-03-28'),(437,2565,'3722',7,6,0,'3341500520154','2022-05-27'),(438,2565,'3721',6,6,0,'3341500520154','2022-05-27'),(439,2565,'3720',5,6,0,'3341500520154','2022-05-27'),(440,2565,'3719',4,6,0,'3341500520154','2022-05-27'),(441,2565,'3718',3,6,0,'3341500520154','2022-05-27'),(442,2565,'3716',2,6,0,'3341500520154','2022-05-27'),(443,2565,'3715',1,6,0,'3341500520154','2022-05-27'),(444,2565,'3759',13,5,0,'3341500520154','2022-05-27'),(445,2565,'3758',12,5,0,'3341500520154','2022-05-27'),(446,2565,'3750',11,5,0,'3341500520154','2022-05-27'),(447,2565,'3745',10,5,0,'3341500520154','2022-05-27'),(448,2565,'3738',9,5,0,'3341500520154','2022-05-27'),(449,2565,'3735',6,5,0,'3341500520154','2022-05-27'),(450,2565,'3790',15,2,0,'3341500520154','2023-03-28'),(451,2565,'3801',2,1,0,'3341500520154','2023-03-28'),(452,2565,'3802',4,1,0,'3341500520154','2023-03-28'),(480,2565,'3804',6,1,0,'3341500520154','2023-03-28'),(479,2565,'3803',5,1,0,'3341500520154','2023-03-28'),(478,2565,'3805',3,1,0,'3341500520154','2023-03-28'),(477,2565,'3808',16,2,0,'3341500520154','2023-03-28'),(476,2565,'3763',2,3,0,'3341500520154','2023-03-28'),(459,2565,'3796',14,2,0,'3341500520154','2023-03-28'),(460,2565,'3734',5,5,0,'3341500520154','2022-09-13'),(461,2565,'3809',17,2,0,'3341500520154','2023-03-28'),(462,2565,'3810',12,3,0,'3341500520154','2022-09-16'),(471,2565,'3811',20,7,0,'3341500520154','2023-03-28'),(470,2565,'3812',19,7,0,'3341500520154','2023-03-28'),(468,2565,'3813',15,8,0,'3341500520154','2023-03-28'),(482,2565,'3807',7,1,0,'3341500520154','2023-03-28'),(483,2566,'3811',20,8,0,'3341500520154','2023-07-13'),(484,2566,'3812',19,8,0,'3341500520154','2023-07-13'),(485,2566,'3814',18,8,0,'3341500520154','2023-07-13'),(486,2566,'3774',17,8,0,'3341500520154','2023-07-13'),(487,2566,'3743',16,8,0,'3341500520154','2023-07-13'),(488,2566,'3710',15,8,0,'3341500520154','2023-07-13'),(489,2566,'3709',14,8,0,'3341500520154','2023-07-13'),(490,2566,'3708',13,8,0,'3341500520154','2023-07-13'),(491,2566,'3707',12,8,0,'3341500520154','2023-07-13'),(492,2566,'3706',11,8,0,'3341500520154','2023-07-13'),(493,2566,'3705',10,8,0,'3341500520154','2023-07-13'),(494,2566,'3703',9,8,0,'3341500520154','2023-07-13'),(495,2566,'3702',8,8,0,'3341500520154','2023-07-13'),(496,2566,'3700',7,8,0,'3341500520154','2023-07-13'),(497,2566,'3699',6,8,0,'3341500520154','2023-07-13'),(498,2566,'3698',5,8,0,'3341500520154','2023-07-13'),(499,2566,'3697',4,8,0,'3341500520154','2023-07-13'),(500,2566,'3696',3,8,0,'3341500520154','2023-07-13'),(501,2566,'3695',2,8,0,'3341500520154','2023-07-13'),(502,2566,'3694',1,8,0,'3341500520154','2023-07-13'),(503,2566,'3798',10,7,0,'3341500520154','2023-07-13'),(504,2566,'3726',11,7,0,'3341500520154','2023-07-13'),(505,2566,'3739',9,7,0,'3341500520154','2023-07-13'),(506,2566,'3725',8,7,0,'3341500520154','2023-07-13'),(507,2566,'3722',7,7,0,'3341500520154','2023-07-13'),(508,2566,'3721',6,7,0,'3341500520154','2023-07-13'),(509,2566,'3720',5,7,0,'3341500520154','2023-07-13'),(510,2566,'3719',4,7,0,'3341500520154','2023-07-13'),(511,2566,'3718',3,7,0,'3341500520154','2023-07-13'),(512,2566,'3716',2,7,0,'3341500520154','2023-07-13'),(513,2566,'3715',1,7,0,'3341500520154','2023-07-13'),(514,2566,'3759',13,6,0,'3341500520154','2023-07-13'),(515,2566,'3758',12,6,0,'3341500520154','2023-07-13'),(516,2566,'3750',11,6,0,'3341500520154','2023-09-19'),(517,2566,'3745',10,6,0,'3341500520154','2023-07-13'),(518,2566,'3738',9,6,0,'3341500520154','2023-07-13'),(519,2566,'3737',8,6,0,'3341500520154','2023-07-13'),(520,2566,'3736',7,6,0,'3341500520154','2023-07-13'),(521,2566,'3735',6,6,0,'3341500520154','2023-07-13'),(522,2566,'3734',5,6,0,'3341500520154','2023-07-13'),(523,2566,'3733',4,6,0,'3341500520154','2023-07-13'),(524,2566,'3732',3,6,0,'3341500520154','2023-07-13'),(525,2566,'3731',2,6,0,'3341500520154','2023-07-13'),(526,2566,'3730',1,6,0,'3341500520154','2023-07-13'),(527,2566,'3777',8,5,0,'3341500520154','2023-07-13'),(528,2566,'3797',7,5,0,'3341500520154','2023-07-13'),(529,2566,'3757',6,5,0,'3341500520154','2023-07-13'),(530,2566,'3756',5,5,0,'3341500520154','2023-07-13'),(531,2566,'3755',4,5,0,'3341500520154','2023-08-04'),(532,2566,'3753',3,5,0,'3341500520154','2023-07-13'),(533,2566,'3752',2,5,0,'3341500520154','2023-07-13'),(534,2566,'3751',1,5,0,'3341500520154','2023-07-13'),(535,2566,'3810',12,4,0,'3341500520154','2023-07-13'),(536,2566,'3778',11,4,0,'3341500520154','2023-07-13'),(537,2566,'3766',10,4,0,'3341500520154','2023-07-13'),(538,2566,'3769',9,4,0,'3341500520154','2023-07-13'),(539,2566,'3771',8,4,0,'3341500520154','2023-07-13'),(540,2566,'3770',7,4,0,'3341500520154','2023-07-13'),(541,2566,'3773',6,4,0,'3341500520154','2023-07-13'),(542,2566,'3772',5,4,0,'3341500520154','2023-07-13'),(543,2566,'3764',4,4,0,'3341500520154','2023-07-13'),(544,2566,'3767',3,4,0,'3341500520154','2023-07-13'),(545,2566,'3763',2,4,0,'3341500520154','2023-07-13'),(546,2566,'3768',1,4,0,'3341500520154','2023-07-13'),(547,2566,'3796',10,3,0,'3341500520154','2024-03-05'),(548,2566,'3792',11,3,0,'3341500520154','2024-03-05'),(549,2566,'3793',9,3,0,'3341500520154','2024-03-05'),(550,2566,'3789',7,3,0,'3341500520154','2024-03-05'),(551,2566,'3781',6,3,0,'3341500520154','2024-03-05'),(552,2566,'3787',5,3,0,'3341500520154','2024-03-05'),(553,2566,'3780',4,3,0,'3341500520154','2024-03-05'),(554,2566,'3785',3,3,0,'3341500520154','2024-03-05'),(555,2566,'3786',2,3,0,'3341500520154','2024-03-05'),(556,2566,'3783',1,3,0,'3341500520154','2024-03-05'),(557,2566,'3807',7,2,0,'3341500520154','2023-07-13'),(558,2566,'3806',7,2,0,'3341500520154','2023-07-13'),(559,2566,'3804',6,2,0,'3341500520154','2023-07-13'),(560,2566,'3803',5,2,0,'3341500520154','2023-07-13'),(561,2566,'3802',4,2,0,'3341500520154','2023-07-13'),(562,2566,'3805',3,2,0,'3341500520154','2023-07-13'),(563,2566,'3801',2,2,0,'3341500520154','2023-07-13'),(564,2566,'3800',1,2,0,'3341500520154','2023-07-13'),(565,2566,'3815',12,7,0,'3341500520154','2023-07-13'),(566,2566,'3816',1,1,0,'3341500520154','2023-07-13'),(567,2566,'3817',2,1,0,'3341500520154','2023-07-13'),(568,2566,'3818',3,1,0,'3341500520154','2023-07-13'),(569,2566,'3819',4,1,0,'3341500520154','2023-07-13'),(570,2566,'3820',5,1,0,'3341500520154','2023-07-13'),(571,2566,'3821',6,1,0,'3341500520154','2023-07-13'),(572,2566,'3822',7,1,0,'3341500520154','2023-07-13'),(573,2566,'3823',8,1,0,'3341500520154','2023-07-13'),(574,2566,'3824',9,1,0,'3341500520154','2023-07-13'),(575,2566,'3788',8,3,0,'3341500520154','2024-03-05'),(576,2567,'3726',11,8,0,'3341500520154','2024-05-16'),(648,2567,'3815',3,2,0,'3341500520154','2024-05-28'),(578,2567,'3798',10,8,0,'3341500520154','2024-05-16'),(579,2567,'3739',9,8,0,'3341500520154','2024-05-16'),(580,2567,'3725',8,8,0,'3341500520154','2024-05-16'),(581,2567,'3722',7,8,0,'3341500520154','2024-05-16'),(582,2567,'3721',6,8,0,'3341500520154','2024-05-16'),(583,2567,'3720',5,8,0,'3341500520154','2024-05-16'),(584,2567,'3719',4,8,0,'3341500520154','2024-05-16'),(585,2567,'3718',3,8,0,'3341500520154','2024-05-16'),(586,2567,'3716',2,8,0,'3341500520154','2024-05-16'),(587,2567,'3715',1,8,0,'3341500520154','2024-05-16'),(588,2567,'3759',13,7,0,'3341500520154','2024-05-16'),(589,2567,'3758',12,7,0,'3341500520154','2024-05-16'),(590,2567,'3750',11,7,0,'3341500520154','2024-05-16'),(591,2567,'3745',10,7,0,'3341500520154','2024-05-16'),(592,2567,'3738',9,7,0,'3341500520154','2024-05-16'),(593,2567,'3737',8,7,0,'3341500520154','2024-05-16'),(594,2567,'3736',7,7,0,'3341500520154','2024-05-16'),(595,2567,'3735',6,7,0,'3341500520154','2024-05-16'),(596,2567,'3734',5,7,0,'3341500520154','2024-05-16'),(666,2568,'3759',12,8,0,'3341500520154','2025-11-07'),(598,2567,'3732',3,7,0,'3341500520154','2024-05-16'),(599,2567,'3731',2,7,0,'3341500520154','2024-05-16'),(600,2567,'3730',1,7,0,'3341500520154','2024-05-16'),(665,2567,'3777',10,5,0,'3341500520154','2024-05-28'),(602,2567,'3797',6,6,0,'3341500520154','2024-05-27'),(603,2567,'3757',5,6,0,'3341500520154','2024-05-27'),(604,2567,'3756',4,6,0,'3341500520154','2024-05-27'),(605,2567,'3755',3,6,0,'3341500520154','2024-05-27'),(606,2567,'3753',2,6,0,'3341500520154','2024-05-27'),(607,2567,'3752',1,6,0,'3341500520154','2024-05-27'),(608,2567,'3810',11,5,0,'3341500520154','2024-05-27'),(664,2567,'3778',7,6,0,'3341500520154','2024-05-28'),(610,2567,'3766',9,5,0,'3341500520154','2024-05-27'),(611,2567,'3769',8,5,0,'3341500520154','2024-05-27'),(612,2567,'3771',7,5,0,'3341500520154','2024-05-27'),(613,2567,'3770',6,5,0,'3341500520154','2024-05-27'),(614,2567,'3773',5,5,0,'3341500520154','2024-05-27'),(615,2567,'3764',4,5,0,'3341500520154','2024-05-16'),(616,2567,'3767',3,5,0,'3341500520154','2024-05-16'),(617,2567,'3763',2,5,0,'3341500520154','2024-05-16'),(618,2567,'3768',1,5,0,'3341500520154','2024-05-16'),(619,2567,'3792',11,4,0,'3341500520154','2024-05-16'),(620,2567,'3796',10,4,0,'3341500520154','2024-05-16'),(621,2567,'3793',9,4,0,'3341500520154','2024-05-16'),(622,2567,'3788',8,4,0,'3341500520154','2024-05-16'),(623,2567,'3789',7,4,0,'3341500520154','2024-05-16'),(624,2567,'3781',6,4,0,'3341500520154','2024-05-16'),(625,2567,'3787',5,4,0,'3341500520154','2024-05-16'),(626,2567,'3780',4,4,0,'3341500520154','2024-05-16'),(627,2567,'3785',3,4,0,'3341500520154','2024-05-16'),(628,2567,'3786',2,4,0,'3341500520154','2024-05-16'),(629,2567,'3783',1,4,0,'3341500520154','2024-05-16'),(630,2567,'3807',8,3,0,'3341500520154','2024-05-27'),(631,2567,'3806',7,3,0,'3341500520154','2024-05-16'),(632,2567,'3804',6,3,0,'3341500520154','2024-05-28'),(633,2567,'3803',5,3,0,'3341500520154','2024-05-16'),(634,2567,'3802',4,3,0,'3341500520154','2024-05-16'),(635,2567,'3805',3,3,0,'3341500520154','2024-05-16'),(636,2567,'3801',2,3,0,'3341500520154','2024-05-16'),(637,2567,'3800',1,3,0,'3341500520154','2024-05-16'),(647,2567,'3824',12,8,0,'3341500520154','2024-05-28'),(639,2567,'3823',9,2,0,'3341500520154','2024-05-28'),(640,2567,'3822',7,2,0,'3341500520154','2024-05-28'),(641,2567,'3821',8,2,0,'3341500520154','2024-05-28'),(642,2567,'3820',6,2,0,'3341500520154','2024-05-28'),(643,2567,'3819',5,2,0,'3341500520154','2024-05-28'),(644,2567,'3818',4,2,0,'3341500520154','2024-05-28'),(645,2567,'3817',2,2,0,'3341500520154','2024-05-16'),(646,2567,'3816',1,2,0,'3341500520154','2024-05-16'),(649,2567,'3836',10,2,0,'3341500520154','2024-05-28'),(650,2567,'3837',11,2,0,'3341500520154','2024-05-28'),(651,2567,'3825',1,1,0,'3341500520154','2024-05-28'),(652,2567,'3826',2,1,0,'3341500520154','2024-05-28'),(653,2567,'3827',3,1,0,'3341500520154','2024-05-28'),(654,2567,'3828',4,1,0,'3341500520154','2024-05-28'),(655,2567,'3829',5,1,0,'3341500520154','2024-05-28'),(656,2567,'3830',6,1,0,'3341500520154','2024-05-28'),(657,2567,'3831',7,1,0,'3341500520154','2024-05-28'),(658,2567,'3832',8,1,0,'3341500520154','2024-05-28'),(659,2567,'3833',9,1,0,'3341500520154','2024-05-28'),(660,2567,'3834',10,1,0,'3341500520154','2024-05-28'),(661,2567,'3835',11,1,0,'3341500520154','2024-06-04'),(662,2567,'3790',12,4,0,'3341500520154','2024-05-28'),(663,2567,'3838',13,4,0,'1342200025586','2024-11-21'),(667,2568,'3758',11,8,0,'3341500520154','2025-11-07'),(668,2568,'3750',10,8,0,'3341500520154','2025-11-07'),(669,2568,'3745',9,8,0,'3341500520154','2025-11-07'),(670,2568,'3738',8,8,0,'3341500520154','2025-11-07'),(671,2568,'3737',7,8,0,'3341500520154','2025-11-07'),(672,2568,'3736',6,8,0,'3341500520154','2025-11-07'),(673,2568,'3735',5,8,0,'3341500520154','2025-11-07'),(674,2568,'3734',4,8,0,'3341500520154','2025-11-07'),(675,2568,'3732',3,8,0,'3341500520154','2025-05-19'),(676,2568,'3731',2,8,0,'3341500520154','2025-05-19'),(677,2568,'3730',1,8,0,'3341500520154','2025-05-19'),(678,2568,'3778',7,7,0,'3341500520154','2025-05-19'),(679,2568,'3797',6,7,0,'3341500520154','2025-05-19'),(680,2568,'3757',5,7,0,'3341500520154','2025-05-19'),(681,2568,'3756',4,7,0,'3341500520154','2025-05-19'),(682,2568,'3755',3,7,0,'3341500520154','2025-05-19'),(683,2568,'3753',2,7,0,'3341500520154','2025-05-19'),(684,2568,'3752',1,7,0,'3341500520154','2025-05-19'),(685,2568,'3810',11,6,0,'3341500520154','2025-05-19'),(686,2568,'3777',10,6,0,'3341500520154','2025-05-19'),(687,2568,'3766',9,6,0,'3341500520154','2025-05-19'),(688,2568,'3769',8,6,0,'3341500520154','2025-05-19'),(689,2568,'3771',7,6,0,'3341500520154','2025-05-19'),(690,2568,'3770',6,6,0,'3341500520154','2025-05-19'),(691,2568,'3773',5,6,0,'3341500520154','2025-05-19'),(692,2568,'3764',4,6,0,'3341500520154','2025-05-19'),(693,2568,'3767',3,6,0,'3341500520154','2025-05-19'),(694,2568,'3763',2,6,0,'3341500520154','2025-05-19'),(695,2568,'3768',1,6,0,'3341500520154','2025-05-19'),(696,2568,'3790',12,5,0,'3341500520154','2025-05-19'),(697,2568,'3792',11,5,0,'3341500520154','2025-05-19'),(698,2568,'3796',10,5,0,'3341500520154','2025-05-19'),(699,2568,'3793',9,5,0,'3341500520154','2025-05-19'),(700,2568,'3788',8,5,0,'3341500520154','2025-05-19'),(702,2568,'3781',6,5,0,'3341500520154','2025-05-19'),(703,2568,'3787',5,5,0,'3341500520154','2025-05-19'),(704,2568,'3780',4,5,0,'3341500520154','2025-05-19'),(705,2568,'3785',3,5,0,'3341500520154','2025-05-19'),(706,2568,'3786',2,5,0,'3341500520154','2025-05-19'),(707,2568,'3783',1,5,0,'3341500520154','2025-05-19'),(708,2568,'3807',8,4,0,'3341500520154','2025-05-19'),(709,2568,'3806',7,4,0,'3341500520154','2025-05-19'),(710,2568,'3804',6,4,0,'3341500520154','2025-05-19'),(711,2568,'3803',5,4,0,'3341500520154','2025-05-19'),(712,2568,'3802',4,4,0,'3341500520154','2025-05-19'),(713,2568,'3805',3,4,0,'3341500520154','2025-05-19'),(714,2568,'3801',2,4,0,'3341500520154','2025-05-19'),(715,2568,'3800',1,4,0,'3341500520154','2025-05-19'),(716,2568,'3836',10,3,0,'3341500520154','2025-05-19'),(717,2568,'3823',9,3,0,'3341500520154','2025-05-19'),(718,2568,'3821',8,3,0,'3341500520154','2025-05-19'),(719,2568,'3822',7,3,0,'3341500520154','2025-05-19'),(720,2568,'3820',6,3,0,'3341500520154','2025-05-19'),(721,2568,'3818',4,3,0,'3341500520154','2025-09-10'),(722,2568,'3815',3,3,0,'3341500520154','2025-05-19'),(723,2568,'3817',2,3,0,'3341500520154','2025-05-19'),(725,2568,'3834',9,2,0,'3341500520154','2025-05-27'),(726,2568,'3833',8,2,0,'3341500520154','2025-05-27'),(727,2568,'3832',7,2,0,'3341500520154','2025-05-27'),(728,2568,'3831',6,2,0,'3341500520154','2025-05-27'),(729,2568,'3829',5,2,0,'3341500520154','2025-05-19'),(730,2568,'3828',4,2,0,'3341500520154','2025-05-19'),(731,2568,'3827',3,2,0,'3341500520154','2025-05-19'),(732,2568,'3826',2,2,0,'3341500520154','2025-05-19'),(733,2568,'3825',1,2,0,'3341500520154','2025-05-19'),(734,2568,'3839',1,1,0,'3341500520154','2025-05-20'),(735,2568,'3840',2,1,0,'3341500520154','2025-05-20'),(736,2568,'3841',3,1,0,'3341500520154','2025-05-20'),(738,2568,'3843',5,1,0,'3341500520154','2025-05-20'),(739,2568,'3844',6,1,0,'3341500520154','2025-05-20'),(740,2568,'3845',7,1,0,'3341500520154','2025-05-20'),(741,2568,'3846',8,1,0,'3341500520154','2025-05-20'),(742,2568,'3847',9,1,0,'3341500520154','2025-05-20'),(743,2568,'3848',10,1,0,'3341500520154','2025-05-20'),(744,2568,'3849',11,1,0,'3341500520154','2025-05-20'),(745,2568,'3850',12,1,0,'1342200025586','2025-05-27'),(746,2568,'3851',10,2,0,'3341500520154','2025-05-27');

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

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

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

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

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

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

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


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

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

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

INSERT INTO `student_main_permission` VALUES (1,'3341500650821',1,'3341500520154','2016-08-02'),(2,'3341500520154',1,'3341500520154','2024-09-16'),(3,'1342200025586',1,'3341500520154','2024-01-29'),(4,'1450600184140',1,'3341500520154','2024-03-29');

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

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

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

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

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

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

INSERT INTO `system_module_admin` VALUES (48,'3341500650821','student_inclass','3341500650821','2016-06-26'),(54,'3341500650821','plan','3341500650821','2016-06-26'),(53,'3341500650821','savings','3341500650821','2016-06-26'),(52,'3341500650821','standard','3341500650821','2016-06-26'),(51,'3341500520154','student_check','3341501718799','2020-08-13'),(49,'3341500650821','student_main','3341500650821','2016-06-26'),(50,'3341500650821','work','3341500650821','2016-06-26'),(62,'3341500520154','book','3341500520154','2018-10-01'),(63,'3341800228874','bookregister','3341500520154','2018-10-01'),(64,'3341501718799','bookregister','3341500520154','2018-10-01'),(22,'3341500520154','bets','7777','2016-06-26'),(23,'3341500520154','bookregister','7777','2016-06-26'),(24,'3341800228874','budget','3341500650821','2016-07-23'),(25,'134220025586','cabinet','7777','2016-06-26'),(26,'3349800025792','delegate','7777','2016-06-26'),(27,'3340400252599','health','7777','2016-06-26'),(28,'3341500520154','la','7777','2016-06-26'),(29,'3341500520154','mail','7777','2016-06-26'),(30,'3341800228874','meeting','7777','2016-06-26'),(31,'3349800025792','permission','7777','2016-06-26'),(32,'3341500392466','person','7777','2016-06-26'),(33,'3341800228874','plan','7777','2016-06-26'),(34,'4341500010537','savings','7777','2016-06-26'),(35,'3349800025792','standard','7777','2016-06-26'),(46,'3341500650821','budget','3341500650821','2016-06-26'),(37,'3341500520154','student_inclass','7777','2016-06-26'),(40,'3341500520154','student_main','7777','2016-06-26'),(39,'3341500392466','work','7777','2016-06-26'),(55,'3341500650821','person','3341500650821','2016-06-26'),(56,'3341500650821','permission','3341500650821','2016-06-26'),(57,'3341500650821','meeting','3341500650821','2016-06-26'),(58,'3341500650821','mail','3341500650821','2016-06-26'),(59,'3341500650821','la','3341500650821','2016-06-26'),(60,'3341500650821','delegate','3341500650821','2016-06-26'),(61,'3341500650821','health','3341500650821','2016-06-26'),(65,'3341500520154','budget','3341501718799','2018-10-02'),(66,'1342200025586','book','3341501718799','2018-12-18'),(67,'1342200025586','achievement','3341501718799','2018-12-18'),(68,'1342200025586','affair','3341501718799','2018-12-18'),(69,'1342200025586','amss_bets','3341501718799','2018-12-18'),(70,'1342200025586','amss_budget','3341501718799','2018-12-18'),(71,'1342200025586','amss_opportunity','3341501718799','2018-12-18'),(72,'1342200025586','amss_mail','3341501718799','2018-12-18'),(73,'1342200025586','bookregister','3341501718799','2018-12-18'),(80,'3341501553595','book','3341501718799','2019-02-12'),(81,'3341501553595','bookregister','3341501718799','2019-02-12');

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

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

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

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

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

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


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

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

INSERT INTO `work_permission` VALUES (8,'3341500551700',1,'3340700420675','2025-08-03'),(7,'3341800228874',1,'3340700420675','2025-08-03'),(3,'3341500520154',1,'3341500650821','2016-06-26'),(6,'3340700420675',1,'3340700420675','2025-08-03'),(9,'3331300239176',1,'3340700420675','2025-08-03');


