/* 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');