代码拉取完成，页面将自动刷新
-- DROP DATABASE IF EXISTS tsscp;
CREATE DATABASE tsscp;
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '角色编号',
`job` varchar(50) NOT NULL COMMENT '角色职位',
`name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名称',
`username` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
`password` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
`school` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '学校',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;
INSERT INTO `user` VALUES ('1','系统管理员','窦图图','admin','123456','三峡大学');
INSERT INTO `user` VALUES ('2','评委','李华','lihua','123456','三峡大学');
INSERT INTO `user` VALUES ('3','评委','张三风','zhangsanfeng','123456','清华大学');
INSERT INTO `user` VALUES ('4','老师','王五','wangwu','123456','武汉大学');
INSERT INTO `user` VALUES ('5','老师','牛爷爷','niuyeye','123456','北京大学');
INSERT INTO `user` VALUES ('6','老师','王爷爷','wangyeye','123456','北京大学')
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '角色编号',
`role_code` varchar(50) NOT NULL COMMENT '角色编码',
`role_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名称',
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;
INSERT INTO `role` VALUES ('1','administrator','管理员','拥有系统所有的权限');
INSERT INTO `role` VALUES ('2','judges','评委','拥有对作品的查看和评分权限');
INSERT INTO `role` VALUES ('3','teacher','老师','拥有对作品的提交和修改权限');
INSERT INTO `role` VALUES ('4','EBAadmin','教育局管理员','拥有对作品的查看和评价查看和导出数据权限');
DROP TABLE IF EXISTS `role_permission`;
CREATE TABLE `role_permission` (
`role_Id` bigint NOT NULL COMMENT '角色ID',
`permission_Id` bigint NOT NULL COMMENT '权限ID'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
-- 添加权限
INSERT INTO `role_permission` VALUES ('1','1');
INSERT INTO `role_permission` VALUES ('1','2');
INSERT INTO `role_permission` VALUES ('1','3');
INSERT INTO `role_permission` VALUES ('1','4');
INSERT INTO `role_permission` VALUES ('1','5');
INSERT INTO `role_permission` VALUES ('1','6');
INSERT INTO `role_permission` VALUES ('1','7');
INSERT INTO `role_permission` VALUES ('1','8');
INSERT INTO `role_permission` VALUES ('1','9');
INSERT INTO `role_permission` VALUES ('1','10');
INSERT INTO `role_permission` VALUES ('1','11');
INSERT INTO `role_permission` VALUES ('1','12');
INSERT INTO `role_permission` VALUES ('1','13');
INSERT INTO `role_permission` VALUES ('1','14');
INSERT INTO `role_permission` VALUES ('1','15');
INSERT INTO `role_permission` VALUES ('1','16');
INSERT INTO `role_permission` VALUES ('2','10');
INSERT INTO `role_permission` VALUES ('2','12');
INSERT INTO `role_permission` VALUES ('2','13');
INSERT INTO `role_permission` VALUES ('2','14');
INSERT INTO `role_permission` VALUES ('2','15');
INSERT INTO `role_permission` VALUES ('3','7');
INSERT INTO `role_permission` VALUES ('3','8');
INSERT INTO `role_permission` VALUES ('3','10');
INSERT INTO `role_permission` VALUES ('3','12');
INSERT INTO `role_permission` VALUES ('4','10');
INSERT INTO `role_permission` VALUES ('4','12');
INSERT INTO `role_permission` VALUES ('4','16');
DROP TABLE IF EXISTS `permission`;
CREATE TABLE `permission` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '权限编号',
`label` varchar(50) DEFAULT NULL COMMENT '权限名称',
`parent_id` bigint DEFAULT NULL COMMENT '父权限ID',
`parent_name` varchar(50) DEFAULT NULL COMMENT '父权限名称',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb3;
INSERT INTO `permission` VALUES ('1','系统管理','0','顶级菜单');
INSERT INTO `permission` VALUES ('2','用户管理','1','系统管理');
INSERT INTO `permission` VALUES ('3','新增','2','用户管理');
INSERT INTO `permission` VALUES ('4','修改','2','用户管理');
INSERT INTO `permission` VALUES ('5','删除','2','用户管理');
INSERT INTO `permission` VALUES ('6','作品管理','1','系统管理');
INSERT INTO `permission` VALUES ('7','新增','6','作品管理');
INSERT INTO `permission` VALUES ('8','修改','6','作品管理');
INSERT INTO `permission` VALUES ('9','删除','6','作品管理');
INSERT INTO `permission` VALUES ('10','查看','6','作品管理');
INSERT INTO `permission` VALUES ('11','评价管理','1','系统管理');
INSERT INTO `permission` VALUES ('12','查看','11','评价管理');
INSERT INTO `permission` VALUES ('13','新增','11','评价管理');
INSERT INTO `permission` VALUES ('14','删除','11','评价管理');
INSERT INTO `permission` VALUES ('15','修改','11','评价管理');
INSERT INTO `permission` VALUES ('16','导出评分','11','评价管理');
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
`user_id` bigint NOT NULL COMMENT '用户编号',
`role_id` bigint NOT NULL COMMENT '角色编号'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
INSERT INTO `user_role` VALUES ('1','1');
INSERT INTO `user_role` VALUES ('2','2');
INSERT INTO `user_role` VALUES ('3','2');
INSERT INTO `user_role` VALUES ('4','3');
INSERT INTO `user_role` VALUES ('5','3');
DROP TABLE IF EXISTS `works`;
CREATE TABLE `works`(
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '作品编号',
`school` varchar(50) DEFAULT NULL COMMENT '学校名称',
`group` varchar(50) DEFAULT NULL COMMENT '报名组别',
`name` varchar(50) DEFAULT NULL COMMENT '作品名称',
`username` varchar(50) DEFAULT NULL COMMENT '参赛人姓名',
`tel` varchar(11) DEFAULT NULL COMMENT '联系方式',
`avg` varchar(50) DEFAULT NULL COMMENT '实时平均分',
`now_time` varchar(50) DEFAULT NULL COMMENT '提交时间',
`video` varchar(300) comment '视频',
`plan` varchar(300) comment '教案',
`report` varchar(300) comment '教学实施报告',
`programme` varchar(300) comment '课堂方案',
`standard` varchar(300) comment '课堂标准',
`other` varchar(300) comment '其他',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb3;
INSERT INTO `works` VALUES ('1','三峡大学','科技类','创新世界','何大涌','16512314456','50','2023-10-5','','','','','','');
INSERT INTO `works` VALUES ('2','三峡科技大学','文学类','新天机','赵子龙','11223344556','40','2023-11-5','','','','','','');
INSERT INTO `works` VALUES ('3','武汉大学','科技类','百变世纪','王长江','15517901566','60','2023-11-8','','','','','','');
INSERT INTO `works` VALUES ('4','北京大学','科技类','探索宇宙','黑旋风','18819701566','45','2023-11-10','','','','','','');
INSERT INTO `works` VALUES ('5','湖北工业大学','文学类','世界大变','百草零','18815471752','30','2023-10-9','','','','','','');
INSERT INTO `works` VALUES ('6','华中科技大学','科技类','地形探索','王惠','15201235241','55','2023-10-8','','','','','','');
INSERT INTO `works` VALUES ('7','清华大学','科技类','工业的创新','何晓东','15845621798','55','2023-11-15','','','','','','');
INSERT INTO `works` VALUES ('8','三峡大学','文学类','童话故事','爱心零','15615484652','50','2023-10-5','','','','','','');
INSERT INTO `works` VALUES ('9','三峡科技大学','科技类','机械升级','文慧非','15741236548','40','2023-11-5','','','','','','');
INSERT INTO `works` VALUES ('10','武汉大学','科技类','宇宙探测器','王集合','15518651245','60','2023-11-8','','','','','','');
INSERT INTO `works` VALUES ('11','北京大学','科技类','火星探测','白虹何','12345345555','45','2023-11-10','','','','','','');
INSERT INTO `works` VALUES ('12','湖北工业大学','文学类','世界大变','百草零','18815471752','30','2023-10-9','','','','','','');
INSERT INTO `works` VALUES ('13','华中科技大学','科技类','地形探索','王惠','15201235241','55','2023-10-8','','','','','','');
INSERT INTO `works` VALUES ('14','清华大学','科技类','工业的创新','何晓东','15845621798','55','2023-11-15','','','','','','');
INSERT INTO `works` VALUES ('15','清华大学','科技类','工业的创新','何晓东','15845621798','55','2023-11-15','','','','','','');
INSERT INTO `works` VALUES ('16','三峡大学','文学类','童话故事','爱心零','15615484652','50','2023-10-5','','','','','','');
INSERT INTO `works` VALUES ('17','三峡科技大学','科技类','机械升级','文慧非','15741236548','40','2023-11-5','','','','','','');
INSERT INTO `works` VALUES ('18','武汉大学','科技类','宇宙探测器','王集合','15518651245','60','2023-11-8','','','','','','');
INSERT INTO `works` VALUES ('19','北京大学','科技类','火星探测','白虹何','12345345555','45','2023-11-10','','','','','','');
INSERT INTO `works` VALUES ('20','湖北工业大学','文学类','世界大变','百草零','18815471752','30','2023-10-9','','','','','','');
INSERT INTO `works` VALUES ('21','华中科技大学','科技类','地形探索','王惠','15201235241','55','2023-10-8','','','','','','');
INSERT INTO `works` VALUES ('22','清华大学','科技类','工业的创新','何晓东','15845621798','55','2023-11-15','','','','','','');
-- 删除表（如果存在）
DROP TABLE IF EXISTS `score`;
-- 创建表
CREATE TABLE `score`(
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '评分编号',
`school` varchar(50) DEFAULT NULL COMMENT '学校名称',
`name` varchar(50) DEFAULT NULL COMMENT '作品名称',
`jname` varchar(50) DEFAULT NULL COMMENT '评委名称',
`video` INT COMMENT '视频评分',
`plan` INT COMMENT '教案评分',
`report` INT COMMENT '教学实施报告评分',
`programme` INT COMMENT '课堂方案评分',
`standard` INT COMMENT '课堂标准评分',
`tutorial` INT COMMENT '教材评分',
`sum` INT COMMENT '总分',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb3;
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手