INSERT INTO `buildings` (`id`, `name`, `order_num`, `is_valid`, `remarks`, `describe`, `image_url`, `is_del`, `status`) 
VALUES 
(NULL, '5号楼', 1, 1, ' ', '宿舍楼5号楼\n位于学校正南方、毗邻教学楼、图书室。\n详情：\n女生：二层、五层。\n男生：一层、三层、四层。\n每层两个七人间、其余的均为四人间。\n标准上床下桌。', 'https://cdnjson.com/images/2022/11/28/building5.jpg', 0, 0),
(NULL, '8号楼', 2, 1, ' ', '宿舍楼8号楼\n学校东南角、距离教学楼更近。\n详情：\n共四层楼、套间式，每个套间包括4个宿舍，\n分别为四人间、四人间、四人间、六人间\n共9个上下铺、2个卫浴。', 'https://cdnjson.com/images/2022/11/28/building8.jpg', 0, 0),
(NULL, '9号楼', 3, 1, ' ', '宿舍楼9号楼\n学校东南角、距离教学楼更近。\n详情：\n共四层楼、套间式，每个套间包括4个宿舍，\n分别为四人间、四人间、四人间、六人间\n共9个上下铺、2个卫浴。', 'https://cdnjson.com/images/2022/11/28/building9.jpg', 0, 0),
(NULL, '13号楼', 4, 1, ' ', '宿舍楼13号楼\n位于学校最北端、拥有便利的取快递&外卖条件、暖气极佳。\n详情：\n共5层楼，每层均有2个套间、每个套间包括5个宿舍、\n分别为二人间、二人间、三人间、三人间、五人间\n共15个平铺、2个卫浴。\n女生：13号楼一单元\n男生：13号楼二&三单元', 'https://cdnjson.com/images/2022/11/28/buidling14.jpg', 0, 0),
(NULL, '14号楼', 5, 1, ' ', '宿舍楼14号楼\n位于学校最北端、拥有便利的取快递&外卖条件、暖气极佳。\n详情：\n共5层楼，每层均有2个套间、每个套间包括5个宿舍、\n分别为二人间、二人间、三人间、三人间、五人间\n共15个平铺、2个卫浴。\n女生：14号楼一&二单元', 'https://cdnjson.com/images/2022/11/28/building13.jpg', 0, 0);


INSERT INTO `users` (`name`, `gender`, `email`, `tel`, `type`, `add_time`, `is_deny`, `last_login_time`, `remarks`, `is_del`, `status`)
VALUES
('stu1', '1', '1@126.com', '1', '1', '0', '0', '0', '0', '0', '0'),
('stu2', '1', '2@126.com', '1', '1', '0', '0', '0', '0', '0', '0'),
('stu3', '1', '3@126.com', '1', '1', '0', '0', '0', '0', '0', '0'),
('stu4', '1', '4@126.com', '1', '1', '0', '0', '0', '0', '0', '0'),
('stu5', '1', '5@126.com', '1', '1', '0', '0', '0', '0', '0', '0'),
('stu6', '1', '6@126.com', '1', '1', '0', '0', '0', '0', '0', '0'),
('stu7', '1', '7@126.com', '1', '1', '0', '0', '0', '0', '0', '0'),
('stu8', '1', '8@126.com', '1', '1', '0', '0', '0', '0', '0', '0'),
('stu9', '1', '9@126.com', '1', '1', '0', '0', '0', '0', '0', '0'),
('stu10', '1', '10@126.com', '1', '1', '0', '0', '0', '0', '0', '0'),
('stu11', '1', '11@126.com', '1', '1', '0', '0', '0', '0', '0', '0'),
('stu12', '1', '12@126.com', '1', '1', '0', '0', '0', '0', '0', '0'),
('stu13', '1', '13@126.com', '1', '1', '0', '0', '0', '0', '0', '0'),
('stu14', '1', '14@126.com', '1', '1', '0', '0', '0', '0', '0', '0'),
('stu15', '1', '15@126.com', '1', '1', '0', '0', '0', '0', '0', '0'),
('stu16', '1', '16@126.com', '1', '1', '0', '0', '0', '0', '0', '0'),
('stu17', '1', '17@126.com', '1', '1', '0', '0', '0', '0', '0', '0'),
('stu18', '1', '18@126.com', '1', '1', '0', '0', '0', '0', '0', '0'),
('stu19', '1', '19@126.com', '1', '1', '0', '0', '0', '0', '0', '0'),
('stu20', '1', '20@126.com', '1', '1', '0', '0', '0', '0', '0', '0');



INSERT INTO `auth` (`id`, `username`, `type`, `password`, `uid`, `add_time`, `remarks`, `is_del`, `status`)
VALUES
(NULL, '2201210601', '1', '123456', '1', '0', '0', '0', '0'),
(NULL, '2201210602', '1', '123456', '2', '0', '0', '0', '0'),
(NULL, '2201210603', '1', '123456', '3', '0', '0', '0', '0'),
(NULL, '2201210604', '1', '123456', '4', '0', '0', '0', '0'),
(NULL, '2201210605', '1', '123456', '5', '0', '0', '0', '0'),
(NULL, '2201210606', '1', '123456', '6', '0', '0', '0', '0'),
(NULL, '2201210607', '1', '123456', '7', '0', '0', '0', '0'),
(NULL, '2201210608', '1', '123456', '8', '0', '0', '0', '0'),
(NULL, '2201210609', '1', '123456', '9', '0', '0', '0', '0'),
(NULL, '2201210610', '1', '123456', '10', '0', '0', '0', '0'),
(NULL, '2201210611', '1', '123456', '11', '0', '0', '0', '0'),
(NULL, '2201210612', '1', '123456', '12', '0', '0', '0', '0'),
(NULL, '2201210613', '1', '123456', '13', '0', '0', '0', '0'),
(NULL, '2201210614', '1', '123456', '14', '0', '0', '0', '0'),
(NULL, '2201210615', '1', '123456', '15', '0', '0', '0', '0'),
(NULL, '2201210616', '1', '123456', '16', '0', '0', '0', '0'),
(NULL, '2201210617', '1', '123456', '17', '0', '0', '0', '0'),
(NULL, '2201210618', '1', '123456', '18', '0', '0', '0', '0'),
(NULL, '2201210619', '1', '123456', '19', '0', '0', '0', '0'),
(NULL, '2201210620', '1', '123456', '20', '0', '0', '0', '0');


INSERT INTO `student_info` (`id`, `uid`, `studentid`, `verification_code`, `class_id`, `remarks`, `status`)
VALUES
(NULL, '1', '2201210601', 'abcd', '1', '0', '0'),
(NULL, '2', '2201210602', 'abcd', '1', '0', '0'),
(NULL, '3', '2201210603', 'abcd', '1', '0', '0'),
(NULL, '4', '2201210604', 'abcd', '1', '0', '0'),
(NULL, '5', '2201210605', 'abcd', '1', '0', '0'),
(NULL, '6', '2201210606', 'abcd', '1', '0', '0'),
(NULL, '7', '2201210607', 'abcd', '1', '0', '0'),
(NULL, '8', '2201210608', 'abcd', '1', '0', '0'),
(NULL, '9', '2201210609', 'abcd', '1', '0', '0'),
(NULL, '10', '2201210610', 'abcd', '1', '0', '0'),
(NULL, '11', '2201210611', 'abcd', '1', '0', '0'),
(NULL, '12', '2201210612', 'abcd', '1', '0', '0'),
(NULL, '13', '2201210613', 'abcd', '1', '0', '0'),
(NULL, '14', '2201210614', 'abcd', '1', '0', '0'),
(NULL, '15', '2201210615', 'abcd', '1', '0', '0'),
(NULL, '16', '2201210616', 'abcd', '1', '0', '0'),
(NULL, '17', '2201210617', 'abcd', '1', '0', '0'),
(NULL, '18', '2201210618', 'abcd', '1', '0', '0'),
(NULL, '19', '2201210619', 'abcd', '1', '0', '0'),
(NULL, '20', '2201210620', 'abcd', '1', '0', '0');

INSERT INTO `groups` (`id`, `name`, `invite_code`, `describe`, `is_del`, `status`)
VALUES
(NULL, 'Java-1队', 'abc-1', 'Hello World', '0', '0'),
(NULL, 'Java-2队', 'abc-2', 'Hello World', '0', '0'),
(NULL, 'Java-3队', 'abc-3', 'Hello World', '0', '0'),
(NULL, 'Java-4队', 'abc-4', 'Hello World', '0', '0'),
(NULL, 'Java-5队', 'abc-5', 'Hello World', '0', '0'),
(NULL, 'Java-6队', 'abc-6', 'Hello World', '0', '0');

INSERT INTO `groups_user` (`id`, `uid`, `is_creator`, `group_id`, `is_del`, `join_time`, `leave_time`, `status`)
VALUES
(NULL, '1', '1', '1', '0', '1671193840', '0', '0'),
(NULL, '2', '0', '1', '0', '1671193840', '0', '0'),
(NULL, '3', '0', '1', '0', '1671193840', '0', '0'),
(NULL, '4', '1', '2', '0', '1671193840', '0', '0'),
(NULL, '5', '0', '2', '0', '1671193840', '0', '0'),
(NULL, '6', '0', '2', '0', '1671193840', '0', '0'),
(NULL, '7', '1', '3', '0', '1671193840', '0', '0'),
(NULL, '8', '0', '3', '0', '1671193840', '0', '0'),
(NULL, '9', '0', '3', '0', '1671193840', '0', '0'),
(NULL, '10', '1', '4', '0', '1671193840', '0', '0'),
(NULL, '11', '0', '4', '0', '1671193840', '0', '0');

INSERT INTO `rooms` (`id`, `building_id`, `name`, `gender`, `order_num`, `is_valid`, `remarks`, `describe`, `image_url`, `is_del`, `status`)
VALUES
(NULL, 4, 'E3325', 1, 1, 1, ' ', ' ', ' ', 0, 0),
(NULL, 4, 'E3326', 1, 2, 1, ' ', ' ', ' ', 0, 0),
(NULL, 1, '5101', 0, 3, 1, ' ', ' ', ' ', 0, 0),
(NULL, 2, '8101', 1, 4, 1, ' ', ' ', ' ', 0, 0),
(NULL, 3, '9101', 1, 5, 1, ' ', ' ', ' ', 0, 0),
(NULL, 5, 'E3114', 0, 6, 1, ' ', ' ', ' ', 0, 0),
(NULL, 1, '5201', 1, 7, 1, ' ', ' ', ' ', 0, 0),
(NULL, 1, '5202', 1, 8, 1, ' ', ' ', ' ', 0, 0);

INSERT INTO `beds` (`id`, `uid`, `room_id`, `name`, `order_num`, `is_valid`, `remarks`, `is_del`, `status`) 
VALUES 
(NULL, 1, 6, '1', 1, 1, '', 0, 0),
(NULL, 2, 6, '2', 1, 1, '', 0, 0),
(NULL, 0, 1, '1', 2, 1, ' ', 0, 0),
(NULL, 0, 3, '2', 3, 1, ' ', 0, 0),
(NULL, 2, 5, '2', 4, 1, '  ', 0, 0),
(NULL, 0, 2, '3', 5, 1, ' ', 0, 0),
(NULL, 0, 1, '2', 6, 1, ' ', 0, 0),
(NULL, 0, 7, '1', 7, 1, ' ', 0, 0),
(NULL, 0, 7, '2', 8, 1, ' ', 0, 0),
(NULL, 0, 8, '1', 9, 1, ' ', 0, 0),
(NULL, 0, 7, '3', 7, 1, ' ', 0, 0);

INSERT INTO `sys` (`id`, `key_name`, `key_value`, `is_del`, `remarks`) 
VALUES 
(NULL, 'start_time', '1669111200', 0, '选宿舍开始时间'),
(NULL, 'end_time', '1669118400', 0, '选宿舍结束时间'),
(NULL, 'class_limit', '0', 0, '1为限制以班级为单位组队及分配宿舍，0为不限制\r\n'),
(NULL, 'group_limit', '0', 0, '1为不允许组队，0为允许组队\r\n'),
(NULL, 'group_num', '4', 0, '通常为2-4\r\n');

INSERT INTO `class` (`id`, `name`, `remarks`, `is_del`, `status`) VALUES (NULL, '未名一苑', '0', '0', '0');