/*
 Navicat MySQL Data Transfer

 Source Server         : lianwei
 Source Server Type    : MySQL
 Source Server Version : 50553
 Source Host           : localhost:3306
 Source Schema         : sushe

 Target Server Type    : MySQL
 Target Server Version : 50553
 File Encoding         : 65001

 Date: 02/07/2019 00:46:27
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (
  `Admin_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Admin_Username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Admin_Password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Admin_Name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Admin_Sex` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Admin_Tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`Admin_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES (1, 'admin', 'admin', '罗方', '男', '15079110117');
INSERT INTO `admin` VALUES (2, 'admin1', 'admin1', '单爽', '女', '15322445689');
INSERT INTO `admin` VALUES (3, 'admin2', 'admin2', '赵文轩', '男', '18970581279');
INSERT INTO `admin` VALUES (4, 'admin3', 'admin3', '罗旭东', '男', '15352851258');
INSERT INTO `admin` VALUES (5, 'admin4', 'admin4', '吴青青', '女', '15589851702');
INSERT INTO `admin` VALUES (6, 'admin5', 'admin5', '邹子政', '男', '17258051285');
INSERT INTO `admin` VALUES (7, 'admin6', 'admin6', '刘建阳', '男', '18022981105');
INSERT INTO `admin` VALUES (8, 'admin7', 'admin7', '张欢', '女', '17755081297');
INSERT INTO `admin` VALUES (9, 'admin8', 'admin8', '刘泽', '男', '18950781259');
INSERT INTO `admin` VALUES (10, 'admin9', 'admin9', '涂龙龙', '男', '15278469958');
INSERT INTO `admin` VALUES (11, 'admin10', 'admin10', '刘世瑞', '男', '17598501248');
INSERT INTO `admin` VALUES (12, 'admin11', 'admin11', '邱佳威', '男', '18870589468');
INSERT INTO `admin` VALUES (13, 'admin12', 'admin12', '罗旭欣', '女', '15877592479');
INSERT INTO `admin` VALUES (14, 'admin13', 'admin13', '郑子成', '男', '17955084579');
INSERT INTO `admin` VALUES (15, 'admin14', 'admin14', '涂威', '男', '15822067946');
INSERT INTO `admin` VALUES (16, 'admin15', 'admin15', '罗龙', '男', '18870586429');
INSERT INTO `admin` VALUES (17, 'admin16', 'admin16', '刘韩湘', '女', '15344791279');
INSERT INTO `admin` VALUES (18, 'admin17', 'admin17', '戴志远', '男', '17956891246');
INSERT INTO `admin` VALUES (19, 'admin18', 'admin18', '余坤龙	', '男', '15501347856');
INSERT INTO `admin` VALUES (20, 'admin19', 'admin19', '朱承毅', '男', '18970581246');

-- ----------------------------
-- Table structure for building
-- ----------------------------
DROP TABLE IF EXISTS `building`;
CREATE TABLE `building`  (
  `Building_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Building_Name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Building_Introduction` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`Building_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of building
-- ----------------------------
INSERT INTO `building` VALUES (1, '学生公寓01楼', '男生宿舍');
INSERT INTO `building` VALUES (2, '学生公寓02楼', '男生宿舍');
INSERT INTO `building` VALUES (3, '学生公寓03楼', '女生宿舍');
INSERT INTO `building` VALUES (4, '学生公寓04楼', '女生宿舍');
INSERT INTO `building` VALUES (5, '学生公寓05楼', '女生宿舍');
INSERT INTO `building` VALUES (6, '学生公寓06楼', '男生宿舍');
INSERT INTO `building` VALUES (7, '学生公寓07楼', '男生宿舍');
INSERT INTO `building` VALUES (8, '学生公寓08楼', '男生宿舍');
INSERT INTO `building` VALUES (9, '学生公寓09楼', '女生宿舍');
INSERT INTO `building` VALUES (10, '学生公寓10楼', '男生宿舍');
INSERT INTO `building` VALUES (11, '学生公寓11楼', '女生宿舍');
INSERT INTO `building` VALUES (12, '学生公寓12楼', '女生宿舍');
INSERT INTO `building` VALUES (13, '学生公寓13楼', '男生宿舍');
INSERT INTO `building` VALUES (14, '学生公寓14楼', '男生宿舍');
INSERT INTO `building` VALUES (15, '学生公寓15楼', '男生宿舍');
INSERT INTO `building` VALUES (16, '学生公寓16楼', '女生宿舍');
INSERT INTO `building` VALUES (17, '学生公寓17楼', '女生宿舍');
INSERT INTO `building` VALUES (18, '学生公寓18楼', '男生宿舍');
INSERT INTO `building` VALUES (19, '学生公寓19楼', '男生宿舍');
INSERT INTO `building` VALUES (20, '学生公寓20楼', '男生宿舍');
INSERT INTO `building` VALUES (21, '学生公寓21楼', '男生宿舍');

-- ----------------------------
-- Table structure for domitory
-- ----------------------------
DROP TABLE IF EXISTS `domitory`;
CREATE TABLE `domitory`  (
  `Domitory_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Domitory_BuildingID` int(11) NULL DEFAULT NULL,
  `Domitory_Name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Domitory_Type` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Domitory_Number` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Domitory_Tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`Domitory_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 241 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of domitory
-- ----------------------------
INSERT INTO `domitory` VALUES (1, 1, '毛欣', '四人寝', '01-1-101', '18979920069');
INSERT INTO `domitory` VALUES (2, 1, '肖清华', '四人寝', '01-1-102', '15070853621');
INSERT INTO `domitory` VALUES (3, 1, '符卓亮', '四人寝', '01-1-103', '18507013373');
INSERT INTO `domitory` VALUES (4, 1, '徐齐齐', '四人寝', '01-1-104', '15070850032');
INSERT INTO `domitory` VALUES (5, 1, '辛鄢放', '四人寝', '01-1-105', '18296897841');
INSERT INTO `domitory` VALUES (6, 1, '孙寅杰', '四人寝', '01-1-106', '18797918106');
INSERT INTO `domitory` VALUES (7, 1, '王欣怡', '四人寝', '01-1-107', '15879662874');
INSERT INTO `domitory` VALUES (8, 1, '邓依依', '四人寝', '01-1-108', '18797812112');
INSERT INTO `domitory` VALUES (9, 1, '纪嵚崟 ', '四人寝', '01-1-109', '13479558563');
INSERT INTO `domitory` VALUES (10, 1, '潘乔峰', '四人寝', '01-1-110', '18702626739');
INSERT INTO `domitory` VALUES (11, 1, '胡梦玲 ', '四人寝', '01-1-111', '18379141904');
INSERT INTO `domitory` VALUES (12, 1, '刘轶鹏', '四人寝', '01-1-112', '15079434718');
INSERT INTO `domitory` VALUES (13, 2, '王宏午', '四人寝', '02-2-101', '15679165047');
INSERT INTO `domitory` VALUES (14, 2, '揭剑', '四人寝', '02-2-102', '18507063816');
INSERT INTO `domitory` VALUES (15, 2, '徐子龙', '四人寝', '02-2-103', '13767023410');
INSERT INTO `domitory` VALUES (16, 2, '柴世琪', '四人寝', '02-2-104', '18170562295');
INSERT INTO `domitory` VALUES (17, 2, '叶颖文', '四人寝', '02-2-105', '18702505570');
INSERT INTO `domitory` VALUES (18, 2, '言文俊', '四人寝', '02-2-106', '15279188661');
INSERT INTO `domitory` VALUES (19, 2, '陆俊名 ', '四人寝', '02-2-107', '18702627215');
INSERT INTO `domitory` VALUES (20, 2, '周启帆', '四人寝', '02-2-108', '15779672439');
INSERT INTO `domitory` VALUES (21, 2, '郭咏梅', '四人寝', '02-2-109', '15779113459');
INSERT INTO `domitory` VALUES (22, 2, '谭泽华', '四人寝', '02-2-110', '18702502145');
INSERT INTO `domitory` VALUES (23, 2, '邓立', '四人寝', '02-2-111', '15179110533');
INSERT INTO `domitory` VALUES (24, 2, '李佳', '四人寝', '02-2-112', '18770813193');
INSERT INTO `domitory` VALUES (25, 3, '李诗椿', '四人寝', '03-2-101', '18797817156');
INSERT INTO `domitory` VALUES (26, 3, '陈志明', '四人寝', '03-2-102', '15270914833');
INSERT INTO `domitory` VALUES (27, 3, '王鑫', '四人寝', '03-2-103', '18720933583');
INSERT INTO `domitory` VALUES (28, 3, '刘鑫', '四人寝', '03-2-104', '13667914165');
INSERT INTO `domitory` VALUES (29, 3, '罗志成', '四人寝', '03-2-105', '13879173767');
INSERT INTO `domitory` VALUES (30, 3, '王冲', '四人寝', '03-2-106', '13979925090');
INSERT INTO `domitory` VALUES (31, 3, '王国雄', '四人寝', '03-2-107', '18720933031');
INSERT INTO `domitory` VALUES (32, 3, '桑诚', '四人寝', '03-2-108', '18816405758');
INSERT INTO `domitory` VALUES (33, 3, '袁国庆', '四人寝', '03-2-109', '18702629244');
INSERT INTO `domitory` VALUES (34, 3, '吴萍', '四人寝', '03-2-110', '15297713360');
INSERT INTO `domitory` VALUES (35, 3, '敖良', '四人寝', '03-2-111', '18797817807');
INSERT INTO `domitory` VALUES (36, 3, '廖高兴', '四人寝', '03-2-112', '18797817918');
INSERT INTO `domitory` VALUES (37, 4, '欧阳龙平', '四人寝', '04-1-101', '13047901290');
INSERT INTO `domitory` VALUES (38, 4, '万程和', '四人寝', '04-1-102', '15779181368');
INSERT INTO `domitory` VALUES (39, 4, '王丽凤', '四人寝', '04-1-103', '13177851656');
INSERT INTO `domitory` VALUES (40, 4, '胡文星', '四人寝', '04-1-104', '18679651258');
INSERT INTO `domitory` VALUES (41, 4, '万胜华', '四人寝', '04-1-105', '18770154903');
INSERT INTO `domitory` VALUES (42, 4, '周衍琨', '四人寝', '04-1-106', '18797957415');
INSERT INTO `domitory` VALUES (43, 4, '洪家伟', '四人寝', '04-1-107', '15070099896');
INSERT INTO `domitory` VALUES (44, 4, '徐礼飞', '四人寝', '04-1-108', '18170058940');
INSERT INTO `domitory` VALUES (45, 4, '谢章康', '四人寝', '04-1-109', '15270093171');
INSERT INTO `domitory` VALUES (46, 4, '谢小波', '四人寝', '04-1-110', '18797816882');
INSERT INTO `domitory` VALUES (47, 4, '刘义贤', '四人寝', '04-1-111', '13672219281');
INSERT INTO `domitory` VALUES (48, 4, ' 宋子繁 ', '四人寝', '04-1-112', '13732999774');
INSERT INTO `domitory` VALUES (50, 5, '胡师坤', '四人寝', '05-1-101', '18279159258');
INSERT INTO `domitory` VALUES (51, 5, '张志刚', '四人寝', '05-1-102', '15870032939');
INSERT INTO `domitory` VALUES (52, 5, '王军', '四人寝', '05-1-103', '18296164357');
INSERT INTO `domitory` VALUES (53, 5, '陈贞颖', '四人寝', '05-1-104', '18070543661');
INSERT INTO `domitory` VALUES (54, 5, '汪亦文', '四人寝', '05-1-105', '18279159423');
INSERT INTO `domitory` VALUES (55, 5, '尹明', '四人寝', '05-1-106', '18720946098');
INSERT INTO `domitory` VALUES (56, 5, '李勤', '四人寝', '05-1-107', '13247760867');
INSERT INTO `domitory` VALUES (57, 5, ' 傅文杰', '四人寝', '05-1-108', '18296166009');
INSERT INTO `domitory` VALUES (58, 5, '周易伟', '四人寝', '05-1-109', '15079037056');
INSERT INTO `domitory` VALUES (59, 5, '艾佳明', '四人寝', '05-1-110', '18702629412');
INSERT INTO `domitory` VALUES (60, 5, '吴革', '四人寝', '05-1-111', '18279196196');
INSERT INTO `domitory` VALUES (61, 5, '胡文雍', '四人寝', '05-1-112', '18720932007');
INSERT INTO `domitory` VALUES (62, 6, '郭继聪', '六人寝', '06-1-101', '15070093523');
INSERT INTO `domitory` VALUES (63, 6, '廖鑫明', '六人寝', '06-1-102', '13307089590');
INSERT INTO `domitory` VALUES (64, 6, '刘帅', '六人寝', '06-1-103', '13876986321');
INSERT INTO `domitory` VALUES (65, 6, '汤启华', '六人寝', '06-1-104', '15279182182');
INSERT INTO `domitory` VALUES (66, 6, '徐畅', '六人寝', '06-1-105', '18702502528');
INSERT INTO `domitory` VALUES (67, 6, '刘啸可', '六人寝', '06-1-106', '18879209391');
INSERT INTO `domitory` VALUES (68, 6, '万云锋', '六人寝', '06-1-107', '18279159421');
INSERT INTO `domitory` VALUES (69, 6, '宋玉成', '六人寝', '06-1-108', '18870915750');
INSERT INTO `domitory` VALUES (70, 6, '李雯慧', '六人寝', '06-1-109', '15170790932');
INSERT INTO `domitory` VALUES (71, 6, '彭普原', '六人寝', '06-1-110', '18296169424');
INSERT INTO `domitory` VALUES (72, 6, '赵丹晟宇', '六人寝', '06-1-111', '18702626790');
INSERT INTO `domitory` VALUES (73, 6, '王好燚鹰', '六人寝', '06-1-112', '18702505196');
INSERT INTO `domitory` VALUES (74, 7, '郭成', '六人寝', '07-2-101', '18679433386');
INSERT INTO `domitory` VALUES (75, 7, '万维先', '六人寝', '07-2-102', '18397919667');
INSERT INTO `domitory` VALUES (76, 7, '马鑫林', '六人寝', '07-2-103', '18702508156');
INSERT INTO `domitory` VALUES (77, 7, '郑慧铭 ', '六人寝', '07-2-104', '15279187100');
INSERT INTO `domitory` VALUES (78, 7, '陈圆圆 ', '六人寝', '07-2-105', '18289280359');
INSERT INTO `domitory` VALUES (79, 7, '邵欣 ', '六人寝', '07-2-106', '13437008494');
INSERT INTO `domitory` VALUES (80, 7, '熊迁迁 ', '六人寝', '07-2-107', '15179162143');
INSERT INTO `domitory` VALUES (81, 7, '饶歌 ', '六人寝', '07-2-108', '18797817102');
INSERT INTO `domitory` VALUES (82, 7, '朱晨炜 ', '六人寝', '07-2-109', '18279159260');
INSERT INTO `domitory` VALUES (83, 7, '廖建军 ', '六人寝', '07-2-110', '15170230426');
INSERT INTO `domitory` VALUES (84, 7, '谢主恩 ', '六人寝', '07-2-111', '15970112618');
INSERT INTO `domitory` VALUES (85, 7, '王呈炜 ', '六人寝', '07-2-112', '15797701846');
INSERT INTO `domitory` VALUES (86, 8, '刘畅 ', '六人寝', '08-2-101', '15270804725');
INSERT INTO `domitory` VALUES (87, 8, '胡高鹏 ', '六人寝', '08-2-102', '17607094826');
INSERT INTO `domitory` VALUES (88, 8, '帅志强 ', '六人寝', '08-2-103', '15979179745');
INSERT INTO `domitory` VALUES (89, 8, '刘灵杰 ', '六人寝', '08-2-104', '15797655100');
INSERT INTO `domitory` VALUES (90, 8, '刘亮 ', '六人寝', '08-2-105', '13970301725');
INSERT INTO `domitory` VALUES (91, 8, '陶鹏 ', '六人寝', '08-2-106', '17779137906');
INSERT INTO `domitory` VALUES (92, 8, '习善新 ', '六人寝', '08-2-107', '15170034633');
INSERT INTO `domitory` VALUES (93, 8, '王铭凯 ', '六人寝', '08-2-108', '15170221019');
INSERT INTO `domitory` VALUES (94, 8, '周端端', '六人寝', '08-2-109', '15797656007');
INSERT INTO `domitory` VALUES (95, 8, '黄锐', '六人寝', '08-2-110', '13767672616');
INSERT INTO `domitory` VALUES (96, 8, '付北晨', '六人寝', '08-2-111', '13065133827');
INSERT INTO `domitory` VALUES (97, 8, '邓程明', '六人寝', '08-2-112', '15797653230');
INSERT INTO `domitory` VALUES (98, 9, '吴江南', '六人寝', '09-2-101', '18770164049');
INSERT INTO `domitory` VALUES (99, 9, '祝达昌', '六人寝', '09-2-102', '18720785041');
INSERT INTO `domitory` VALUES (100, 9, '余毛', '六人寝', '09-2-103', '15797638657');
INSERT INTO `domitory` VALUES (101, 9, '孔令彪', '六人寝', '09-2-104', '15797653989');
INSERT INTO `domitory` VALUES (102, 9, '王志轩', '六人寝', '09-2-105', '15797700594');
INSERT INTO `domitory` VALUES (103, 9, '骆袁凯', '六人寝', '09-2-106', '15279692121');
INSERT INTO `domitory` VALUES (104, 9, '宋涵喆', '六人寝', '09-2-107', '15797650167');
INSERT INTO `domitory` VALUES (105, 9, '龙易', '六人寝', '09-2-108', '15279533907');
INSERT INTO `domitory` VALUES (106, 9, '徐州辉', '六人寝', '09-2-109', '18770323221');
INSERT INTO `domitory` VALUES (107, 9, '许鹏飞', '六人寝', '09-2-110', '15797656705');
INSERT INTO `domitory` VALUES (108, 9, '谢志伟', '六人寝', '09-2-111', '13155810105');
INSERT INTO `domitory` VALUES (109, 9, '王子豪', '六人寝', '09-2-112', '15070932131');
INSERT INTO `domitory` VALUES (110, 10, '严俊琳', '六人寝', '10-1-101', '18702614167');
INSERT INTO `domitory` VALUES (111, 10, '雷永', '六人寝', '10-1-102', '15070182204');
INSERT INTO `domitory` VALUES (112, 10, '吴明昫', '六人寝', '10-1-103', '15797639201');
INSERT INTO `domitory` VALUES (113, 10, '曾琪', '六人寝', '10-1-104', '15970533692');
INSERT INTO `domitory` VALUES (114, 10, '仝炳蔚', '六人寝', '10-1-105', '13767157255');
INSERT INTO `domitory` VALUES (115, 10, '雷城', '六人寝', '10-1-106', '15070649371');
INSERT INTO `domitory` VALUES (116, 10, '郝志强', '六人寝', '10-1-107', '15079000206');
INSERT INTO `domitory` VALUES (117, 10, '张博凡', '六人寝', '10-1-108', '15797638702');
INSERT INTO `domitory` VALUES (118, 10, '蔡文毅', '六人寝', '10-1-109', '17779148491');
INSERT INTO `domitory` VALUES (119, 10, '杜伟', '六人寝', '10-1-110', '15070701859');
INSERT INTO `domitory` VALUES (120, 10, '涂昊', '六人寝', '10-1-111', '13657945231');
INSERT INTO `domitory` VALUES (121, 10, '刘刚', '六人寝', '10-1-112', '18720325211');
INSERT INTO `domitory` VALUES (122, 11, '胡洪博', '八人寝', '11-1-101', '18720807204');
INSERT INTO `domitory` VALUES (123, 11, '柳乔晖', '八人寝', '11-1-102', '13155806819');
INSERT INTO `domitory` VALUES (124, 11, '吴金琨', '八人寝', '11-1-103', '15797655006');
INSERT INTO `domitory` VALUES (125, 11, '毛彪勇', '八人寝', '11-1-104', '15607901226');
INSERT INTO `domitory` VALUES (126, 11, '袁赐', '八人寝', '11-1-105', '18317962601');
INSERT INTO `domitory` VALUES (127, 11, '邓超毅', '八人寝', '11-1-106', '15797656062');
INSERT INTO `domitory` VALUES (128, 11, '邹翔', '八人寝', '11-1-107', '18870111996');
INSERT INTO `domitory` VALUES (129, 11, '李铸坤', '八人寝', '11-1-108', '18779304300');
INSERT INTO `domitory` VALUES (130, 11, '傅凯', '八人寝', '11-1-109', '17779148533');
INSERT INTO `domitory` VALUES (131, 11, '柯恒', '八人寝', '11-1-110', '\" 15797651971');
INSERT INTO `domitory` VALUES (132, 11, '任浩', '八人寝', '11-1-111', '\"');
INSERT INTO `domitory` VALUES (133, 11, '邓林俊', '八人寝', '11-1-112', '18779930136');
INSERT INTO `domitory` VALUES (134, 12, '巫超', '八人寝', '12-1-101', '15797701470');
INSERT INTO `domitory` VALUES (135, 12, '胡建', '八人寝', '12-1-102', '15932936742');
INSERT INTO `domitory` VALUES (136, 12, '王子宁', '八人寝', '12-1-103', '15797655660');
INSERT INTO `domitory` VALUES (137, 12, '李志强', '八人寝', '12-1-104', '15797727094');
INSERT INTO `domitory` VALUES (138, 12, '李鑫', '八人寝', '12-1-105', '18779993910');
INSERT INTO `domitory` VALUES (139, 12, '陈志文', '八人寝', '12-1-106', '15007011282');
INSERT INTO `domitory` VALUES (140, 12, '彭旭龙', '八人寝', '12-1-107', '15797650596');
INSERT INTO `domitory` VALUES (141, 12, '习晋', '八人寝', '12-1-108', '15979814542');
INSERT INTO `domitory` VALUES (142, 12, '刘影', '八人寝', '12-1-109', '18279205058');
INSERT INTO `domitory` VALUES (143, 12, '史泰龙', '八人寝', '12-1-110', '18779432031');
INSERT INTO `domitory` VALUES (144, 12, '曹新亚', '八人寝', '12-1-111', '15979169044');
INSERT INTO `domitory` VALUES (145, 12, '姜煜', '八人寝', '12-1-112', '13576063202');
INSERT INTO `domitory` VALUES (146, 13, '夏庆强', '八人寝', '13-1-101', '15079125843');
INSERT INTO `domitory` VALUES (147, 13, '龚剑', '八人寝', '13-1-102', '17779148522');
INSERT INTO `domitory` VALUES (148, 13, '陶志', '八人寝', '13-1-103', '13627088052');
INSERT INTO `domitory` VALUES (149, 13, '胡元正', '八人寝', '13-1-104', '18279319376');
INSERT INTO `domitory` VALUES (150, 13, '金浩', '八人寝', '13-1-105', '15797652732');
INSERT INTO `domitory` VALUES (151, 13, '程希洋', '八人寝', '13-1-106', '13307005160');
INSERT INTO `domitory` VALUES (152, 13, '周子琦', '八人寝', '13-1-107', '15170035204');
INSERT INTO `domitory` VALUES (153, 13, '杨逸哲', '八人寝', '13-1-108', '15797704351');
INSERT INTO `domitory` VALUES (154, 13, '舒庆', '八人寝', '13-1-109', '17779148490');
INSERT INTO `domitory` VALUES (155, 13, '曾令伟', '八人寝', '13-1-110', '15070398311');
INSERT INTO `domitory` VALUES (156, 13, '刘辉', '八人寝', '13-1-111', '18720495925');
INSERT INTO `domitory` VALUES (157, 13, '曹祖旭', '八人寝', '13-1-112', '15180685128');
INSERT INTO `domitory` VALUES (158, 14, '李涛', '八人寝', '14-2-101', '17779148525');
INSERT INTO `domitory` VALUES (159, 14, '龚文军', '八人寝', '14-2-102', '13697915256');
INSERT INTO `domitory` VALUES (160, 14, '陈通通', '八人寝', '14-2-103', '15797698848');
INSERT INTO `domitory` VALUES (161, 14, '冯文昌', '八人寝', '14-2-104', '15779939930');
INSERT INTO `domitory` VALUES (162, 14, '曾明亮', '八人寝', '14-2-105', '15797657305');
INSERT INTO `domitory` VALUES (163, 14, '张志赟', '八人寝', '14-2-106', '18879582046');
INSERT INTO `domitory` VALUES (164, 14, '陈鹏飞', '八人寝', '14-2-107', '18925385696');
INSERT INTO `domitory` VALUES (165, 14, '刘仲奇', '八人寝', '14-2-108', '15797694138');
INSERT INTO `domitory` VALUES (166, 14, '李鑫鑫', '八人寝', '14-2-109', '13697090130');
INSERT INTO `domitory` VALUES (167, 14, '戴锟', '八人寝', '14-2-110', '15797868127');
INSERT INTO `domitory` VALUES (168, 14, '杨明杰', '八人寝', '14-2-111', '18146748337');
INSERT INTO `domitory` VALUES (169, 14, '朱振远', '八人寝', '14-2-112', '15170234764');
INSERT INTO `domitory` VALUES (170, 15, '涂琛', '八人寝', '15-2-101', '18279123741');
INSERT INTO `domitory` VALUES (171, 15, '周磐', '八人寝', '15-2-102', '15870955365');
INSERT INTO `domitory` VALUES (172, 15, '钟文精', '八人寝', '15-2-103', '13767203485');
INSERT INTO `domitory` VALUES (173, 15, '徐啸剑', '八人寝', '15-2-104', '15797655503');
INSERT INTO `domitory` VALUES (174, 15, '朱青山', '八人寝', '15-2-105', '18879492883');
INSERT INTO `domitory` VALUES (175, 15, '周芳浓', '八人寝', '15-2-106', '15216134966');
INSERT INTO `domitory` VALUES (176, 15, '陶思佳 ', '八人寝', '15-2-107', '15909460996');
INSERT INTO `domitory` VALUES (177, 15, '李娜 ', '八人寝', '15-2-108', '18770013327');
INSERT INTO `domitory` VALUES (178, 15, '沈宁 ', '八人寝', '15-2-109', '15797656009');
INSERT INTO `domitory` VALUES (179, 15, '蔡乐 ', '八人寝', '15-2-110', '18279905201');
INSERT INTO `domitory` VALUES (180, 15, '杨惠子 ', '八人寝', '15-2-111', '18179705356');
INSERT INTO `domitory` VALUES (181, 15, '张洁清 ', '八人寝', '15-2-112', '15350204931');
INSERT INTO `domitory` VALUES (182, 16, '谢玮卿 ', '四人寝', '16-2-101', '15970884113');
INSERT INTO `domitory` VALUES (183, 16, '肖群 ', '四人寝', '16-2-102', '15979126243');
INSERT INTO `domitory` VALUES (184, 16, '汪政颖 ', '四人寝', '16-2-103', '17370044913');
INSERT INTO `domitory` VALUES (185, 16, '黄文 ', '四人寝', '16-2-104', '15180401120');
INSERT INTO `domitory` VALUES (186, 16, '王子欣 ', '四人寝', '16-2-105', '13755553595');
INSERT INTO `domitory` VALUES (187, 16, '徐斌 ', '四人寝', '16-2-106', '15797868356');
INSERT INTO `domitory` VALUES (188, 16, '任庆麟 ', '四人寝', '16-2-107', '15079254030');
INSERT INTO `domitory` VALUES (189, 16, '宗云良 ', '四人寝', '16-2-108', '13507094849');
INSERT INTO `domitory` VALUES (190, 16, '杜文强 ', '四人寝', '16-2-109', '18779932872');
INSERT INTO `domitory` VALUES (191, 16, '况海萍 ', '四人寝', '16-2-110', '15679163268');
INSERT INTO `domitory` VALUES (192, 16, '张鑫 ', '四人寝', '16-2-111', '18279515734');
INSERT INTO `domitory` VALUES (193, 16, '钟春福 ', '四人寝', '16-2-112', '18770091269');
INSERT INTO `domitory` VALUES (194, 17, '魏同同 ', '四人寝', '17-2-101', '13237007676');
INSERT INTO `domitory` VALUES (195, 17, '江冬冬 ', '四人寝', '17-2-102', '15970665498');
INSERT INTO `domitory` VALUES (196, 17, '曹京 ', '四人寝', '17-2-103', '18720415612');
INSERT INTO `domitory` VALUES (197, 17, '黄凯 ', '四人寝', '17-2-104', '13397914205');
INSERT INTO `domitory` VALUES (198, 17, '曾岩 ', '四人寝', '17-2-105', '15269005209');
INSERT INTO `domitory` VALUES (199, 17, '梁梓锟 ', '四人寝', '17-2-106', '15007934056');
INSERT INTO `domitory` VALUES (200, 17, '万露峰 ', '四人寝', '17-2-107', '15797653362');
INSERT INTO `domitory` VALUES (201, 17, '蒋文雄 ', '四人寝', '17-2-108', '18720944514');
INSERT INTO `domitory` VALUES (202, 17, '管文航 ', '四人寝', '17-2-109', '13155807720');
INSERT INTO `domitory` VALUES (203, 17, '徐江华 ', '四人寝', '17-2-110', '13237007707');
INSERT INTO `domitory` VALUES (204, 17, '章小军 ', '四人寝', '17-2-111', '13767645818');
INSERT INTO `domitory` VALUES (205, 17, ' 陈卓', '四人寝', '17-2-112', '15079654394');
INSERT INTO `domitory` VALUES (206, 18, '尚骏 ', '四人寝', '18-2-101', '15779992209');
INSERT INTO `domitory` VALUES (207, 18, '朱磊', '四人寝', '18-2-102', '18162173509');
INSERT INTO `domitory` VALUES (208, 18, '薄雪晴', '四人寝', '18-2-103', '15070883212');
INSERT INTO `domitory` VALUES (209, 18, '陈婉卿', '四人寝', '18-2-104', '15797694133');
INSERT INTO `domitory` VALUES (210, 18, '郭仕聪', '四人寝', '18-2-105', '15279318036');
INSERT INTO `domitory` VALUES (211, 18, '王晓杰 ', '四人寝', '18-2-106', '18079803007');
INSERT INTO `domitory` VALUES (212, 18, '张佳丽 ', '四人寝', '18-2-107', '18279699658');
INSERT INTO `domitory` VALUES (213, 18, '牛嘉靖 ', '四人寝', '18-2-108', '15907934377');
INSERT INTO `domitory` VALUES (214, 18, '唐姜颖 ', '四人寝', '18-2-109', '15179537282');
INSERT INTO `domitory` VALUES (215, 18, '钟琼怡 ', '四人寝', '18-2-110', '18296312130');
INSERT INTO `domitory` VALUES (216, 18, '王玥 ', '四人寝', '18-2-111', '15397914546');
INSERT INTO `domitory` VALUES (217, 18, '刘蕾妮 ', '四人寝', '18-2-112', '18770764364');
INSERT INTO `domitory` VALUES (218, 19, '谢旻毓 ', '四人寝', '19-2-101', '15779137595');
INSERT INTO `domitory` VALUES (219, 19, '肖紫微 ', '四人寝', '19-2-102', '18770065530');
INSERT INTO `domitory` VALUES (220, 19, '杨佳煜 ', '四人寝', '19-2-103', '15180156243');
INSERT INTO `domitory` VALUES (221, 19, '李耀 ', '四人寝', '19-2-104', '15070812892');
INSERT INTO `domitory` VALUES (222, 19, '熊军 ', '四人寝', '19-2-105', '15170034357');
INSERT INTO `domitory` VALUES (223, 19, '刘晨 ', '四人寝', '19-2-106', '13879390753');
INSERT INTO `domitory` VALUES (224, 19, '杨庆豫 ', '四人寝', '19-2-107', '15797650608');
INSERT INTO `domitory` VALUES (225, 19, '方成超 ', '四人寝', '19-2-108', '18779936126');
INSERT INTO `domitory` VALUES (226, 19, '荣浩 ', '四人寝', '19-2-109', '18807024835');
INSERT INTO `domitory` VALUES (227, 19, '吴亦洲 ', '四人寝', '19-2-110', '15679781928');
INSERT INTO `domitory` VALUES (228, 19, '琚冠男 ', '四人寝', '19-2-111', '15979255942');
INSERT INTO `domitory` VALUES (229, 19, '甘文海 ', '四人寝', '19-2-112', '13755613917');
INSERT INTO `domitory` VALUES (230, 20, '张渊博 ', '四人寝', '20-2-101', '15797701304');
INSERT INTO `domitory` VALUES (231, 20, '曾翀洲 ', '四人寝', '20-2-102', '15083715010');
INSERT INTO `domitory` VALUES (232, 20, '严平 ', '四人寝', '20-2-103', '15070029115');
INSERT INTO `domitory` VALUES (233, 20, '黄鹏 ', '四人寝', '20-2-104', '15070460577');
INSERT INTO `domitory` VALUES (234, 20, '杨爱民 ', '四人寝', '20-2-105', '18770208807');
INSERT INTO `domitory` VALUES (235, 20, '涂涛 ', '四人寝', '20-2-106', '18370677087');
INSERT INTO `domitory` VALUES (236, 20, '钟诚 ', '四人寝', '20-2-107', '15070063317');
INSERT INTO `domitory` VALUES (237, 20, '毛勇进 ', '四人寝', '20-2-108', '15797653595');
INSERT INTO `domitory` VALUES (238, 20, '徐剑聪 ', '四人寝', '20-2-109', '15797652928');
INSERT INTO `domitory` VALUES (239, 20, '周仰 ', '四人寝', '20-2-110', '15297979875');
INSERT INTO `domitory` VALUES (240, 20, '万苗云', '四人寝', '20-2-111', '13407968215');

-- ----------------------------
-- Table structure for log
-- ----------------------------
DROP TABLE IF EXISTS `log`;
CREATE TABLE `log`  (
  `Log_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Log_StudentID` int(11) NULL DEFAULT NULL,
  `Log_TeacherID` int(11) NULL DEFAULT NULL,
  `Log_Date` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Log_Remark` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`Log_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 242 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of log
-- ----------------------------
INSERT INTO `log` VALUES (1, 1, 1, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (2, 2, 1, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (3, 3, 1, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (4, 4, 1, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (5, 5, 1, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (6, 6, 1, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (7, 7, 1, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (8, 8, 1, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (9, 9, 1, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (10, 10, 1, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (11, 11, 1, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (12, 12, 1, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (13, 13, 2, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (14, 14, 2, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (15, 15, 2, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (16, 16, 2, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (17, 17, 2, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (18, 18, 2, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (19, 19, 2, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (20, 20, 2, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (21, 21, 2, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (22, 22, 2, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (23, 23, 2, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (24, 24, 2, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (25, 25, 3, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (26, 26, 3, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (27, 27, 3, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (28, 28, 3, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (29, 29, 3, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (30, 30, 3, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (31, 31, 3, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (32, 32, 3, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (33, 33, 3, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (34, 34, 3, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (35, 35, 3, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (36, 36, 3, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (37, 37, 4, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (38, 38, 4, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (39, 39, 4, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (40, 40, 4, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (41, 41, 4, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (42, 42, 4, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (43, 43, 4, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (44, 44, 4, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (45, 45, 4, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (46, 46, 4, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (47, 47, 4, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (48, 48, 4, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (49, 49, 5, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (50, 50, 5, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (51, 51, 5, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (52, 52, 5, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (53, 53, 5, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (54, 54, 5, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (55, 55, 5, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (56, 56, 5, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (57, 57, 5, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (58, 58, 5, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (59, 59, 5, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (60, 60, 5, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (61, 61, 6, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (62, 62, 6, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (63, 63, 6, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (64, 64, 6, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (65, 65, 6, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (66, 66, 6, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (67, 67, 6, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (68, 68, 6, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (69, 69, 6, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (70, 70, 6, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (71, 71, 6, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (72, 72, 6, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (73, 73, 7, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (74, 74, 7, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (75, 75, 7, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (76, 76, 7, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (77, 77, 7, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (78, 78, 7, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (79, 79, 7, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (80, 80, 7, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (81, 81, 7, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (82, 82, 7, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (83, 83, 7, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (84, 84, 7, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (85, 85, 8, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (86, 86, 8, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (87, 87, 8, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (88, 88, 8, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (89, 89, 8, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (90, 90, 8, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (91, 91, 8, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (92, 92, 8, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (93, 93, 8, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (94, 94, 8, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (95, 95, 8, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (96, 96, 8, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (97, 97, 9, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (98, 98, 9, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (99, 99, 9, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (100, 100, 9, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (101, 101, 9, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (102, 102, 9, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (103, 103, 9, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (104, 104, 9, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (105, 105, 9, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (106, 106, 9, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (107, 107, 9, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (108, 108, 9, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (109, 109, 10, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (110, 110, 10, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (111, 111, 10, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (112, 112, 10, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (113, 113, 10, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (114, 114, 10, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (115, 115, 10, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (116, 116, 10, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (117, 117, 10, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (118, 118, 10, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (119, 119, 10, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (120, 120, 10, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (121, 121, 11, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (122, 122, 11, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (123, 123, 11, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (124, 124, 11, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (125, 125, 11, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (126, 126, 11, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (127, 127, 11, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (128, 128, 11, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (129, 129, 11, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (130, 130, 11, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (131, 131, 11, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (132, 132, 11, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (133, 133, 12, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (134, 134, 12, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (135, 135, 12, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (136, 136, 12, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (137, 137, 12, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (138, 138, 12, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (139, 139, 12, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (140, 140, 12, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (141, 141, 12, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (142, 142, 12, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (143, 143, 12, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (144, 144, 12, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (145, 145, 13, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (146, 146, 13, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (147, 147, 13, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (148, 148, 13, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (149, 149, 13, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (150, 150, 13, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (151, 151, 13, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (152, 152, 13, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (153, 153, 13, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (154, 154, 13, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (155, 155, 13, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (156, 156, 13, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (157, 157, 14, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (158, 158, 14, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (159, 159, 14, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (160, 160, 14, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (161, 161, 14, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (162, 162, 14, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (163, 163, 14, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (164, 164, 14, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (165, 165, 14, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (166, 166, 14, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (167, 167, 14, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (168, 168, 14, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (169, 169, 15, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (170, 170, 15, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (171, 171, 15, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (172, 172, 15, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (173, 173, 15, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (174, 174, 15, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (175, 175, 15, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (176, 176, 15, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (177, 177, 15, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (178, 178, 15, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (179, 179, 15, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (180, 180, 15, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (181, 181, 16, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (182, 182, 16, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (183, 183, 16, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (184, 184, 16, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (185, 185, 16, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (186, 186, 16, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (187, 187, 16, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (188, 188, 16, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (189, 189, 16, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (190, 190, 16, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (191, 191, 16, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (192, 192, 16, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (193, 193, 17, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (194, 194, 17, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (195, 195, 17, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (196, 196, 17, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (197, 197, 17, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (198, 198, 17, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (199, 199, 17, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (200, 200, 17, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (201, 201, 17, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (202, 202, 17, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (203, 203, 17, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (204, 204, 17, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (205, 205, 18, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (206, 206, 18, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (207, 207, 18, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (208, 208, 18, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (209, 209, 18, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (210, 210, 18, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (211, 211, 18, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (212, 212, 18, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (213, 213, 18, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (214, 214, 18, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (215, 215, 18, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (216, 216, 18, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (217, 217, 19, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (218, 218, 19, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (219, 219, 19, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (220, 220, 19, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (221, 221, 19, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (222, 222, 19, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (223, 223, 19, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (224, 224, 19, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (225, 225, 19, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (226, 226, 19, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (227, 227, 19, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (228, 228, 19, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (229, 229, 20, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (230, 230, 20, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (231, 231, 20, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (232, 232, 20, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (233, 233, 20, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (234, 234, 20, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (235, 235, 20, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (236, 236, 20, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (237, 237, 20, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (238, 238, 20, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (239, 239, 20, '2019-07-01\r\n', '未按时到寝室');
INSERT INTO `log` VALUES (240, 240, 20, '2019-07-01\r\n', '按时到寝室');
INSERT INTO `log` VALUES (241, 241, NULL, '2019-07-01\r\n', NULL);

-- ----------------------------
-- Table structure for notice
-- ----------------------------
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice`  (
  `id` int(11) NOT NULL,
  `info` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `date` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for out1
-- ----------------------------
DROP TABLE IF EXISTS `out1`;
CREATE TABLE `out1`  (
  `Out_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Out_StudentID` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Out_Date` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Out_Remark` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`Out_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 53 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of out1
-- ----------------------------
INSERT INTO `out1` VALUES (1, '2', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (2, '6', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (3, '14', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (4, '16', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (5, '20', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (6, '28', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (7, '30', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (8, '34', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (9, '42', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (10, '44', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (11, '48', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (12, '56', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (13, '58', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (14, '62', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (15, '70', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (16, '72', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (17, '76', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (18, '84', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (19, '86', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (20, '90', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (21, '98', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (22, '100', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (23, '104', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (24, '112', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (25, '114', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (26, '118', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (27, '126', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (28, '128', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (29, '132', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (30, '140', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (31, '142', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (32, '146', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (33, '154', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (34, '156', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (35, '160', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (36, '168', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (37, '170', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (38, '174', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (39, '182', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (40, '184', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (41, '188', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (42, '196', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (43, '198', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (44, '202', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (45, '210', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (46, '212', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (47, '216', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (48, '224', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (49, '226', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (50, '230', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (51, '238', '2018-07-10', '已离校');
INSERT INTO `out1` VALUES (52, '240', '2018-07-10', '已离校');

-- ----------------------------
-- Table structure for repair
-- ----------------------------
DROP TABLE IF EXISTS `repair`;
CREATE TABLE `repair`  (
  `repair_id` int(40) NOT NULL AUTO_INCREMENT,
  `repair_info` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `repair_address` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `repair_tel` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `repair_status` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `repair_time` date NULL DEFAULT NULL,
  `repair_cost` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`repair_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of repair
-- ----------------------------
INSERT INTO `repair` VALUES (1, '凳子坏了', '8栋一单元136', '18979920069', '已维修', '2019-07-01', '5');
INSERT INTO `repair` VALUES (2, '灯坏了', '7栋二单元236', '15679165047', '待维修', '2019-07-01', '15');
INSERT INTO `repair` VALUES (3, '凳子坏了', '5栋一单元136', '18507063816', '待维修', '2019-07-01', '5');
INSERT INTO `repair` VALUES (4, '桌子坏了', '5栋二单元136', '15270914833', '待维修', '2019-07-01', '20');
INSERT INTO `repair` VALUES (5, '水龙头坏了', '2栋一单元136', '13047901290', '待维修', '2019-06-30', '10');
INSERT INTO `repair` VALUES (6, '水龙头坏了', '1栋二单元136', '13732999774', '待维修', '2019-06-30', '10');
INSERT INTO `repair` VALUES (7, '桌子坏了', '20栋一单元136', '18279159258', '待维修', '2019-06-29', '20');
INSERT INTO `repair` VALUES (8, '凳子坏了', '6栋一单元136', '18702626790', '待维修', '2019-06-29', '5');
INSERT INTO `repair` VALUES (9, '水龙头坏了', '4栋二单元136', '18702505196', '已维修', '2019-06-29', '10');
INSERT INTO `repair` VALUES (10, '凳子坏了', '3栋一单元136', '18679433386', '已维修', '2019-06-29', '5');
INSERT INTO `repair` VALUES (11, '凳子坏了', '4栋二单元136', '17607094826', '待维修', '2019-07-28', '5');
INSERT INTO `repair` VALUES (12, '水龙头坏了', '5栋一单元136', '15979179745', '待维修', '2019-07-28', '10');
INSERT INTO `repair` VALUES (13, '水龙头坏了', '11栋一单元136', '15797656705', '已维修', '2019-07-28', '10');
INSERT INTO `repair` VALUES (14, '桌子坏了', '16栋二单元136', '13155810105', '待维修', '2019-07-28', '20');
INSERT INTO `repair` VALUES (15, '凳子坏了', '15栋一单元136', '15070932131', '待维修', '2019-07-28', '5');
INSERT INTO `repair` VALUES (16, '灯坏了', '14栋一单元136', '18317962601', '待维修', '2019-07-28', '15');
INSERT INTO `repair` VALUES (17, '凳子坏了', '13栋二单元136', '15797656062', '待维修', '2019-07-28', '5');
INSERT INTO `repair` VALUES (18, '凳子坏了', '12栋一单元136', '18870111996', '待维修', '2019-06-27', '5');
INSERT INTO `repair` VALUES (19, '水龙头坏了', '12栋一单元136', '15079125843', '待维修', '2019-06-27', '10');
INSERT INTO `repair` VALUES (20, '凳子坏了', '13栋二单元136', '17779148522', '待维修', '2019-06-27', '5');
INSERT INTO `repair` VALUES (21, '凳子坏了', '1栋一单元136', '13627088052', '待维修', '2019-06-27', '5');

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student`  (
  `Student_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Student_DomitoryID` int(11) NULL DEFAULT NULL,
  `Student_Username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Student_Password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Student_Name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Student_Sex` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Student_Class` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Student_State` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`Student_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 302 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES (1, 1, '2017211001000701', '2017211001000701', '王灵鑫 ', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (2, 1, '2017211001000702', '2017211001000702', '娄洋 ', '男 ', '2017软件工程1班', '迁出');
INSERT INTO `student` VALUES (3, 1, '2017211001000703', '2017211001000703', '赵阳 ', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (4, 1, '2017211001000704', '2017211001000704', '颜名堂 ', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (5, 2, '2017211001000705', '2017211001000705', '熊学理 ', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (6, 2, '2017211001000706', '2017211001000706', '龚智强 ', '男 ', '2017软件工程1班', '迁出');
INSERT INTO `student` VALUES (7, 2, '2017211001000708', '2017211001000708', '李志龙 ', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (8, 2, '2017211001000709', '2017211001000709', '喻雪葵 ', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (9, 3, '2017211001000710', '2017211001000710', '李煜 ', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (10, 3, '2017211001000711', '2017211001000711', '张千通 ', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (11, 3, '2017211001000712', '2017211001000712', '郭章琼 ', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (12, 3, '2017211001000713', '2017211001000713', '杨德志 ', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (13, 4, '2017211001000714', '2017211001000714', '吴宇健 ', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (14, 4, '2017211001000715', '2017211001000715', '宋宇 ', '男 ', '2017软件工程1班', '迁出');
INSERT INTO `student` VALUES (15, 4, '2017211001000716', '2017211001000716', '赖碧瑞 ', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (16, 4, '2017211001000717', '2017211001000717', '欧阳强 ', '男 ', '2017软件工程1班', '迁出');
INSERT INTO `student` VALUES (17, 5, '2017211001000718', '2017211001000718', '刘德煌 ', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (18, 5, '2017211001000719', '2017211001000719', '朱润秋 ', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (19, 5, '2017211001000720', '2017211001000720', '彭嘉成 ', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (20, 5, '2017211001000721', '2017211001000721', '彭彬 ', '男 ', '2017软件工程1班', '迁出');
INSERT INTO `student` VALUES (21, 6, '2017211001000722', '2017211001000722', '欧阳辉 ', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (22, 6, '2017211001000723', '2017211001000723', '姚典 ', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (23, 6, '2017211001000724', '2017211001000724', '甘宏 ', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (24, 6, '2017211001000725', '2017211001000725', '王乐飞 ', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (25, 7, '2017211001000726', '2017211001000726', '叶皓杰 ', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (26, 7, '2017211001000727', '2017211001000727', '柳雄 ', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (27, 7, '2017211001000728', '2017211001000728', '蒋子良 ', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (28, 7, '2017211001000729', '2017211001000729', '蒋俊豪 ', '男 ', '2017软件工程1班', '迁出');
INSERT INTO `student` VALUES (29, 8, '2017211001000730', '2017211001000730', '肖昀 ', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (30, 8, '2017211001000731', '2017211001000731', '刘昊杨 ', '男 ', '2017软件工程1班', '迁出');
INSERT INTO `student` VALUES (31, 8, '2017211001000732', '2017211001000732', '谢青保', '男 ', '2017软件工程1班', '入住');
INSERT INTO `student` VALUES (32, 8, '2017211001000733', '2017211001000733', '涂远安', '男', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (33, 9, '2017211001000801', '2017211001000801', '廖宝斌', '男 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (34, 9, '2017211001000802', '2017211001000802', '周理吉', '男 ', '2017软件工程2班', '迁出');
INSERT INTO `student` VALUES (35, 9, '2017211001000803', '2017211001000803', '熊家友', '男 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (36, 9, '2017211001000804', '2017211001000804', '邓曦颖 ', '女 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (37, 10, '2017211001000805', '2017211001000805', '朱毓情 ', '女 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (38, 10, '2017211001000806', '2017211001000806', '周航 ', '男 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (39, 10, '2017211001000807', '2017211001000807', '李岳强 ', '男 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (40, 10, '2017211001000808', '2017211001000808', '崔健 ', '男 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (41, 11, '2017211001000809', '2017211001000809', '尚龙翔 ', '男 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (42, 11, '2017211001000810', '2017211001000810', '夏江南 ', '男 ', '2017软件工程2班', '迁出');
INSERT INTO `student` VALUES (43, 11, '2017211001000811', '2017211001000811', '贺振翔 ', '男 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (44, 11, '2017211001000812', '2017211001000812', '舒杰 ', '男 ', '2017软件工程2班', '迁出');
INSERT INTO `student` VALUES (45, 12, '2017211001000813', '2017211001000813', '万亮 ', '男 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (46, 12, '2017211001000814', '2017211001000814', '胡琤 ', '男 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (47, 12, '2017211001000815', '2017211001000815', '郑志强 ', '男 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (48, 12, '2017211001000816', '2017211001000816', '潘江祚 ', '男 ', '2017软件工程2班', '迁出');
INSERT INTO `student` VALUES (49, 13, '2017211001000817', '2017211001000817', '胡生东 ', '男 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (50, 13, '2017211001000818', '2017211001000818', '袁松 ', '男 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (51, 13, '2017211001000819', '2017211001000819', '彭宗智 ', '男 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (52, 13, '2017211001000820', '2017211001000820', '谢思军 ', '男 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (53, 14, '2017211001000821', '2017211001000821', '周建明 ', '男 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (54, 14, '2017211001000822', '2017211001000822', '梁乐 ', '男 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (55, 14, '2017211001000823', '2017211001000823', '陈起昌 ', '男 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (56, 14, '2017211001000824', '2017211001000824', '郑金任 ', '男 ', '2017软件工程2班', '迁出');
INSERT INTO `student` VALUES (57, 15, '2017211001000825', '2017211001000825', '朱小明 ', '男 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (58, 15, '2017211001000826', '2017211001000826', '陈宪周 ', '男 ', '2017软件工程2班', '迁出');
INSERT INTO `student` VALUES (59, 15, '2017211001000827', '2017211001000827', '周俊豪 ', '男 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (60, 15, '2017211001000828', '2017211001000828', '程博文 ', '男 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (61, 16, '2017211001000829', '2017211001000829', '王海 ', '男 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (62, 16, '2017211001000830', '2017211001000830', '闫文铠 ', '男 ', '2017软件工程2班', '迁出');
INSERT INTO `student` VALUES (63, 16, '2017211001000831', '2017211001000831', '邬鸣 ', '男 ', '2017软件工程2班', '入住');
INSERT INTO `student` VALUES (64, 16, '2017211001000832', '2017211001000832', '梁吉尧 ', '男 ', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (65, 17, '2017211001000833', '2017211001000833', '张怡辉', '男', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (66, 17, '2017211001000901', '2017211001000901', '李金辉', '男 ', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (67, 17, '2017211001000902', '2017211001000902', '许耕硕 ', '男 ', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (68, 17, '2017211001000903', '2017211001000903', '邵立三', '男', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (69, 18, '2017211001000904', '2017211001000904', '戴泽韵', '男', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (70, 18, '2017211001000905', '2017211001000905', '晏澍瑞', '男 ', '2017软件工程3班', '迁出');
INSERT INTO `student` VALUES (71, 18, '2017211001000906', '2017211001000906', '周福林', '男', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (72, 18, '2017211001000907', '2017211001000907', '吴迎迎 ', '女 ', '2017软件工程3班', '迁出');
INSERT INTO `student` VALUES (73, 19, '2017211001000908', '2017211001000908', '叶珍珍 ', '女 ', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (74, 19, '2017211001000909', '2017211001000909', '陈清梅 ', '女 ', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (75, 19, '2017211001000910', '2017211001000910', '朱静怡 ', '女 ', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (76, 19, '2017211001000911', '2017211001000911', '马玉 ', '男 ', '2017软件工程3班', '迁出');
INSERT INTO `student` VALUES (77, 20, '2017211001000912', '2017211001000912', '冯金兴 ', '男 ', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (78, 20, '2017211001000913', '2017211001000913', '汤仲训 ', '男 ', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (79, 20, '2017211001000914', '2017211001000914', '朱煜铭 ', '男 ', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (80, 20, '2017211001000915', '2017211001000915', '秦志坤 ', '男 ', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (81, 21, '2017211001000916', '2017211001000916', '徐涛 ', '男 ', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (82, 21, '2017211001000917', '2017211001000917', '徐骏铎 ', '男 ', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (83, 21, '2017211001000918', '2017211001000918', '裘艺 ', '男 ', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (84, 21, '2017211001000919', '2017211001000919', '吴天乐 ', '男 ', '2017软件工程3班', '迁出');
INSERT INTO `student` VALUES (85, 22, '2017211001000920', '2017211001000920', '万尚俊 ', '男 ', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (86, 22, '2017211001000921', '2017211001000921', '周裕 ', '男 ', '2017软件工程3班', '迁出');
INSERT INTO `student` VALUES (87, 22, '2017211001000922', '2017211001000922', '柯璋 ', '男 ', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (88, 22, '2017211001000923', '2017211001000923', '蓝天飞 ', '男 ', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (89, 23, '2017211001000924', '2017211001000924', '刘生林 ', '男 ', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (90, 23, '2017211001000925', '2017211001000925', '聂自立 ', '男 ', '2017软件工程3班', '迁出');
INSERT INTO `student` VALUES (91, 23, '2017211001000926', '2017211001000926', '龙齐明 ', '男 ', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (92, 23, '2017211001000927', '2017211001000927', '罗顺龙 ', '男 ', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (93, 24, '2017211001000928', '2017211001000928', '易芳 ', '男 ', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (94, 24, '2017211001000929', '2017211001000929', '林佳剑 ', '男 ', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (95, 24, '2017211001000930', '2017211001000930', '李志雄 ', '男 ', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (96, 24, '2017211001000931', '2017211001000931', '金谱 ', '男 ', '2017软件工程3班', '入住');
INSERT INTO `student` VALUES (97, 25, '2017211001000933', '2017211001000933', '邹鹿鹿 ', '男 ', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (98, 25, '2017211001001001', '2017211001001001', '雷鸣宇 ', '男 ', '2017软件工程4班', '迁出');
INSERT INTO `student` VALUES (99, 25, '2017211001001002', '2017211001001002', '汤归华 ', '男 ', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (100, 25, '2017211001001003', '2017211001001003', '郑鸿翔 ', '男 ', '2017软件工程4班', '迁出');
INSERT INTO `student` VALUES (101, 26, '2017211001001004', '2017211001001004', '张耀', '男 ', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (102, 26, '2017211001001005', '2017211001001005', '姜佩', '男', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (103, 26, '2017211001001006', '2017211001001006', '刘旭升', '男', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (104, 27, '2017211001001007', '2017211001001007', '袁蹬', '男', '2017软件工程4班', '迁出');
INSERT INTO `student` VALUES (105, 27, '2017211001001008', '2017211001001008', '谢祥辉', '男', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (106, 27, '2017211001001009', '2017211001001009', '孙晨宇 ', '女 ', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (107, 27, '2017211001001010', '2017211001001010', '熊茜文 ', '女 ', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (108, 28, '2017211001001011', '2017211001001011', '梁婷 ', '女 ', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (109, 28, '2017211001001012', '2017211001001012', '侯猛飞 ', '男 ', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (110, 28, '2017211001001013', '2017211001001013', '邢哲 ', '男 ', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (111, 28, '2017211001001014', '2017211001001014', '于文硕 ', '男 ', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (112, 29, '2017211001001015', '2017211001001015', '张道鹏 ', '男 ', '2017软件工程4班', '迁出');
INSERT INTO `student` VALUES (113, 29, '2017211001001016', '2017211001001016', '黄俊杰 ', '男 ', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (114, 29, '2017211001001017', '2017211001001017', '付廷文 ', '男 ', '2017软件工程4班', '迁出');
INSERT INTO `student` VALUES (115, 29, '2017211001001018', '2017211001001018', '余子康 ', '男 ', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (116, 30, '2017211001001019', '2017211001001019', '谭铭军 ', '男 ', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (117, 30, '2017211001001020', '2017211001001020', '王荣峰 ', '男 ', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (118, 30, '2017211001001021', '2017211001001021', '朱金旋 ', '男 ', '2017软件工程4班', '迁出');
INSERT INTO `student` VALUES (119, 30, '2017211001001022', '2017211001001022', '余延 ', '男 ', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (120, 31, '2017211001001023', '2017211001001023', '黄阳瑞 ', '男 ', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (121, 31, '2017211001001024', '2017211001001024', '李旺 ', '男 ', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (122, 31, '2017211001001025', '2017211001001025', '黄河 ', '男 ', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (123, 31, '2017211001001026', '2017211001001026', '张勇 ', '男 ', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (124, 32, '2017211001001027', '2017211001001027', '刘祥 ', '男 ', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (125, 32, '2017211001001028', '2017211001001028', '王发云 ', '男 ', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (126, 32, '2017211001001029', '2017211001001029', '涂浩宇 ', '男 ', '2017软件工程4班', '迁出');
INSERT INTO `student` VALUES (127, 32, '2017211001001030', '2017211001001030', '张印 ', '男 ', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (128, 33, '2017211001001031', '2017211001001031', '肖鹏 ', '男 ', '2017软件工程4班', '迁出');
INSERT INTO `student` VALUES (129, 33, '2017211001001032', '2017211001001032', '杨文俊 ', '男 ', '2017软件工程4班', '入住');
INSERT INTO `student` VALUES (130, 33, '2017211001001033', '2017211001001033', '谢恺睿 ', '男 ', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (131, 33, '2017211001001034', '2017211001001034', '黄诗俊 ', '男 ', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (132, 34, '2017211001001101', '2017211001001101', '张航 ', '男 ', '2017软件工程5班', '迁出');
INSERT INTO `student` VALUES (133, 34, '2017211001001102', '2017211001001102', '郑国强 ', '男 ', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (134, 34, '2017211001001103', '2017211001001103', '吴兴旻 ', '男 ', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (135, 34, '2017211001001104', '2017211001001104', '胡嘉辉 ', '男 ', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (136, 35, '2017211001001105', '2017211001001105', '曹植洋 ', '男 ', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (137, 35, '2017211001001106', '2017211001001106', '赵凯 ', '男 ', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (138, 35, '2017211001001107', '2017211001001107', '江华 ', '女 ', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (139, 35, '2017211001001108', '2017211001001108', '王指柔 ', '女 ', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (140, 36, '2017211001001109', '2017211001001109', '吴雨婷 ', '女 ', '2017软件工程5班', '迁出');
INSERT INTO `student` VALUES (141, 36, '2017211001001110', '2017211001001110', '徐红波 ', '女 ', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (142, 36, '2017211001001111', '2017211001001111', '朱欣宇 ', '女 ', '2017软件工程5班', '迁出');
INSERT INTO `student` VALUES (143, 36, '2017211001001112', '2017211001001112', '熊玲 ', '女 ', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (144, 37, '2017211001001113', '2017211001001113', '陈梦婷 ', '女 ', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (145, 37, '2017211001001114', '2017211001001114', '刘琳 ', '女 ', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (146, 37, '2017211001001115', '2017211001001115', '沈佳宁 ', '女 ', '2017软件工程5班', '迁出');
INSERT INTO `student` VALUES (147, 37, '2017211001001116', '2017211001001116', '彭涛 ', '女 ', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (148, 38, '2017211001001117', '2017211001001117', '丁艳 ', '女 ', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (149, 38, '2017211001001118', '2017211001001118', '申琦 ', '女 ', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (150, 38, '2017211001001119', '2017211001001119', '邓思怡 ', '女 ', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (151, 38, '2017211001001120', '2017211001001120', '江昊宣 ', '女 ', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (152, 39, '2017211001001121', '2017211001001121', '张湘琳 ', '女 ', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (153, 39, '2017211001001122', '2017211001001122', '玉苏批·麦麦提', '男', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (154, 39, '2017211001001123', '2017211001001123', '杨贺群 ', '男 ', '2017软件工程5班', '迁出');
INSERT INTO `student` VALUES (155, 39, '2017211001001124', '2017211001001124', '曹国仪 ', '男 ', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (156, 39, '2017211001001125', '2017211001001125', '胡玥琦 ', '男 ', '2017软件工程5班', '迁出');
INSERT INTO `student` VALUES (157, 40, '2017211001001126', '2017211001001126', '宋鹏 ', '男 ', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (158, 40, '2017211001001127', '2017211001001127', '吴庆国 ', '男 ', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (159, 40, '2017211001001128', '2017211001001128', '陈辰 ', '男 ', '2017软件工程5班', '入住');
INSERT INTO `student` VALUES (160, 40, '2017211001001129', '2017211001001129', '谢强 ', '男 ', '2017软件工程5班', '迁出');
INSERT INTO `student` VALUES (161, 41, '2017211001001130', '2017211001001130', '林震宇 ', '男 ', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (162, 41, '2017211001001131', '2017211001001131', '康睿 ', '男 ', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (163, 41, '2017211001001132', '2017211001001132', '蒋多福 ', '男 ', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (164, 41, '2017211001001201', '2017211001001201', '廖喜 ', '男 ', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (165, 42, '2017211001001202', '2017211001001202', '陈璨 ', '男 ', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (166, 42, '2017211001001203', '2017211001001203', '刘绍文 ', '男 ', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (167, 42, '2017211001001204', '2017211001001204', '章海洋 ', '男 ', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (168, 42, '2017211001001205', '2017211001001205', '杨子炎 ', '男 ', '2017软件工程6班', '迁出');
INSERT INTO `student` VALUES (169, 43, '2017211001001206', '2017211001001206', '黄睿 ', '男 ', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (170, 43, '2017211001001207', '2017211001001207', '刘建', '女 ', '2017软件工程6班', '迁出');
INSERT INTO `student` VALUES (171, 43, '2017211001001208', '2017211001001208', '高程成', '男', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (172, 43, '2017211001001209', '2017211001001209', '彭俊翔', '男', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (173, 44, '2017211001001210', '2017211001001210', '付林', '男', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (174, 44, '2017211001001211', '2017211001001211', '杨真', '男', '2017软件工程6班', '迁出');
INSERT INTO `student` VALUES (175, 44, '2017211001001212', '2017211001001212', '余波', '男', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (176, 44, '2017211001001213', '2017211001001213', '曾文成', '男', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (177, 45, '2017211001001214', '2017211001001214', '巴登其其克 ', '女 ', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (178, 45, '2017211001001215', '2017211001001215', '刘冰星 ', '女 ', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (179, 45, '2017211001001216', '2017211001001216', '黄梦佳 ', '女 ', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (180, 45, '2017211001001217', '2017211001001217', '黄逸 ', '女 ', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (181, 46, '2017211001001218', '2017211001001218', '欧阳结 ', '女 ', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (182, 46, '2017211001001219', '2017211001001219', '郭诗妍 ', '女 ', '2017软件工程6班', '迁出');
INSERT INTO `student` VALUES (183, 46, '2017211001001220', '2017211001001220', '孙梦凡 ', '女 ', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (184, 46, '2017211001001221', '2017211001001221', '朱玉琴 ', '女 ', '2017软件工程6班', '迁出');
INSERT INTO `student` VALUES (185, 47, '2017211001001222', '2017211001001222', '赵婧茹 ', '女 ', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (186, 47, '2017211001001223', '2017211001001223', '邹倩如 ', '女 ', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (187, 47, '2017211001001224', '2017211001001224', '黄文娟 ', '女 ', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (188, 47, '2017211001001225', '2017211001001225', '汪霁雯 ', '女 ', '2017软件工程6班', '迁出');
INSERT INTO `student` VALUES (189, 48, '2017211001001226', '2017211001001226', '李琦 ', '女 ', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (190, 48, '2017211001001227', '2017211001001227', '钟凝 ', '女 ', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (191, 48, '2017211001001228', '2017211001001228', '梁杰富 ', '男 ', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (192, 48, '2017211001001229', '2017211001001229', '程谦 ', '男 ', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (193, 49, '2017211001001230', '2017211001001230', '万怡荣 ', '男 ', '2017软件工程6班', '入住');
INSERT INTO `student` VALUES (194, 49, '2017211001001231', '2017211001001231', '万鹏 ', '男 ', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (195, 49, '2017211001001232', '2017211001001232', '李浪 ', '男 ', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (196, 49, '2017211001001233', '2017211001001233', '陈可洋 ', '男 ', '2017软件工程7班', '迁出');
INSERT INTO `student` VALUES (197, 50, '2017211001001301', '2017211001001301', '古剑飞 ', '男 ', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (198, 50, '2017211001001302', '2017211001001302', '钟鸣华 ', '男 ', '2017软件工程7班', '迁出');
INSERT INTO `student` VALUES (199, 50, '2017211001001303', '2017211001001303', '刘海涛 ', '男 ', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (200, 50, '2017211001001304', '2017211001001304', '黄攀 ', '男 ', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (201, 51, '2017211001001305', '2017211001001305', '况鑫涛 ', '男 ', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (202, 51, '2017211001001306', '2017211001001306', '钟小蛟 ', '男 ', '2017软件工程7班', '迁出');
INSERT INTO `student` VALUES (203, 51, '2017211001001307', '2017211001001307', '聂志旺 ', '男 ', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (204, 51, '2017211001001308', '2017211001001308', '赖驰 ', '男 ', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (205, 52, '2017211001001309', '2017211001001309', '吴坤鹏 ', '男 ', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (206, 52, '2017211001001310', '2017211001001310', '李宇坤 ', '男 ', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (207, 52, '2017211001001311', '2017211001001311', '王慧谦', '男 ', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (208, 52, '2017211001001312', '2017211001001312', '王楚欣', '女 ', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (209, 53, '2017211001001313', '2017211001001313', '卢诗文', '女 ', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (210, 53, '2017211001001314', '2017211001001314', '陈扬', '女', '2017软件工程7班', '迁出');
INSERT INTO `student` VALUES (211, 53, '2017211001001315', '2017211001001315', '谢鹏英', '男', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (212, 53, '2017211001001316', '2017211001001316', '骆俊松', '男 ', '2017软件工程7班', '迁出');
INSERT INTO `student` VALUES (213, 54, '2017211001001317', '2017211001001317', '李钰婷 ', '女', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (214, 54, '2017211001001318', '2017211001001318', '黄晓立 ', '男', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (215, 54, '2017211001001319', '2017211001001319', '甘传贵 ', '男', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (216, 54, '2017211001001320', '2017211001001320', '林晓冬 ', '男', '2017软件工程7班', '迁出');
INSERT INTO `student` VALUES (217, 55, '2017211001001321', '2017211001001321', '余琪琳', '女', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (218, 55, '2017211001001322', '2017211001001322', '张艺欣', '女', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (219, 55, '2017211001001323', '2017211001001323', '王洁', '女', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (220, 55, '2017211001001324', '2017211001001324', '刘自强', '男', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (221, 56, '2017211001001325', '2017211001001325', '丁超', '男', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (222, 56, '2017211001001326', '2017211001001326', '冯佳泓', '男', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (223, 56, '2017211001001327', '2017211001001327', '熊超', '男', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (224, 56, '2017211001001328', '2017211001001328', '方文刚', '男', '2017软件工程7班', '迁出');
INSERT INTO `student` VALUES (225, 57, '2017211001001329', '2017211001001329', '江忱', '男', '2017软件工程7班', '入住');
INSERT INTO `student` VALUES (226, 57, '2017211001001330', '2017211001001330', '张嵩', '男', '17软件工程-08', '迁出');
INSERT INTO `student` VALUES (227, 57, '2017211001001331', '2017211001001331', '朱俊琦', '男', '17软件工程-08', '入住');
INSERT INTO `student` VALUES (228, 57, '2017211001001332', '2017211001001332', '林建平', '男', '17软件工程-08', '入住');
INSERT INTO `student` VALUES (229, 58, '2017211001001401', '2017211001001401', '曹家新', '男', '17软件工程-08', '入住');
INSERT INTO `student` VALUES (230, 58, '2017211001001402', '2017211001001402', '谷峰', '男', '17软件工程-08', '迁出');
INSERT INTO `student` VALUES (231, 58, '2017211001001403', '2017211001001403', '雷泽龙', '男', '17软件工程-08', '入住');
INSERT INTO `student` VALUES (232, 58, '2017211001001404', '2017211001001404', '邵志磊', '男', '17软件工程-08', '入住');
INSERT INTO `student` VALUES (233, 59, '2017211001001405', '2017211001001405', '李嘉伟', '男', '17软件工程-08', '入住');
INSERT INTO `student` VALUES (234, 59, '2017211001001406', '2017211001001406', '丁凌波', '男', '17软件工程-08', '入住');
INSERT INTO `student` VALUES (235, 59, '2017211001001407', '2017211001001407', '陈志辉', '男', '17软件工程-08', '入住');
INSERT INTO `student` VALUES (236, 59, '2017211001001408', '2017211001001408', '郭建亮', '男', '17软件工程-08', '入住');
INSERT INTO `student` VALUES (237, 60, '2017211001001409', '2017211001001409', '彭博', '男', '17软件工程-08', '入住');
INSERT INTO `student` VALUES (238, 60, '2017211001001410', '2017211001001410', '杜鲁子楚', '男', '17软件工程-08', '迁出');
INSERT INTO `student` VALUES (239, 60, '2017211001001411', '2017211001001411', '叶林生', '男', '17软件工程-08', '入住');
INSERT INTO `student` VALUES (240, 60, '2017211001001412', '2017211001001412', '唐诗发', '男', '17软件工程-08', '迁出');
INSERT INTO `student` VALUES (241, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (242, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (243, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (244, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (245, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (246, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (247, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (248, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (249, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (250, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (251, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (252, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (253, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (254, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (255, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (256, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (257, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (258, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (259, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (260, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (261, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (262, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (263, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (264, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (265, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (266, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (267, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (268, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (269, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (270, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (271, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (272, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (273, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (274, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (275, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (276, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (277, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (278, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (279, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (280, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (281, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (282, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (283, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (284, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (285, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (286, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (287, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (288, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (289, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (290, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (291, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (292, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (293, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (294, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (295, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (296, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (297, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (298, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (299, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (300, NULL, NULL, NULL, NULL, NULL, NULL, '');
INSERT INTO `student` VALUES (301, NULL, NULL, NULL, NULL, NULL, NULL, '');

-- ----------------------------
-- Table structure for tb
-- ----------------------------
DROP TABLE IF EXISTS `tb`;
CREATE TABLE `tb`  (
  `TB_ID` int(11) NOT NULL AUTO_INCREMENT,
  `TB_TeacherID` int(11) NULL DEFAULT NULL,
  `TB_BuildingID` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`TB_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of tb
-- ----------------------------
INSERT INTO `tb` VALUES (1, 1, 1);
INSERT INTO `tb` VALUES (2, 2, 2);
INSERT INTO `tb` VALUES (3, 3, 3);
INSERT INTO `tb` VALUES (4, 4, 4);
INSERT INTO `tb` VALUES (5, 5, 5);
INSERT INTO `tb` VALUES (6, 6, 6);
INSERT INTO `tb` VALUES (7, 7, 7);
INSERT INTO `tb` VALUES (8, 8, 8);
INSERT INTO `tb` VALUES (9, 9, 9);
INSERT INTO `tb` VALUES (10, 10, 10);
INSERT INTO `tb` VALUES (11, 11, 11);
INSERT INTO `tb` VALUES (12, 12, 12);
INSERT INTO `tb` VALUES (13, 13, 13);
INSERT INTO `tb` VALUES (14, 14, 14);
INSERT INTO `tb` VALUES (15, 15, 15);
INSERT INTO `tb` VALUES (16, 16, 16);
INSERT INTO `tb` VALUES (17, 17, 17);
INSERT INTO `tb` VALUES (18, 18, 18);
INSERT INTO `tb` VALUES (19, 19, 19);
INSERT INTO `tb` VALUES (20, 20, 20);
INSERT INTO `tb` VALUES (21, 21, 21);

-- ----------------------------
-- Table structure for teacher
-- ----------------------------
DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher`  (
  `Teacher_ID` int(11) NOT NULL AUTO_INCREMENT,
  `Teacher_Username` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Teacher_Password` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Teacher_Name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Teacher_Sex` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `Teacher_Tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`Teacher_ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of teacher
-- ----------------------------
INSERT INTO `teacher` VALUES (1, 'teacher', 'teacher', '朱雨清', '女', '13979029056');
INSERT INTO `teacher` VALUES (2, 'teacher1', 'teacher1', '曾雨浩', '女', '18379522370');
INSERT INTO `teacher` VALUES (3, 'teacher2', 'teacher2', '冯绍薇', '女', '15979162405');
INSERT INTO `teacher` VALUES (4, 'teacher3', 'teacher3', '曾雨超', '女', '17770844008');
INSERT INTO `teacher` VALUES (5, 'teacher4', 'teacher4', '鞠晓朋', '女', '15797639137');
INSERT INTO `teacher` VALUES (6, 'teacher5', 'teacher5', '黄晓', '女', '15970384949');
INSERT INTO `teacher` VALUES (7, 'teacher6', 'teacher6', '李薇民', '女', '15797639618');
INSERT INTO `teacher` VALUES (8, 'teacher7', 'teacher7', '甘雨赓', '女', '17770046638');
INSERT INTO `teacher` VALUES (9, 'teacher8', 'teacher8', '黄晓清', '女', '15797704304');
INSERT INTO `teacher` VALUES (10, 'teacher9', 'teacher9', '郭雨元', '女', '15180604700');
INSERT INTO `teacher` VALUES (11, 'teacher10', 'teacher10', '赖薇文', '女', '18307947489');
INSERT INTO `teacher` VALUES (12, 'teacher11', 'teacher11', '王晓', '女', '15216007017');
INSERT INTO `teacher` VALUES (13, 'teacher12', 'teacher12', '詹薇霖', '女', '15770683657');
INSERT INTO `teacher` VALUES (14, 'teacher13', 'teacher13', '胡雨', '女', '15083505510');
INSERT INTO `teacher` VALUES (15, 'teacher14', 'teacher14', '魏辽', '女', '15180401521');
INSERT INTO `teacher` VALUES (16, 'teacher15', 'teacher15', '胡晓', '女', '17770046774');
INSERT INTO `teacher` VALUES (17, 'teacher16', 'teacher16', '刘霆晓', '女', '15279464013');
INSERT INTO `teacher` VALUES (18, 'teacher17', 'teacher17', '郑薇亮', '女', '15970650221');
INSERT INTO `teacher` VALUES (19, 'teacher18', 'teacher18', '付薇平', '女', '15970650519');
INSERT INTO `teacher` VALUES (20, 'teacher19', 'teacher19', '蓝勇薇', '女', '15180111574');
INSERT INTO `teacher` VALUES (21, 'teacher20', 'teacher20', '周浩晓', '女', '13756403020 ');

SET FOREIGN_KEY_CHECKS = 1;
