text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : hoc_mysql
  Source Server Version : 50505
  Source Host           : localhost:3306
  Source Database       : danhgiagiangvien
  
  Target Server Type    : MYSQL
  Target Server Version : 50505
  File Encoding         : 65001
  
  Date: 2019-07-06 23:01:30
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  -- ----------------------------
  -- Table structure for `admin`
  -- ----------------------------
  DROP TABLE IF EXISTS `admin`;
  CREATE TABLE `admin` (
    `id` int(9) NOT NULL AUTO_INCREMENT,
    `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,
    `tel` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
    `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `status` smallint(1) NOT NULL DEFAULT '10',
    `avatar` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `username` (`username`) USING BTREE,
    UNIQUE KEY `email` (`email`) USING BTREE,
    UNIQUE KEY `password_reset_token` (`password_reset_token`) USING BTREE,
    KEY `id` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
  
  -- ----------------------------
  -- Records of admin
  -- ----------------------------
  INSERT INTO `admin` VALUES ('2', 'admin2', 'iuEf0g12cB7yptA6BjaywDi7YgeeZf_c', '$2y$13$SZXQQjXbSCI3g03cZ5ynkOxvUI9WdeElrbIenaB/JVutpcPHq1vpG', null, 'khang@gmail.com', '0123456789', 'Hà Nội', 'Nguyễn Thị Ngân', '1', 'giphy-downsized.gif');
  INSERT INTO `admin` VALUES ('3', 'admin1', 'iuEf0g12cB7yptA6BjaywDi7YgeeZf_c', '$2y$13$SZXQQjXbSCI3g03cZ5ynkOxvUI9WdeElrbIenaB/JVutpcPHq1vpG', null, 'quynhanh@gmail.com', '0123456789', 'Hà Nội', 'Nguyễn Thu Hà', '1', 'giphy-downsized.gif');
  
  -- ----------------------------
  -- Table structure for `attendance`
  -- ----------------------------
  DROP TABLE IF EXISTS `attendance`;
  CREATE TABLE `attendance` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `studentID` int(11) NOT NULL,
    `classID` int(11) NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`id`),
    KEY `studentID` (`studentID`),
    KEY `classID` (`classID`),
    CONSTRAINT `attendance_ibfk_1` FOREIGN KEY (`studentID`) REFERENCES `user` (`id`),
    CONSTRAINT `attendance_ibfk_2` FOREIGN KEY (`classID`) REFERENCES `classes` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- ----------------------------
  -- Records of attendance
  -- ----------------------------
  INSERT INTO `attendance` VALUES ('1', '1', '2', 'Xử lý ảnh_1');
  INSERT INTO `attendance` VALUES ('2', '1', '1', 'Âm nhạc_1');
  INSERT INTO `attendance` VALUES ('3', '1', '3', 'Phương pháp tính_2');
  INSERT INTO `attendance` VALUES ('4', '1', '10', 'Mạng nâng cao_1');
  INSERT INTO `attendance` VALUES ('5', '1', '11', 'Ngôn ngữ hình thức_1');
  INSERT INTO `attendance` VALUES ('6', '1', '15', 'Giải tích 2_1');
  INSERT INTO `attendance` VALUES ('7', '1', '4', 'Kiểm tra đánh giá trong giáo dục');
  INSERT INTO `attendance` VALUES ('8', '1', '7', 'Sử thi_1');
  INSERT INTO `attendance` VALUES ('9', '2', '2', 'Xử lý ảnh_1');
  INSERT INTO `attendance` VALUES ('10', '2', '1', 'Âm nhạc_1');
  INSERT INTO `attendance` VALUES ('11', '2', '3', 'Phương pháp tính_2');
  INSERT INTO `attendance` VALUES ('12', '2', '10', 'Mạng nâng cao_1');
  INSERT INTO `attendance` VALUES ('13', '2', '11', 'Ngôn ngữ hình thức_1');
  INSERT INTO `attendance` VALUES ('14', '2', '15', 'Giải tích 2_1');
  INSERT INTO `attendance` VALUES ('15', '3', '1', 'Âm nhạc_1');
  INSERT INTO `attendance` VALUES ('16', '3', '3', 'Phương pháp tính_2');
  INSERT INTO `attendance` VALUES ('17', '3', '10', 'Mạng nâng cao_1');
  INSERT INTO `attendance` VALUES ('18', '3', '11', 'Ngôn ngữ hình thức_1');
  INSERT INTO `attendance` VALUES ('19', '3', '15', 'Giải tích 2_1');
  INSERT INTO `attendance` VALUES ('20', '4', '2', 'Xử lý ảnh_1');
  INSERT INTO `attendance` VALUES ('21', '5', '2', 'Xử lý ảnh_1');
  INSERT INTO `attendance` VALUES ('22', '6', '2', 'Xử lý ảnh_1');
  INSERT INTO `attendance` VALUES ('40', '7', '2', 'Xử lý ảnh_1');
  INSERT INTO `attendance` VALUES ('42', '1', '2', '');
  
  -- ----------------------------
  -- Table structure for `classes`
  -- ----------------------------
  DROP TABLE IF EXISTS `classes`;
  CREATE TABLE `classes` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `scheduleID` int(11) NOT NULL,
    `teacherID` int(11) NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`id`),
    KEY `scheduleID` (`scheduleID`),
    KEY `teacherID` (`teacherID`),
    CONSTRAINT `classes_ibfk_1` FOREIGN KEY (`scheduleID`) REFERENCES `schedule` (`id`),
    CONSTRAINT `classes_ibfk_2` FOREIGN KEY (`teacherID`) REFERENCES `teacher` (`teacherID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- ----------------------------
  -- Records of classes
  -- ----------------------------
  INSERT INTO `classes` VALUES ('1', '13', '1', 'Âm nhạc');
  INSERT INTO `classes` VALUES ('2', '1', '11', 'Xử lý ảnh');
  INSERT INTO `classes` VALUES ('3', '2', '7', 'Phương pháp tính');
  INSERT INTO `classes` VALUES ('4', '3', '6', 'Kiểm tra đánh giá trong giáo dục');
  INSERT INTO `classes` VALUES ('7', '4', '15', 'Sử thi');
  INSERT INTO `classes` VALUES ('8', '5', '5', 'P.triển chương trình ngữ văn nhà trường');
  INSERT INTO `classes` VALUES ('9', '1', '12', 'Phương pháp tính');
  INSERT INTO `classes` VALUES ('10', '8', '9', 'Mạng nâng cao');
  INSERT INTO `classes` VALUES ('11', '9', '10', 'Ngôn ngữ hình thức');
  INSERT INTO `classes` VALUES ('12', '10', '2', 'Cấu trúc máy tính');
  INSERT INTO `classes` VALUES ('15', '11', '7', 'Giải tích 2');
  INSERT INTO `classes` VALUES ('16', '1', '2', 'A');
  INSERT INTO `classes` VALUES ('17', '1', '15', 'A');
  
  -- ----------------------------
  -- Table structure for `department`
  -- ----------------------------
  DROP TABLE IF EXISTS `department`;
  CREATE TABLE `department` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `department` varchar(256) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`id`),
    KEY `studentID` (`department`(255))
  ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- ----------------------------
  -- Records of department
  -- ----------------------------
  INSERT INTO `department` VALUES ('1', 'Ngữ văn');
  INSERT INTO `department` VALUES ('2', 'Tin');
  INSERT INTO `department` VALUES ('3', 'Toán');
  INSERT INTO `department` VALUES ('4', 'Tiếng anh');
  INSERT INTO `department` VALUES ('5', 'Âm nhạc');
  INSERT INTO `department` VALUES ('6', 'Triết học');
  INSERT INTO `department` VALUES ('7', 'Vật lý');
  INSERT INTO `department` VALUES ('8', 'Hóa học');
  INSERT INTO `department` VALUES ('9', 'Sinh học');
  INSERT INTO `department` VALUES ('10', 'Địa lý');
  INSERT INTO `department` VALUES ('11', 'Công nghệ');
  INSERT INTO `department` VALUES ('12', 'Lịch sử');
  INSERT INTO `department` VALUES ('13', 'Giáo dục chính trị');
  INSERT INTO `department` VALUES ('14', 'Pháp');
  INSERT INTO `department` VALUES ('15', 'Kỹ thuật');
  INSERT INTO `department` VALUES ('16', 'Mỹ thuật ');
  INSERT INTO `department` VALUES ('17', 'Mầm non');
  INSERT INTO `department` VALUES ('18', 'Tiểu học');
  INSERT INTO `department` VALUES ('19', 'Giáo dục đặc biệt');
  INSERT INTO `department` VALUES ('20', 'Quản lý giáo dục');
  INSERT INTO `department` VALUES ('21', 'Quốc phòng');
  INSERT INTO `department` VALUES ('22', 'Việt Nam học');
  INSERT INTO `department` VALUES ('23', 'Tâm lý học');
  INSERT INTO `department` VALUES ('24', 'Công tác xã hội');
  INSERT INTO `department` VALUES ('25', 'Toán');
  
  -- ----------------------------
  -- Table structure for `evalutionform`
  -- ----------------------------
  DROP TABLE IF EXISTS `evalutionform`;
  CREATE TABLE `evalutionform` (
    `attendanceID` int(11) NOT NULL,
    `score` tinyint(3) NOT NULL,
    `date` date NOT NULL,
    `comment` text COLLATE utf8_unicode_ci,
    `answer1` int(11) DEFAULT NULL,
    `answer2` int(11) DEFAULT NULL,
    `answer3` int(11) DEFAULT NULL,
    `answer4` int(11) DEFAULT NULL,
    `answer5` int(11) DEFAULT NULL,
    `answer6` int(11) DEFAULT NULL,
    `answer7` int(11) DEFAULT NULL,
    `answer8` int(11) DEFAULT NULL,
    `answer9` int(11) DEFAULT NULL,
    `answer10` int(11) DEFAULT NULL,
    `answer11` int(11) DEFAULT NULL,
    `answer12` int(11) DEFAULT NULL,
    `answer13` int(11) DEFAULT NULL,
    `answer14` int(11) DEFAULT NULL,
    `answer15` int(11) DEFAULT NULL,
    `answer16` int(11) DEFAULT NULL,
    PRIMARY KEY (`attendanceID`),
    CONSTRAINT `evalutionform_ibfk_1` FOREIGN KEY (`attendanceID`) REFERENCES `attendance` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- ----------------------------
  -- Records of evalutionform
  -- ----------------------------
  INSERT INTO `evalutionform` VALUES ('1', '80', '2019-06-22', '	', '5', '5', '5', '5', '5', '5', '5', '5', '5', '5', '5', '5', '5', '5', '5', '5');
  INSERT INTO `evalutionform` VALUES ('2', '90', '2019-05-19', 'Thầy hay đi có việc bận', '5', '4', '4', '4', '4', '4', '4', '4', null, null, null, null, null, null, null, null);
  INSERT INTO `evalutionform` VALUES ('3', '40', '0000-00-00', null, '5', '3', '3', '3', '3', '3', '3', '3', null, null, null, null, null, null, null, null);
  INSERT INTO `evalutionform` VALUES ('4', '40', '2019-05-19', null, '5', '2', '2', '2', '2', '2', '2', '2', null, null, null, null, null, null, null, null);
  INSERT INTO `evalutionform` VALUES ('5', '60', '2019-05-19', null, '5', '1', '1', '1', '1', '1', '1', '1', null, null, null, null, null, null, null, null);
  INSERT INTO `evalutionform` VALUES ('6', '70', '2019-05-19', null, '5', '1', '1', '1', '1', '1', '1', '1', null, null, null, null, null, null, null, null);
  INSERT INTO `evalutionform` VALUES ('7', '50', '2019-05-19', null, '5', '2', '2', '2', '2', '2', '2', '2', null, null, null, null, null, null, null, null);
  INSERT INTO `evalutionform` VALUES ('8', '45', '2019-05-19', null, '5', '3', '3', '3', '3', '3', '3', '3', null, null, null, null, null, null, null, null);
  INSERT INTO `evalutionform` VALUES ('9', '67', '2019-05-19', null, '5', '4', '4', '4', '4', '4', '4', '4', null, null, null, null, null, null, null, null);
  INSERT INTO `evalutionform` VALUES ('10', '87', '2019-05-19', null, '5', '5', '5', '5', '5', '5', '5', '5', null, null, null, null, null, null, null, null);
  INSERT INTO `evalutionform` VALUES ('11', '78', '2019-05-19', null, '5', '4', '4', '4', '4', '4', '4', '4', null, null, null, null, null, null, null, null);
  INSERT INTO `evalutionform` VALUES ('12', '57', '2019-05-19', null, '5', '3', '3', '3', '3', '3', '3', '3', null, null, null, null, null, null, null, null);
  INSERT INTO `evalutionform` VALUES ('13', '56', '2019-05-19', null, '5', '1', '1', '1', '1', '1', '1', '1', null, null, null, null, null, null, null, null);
  INSERT INTO `evalutionform` VALUES ('14', '98', '2019-05-19', null, '5', '2', '2', '2', '2', '2', '2', '2', null, null, null, null, null, null, null, null);
  INSERT INTO `evalutionform` VALUES ('15', '100', '2019-05-19', null, '5', '3', '3', '3', '3', '3', '3', '3', null, null, null, null, null, null, null, null);
  INSERT INTO `evalutionform` VALUES ('16', '39', '2019-05-19', null, '5', '4', '4', '4', '4', '4', '4', '4', null, null, null, null, null, null, null, null);
  INSERT INTO `evalutionform` VALUES ('17', '56', '2019-05-19', null, '5', '5', '5', '5', '5', '5', '5', '5', null, null, null, null, null, null, null, null);
  INSERT INTO `evalutionform` VALUES ('18', '67', '2019-05-19', null, '5', '3', '3', '3', '3', '3', '3', '3', null, null, null, null, null, null, null, null);
  INSERT INTO `evalutionform` VALUES ('42', '90', '0000-00-00', '', '5', '2', '2', '2', '2', '2', '2', '2', null, null, null, null, null, null, null, null);
  
  -- ----------------------------
  -- Table structure for `major`
  -- ----------------------------
  DROP TABLE IF EXISTS `major`;
  CREATE TABLE `major` (
    `ID` int(11) NOT NULL AUTO_INCREMENT,
    `major` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`ID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- ----------------------------
  -- Records of major
  -- ----------------------------
  INSERT INTO `major` VALUES ('1', 'Tin');
  INSERT INTO `major` VALUES ('2', 'Toan');
  INSERT INTO `major` VALUES ('3', 'Van');
  INSERT INTO `major` VALUES ('4', 'Su');
  
  -- ----------------------------
  -- Table structure for `migration`
  -- ----------------------------
  DROP TABLE IF EXISTS `migration`;
  CREATE TABLE `migration` (
    `version` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
    `apply_time` int(11) DEFAULT NULL,
    PRIMARY KEY (`version`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- ----------------------------
  -- Records of migration
  -- ----------------------------
  INSERT INTO `migration` VALUES ('m000000_000000_base', '1555162386');
  INSERT INTO `migration` VALUES ('m130524_201442_init', '1555162393');
  INSERT INTO `migration` VALUES ('m190413_134049_subjects', '1555166201');
  INSERT INTO `migration` VALUES ('m190413_141922_teacher', '1555166201');
  INSERT INTO `migration` VALUES ('m190413_142005_year', '1555166202');
  
  -- ----------------------------
  -- Table structure for `result`
  -- ----------------------------
  DROP TABLE IF EXISTS `result`;
  CREATE TABLE `result` (
    `classID` int(11) NOT NULL,
    `score` tinyint(3) NOT NULL,
    PRIMARY KEY (`classID`),
    CONSTRAINT `result_ibfk_1` FOREIGN KEY (`classID`) REFERENCES `classes` (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- ----------------------------
  -- Records of result
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `schedule`
  -- ----------------------------
  DROP TABLE IF EXISTS `schedule`;
  CREATE TABLE `schedule` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `semesterID` int(11) NOT NULL,
    `offercode` varchar(11) CHARACTER SET utf8 NOT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    KEY `offercode` (`offercode`),
    KEY `semesterID` (`semesterID`),
    CONSTRAINT `schedule_ibfk_1` FOREIGN KEY (`offercode`) REFERENCES `subjects` (`offercode`),
    CONSTRAINT `schedule_ibfk_2` FOREIGN KEY (`semesterID`) REFERENCES `semester` (`ID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
  
  -- ----------------------------
  -- Records of schedule
  -- ----------------------------
  INSERT INTO `schedule` VALUES ('1', '6', 'COMP 313');
  INSERT INTO `schedule` VALUES ('2', '6', 'MATH 264');
  INSERT INTO `schedule` VALUES ('3', '6', 'PHIL 003');
  INSERT INTO `schedule` VALUES ('4', '6', 'PHIL 416');
  INSERT INTO `schedule` VALUES ('5', '6', 'PHIL 417');
  INSERT INTO `schedule` VALUES ('6', '5', 'COMP 313');
  INSERT INTO `schedule` VALUES ('7', '6', 'POLI 202');
  INSERT INTO `schedule` VALUES ('8', '6', 'COMP 418');
  INSERT INTO `schedule` VALUES ('9', '6', 'COMP 224');
  INSERT INTO `schedule` VALUES ('10', '6', 'COMP 228');
  INSERT INTO `schedule` VALUES ('11', '6', 'COMP 325	');
  INSERT INTO `schedule` VALUES ('12', '6', 'MATH 154');
  INSERT INTO `schedule` VALUES ('13', '6', 'MUSI 109');
  INSERT INTO `schedule` VALUES ('16', '3', 'COMP 325	');
  
  -- ----------------------------
  -- Table structure for `semester`
  -- ----------------------------
  DROP TABLE IF EXISTS `semester`;
  CREATE TABLE `semester` (
    `ID` int(11) NOT NULL AUTO_INCREMENT,
    `year` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`ID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- ----------------------------
  -- Records of semester
  -- ----------------------------
  INSERT INTO `semester` VALUES ('1', 'Kỳ 1 năm 2012');
  INSERT INTO `semester` VALUES ('2', 'Kỳ hè năm 2018');
  INSERT INTO `semester` VALUES ('3', 'Kỳ  2 năm 2018');
  INSERT INTO `semester` VALUES ('4', 'Kỳ 1 năm 2019');
  INSERT INTO `semester` VALUES ('5', 'Kỳ hè năm 2019');
  INSERT INTO `semester` VALUES ('6', 'Kỳ 2 năm 2019');
  
  -- ----------------------------
  -- Table structure for `studentmajors`
  -- ----------------------------
  DROP TABLE IF EXISTS `studentmajors`;
  CREATE TABLE `studentmajors` (
    `studentID` int(11) NOT NULL,
    `departmentID` int(11) NOT NULL,
    `majorID` int(11) NOT NULL,
    KEY `studentID` (`studentID`),
    KEY `departmentID` (`departmentID`),
    KEY `majorID` (`majorID`),
    CONSTRAINT `studentmajors_ibfk_1` FOREIGN KEY (`studentID`) REFERENCES `user` (`id`),
    CONSTRAINT `studentmajors_ibfk_2` FOREIGN KEY (`departmentID`) REFERENCES `department` (`id`),
    CONSTRAINT `studentmajors_ibfk_3` FOREIGN KEY (`majorID`) REFERENCES `major` (`ID`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- ----------------------------
  -- Records of studentmajors
  -- ----------------------------
  INSERT INTO `studentmajors` VALUES ('1', '1', '1');
  INSERT INTO `studentmajors` VALUES ('1', '2', '2');
  
  -- ----------------------------
  -- Table structure for `subjects`
  -- ----------------------------
  DROP TABLE IF EXISTS `subjects`;
  CREATE TABLE `subjects` (
    `offercode` varchar(11) CHARACTER SET utf8 NOT NULL,
    `subjectname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `status` smallint(6) DEFAULT '10',
    `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`offercode`) USING BTREE
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
  
  -- ----------------------------
  -- Records of subjects
  -- ----------------------------
  INSERT INTO `subjects` VALUES ('COMP 224', 'Ngôn ngữ hình thức', '1', null);
  INSERT INTO `subjects` VALUES ('COMP 228', 'Cấu trúc máy tính', '1', null);
  INSERT INTO `subjects` VALUES ('COMP 313', 'Xử lý ảnh', '1', '');
  INSERT INTO `subjects` VALUES ('COMP 325	', 'Bài tập lớn môn học', '1', '');
  INSERT INTO `subjects` VALUES ('COMP 418', 'Mạng máy tính nâng cao', '1', null);
  INSERT INTO `subjects` VALUES ('CT231', '', '10', null);
  INSERT INTO `subjects` VALUES ('MATH 143', 'Xác suất thống kê', '1', null);
  INSERT INTO `subjects` VALUES ('MATH 154', 'Giải tích 2', '1', null);
  INSERT INTO `subjects` VALUES ('MATH 264', 'Phương pháp tính và tối ưu', '1', '');
  INSERT INTO `subjects` VALUES ('MUSI 109', 'Âm nhạc', '1', null);
  INSERT INTO `subjects` VALUES ('PHIL 003', 'Kiểm tra đánh giá trong giáo dục', '1', null);
  INSERT INTO `subjects` VALUES ('PHIL 416', 'Sử thi Việt Nam', '1', null);
  INSERT INTO `subjects` VALUES ('PHIL 417', 'P.triển chương trình ngữ văn nhà trường', '1', '');
  INSERT INTO `subjects` VALUES ('POLI 202', 'Tư tưởng Hồ Chí Minh', '1', '');
  
  -- ----------------------------
  -- Table structure for `teacher`
  -- ----------------------------
  DROP TABLE IF EXISTS `teacher`;
  CREATE TABLE `teacher` (
    `teacherID` int(9) NOT NULL AUTO_INCREMENT,
    `teacherName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `departmentID` int(11) NOT NULL,
    `status` smallint(1) NOT NULL DEFAULT '10',
    `avatar` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`teacherID`),
    KEY `departmentID` (`departmentID`),
    CONSTRAINT `teacher_ibfk_1` FOREIGN KEY (`departmentID`) REFERENCES `department` (`id`),
    CONSTRAINT `teacher_ibfk_2` FOREIGN KEY (`departmentID`) REFERENCES `department` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  
  -- ----------------------------
  -- Records of teacher
  -- ----------------------------
  INSERT INTO `teacher` VALUES ('1', 'Bùi Đình Thọ', '15', '1', '');
  INSERT INTO `teacher` VALUES ('2', 'Vũ Thái Giang', '2', '1', '');
  INSERT INTO `teacher` VALUES ('3', 'Nguyễn Thị Liên', '2', '1', '');
  INSERT INTO `teacher` VALUES ('4', 'Đỗ Thùy Linh', '4', '1', '');
  INSERT INTO `teacher` VALUES ('5', 'Đặng Thị Thu Hiền', '1', '1', '');
  INSERT INTO `teacher` VALUES ('6', 'Phan Thị Lê Dung', '6', '1', '');
  INSERT INTO `teacher` VALUES ('7', 'Nguyễn Thị Liên', '3', '1', null);
  INSERT INTO `teacher` VALUES ('8', 'Phạm Thọ Hoàn', '2', '1', null);
  INSERT INTO `teacher` VALUES ('9', 'Nguyễn Thế Lộc', '2', '1', null);
  INSERT INTO `teacher` VALUES ('10', 'Nguyễn Thị Hồng', '2', '1', null);
  INSERT INTO `teacher` VALUES ('11', 'Vũ Thành Trung', '2', '1', null);
  INSERT INTO `teacher` VALUES ('12', 'Nguyễn Thế Trọng', '3', '1', null);
  INSERT INTO `teacher` VALUES ('15', 'Nguyễn Thế Hùng', '1', '1', null);
  INSERT INTO `teacher` VALUES ('19', 'Đặng Thị Thu Hiền', '17', '1', '');
  
  -- ----------------------------
  -- Table structure for `user`
  -- ----------------------------
  DROP TABLE IF EXISTS `user`;
  CREATE TABLE `user` (
    `id` int(9) NOT NULL AUTO_INCREMENT,
    `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `auth_key` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
    `password_hash` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `password_reset_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `tel` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
    `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `status` smallint(1) NOT NULL DEFAULT '10',
    `avatar` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `batch` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE KEY `username` (`username`) USING BTREE,
    UNIQUE KEY `email` (`email`) USING BTREE,
    UNIQUE KEY `password_reset_token` (`password_reset_token`) USING BTREE,
    KEY `id` (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPACT;
  
  -- ----------------------------
  -- Records of user
  -- ----------------------------
  INSERT INTO `user` VALUES ('1', '665601001', 'iuEf0g12cB7yptA6BjaywDi7YgeeZf_c', '$2y$13$SZXQQjXbSCI3g03cZ5ynkOxvUI9WdeElrbIenaB/JVutpcPHq1vpG', null, 'quynhanh1@gmail.com', '0123456789', 'Hà Nội', 'Hoàng Quỳnh Anh', '1', 'giphy-downsized.gif', '64');
  INSERT INTO `user` VALUES ('2', '665601002', 'iuEf0g12cB7yptA6BjaywDi7YgeeZf_c', '$2y$13$SZXQQjXbSCI3g03cZ5ynkOxvUI9WdeElrbIenaB/JVutpcPHq1vpG', null, 'khang@gmail.com', '0123456789', 'Hà Nội', 'Nguyễn Nhật Khang', '1', 'giphy-downsized.gif', '65');
  INSERT INTO `user` VALUES ('3', '665601003', 'iuEf0g12cB7yptA6BjaywDi7YgeeZf_c', '$2y$13$SZXQQjXbSCI3g03cZ5ynkOxvUI9WdeElrbIenaB/JVutpcPHq1vpG', null, 'myclover@gmail.com', '0123456789', 'Hà Nam', 'Vũ Ánh Dương', '1', 'giphy-downsized.gif', '64');
  INSERT INTO `user` VALUES ('4', '645601004', 'iuEf0g12cB7yptA6BjaywDi7YgeeZf_c', '$2y$13$SZXQQjXbSCI3g03cZ5ynkOxvUI9WdeElrbIenaB/JVutpcPHq1vpG', null, 'duong@gmail.com', '0123456789', 'Nam Định', 'Nguyễn Đình Hoàn', '1', 'giphy-downsized.gif', '66');
  INSERT INTO `user` VALUES ('5', '665601005', 'iuEf0g12cB7yptA6BjaywDi7YgeeZf_c', '$2y$13$SZXQQjXbSCI3g03cZ5ynkOxvUI9WdeElrbIenaB/JVutpcPHq1vpG', null, 'chi@gmail.com', '0123456789', 'Hải Phòng', 'Đào Mai Chi', '1', 'giphy-downsized.gif', '66');
  INSERT INTO `user` VALUES ('6', '665601006', 'iuEf0g12cB7yptA6BjaywDi7YgeeZf_c', '$2y$13$SZXQQjXbSCI3g03cZ5ynkOxvUI9WdeElrbIenaB/JVutpcPHq1vpG', null, 'xuyen@gmail.com', '0123456789', 'Hải Phòng', 'Vũ Thị Kim Xuyến', '1', 'giphy-downsized.gif', '66');
  INSERT INTO `user` VALUES ('7', '665601007', 'iuEf0g12cB7yptA6BjaywDi7YgeeZf_c', '$2y$13$SZXQQjXbSCI3g03cZ5ynkOxvUI9WdeElrbIenaB/JVutpcPHq1vpG', null, 'long@gmail.com', '0123456789', 'Nam Định', 'Nguyễn Nhật Long', '1', 'giphy-downsized.gif', '66');
  INSERT INTO `user` VALUES ('8', '665601008', 'iuEf0g12cB7yptA6BjaywDi7YgeeZf_c', '$2y$13$SZXQQjXbSCI3g03cZ5ynkOxvUI9WdeElrbIenaB/JVutpcPHq1vpG', null, 'nam@gmail.com', '0123456789', 'Hà Nội', 'Nguyễn Hoàng Nam', '1', 'giphy-downsized.gif', '66');
  INSERT INTO `user` VALUES ('9', '665601009', 'iuEf0g12cB7yptA6BjaywDi7YgeeZf_c', '$2y$13$SZXQQjXbSCI3g03cZ5ynkOxvUI9WdeElrbIenaB/JVutpcPHq1vpG', null, 'cong@gmail.com', '0123456789', 'Hà Nội', 'Vũ Thành Công', '1', 'giphy-downsized.gif', '66');
  