-- phpMyAdmin SQL Dump -- version 5.1.0 -- https://www.phpmyadmin.net/ -- -- Host: db -- Generation Time: Aug 07, 2021 at 01:41 PM -- Server version: 10.5.9-MariaDB-1:10.5.9+maria~focal -- PHP Version: 7.4.15 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 ('Admin', '1', 1626109774); -- -------------------------------------------------------- -- -- 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 ('Admin', 1, 'สำหรับการดูแลระบบ', NULL, NULL, 1626109774, 1626109774), ('Management', 1, 'สำหรับจัดการข้อมูลผู้ใช้งานและบทความ', NULL, NULL, 1626109774, 1626109774), ('ManageUser', 1, 'สำหรับจัดการข้อมูลผู้ใช้งาน', 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; -- -- Dumping data for table `auth_item_child` -- INSERT INTO `auth_item_child` (`parent`, `child`) VALUES ('Admin', 'Management'), ('Management', 'ManageUser'); -- -------------------------------------------------------- -- -- 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 'คำค้น', `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`, `images`, `created_by`, `updated_by`, `create_at`, `update_at`) VALUES (1, 'More Information', '
*Due to an English version of admission system has been developing, the international applicants can download an application form from CGS Website (https://grad.wu.ac.th/admission-trimeter/ or https://grad.wu.ac.th/admission-semester/) and submit the application to us via email: grad.walailak@gmail.com
', 1, NULL, '488d09fe5ce6008657a19e23ef302bcd.jpg', NULL, NULL, '2021-07-15 00:00:00', '2021-07-15 00:00:00'), (2, 'Recruiting people to study opposite Arthit requesting a Master\'s degree Walailak University', 'Walailak University Recruiting people to study for a Master\'s degree program in the Master of Public Health for the academic year 2021. Focusing on the program. Produce master\'s degrees with academic and professional ethics, able to apply innovations by integrating health wisdom with health management technology. To solve problems and develop public health work in the local, regional, national and international Interested persons can apply for the course from today onwards. Open for semester 1/2564 in June Open a special course Saturday - Sunday Selection - Based on Profile, written exam and interview “There is a scholarship For those with high potential\" Contact for more information and apply at Master of Public Health Program School of Public Health, Academic Building 8, Walailak University call 0-7567-2789, 08-9866-1098, 09-7124-361414 1617
', 1, '', '6c646dea6732861e4270f54e466b28cb.jpg', NULL, NULL, '2021-07-15 00:00:00', '2021-07-16 00:00:00'), (3, 'School of Public Health Recruiting people to study at the master\'s-doctoral level Academic year 2021', 'School of Public Health Recruiting people to study at the master\'s-doctoral level Academic year 2021 1. Master\'s degree Department of Environmental Technology, Safety and Health 1.1 Special Course (Saturday-Sunday classes) 1.2 International program 2. Doctoral degree Department of Environmental Technology, Safety and Health 2.1 Special Course (Saturday-Sunday classes) 2.2 International Program Selection 1. Consider the applicant\'s qualifications. 2. Interview and present the topic of interest in the thesis. Scholarships for Master\'s degree 1. Special courses 1.1 Scholarships for potential candidates. Support for educational fees in the amount of 84,000 baht. 1.2 Research project subsidies. The scholarship value is not more than 50,000 baht per subject. 2. International Program 2.1 Master Degree Excellence Scholarships (ME Scholarships) Full tuition fee exemption. (95,000 baht per semester) 2.2 Research project subsidies The capital value is not more than 50,000 baht per case. 1. International Program PhD level 1.1 Ph.D. Excellence Scholarships (PE Scholarships) Full tuition fee waiver (95,000 baht per semester) 1.2 Scholarships for high potential students Full tuition fee waiver and living expenses 10,000 baht per month 1.3 funding for research projects The capital value is not more than 100,000 baht per story. For more information, please contact Assistant Professor Dr. Panadda Phiboon E-mail ppanatda@wu.ac.th Tel. 0-7567-2750 School of Public Health Academic Building 8 Walailak University website : http://sph.wu.ac.th facebook : Public Health Walailak', NULL, NULL, '', NULL, NULL, '2021-07-15 00:00:00', '2021-07-17 00:00:00'), (5, 'title 2', 'test2
', NULL, NULL, '883ab062a52a01d7634ca9dbe9cca7ca.jpg', NULL, NULL, '2021-07-20 15:52:59', '2021-07-20 15:52:59'); -- -------------------------------------------------------- -- -- Table structure for table `branch` -- CREATE TABLE `branch` ( `id` int(11) NOT NULL, `name_th` varchar(200) DEFAULT NULL, `name_en` varchar(200) DEFAULT NULL, `course_id` int(10) DEFAULT NULL, `student_limit` int(10) DEFAULT NULL, `is_enable` int(1) DEFAULT 1, `create_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `branch` -- INSERT INTO `branch` (`id`, `name_th`, `name_en`, `course_id`, `student_limit`, `is_enable`, `create_at`) VALUES (5, 'สาขาบริหารธุรกิจ', NULL, 7, 10, 0, '2020-05-01 14:04:43'), (14, 'สาขาการพยาบาลผู้ใหญ่และผู้สูงอายุ', NULL, 9, 10, 1, '2020-07-02 15:21:11'), (34, 'สาขาเกษตรศาสตร์ หลักสูตรนานาชาติ', NULL, 15, 10, 1, '2020-07-02 15:51:34'), (37, 'สาขาวิทยาการด้านยาและเครื่องสำอาง', NULL, 16, 10, 0, '2020-07-02 15:54:05'), (38, 'สาขานวัตกรรมยาและเครื่องสำอาง หลักสูตรนานาชาติ', NULL, 16, 10, 1, '2020-07-02 15:54:05'), (39, 'สาขาวิทยาศาสตร์ หลักสูตรนานาชาติ', NULL, 17, 10, 1, '2020-07-02 15:55:08'), (43, 'สาขาวิศวกรรมศาสตร์ หลักสูตรนานาชาติ', NULL, 13, 10, 1, '2020-07-02 15:55:47'), (47, 'สาขาการจัดการเทคโนโลยีสารสนเทศ', NULL, 19, 10, 1, '2020-07-02 15:56:21'), (68, 'สาขาทันตแพทยศาสตร์ (หลักสูตรนานาชาติ) - วิชาเอกทันตกรรมจัดฟัน', NULL, 2, NULL, 1, '2021-03-02 07:30:13'), (72, 'สาขาทันตแพทยศาสตร์ (หลักสูตรนานาชาติ) - วิชาเอกศัลยศาสตร์ช่องปากและแม็กชิลโลเฟเชียล', NULL, 2, NULL, 1, '2021-03-02 07:43:16'), (73, 'สาขาการพยาบาลเวชปฏิบัติชุมชน', NULL, 40, NULL, 1, '2021-03-02 08:18:07'), (74, 'สาขาศิลปศาสตร์ (หลักสูตรนานาชาติ)', NULL, 41, NULL, 1, '2021-03-02 08:20:19'), (76, 'สาขาวิศวกรรมศาสตร์ (หลักสูตรนานาชาติ)', NULL, 10, NULL, 1, '2021-03-02 08:21:47'), (79, 'สาขานวัตกรรมด้านยาและเครื่องสำอาง (หลักสูตรนานาชาติ)', NULL, 16, NULL, 1, '2021-03-02 08:24:27'), (80, 'สาขาเทคโนโลโยีสิ่งแวดล้อม ความปลอดภัย และสุขภาพ', NULL, 17, NULL, 1, '2021-03-02 08:25:48'), (82, 'สาธารณสุขศาสตรมหาบัณฑิต', NULL, 12, NULL, 1, '2021-03-02 08:49:52'), (83, 'สาขาเทคโนโลยีสิ่งแวดล้อม ความปลอดภัย และสุขภาพ ', NULL, 17, NULL, 1, '2021-03-02 08:55:29'), (84, 'สาขาเทคโนโลยีสิ่งแวดล้อม ความปลอดภัย และสุขภาพ (หลักสูตรนานาชาติ)', NULL, 17, NULL, 1, '2021-03-02 08:55:47'), (85, 'สาขาวิทยาศาสตร์สุขภาพ (หลักสูตรนานาชาติ)', NULL, 38, NULL, 1, '2021-03-02 09:00:17'), (86, 'สาขาวิศวกรรมศาสตร์ (หลักสูตรนานาชาติ)', NULL, 13, NULL, 1, '2021-03-02 09:00:45'), (87, 'สาขานวัตกรรมยาและเครื่องสำอาง (หลักสูตรนานาชาติ)', NULL, 16, NULL, 1, '2021-03-02 09:01:15'), (88, 'สาขาเกษตรศาสตร์ หลักสูตรนานาชาติ', NULL, 37, NULL, 1, '2021-03-02 09:02:20'), (89, 'สาขาเกษตรศาสตร์ (หลักสูตรนานาชาติ)', NULL, 42, NULL, 1, '2021-03-02 09:04:18'), (90, 'สาขาวัสดุศาสตร์และนวัตกรรม (หลักสูตรนานาชาติ)', NULL, 43, NULL, 1, '2021-03-02 09:05:22'), (91, 'สาขาวัสดุศาสตร์และนวัตกรรม (หลักสูตรนานาชาติ)', NULL, 44, NULL, 1, '2021-03-02 09:08:07'), (92, 'สาขาอุตสาหกรรมเกษตรและเทคโนโลยีชีวภาพ (หลักสูตรนานาชาติ)', NULL, 45, NULL, 1, '2021-03-02 09:11:06'), (93, 'สาขาเทคโนโลยีสิ่งแวดล้อม ความปลอดภัย และสุขภาพ', NULL, 46, NULL, 0, '2021-03-02 09:19:08'), (94, 'สาขาอุตสาหกรรมเกษตรและเทคโนโลยีชีวภาพ (หลักสูตรนานาชาติ)', NULL, 47, NULL, 1, '2021-03-02 09:21:47'), (95, 'สาขาการจัดการ (หลักสูตรนานาชาติ)', NULL, 48, NULL, 1, '2021-03-02 09:46:45'); -- -------------------------------------------------------- -- -- Table structure for table `category` -- CREATE TABLE `category` ( `category_id` int(11) NOT NULL, `category_name` varchar(255) NOT NULL, `status` int(11) NOT NULL DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `category` -- INSERT INTO `category` (`category_id`, `category_name`, `status`) VALUES (1, 'ข่าวทั่วไป', 1); -- -------------------------------------------------------- -- -- Table structure for table `contact` -- CREATE TABLE `contact` ( `id` int(11) NOT NULL, `contact` text NOT NULL, `create_at` date NOT NULL, `update_at` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `contact` -- INSERT INTO `contact` (`id`, `contact`, `create_at`, `update_at`) VALUES (1, 'ที่อยู่
ฝ่ายรับนักศึกษา
มหาวิทยาลัยวลัยลักษณ์
222 ตำบลไทยบุรี
อำเภมท่าศาลา จังหวัดนครศรีธรรมราช
80160
โทรศัพท์
075673101-5
โทรสาร
075673135
Facebook
www.facebook.com/walailakgradstudy
\r\n
\r\n
ติดต่อได้ที่ ศบศ.. ทดสอบ
', 1, 1, '2021-07-14'), (2, 'ติดต่อเจ้าหน้าที่ได้ทางช่องทางใหนบ้าง', 'สำนักงาน', 0, 0, '2021-07-14'), (3, 'test', 'School of Public Health Recruiting people to study at the master\'s-doctoral level Academic year 2021 1. Master\'s degree Department of Environmental Technology, Safety and Health 1.1 Special Course (Saturday-Sunday classes) 1.2 International program 2. Doctoral degree Department of Environmental Technology, Safety and Health 2.1 Special Course (Saturday-Sunday classes) 2.2 International Program Selection 1. Consider the applicant\'s qualifications. 2. Interview and present the topic of interest in the thesis. Scholarships for Master\'s degree 1. Special courses 1.1 Scholarships for potential candidates. Support for educational fees in the amount of 84,000 baht. 1.2 Research project subsidies. The scholarship value is not more than 50,000 baht per subject. 2. International Program 2.1 Master Degree Excellence Scholarships (ME Scholarships) Full tuition fee exemption. (95,000 baht per semester) 2.2 Research project subsidies The capital value is not more than 50,000 baht per case. 1. International Program PhD level 1.1 Ph.D. Excellence Scholarships (PE Scholarships) Full tuition fee waiver (95,000 baht per semester) 1.2 Scholarships for high potential students Full tuition fee waiver and living expenses 10,000 baht per month 1.3 funding for research projects The capital value is not more than 100,000 baht per story. For more information, please contact Assistant Professor Dr. Panadda Phiboon E-mail ppanatda@wu.ac.th Tel. 0-7567-2750 School of Public Health Academic Building 8 Walailak University website : http://sph.wu.ac.th facebook : Public Health Walailak
', 0, 0, '2021-07-19'); -- -------------------------------------------------------- -- -- Table structure for table `referees` -- CREATE TABLE `referees` ( `id` int(11) NOT NULL, `student_id` int(11) NOT 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`, `name`, `family_name`, `surname`, `Institution`, `relationship_applicant`, `address`, `contact_number`, `e_mail`, `created_at`, `updated_at`) VALUES (9, 8, 'userteast', 'home', 'homepage', 'wise', 'wise', 'wise 1.2 / 0485', '111111111', 'com.com@mail', '2021-08-05 09:47:18', '2021-08-05 09:47:18'), (10, 8, 'userteast', 'home', 'homepage', 'wise', 'wise', 'wise 1.2 / 0485', '111111111', 'com.com@mail', '2021-08-05 09:47:18', '2021-08-05 09:47:18'), (11, 9, 'userteast', 'home', 'homepage', 'wise', 'wise', 'wise 1.2 / 0485', '111111111', 'com.com@mail', '2021-08-05 09:57:06', '2021-08-05 09:57:06'), (12, 9, 'userteast', 'home', 'homepage', 'wise', 'wise', 'wise 1.2 / 0485', '111111111', 'com.com@mail', '2021-08-05 09:57:06', '2021-08-05 09:57:06'), (13, 10, 'userteast', 'home', 'homepage', 'wise', 'wise', 'wise 1.2 / 0485', '111111111', 'com.com@mail', '2021-08-05 09:58:55', '2021-08-05 09:58:55'), (14, 10, 'userteast', 'home', 'homepage', 'wise', 'wise', 'wise 1.2 / 0485', '111111111', 'com.com@mail', '2021-08-05 09:58:55', '2021-08-05 09:58:55'), (15, 11, 'userteast', 'home', 'homepage', 'wise', 'wise', 'wise 1.2 / 0485', '111111111', 'com.com@mail', '2021-08-05 10:04:31', '2021-08-05 10:04:31'), (16, 11, 'userteast', 'home', 'homepage', 'wise', 'wise', 'wise 1.2 / 0485', '111111111', 'com.com@mail', '2021-08-05 10:04:31', '2021-08-05 10:04:31'), (17, 19, 'asd', 'asd', 'asd', 'asd', 'asd', 'asdasd', 'asd', 'asd', '2021-08-07 09:57:50', '2021-08-07 09:57:50'), (18, 20, 'thitipong', '-', 'asddd', 'asd', 'asd', 'asd', 'asd', 'asd', '2021-08-07 10:45:59', '2021-08-07 10:45:59'), (19, 20, 'asd', 'asd', 'asd', 'asd', 'asd', 'asdasd', 'asd', 'asd', '2021-08-07 10:45:59', '2021-08-07 10:45:59'), (20, 21, 'tha', '-', 'tha', '-', '-', '-', '-', '-', '2021-08-07 11:01:44', '2021-08-07 11:01:44'), (21, 21, 'rtha', '-', 'that', '-', '-', '-', '-', '-', '2021-08-07 11:01:44', '2021-08-07 11:01:44'), (22, 22, 'tha', '-', 'tha', '-', '-', '-', '-', '-', '2021-08-07 11:59:56', '2021-08-07 11:59:56'), (23, 22, 'rtha', '-', 'that', '-', '-', '-', '-', '-', '2021-08-07 11:59:56', '2021-08-07 11:59:56'), (24, 23, 'tha', '-', 'tha', 'aaa', 'aa', 'aa', 'aa', 'aaa', '2021-08-07 12:03:48', '2021-08-07 12:03:48'), (25, 23, 'rtha', '-', 'that', 'aaa', 'aa', 'aaa', 'aa', 'aa', '2021-08-07 12:03:48', '2021-08-07 12:03:48'); -- -------------------------------------------------------- -- -- 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, `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`, `update_at`, `create_at`) VALUES (102, 134, 11, 13, 43, 1, 1, 1, 1, 2, 1, 'Magnetic material and DFT calculation in inorganic chemistry', '2021-04-02 06:31:03', '2021-04-02 06:31:03'), (107, 140, 11, 12, 82, 1, 1, 1, 1, 2, 1, 'การพัฒนาระบบทำส่งเพื่อเพิ่มฤทธิ์ทางชีวภาพและเสถียรภาพของน้ำมันปาล์มแดงพรีเมียมและการประยุกต์ใช้เพื่อเป็นส่วนผสมฟังก์ชันในอาหาร', '2021-04-07 03:06:44', '2021-04-07 03:06:44'); -- -------------------------------------------------------- -- -- Table structure for table `register_status` -- CREATE TABLE `register_status` ( `id` int(11) NOT NULL, `name` varchar(200) 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`, `is_enable`, `create_at`, `update_at`) VALUES (1, 'ตรวจสอบสถานะ', 1, '2020-06-01 11:29:30', '2020-06-01 11:29:30'), (2, 'ยื่นใบสมัครแล้ว', 1, '2020-06-01 11:29:30', '2020-06-01 11:29:30'); -- -------------------------------------------------------- -- -- Table structure for table `research_experiences` -- CREATE TABLE `research_experiences` ( `id` int(11) NOT NULL, `student_id` int(11) NOT NULL, `project_title` varchar(200) NOT NULL, `start_date` varchar(5) 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(50) NOT NULL, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- 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/2564', '2021-01-01', '2021-06-30', 1, '2020-03-08 04:13:19', '2021-02-09 05:48:19'), (2, '2/2563', '2020-06-11', '2020-06-20', 0, '2020-03-08 04:13:38', '2021-02-09 04:39:11'), (3, '3/2563', '2020-06-21', '2020-06-30', 0, '2020-03-08 04:13:38', '2021-02-09 04:40:33'), (4, '3/2564', '2021-01-01', '2021-07-31', 1, '2020-06-21 14:50:01', '2021-02-09 05:48:35'), (5, '2/2564', '2021-01-01', '2021-08-31', 1, '2020-08-02 08:39:45', '2021-02-09 05:48:56'), (6, '3/2564', '2020-08-02', '2020-08-14', 0, '2020-08-02 08:39:59', '2021-02-09 04:38:39'), (7, '1/2565', '2020-08-18', '2020-08-19', 0, '2020-08-07 02:56:14', '2020-08-07 02:56:14'); -- -------------------------------------------------------- -- -- 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 (12, 'tester33187@gmail.com', '1234', 3, 0, '2021-08-07 08:32:08'); -- -------------------------------------------------------- -- -- Table structure for table `test_type` -- CREATE TABLE `test_type` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `condition` 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`, `create_at`, `update_at`) VALUES (1, 'TOEFL ITP', 'ต้องเกิน 100 คะแนน', '2021-08-02 09:57:13', '2021-08-02 09:57:13'), (2, 'TOEFL PBT', 'ต้องเกิน 90 คะแนน', '2021-08-02 09:57:13', '2021-08-02 09:57:13'), (5, 'TOEFL CBT', 'ต้องเกิน 80 คะแนน', '2021-08-02 09:58:17', '2021-08-02 09:58:17'), (6, 'TOEFL IBT', 'ต้องเกิน 1000 คะแนน', '2021-08-02 09:58:17', '2021-08-02 09:58:17'), (7, 'IELTS (Academic test only)', 'ต้องเกิน 50 คะแนน', '2021-08-02 09:58:17', '2021-08-02 09:58:17'), (8, 'CU-TEP', 'ต้องเกิน 90 คะแนน', '2021-08-02 09:58:17', '2021-08-02 09:58:17'), (9, 'WU-TEP', 'ต้องเกิน 400 คะแนน', '2021-08-02 09:58:17', '2021-08-02 09:58:17'), (10, 'CEFR', 'ต้องเกิน 40 คะแนน', '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, `status` smallint(6) NOT NULL DEFAULT 10, `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`, `status`, `created_at`, `updated_at`) VALUES (1, 'admin', 'ESwfvDU67iA6-bZdjAFaoPWD3m8-jluT', '$2y$13$m4LEYVPS7u5T.D8Ytzb0AuMYQ7TJh1Ni7vnTBPCPYDpFvvItJIqTG', NULL, 'admin@gmail.com', 10, 1626109923, 1626109923); -- -------------------------------------------------------- -- -- Table structure for table `user_address` -- CREATE TABLE `user_address` ( `id` int(11) NOT NULL, `student_id` int(11) NOT NULL, `addr_line_1` varchar(100) NOT NULL, `addr_line_2` varchar(100) NOT NULL, `country` varchar(50) NOT NULL, `province` varchar(50) NOT NULL, `city` varchar(50) NOT NULL, `postalcode` varchar(10) NOT 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`, `addr_line_1`, `addr_line_2`, `country`, `province`, `city`, `postalcode`, `addr_type`, `created_at`, `updated_at`) VALUES (17, 12, '4/54ddd', '6/54asddทดสอบ', 'thaiก', 'nakon', 'thasala', '80010', 0, '2021-08-07 08:32:09', '2021-08-07 08:32:09'); -- -------------------------------------------------------- -- -- Table structure for table `user_file` -- CREATE TABLE `user_file` ( `id` int(11) NOT NULL, `student_id` int(11) NOT NULL, `certif_master` text NOT NULL, `certif_master_c` text NOT NULL, `certif_bachelor_grad` text NOT NULL, `certif_bachelor_grad_c` text NOT NULL, `certif_master_grad` text NOT NULL, `certif_master_grad_c` text NOT NULL, `toefl_ielts_score` text NOT NULL, `toefl_ielts_score_c` text NOT NULL, `passport_national_id` text NOT NULL, `passport_national_id_c` text NOT NULL, `affiliation` text NOT NULL, `affiliation_c` text NOT NULL, `awards` text NOT NULL, `awards_c` text NOT NULL, `create_at` datetime NOT NULL, `update_at` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `user_file` -- INSERT INTO `user_file` (`id`, `student_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`, `create_at`, `update_at`) VALUES (9, 12, 'YouTube-output (1).xlsx', 'cc262b498604dd1fe951b09612d2b268.xlsx', 'YouTube-output (1).xlsx', 'cc262b498604dd1fe951b09612d2b268.xlsx', 'YouTube-output (1).xlsx', 'cc262b498604dd1fe951b09612d2b268.xlsx', 'YouTube-output (1).xlsx', 'cc262b498604dd1fe951b09612d2b268.xlsx', 'YouTube-output (1).xlsx', 'cc262b498604dd1fe951b09612d2b268.xlsx', 'YouTube-output (1).xlsx', 'cc262b498604dd1fe951b09612d2b268.xlsx', 'YouTube-output (1).xlsx', 'cc262b498604dd1fe951b09612d2b268.xlsx', '2021-08-07 00:00:00', '2021-08-07 00:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `user_information` -- CREATE TABLE `user_information` ( `id` int(11) NOT NULL, `student_id` int(10) DEFAULT NULL, `name_title` varchar(100) DEFAULT NULL, `firstname` varchar(100) 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(30) DEFAULT NULL, `passport_id` varchar(50) NOT NULL, `mobile_number` varchar(11) 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`, `name_title`, `firstname`, `lastname`, `sex`, `birthday`, `age`, `nationality`, `country`, `religion`, `personal_id`, `passport_id`, `mobile_number`, `email`, `create_at`, `update_at`) VALUES (29, 15, 'นาย', 'ธนพล', 'วงศ์มณี', 'male', '1987-06-08 00:00:00', 33, 'ไทย', 'ไทย', 'พุทธ', '1529900235901', '', '945396546', 'ddddd@gmail.com', '2020-04-26 08:59:45', '2020-06-01 06:09:44'), (32, 20, 'นาย', 'ธนพล', 'วงศ์มณี', 'male', '1987-06-08 00:00:00', 33, 'ไทย', 'ไทย', 'พุทธ', '1529900235901', '', '0945396546', 'Bleachkissme@gmail.com', '2020-07-03 16:02:36', '2020-07-03 16:02:36'), (33, 21, 'นาย', 'ธนพล', 'วงศ์มณี', 'male', '1987-06-08 00:00:00', 33, 'ไทย', 'ไทย', 'พุทธ', '1529900235901', '', '0945396546', 'Bleachkissme@gmail.com', '2020-07-03 16:05:15', '2020-07-03 16:05:15'), (37, 60, 'นาง', 'สมฤทัย', 'บัวแย้ม', 'female', '1985-02-26 17:00:00', 35, 'ไทย', 'ไทย', 'พุทธ', '1809900055200', '', '0899719024', 'Somruethai.bo@gmail.com', '2020-12-16 09:03:42', '2020-12-16 09:03:42'), (38, 61, 'นาง', 'สมใจ', 'สิงโตทอง', 'female', '1985-02-26 17:00:00', 35, 'ไทย', 'ไทย', 'พุทธ', '1809900055200', '', '0899719024', 'somruethai.bo@mail.wu.ac.th', '2020-12-16 09:41:58', '2020-12-16 09:41:58'), (39, 62, 'นางสาว', 'สุจินดา ', 'ย่องจีน', 'female', '1983-05-03 17:00:00', 37, 'ไทย', 'ไทย', 'พุทธ', '3920100243432', '', '0830003574', 'panipook2@gmail.com', '2020-12-17 02:57:57', '2020-12-17 02:57:57'), (40, 134, 'นางสาว', 'ฉันทลักษณา', 'ฉันทรางกูร', 'female', '1998-08-13 17:00:00', 23, 'ไทย', 'ไทย', 'พุทธ', '1920600252922', '', '0937352301', 'chantalaksana@gmail.com', '2021-04-02 06:31:03', '2021-04-02 06:31:03'), (41, 135, 'นางสาว', 'ฉันทมาลินี', 'ฉันทรางกูร', 'female', '1998-08-13 17:00:00', 23, 'ไทย', 'ไทย', 'พุทธ', '1920600252931', '', '0936246642', 'chantamalinee@gmail.com', '2021-04-02 06:31:36', '2021-04-02 06:31:36'), (42, 136, 'นางสาว', 'ชนิดา', 'จักรหวัด', 'female', '1998-10-15 17:00:00', 23, 'ไทย', 'ไทย', 'พุทธ', '1809900889470', '', '0661504398', 'chanida.ju@mail.wu.ac.th', '2021-04-02 18:07:36', '2021-04-02 18:07:36'), (44, 140, 'นางสาว', 'ธนัชพร', 'รอดสมัย', 'female', '1998-02-09 17:00:00', 23, 'ไทย', 'ไทย', 'พุทธ', '1100702663252', '', '0625689414', 'Ka-ew24@hotmail.com', '2021-04-07 03:06:44', '2021-04-07 03:06:44'), (45, 141, 'นางสาว', 'พรพิมล', 'หนูมี', 'female', '1997-08-20 17:00:00', 24, 'ไทย', 'ประเทศไทย', 'พุทธ', '1849900294794', '', '0980502216', 'mmonppm@gmail.com', '2021-04-12 13:19:05', '2021-04-12 13:19:05'), (46, 142, 'นางสาว', 'พรพิมล', 'หนูมี', 'female', '1997-08-20 17:00:00', 24, 'ไทย', 'ประเทศไทย', 'พุทธ', '1849900294794', '', '0980502216', 'mmonppm@gmail.com', '2021-04-12 13:23:14', '2021-04-12 13:23:14'); -- -- 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 `branch` -- ALTER TABLE `branch` ADD PRIMARY KEY (`id`); -- -- 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 `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 `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 `school_year` -- ALTER TABLE `school_year` 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`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `blog` -- ALTER TABLE `blog` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `branch` -- ALTER TABLE `branch` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=96; -- -- 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=27; -- -- AUTO_INCREMENT for table `education_qualifications` -- ALTER TABLE `education_qualifications` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `employment_history` -- ALTER TABLE `employment_history` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15; -- -- AUTO_INCREMENT for table `faculty` -- ALTER TABLE `faculty` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18; -- -- 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=18; -- -- 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 `publications` -- ALTER TABLE `publications` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19; -- -- 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=26; -- -- AUTO_INCREMENT for table `register_information` -- ALTER TABLE `register_information` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=124; -- -- AUTO_INCREMENT for table `register_status` -- ALTER TABLE `register_status` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `research_experiences` -- ALTER TABLE `research_experiences` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- 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 `student_account` -- ALTER TABLE `student_account` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25; -- -- AUTO_INCREMENT for table `test_type` -- ALTER TABLE `test_type` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT for table `user` -- ALTER TABLE `user` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `user_address` -- ALTER TABLE `user_address` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35; -- -- AUTO_INCREMENT for table `user_file` -- ALTER TABLE `user_file` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- AUTO_INCREMENT for table `user_information` -- ALTER TABLE `user_information` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=65; -- -- 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 */;