text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : localhost
  Source Server Version : 50724
  Source Host           : localhost:3306
  Source Database       : exam_system
  
  Target Server Type    : MYSQL
  Target Server Version : 50724
  File Encoding         : 65001
  
  Date: 2021-02-08 14:17:55
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for answer
  -- ----------------------------
  DROP TABLE IF EXISTS `answer`;
  CREATE TABLE `answer` (
    `id` int(50) NOT NULL AUTO_INCREMENT COMMENT '答案表的主键',
    `all_option` longtext COMMENT '当前题目所有答案的信息',
    `images` longtext COMMENT '答案的图片路径',
    `analysis` longtext COMMENT '答案解析',
    `question_id` int(50) NOT NULL COMMENT '对应题目的id',
    `true_option` varchar(25) DEFAULT NULL COMMENT '正确的选项对应的下标',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4;
  
  -- ----------------------------
  -- Records of answer
  -- ----------------------------
  INSERT INTO `answer` VALUES ('1', '1,2', 'https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-10-26/b1535亚索锐雯.jpg', '1', '5', '0');
  INSERT INTO `answer` VALUES ('3', '语文,数学,英语,选修课', ',', null, '6', '0,1,2');
  INSERT INTO `answer` VALUES ('10', '0,1', '', '111', '11', '0');
  INSERT INTO `answer` VALUES ('11', '11,16', '', '16', '12', '1');
  INSERT INTO `answer` VALUES ('12', '9,8', '', '9', '13', '0');
  INSERT INTO `answer` VALUES ('13', '4,3', 'https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-10-27/1950327D.jpg', '4', '14', '0');
  INSERT INTO `answer` VALUES ('14', '18,11', 'https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-10-27/583a91522134986336591.jpg', '18', '15', '0');
  INSERT INTO `answer` VALUES ('15', '1', '', '1', '16', '0');
  INSERT INTO `answer` VALUES ('16', '4,3', '', '4', '17', '0');
  INSERT INTO `answer` VALUES ('17', '1,2,3,4', ',,,', null, '18', '0,1');
  INSERT INTO `answer` VALUES ('18', '奇数,偶数', '', '奇数', '19', '0');
  INSERT INTO `answer` VALUES ('19', '奇数,偶数', '', '奇数', '20', '0');
  INSERT INTO `answer` VALUES ('20', '111,222,333', '', null, '21', '0,1,2');
  INSERT INTO `answer` VALUES ('21', '1', '', '1', '22', '0');
  INSERT INTO `answer` VALUES ('22', '', '', '', '23', '0');
  
  -- ----------------------------
  -- Table structure for exam
  -- ----------------------------
  DROP TABLE IF EXISTS `exam`;
  CREATE TABLE `exam` (
    `exam_id` int(50) NOT NULL AUTO_INCREMENT,
    `exam_name` varchar(100) NOT NULL COMMENT '考试名称',
    `exam_desc` varchar(100) DEFAULT NULL COMMENT '考试描述',
    `type` int(15) NOT NULL DEFAULT '1' COMMENT '1完全公开  2需要密码',
    `password` varchar(50) DEFAULT NULL COMMENT '需要密码考试的密码',
    `duration` int(50) NOT NULL COMMENT '考试时长',
    `start_time` date DEFAULT NULL COMMENT '考试开始时间',
    `end_time` date DEFAULT NULL COMMENT '考试结束时间',
    `total_score` int(30) NOT NULL COMMENT '考试总分',
    `pass_score` int(30) NOT NULL COMMENT '考试通过线',
    `status` int(15) NOT NULL DEFAULT '1' COMMENT '1有效 2无效',
    PRIMARY KEY (`exam_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4;
  
  -- ----------------------------
  -- Records of exam
  -- ----------------------------
  INSERT INTO `exam` VALUES ('9', '小学入学考试', '对小学生做一个评估', '2', null, '1', null, null, '10', '6', '1');
  INSERT INTO `exam` VALUES ('10', '多选题练习考试', '滴滴', '1', null, '1', null, null, '2', '1', '1');
  INSERT INTO `exam` VALUES ('11', '测试123', '2113', '2', '12345', '1', '2020-11-01', null, '1', '1', '1');
  INSERT INTO `exam` VALUES ('12', '全能考试', '啥都考', '1', null, '4', null, null, '12', '7', '1');
  INSERT INTO `exam` VALUES ('13', '过期的考试', '测试过期', '1', null, '1', '2020-10-31', '2020-11-01', '3', '1', '1');
  INSERT INTO `exam` VALUES ('14', '阿达', '阿达', '1', null, '1', '2021-01-04', '2021-01-22', '3', '1', '1');
  INSERT INTO `exam` VALUES ('15', 'test', 'desc', '1', null, '2', '2021-01-03', '2021-01-19', '10', '1', '1');
  
  -- ----------------------------
  -- Table structure for exam_question
  -- ----------------------------
  DROP TABLE IF EXISTS `exam_question`;
  CREATE TABLE `exam_question` (
    `id` int(50) NOT NULL AUTO_INCREMENT,
    `question_ids` varchar(100) NOT NULL COMMENT '考试的题目id列表',
    `exam_id` int(50) NOT NULL COMMENT '考试的id',
    `scores` varchar(100) NOT NULL COMMENT '每一题的分数',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4;
  
  -- ----------------------------
  -- Records of exam_question
  -- ----------------------------
  INSERT INTO `exam_question` VALUES ('5', '12,13,15,3,6,8,18,11,19,14', '9', '1,1,1,1,1,1,1,1,1,1');
  INSERT INTO `exam_question` VALUES ('6', '6,18', '10', '1,1');
  INSERT INTO `exam_question` VALUES ('7', '3', '11', '1');
  INSERT INTO `exam_question` VALUES ('8', '3,6,8,11,12,13,14,15,18,19,20,21', '12', '1,1,1,1,1,1,1,1,1,1,1,1');
  INSERT INTO `exam_question` VALUES ('9', '18,19,15', '13', '1,1,1');
  INSERT INTO `exam_question` VALUES ('12', '3,21,22', '14', '1,1,1');
  INSERT INTO `exam_question` VALUES ('13', '11,8,3,12,13,14,18,15,19,6', '15', '1,1,1,1,1,1,1,1,1,1');
  
  -- ----------------------------
  -- Table structure for exam_record
  -- ----------------------------
  DROP TABLE IF EXISTS `exam_record`;
  CREATE TABLE `exam_record` (
    `record_id` int(50) NOT NULL AUTO_INCREMENT COMMENT '考试记录的id',
    `user_id` int(50) NOT NULL COMMENT '考试用户的id',
    `user_answers` longtext NOT NULL COMMENT '用户的答案列表',
    `credit_img_url` longtext COMMENT '考试诚信截图',
    `exam_id` int(50) NOT NULL COMMENT '考试的id',
    `logic_score` int(50) DEFAULT NULL COMMENT '考试的逻辑得分(除简答)',
    `exam_time` datetime NOT NULL COMMENT '考试时间',
    `question_ids` varchar(150) NOT NULL COMMENT '考试的题目信息',
    `total_score` int(50) DEFAULT NULL COMMENT '考试总分数 (逻辑+简答)',
    `error_question_ids` varchar(50) DEFAULT NULL COMMENT '用户考试的错题',
    PRIMARY KEY (`record_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4;
  
  -- ----------------------------
  -- Records of exam_record
  -- ----------------------------
  INSERT INTO `exam_record` VALUES ('1', '1', '1-1-0-1-0-1,2-1,2-1-java是全世界最好的语言.jpg-小学是童年', 'https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-11-05/b09d7examTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-11-05/ab243examTakePhoto.png', '9', '3', '2020-11-05 19:28:40', '11,13,14,12,15,6,18,19,3,8', '5', '11,13,6,18,19,14');
  INSERT INTO `exam_record` VALUES ('2', '1', '1', 'https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-11-07/95c31examTakePhoto.png', '11', '0', '2020-11-07 11:34:50', '3', '1', null);
  INSERT INTO `exam_record` VALUES ('3', '1', '0-1-0-0-0-0,1,2-0,1-0,1,2-0-0-12345-56', 'https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-11-08/2d0e2examTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-11-08/bbca9examTakePhoto.png', '12', '10', '2020-11-08 09:15:16', '11,12,13,14,15,6,18,21,19,20,3,8', '12', null);
  INSERT INTO `exam_record` VALUES ('4', '2', '0-0-0-1-0-0,1,2-0,1-0-wqe-eqweq', 'https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-11-08/411a8examTakePhoto.png', '9', '8', '2020-11-08 09:20:27', '11,13,14,12,15,6,18,19,3,8', '10', null);
  INSERT INTO `exam_record` VALUES ('5', '2', '0,1,2-1,2', 'https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-11-08/ebdd9examTakePhoto.png', '10', '1', '2020-11-08 10:57:00', '6,18', '1', '18');
  INSERT INTO `exam_record` VALUES ('6', '1', '0-0-0-0-1-1-2-1-23-156', 'https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/8c282examTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/7fdf0examTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/ca048examTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/2cafcexamTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/bbf68examTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/977b7examTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/f8061examTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/948c5examTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/eff69examTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/811aaexamTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/d9279examTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/3fc0cexamTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/6ff2eexamTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/c4400examTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/243b6examTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/07a2fexamTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/f1176examTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/07c1bexamTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/d0a45examTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/b8037examTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/95438examTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/b185dexamTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/259b8examTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/a8a37examTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/08f17examTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/329a5examTakePhoto.png', '9', '5', '2020-12-01 21:41:58', '11,15,13,14,12,18,6,19,3,8', null, '18,6,19');
  INSERT INTO `exam_record` VALUES ('7', '1', '0-0-0-1-0-0,1,2-0,1-0-java-大大', 'https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/41206examTakePhoto.png', '9', '8', '2020-12-01 21:45:30', '11,13,14,12,15,6,18,19,3,8', null, null);
  INSERT INTO `exam_record` VALUES ('9', '1', '0-1-0-0-0-1-2-1-是-sad', 'https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-12-01/0fe10examTakePhoto.png', '9', '3', '2020-12-01 21:48:45', '11,13,14,12,15,6,18,19,3,8', null, '13,12,6,18,19');
  INSERT INTO `exam_record` VALUES ('10', '1', '0-0-0-0-0-1,3-1,2,3-1-656', 'https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2021-01-14/b9f75examTakePhoto.png,https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2021-01-14/bc3f7examTakePhoto.png', '9', '4', '2021-01-14 18:45:42', '12,13,15,11,14,6,18,19,3,8', '6', '12,6,18,19');
  INSERT INTO `exam_record` VALUES ('14', '1', '0-1-0-1-1-1--1 -', 'https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2021-01-15/eb067examTakePhoto.png', '9', '1', '2021-01-15 10:25:05', '12,11,14,13,15,6,18,19,3,8', null, '12,11,13,15,6,18,19');
  INSERT INTO `exam_record` VALUES ('15', '2', '1-0-0 - - - - - -', '', '9', '2', '2021-01-15 10:18:54', '12,13,15,11,14,6,18,19,3,8', '4', '15,11,14,6,18,19');
  INSERT INTO `exam_record` VALUES ('16', '1', '- - - - - - - - - - - -  - - - - - - - - - - - -', '', '12', '0', '2021-02-08 13:31:19', '11,12,13,14,15,6,18,21,19,20,3,8', null, '11,12,13,14,15,6,18,21,19,20');
  INSERT INTO `exam_record` VALUES ('17', '1', '0------0,1,2----java web-php web', '', '12', '1', '2021-02-08 13:38:39', '11,12,13,14,15,6,18,21,19,20,3,8', null, '12,13,14,15,6,18,21,19,20');
  INSERT INTO `exam_record` VALUES ('18', '1', '0,1,2-0,1', '', '10', '2', '2021-02-08 13:38:57', '6,18', null, null);
  
  -- ----------------------------
  -- Table structure for notice
  -- ----------------------------
  DROP TABLE IF EXISTS `notice`;
  CREATE TABLE `notice` (
    `n_id` int(64) NOT NULL AUTO_INCREMENT COMMENT '系统公告id',
    `content` longtext NOT NULL COMMENT '公告内容',
    `create_time` datetime DEFAULT NULL COMMENT '公告创建时间',
    `update_time` datetime DEFAULT NULL COMMENT '更新此公告时间',
    `status` tinyint(2) NOT NULL DEFAULT '0' COMMENT '0(不是当前系统公告) 1(是当前系统公告)',
    PRIMARY KEY (`n_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
  
  -- ----------------------------
  -- Records of notice
  -- ----------------------------
  INSERT INTO `notice` VALUES ('1', '<ul><li><font color=\"#c24f4a\">2020/11/14 更新:</font></li><ol><li>网易云音乐线上体验地址:&nbsp;<a href=\"http://music.hjqz.fun/\" target=\"_blank\">http://music.hjqz.fun</a></li><li>博客系统线上体验地址:&nbsp;<a href=\"http://blog.hjqz.fun/\" target=\"_blank\">http://blog.hjqz.fun</a>&nbsp;&nbsp;<span style=\"background-color: rgb(249, 150, 59);\">(账号:hjq 密码:111)</span></li><li>考试系统线上体验地址:&nbsp;<a href=\"http://exam.hjqz.fun/\" target=\"_blank\">http://exam.hjqz.fun</a>&nbsp;<span style=\"background-color: rgb(249, 150, 59);\">(账号:hjq 密码:12345)</span></li></ol><p><span style=\"background-color: rgb(249, 150, 59);\">为了各位有良好的体验,请不要更改演示账号的权限以及密码</span></p></ul><hr/><ul><li><span style=\"color: rgb(194, 79, 74); text-align: initial;\">2021/02/07更新:</span></li></ul><ul><ol><li>注册验证码校验</li><li>主页面小屏样式更改</li><li>题库训练弹窗在小屏样式调整</li><li>修复添加考试时选择需要密码权限时,密码为空的情况</li><li>修复更新考试时选择需要密码权限时,密码为空的情况</li><li><font color=\"#f9963b\" style=\"background-color: rgb(238, 236, 224);\">新增</font><font color=\"#f9963b\" style=\"\"><span style=\"background-color: rgb(139, 170, 74);\">公告</span><span style=\"background-color: rgb(238, 236, 224);\">功能</span></font>(管理员可改,其他用户可以查看公告)</li><li>修复考试提交试卷业务逻辑BUG</li></ol></ul><hr/><ul><li><font color=\"#c24f4a\">2021/02/08更新:</font><br/></li><ol><li><span style=\"background-color: rgb(249, 150, 59);\">新增测验通过之后的</span><span style=\"background-color: rgb(139, 170, 74);\">发放证书</span><span style=\"background-color: rgb(249, 150, 59);\">功能 (我的成绩模块中)</span></li><li>&nbsp;考试多选题结果数据过滤逻辑优化</li></ol></ul>', '2021-02-07 15:52:45', '2021-02-08 14:10:45', '1');
  INSERT INTO `notice` VALUES ('4', '<p>发布公告测试<br/></p>', '2021-02-07 17:02:07', '2021-02-07 17:05:13', '0');
  
  -- ----------------------------
  -- Table structure for question
  -- ----------------------------
  DROP TABLE IF EXISTS `question`;
  CREATE TABLE `question` (
    `id` int(50) NOT NULL AUTO_INCREMENT,
    `qu_content` longtext NOT NULL COMMENT '问题内容',
    `create_time` datetime NOT NULL COMMENT '创建时间',
    `create_person` varchar(50) NOT NULL COMMENT '创建人',
    `qu_type` int(10) NOT NULL COMMENT '问题类型 1单选 2多选 3判断 4简答',
    `level` int(10) NOT NULL DEFAULT '1' COMMENT '题目难度 1简单 2中等 3困难',
    `image` longtext COMMENT '图片',
    `qu_bank_id` varchar(40) NOT NULL COMMENT '所属题库id',
    `qu_bank_name` varchar(255) NOT NULL COMMENT '所属题库名称',
    `analysis` varchar(255) DEFAULT NULL COMMENT '解析',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4;
  
  -- ----------------------------
  -- Records of question
  -- ----------------------------
  INSERT INTO `question` VALUES ('3', '实现web后端的语言', '2020-10-24 16:30:08', 'hjq', '4', '2', null, '1,2,5', '小学数学题库,生活小常识,java开发', '解析');
  INSERT INTO `question` VALUES ('6', '以下哪些语言是必修课', '2020-11-02 10:11:28', 'hjq', '2', '1', null, '1,5', '小学数学题库,java开发', '语文 数学 英语');
  INSERT INTO `question` VALUES ('8', '说说小学是什么样的?', '2020-11-02 10:12:02', 'hjq', '4', '3', null, '1,5', '小学数学题库,java开发', '说亲身经历即可');
  INSERT INTO `question` VALUES ('11', '1-1', '2020-10-27 14:35:33', 'hjq', '1', '1', null, '1,5', '小学数学题库,java开发', '0');
  INSERT INTO `question` VALUES ('12', '8+8', '2020-10-27 15:32:44', 'hjq', '1', '3', null, '1,5', '小学数学题库,java开发', '16');
  INSERT INTO `question` VALUES ('13', '1 * 9', '2020-10-27 15:13:38', 'hjq', '1', '1', null, '1,5', '小学数学题库,java开发', '9');
  INSERT INTO `question` VALUES ('14', '2+2', '2020-10-27 16:17:09', 'hjq', '1', '1', 'https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-10-27/e4f71d9b67b4a15ce2ec638c908b00dc506ab.png', '1,5', '小学数学题库,java开发', '4');
  INSERT INTO `question` VALUES ('15', '9+9', '2020-10-27 15:53:14', 'hjq', '1', '1', 'https://wangsiryun.oss-cn-beijing.aliyuncs.com/images/upload/2020-10-27/47ccdd9b67b4a15ce2ec638c908b00dc506ab.png', '1,5', '小学数学题库,java开发', '18');
  INSERT INTO `question` VALUES ('18', '最接近0的两个数', '2020-11-02 10:09:13', 'hjq', '2', '2', null, '1', '小学数学题库', '1和2');
  INSERT INTO `question` VALUES ('19', '1是不是奇数', '2020-10-31 14:54:09', 'hjq', '3', '1', null, '1', '小学数学题库', '是');
  INSERT INTO `question` VALUES ('20', '9是奇数还是偶数', '2020-11-02 10:21:19', 'hjq', '3', '1', null, '1', '小学数学题库', '奇数');
  INSERT INTO `question` VALUES ('21', '哪几个是三位数', '2020-11-05 14:42:56', 'hjq', '2', '1', null, '1,2', '小学数学题库,生活小常识', '数数');
  INSERT INTO `question` VALUES ('22', '测试', '2020-12-27 21:03:31', 'hjq', '1', '1', null, '2', '生活小常识', '测试');
  
  -- ----------------------------
  -- Table structure for question_bank
  -- ----------------------------
  DROP TABLE IF EXISTS `question_bank`;
  CREATE TABLE `question_bank` (
    `bank_id` int(40) NOT NULL AUTO_INCREMENT,
    `bank_name` varchar(100) NOT NULL,
    PRIMARY KEY (`bank_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;
  
  -- ----------------------------
  -- Records of question_bank
  -- ----------------------------
  INSERT INTO `question_bank` VALUES ('1', '小学数学题库');
  INSERT INTO `question_bank` VALUES ('2', '生活小常识');
  INSERT INTO `question_bank` VALUES ('5', 'java开发');
  
  -- ----------------------------
  -- Table structure for user
  -- ----------------------------
  DROP TABLE IF EXISTS `user`;
  CREATE TABLE `user` (
    `id` int(50) NOT NULL AUTO_INCREMENT,
    `role_id` int(10) NOT NULL DEFAULT '1' COMMENT '1(学生) 2(教师) 3(管理员)',
    `username` varchar(100) NOT NULL,
    `true_name` varchar(50) NOT NULL,
    `password` varchar(100) NOT NULL,
    `salt` varchar(30) NOT NULL,
    `status` int(10) NOT NULL DEFAULT '1' COMMENT '用户是否被禁用 1正常 2禁用',
    `create_date` datetime NOT NULL COMMENT '用户创建时间',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4;
  
  -- ----------------------------
  -- Records of user
  -- ----------------------------
  
  
  -- ----------------------------
  -- Table structure for user_role
  -- ----------------------------
  DROP TABLE IF EXISTS `user_role`;
  CREATE TABLE `user_role` (
    `id` int(10) NOT NULL,
    `role_id` int(10) NOT NULL DEFAULT '1' COMMENT '1学生 2教师 3超级管理员',
    `role_name` varchar(15) NOT NULL,
    `menu_info` longtext NOT NULL COMMENT '主页的菜单信息',
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  
  -- ----------------------------
  -- Records of user_role
  -- ----------------------------
  INSERT INTO `user_role` VALUES ('1', '1', '学生', '[{\"topMenuName\":\"系统介绍\",\"topIcon\":\"el-icon-odometer\",\"url\":\"/dashboard\"},{\"topMenuName\":\"在线考试\",\"topIcon\":\"el-icon-menu\",\"submenu\":[{\"name\":\"在线考试\",\"icon\":\"el-icon-s-promotion\",\"url\":\"/examOnline\"},{\"name\":\"我的成绩\",\"icon\":\"el-icon-trophy\",\"url\":\"/myGrade\"},{\"name\":\"我的题库\",\"icon\":\"el-icon-notebook-2\",\"url\":\"/myQuestionBank\"}]}]');
  INSERT INTO `user_role` VALUES ('2', '2', '教师', '[{\"topMenuName\":\"系统介绍\",\"topIcon\":\"el-icon-odometer\",\"url\":\"/dashboard\"},{\"topMenuName\":\"考试管理\",\"topIcon\":\"el-icon-bangzhu\",\"submenu\":[{\"name\":\"题库管理\",\"icon\":\"el-icon-aim\",\"url\":\"/questionBankMange\"},{\"name\":\"试题管理\",\"icon\":\"el-icon-news\",\"url\":\"/questionManage\"},{\"name\":\"考试管理\",\"icon\":\"el-icon-tickets\",\"url\":\"/examManage\"},{\"name\":\"阅卷管理\",\"icon\":\"el-icon-view\",\"url\":\"/markManage\"}]},{\"topMenuName\":\"考试统计\",\"topIcon\":\"el-icon-pie-chart\",\"submenu\":[{\"name\":\"统计总览\",\"icon\":\"el-icon-data-line\",\"url\":\"/staticOverview\"}]}]');
  INSERT INTO `user_role` VALUES ('3', '3', '超级管理员', '[{\"topMenuName\":\"系统介绍\",\"topIcon\":\"el-icon-odometer\",\"url\":\"/dashboard\"},{\"topMenuName\":\"在线考试\",\"topIcon\":\"el-icon-menu\",\"submenu\":[{\"name\":\"在线考试\",\"icon\":\"el-icon-s-promotion\",\"url\":\"/examOnline\"},{\"name\":\"我的成绩\",\"icon\":\"el-icon-trophy\",\"url\":\"/myGrade\"},{\"name\":\"我的题库\",\"icon\":\"el-icon-notebook-2\",\"url\":\"/myQuestionBank\"}]},{\"topMenuName\":\"考试管理\",\"topIcon\":\"el-icon-bangzhu\",\"submenu\":[{\"name\":\"题库管理\",\"icon\":\"el-icon-aim\",\"url\":\"/questionBankMange\"},{\"name\":\"试题管理\",\"icon\":\"el-icon-news\",\"url\":\"/questionManage\"},{\"name\":\"考试管理\",\"icon\":\"el-icon-tickets\",\"url\":\"/examManage\"},{\"name\":\"阅卷管理\",\"icon\":\"el-icon-view\",\"url\":\"/markManage\"}]},{\"topMenuName\":\"考试统计\",\"topIcon\":\"el-icon-pie-chart\",\"submenu\":[{\"name\":\"统计总览\",\"icon\":\"el-icon-data-line\",\"url\":\"/staticOverview\"}]},{\"topMenuName\":\"系统设置\",\"topIcon\":\"el-icon-setting\",\"submenu\":[{\"name\":\"公告管理\",\"icon\":\"el-icon-bell\",\"url\":\"/noticeManage\"},{\"name\":\"角色管理\",\"icon\":\"el-icon-s-custom\",\"url\":\"/roleManage\"},{\"name\":\"用户管理\",\"icon\":\"el-icon-user-solid\",\"url\":\"/userManage\"}]}]');
  