-- phpMyAdmin SQL Dump -- version 5.1.1 -- https://www.phpmyadmin.net/ -- -- Host: db -- Generation Time: Mar 22, 2022 at 08:18 AM -- Server version: 10.5.12-MariaDB-1:10.5.12+maria~focal -- PHP Version: 7.4.20 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `admission` -- -- -------------------------------------------------------- -- -- Table structure for table `auth_assignment` -- CREATE TABLE `auth_assignment` ( `item_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `user_id` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `created_at` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `auth_assignment` -- INSERT INTO `auth_assignment` (`item_name`, `user_id`, `created_at`) VALUES ('Accounting Staff', '80', 1647343417), ('Admin', '1', 1626109774), ('CGS Adminstrator', '79', 1647334486), ('Program Staff', '78', 1647333417); -- -------------------------------------------------------- -- -- Table structure for table `auth_item` -- CREATE TABLE `auth_item` ( `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `type` smallint(6) NOT NULL, `description` text COLLATE utf8_unicode_ci DEFAULT NULL, `rule_name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL, `data` blob DEFAULT NULL, `created_at` int(11) DEFAULT NULL, `updated_at` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `auth_item` -- INSERT INTO `auth_item` (`name`, `type`, `description`, `rule_name`, `data`, `created_at`, `updated_at`) VALUES ('Accounting Staff', 1, 'สำหรับ Accounting Staff', NULL, NULL, 1626109774, 1626109774), ('Admin', 1, 'สำหรับการดูแลระบบ', NULL, NULL, 1626109774, 1626109774), ('Applicant', 1, 'สำหรับนักศึกษา', NULL, NULL, 1626109774, 1626109774), ('CGS Adminstrator', 1, 'สำหรับ CGS Adminstrator', NULL, NULL, 1626109774, 1626109774), ('CGS Staff', 1, 'สำหรับ CGS Staff', NULL, NULL, 1626109774, 1626109774), ('Head of Program', 1, 'สำหรับ Head of Program', NULL, NULL, 1626109774, 1626109774), ('Program Staff', 1, 'สำหรับ Program Staff', NULL, NULL, 1626109774, 1626109774); -- -------------------------------------------------------- -- -- Table structure for table `auth_item_child` -- CREATE TABLE `auth_item_child` ( `parent` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `child` varchar(64) COLLATE utf8_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `auth_rule` -- CREATE TABLE `auth_rule` ( `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL, `data` blob DEFAULT NULL, `created_at` int(11) DEFAULT NULL, `updated_at` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -------------------------------------------------------- -- -- Table structure for table `blog` -- CREATE TABLE `blog` ( `id` int(11) NOT NULL, `title` varchar(255) DEFAULT NULL COMMENT 'ชื่อเรื่อง', `content` text DEFAULT NULL COMMENT 'เนื้อหา', `category` int(11) DEFAULT NULL COMMENT 'หมวดหมู่', `tag` varchar(255) DEFAULT NULL COMMENT 'คำค้น', `is_show` int(11) NOT NULL DEFAULT 0, `images` text NOT NULL, `created_by` int(11) DEFAULT NULL COMMENT 'สร้างโดย', `updated_by` int(11) DEFAULT NULL COMMENT 'แก้ไขโดย', `create_at` datetime NOT NULL, `update_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `blog` -- INSERT INTO `blog` (`id`, `title`, `content`, `category`, `tag`, `is_show`, `images`, `created_by`, `updated_by`, `create_at`, `update_at`) VALUES (6, 'Scholarships for High Potential Candidates to Enroll in Doctoral Programs', '
ที่อยู่
บัณฑิตวิทยาลัย
มหาวิทยาลัยวลัยลักษณ์
222 ตำบลไทยบุรี
อำเภมท่าศาลา จังหวัดนครศรีธรรมราช
80160
โทรศัพท์
075476481
โทรสาร
075476480
Facebook
www.facebook.com/gradwalailak
\r\n
\r\n
ติดต่อได้ที่ ศบศ.. ทดสอบ
\r\nติดต่อได้ที่ ศบศ. ทดสอบ พี่ปุ๊ก
', 1, 1, '2021-07-14'), (2, 'ติดต่อเจ้าหน้าที่ได้ทางช่องทางใหนบ้าง', 'สำนักงาน', 0, 0, '2021-07-14'); -- -------------------------------------------------------- -- -- Table structure for table `referees` -- CREATE TABLE `referees` ( `id` int(11) NOT NULL, `student_id` int(11) NOT NULL, `register_id` int(11) DEFAULT NULL, `name` varchar(50) NOT NULL, `family_name` varchar(50) NOT NULL, `surname` varchar(50) NOT NULL, `Institution` varchar(200) NOT NULL, `relationship_applicant` varchar(50) NOT NULL, `address` varchar(200) NOT NULL, `contact_number` varchar(10) NOT NULL, `e_mail` varchar(50) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `referees` -- INSERT INTO `referees` (`id`, `student_id`, `register_id`, `name`, `family_name`, `surname`, `Institution`, `relationship_applicant`, `address`, `contact_number`, `e_mail`, `created_at`, `updated_at`) VALUES (123, 90, NULL, 'Dr. Tanaporn Khamphaya', '-', 'Khamphaya', 'Walailik University, Thailand', 'Proposed Supervisor', 'Walailik University 222 Thaiburi, Tha Sala, Nakhon Si Thammarat, 80160, Thailand', '-', 'tanaporn.kh@wu.ac.th', '2021-09-24 13:32:14', '2021-09-24 13:32:14'), (124, 90, NULL, 'Prof. Udomratana Vattanasit', '-', 'Vattanasit', 'Walailik University, Thailand', '-', 'Walailik University 222 Thaiburi, Tha Sala, Nakhon Si Thammarat, 80160, Thailand', '-', 'udomratana.va@wu.ac.th', '2021-09-24 13:32:14', '2021-09-24 13:32:14'), (125, 91, NULL, 'Dr. Tanaporn Khamphaya', '-', 'Khamphaya', 'Walailik University, Thailand', 'Proposed Supervisor', 'Walailik University 222 Thaiburi, Tha Sala, Nakhon Si Thammarat, 80160, Thailand', '-', 'tanaporn.kh@wu.ac.th', '2021-09-24 13:37:32', '2021-09-24 13:37:32'), (126, 91, NULL, 'Prof. Udomratana Vattanasit', '-', 'Vattanasit', 'Walailik University, Thailand', '-', 'Walailik University 222 Thaiburi, Tha Sala, Nakhon Si Thammarat, 80160, Thailand', '-', 'udomratana.va@wu.ac.th', '2021-09-24 13:37:32', '2021-09-24 13:37:32'), (127, 92, 180, 'Test', '-', 'Test', '-', '-', '-', '-', '-', '2021-09-27 01:35:50', '2021-09-27 01:35:50'), (128, 92, 180, 'Test', '-', 'Test', '-', '-', '-', '-', '-', '2021-09-27 01:35:50', '2021-09-27 01:35:50'), (129, 93, 181, 'mama', '-', 'mama', 'Thailand', '-', '5/36 ม.13 ซอยข้างการไฟฟ้า', '0955265394', '-', '2021-09-27 11:37:51', '2021-09-27 11:37:51'), (130, 93, 181, 'papa', '-', 'papa', '-', '-', '-', '-', '-', '2021-09-27 11:37:51', '2021-09-27 11:37:51'), (131, 94, 182, 'Test ', '-', 'Test', '-', '-', '-', '-', '-', '2021-09-27 13:21:03', '2021-09-27 13:21:03'), (132, 94, 182, 'Test', '-', 'Testing ', '-', '-', '-', '-', '-', '2021-09-27 13:21:03', '2021-09-27 13:21:03'), (133, 98, 186, 'ทดสอบ ทดสอบ', '-', 'thai', '-', '-', '-', '0000000000', 'thitipong.pu@gmail.com', '2021-11-18 05:07:08', '2021-11-18 05:07:08'), (134, 98, 186, 'thai', '-', 'thai', '-', '-', '-', '-', '-', '2021-11-18 05:07:08', '2021-11-18 05:07:08'), (135, 99, 187, 'dsfsdf', '-', 'sdfsdf', '-', '-', '-', '-', '-', '2021-11-22 09:04:38', '2021-11-22 09:04:38'), (136, 99, 187, 'ทดสอบ ทดสอบ', '-', 'ทดสอบ', '-', '-', 'thai', '0000000000', 'tan2022@hotmail.com', '2021-11-22 09:04:38', '2021-11-22 09:04:38'), (137, 100, 188, 'Chanikan Potjamanpong', '-', 'developer', '-', '-', '5/36 หมู่ที่ 13 ซอยข้างการไฟฟ้า', '0955265394', '-', '2022-02-15 06:47:56', '2022-02-15 06:47:56'), (138, 100, 188, 'Chanikan Potjamanpong', '-', 'developer', '-', '-', '5/36 หมู่ที่ 13 ซอยข้างการไฟฟ้า', '0955265394', '-', '2022-02-15 06:47:56', '2022-02-15 06:47:56'), (139, 101, 189, 'Chanikan Potjamanpong', '-', 'developer', '-', '-', '5/36 หมู่ที่ 13 ซอยข้างการไฟฟ้า', '0955265394', '-', '2022-02-15 06:51:12', '2022-02-15 06:51:12'), (140, 101, 189, 'Chanikan Potjamanpong', '-', 'developer', '-', '-', '5/36 หมู่ที่ 13 ซอยข้างการไฟฟ้า', '0955265394', '-', '2022-02-15 06:51:12', '2022-02-15 06:51:12'); -- -------------------------------------------------------- -- -- Table structure for table `register_information` -- CREATE TABLE `register_information` ( `id` int(11) NOT NULL, `student_id` int(10) DEFAULT NULL, `faculty_id` int(5) DEFAULT NULL, `course_id` int(5) DEFAULT NULL, `branch_id` int(5) DEFAULT NULL, `session` int(3) DEFAULT NULL COMMENT '0 = normal, 1= special', `location_id` int(3) DEFAULT NULL, `school_year_id` int(3) DEFAULT NULL, `learn_plan_id` int(1) NOT NULL, `payment_status` int(1) NOT NULL DEFAULT 2, `register_status` int(1) NOT NULL DEFAULT 1, `proposed` varchar(500) DEFAULT NULL, `advisor` varchar(500) DEFAULT NULL, `status` int(11) NOT NULL DEFAULT 1, `update_at` datetime DEFAULT NULL, `create_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `register_information` -- INSERT INTO `register_information` (`id`, `student_id`, `faculty_id`, `course_id`, `branch_id`, `session`, `location_id`, `school_year_id`, `learn_plan_id`, `payment_status`, `register_status`, `proposed`, `advisor`, `status`, `update_at`, `create_at`) VALUES (180, 92, 16, 27, 0, 0, 1, 1, 4, 2, 1, '', '', 1, '2021-09-27 01:35:50', '2021-09-27 01:35:50'), (181, 93, 17, 36, 0, 0, 1, 1, 1, 2, 1, '', '', 1, '2021-09-27 11:37:51', '2021-09-27 11:37:51'), (182, 94, 3, 34, 0, 0, 1, 1, 1, 2, 1, 'Test', '', 1, '2021-09-27 13:21:02', '2021-09-27 13:21:02'), (186, 98, 17, 36, 0, 0, 1, 1, 1, 2, 1, '', '', 1, '2021-11-18 05:07:08', '2021-11-18 05:07:08'), (187, 99, 17, 36, 0, 0, 1, 1, 1, 2, 1, '', '', 1, '2021-11-22 09:04:38', '2021-11-22 09:04:38'), (188, 100, 17, 36, 0, 0, 1, 1, 1, 2, 1, 'test', '-', 1, '2022-02-15 06:47:56', '2022-02-15 06:47:56'), (189, 101, 17, 36, 0, 0, 1, 1, 1, 2, 1, 'rtest', 'dev', 1, '2022-02-15 06:51:12', '2022-02-15 06:51:12'); -- -------------------------------------------------------- -- -- Table structure for table `register_status` -- CREATE TABLE `register_status` ( `id` int(11) NOT NULL, `name` varchar(200) DEFAULT NULL, `name_en` text DEFAULT NULL, `is_enable` int(1) DEFAULT 0, `create_at` datetime DEFAULT NULL, `update_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `register_status` -- INSERT INTO `register_status` (`id`, `name`, `name_en`, `is_enable`, `create_at`, `update_at`) VALUES (1, 'ตรวจสอบใบสมัครแล้ว', 'Application Checked', 1, '2020-06-01 11:29:30', '2020-06-01 11:29:30'), (2, 'ชำระเงินแล้ว', 'Paid', 1, '2020-06-01 11:29:30', '2020-06-01 11:29:30'), (3, 'ตรวจสอบเอกสารประกอบแล้ว', 'Supportive Documents - Checked', 1, '2021-09-27 10:52:00', '2021-09-27 10:52:00'), (4, 'ตรวจสอบคุณสมบัติผู้สมัครแล้ว', 'Eligibility Checked', 1, '2021-09-27 10:52:00', '2021-09-27 10:52:00'), (5, 'สอบคัดเลือก', 'Selection Process', 1, '2021-09-27 10:52:31', '2021-09-27 10:52:31'), (6, 'การสมัครเสร็จสมบูรณ์', 'Completed', 1, '2021-09-27 10:52:31', '2021-09-27 10:52:31'); -- -------------------------------------------------------- -- -- Table structure for table `research_experiences` -- CREATE TABLE `research_experiences` ( `id` int(11) NOT NULL, `student_id` int(11) NOT NULL, `register_id` int(11) DEFAULT NULL, `project_title` varchar(200) NOT NULL, `start_date` varchar(100) NOT NULL, `supporter` varchar(200) NOT NULL, `project_coordinator` varchar(200) NOT NULL, `duties_project` varchar(200) NOT NULL, `research_paper` varchar(200) NOT NULL, `project_duration` varchar(100) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `research_experiences` -- INSERT INTO `research_experiences` (`id`, `student_id`, `register_id`, `project_title`, `start_date`, `supporter`, `project_coordinator`, `duties_project`, `research_paper`, `project_duration`, `created_at`, `updated_at`) VALUES (18, 93, 181, 'test', '2020', 'tester', 'tester', '-', '-', '1', '2021-09-27 11:37:51', '2021-09-27 11:37:51'); -- -------------------------------------------------------- -- -- Table structure for table `role_verify_topic` -- CREATE TABLE `role_verify_topic` ( `id` int(11) NOT NULL, `role_name` varchar(64) NOT NULL, `verify_topic_id` int(11) NOT NULL, `created_at` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `role_verify_topic` -- INSERT INTO `role_verify_topic` (`id`, `role_name`, `verify_topic_id`, `created_at`) VALUES (1, 'Program Staff', 1, '2022-03-01'), (2, 'Program Staff', 3, '2022-03-01'), (3, 'Program Staff', 4, '2022-03-01'), (4, 'Program Staff', 5, '2022-03-01'), (5, 'Program Staff', 6, '2022-03-01'), (6, 'Accounting Staff', 2, '2022-03-01'), (7, 'CGS Staff', 1, '2022-03-01'), (8, 'CGS Staff', 3, '2022-03-01'), (9, 'CGS Staff', 4, '2022-03-01'), (10, 'CGS Staff', 5, '2022-03-01'), (11, 'CGS Staff', 6, '2022-03-01'), (12, 'CGS Staff', 2, '2022-03-01'); -- -------------------------------------------------------- -- -- Table structure for table `school_year` -- CREATE TABLE `school_year` ( `id` int(11) NOT NULL, `year` varchar(10) DEFAULT NULL, `open_register` varchar(10) DEFAULT NULL, `close_register` varchar(10) DEFAULT NULL, `is_enable` int(1) DEFAULT 0, `create_at` datetime DEFAULT NULL, `update_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `school_year` -- INSERT INTO `school_year` (`id`, `year`, `open_register`, `close_register`, `is_enable`, `create_at`, `update_at`) VALUES (1, '1/2021', '2021-01-01', '2021-06-30', 1, '2020-03-08 04:13:19', '2021-02-09 05:48:19'), (2, '2/2020', '2020-06-11', '2020-06-20', 0, '2020-03-08 04:13:38', '2021-02-09 04:39:11'), (3, '3/2020', '2020-06-21', '2020-06-30', 0, '2020-03-08 04:13:38', '2021-02-09 04:40:33'), (4, '3/2021', '2021-01-01', '2021-07-31', 1, '2020-06-21 14:50:01', '2021-02-09 05:48:35'), (5, '2/2021', '2021-01-01', '2021-08-31', 1, '2020-08-02 08:39:45', '2021-02-09 05:48:56'), (6, '3/2020', '2020-08-02', '2020-08-14', 0, '2020-08-02 08:39:59', '2021-02-09 04:38:39'), (7, '1/2020', '2020-08-18', '2020-08-19', 0, '2020-08-07 02:56:14', '2020-08-07 02:56:14'); -- -------------------------------------------------------- -- -- Table structure for table `setting` -- CREATE TABLE `setting` ( `id` int(11) NOT NULL, `name` text NOT NULL, `value` text NOT NULL, `created_at` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `setting` -- INSERT INTO `setting` (`id`, `name`, `value`, `created_at`) VALUES (1, 'home-page', 'Graduate Admission is Now Open For All Year Round (Academic Year 2022)', '2022-03-01'), (2, 'sub-home-page', 'Now – December 2022', '2022-03-01'); -- -------------------------------------------------------- -- -- Table structure for table `student_account` -- CREATE TABLE `student_account` ( `id` int(11) NOT NULL, `username` varchar(50) NOT NULL, `password` varchar(50) NOT NULL, `faculty_lv_0` int(11) NOT NULL, `faculty_lv_1` int(11) NOT NULL, `created_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `student_account` -- INSERT INTO `student_account` (`id`, `username`, `password`, `faculty_lv_0`, `faculty_lv_1`, `created_at`) VALUES (92, 'Somruethai.bo@mail.wu.ac.th', '123456', 16, 0, '2021-09-27 01:35:49'), (93, 'tan2022@hotmail.com', '121212', 17, 0, '2021-09-27 11:37:50'), (94, 'Test1234', 'qwer1234', 3, 0, '2021-09-27 13:21:02'), (98, 'developer02@gmail.com', 'developer02@gmail.com', 17, 0, '2021-11-18 05:07:08'), (99, 'developerasdasd02@gmail.com', 'developerasdasd02@gmail.com', 17, 0, '2021-11-22 09:04:38'), (100, 'developer2@22@gmail.com', 'developer2@22@gmail.com', 17, 0, '2022-02-15 06:47:55'), (101, 'developer2@221@gmail.com', 'developer2@221@gmail.com', 17, 0, '2022-02-15 06:51:11'); -- -------------------------------------------------------- -- -- Table structure for table `test_type` -- CREATE TABLE `test_type` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `condition_lv_1` varchar(255) NOT NULL, `condition_lv_2` varchar(255) NOT NULL, `create_at` datetime NOT NULL, `update_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `test_type` -- INSERT INTO `test_type` (`id`, `name`, `condition_lv_1`, `condition_lv_2`, `create_at`, `update_at`) VALUES (1, 'TOEFL ITP', 'minimum score 400', 'minimum score 450', '2021-08-02 09:57:13', '2021-08-02 09:57:13'), (2, 'TOEFL PBT', '-', '-', '2021-08-02 09:57:13', '2021-08-02 09:57:13'), (5, 'TOEFL CBT', 'minimum score 97', 'minimum score 153', '2021-08-02 09:58:17', '2021-08-02 09:58:17'), (6, 'TOEFL IBT', 'minimum score 32', 'minimum score 41', '2021-08-02 09:58:17', '2021-08-02 09:58:17'), (7, 'IELTS (Academic test only)', 'minimum score 5.4', 'minimum score 4.5', '2021-08-02 09:58:17', '2021-08-02 09:58:17'), (8, 'CU-TEP', '-', 'minimum score 35', '2021-08-02 09:58:17', '2021-08-02 09:58:17'), (9, 'WU-TEP', 'minimum score 54', 'minimum score 63', '2021-08-02 09:58:17', '2021-08-02 09:58:17'), (10, 'CEFR', 'B1', 'B1', '2021-08-02 09:58:17', '2021-08-02 09:58:17'); -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE `user` ( `id` int(11) NOT NULL, `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `auth_key` varchar(32) COLLATE utf8_unicode_ci NOT NULL, `password_hash` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `password_reset_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `role_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Applicant', `student_id` int(11) NOT NULL DEFAULT 0, `status` smallint(6) NOT NULL DEFAULT 10, `faculty_lv_0` int(11) NOT NULL DEFAULT 0, `faculty_lv_1` int(11) NOT NULL DEFAULT 0, `created_at` int(11) NOT NULL, `updated_at` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; -- -- Dumping data for table `user` -- INSERT INTO `user` (`id`, `username`, `auth_key`, `password_hash`, `password_reset_token`, `email`, `role_name`, `student_id`, `status`, `faculty_lv_0`, `faculty_lv_1`, `created_at`, `updated_at`) VALUES (1, 'admin', 'ESwfvDU67iA6-bZdjAFaoPWD3m8-jluT', '$2y$13$m4LEYVPS7u5T.D8Ytzb0AuMYQ7TJh1Ni7vnTBPCPYDpFvvItJIqTG', NULL, 'admin@gmail.com', 'Admin', 0, 10, 0, 0, 1626109923, 1626109923), (68, 'Somruethai.bo@mail.wu.ac.th', 'A-rb4jgTOBy-ynK1b3cGQSFm_b2V-D-O', '$2y$13$Yat8ofVE60/5IhgRQXiU8OfUbQPPvfo8ui31ssg8xYzWTeYmdTi/W', NULL, 'Somruethai.bo@mail.wu.ac.th', 'Applicant', 92, 10, 16, 0, 1632706550, 1632706550), (69, 'tan2022@hotmail.com', 'BLloDwvUFOYMDEhLivwyGfuilvARl7DY', '$2y$13$W/IQvC9xnxMBcydwp.tSZ.3EVNVx3O25qXI95IwHKn6oMgLrCPYdu', NULL, 'tan2022@hotmail.com', 'Applicant', 93, 10, 17, 0, 1632742671, 1643302727), (70, 'Test1234', '6UIzPzrOfWbAFqjafOBWYAHsa5lsZMqB', '$2y$13$GQmY61WeZHbWgUPuTwsGleSO/GUh9PIYaAnqJRbAvbtkdDrZwEQ/K', NULL, 'Test1234', 'Applicant', 94, 10, 3, 0, 1632748862, 1632748862), (74, 'developer02@gmail.com', 'bu4xf3EXU2JaFhyIQCcth1zzTbEeUGIb', '$2y$13$zigwEZQ7PDpRoUf7bY.QnuxRgdD1vt80fmGGQfv/y7CMH9v5jF48i', NULL, 'developer02@gmail.com', 'Applicant', 98, 10, 17, 0, 1637212028, 1637212028), (75, 'developerasdasd02@gmail.com', 'k1z7ME8Sf5EjDo8ogaPsz1PLSw4p7rRl', '$2y$13$VtmvxjDogACTQupYS691WulOxKtxhX6jBpC9PUSNadAmyFZTmDDm6', NULL, 'developerasdasd02@gmail.com', 'Applicant', 99, 10, 17, 0, 1637571878, 1637571878), (76, 'developer2@22@gmail.com', 'JPbOAL7nGUvdah_DBLu_qO_cc9FLzPWT', '$2y$13$GVu/bBdY8OvUcdl8Y3Uo5edbEH8PmVwaAlOO63tMs0nzLIoRHzDBy', NULL, 'developer2@22@gmail.com', 'Applicant', 100, 10, 17, 0, 1644907676, 1644907676), (77, 'developer2@221@gmail.com', 'VkdzYIL3qovr7Bn_EhlKDFFWtE6O4D8q', '$2y$13$xs7Zn9HGZkP8EWXf.asnSuPJhAU4rWzMTMtZGBxAjeJAmdlNgGUPu', NULL, 'developer2@221@gmail.com', 'Applicant', 101, 10, 17, 0, 1644907872, 1644907872), (78, 'staff01@mail.com', 'KR_k_7vews3Dx1KPnDNwmiFn3aLyfxdj', '$2y$13$cE7Q.28Vs/5Nw2OAJszav.nup8SOpaHJFAxKdzYaYOV3/JjCLqLKm', NULL, 'staff01@mail.com', 'Program Staff', 0, 10, 0, 0, 1647333417, 1647347294), (79, 'admin02@mail.com', 'hpD40g0FBg3uTfobwVlS-48lab95PpTb', '$2y$13$zS6dl8LAJ9ly4CmYzQEGJe7HHehBTOlx9OhKxiBnC/AWlnnmuBuCi', NULL, 'admin02@mail.com', 'CGS Adminstrator', 0, 0, 0, 0, 1647334485, 1647334515), (80, 'hospital01@hotmail.com', 's6wfM6fLzrtffqHnynkgK_jEjSNc0-Sj', '$2y$13$Lq.qvy01u6kF0sp5WHePGe3hamCQlECYeA7kepYgs9ROsu.bAD0l6', NULL, 'hospital01@hotmail.com', 'Accounting Staff', 0, 10, 0, 0, 1647343417, 1647343417); -- -------------------------------------------------------- -- -- Table structure for table `user_address` -- CREATE TABLE `user_address` ( `id` int(11) NOT NULL, `student_id` int(11) NOT NULL, `register_id` int(11) DEFAULT NULL, `addr_line_1` varchar(100) DEFAULT NULL, `addr_line_2` varchar(100) DEFAULT NULL, `country` varchar(50) DEFAULT NULL, `province` varchar(50) DEFAULT NULL, `city` varchar(50) DEFAULT NULL, `postalcode` varchar(10) DEFAULT NULL, `addr_type` int(1) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `user_address` -- INSERT INTO `user_address` (`id`, `student_id`, `register_id`, `addr_line_1`, `addr_line_2`, `country`, `province`, `city`, `postalcode`, `addr_type`, `created_at`, `updated_at`) VALUES (116, 76, NULL, '123 ม.13 ซอยข้างการไฟฟ้า', 'ท่าศาลา', 'Thailand', 'นครศรีธรรมราช', 'ท่าศาลา', '80160', 0, '2021-09-19 06:13:57', '2021-09-19 06:13:57'), (117, 76, NULL, '123 ม.13 ซอยข้างการไฟฟ้า', 'ท่าศาลา', 'Thailand', 'นครศรีธรรมราช', 'ท่าศาลา', '80160', 1, '2021-09-19 06:13:57', '2021-09-19 06:13:57'), (140, 88, NULL, '5/36 ม.13 ซอยข้างการไฟฟ้า', '-', 'Thailand', 'นครศรีธรรมราช', 'ท่าศาลา', '80160', 0, '2021-09-24 06:45:00', '2021-09-24 06:45:00'), (141, 88, NULL, '5/36 ม.13 ซอยข้างการไฟฟ้า', '-', 'Thailand', 'นครศรีธรรมราช', 'ท่าศาลา', '80160', 1, '2021-09-24 06:45:00', '2021-09-24 06:45:00'), (142, 89, NULL, '5/36 ม.13 ซอยข้างการไฟฟ้า', 'ท่าศาลา', 'Thailand', 'นครศรีธรรมราช', 'ท่าศาลา', '80160', 0, '2021-09-24 06:50:02', '2021-09-24 06:50:02'), (143, 89, NULL, '5/36 ม.13 ซอยข้างการไฟฟ้า', 'ท่าศาลา', 'Thailand', 'นครศรีธรรมราช', 'ท่าศาลา', '80160', 1, '2021-09-24 06:50:02', '2021-09-24 06:50:02'), (148, 92, 180, '1904/1', '-', 'Thailand', 'NST', 'NST', '80000', 0, '2021-09-27 01:35:50', '2021-09-27 01:35:50'), (149, 92, 180, '1904/1', '-', 'Thailand', 'NST', 'NST', '80000', 1, '2021-09-27 01:35:50', '2021-09-27 01:35:50'), (150, 93, 181, '5/36 ม.13 ซอยข้างการไฟฟ้า', 'ท่าศาลา', 'Thailand', 'นครศรีธรรมราช', 'ท่าศาลา', '80160', 0, '2021-09-27 11:37:51', '2021-09-27 11:37:51'), (151, 93, 181, '5/36 ม.13 ซอยข้างการไฟฟ้า', 'ท่าศาลา', 'Thailand', 'นครศรีธรรมราช', 'ท่าศาลา', '80160', 1, '2021-09-27 11:37:51', '2021-09-27 11:37:51'), (152, 94, 182, '-', '-', 'Japan', 'Okinawa', 'Okinawa', '12345', 0, '2021-09-27 13:21:02', '2021-09-27 13:21:02'), (153, 94, 182, '-', '-', 'Japan', 'Okinawa', 'Okinawa', '12345', 1, '2021-09-27 13:21:02', '2021-09-27 13:21:02'), (154, 95, NULL, 'Unit 53, Block c28a, phase 6,Parand', '-', 'Iran', 'Tehran', 'Tehran', '3763944123', 0, '2021-09-27 17:48:48', '2021-09-27 17:48:48'), (155, 95, NULL, 'Unit 53, Block c28a, phase 6,Parand', '-', 'Iran', 'Tehran', 'Tehran', '3763944123', 1, '2021-09-27 17:48:48', '2021-09-27 17:48:48'), (156, 96, NULL, 'Unit 53, Block c28a, phase 6,Parand', '-', 'Iran', 'Tehran', 'Tehran', '3763944123', 0, '2021-09-27 17:55:14', '2021-09-27 17:55:14'), (157, 96, NULL, 'Unit 53, Block c28a, phase 6,Parand', '-', 'Iran', 'Tehran', 'Tehran', '3763944123', 1, '2021-09-27 17:55:14', '2021-09-27 17:55:14'), (158, 97, NULL, 'Unit 53, Block c28a, phase 6,Parand', '-', 'Iran', 'Tehran', 'Tehran', '3763944123', 0, '2021-09-27 17:58:26', '2021-09-27 17:58:26'), (159, 97, NULL, 'Unit 53, Block c28a, phase 6,Parand', '-', 'Iran', 'Tehran', 'Tehran', '3763944123', 1, '2021-09-27 17:58:26', '2021-09-27 17:58:26'), (160, 98, 186, 'thai', 'thai', 'thai', 'thai', 'thai', '80160', 0, '2021-11-18 05:07:08', '2021-11-18 05:07:08'), (161, 98, 186, 'thai', 'thai', 'thai', 'thai', 'thai', '80160', 1, '2021-11-18 05:07:08', '2021-11-18 05:07:08'), (162, 99, 187, 'thai', 'thai', 'Afghanistan', 'ทดสอบ', 'thai', '80160', 0, '2021-11-22 09:04:38', '2021-11-22 09:04:38'), (163, 99, 187, 'thai', 'thai', 'Afghanistan', 'ทดสอบ', 'thai', '80160', 1, '2021-11-22 09:04:38', '2021-11-22 09:04:38'), (164, 100, 188, '5/36 หมู่ที่ 13 ซอยข้างการไฟฟ้า', 'ท่าศาลา', 'Thailand', 'นครศรีธรรมราช', 'ท่าศาลา', '80160', 0, '2022-02-15 06:47:56', '2022-02-15 06:47:56'), (165, 100, 188, '5/36 หมู่ที่ 13 ซอยข้างการไฟฟ้า', 'ท่าศาลา', 'Thailand', 'นครศรีธรรมราช', 'ท่าศาลา', '80160', 1, '2022-02-15 06:47:56', '2022-02-15 06:47:56'), (166, 101, 189, '5/36 หมู่ที่ 13 ซอยข้างการไฟฟ้า', 'ท่าศาลา', 'Thailand', 'นครศรีธรรมราช', 'ท่าศาลา', '80160', 0, '2022-02-15 06:51:12', '2022-02-15 06:51:12'), (167, 101, 189, '5/36 หมู่ที่ 13 ซอยข้างการไฟฟ้า', 'ท่าศาลา', 'Thailand', 'นครศรีธรรมราช', 'ท่าศาลา', '80160', 1, '2022-02-15 06:51:12', '2022-02-15 06:51:12'); -- -------------------------------------------------------- -- -- Table structure for table `user_file` -- CREATE TABLE `user_file` ( `id` int(11) NOT NULL, `student_id` int(11) NOT NULL, `register_id` int(11) DEFAULT NULL, `certif_master` text DEFAULT NULL, `certif_master_c` text DEFAULT NULL, `certif_bachelor_grad` text DEFAULT NULL, `certif_bachelor_grad_c` text DEFAULT NULL, `certif_master_grad` text DEFAULT NULL, `certif_master_grad_c` text DEFAULT NULL, `toefl_ielts_score` text DEFAULT NULL, `toefl_ielts_score_c` text DEFAULT NULL, `passport_national_id` text DEFAULT NULL, `passport_national_id_c` text DEFAULT NULL, `affiliation` text DEFAULT NULL, `affiliation_c` text DEFAULT NULL, `awards` text DEFAULT NULL, `awards_c` text DEFAULT NULL, `payment` text DEFAULT NULL, `payment_c` text DEFAULT NULL, `create_at` datetime DEFAULT NULL, `update_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `user_file` -- INSERT INTO `user_file` (`id`, `student_id`, `register_id`, `certif_master`, `certif_master_c`, `certif_bachelor_grad`, `certif_bachelor_grad_c`, `certif_master_grad`, `certif_master_grad_c`, `toefl_ielts_score`, `toefl_ielts_score_c`, `passport_national_id`, `passport_national_id_c`, `affiliation`, `affiliation_c`, `awards`, `awards_c`, `payment`, `payment_c`, `create_at`, `update_at`) VALUES (48, 92, 180, 'A71F00DB-5CC4-4825-9E16-3F09D9C76A59.jpeg', '46822a9b767fdcc57285ebdd09721fc6.jpeg', '4ADD5E15-8BB9-49B9-8FAF-7470BEED3ADD.jpeg', 'effb83a0bc4bb09f799bf4a517261dd6.jpeg', NULL, NULL, NULL, NULL, '06998681-D54D-4F3E-B899-7AFB3988A86E.jpeg', 'e68508b231cf5f632aec6fbfb85a5dd3.jpeg', NULL, NULL, NULL, NULL, NULL, NULL, '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (49, 93, 181, 'DDProperty2021-08-30 (1) (1).xlsx', 'd3b9548d6a41bf80fa0f59fd44ef8de8.xlsx', 'DDProperty2021-08-30 (1) (1).xlsx', 'd3b9548d6a41bf80fa0f59fd44ef8de8.xlsx', NULL, NULL, NULL, NULL, 'DDProperty2021-08-30 (1) (1).xlsx', 'd3b9548d6a41bf80fa0f59fd44ef8de8.xlsx', NULL, NULL, NULL, NULL, NULL, NULL, '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (50, 94, 182, '1BE00202-6B09-4F03-8494-B50CC59ECD16.jpeg', '5c6ed1ab672c0219775294293f561584.jpeg', 'C3BC8BE3-6395-4047-835C-9A77EB44EF48.jpeg', '1c34ea4ce6ab26322b0b9463bccb752f.jpeg', NULL, NULL, NULL, NULL, '8471A818-3540-41E8-8D04-B7B1852870AD.jpeg', '3eed1e82506aeefc7cd200b3fb8e8879.jpeg', NULL, NULL, NULL, NULL, NULL, NULL, '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (51, 98, 186, 'Transcript.pdf', 'd11cd28bb1f78e1c0dc0a35e4e070b38.pdf', 'Certificate.pdf', 'a5c79278a20f7911df9ad5ff31b96089.pdf', NULL, NULL, NULL, NULL, 'Transcript.pdf', 'e34bc6f57120532a0e417123ad4f74a2.pdf', NULL, NULL, NULL, NULL, NULL, NULL, '2021-11-18 00:00:00', '2021-11-18 00:00:00'), (52, 99, 187, 'Back office - Somruethai.pdf', '8a4bd080f9737ea248beba6a43e2ca86.pdf', 'Back office - Somruethai.pdf', '7bbff273619910341fa68b41eae935a9.pdf', NULL, NULL, NULL, NULL, 'Back office - Somruethai.pdf', '7bbff273619910341fa68b41eae935a9.pdf', NULL, NULL, NULL, NULL, NULL, NULL, '2021-11-22 00:00:00', '2021-11-22 00:00:00'), (53, 100, 188, 'Server-Hosting (1).docx', 'e126339937d43909c0d412e5c38cf26f.docx', 'Server-Hosting (1).docx', 'e126339937d43909c0d412e5c38cf26f.docx', '-', '-', '-', '-', 'Server-Hosting (1).docx', 'e126339937d43909c0d412e5c38cf26f.docx', '-', '-', '-', '-', '-', '-', '2022-02-15 00:00:00', '2022-02-15 00:00:00'), (54, 101, 189, 'PO.jpg', '598dd85dcb0c7ce23defbe0d22d6585d.jpg', 'Server-Hosting (1).docx', '5df6e93ff1469ba719db96c510ac0b4d.docx', '-', '-', 'Server-Hosting (1).docx', 'b27e447a9b17a9809e92db1cbbdf65ba.docx', 'Server-Hosting (1).docx', '5df6e93ff1469ba719db96c510ac0b4d.docx', 'HaishengHu_Application_compressed (1).pdf', '3bf7c6b576c7d61ecfc07cf73b065e90.pdf', '-', '-', 'Server-Hosting (1) - Copy.docx', '46412b28ade2392c802e60cd46a8e5a1.docx', '2022-02-15 00:00:00', '2022-02-15 00:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `user_information` -- CREATE TABLE `user_information` ( `id` int(11) NOT NULL, `student_id` int(10) DEFAULT NULL, `register_id` int(11) DEFAULT NULL, `name_title` varchar(100) DEFAULT NULL, `firstname` varchar(100) DEFAULT NULL, `midname` varchar(1000) DEFAULT NULL, `lastname` varchar(100) DEFAULT NULL, `sex` varchar(10) DEFAULT NULL, `birthday` timestamp NULL DEFAULT NULL, `age` int(5) DEFAULT NULL, `nationality` varchar(20) DEFAULT NULL, `country` varchar(20) DEFAULT NULL, `religion` varchar(20) DEFAULT NULL, `personal_id` varchar(50) DEFAULT NULL, `passport_id` varchar(50) DEFAULT NULL, `mobile_number` varchar(50) DEFAULT NULL, `email` varchar(100) DEFAULT NULL, `create_at` datetime DEFAULT NULL, `update_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `user_information` -- INSERT INTO `user_information` (`id`, `student_id`, `register_id`, `name_title`, `firstname`, `midname`, `lastname`, `sex`, `birthday`, `age`, `nationality`, `country`, `religion`, `personal_id`, `passport_id`, `mobile_number`, `email`, `create_at`, `update_at`) VALUES (102, 76, NULL, 'Mrs.', 'Thitipong', NULL, 'Purinsuwan', 'male', '1991-09-17 17:00:00', 30, 'thai', 'Thailand', 'thai', '1200000000', '-', '0955265394', 'tan2022@hotmail.com', '2021-09-19 06:13:57', '2021-09-19 06:13:57'), (103, 88, NULL, 'Mrs.', 'thitipong', NULL, 'purinsuwan', 'male', '2001-09-05 17:00:00', 20, 'thai', 'Thailand', 'thai', '1200000000', '-', '0955265394', 'tan2022@hotmail.com', '2021-09-24 06:45:00', '2021-09-24 06:45:00'), (104, 89, NULL, 'Mrs.', 'ธิติพงศ์', NULL, 'ปุรินสุวรรณ', 'male', '2021-09-08 17:00:00', 0, 'thai', 'Thailand', 'thai', '1200000000', '-', '0955265394', 'usertest.ui@mail.com', '2021-09-24 06:50:02', '2021-09-24 06:50:02'), (107, 92, 180, 'Mrs.', 'Somruethai', NULL, 'Bouyam', 'female', '1985-02-26 17:00:00', 36, 'Thai', 'Thailand', 'Buddhist', '1809900055200', '-', '0899719024', 'somruethai.bo@mail.wu.ac.th', '2021-09-27 01:35:50', '2021-09-27 01:35:50'), (108, 93, 181, 'Mrs.', 'UserTest', NULL, 'Thitipong', 'male', '1996-09-05 17:00:00', 25, 'thai', 'Thailand', 'thai', '1200000000', '-', '0955265394', 'tan2022@hotmail.com', '2021-09-27 11:37:51', '2021-09-27 11:37:51'), (109, 94, 182, 'Mr.', 'Test', NULL, 'Test', 'male', '2021-09-26 17:00:00', NULL, 'Japan', 'Japan', 'Yes', '12345678910', '-', '-', 'test@hmail.com', '2021-09-27 13:21:02', '2021-09-27 13:21:02'), (110, 95, NULL, 'Mr.', 'Mojtaba', NULL, 'Falahi', 'male', '1985-05-05 17:00:00', 36, 'Iranian', 'Iran', 'muslim', 'L44159445', 'L44159445', '09358328627', 'mojtaba.falahi.az@gmail.com', '2021-09-27 17:48:48', '2021-09-27 17:48:48'), (111, 96, NULL, 'Mr.', 'Mojtaba', NULL, 'Falahi', 'male', '1985-05-05 17:00:00', 36, 'Iranian', 'Iran', 'muslim', 'L44159445', 'L44159445', '09358328627', 'mojtaba.falahi.az@gmail.com', '2021-09-27 17:55:14', '2021-09-27 17:55:14'), (112, 97, NULL, 'Mr.', 'Mojtaba', NULL, 'Falahi', 'male', '1985-05-05 17:00:00', 36, 'Iranian', 'Iran', 'muslim', 'L44159445', 'L44159445', '09358328627', 'mojtaba.falahi.az@gmail.com', '2021-09-27 17:58:26', '2021-09-27 17:58:26'), (113, 98, 186, 'Mrs.', 'ทดสอบ', NULL, 'ทดสอบ', 'male', '2001-03-01 00:00:00', 20, 'thai', 'thai', 'thai', '1909000909999', '-', '0000000000', 'thitipong.pu@gmail.com', '2021-11-18 05:07:08', '2021-11-18 05:07:08'), (114, 99, 187, 'Mrs.', 'ทดสอบ', NULL, 'ทดสอบ', 'male', '2004-11-12 00:00:00', 17, 'thai', 'Afghanistan', 'thai', '1909000909999', '-', '0000000000', 'tan2022@hotmail.com', '2021-11-22 09:04:38', '2021-11-22 09:04:38'), (115, 100, 188, 'Miss.', 'Chanikan', NULL, 'Potjamanpong', 'male', '2006-02-09 00:00:00', 16, 'thai', 'Thailand', 'thai', '1909099099999', '-', '0955265394', 'thitipong.pu@gmail.com', '2022-02-15 06:47:56', '2022-02-15 06:47:56'), (116, 101, 189, 'Mr.', 'Chanikan', NULL, 'Potjamanpong', 'male', '2022-02-15 00:00:00', 0, 'thai', 'Thailand', 'thai', '1909099099999', '1909099099999', '0955265394', 'tan@hotmail.com', '2022-02-15 06:51:12', '2022-02-15 06:51:12'); -- -------------------------------------------------------- -- -- Table structure for table `user_my_course` -- CREATE TABLE `user_my_course` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `course_id` int(11) NOT NULL, `created_at` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `user_my_course` -- INSERT INTO `user_my_course` (`id`, `user_id`, `course_id`, `created_at`) VALUES (5, 80, 28, '2022-03-15'), (6, 80, 31, '2022-03-15'), (10, 78, 27, '2022-03-15'); -- -------------------------------------------------------- -- -- Table structure for table `verify_detail` -- CREATE TABLE `verify_detail` ( `id` int(11) NOT NULL, `topic_id` int(11) NOT NULL, `student_id` int(11) NOT NULL, `register_id` int(11) DEFAULT NULL, `description` varchar(1000) NOT NULL, `status` int(11) NOT NULL, `date_veried` datetime NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `verify_detail` -- INSERT INTO `verify_detail` (`id`, `topic_id`, `student_id`, `register_id`, `description`, `status`, `date_veried`, `created_at`, `updated_at`) VALUES (146, 1, 90, NULL, '', 0, '2021-09-24 00:00:00', '2021-09-24 00:00:00', '2021-09-24 00:00:00'), (147, 2, 90, NULL, '', 0, '2021-09-24 00:00:00', '2021-09-24 00:00:00', '2021-09-24 00:00:00'), (148, 3, 90, NULL, '', 0, '2021-09-24 00:00:00', '2021-09-24 00:00:00', '2021-09-24 00:00:00'), (149, 4, 90, NULL, '', 0, '2021-09-24 00:00:00', '2021-09-24 00:00:00', '2021-09-24 00:00:00'), (150, 5, 90, NULL, '', 0, '2021-09-24 00:00:00', '2021-09-24 00:00:00', '2021-09-24 00:00:00'), (151, 6, 90, NULL, '', 0, '2021-09-24 00:00:00', '2021-09-24 00:00:00', '2021-09-24 00:00:00'), (153, 8, 90, NULL, '', 0, '2021-09-24 00:00:00', '2021-09-24 00:00:00', '2021-09-24 00:00:00'), (154, 1, 91, NULL, '', 0, '2021-09-24 00:00:00', '2021-09-24 00:00:00', '2021-09-24 00:00:00'), (155, 2, 91, NULL, '', 0, '2021-09-24 00:00:00', '2021-09-24 00:00:00', '2021-09-24 00:00:00'), (156, 3, 91, NULL, '', 0, '2021-09-24 00:00:00', '2021-09-24 00:00:00', '2021-09-24 00:00:00'), (157, 4, 91, NULL, '', 0, '2021-09-24 00:00:00', '2021-09-24 00:00:00', '2021-09-24 00:00:00'), (158, 5, 91, NULL, '', 0, '2021-09-24 00:00:00', '2021-09-24 00:00:00', '2021-09-24 00:00:00'), (159, 6, 91, NULL, '', 0, '2021-09-24 00:00:00', '2021-09-24 00:00:00', '2021-09-24 00:00:00'), (161, 8, 91, NULL, '', 0, '2021-09-24 00:00:00', '2021-09-24 00:00:00', '2021-09-24 00:00:00'), (162, 1, 92, 180, 'Checked', 1, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (163, 2, 92, 180, 'Paid', 1, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (164, 3, 92, 180, 'More documents are required.:\r\n1) Research Proposal\r\n2) Recommendation Letter', 2, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (165, 4, 92, 180, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (166, 5, 92, 180, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (167, 6, 92, 180, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (169, 8, 92, 180, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (170, 1, 93, 181, 'pass', 1, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (171, 2, 93, 181, 'no Payment', 2, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (172, 3, 93, 181, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (173, 4, 93, 181, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (174, 5, 93, 181, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (175, 6, 93, 181, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (177, 8, 93, 181, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (178, 1, 94, 182, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (179, 2, 94, 182, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (180, 3, 94, 182, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (181, 4, 94, 182, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (182, 5, 94, 182, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (183, 6, 94, 182, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (184, 8, 94, 182, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (185, 1, 95, NULL, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (186, 2, 95, NULL, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (187, 3, 95, NULL, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (188, 4, 95, NULL, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (189, 5, 95, NULL, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (190, 6, 95, NULL, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (191, 8, 95, NULL, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (192, 1, 96, NULL, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (193, 2, 96, NULL, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (194, 3, 96, NULL, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (195, 4, 96, NULL, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (196, 5, 96, NULL, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (197, 6, 96, NULL, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (198, 8, 96, NULL, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (199, 1, 97, NULL, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (200, 2, 97, NULL, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (201, 3, 97, NULL, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (202, 4, 97, NULL, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (203, 5, 97, NULL, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (204, 6, 97, NULL, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (205, 8, 97, NULL, '', 0, '2021-09-27 00:00:00', '2021-09-27 00:00:00', '2021-09-27 00:00:00'), (206, 1, 98, 186, '', 0, '2021-11-18 00:00:00', '2021-11-18 00:00:00', '2021-11-18 00:00:00'), (207, 2, 98, 186, '', 0, '2021-11-18 00:00:00', '2021-11-18 00:00:00', '2021-11-18 00:00:00'), (208, 3, 98, 186, '', 0, '2021-11-18 00:00:00', '2021-11-18 00:00:00', '2021-11-18 00:00:00'), (209, 4, 98, 186, '', 0, '2021-11-18 00:00:00', '2021-11-18 00:00:00', '2021-11-18 00:00:00'), (210, 5, 98, 186, '', 0, '2021-11-18 00:00:00', '2021-11-18 00:00:00', '2021-11-18 00:00:00'), (211, 6, 98, 186, '', 0, '2021-11-18 00:00:00', '2021-11-18 00:00:00', '2021-11-18 00:00:00'), (212, 8, 98, 186, '', 0, '2021-11-18 00:00:00', '2021-11-18 00:00:00', '2021-11-18 00:00:00'), (213, 1, 99, 187, '', 0, '2021-11-22 00:00:00', '2021-11-22 00:00:00', '2021-11-22 00:00:00'), (214, 2, 99, 187, '', 0, '2021-11-22 00:00:00', '2021-11-22 00:00:00', '2021-11-22 00:00:00'), (215, 3, 99, 187, '', 0, '2021-11-22 00:00:00', '2021-11-22 00:00:00', '2021-11-22 00:00:00'), (216, 4, 99, 187, '', 0, '2021-11-22 00:00:00', '2021-11-22 00:00:00', '2021-11-22 00:00:00'), (217, 5, 99, 187, '', 0, '2021-11-22 00:00:00', '2021-11-22 00:00:00', '2021-11-22 00:00:00'), (218, 6, 99, 187, '', 0, '2021-11-22 00:00:00', '2021-11-22 00:00:00', '2021-11-22 00:00:00'), (219, 8, 99, 187, '', 0, '2021-11-22 00:00:00', '2021-11-22 00:00:00', '2021-11-22 00:00:00'), (220, 1, 100, 188, '', 0, '2022-02-15 00:00:00', '2022-02-15 00:00:00', '2022-02-15 00:00:00'), (221, 2, 100, 188, '', 0, '2022-02-15 00:00:00', '2022-02-15 00:00:00', '2022-02-15 00:00:00'), (222, 3, 100, 188, '', 0, '2022-02-15 00:00:00', '2022-02-15 00:00:00', '2022-02-15 00:00:00'), (223, 4, 100, 188, '', 0, '2022-02-15 00:00:00', '2022-02-15 00:00:00', '2022-02-15 00:00:00'), (224, 5, 100, 188, '', 0, '2022-02-15 00:00:00', '2022-02-15 00:00:00', '2022-02-15 00:00:00'), (225, 6, 100, 188, '', 0, '2022-02-15 00:00:00', '2022-02-15 00:00:00', '2022-02-15 00:00:00'), (226, 8, 100, 188, '', 0, '2022-02-15 00:00:00', '2022-02-15 00:00:00', '2022-02-15 00:00:00'), (227, 1, 101, 189, '', 2, '2022-02-15 00:00:00', '2022-02-15 00:00:00', '2022-02-15 00:00:00'), (228, 2, 101, 189, '', 0, '2022-02-15 00:00:00', '2022-02-15 00:00:00', '2022-02-15 00:00:00'), (229, 3, 101, 189, '', 0, '2022-02-15 00:00:00', '2022-02-15 00:00:00', '2022-02-15 00:00:00'), (230, 4, 101, 189, '', 0, '2022-02-15 00:00:00', '2022-02-15 00:00:00', '2022-02-15 00:00:00'), (231, 5, 101, 189, '', 0, '2022-02-15 00:00:00', '2022-02-15 00:00:00', '2022-02-15 00:00:00'), (232, 6, 101, 189, '', 0, '2022-02-15 00:00:00', '2022-02-15 00:00:00', '2022-02-15 00:00:00'), (233, 8, 101, 189, '', 0, '2022-02-15 00:00:00', '2022-02-15 00:00:00', '2022-02-15 00:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `verify_detail_history` -- CREATE TABLE `verify_detail_history` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `verify_detail_id` int(11) NOT NULL, `user_username` varchar(255) NOT NULL, `message` text DEFAULT NULL, `result` varchar(1000) DEFAULT NULL, `created_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `verify_detail_history` -- INSERT INTO `verify_detail_history` (`id`, `user_id`, `verify_detail_id`, `user_username`, `message`, `result`, `created_at`) VALUES (1, 1, 227, 'admin', NULL, 'Selection Result: pass', '2022-03-15 20:08:21'), (2, 1, 227, 'admin', NULL, 'Selection Result: don\'t pass', '2022-03-15 21:51:40'); -- -------------------------------------------------------- -- -- Table structure for table `verify_topic` -- CREATE TABLE `verify_topic` ( `id` int(11) NOT NULL, `name_th` varchar(255) NOT NULL, `name_en` varchar(255) NOT NULL, `is_enable` int(1) NOT NULL DEFAULT 1, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `verify_topic` -- INSERT INTO `verify_topic` (`id`, `name_th`, `name_en`, `is_enable`, `created_at`, `updated_at`) VALUES (1, 'ตรวจสอบใบสมัคร', 'Application Check', 1, '2021-09-16 11:14:48', '2021-09-16 11:14:48'), (2, 'ตรวจสอบหลักฐานการชำระเงินค่าสมัคร', 'Payment Checking', 1, '2021-09-16 11:14:48', '2021-09-16 11:14:48'), (3, 'ตรวจสอบเอกสารประกอบการสมัคร', 'Supportive Documents', 1, '2021-09-16 11:14:48', '2021-09-16 11:14:48'), (4, 'ตรวจสอบคุณสมบัติผู้สมัคร', 'Applicant’s Eligibility', 1, '2021-09-16 11:14:48', '2021-09-16 11:14:48'), (5, 'สอบข้อเขียน', 'Selection Process', 1, '2021-09-16 11:14:48', '2021-09-16 11:14:48'), (6, 'ผลการคัดเลือก', 'Selection Result', 1, '2021-09-16 11:14:48', '2021-09-16 11:14:48'), (7, 'ตรวจสอบหลักฐานการชำระเงินยืนยันสิทธิ์', 'ตรวจสอบหลักฐานการชำระเงินยืนยันสิทธิ์', 0, '2021-09-16 11:14:48', '2021-09-16 11:14:48'), (8, 'การสมัครเสร็จสมูบรณ์', 'Completed', 1, '2021-09-16 11:14:48', '2021-09-16 11:14:48'); -- -- Indexes for dumped tables -- -- -- Indexes for table `auth_assignment` -- ALTER TABLE `auth_assignment` ADD PRIMARY KEY (`item_name`,`user_id`), ADD KEY `idx-auth_assignment-user_id` (`user_id`); -- -- Indexes for table `auth_item` -- ALTER TABLE `auth_item` ADD PRIMARY KEY (`name`), ADD KEY `rule_name` (`rule_name`), ADD KEY `idx-auth_item-type` (`type`); -- -- Indexes for table `auth_item_child` -- ALTER TABLE `auth_item_child` ADD PRIMARY KEY (`parent`,`child`), ADD KEY `child` (`child`); -- -- Indexes for table `auth_rule` -- ALTER TABLE `auth_rule` ADD PRIMARY KEY (`name`); -- -- Indexes for table `blog` -- ALTER TABLE `blog` ADD PRIMARY KEY (`id`), ADD KEY `title` (`title`); ALTER TABLE `blog` ADD FULLTEXT KEY `content` (`content`); -- -- Indexes for table `category` -- ALTER TABLE `category` ADD PRIMARY KEY (`category_id`); -- -- Indexes for table `contact` -- ALTER TABLE `contact` ADD PRIMARY KEY (`id`); -- -- Indexes for table `courses` -- ALTER TABLE `courses` ADD PRIMARY KEY (`id`); -- -- Indexes for table `education_qualifications` -- ALTER TABLE `education_qualifications` ADD PRIMARY KEY (`id`); -- -- Indexes for table `employment_history` -- ALTER TABLE `employment_history` ADD PRIMARY KEY (`id`); -- -- Indexes for table `error_log` -- ALTER TABLE `error_log` ADD PRIMARY KEY (`id`); -- -- Indexes for table `faculty` -- ALTER TABLE `faculty` ADD PRIMARY KEY (`id`); -- -- Indexes for table `faculty_level` -- ALTER TABLE `faculty_level` ADD PRIMARY KEY (`id`); -- -- Indexes for table `learnPlan` -- ALTER TABLE `learnPlan` ADD PRIMARY KEY (`id`); -- -- Indexes for table `locations` -- ALTER TABLE `locations` ADD PRIMARY KEY (`id`); -- -- Indexes for table `migration` -- ALTER TABLE `migration` ADD PRIMARY KEY (`version`); -- -- Indexes for table `others_info` -- ALTER TABLE `others_info` ADD PRIMARY KEY (`id`); -- -- Indexes for table `payment_status` -- ALTER TABLE `payment_status` ADD PRIMARY KEY (`id`); -- -- Indexes for table `prefix_title` -- ALTER TABLE `prefix_title` ADD PRIMARY KEY (`id`); -- -- Indexes for table `program` -- ALTER TABLE `program` ADD PRIMARY KEY (`id`); -- -- Indexes for table `publications` -- ALTER TABLE `publications` ADD PRIMARY KEY (`id`); -- -- Indexes for table `question_and_answer` -- ALTER TABLE `question_and_answer` ADD PRIMARY KEY (`id`); -- -- Indexes for table `referees` -- ALTER TABLE `referees` ADD PRIMARY KEY (`id`); -- -- Indexes for table `register_information` -- ALTER TABLE `register_information` ADD PRIMARY KEY (`id`); -- -- Indexes for table `register_status` -- ALTER TABLE `register_status` ADD PRIMARY KEY (`id`); -- -- Indexes for table `research_experiences` -- ALTER TABLE `research_experiences` ADD PRIMARY KEY (`id`); -- -- Indexes for table `role_verify_topic` -- ALTER TABLE `role_verify_topic` ADD PRIMARY KEY (`id`); -- -- Indexes for table `school_year` -- ALTER TABLE `school_year` ADD PRIMARY KEY (`id`); -- -- Indexes for table `setting` -- ALTER TABLE `setting` ADD PRIMARY KEY (`id`); -- -- Indexes for table `student_account` -- ALTER TABLE `student_account` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`); -- -- Indexes for table `test_type` -- ALTER TABLE `test_type` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user` -- ALTER TABLE `user` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `username` (`username`), ADD UNIQUE KEY `email` (`email`), ADD UNIQUE KEY `password_reset_token` (`password_reset_token`); -- -- Indexes for table `user_address` -- ALTER TABLE `user_address` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user_file` -- ALTER TABLE `user_file` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user_information` -- ALTER TABLE `user_information` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user_my_course` -- ALTER TABLE `user_my_course` ADD PRIMARY KEY (`id`); -- -- Indexes for table `verify_detail` -- ALTER TABLE `verify_detail` ADD PRIMARY KEY (`id`); -- -- Indexes for table `verify_detail_history` -- ALTER TABLE `verify_detail_history` ADD PRIMARY KEY (`id`); -- -- Indexes for table `verify_topic` -- ALTER TABLE `verify_topic` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `blog` -- ALTER TABLE `blog` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `category` -- ALTER TABLE `category` MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `contact` -- ALTER TABLE `contact` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `courses` -- ALTER TABLE `courses` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54; -- -- AUTO_INCREMENT for table `education_qualifications` -- ALTER TABLE `education_qualifications` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=108; -- -- AUTO_INCREMENT for table `employment_history` -- ALTER TABLE `employment_history` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67; -- -- AUTO_INCREMENT for table `error_log` -- ALTER TABLE `error_log` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- AUTO_INCREMENT for table `faculty` -- ALTER TABLE `faculty` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23; -- -- AUTO_INCREMENT for table `faculty_level` -- ALTER TABLE `faculty_level` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `learnPlan` -- ALTER TABLE `learnPlan` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `locations` -- ALTER TABLE `locations` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `others_info` -- ALTER TABLE `others_info` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=87; -- -- AUTO_INCREMENT for table `payment_status` -- ALTER TABLE `payment_status` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `prefix_title` -- ALTER TABLE `prefix_title` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `program` -- ALTER TABLE `program` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=102; -- -- AUTO_INCREMENT for table `publications` -- ALTER TABLE `publications` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=72; -- -- AUTO_INCREMENT for table `question_and_answer` -- ALTER TABLE `question_and_answer` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `referees` -- ALTER TABLE `referees` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=145; -- -- AUTO_INCREMENT for table `register_information` -- ALTER TABLE `register_information` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=191; -- -- AUTO_INCREMENT for table `register_status` -- ALTER TABLE `register_status` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `research_experiences` -- ALTER TABLE `research_experiences` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24; -- -- AUTO_INCREMENT for table `role_verify_topic` -- ALTER TABLE `role_verify_topic` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13; -- -- AUTO_INCREMENT for table `school_year` -- ALTER TABLE `school_year` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT for table `setting` -- ALTER TABLE `setting` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `student_account` -- ALTER TABLE `student_account` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=102; -- -- AUTO_INCREMENT for table `test_type` -- ALTER TABLE `test_type` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- AUTO_INCREMENT for table `user` -- ALTER TABLE `user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81; -- -- AUTO_INCREMENT for table `user_address` -- ALTER TABLE `user_address` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=170; -- -- AUTO_INCREMENT for table `user_file` -- ALTER TABLE `user_file` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=59; -- -- AUTO_INCREMENT for table `user_information` -- ALTER TABLE `user_information` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=118; -- -- AUTO_INCREMENT for table `user_my_course` -- ALTER TABLE `user_my_course` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `verify_detail` -- ALTER TABLE `verify_detail` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=262; -- -- AUTO_INCREMENT for table `verify_detail_history` -- ALTER TABLE `verify_detail_history` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `verify_topic` -- ALTER TABLE `verify_topic` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9; -- -- Constraints for dumped tables -- -- -- Constraints for table `auth_assignment` -- ALTER TABLE `auth_assignment` ADD CONSTRAINT `auth_assignment_ibfk_1` FOREIGN KEY (`item_name`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- Constraints for table `auth_item` -- ALTER TABLE `auth_item` ADD CONSTRAINT `auth_item_ibfk_1` FOREIGN KEY (`rule_name`) REFERENCES `auth_rule` (`name`) ON DELETE SET NULL ON UPDATE CASCADE; -- -- Constraints for table `auth_item_child` -- ALTER TABLE `auth_item_child` ADD CONSTRAINT `auth_item_child_ibfk_1` FOREIGN KEY (`parent`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `auth_item_child_ibfk_2` FOREIGN KEY (`child`) REFERENCES `auth_item` (`name`) ON DELETE CASCADE ON UPDATE CASCADE; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;