代码拉取完成，页面将自动刷新
/*
Navicat Premium Data Transfer
Source Server : mydb_3306
Source Server Type : MySQL
Source Server Version : 50726
Source Host : localhost:3306
Source Schema : mydb
Target Server Type : MySQL
Target Server Version : 50726
File Encoding : 65001
Date: 30/03/2021 15:40:31
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for class_and_set
-- ----------------------------
DROP TABLE IF EXISTS `class_and_set`;
CREATE TABLE `class_and_set` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`class_id` int(10) NULL DEFAULT NULL,
`set_id` int(10) NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `class_id`(`class_id`) USING BTREE,
INDEX `set_id`(`set_id`) USING BTREE,
CONSTRAINT `class_and_set_ibfk_1` FOREIGN KEY (`class_id`) REFERENCES `class_information` (`class_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `class_and_set_ibfk_2` FOREIGN KEY (`set_id`) REFERENCES `test_set` (`set_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of class_and_set
-- ----------------------------
-- ----------------------------
-- Table structure for class_information
-- ----------------------------
DROP TABLE IF EXISTS `class_information`;
CREATE TABLE `class_information` (
`class_id` int(10) NOT NULL AUTO_INCREMENT,
`class_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`teach_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`teach_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
PRIMARY KEY (`class_id`) USING BTREE,
INDEX `class_id`(`class_id`, `class_name`, `teach_id`, `teach_name`) USING BTREE,
INDEX `teach_id`(`teach_id`, `teach_name`) USING BTREE,
INDEX `class_id_2`(`class_id`, `teach_id`, `teach_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 30 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of class_information
-- ----------------------------
INSERT INTO `class_information` VALUES (3, '2018级计算机三班', '311002', '张三');
INSERT INTO `class_information` VALUES (4, '2018级计算机二班', '311001', '郑炜');
INSERT INTO `class_information` VALUES (21, '19级计算机1班', '311001', '郑炜');
INSERT INTO `class_information` VALUES (24, '2019级计算机5班', '311001', '郑炜');
INSERT INTO `class_information` VALUES (27, '19级计算机1班', '311001', '郑炜');
INSERT INTO `class_information` VALUES (28, '计算机197', '311001', '郑炜');
INSERT INTO `class_information` VALUES (29, '测试1班', '311001', '郑炜');
-- ----------------------------
-- Table structure for stu_and_class
-- ----------------------------
DROP TABLE IF EXISTS `stu_and_class`;
CREATE TABLE `stu_and_class` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`stu_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`class_id` int(10) NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `stu_id`(`stu_id`) USING BTREE,
INDEX `class_id`(`class_id`) USING BTREE,
CONSTRAINT `stu_and_class_ibfk_1` FOREIGN KEY (`stu_id`) REFERENCES `stu_information` (`stu_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `stu_and_class_ibfk_2` FOREIGN KEY (`class_id`) REFERENCES `class_information` (`class_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of stu_and_class
-- ----------------------------
INSERT INTO `stu_and_class` VALUES (32, '3190421117', 4);
INSERT INTO `stu_and_class` VALUES (33, '3190421119', 4);
-- ----------------------------
-- Table structure for stu_and_set
-- ----------------------------
DROP TABLE IF EXISTS `stu_and_set`;
CREATE TABLE `stu_and_set` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`stu_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`set_id` int(10) NOT NULL,
`total_score` int(255) NULL DEFAULT 0,
`open` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT 'no',
PRIMARY KEY (`id`) USING BTREE,
INDEX `set_id`(`set_id`) USING BTREE,
INDEX `stu_id`(`stu_id`) USING BTREE,
CONSTRAINT `stu_and_set_ibfk_1` FOREIGN KEY (`set_id`) REFERENCES `test_set` (`set_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 39 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of stu_and_set
-- ----------------------------
INSERT INTO `stu_and_set` VALUES (38, '311001', 14, 0, 'yes');
-- ----------------------------
-- Table structure for stu_homework
-- ----------------------------
DROP TABLE IF EXISTS `stu_homework`;
CREATE TABLE `stu_homework` (
`homework_id` int(50) NOT NULL AUTO_INCREMENT,
`stu_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`stu_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`test_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'type:\r\nselect——选择题\r\nmuti——多选题\r\nfill——填空题\r\nessay——简答题\r\nexperience——实验题\r\njudge——判断题',
`test_id` int(10) NOT NULL,
`test_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`set_id` int(10) NULL DEFAULT NULL,
`set_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
`homework_file` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '实验题上传文件',
`finish` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'no',
`score` int(8) NULL DEFAULT NULL,
`comment` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'md文件路径',
`fill_answer` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '填空题的答案',
`select_answer` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '单选题答案，如：A',
`muti_answer` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '多选题答案，如：ABC',
`judge_answer` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '判断题答案，如：true',
`essay_answer` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '简答题答案或实验题答案（md文件路径）',
PRIMARY KEY (`homework_id`) USING BTREE,
INDEX `test_id`(`test_id`) USING BTREE,
INDEX `stu_id`(`stu_id`) USING BTREE,
INDEX `set_id`(`set_id`) USING BTREE,
CONSTRAINT `stu_homework_ibfk_1` FOREIGN KEY (`stu_id`) REFERENCES `stu_and_set` (`stu_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `stu_homework_ibfk_2` FOREIGN KEY (`set_id`) REFERENCES `stu_and_set` (`set_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of stu_homework
-- ----------------------------
INSERT INTO `stu_homework` VALUES (3, '311001', '郑炜', 'experience', 3, '一位全加器', 14, '题目集一', 'http://218.244.149.226:8181/file/homework/20201230015734427_homework_LED计数器电路.circ', 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `stu_homework` VALUES (4, '311001', '郑炜', 'experience', 3, '一位全加器', 14, '题目集一', NULL, 'no', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-- ----------------------------
-- Table structure for stu_information
-- ----------------------------
DROP TABLE IF EXISTS `stu_information`;
CREATE TABLE `stu_information` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`stu_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
`stu_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `stu_id`(`stu_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 97 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of stu_information
-- ----------------------------
INSERT INTO `stu_information` VALUES (1, '3180421050', '张昱');
INSERT INTO `stu_information` VALUES (4, '3180421051', '林琦凡');
INSERT INTO `stu_information` VALUES (5, '3180421053', '杜浩伟');
INSERT INTO `stu_information` VALUES (56, '3180421055', '张三');
INSERT INTO `stu_information` VALUES (57, '3180421056', '张四');
INSERT INTO `stu_information` VALUES (58, '3190432879', '张五');
INSERT INTO `stu_information` VALUES (59, '3190432854', '张9');
INSERT INTO `stu_information` VALUES (60, '3190432851', '张七');
INSERT INTO `stu_information` VALUES (61, '3190432824', '张八');
INSERT INTO `stu_information` VALUES (62, '3190432853', '张九');
INSERT INTO `stu_information` VALUES (63, '3180421355', '宝宝');
INSERT INTO `stu_information` VALUES (64, '3190421114', '江蕾');
INSERT INTO `stu_information` VALUES (73, '3190421113', '小明');
INSERT INTO `stu_information` VALUES (74, '3190421115', '小红');
INSERT INTO `stu_information` VALUES (94, '3190421117', '小紫');
INSERT INTO `stu_information` VALUES (95, '3190421119', '小蓝');
INSERT INTO `stu_information` VALUES (96, '3180421059', '张昱');
-- ----------------------------
-- Table structure for teach_information
-- ----------------------------
DROP TABLE IF EXISTS `teach_information`;
CREATE TABLE `teach_information` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
`teach_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '教师id',
`teach_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '教师名称',
PRIMARY KEY (`id`) USING BTREE,
INDEX `teach_id`(`teach_id`, `teach_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of teach_information
-- ----------------------------
INSERT INTO `teach_information` VALUES (4, '310101', '测试2');
INSERT INTO `teach_information` VALUES (1, '311001', '郑炜');
INSERT INTO `teach_information` VALUES (2, '311002', '张三');
-- ----------------------------
-- Table structure for test_and_set
-- ----------------------------
DROP TABLE IF EXISTS `test_and_set`;
CREATE TABLE `test_and_set` (
`id` int(255) NOT NULL AUTO_INCREMENT COMMENT '主键',
`test_id` int(10) NOT NULL COMMENT '题目id',
`set_id` int(10) NOT NULL COMMENT '题目集id',
`test_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '题目类型',
PRIMARY KEY (`id`) USING BTREE,
INDEX `test_id`(`test_id`) USING BTREE,
INDEX `set_id`(`set_id`) USING BTREE,
CONSTRAINT `test_and_set_ibfk_1` FOREIGN KEY (`test_id`) REFERENCES `test_information` (`test_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `test_and_set_ibfk_2` FOREIGN KEY (`set_id`) REFERENCES `test_set` (`set_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of test_and_set
-- ----------------------------
INSERT INTO `test_and_set` VALUES (13, 3, 14, 'experience');
-- ----------------------------
-- Table structure for test_information
-- ----------------------------
DROP TABLE IF EXISTS `test_information`;
CREATE TABLE `test_information` (
`test_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '题目id',
`test_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '题目名称',
`test_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'type:\r\nselect——选择题\r\nmuti——多选题\r\nfill——填空题\r\nessay——简答题\r\nexperience——实验题\r\njudge——判断题',
`author_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '作者姓名',
`teach_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '教师id',
`test_content` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '题目内容',
`test_doc` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '题目文件',
`test_mp4` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '题目视频',
`create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间',
`update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
`select_a` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '选项A',
`select_b` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '选项B',
`select_c` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '选项C',
`select_d` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '选项D',
`fill_answer` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '填空题的答案',
`select_answer` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '单选题答案，如：A',
`muti_answer` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '多选题答案，如：ABC',
`judge_true` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '判断题答案正确',
`judge_false` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '判断题答案错误',
`judge_answer` varchar(5) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT 'true或者false',
`total_score` int(8) NULL DEFAULT NULL COMMENT '总分',
PRIMARY KEY (`test_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of test_information
-- ----------------------------
INSERT INTO `test_information` VALUES (1, '一位全加器', 'experience', '郑炜', '311001', 'http://218.244.149.226:8181/file/md/20201117074451205_content_1.md', 'http://218.244.149.226:8181/file/doc/20201112061401691_doc_实验6 数据更新.doc', 'http://218.244.149.226:8181/file/mp4/20201112061611360_mp4_实验.mp4', '2020-01-01 10:00:00', '2020-11-17 19:44:51', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 100);
INSERT INTO `test_information` VALUES (3, '一位全加器', 'experience', '郑炜', '311001', '请用logisim设计一个一位全加器，并上传文件', '../doc/一位全加器.doc', '../mp4/一位全加器.mp4', '2020-01-01 10:00:00', '2020-11-08 00:10:15', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 100);
INSERT INTO `test_information` VALUES (4, '一位全加器', 'experience', '郑炜', '311001', '请用logisim设计一个一位全加器，并上传文件', '../doc/一位全加器.doc', '../mp4/一位全加器.mp4', '2020-01-01 10:00:00', '2020-11-08 00:10:16', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 100);
INSERT INTO `test_information` VALUES (5, 'LED计数器', 'experience', '郑炜', '311001', '请用logisim设计一个LED计数器，并上传文件', '../doc/LED计数器.doc', '../mp4/LED计数器.mp4', '2020-01-01 10:00:00', '2020-11-08 00:10:17', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 100);
INSERT INTO `test_information` VALUES (6, '五输入按键编码器', 'experience', '张三', '311002', '请用logisim设计一个五输入按键编码器，并上传文件', '../doc/五输入按键编码器.doc', '../mp4/五输入按键编码器.mp4', '2020-01-01 10:00:00', '2020-11-08 00:10:51', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 100);
INSERT INTO `test_information` VALUES (7, '五输入按键编码器', 'experience', '张三', '311002', '请用logisim设计一个五输入按键编码器，并上传文件', '../doc/五输入按键编码器.doc', '../mp4/五输入按键编码器.mp4', '2020-01-01 10:00:00', '2020-11-08 00:11:00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 100);
INSERT INTO `test_information` VALUES (8, '一位全加器', 'experience', '郑炜', '311001', NULL, NULL, NULL, '2020-12-13 15:28:48', '2020-12-13 15:28:48', '', '', '', '', '', '', '', '', '', '', 30);
INSERT INTO `test_information` VALUES (9, 'test', 'muti', '郑炜', '311001', NULL, NULL, NULL, '2020-12-13 15:32:23', '2020-12-13 15:32:23', '', '', '', '', '', '', 'ABCD', '', '', '', 4);
INSERT INTO `test_information` VALUES (10, '一位全加器', 'experience', '郑炜', '311001', NULL, NULL, NULL, '2020-12-27 12:16:49', '2020-12-27 12:16:49', '', '', '', '', '', '', '', '', '', '', 30);
-- ----------------------------
-- Table structure for test_set
-- ----------------------------
DROP TABLE IF EXISTS `test_set`;
CREATE TABLE `test_set` (
`set_id` int(10) NOT NULL AUTO_INCREMENT COMMENT '题目集id，自增',
`set_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '题目集名称',
`teach_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '教师id',
`teach_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '教师名称',
`create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '创建时间,不用输入',
`update_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '更新时间',
`start_time` timestamp(0) NULL DEFAULT NULL COMMENT '开始时间',
`over_time` timestamp(0) NULL DEFAULT NULL COMMENT '结束时间',
PRIMARY KEY (`set_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of test_set
-- ----------------------------
INSERT INTO `test_set` VALUES (14, '题目集一', '311001', '郑炜', '2020-12-27 16:42:53', '2020-12-27 16:42:53', '2020-12-27 16:42:45', '2021-01-08 23:00:00');
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`username` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '用户名',
`password` varchar(512) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '密码',
`role` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '身份',
`perms` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '权限',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 105 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '主键' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, '3180421050', '51A787D5F91C805060493DEA4EAE12F4', 'student', 'normal');
INSERT INTO `user` VALUES (2, '3180421051', '7B65AE47009A45B87EF329A9371108F8', 'student', 'normal');
INSERT INTO `user` VALUES (3, '3180421053', 'E30A73DC60AE63CA600ADDB6DF45890D', 'student', 'normal');
INSERT INTO `user` VALUES (4, '311001', 'EB25A5A8628143EF97DE18CD09F6A980', 'teacher', 'manage');
INSERT INTO `user` VALUES (5, '001', 'DC5C7986DAEF50C1E02AB09B442EE34F', 'admin', 'super');
INSERT INTO `user` VALUES (37, '310101', '508648865001185B6A704E553C44B0D7', 'teacher', 'manage');
INSERT INTO `user` VALUES (39, '002', '93DD4DE5CDDBA2C733C65F233097F05A', 'admin', 'super');
INSERT INTO `user` VALUES (60, '3180421055', '3C26313F2C5EA45B8B69E7EB94392A19', 'student', 'normal');
INSERT INTO `user` VALUES (61, '3180421056', '6B05FFE87729E420DEDD55983BED7B45', 'student', 'normal');
INSERT INTO `user` VALUES (62, '3190432879', '752AA750473604B169D1C6A3968D0784', 'student', 'normal');
INSERT INTO `user` VALUES (63, '3190432854', '38E0DCEBB5E91B2F10BE8E89C9B250B9', 'student', 'normal');
INSERT INTO `user` VALUES (64, '3190432851', '0E446FAAC24844453B11599B7D4E6B20', 'student', 'normal');
INSERT INTO `user` VALUES (65, '3190432824', '574C2B5478F89C5929C74C3A44EBDEB0', 'student', 'normal');
INSERT INTO `user` VALUES (66, '3190432853', 'BC8D645F586F1570FF5FD0A366CE436A', 'student', 'normal');
INSERT INTO `user` VALUES (67, '3180421355', 'D2649272E2CCBB311907776272B9E82A', 'student', 'normal');
INSERT INTO `user` VALUES (69, '3190421114', '2FF72A41649D9DBC8D131EDD78241DDC', 'student', 'normal');
INSERT INTO `user` VALUES (80, '3190421113', '9222379ECBD461E04EF1892E811334BD', 'student', 'normal');
INSERT INTO `user` VALUES (81, '3190421115', '5819E5AC1E3734DB66C38C2E89FD1411', 'student', 'normal');
INSERT INTO `user` VALUES (85, '005', 'CE08BECC73195DF12D99D761BFBBA68D', 'admin', 'super');
INSERT INTO `user` VALUES (102, '3190421117', '1A29A946D23D039253BC22CA1AE6C26C', 'student', 'normal');
INSERT INTO `user` VALUES (103, '3190421119', '061DD1362A2C1A92E6C47187A957973C', 'student', 'normal');
INSERT INTO `user` VALUES (104, '3180421059', '03F742266EE4847105BC5CA94D99CEEC', 'student', 'normal');
SET FOREIGN_KEY_CHECKS = 1;
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手