数据库脚本

于 2022-11-21 22:44:02 发布
阅读量702 收藏
点赞数
文章标签： 数据库 java spring cloud
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/m0_53524766/article/details/127974155
版权

目录

在这里插入图片描述

soul_exam.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 50720
Source Host           : localhost:3306
Source Database       : soul_exam

Target Server Type    : MYSQL
Target Server Version : 50720
File Encoding         : 65001

Date: 2020-07-28 08:49:43
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `exam_paper`
-- ----------------------------
DROP TABLE IF EXISTS `exam_paper`;
CREATE TABLE `exam_paper` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '试卷名',
  `status` int(5) DEFAULT NULL COMMENT '试卷状态 0为无效  1为有效',
  `startTime` datetime DEFAULT NULL COMMENT '开始时间',
  `endTime` datetime DEFAULT NULL COMMENT '结束时间',
  `isStart` int(5) DEFAULT '1' COMMENT '是否开始考试 0 关闭 1开始',
  `createTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10016 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of exam_paper
-- ----------------------------
INSERT INTO `exam_paper` VALUES ('10001', 'PHP卷一', '1', '2016-12-24 14:00:00', '2016-12-24 14:30:00', '1', null);
INSERT INTO `exam_paper` VALUES ('10002', 'SpringBoot卷二', '1', '2016-12-24 16:00:00', '2016-12-24 17:00:00', '1', null);
INSERT INTO `exam_paper` VALUES ('10003', 'SpringCloud卷三', '1', '2016-12-25 09:00:00', '2016-12-25 10:00:00', '1', null);
INSERT INTO `exam_paper` VALUES ('10004', '分布式卷一', '0', '2016-12-27 09:00:00', '2016-12-27 10:00:00', '1', null);
INSERT INTO `exam_paper` VALUES ('10005', 'K8S卷二', '0', '2016-12-27 15:25:24', '2016-12-27 15:25:24', '1', null);
INSERT INTO `exam_paper` VALUES ('10006', 'Docker卷一', '0', '2016-12-27 15:23:56', '2016-12-27 15:23:56', '1', null);
INSERT INTO `exam_paper` VALUES ('10007', 'NOSQL卷二', '0', '2016-12-27 15:23:50', '2016-12-27 15:23:50', '1', null);
INSERT INTO `exam_paper` VALUES ('10008', '集群卷三', '1', '2016-12-28 15:36:00', '2016-12-30 15:36:00', '1', null);
INSERT INTO `exam_paper` VALUES ('10009', '微服务卷一', '0', '2016-12-28 15:57:23', '2016-12-28 15:57:23', '1', null);
INSERT INTO `exam_paper` VALUES ('10010', 'JSP卷一', '0', '2016-12-30 16:33:28', '2016-12-30 16:33:28', '1', null);
INSERT INTO `exam_paper` VALUES ('10011', 'HTML5卷一', '1', '2016-12-30 17:08:00', '2016-12-30 17:08:00', '1', null);
INSERT INTO `exam_paper` VALUES ('10012', 'NodeJS卷一', '1', '2020-05-29 20:59:00', '2020-05-29 20:59:00', '1', null);
INSERT INTO `exam_paper` VALUES ('10013', '数据库卷一', '1', '2020-05-29 21:06:00', '2020-05-29 21:08:00', '1', null);
INSERT INTO `exam_paper` VALUES ('10014', 'Java测试试卷一', '0', '2020-05-30 13:10:00', '2020-05-30 13:30:00', '1', '2020-05-30 15:45:51');
INSERT INTO `exam_paper` VALUES ('10015', 'Java基础测试卷一', '0', '2020-06-02 09:00:00', '2020-06-02 10:00:00', '1', '2020-06-02 15:20:40');

-- ----------------------------
-- Table structure for `exam_paper_question`
-- ----------------------------
DROP TABLE IF EXISTS `exam_paper_question`;
CREATE TABLE `exam_paper_question` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `paperId` bigint(11) DEFAULT NULL,
  `questionId` bigint(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=288 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of exam_paper_question
-- ----------------------------
INSERT INTO `exam_paper_question` VALUES ('260', '10013', '167');
INSERT INTO `exam_paper_question` VALUES ('261', '10013', '166');
INSERT INTO `exam_paper_question` VALUES ('262', '10013', '165');
INSERT INTO `exam_paper_question` VALUES ('267', '10014', '167');
INSERT INTO `exam_paper_question` VALUES ('268', '10014', '166');
INSERT INTO `exam_paper_question` VALUES ('269', '10014', '165');
INSERT INTO `exam_paper_question` VALUES ('270', '10014', '164');
INSERT INTO `exam_paper_question` VALUES ('271', '10014', '162');
INSERT INTO `exam_paper_question` VALUES ('272', '10012', '167');
INSERT INTO `exam_paper_question` VALUES ('273', '10012', '166');
INSERT INTO `exam_paper_question` VALUES ('274', '10012', '165');
INSERT INTO `exam_paper_question` VALUES ('275', '10012', '164');
INSERT INTO `exam_paper_question` VALUES ('276', '10012', '163');
INSERT INTO `exam_paper_question` VALUES ('277', '10012', '162');
INSERT INTO `exam_paper_question` VALUES ('278', '10012', '161');
INSERT INTO `exam_paper_question` VALUES ('279', '10012', '160');
INSERT INTO `exam_paper_question` VALUES ('280', '10015', '171');
INSERT INTO `exam_paper_question` VALUES ('281', '10015', '170');
INSERT INTO `exam_paper_question` VALUES ('282', '10015', '169');
INSERT INTO `exam_paper_question` VALUES ('283', '10015', '168');
INSERT INTO `exam_paper_question` VALUES ('284', '10015', '167');
INSERT INTO `exam_paper_question` VALUES ('285', '10015', '166');
INSERT INTO `exam_paper_question` VALUES ('286', '10015', '165');
INSERT INTO `exam_paper_question` VALUES ('287', '10015', '164');

-- ----------------------------
-- Table structure for `exam_questionbank`
-- ----------------------------
DROP TABLE IF EXISTS `exam_questionbank`;
CREATE TABLE `exam_questionbank` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `questionTitle` text COMMENT '题目',
  `questionAnswer` varchar(255) DEFAULT NULL COMMENT '正确答案',
  `q_typeid` int(5) DEFAULT NULL COMMENT '题目类型（判断 0或者选择 1）',
  `status` int(5) DEFAULT NULL COMMENT '状态 0 删除 1有效',
  `createTime` datetime DEFAULT NULL,
  `grade` int(10) DEFAULT NULL,
  `creatorId` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=172 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of exam_questionbank
-- ----------------------------
INSERT INTO `exam_questionbank` VALUES ('158', '测试选择题1', 'B', '1', '1', '2020-05-30 16:24:40', '3', '1');
INSERT INTO `exam_questionbank` VALUES ('159', '测试选择题2', 'D', '1', '1', '2020-05-30 16:24:43', '3', '1');
INSERT INTO `exam_questionbank` VALUES ('160', '测试判断题1', '1', '3', '0', '2020-05-30 16:24:46', '3', '1');
INSERT INTO `exam_questionbank` VALUES ('161', '测试判断题2', '0', '3', '0', '2020-05-30 16:24:49', '3', '1');
INSERT INTO `exam_questionbank` VALUES ('162', '测试判断题3', '1', '3', '0', '2020-05-30 16:24:52', '3', '1');
INSERT INTO `exam_questionbank` VALUES ('163', '今年你多少岁?', 'A', '1', '0', '2020-05-30 20:59:50', '5', '1');
INSERT INTO `exam_questionbank` VALUES ('164', '您的女朋友是不是一个?', '1', '3', '0', '2020-05-30 21:03:08', '10', '1');
INSERT INTO `exam_questionbank` VALUES ('165', '您是不是什么时候进入公司的?', '2020年10月', '2', '0', '2020-05-30 21:04:32', '3', '1');
INSERT INTO `exam_questionbank` VALUES ('166', '请描述一下您每晚的感受?', null, '4', '0', '2020-05-30 21:05:19', '20', '1');
INSERT INTO `exam_questionbank` VALUES ('167', '您多少个女朋友?', 'D', '1', '0', '2020-05-30 21:13:29', '5', '1');
INSERT INTO `exam_questionbank` VALUES ('168', 'Java里面有几种基本类型?', 'C', '1', '0', '2020-06-02 15:17:16', '5', '18');
INSERT INTO `exam_questionbank` VALUES ('169', 'Java里面包装类型有多少个?', 'D', '1', '0', '2020-06-02 15:18:35', '5', '18');
INSERT INTO `exam_questionbank` VALUES ('170', '描述一下抽象类和接口的区别?', null, '4', '0', '2020-06-02 15:19:48', '10', '18');
INSERT INTO `exam_questionbank` VALUES ('171', 'try-catch是不是能够处理异常?', '1', '3', '0', '2020-06-02 15:22:12', '3', '18');

-- ----------------------------
-- Table structure for `exam_questiontype`
-- ----------------------------
DROP TABLE IF EXISTS `exam_questiontype`;
CREATE TABLE `exam_questiontype` (
  `id` bigint(2) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `desc` varchar(255) DEFAULT NULL,
  `typeNum` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of exam_questiontype
-- ----------------------------
INSERT INTO `exam_questiontype` VALUES ('1', '选择题', 'xzt', 'xzt');
INSERT INTO `exam_questiontype` VALUES ('2', '填空题', 'tkt', 'tkt');
INSERT INTO `exam_questiontype` VALUES ('3', '判断题', 'pdt', 'pdt');
INSERT INTO `exam_questiontype` VALUES ('4', '简答题', 'jdt', 'jdt');

-- ----------------------------
-- Table structure for `exam_score`
-- ----------------------------
DROP TABLE IF EXISTS `exam_score`;
CREATE TABLE `exam_score` (
  `id` bigint(2) NOT NULL AUTO_INCREMENT,
  `stuId` bigint(2) DEFAULT NULL,
  `paperId` bigint(2) DEFAULT NULL,
  `totalScore` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of exam_score
-- ----------------------------

-- ----------------------------
-- Table structure for `exam_scoredetail`
-- ----------------------------
DROP TABLE IF EXISTS `exam_scoredetail`;
CREATE TABLE `exam_scoredetail` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '分数ID',
  `stuId` bigint(30) DEFAULT NULL COMMENT '用户ID',
  `paperId` bigint(11) DEFAULT NULL,
  `questionId` bigint(255) DEFAULT NULL COMMENT '分数',
  `questionTitle` varchar(255) DEFAULT NULL,
  `q_typeid` bigint(2) DEFAULT NULL,
  `questionAnswer` varchar(2000) DEFAULT NULL,
  `questionScore` varchar(255) DEFAULT NULL,
  `correntAnswer` varchar(255) DEFAULT NULL,
  `correntScore` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of exam_scoredetail
-- ----------------------------
INSERT INTO `exam_scoredetail` VALUES ('92', '1', '10014', '167', '您多少个女朋友?', null, 'D', '5', 'D', '5');
INSERT INTO `exam_scoredetail` VALUES ('93', '1', '10014', '165', '您是不是什么时候进入公司的?', null, '2020年10月', '3', '2020年10月', '3');
INSERT INTO `exam_scoredetail` VALUES ('94', '1', '10014', '164', '您的女朋友是不是一个?', null, '1', '10', '1', '10');
INSERT INTO `exam_scoredetail` VALUES ('95', '1', '10014', '162', '测试判断题3', null, '1', '3', '1', '3');
INSERT INTO `exam_scoredetail` VALUES ('96', '1', '10014', '166', '请描述一下您每晚的感受?', null, '很精神呀', '20', '', '19');
INSERT INTO `exam_scoredetail` VALUES ('97', '2', '10014', '167', '您多少个女朋友?', '1', 'D', '5', 'D', '5');
INSERT INTO `exam_scoredetail` VALUES ('98', '2', '10014', '165', '您是不是什么时候进入公司的?', '2', '2020年10月', '3', '2020年10月', '3');
INSERT INTO `exam_scoredetail` VALUES ('99', '2', '10014', '164', '您的女朋友是不是一个?', '3', '1', '10', '1', '10');
INSERT INTO `exam_scoredetail` VALUES ('100', '2', '10014', '162', '测试判断题3', '3', '1', '3', '1', '3');
INSERT INTO `exam_scoredetail` VALUES ('101', '2', '10014', '166', '请描述一下您每晚的感受?', '4', '每天晚上都很精神', '20', '', '19');
INSERT INTO `exam_scoredetail` VALUES ('102', '3', '10014', '167', '您多少个女朋友?', '1', 'C', '5', 'D', '0');
INSERT INTO `exam_scoredetail` VALUES ('103', '3', '10014', '165', '您是不是什么时候进入公司的?', '2', '2020年10月', '3', '2020年10月', '3');
INSERT INTO `exam_scoredetail` VALUES ('104', '3', '10014', '164', '您的女朋友是不是一个?', '3', '1', '10', '1', '10');
INSERT INTO `exam_scoredetail` VALUES ('105', '3', '10014', '162', '测试判断题3', '3', '0', '3', '1', '0');
INSERT INTO `exam_scoredetail` VALUES ('106', '3', '10014', '166', '请描述一下您每晚的感受?', '4', '很好哟', '20', '', '16');
INSERT INTO `exam_scoredetail` VALUES ('107', '2', '10015', '167', '您多少个女朋友?', '1', 'C', '5', 'D', '0');
INSERT INTO `exam_scoredetail` VALUES ('108', '2', '10015', '168', 'Java里面有几种基本类型?', '1', 'C', '5', 'C', '5');
INSERT INTO `exam_scoredetail` VALUES ('109', '2', '10015', '169', 'Java里面包装类型有多少个?', '1', 'C', '5', 'D', '0');
INSERT INTO `exam_scoredetail` VALUES ('110', '2', '10015', '165', '您是不是什么时候进入公司的?', '2', '2020年10月', '3', '2020年10月', '3');
INSERT INTO `exam_scoredetail` VALUES ('111', '2', '10015', '171', 'try-catch是不是能够处理异常?', '3', '1', '3', '1', '3');
INSERT INTO `exam_scoredetail` VALUES ('112', '2', '10015', '164', '您的女朋友是不是一个?', '3', '1', '10', '1', '10');
INSERT INTO `exam_scoredetail` VALUES ('113', '2', '10015', '170', '描述一下抽象类和接口的区别?', '4', '就是这样呀', '10', '', '4');
INSERT INTO `exam_scoredetail` VALUES ('114', '2', '10015', '166', '请描述一下您每晚的感受?', '4', '很精神', '20', '', '19');
INSERT INTO `exam_scoredetail` VALUES ('115', '4', '10014', '167', '您多少个女朋友?', '1', 'A', '5', 'D', '0');
INSERT INTO `exam_scoredetail` VALUES ('116', '4', '10014', '165', '您是不是什么时候进入公司的?', '2', '2019年10月', '3', '2020年10月', '0');
INSERT INTO `exam_scoredetail` VALUES ('117', '4', '10014', '164', '您的女朋友是不是一个?', '3', '1', '10', '1', '10');
INSERT INTO `exam_scoredetail` VALUES ('118', '4', '10014', '162', '测试判断题3', '3', '0', '3', '1', '0');
INSERT INTO `exam_scoredetail` VALUES ('119', '4', '10014', '166', '请描述一下您每晚的感受?', '4', '每天晚上都很精神', '20', '', '18');

-- ----------------------------
-- Table structure for `exam_times`
-- ----------------------------
DROP TABLE IF EXISTS `exam_times`;
CREATE TABLE `exam_times` (
  `times_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
  `testpaper_id` int(11) NOT NULL COMMENT '试卷_id',
  `user_id` varchar(30) NOT NULL COMMENT '用户ID',
  `data_min` double DEFAULT NULL,
  `times_state` int(5) DEFAULT NULL COMMENT '数据状态',
  PRIMARY KEY (`times_id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of exam_times
-- ----------------------------
INSERT INTO `exam_times` VALUES ('39', '10002', '149000307', '-1', '0');
INSERT INTO `exam_times` VALUES ('40', '10001', '149000307', '-1', '0');
INSERT INTO `exam_times` VALUES ('41', '10012', '149000307', '-1', '0');
INSERT INTO `exam_times` VALUES ('42', '10012', '10000', '-1', '0');
INSERT INTO `exam_times` VALUES ('43', '10001', '10000', '-1', '0');
INSERT INTO `exam_times` VALUES ('44', '10002', '10000', '-1', '0');
INSERT INTO `exam_times` VALUES ('45', '10003', '10000', '-1', '0');
INSERT INTO `exam_times` VALUES ('46', '10011', '149000307', '-1', '0');
INSERT INTO `exam_times` VALUES ('47', '10008', '149000307', '-1', '0');
INSERT INTO `exam_times` VALUES ('48', '10013', '10000', '-1', '0');

-- ----------------------------
-- Table structure for `exam_xzt_options`
-- ----------------------------
DROP TABLE IF EXISTS `exam_xzt_options`;
CREATE TABLE `exam_xzt_options` (
  `id` bigint(2) NOT NULL AUTO_INCREMENT,
  `optionA` varchar(255) DEFAULT NULL,
  `optionB` varchar(255) DEFAULT NULL,
  `optionC` varchar(255) DEFAULT NULL,
  `optionD` varchar(255) DEFAULT NULL,
  `questionId` bigint(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of exam_xzt_options
-- ----------------------------
INSERT INTO `exam_xzt_options` VALUES ('1', '18-28', '28-38', '38-48', '48岁以上', '163');
INSERT INTO `exam_xzt_options` VALUES ('2', '1个', '2个', '3个', '4个', '167');
INSERT INTO `exam_xzt_options` VALUES ('3', '6个', '4个', '8个', '10个', '168');
INSERT INTO `exam_xzt_options` VALUES ('4', '2个', '4个', '6个', '8个', '169');

-- ----------------------------
-- Table structure for `t_menu`
-- ----------------------------
DROP TABLE IF EXISTS `t_menu`;
CREATE TABLE `t_menu` (
  `id` bigint(2) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `pid` bigint(2) DEFAULT NULL,
  `icon` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_menu
-- ----------------------------
INSERT INTO `t_menu` VALUES ('1', '系统管理', null, null, 'mdi mdi-file-outline');
INSERT INTO `t_menu` VALUES ('2', '用户维护', '/user/index', '1', null);
INSERT INTO `t_menu` VALUES ('3', '角色维护', '/role/index', '1', null);
INSERT INTO `t_menu` VALUES ('4', '权限维护', '/permission/index', '1', null);
INSERT INTO `t_menu` VALUES ('5', '菜单维护', '/menu/index', '1', null);
INSERT INTO `t_menu` VALUES ('6', '数据字典', null, null, 'mdi mdi-palette');
INSERT INTO `t_menu` VALUES ('7', '信息维护', '/dic/index', '6', null);
INSERT INTO `t_menu` VALUES ('10', '学生管理', null, null, 'mdi mdi-account-multiple');
INSERT INTO `t_menu` VALUES ('11', '学生列表', '/student/index', '10', '');
INSERT INTO `t_menu` VALUES ('12', '老师管理', null, null, 'mdi mdi-account-settings-variant');
INSERT INTO `t_menu` VALUES ('13', '老师列表', '/teacher/index', '12', '');
INSERT INTO `t_menu` VALUES ('14', '题库管理', null, null, 'mdi mdi-file');
INSERT INTO `t_menu` VALUES ('15', '题库列表', '/question/index', '14', '');
INSERT INTO `t_menu` VALUES ('16', '试卷管理', null, null, 'mdi mdi-file-document');
INSERT INTO `t_menu` VALUES ('17', '试卷列表', '/paper/index', '16', '');
INSERT INTO `t_menu` VALUES ('18', '成绩管理', null, null, 'mdi mdi-file-check');
INSERT INTO `t_menu` VALUES ('19', '成绩列表', '/score/index', '18', '');
INSERT INTO `t_menu` VALUES ('20', '报表管理', null, null, 'mdi mdi-file-chart');
INSERT INTO `t_menu` VALUES ('21', '报表列表', '/report/index', '20', '');
INSERT INTO `t_menu` VALUES ('22', '日志管理', null, null, 'mdi mdi-equal-box ');
INSERT INTO `t_menu` VALUES ('23', '日志列表', '/log/index', '22', '');
INSERT INTO `t_menu` VALUES ('25', '试卷组题', '/paper/appendQuestion', '16', null);
INSERT INTO `t_menu` VALUES ('26', '老师阅卷', '/teacher/paperExamRecord', '12', null);
INSERT INTO `t_menu` VALUES ('27', 'test父级', null, null, 'mdi mdi-palette');
INSERT INTO `t_menu` VALUES ('28', 'test子菜单1', '/test/index', '27', '');
INSERT INTO `t_menu` VALUES ('29', 'test子菜单2', '/test/index2', '27', '');
INSERT INTO `t_menu` VALUES ('30', 'test子菜单3', '/test/index3', '27', '');

-- ----------------------------
-- Table structure for `t_permission`
-- ----------------------------
DROP TABLE IF EXISTS `t_permission`;
CREATE TABLE `t_permission` (
  `id` bigint(2) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `pid` bigint(2) DEFAULT NULL,
  `menuid` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_permission
-- ----------------------------
INSERT INTO `t_permission` VALUES ('1', 'user', '用户模块', '0', '2');
INSERT INTO `t_permission` VALUES ('7', 'role', '角色模块', '0', '3');
INSERT INTO `t_permission` VALUES ('8', 'role:add', '新增角色', '7', null);
INSERT INTO `t_permission` VALUES ('9', 'role:delete', '删除角色', '7', null);
INSERT INTO `t_permission` VALUES ('10', 'role:get', '查询角色', '7', null);
INSERT INTO `t_permission` VALUES ('11', 'role:update', '修改角色', '7', null);
INSERT INTO `t_permission` VALUES ('13', 'menu', '菜单管理', '0', '5');
INSERT INTO `t_permission` VALUES ('14', 'menu:add', '新增菜单', '13', null);
INSERT INTO `t_permission` VALUES ('15', 'user:add', '用户新增', '1', null);
INSERT INTO `t_permission` VALUES ('16', 'user:delete', '用户删除', '1', null);
INSERT INTO `t_permission` VALUES ('17', 'user:get', '用户查询', '1', null);
INSERT INTO `t_permission` VALUES ('18', 'user:update', '用户更新', '1', null);
INSERT INTO `t_permission` VALUES ('19', 'menu:delete', '菜单删除', '13', null);
INSERT INTO `t_permission` VALUES ('20', 'menu:query', '菜单查询', '13', null);
INSERT INTO `t_permission` VALUES ('21', 'menu:get', '菜单获取', '13', null);
INSERT INTO `t_permission` VALUES ('22', 'permission', '权限列表', '0', '4');
INSERT INTO `t_permission` VALUES ('23', 'dic', '数据字典信息', '0', '7');
INSERT INTO `t_permission` VALUES ('24', 'student', '学生列表', '0', '11');
INSERT INTO `t_permission` VALUES ('25', 'teacher', '老师列表', '0', '13');
INSERT INTO `t_permission` VALUES ('26', 'tk', '题库列表', '0', '15');
INSERT INTO `t_permission` VALUES ('27', 'paper', '试卷列表', '0', '17');
INSERT INTO `t_permission` VALUES ('28', 'score', '成绩列表', '0', '19');
INSERT INTO `t_permission` VALUES ('29', 'report', '报表列表', '0', '21');
INSERT INTO `t_permission` VALUES ('30', 'log', '日志列表', '0', '23');
INSERT INTO `t_permission` VALUES ('31', 'zt', '试卷组题', '0', '25');
INSERT INTO `t_permission` VALUES ('32', 'checked', '老师阅卷', '0', '26');
INSERT INTO `t_permission` VALUES ('33', 'test', 'test子菜单1', '0', '28');
INSERT INTO `t_permission` VALUES ('34', 'test2', 'test子菜单2', '0', '29');
INSERT INTO `t_permission` VALUES ('35', 'test:add', '测试新增', '33', null);
INSERT INTO `t_permission` VALUES ('36', 'test3', 'test子菜单3', '0', '30');
INSERT INTO `t_permission` VALUES ('37', 'checked:add', '新增阅卷', '32', null);

-- ----------------------------
-- Table structure for `t_role`
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
  `id` bigint(2) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `sn` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_role
-- ----------------------------
INSERT INTO `t_role` VALUES ('1', '管理员', null);
INSERT INTO `t_role` VALUES ('2', '老师权限', null);

-- ----------------------------
-- Table structure for `t_role_permission`
-- ----------------------------
DROP TABLE IF EXISTS `t_role_permission`;
CREATE TABLE `t_role_permission` (
  `id` bigint(2) NOT NULL AUTO_INCREMENT,
  `roleid` bigint(2) DEFAULT NULL,
  `permissionid` bigint(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_role_permission
-- ----------------------------
INSERT INTO `t_role_permission` VALUES ('65', '2', '23');
INSERT INTO `t_role_permission` VALUES ('66', '2', '24');
INSERT INTO `t_role_permission` VALUES ('67', '2', '25');
INSERT INTO `t_role_permission` VALUES ('68', '2', '26');
INSERT INTO `t_role_permission` VALUES ('69', '2', '27');
INSERT INTO `t_role_permission` VALUES ('70', '2', '28');
INSERT INTO `t_role_permission` VALUES ('71', '2', '29');
INSERT INTO `t_role_permission` VALUES ('72', '2', '30');
INSERT INTO `t_role_permission` VALUES ('73', '2', '31');
INSERT INTO `t_role_permission` VALUES ('74', '2', '32');
INSERT INTO `t_role_permission` VALUES ('103', '1', '1');
INSERT INTO `t_role_permission` VALUES ('104', '1', '7');
INSERT INTO `t_role_permission` VALUES ('105', '1', '8');
INSERT INTO `t_role_permission` VALUES ('106', '1', '9');
INSERT INTO `t_role_permission` VALUES ('107', '1', '10');
INSERT INTO `t_role_permission` VALUES ('108', '1', '11');
INSERT INTO `t_role_permission` VALUES ('109', '1', '13');
INSERT INTO `t_role_permission` VALUES ('110', '1', '14');
INSERT INTO `t_role_permission` VALUES ('111', '1', '15');
INSERT INTO `t_role_permission` VALUES ('112', '1', '16');
INSERT INTO `t_role_permission` VALUES ('113', '1', '17');
INSERT INTO `t_role_permission` VALUES ('114', '1', '18');
INSERT INTO `t_role_permission` VALUES ('115', '1', '19');
INSERT INTO `t_role_permission` VALUES ('116', '1', '20');
INSERT INTO `t_role_permission` VALUES ('117', '1', '21');
INSERT INTO `t_role_permission` VALUES ('118', '1', '22');
INSERT INTO `t_role_permission` VALUES ('119', '1', '23');
INSERT INTO `t_role_permission` VALUES ('120', '1', '24');
INSERT INTO `t_role_permission` VALUES ('121', '1', '25');
INSERT INTO `t_role_permission` VALUES ('122', '1', '26');
INSERT INTO `t_role_permission` VALUES ('123', '1', '27');
INSERT INTO `t_role_permission` VALUES ('124', '1', '28');
INSERT INTO `t_role_permission` VALUES ('125', '1', '29');
INSERT INTO `t_role_permission` VALUES ('126', '1', '30');
INSERT INTO `t_role_permission` VALUES ('127', '1', '31');
INSERT INTO `t_role_permission` VALUES ('128', '1', '32');
INSERT INTO `t_role_permission` VALUES ('129', '1', '33');
INSERT INTO `t_role_permission` VALUES ('130', '1', '34');
INSERT INTO `t_role_permission` VALUES ('131', '1', '37');

-- ----------------------------
-- Table structure for `t_student`
-- ----------------------------
DROP TABLE IF EXISTS `t_student`;
CREATE TABLE `t_student` (
  `id` bigint(2) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `tel` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `stuNum` varchar(255) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  `nickName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_student
-- ----------------------------
INSERT INTO `t_student` VALUES ('1', 'stu1', '123', '18800010002', 'stu1@qq.com', '10120130', null, '张三');
INSERT INTO `t_student` VALUES ('2', 'stu2', '123', '18900100201', 'stu2@qq.com', '101202303', null, '李四');
INSERT INTO `t_student` VALUES ('3', 'stu3', '123', '18088819992', 'stu3@qq.com', '101001002', null, '王五');
INSERT INTO `t_student` VALUES ('4', 'stu4', '123', '18000010002', 'stu2@qq.com', '10020030', null, '貂蝉');

-- ----------------------------
-- Table structure for `t_test`
-- ----------------------------
DROP TABLE IF EXISTS `t_test`;
CREATE TABLE `t_test` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of t_test
-- ----------------------------
INSERT INTO `t_test` VALUES ('1', '张三');
INSERT INTO `t_test` VALUES ('2', '李四');

-- ----------------------------
-- Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` bigint(2) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `tel` varchar(11) DEFAULT NULL,
  `sex` bit(1) DEFAULT NULL,
  `headImg` varchar(255) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  `type` bigint(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES ('1', 'admin', '$2a$10$YITYi7HjqT2gh8jEF6eyquR/Og0qmYBNT8cQLaEjjS92jcZHwsI9G', 'admin@qq.com', '18000010002', '', '/upload/229caa82-17c6-4515-9bd6-edbf10212099.png', '2020-05-15 13:49:07', '1');
INSERT INTO `t_user` VALUES ('2', 'admin2', '$2a$10$YITYi7HjqT2gh8jEF6eyquR/Og0qmYBNT8cQLaEjjS92jcZHwsI9G', 'test112244@qq.com', '18000020003', '', '/upload/f879da1c-b376-40a2-a5a0-68b656fad44a.jpg', '2020-05-13 13:49:11', '1');
INSERT INTO `t_user` VALUES ('17', 't1', '$2a$10$t7K//qDwIbaPGt6fiRVL.eXeFHBHtF4aON2VGwd3u.pOwvH8AzTBe', 't1@qq.com', '18800030005', '', '/upload/229caa82-17c6-4515-9bd6-edbf10212099.png', '2020-06-02 15:04:05', '2');
INSERT INTO `t_user` VALUES ('18', 't2', '$2a$10$yPSGzDtZevO/O9LwJVFteOJJywpJXIMW2FZJdMHAQukTxul3WCVWG', 't2@qq.com', '18800040006', '', '/upload/229caa82-17c6-4515-9bd6-edbf10212099.png', '2020-06-02 15:06:08', '2');

-- ----------------------------
-- Table structure for `t_user_role`
-- ----------------------------
DROP TABLE IF EXISTS `t_user_role`;
CREATE TABLE `t_user_role` (
  `id` bigint(2) NOT NULL AUTO_INCREMENT,
  `userid` bigint(2) DEFAULT NULL,
  `roleid` bigint(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_user_role
-- ----------------------------
INSERT INTO `t_user_role` VALUES ('1', '1', '1');
INSERT INTO `t_user_role` VALUES ('2', '1', '2');
INSERT INTO `t_user_role` VALUES ('3', '17', '2');
INSERT INTO `t_user_role` VALUES ('14', '18', '2');

-- ----------------------------
-- View structure for `v_stuscore`
-- ----------------------------
DROP VIEW IF EXISTS `v_stuscore`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_stuscore` AS select `s`.`id` AS `stuId`,`ep`.`id` AS `paperId`,`s`.`nickName` AS `nickName`,`ep`.`name` AS `name`,sum(`sd`.`correntScore`) AS `totalScore` from ((`exam_scoredetail` `sd` join `exam_paper` `ep` on((`sd`.`paperId` = `ep`.`id`))) join `t_student` `s` on((`s`.`id` = `sd`.`stuId`))) group by `sd`.`paperId`,`sd`.`stuId` ;

t_dictype.sql

/*
Navicat MySQL Data Transfer

Source Server         : 62.234.78.94_3306
Source Server Version : 50731
Source Host           : 62.234.78.94:3306
Source Database       : mz_exam

Target Server Type    : MYSQL
Target Server Version : 50731
File Encoding         : 65001

Date: 2020-08-29 07:55:17
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `t_dictype`
-- ----------------------------
DROP TABLE IF EXISTS `t_dictype`;
CREATE TABLE `t_dictype` (
  `id` bigint(2) NOT NULL AUTO_INCREMENT,
  `sn` varchar(255) DEFAULT NULL,
  `info` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_dictype
-- ----------------------------
INSERT INTO `t_dictype` VALUES ('1', 'level', '试卷等级');
INSERT INTO `t_dictype` VALUES ('2', 'category', '试卷科目分类');

t_dictype_data.sql

/*
Navicat MySQL Data Transfer

Source Server         : 62.234.78.94_3306
Source Server Version : 50731
Source Host           : 62.234.78.94:3306
Source Database       : mz_exam

Target Server Type    : MYSQL
Target Server Version : 50731
File Encoding         : 65001

Date: 2020-08-29 07:55:52
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `t_dictype_data`
-- ----------------------------
DROP TABLE IF EXISTS `t_dictype_data`;
CREATE TABLE `t_dictype_data` (
  `id` bigint(2) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `typeid` bigint(2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_dictype_data
-- ----------------------------
INSERT INTO `t_dictype_data` VALUES ('1', '困难', '1');
INSERT INTO `t_dictype_data` VALUES ('2', '容易', '1');
INSERT INTO `t_dictype_data` VALUES ('3', '简单', '1');
INSERT INTO `t_dictype_data` VALUES ('4', '文科', '2');
INSERT INTO `t_dictype_data` VALUES ('5', '理科', '2');
段子子
关注
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值