|
|
/*
|
|
|
Navicat MySQL Data Transfer
|
|
|
|
|
|
Source Server : local-php
|
|
|
Source Server Version : 50553
|
|
|
Source Host : localhost:3306
|
|
|
Source Database : tsgzw
|
|
|
|
|
|
Target Server Type : MYSQL
|
|
|
Target Server Version : 50553
|
|
|
File Encoding : 65001
|
|
|
|
|
|
Date: 2023-03-19 23:43:45
|
|
|
*/
|
|
|
|
|
|
SET FOREIGN_KEY_CHECKS=0;
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Table structure for news
|
|
|
-- ----------------------------
|
|
|
DROP TABLE IF EXISTS `news`;
|
|
|
CREATE TABLE `news` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
|
`title` varchar(255) DEFAULT NULL COMMENT '新闻标题',
|
|
|
`gmtTime` datetime DEFAULT NULL COMMENT '发布时间',
|
|
|
`content` varchar(2000) DEFAULT NULL COMMENT '内容',
|
|
|
PRIMARY KEY (`id`)
|
|
|
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='通知公告';
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Records of news
|
|
|
-- ----------------------------
|
|
|
INSERT INTO `news` VALUES ('1', '的萨达撒', '2023-03-19 23:02:07', '21321');
|
|
|
INSERT INTO `news` VALUES ('2', '关于图书馆最近座位不够的通知', '2023-03-19 23:39:03', '关于图书馆最近座位不够的通知\n关于图书馆最近座位不够的通知\n关于图书馆最近座位不够的通知\n关于图书馆最近座位不够的通知\n关于图书馆最近座位不够的通知\n关于图书馆最近座位不够的通知\n关于图书馆最近座位不够的通知\n关于图书馆最近座位不够的通知\n关于图书馆最近座位不够的通知关于图书馆最近座位不够的通知');
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Table structure for record
|
|
|
-- ----------------------------
|
|
|
DROP TABLE IF EXISTS `record`;
|
|
|
CREATE TABLE `record` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
|
`seat` bigint(20) DEFAULT NULL COMMENT '座位号',
|
|
|
`user` bigint(20) DEFAULT NULL COMMENT '预约人',
|
|
|
`gmtTime` varchar(255) DEFAULT NULL COMMENT '预约时间',
|
|
|
`state` varchar(255) DEFAULT NULL COMMENT '审批状态',
|
|
|
PRIMARY KEY (`id`)
|
|
|
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COMMENT='座位预约';
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Records of record
|
|
|
-- ----------------------------
|
|
|
INSERT INTO `record` VALUES ('9', '4', '9', '2023-03-19 23:41:57', '未通过');
|
|
|
INSERT INTO `record` VALUES ('8', '5', '9', '2023-03-19 23:40:54', '已通过');
|
|
|
INSERT INTO `record` VALUES ('7', '2', '1', '2023-03-19 23:36:17', '已通过');
|
|
|
INSERT INTO `record` VALUES ('6', '2', '1', '2023-03-19 23:21:25', '未通过');
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Table structure for seat
|
|
|
-- ----------------------------
|
|
|
DROP TABLE IF EXISTS `seat`;
|
|
|
CREATE TABLE `seat` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
|
`no` varchar(255) DEFAULT NULL COMMENT '座位号',
|
|
|
`floor` varchar(255) DEFAULT NULL COMMENT '楼层',
|
|
|
`state` varchar(255) DEFAULT NULL COMMENT '预约状态',
|
|
|
`user` bigint(20) DEFAULT NULL COMMENT '预约人',
|
|
|
`ytime` datetime DEFAULT NULL COMMENT '预约时间',
|
|
|
PRIMARY KEY (`id`)
|
|
|
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COMMENT='座位信息';
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Records of seat
|
|
|
-- ----------------------------
|
|
|
INSERT INTO `seat` VALUES ('3', '123', '1', '空闲', null, null);
|
|
|
INSERT INTO `seat` VALUES ('2', '888', '1', '已预定', '1', '2023-03-19 23:36:17');
|
|
|
INSERT INTO `seat` VALUES ('4', '2', '1', '空闲', null, null);
|
|
|
INSERT INTO `seat` VALUES ('5', '3', '1', '已预定', '9', '2023-03-19 23:40:54');
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Table structure for sys_config
|
|
|
-- ----------------------------
|
|
|
DROP TABLE IF EXISTS `sys_config`;
|
|
|
CREATE TABLE `sys_config` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
|
`key` varchar(50) DEFAULT NULL COMMENT 'key',
|
|
|
`value` varchar(2000) DEFAULT NULL COMMENT 'value',
|
|
|
`status` tinyint(4) DEFAULT '1' COMMENT '状态 0：隐藏 1：显示',
|
|
|
`remark` varchar(500) DEFAULT NULL COMMENT '备注',
|
|
|
PRIMARY KEY (`id`),
|
|
|
UNIQUE KEY `key` (`key`)
|
|
|
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='系统配置信息表';
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Records of sys_config
|
|
|
-- ----------------------------
|
|
|
INSERT INTO `sys_config` VALUES ('1', 'CLOUD_STORAGE_CONFIG_KEY', '{\"aliyunAccessKeyId\":\"\",\"aliyunAccessKeySecret\":\"\",\"aliyunBucketName\":\"\",\"aliyunDomain\":\"\",\"aliyunEndPoint\":\"\",\"aliyunPrefix\":\"\",\"qcloudBucketName\":\"\",\"qcloudDomain\":\"\",\"qcloudPrefix\":\"\",\"qcloudSecretId\":\"\",\"qcloudSecretKey\":\"\",\"qiniuAccessKey\":\"NrgMfABZxWLo5B-YYSjoE8-AZ1EISdi1Z3ubLOeZ\",\"qiniuBucketName\":\"ios-app\",\"qiniuDomain\":\"http://7xqbwh.dl1.z0.glb.clouddn.com\",\"qiniuPrefix\":\"upload\",\"qiniuSecretKey\":\"uIwJHevMRWU0VLxFvgy0tAcOdGqasdtVlJkdy6vV\",\"type\":1}', '0', '云存储配置信息');
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Table structure for sys_log
|
|
|
-- ----------------------------
|
|
|
DROP TABLE IF EXISTS `sys_log`;
|
|
|
CREATE TABLE `sys_log` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
|
`username` varchar(50) DEFAULT NULL COMMENT '用户名',
|
|
|
`operation` varchar(50) DEFAULT NULL COMMENT '用户操作',
|
|
|
`method` varchar(200) DEFAULT NULL COMMENT '请求方法',
|
|
|
`params` varchar(5000) DEFAULT NULL COMMENT '请求参数',
|
|
|
`ip` varchar(64) DEFAULT NULL COMMENT 'IP地址',
|
|
|
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
|
|
|
PRIMARY KEY (`id`)
|
|
|
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8 COMMENT='系统日志';
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Records of sys_log
|
|
|
-- ----------------------------
|
|
|
INSERT INTO `sys_log` VALUES ('1', 'admin', '修改密码', 'com.learn.controller.SysUserController.password()', '\"admin\"', '0:0:0:0:0:0:0:1', '2023-04-17 10:10:34');
|
|
|
INSERT INTO `sys_log` VALUES ('2', 'admin', '修改菜单', 'com.learn.controller.SysMenuController.update()', '{\"icon\":\"fa fa-comment-o\",\"menuId\":31,\"name\":\"通知公告\",\"orderNum\":6,\"parentId\":0,\"parentName\":\"一级菜单\",\"type\":1,\"url\":\"generator/notice.html\"}', '0:0:0:0:0:0:0:1', '2023-04-17 10:12:20');
|
|
|
INSERT INTO `sys_log` VALUES ('3', 'admin', '删除用户', 'com.learn.controller.SysUserController.delete()', '[1]', '0:0:0:0:0:0:0:1', '2023-04-17 10:18:09');
|
|
|
INSERT INTO `sys_log` VALUES ('4', 'admin', '删除用户', 'com.learn.controller.SysUserController.delete()', '[1]', '0:0:0:0:0:0:0:1', '2023-04-17 10:18:55');
|
|
|
INSERT INTO `sys_log` VALUES ('5', 'admin', '保存角色', 'com.learn.controller.SysRoleController.save()', '{\"menuIdList\":[31,32],\"roleName\":\"学生\"}', '0:0:0:0:0:0:0:1', '2023-04-17 10:26:34');
|
|
|
INSERT INTO `sys_log` VALUES ('6', 'admin', '保存用户', 'com.learn.controller.SysUserController.save()', '{\"roleIdList\":[1],\"status\":1,\"username\":\"小明\"}', '0:0:0:0:0:0:0:1', '2023-04-17 10:30:58');
|
|
|
INSERT INTO `sys_log` VALUES ('7', 'admin', '修改菜单', 'com.learn.controller.SysMenuController.update()', '{\"icon\":\"fa fa-th-list\",\"menuId\":36,\"name\":\"课程选择\",\"orderNum\":6,\"parentId\":0,\"parentName\":\"一级菜单\",\"type\":1,\"url\":\"generator/choose.html\"}', '0:0:0:0:0:0:0:1', '2023-04-17 12:36:29');
|
|
|
INSERT INTO `sys_log` VALUES ('8', 'admin', '修改菜单', 'com.learn.controller.SysMenuController.update()', '{\"icon\":\"fa fa-user-circle\",\"menuId\":41,\"name\":\"教师管理\",\"orderNum\":6,\"parentId\":0,\"parentName\":\"一级菜单\",\"type\":1,\"url\":\"generator/teacher.html\"}', '0:0:0:0:0:0:0:1', '2023-04-17 12:46:48');
|
|
|
INSERT INTO `sys_log` VALUES ('9', 'admin', '删除菜单', 'com.learn.controller.SysMenuController.delete()', '[38,40,39]', '0:0:0:0:0:0:0:1', '2023-04-17 13:00:47');
|
|
|
INSERT INTO `sys_log` VALUES ('10', 'admin', '修改菜单', 'com.learn.controller.SysMenuController.update()', '{\"icon\":\"fa fa-book\",\"menuId\":46,\"name\":\"教师开课\",\"orderNum\":6,\"parentId\":1,\"parentName\":\"系统管理\",\"type\":1,\"url\":\"generator/teachercourse.html\"}', '0:0:0:0:0:0:0:1', '2023-04-17 13:02:38');
|
|
|
INSERT INTO `sys_log` VALUES ('11', 'admin', '修改菜单', 'com.learn.controller.SysMenuController.update()', '{\"icon\":\"fa fa-book\",\"menuId\":46,\"name\":\"教师开课\",\"orderNum\":6,\"parentId\":0,\"parentName\":\"一级菜单\",\"type\":1,\"url\":\"generator/teachercourse.html\"}', '0:0:0:0:0:0:0:1', '2023-04-17 13:02:50');
|
|
|
INSERT INTO `sys_log` VALUES ('12', 'admin', '修改菜单', 'com.learn.controller.SysMenuController.update()', '{\"icon\":\"fa fa-user\",\"menuId\":2,\"name\":\"用户管理\",\"orderNum\":1,\"parentId\":0,\"parentName\":\"一级菜单\",\"type\":1,\"url\":\"sys/user.html\"}', '0:0:0:0:0:0:0:1', '2023-04-17 13:04:10');
|
|
|
INSERT INTO `sys_log` VALUES ('13', 'admin', '修改角色', 'com.learn.controller.SysRoleController.update()', '{\"createTime\":1492395994000,\"createUserId\":1,\"menuIdList\":[31,32,36,37,46,47],\"roleId\":1,\"roleName\":\"学生\"}', '0:0:0:0:0:0:0:1', '2023-04-17 13:04:43');
|
|
|
INSERT INTO `sys_log` VALUES ('14', 'admin', '修改角色', 'com.learn.controller.SysRoleController.update()', '{\"createTime\":1492395994000,\"createUserId\":1,\"menuIdList\":[31,32,36,37],\"roleId\":1,\"roleName\":\"学生\"}', '0:0:0:0:0:0:0:1', '2023-04-17 13:24:40');
|
|
|
INSERT INTO `sys_log` VALUES ('15', 'admin', '修改菜单', 'com.learn.controller.SysMenuController.update()', '{\"icon\":\"fa fa-build\",\"menuId\":51,\"name\":\"选课记录\",\"orderNum\":6,\"parentId\":0,\"parentName\":\"一级菜单\",\"type\":1,\"url\":\"generator/record.html\"}', '0:0:0:0:0:0:0:1', '2023-04-17 14:40:22');
|
|
|
INSERT INTO `sys_log` VALUES ('16', 'admin', '修改菜单', 'com.learn.controller.SysMenuController.update()', '{\"icon\":\"fa fa-building\",\"menuId\":51,\"name\":\"选课记录\",\"orderNum\":6,\"parentId\":0,\"parentName\":\"一级菜单\",\"type\":1,\"url\":\"generator/record.html\"}', '0:0:0:0:0:0:0:1', '2023-04-17 14:41:05');
|
|
|
INSERT INTO `sys_log` VALUES ('17', 'admin', '修改角色', 'com.learn.controller.SysRoleController.update()', '{\"createTime\":1492395994000,\"createUserId\":1,\"menuIdList\":[31,32,36,37,51,52],\"roleId\":1,\"roleName\":\"学生\"}', '0:0:0:0:0:0:0:1', '2023-04-17 14:42:53');
|
|
|
INSERT INTO `sys_log` VALUES ('18', 'admin', '修改菜单', 'com.learn.controller.SysMenuController.update()', '{\"icon\":\"fa fa-building\",\"menuId\":53,\"name\":\"学生选课\",\"orderNum\":6,\"parentId\":1,\"parentName\":\"系统管理\",\"type\":1,\"url\":\"generator/record.html\"}', '0:0:0:0:0:0:0:1', '2023-04-17 15:06:42');
|
|
|
INSERT INTO `sys_log` VALUES ('19', 'admin', '修改菜单', 'com.learn.controller.SysMenuController.update()', '{\"icon\":\"fa fa-building\",\"menuId\":53,\"name\":\"学生选课\",\"orderNum\":6,\"parentId\":0,\"parentName\":\"一级菜单\",\"type\":1,\"url\":\"generator/record.html\"}', '0:0:0:0:0:0:0:1', '2023-04-17 15:06:48');
|
|
|
INSERT INTO `sys_log` VALUES ('20', 'admin', '修改菜单', 'com.learn.controller.SysMenuController.update()', '{\"icon\":\"fa fa-building\",\"menuId\":53,\"name\":\"学生选课\",\"orderNum\":6,\"parentId\":0,\"parentName\":\"一级菜单\",\"type\":1,\"url\":\"generator/choose-user.html\"}', '0:0:0:0:0:0:0:1', '2023-04-17 15:10:43');
|
|
|
INSERT INTO `sys_log` VALUES ('21', 'admin2', '保存角色', 'com.learn.controller.SysRoleController.save()', '{\"menuIdList\":[],\"roleName\":\"系统管理员\"}', '0:0:0:0:0:0:0:1', '2023-04-17 15:24:04');
|
|
|
INSERT INTO `sys_log` VALUES ('22', 'admin2', '修改角色', 'com.learn.controller.SysRoleController.update()', '{\"createTime\":1492413844000,\"createUserId\":-1,\"menuIdList\":[2,15,16,17,18,31,32,33,34,35,41,42,43,44,45,46,47,48,49,50,53,54],\"roleId\":2,\"roleName\":\"系统管理员\"}', '0:0:0:0:0:0:0:1', '2023-04-17 15:29:39');
|
|
|
INSERT INTO `sys_log` VALUES ('23', 'admin', '保存用户', 'com.learn.controller.SysUserController.save()', '{\"email\":\"36113@qq.com\",\"mobile\":\"13887477411\",\"roleIdList\":[1],\"status\":1,\"username\":\"大明\"}', '0:0:0:0:0:0:0:1', '2023-04-17 21:15:22');
|
|
|
INSERT INTO `sys_log` VALUES ('24', 'admin', '保存用户', 'com.learn.controller.SysUserController.save()', '{\"email\":\"zhangsan@137.com\",\"mobile\":\"18378729881\",\"roleIdList\":[1],\"status\":1,\"username\":\"张三\"}', '0:0:0:0:0:0:0:1', '2023-04-17 21:38:29');
|
|
|
INSERT INTO `sys_log` VALUES ('25', 'admin', '保存用户', 'com.learn.controller.SysUserController.save()', '{\"email\":\"lisi@163.com\",\"mobile\":\"13963651269\",\"roleIdList\":[1],\"status\":1,\"username\":\"李四\"}', '0:0:0:0:0:0:0:1', '2023-04-17 21:38:48');
|
|
|
INSERT INTO `sys_log` VALUES ('26', 'admin2', '修改角色', 'com.learn.controller.SysRoleController.update()', '{\"createTime\":1492413844000,\"createUserId\":-1,\"menuIdList\":[2,15,16,17,18,31,32,33,34,35,41,42,43,44,45,46,47,48,49,50,53,54,60,61,62,63,64],\"roleId\":2,\"roleName\":\"系统管理员\"}', '0:0:0:0:0:0:0:1', '2023-04-17 21:41:35');
|
|
|
INSERT INTO `sys_log` VALUES ('27', 'admin', '删除菜单', 'com.learn.controller.SysMenuController.delete()', '[33,34,35,36,37,41,42,43,44,45]', '0:0:0:0:0:0:0:1', '2023-05-04 17:59:51');
|
|
|
INSERT INTO `sys_log` VALUES ('28', 'admin', '删除菜单', 'com.learn.controller.SysMenuController.delete()', '[46,47,48,49,50,51,52,53,54,60]', '0:0:0:0:0:0:0:1', '2023-05-04 17:59:54');
|
|
|
INSERT INTO `sys_log` VALUES ('29', 'admin', '删除菜单', 'com.learn.controller.SysMenuController.delete()', '[64,63,62,61]', '0:0:0:0:0:0:0:1', '2023-05-04 17:59:58');
|
|
|
INSERT INTO `sys_log` VALUES ('30', 'admin', '删除菜单', 'com.learn.controller.SysMenuController.delete()', '[32,31]', '0:0:0:0:0:0:0:1', '2023-05-04 18:00:02');
|
|
|
INSERT INTO `sys_log` VALUES ('31', 'admin', '修改角色', 'com.learn.controller.SysRoleController.update()', '{\"createTime\":1492413844000,\"createUserId\":-1,\"menuIdList\":[1,3,19,20,21,22,4,23,24,25,26,5,6,7,8,9,10,11,12,13,14,27,30,29,28,2,15,16,17,18],\"roleId\":2,\"roleName\":\"系统管理员\"}', '0:0:0:0:0:0:0:1', '2023-05-04 18:01:30');
|
|
|
INSERT INTO `sys_log` VALUES ('32', 'admin', '修改角色', 'com.learn.controller.SysRoleController.update()', '{\"createTime\":1492395994000,\"createUserId\":1,\"menuIdList\":[2,15,16,17,18],\"roleId\":1,\"roleName\":\"普通\"}', '0:0:0:0:0:0:0:1', '2023-05-04 18:01:36');
|
|
|
INSERT INTO `sys_log` VALUES ('33', 'admin', '修改角色', 'com.learn.controller.SysRoleController.update()', '{\"createTime\":1492413844000,\"createUserId\":-1,\"menuIdList\":[2,15,16,17,18],\"roleId\":2,\"roleName\":\"系统管理员\"}', '0:0:0:0:0:0:0:1', '2023-05-04 18:04:19');
|
|
|
INSERT INTO `sys_log` VALUES ('34', 'admin', '修改个人信息', 'com.learn.controller.SysUserController.updateInfo()', '\"13612345678\"', '127.0.0.1', '2023-03-13 18:45:44');
|
|
|
INSERT INTO `sys_log` VALUES ('35', 'admin', '修改个人信息', 'com.learn.controller.SysUserController.updateInfo()', '\"13612345678\"', '127.0.0.1', '2023-03-13 18:46:06');
|
|
|
INSERT INTO `sys_log` VALUES ('36', 'admin', '修改个人信息', 'com.learn.controller.SysUserController.updateInfo()', '\"13612345678\"', '127.0.0.1', '2023-03-13 18:46:10');
|
|
|
INSERT INTO `sys_log` VALUES ('37', 'admin', '修改个人信息', 'com.learn.controller.SysUserController.updateInfo()', '\"13223232323\"', '127.0.0.1', '2023-03-13 18:46:41');
|
|
|
INSERT INTO `sys_log` VALUES ('38', 'admin', '修改个人信息', 'com.learn.controller.SysUserController.updateInfo()', '\"321321\"', '127.0.0.1', '2023-03-13 18:46:45');
|
|
|
INSERT INTO `sys_log` VALUES ('39', 'admin', '修改个人信息', 'com.learn.controller.SysUserController.updateInfo()', '\"321321\"', '127.0.0.1', '2023-03-13 18:46:55');
|
|
|
INSERT INTO `sys_log` VALUES ('40', 'admin', '修改个人信息', 'com.learn.controller.SysUserController.updateInfo()', '\"321321\"', '127.0.0.1', '2023-03-13 18:47:09');
|
|
|
INSERT INTO `sys_log` VALUES ('41', 'admin1', '修改菜单', 'com.learn.controller.SysMenuController.update()', '{\"menuId\":75,\"name\":\"预约记录\",\"orderNum\":6,\"parentId\":0,\"parentName\":\"一级菜单\",\"type\":1,\"url\":\"admin/record.html\"}', '0:0:0:0:0:0:0:1', '2023-03-19 23:08:37');
|
|
|
INSERT INTO `sys_log` VALUES ('42', 'admin1', '保存菜单', 'com.learn.controller.SysMenuController.save()', '{\"name\":\"座位预约\",\"orderNum\":6,\"parentId\":0,\"parentName\":\"一级菜单\",\"type\":1,\"url\":\"admin/seat1.html\"}', '0:0:0:0:0:0:0:1', '2023-03-19 23:08:57');
|
|
|
INSERT INTO `sys_log` VALUES ('43', 'admin1', '保存菜单', 'com.learn.controller.SysMenuController.save()', '{\"name\":\"预约审批\",\"orderNum\":0,\"parentId\":0,\"parentName\":\"一级菜单\",\"type\":1,\"url\":\"admin/record1.html\"}', '0:0:0:0:0:0:0:1', '2023-03-19 23:26:50');
|
|
|
INSERT INTO `sys_log` VALUES ('44', 'admin1', '修改菜单', 'com.learn.controller.SysMenuController.update()', '{\"menuId\":81,\"name\":\"预约审批\",\"orderNum\":0,\"parentId\":0,\"parentName\":\"一级菜单\",\"type\":1,\"url\":\"admin/record1.html\"}', '0:0:0:0:0:0:0:1', '2023-03-19 23:27:03');
|
|
|
INSERT INTO `sys_log` VALUES ('45', 'admin1', '修改菜单', 'com.learn.controller.SysMenuController.update()', '{\"menuId\":81,\"name\":\"预约审批\",\"orderNum\":6,\"parentId\":0,\"parentName\":\"一级菜单\",\"type\":1,\"url\":\"admin/record1.html\"}', '0:0:0:0:0:0:0:1', '2023-03-19 23:27:07');
|
|
|
INSERT INTO `sys_log` VALUES ('46', 'admin1', '修改角色', 'com.learn.controller.SysRoleController.update()', '{\"createTime\":1523931994000,\"createUserId\":1,\"menuIdList\":[65,67,68,69,75,76,80],\"roleId\":1,\"roleName\":\"普通\"}', '0:0:0:0:0:0:0:1', '2023-03-19 23:36:45');
|
|
|
INSERT INTO `sys_log` VALUES ('47', 'admin1', '修改菜单', 'com.learn.controller.SysMenuController.update()', '{\"menuId\":75,\"name\":\"预约记录\",\"orderNum\":7,\"parentId\":0,\"parentName\":\"一级菜单\",\"type\":1,\"url\":\"admin/record.html\"}', '0:0:0:0:0:0:0:1', '2023-03-19 23:36:57');
|
|
|
INSERT INTO `sys_log` VALUES ('48', 'admin1', '修改角色', 'com.learn.controller.SysRoleController.update()', '{\"createTime\":1523949844000,\"createUserId\":-1,\"menuIdList\":[2,15,16,17,18,65,66,67,68,69,70,71,72,73,74,81,75,76,77,78,79],\"roleId\":2,\"roleName\":\"系统管理员\"}', '0:0:0:0:0:0:0:1', '2023-03-19 23:37:21');
|
|
|
INSERT INTO `sys_log` VALUES ('49', 'admin1', '修改角色', 'com.learn.controller.SysRoleController.update()', '{\"createTime\":1523949844000,\"createUserId\":-1,\"menuIdList\":[2,15,16,17,18,65,66,67,68,69,70,71,72,73,74,81],\"roleId\":2,\"roleName\":\"系统管理员\"}', '0:0:0:0:0:0:0:1', '2023-03-19 23:37:52');
|
|
|
INSERT INTO `sys_log` VALUES ('50', 'admin', '修改用户', 'com.learn.controller.SysUserController.update()', '{\"createTime\":1525428183000,\"roleIdList\":[1],\"status\":1,\"userId\":8,\"username\":\"王同学\"}', '0:0:0:0:0:0:0:1', '2023-03-19 23:38:43');
|
|
|
INSERT INTO `sys_log` VALUES ('51', 'admin1', '修改角色', 'com.learn.controller.SysRoleController.update()', '{\"createTime\":1523931994000,\"createUserId\":1,\"menuIdList\":[65,66,80,75,76],\"roleId\":1,\"roleName\":\"普通\"}', '0:0:0:0:0:0:0:1', '2023-03-19 23:40:41');
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Table structure for sys_menu
|
|
|
-- ----------------------------
|
|
|
DROP TABLE IF EXISTS `sys_menu`;
|
|
|
CREATE TABLE `sys_menu` (
|
|
|
`menu_id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
|
`parent_id` bigint(20) DEFAULT NULL COMMENT '父菜单ID，一级菜单为0',
|
|
|
`name` varchar(50) DEFAULT NULL COMMENT '菜单名称',
|
|
|
`url` varchar(200) DEFAULT NULL COMMENT '菜单URL',
|
|
|
`perms` varchar(500) DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：user:list,user:create)',
|
|
|
`type` int(11) DEFAULT NULL COMMENT '类型 0：目录 1：菜单 2：按钮',
|
|
|
`icon` varchar(50) DEFAULT NULL COMMENT '菜单图标',
|
|
|
`order_num` int(11) DEFAULT NULL COMMENT '排序',
|
|
|
PRIMARY KEY (`menu_id`)
|
|
|
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=utf8 COMMENT='菜单管理';
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Records of sys_menu
|
|
|
-- ----------------------------
|
|
|
INSERT INTO `sys_menu` VALUES ('1', '0', '系统管理', null, null, '0', 'fa fa-cog', '0');
|
|
|
INSERT INTO `sys_menu` VALUES ('2', '0', '用户管理', 'sys/user.html', null, '1', 'fa fa-user', '1');
|
|
|
INSERT INTO `sys_menu` VALUES ('3', '1', '角色管理', 'sys/role.html', null, '1', 'fa fa-user-secret', '2');
|
|
|
INSERT INTO `sys_menu` VALUES ('4', '1', '菜单管理', 'sys/menu.html', null, '1', 'fa fa-th-list', '3');
|
|
|
INSERT INTO `sys_menu` VALUES ('5', '1', 'SQL监控', 'druid/sql.html', null, '1', 'fa fa-bug', '4');
|
|
|
INSERT INTO `sys_menu` VALUES ('6', '1', '定时任务', 'sys/schedule.html', null, '1', 'fa fa-tasks', '5');
|
|
|
INSERT INTO `sys_menu` VALUES ('7', '6', '查看', null, 'sys:schedule:list,sys:schedule:info', '2', null, '0');
|
|
|
INSERT INTO `sys_menu` VALUES ('8', '6', '新增', null, 'sys:schedule:save', '2', null, '0');
|
|
|
INSERT INTO `sys_menu` VALUES ('9', '6', '修改', null, 'sys:schedule:update', '2', null, '0');
|
|
|
INSERT INTO `sys_menu` VALUES ('10', '6', '删除', null, 'sys:schedule:delete', '2', null, '0');
|
|
|
INSERT INTO `sys_menu` VALUES ('11', '6', '暂停', null, 'sys:schedule:pause', '2', null, '0');
|
|
|
INSERT INTO `sys_menu` VALUES ('12', '6', '恢复', null, 'sys:schedule:resume', '2', null, '0');
|
|
|
INSERT INTO `sys_menu` VALUES ('13', '6', '立即执行', null, 'sys:schedule:run', '2', null, '0');
|
|
|
INSERT INTO `sys_menu` VALUES ('14', '6', '日志列表', null, 'sys:schedule:log', '2', null, '0');
|
|
|
INSERT INTO `sys_menu` VALUES ('15', '2', '查看', null, 'sys:user:list,sys:user:info', '2', null, '0');
|
|
|
INSERT INTO `sys_menu` VALUES ('16', '2', '新增', null, 'sys:user:save,sys:role:select', '2', null, '0');
|
|
|
INSERT INTO `sys_menu` VALUES ('17', '2', '修改', null, 'sys:user:update,sys:role:select', '2', null, '0');
|
|
|
INSERT INTO `sys_menu` VALUES ('18', '2', '删除', null, 'sys:user:delete', '2', null, '0');
|
|
|
INSERT INTO `sys_menu` VALUES ('19', '3', '查看', null, 'sys:role:list,sys:role:info', '2', null, '0');
|
|
|
INSERT INTO `sys_menu` VALUES ('20', '3', '新增', null, 'sys:role:save,sys:menu:perms', '2', null, '0');
|
|
|
INSERT INTO `sys_menu` VALUES ('21', '3', '修改', null, 'sys:role:update,sys:menu:perms', '2', null, '0');
|
|
|
INSERT INTO `sys_menu` VALUES ('22', '3', '删除', null, 'sys:role:delete', '2', null, '0');
|
|
|
INSERT INTO `sys_menu` VALUES ('23', '4', '查看', null, 'sys:menu:list,sys:menu:info', '2', null, '0');
|
|
|
INSERT INTO `sys_menu` VALUES ('24', '4', '新增', null, 'sys:menu:save,sys:menu:select', '2', null, '0');
|
|
|
INSERT INTO `sys_menu` VALUES ('25', '4', '修改', null, 'sys:menu:update,sys:menu:select', '2', null, '0');
|
|
|
INSERT INTO `sys_menu` VALUES ('26', '4', '删除', null, 'sys:menu:delete', '2', null, '0');
|
|
|
INSERT INTO `sys_menu` VALUES ('27', '1', '参数管理', 'sys/config.html', 'sys:config:list,sys:config:info,sys:config:save,sys:config:update,sys:config:delete', '1', 'fa fa-sun-o', '6');
|
|
|
INSERT INTO `sys_menu` VALUES ('28', '1', '代码生成器', 'sys/generator.html', 'sys:generator:list,sys:generator:code', '1', 'fa fa-rocket', '8');
|
|
|
INSERT INTO `sys_menu` VALUES ('29', '1', '系统日志', 'sys/log.html', 'sys:log:list', '1', 'fa fa-file-text-o', '7');
|
|
|
INSERT INTO `sys_menu` VALUES ('30', '1', '文件上传', 'sys/oss.html', 'sys:oss:all', '1', 'fa fa-file-image-o', '6');
|
|
|
INSERT INTO `sys_menu` VALUES ('65', '0', '通知公告', 'admin/news.html', null, '1', null, '6');
|
|
|
INSERT INTO `sys_menu` VALUES ('66', '65', '查看', null, 'news:list,news:info', '2', null, '6');
|
|
|
INSERT INTO `sys_menu` VALUES ('67', '65', '新增', null, 'news:save', '2', null, '6');
|
|
|
INSERT INTO `sys_menu` VALUES ('68', '65', '修改', null, 'news:update', '2', null, '6');
|
|
|
INSERT INTO `sys_menu` VALUES ('69', '65', '删除', null, 'news:delete', '2', null, '6');
|
|
|
INSERT INTO `sys_menu` VALUES ('70', '0', '座位信息', 'admin/seat.html', null, '1', null, '6');
|
|
|
INSERT INTO `sys_menu` VALUES ('71', '70', '查看', null, 'seat:list,seat:info', '2', null, '6');
|
|
|
INSERT INTO `sys_menu` VALUES ('72', '70', '新增', null, 'seat:save', '2', null, '6');
|
|
|
INSERT INTO `sys_menu` VALUES ('73', '70', '修改', null, 'seat:update', '2', null, '6');
|
|
|
INSERT INTO `sys_menu` VALUES ('74', '70', '删除', null, 'seat:delete', '2', null, '6');
|
|
|
INSERT INTO `sys_menu` VALUES ('75', '0', '预约记录', 'admin/record.html', null, '1', null, '7');
|
|
|
INSERT INTO `sys_menu` VALUES ('76', '75', '查看', null, 'record:list,record:info', '2', null, '6');
|
|
|
INSERT INTO `sys_menu` VALUES ('77', '75', '新增', null, 'record:save', '2', null, '6');
|
|
|
INSERT INTO `sys_menu` VALUES ('78', '75', '修改', null, 'record:update', '2', null, '6');
|
|
|
INSERT INTO `sys_menu` VALUES ('79', '75', '删除', null, 'record:delete', '2', null, '6');
|
|
|
INSERT INTO `sys_menu` VALUES ('80', '0', '座位预约', 'admin/seat1.html', null, '1', null, '6');
|
|
|
INSERT INTO `sys_menu` VALUES ('81', '0', '预约审批', 'admin/record1.html', null, '1', null, '6');
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Table structure for sys_oss
|
|
|
-- ----------------------------
|
|
|
DROP TABLE IF EXISTS `sys_oss`;
|
|
|
CREATE TABLE `sys_oss` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
|
`url` varchar(200) DEFAULT NULL COMMENT 'URL地址',
|
|
|
`create_date` datetime DEFAULT NULL COMMENT '创建时间',
|
|
|
PRIMARY KEY (`id`)
|
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='文件上传';
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Records of sys_oss
|
|
|
-- ----------------------------
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Table structure for sys_role
|
|
|
-- ----------------------------
|
|
|
DROP TABLE IF EXISTS `sys_role`;
|
|
|
CREATE TABLE `sys_role` (
|
|
|
`role_id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
|
`role_name` varchar(100) DEFAULT NULL COMMENT '角色名称',
|
|
|
`remark` varchar(100) DEFAULT NULL COMMENT '备注',
|
|
|
`create_user_id` bigint(20) DEFAULT NULL COMMENT '创建者ID',
|
|
|
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
|
|
PRIMARY KEY (`role_id`)
|
|
|
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='角色';
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Records of sys_role
|
|
|
-- ----------------------------
|
|
|
INSERT INTO `sys_role` VALUES ('1', '普通', null, '1', '2023-04-17 10:26:34');
|
|
|
INSERT INTO `sys_role` VALUES ('2', '系统管理员', null, '-1', '2023-04-17 15:24:04');
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Table structure for sys_role_menu
|
|
|
-- ----------------------------
|
|
|
DROP TABLE IF EXISTS `sys_role_menu`;
|
|
|
CREATE TABLE `sys_role_menu` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
|
`role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
|
|
|
`menu_id` bigint(20) DEFAULT NULL COMMENT '菜单ID',
|
|
|
PRIMARY KEY (`id`)
|
|
|
) ENGINE=InnoDB AUTO_INCREMENT=157 DEFAULT CHARSET=utf8 COMMENT='角色与菜单对应关系';
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Records of sys_role_menu
|
|
|
-- ----------------------------
|
|
|
INSERT INTO `sys_role_menu` VALUES ('136', '2', '2');
|
|
|
INSERT INTO `sys_role_menu` VALUES ('137', '2', '15');
|
|
|
INSERT INTO `sys_role_menu` VALUES ('138', '2', '16');
|
|
|
INSERT INTO `sys_role_menu` VALUES ('139', '2', '17');
|
|
|
INSERT INTO `sys_role_menu` VALUES ('140', '2', '18');
|
|
|
INSERT INTO `sys_role_menu` VALUES ('141', '2', '65');
|
|
|
INSERT INTO `sys_role_menu` VALUES ('142', '2', '66');
|
|
|
INSERT INTO `sys_role_menu` VALUES ('143', '2', '67');
|
|
|
INSERT INTO `sys_role_menu` VALUES ('144', '2', '68');
|
|
|
INSERT INTO `sys_role_menu` VALUES ('145', '2', '69');
|
|
|
INSERT INTO `sys_role_menu` VALUES ('146', '2', '70');
|
|
|
INSERT INTO `sys_role_menu` VALUES ('147', '2', '71');
|
|
|
INSERT INTO `sys_role_menu` VALUES ('148', '2', '72');
|
|
|
INSERT INTO `sys_role_menu` VALUES ('149', '2', '73');
|
|
|
INSERT INTO `sys_role_menu` VALUES ('150', '2', '74');
|
|
|
INSERT INTO `sys_role_menu` VALUES ('151', '2', '81');
|
|
|
INSERT INTO `sys_role_menu` VALUES ('152', '1', '65');
|
|
|
INSERT INTO `sys_role_menu` VALUES ('153', '1', '66');
|
|
|
INSERT INTO `sys_role_menu` VALUES ('154', '1', '80');
|
|
|
INSERT INTO `sys_role_menu` VALUES ('155', '1', '75');
|
|
|
INSERT INTO `sys_role_menu` VALUES ('156', '1', '76');
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Table structure for sys_user
|
|
|
-- ----------------------------
|
|
|
DROP TABLE IF EXISTS `sys_user`;
|
|
|
CREATE TABLE `sys_user` (
|
|
|
`user_id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
|
`username` varchar(50) NOT NULL COMMENT '用户名',
|
|
|
`password` varchar(100) DEFAULT NULL COMMENT '密码',
|
|
|
`email` varchar(100) DEFAULT NULL COMMENT '邮箱',
|
|
|
`mobile` varchar(100) DEFAULT NULL COMMENT '手机号',
|
|
|
`status` tinyint(4) DEFAULT NULL COMMENT '状态 0：禁用 1：正常',
|
|
|
`create_user_id` bigint(20) DEFAULT NULL COMMENT '创建者ID',
|
|
|
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
|
|
|
PRIMARY KEY (`user_id`),
|
|
|
UNIQUE KEY `username` (`username`)
|
|
|
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='系统用户';
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Records of sys_user
|
|
|
-- ----------------------------
|
|
|
INSERT INTO `sys_user` VALUES ('-1', 'admin', '96cae35ce8a9b0244178bf28e4966c2ce1b8385723a96a6b838858cdd6ca0a1e', 'root@renren.io', '321321', '1', null, '2023-11-11 11:11:11');
|
|
|
INSERT INTO `sys_user` VALUES ('1', 'admin1', '96cae35ce8a9b0244178bf28e4966c2ce1b8385723a96a6b838858cdd6ca0a1e', 'admin@admin.com', '13612345678', '1', null, '2023-11-11 11:11:11');
|
|
|
INSERT INTO `sys_user` VALUES ('8', '王同学', '96cae35ce8a9b0244178bf28e4966c2ce1b8385723a96a6b838858cdd6ca0a1e', null, null, '1', null, '2023-05-04 18:03:03');
|
|
|
INSERT INTO `sys_user` VALUES ('9', '李大胖', '96cae35ce8a9b0244178bf28e4966c2ce1b8385723a96a6b838858cdd6ca0a1e', null, null, '1', null, '2023-03-19 23:40:10');
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Table structure for sys_user_role
|
|
|
-- ----------------------------
|
|
|
DROP TABLE IF EXISTS `sys_user_role`;
|
|
|
CREATE TABLE `sys_user_role` (
|
|
|
`id` bigint(20) NOT NULL AUTO_INCREMENT,
|
|
|
`user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
|
|
|
`role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
|
|
|
PRIMARY KEY (`id`)
|
|
|
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='用户与角色对应关系';
|
|
|
|
|
|
-- ----------------------------
|
|
|
-- Records of sys_user_role
|
|
|
-- ----------------------------
|
|
|
INSERT INTO `sys_user_role` VALUES ('7', '-1', '2');
|
|
|
INSERT INTO `sys_user_role` VALUES ('8', '8', '1');
|
|
|
INSERT INTO `sys_user_role` VALUES ('9', '9', '1');
|
