/*
 Navicat Premium Data Transfer

 Source Server         : 云端测试数据库spring_db
 Source Server Type    : MySQL
 Source Server Version : 50650
 Source Host           : 58.56.31.21:3306
 Source Schema         : spring_db

 Target Server Type    : MySQL
 Target Server Version : 50650
 File Encoding         : 65001

 Date: 14/08/2022 23:45:33
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_admin
-- ----------------------------
DROP TABLE IF EXISTS `tb_admin`;
CREATE TABLE `tb_admin`  (
  `admin_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户姓名',
  `user_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户登录名，不能重复,可为中文',
  `password` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户密码，shiro MD5密码32位',
  `dept_id` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联的部门id',
  `dept_name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联的部门名称',
  `state` decimal(11, 0) NULL DEFAULT NULL COMMENT '1启用0停用',
  `created` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `operator` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '静态记录编辑改用户的管理员姓名',
  `version` int(255) UNSIGNED NULL DEFAULT 1 COMMENT 'mybatisplus乐观锁版本号',
  `operator_id` bigint(20) NULL DEFAULT 0 COMMENT '操作用户id',
  `operator_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作用户名',
  `deleted` int(1) NULL DEFAULT 0 COMMENT '逻辑删除标记',
  PRIMARY KEY (`admin_id`) USING BTREE,
  UNIQUE INDEX `Idx_adminId`(`admin_id`) USING BTREE COMMENT '主键索引，唯一索引',
  INDEX `SYS_C005467`(`dept_id`) USING BTREE COMMENT '关联部门id索引，普通索引',
  INDEX `Idx_name`(`name`) USING BTREE COMMENT '姓名索引，普通索引',
  INDEX `Idx_updated`(`updated`) USING BTREE COMMENT '更新时间索引，普通索引'
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of tb_admin
-- ----------------------------
INSERT INTO `tb_admin` VALUES (1, '张骞1', 'zhangqian', '123', '16', NULL, 1, NULL, '2022-04-08 18:46:19', NULL, 6, 0, NULL, 0);

-- ----------------------------
-- Table structure for tb_campus
-- ----------------------------
DROP TABLE IF EXISTS `tb_campus`;
CREATE TABLE `tb_campus`  (
  `campus_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '加盟校名称',
  `coop_time` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '合作时间',
  `sale` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属销售',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `number` int(255) NULL DEFAULT NULL COMMENT '账户最大数量',
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所属地区',
  `created` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `operator` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最后一次操作数据的用户名',
  `version` int(255) NULL DEFAULT 1 COMMENT '乐观锁版本号',
  `deleted` int(1) NULL DEFAULT 0 COMMENT '逻辑删除标记',
  PRIMARY KEY (`campus_id`) USING BTREE,
  UNIQUE INDEX `Idx_id`(`campus_id`) USING BTREE COMMENT '主键索引，唯一索引',
  INDEX `Idx_name`(`name`) USING BTREE COMMENT '名称索引，普通索引',
  INDEX `Idx_coopTime`(`coop_time`) USING BTREE COMMENT '合作时间索引，普通索引',
  INDEX `Idx_updated`(`updated`) USING BTREE COMMENT '更新时间索引，普通索引',
  INDEX `Idx_address`(`address`) USING BTREE COMMENT '地址索引，普通索引'
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of tb_campus
-- ----------------------------
INSERT INTO `tb_campus` VALUES ('66ccd82ecc82f4b17165c5b0e986156a', '测试加盟校1', '2022-06-09', '测试人员', '', 1, '山东省菏泽市鄄城县', '2022-06-09 11:35:20', '2022-06-09 12:11:58', '张骞', 4, 0);
INSERT INTO `tb_campus` VALUES ('93ad355892f3b88a74ee81639f164c88', '测试加盟校', '2022-06-09', '王荣荣', '测试数据', 3, '山东省济南市历城区二环东路', '2022-06-09 12:11:24', '2022-06-11 18:15:56', '张骞', 3, 0);
INSERT INTO `tb_campus` VALUES ('e31d3aabde194c39bb7c2094efb32d4d', '济南方未教育咨询有限公司', '2022-03-01', '——', '总部校区', 10, '山东省济南市历城区二环东路3966号', '2022-03-08 14:28:01', '2022-06-09 18:18:46', '张骞', 2, 0);

-- ----------------------------
-- Table structure for tb_dept
-- ----------------------------
DROP TABLE IF EXISTS `tb_dept`;
CREATE TABLE `tb_dept`  (
  `dept_id` bigint(40) NOT NULL AUTO_INCREMENT,
  `dept_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门名称',
  `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '部门备注',
  `created` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `operator` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '记录最后一次编辑人',
  `version` int(255) NULL DEFAULT 1 COMMENT 'mybatisplus乐观锁版本号',
  `operator_id` bigint(1) NULL DEFAULT NULL COMMENT '操作用户id',
  `operator_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作用户名',
  `deleted` int(1) NULL DEFAULT 0 COMMENT '逻辑删除标记',
  PRIMARY KEY (`dept_id`) USING BTREE,
  INDEX `dept_name`(`dept_name`) USING BTREE,
  INDEX `DEPT_ADMIN_ID`(`operator_id`) USING BTREE,
  INDEX `DEPT_ADMIN_NAME`(`operator_name`) USING BTREE,
  CONSTRAINT `DEPT_ADMIN_ID` FOREIGN KEY (`operator_id`) REFERENCES `tb_admin` (`admin_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `DEPT_ADMIN_NAME` FOREIGN KEY (`operator_name`) REFERENCES `tb_admin` (`name`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of tb_dept
-- ----------------------------
INSERT INTO `tb_dept` VALUES (16, '测试部门', '1', '2022-08-14 22:54:19', '2022-08-14 22:54:19', NULL, 1, 1, '张骞1', 1);

-- ----------------------------
-- Table structure for tb_heartbeat
-- ----------------------------
DROP TABLE IF EXISTS `tb_heartbeat`;
CREATE TABLE `tb_heartbeat`  (
  `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `id` int(40) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of tb_heartbeat
-- ----------------------------

-- ----------------------------
-- Table structure for tb_logger
-- ----------------------------
DROP TABLE IF EXISTS `tb_logger`;
CREATE TABLE `tb_logger`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `classes` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出现异常的位置和类名',
  `method` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出现异常的方法名',
  `user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出现异常的用户id',
  `nick_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '出现异常的用户名',
  `exception` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '具体异常信息',
  `remark` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '开发者自定义备注',
  `created` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `operator` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最后一次操作数据的用户名',
  `operator_id` bigint(1) NULL DEFAULT NULL COMMENT '操作用户id',
  `operator_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作用户名',
  UNIQUE INDEX `Idx_id`(`id`) USING BTREE COMMENT '主键索引，唯一索引',
  INDEX `Idx_created`(`created`) USING BTREE COMMENT '创建时间索引，普通索引',
  INDEX `ADMIN_ID`(`operator_id`) USING BTREE,
  INDEX `ADMIN_NAME`(`operator_name`) USING BTREE,
  CONSTRAINT `ADMIN_ID` FOREIGN KEY (`operator_id`) REFERENCES `tb_admin` (`admin_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `ADMIN_NAME` FOREIGN KEY (`operator_name`) REFERENCES `tb_admin` (`name`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 220 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '日志表' ROW_FORMAT = Compact;

-- ----------------------------
-- Records of tb_logger
-- ----------------------------


-- ----------------------------
-- Table structure for tb_module
-- ----------------------------
DROP TABLE IF EXISTS `tb_module`;
CREATE TABLE `tb_module`  (
  `module_id` bigint(40) NOT NULL AUTO_INCREMENT COMMENT '模块id',
  `parent_id` bigint(40) NULL DEFAULT NULL COMMENT '自关联父模块id',
  `parent_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '自关联父模块名称',
  `sort` int(255) NULL DEFAULT NULL COMMENT '排序字段',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模块名称',
  `ctype` decimal(11, 0) NULL DEFAULT NULL COMMENT '0 主菜单/1 左侧菜单/2按钮/3 链接/4 状态',
  `state` decimal(11, 0) NULL DEFAULT NULL COMMENT '1启用0停用',
  `curl` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模块静态页链接地址',
  `req` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模块向后端请求的地址',
  `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `created` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `operator` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '记录最后一次编辑人',
  `version` int(255) NULL DEFAULT 1 COMMENT 'mybatisplus乐观锁版本号',
  `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模块图标',
  `operator_id` bigint(20) NULL DEFAULT NULL COMMENT '最后一次更新数据用户Id',
  `operator_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最后一次更新数据用户名',
  `deleted` int(1) NULL DEFAULT 0 COMMENT '逻辑删除标记',
  PRIMARY KEY (`module_id`) USING BTREE,
  UNIQUE INDEX `Idx_id`(`module_id`) USING BTREE COMMENT '主键索引，唯一索引',
  INDEX `Idx_parentId`(`parent_id`) USING BTREE COMMENT '自关联父类索引，普通索引',
  INDEX `Idx_name`(`name`) USING BTREE COMMENT '名称索引，普通索引',
  INDEX `Idx_sort`(`sort`) USING BTREE COMMENT '排序索引，普通索引',
  INDEX `Idx_updated`(`updated`) USING BTREE COMMENT '修改时间索引，普通索引',
  INDEX `MODULE_ADMIN_ID`(`operator_id`) USING BTREE,
  INDEX `MODULE_ADMIN_NAME`(`operator_name`) USING BTREE,
  CONSTRAINT `MODULE_ADMIN_ID` FOREIGN KEY (`operator_id`) REFERENCES `tb_admin` (`admin_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `MODULE_ADMIN_NAME` FOREIGN KEY (`operator_name`) REFERENCES `tb_admin` (`name`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 87 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of tb_module
-- ----------------------------
INSERT INTO `tb_module` VALUES (8, NULL, NULL, 10000, '平台系统管理', 0, 1, 'system', NULL, '', '2022-03-07 18:33:45', '2022-04-14 22:38:24', '张骞', 6, 'el-icon-s-tools', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (9, 8, NULL, 10010, '部门管理', 1, 1, 'pages/system/dept/list.html', 'system/dept/page', '部门列表', '2022-03-07 18:34:28', '2022-04-15 13:32:37', '张骞', 10, 'el-icon-tickets', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (10, 9, NULL, 10011, '部门新增按钮', 2, 1, 'add', 'system/dept/save', '', '2022-03-07 18:35:00', '2022-04-15 13:45:26', '张骞', 5, 'add', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (11, 9, NULL, 10013, '部门删除按钮', 2, 1, 'del', 'system/dept/delete', '', '2022-03-07 18:35:38', '2022-04-15 13:45:37', '张骞', 5, 'del', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (12, 9, NULL, 10012, '部门修改按钮', 2, 1, 'updata', 'system/dept/edit', '', '2022-03-07 18:36:34', '2022-04-15 13:45:57', '张骞', 5, 'updata', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (13, 8, NULL, 10020, '模块管理', 1, 1, 'pages/system/module/list.html', 'system/module/page', '', '2022-03-07 18:37:05', '2022-04-15 13:46:21', '张骞', 4, 'el-icon-box', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (14, 13, NULL, 10021, '模块新增按钮', 2, 1, 'system/module/toAdd', 'system/module/save', '', '2022-03-07 18:37:46', '2022-04-15 13:47:20', '张骞', 4, 'add', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (15, 13, NULL, 10022, '模块修改按钮', 2, 1, 'system/module/toEdit', 'system/module/edit', '', '2022-03-07 18:38:03', '2022-04-15 13:47:10', '张骞', 4, 'update', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (16, 13, NULL, 10023, '模块删除按钮', 2, 1, 'system/module/delete', 'system/module/delete', '', '2022-03-07 18:38:19', '2022-04-15 13:46:59', '张骞', 3, 'del', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (17, 8, NULL, 10030, '角色管理', 1, 1, 'pages/system/role/list.html', 'system/role/page', '', '2022-03-07 18:38:48', '2022-04-15 13:47:52', '张骞', 7, 'el-icon-coordinate', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (18, 17, NULL, 10031, '角色新增按钮', 2, 1, 'system/role/toAdd', 'system/role/save', '', '2022-03-07 18:39:43', '2022-04-15 13:48:31', '张骞', 4, 'add', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (19, 17, NULL, 10032, '角色修改按钮', 2, 1, 'system/role/toEdit', 'system/role/edit', '', '2022-03-07 18:40:01', '2022-04-15 13:48:40', '张骞', 4, 'update', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (20, 17, NULL, 10033, '角色删除按钮', 2, 1, 'system/role/delete', 'system/role/delete', '', '2022-03-07 18:40:16', '2022-04-15 13:48:34', '张骞', 4, 'del', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (21, 8, NULL, 10040, '用户管理', 1, 1, 'pages/system/admin/list.html', 'system/user/page', '', '2022-03-07 18:40:58', '2022-04-15 16:55:58', '张骞', 5, 'el-icon-user', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (22, 21, NULL, 10041, '用户新增按钮', 2, 1, 'system/user/toAdd', 'system/user/save', '', '2022-03-07 18:41:33', '2022-04-15 21:30:59', '张骞', 5, 'add', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (23, 21, NULL, 10042, '用户修改按钮', 2, 1, 'system/user/toEdit', 'system/user/edit', '', '2022-03-07 18:41:49', '2022-04-15 14:03:22', '张骞', 5, 'updata', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (24, 21, NULL, 10043, '用户删除按钮', 2, 1, 'system/user/delete', 'system/user/delete', '', '2022-03-07 18:42:16', '2022-04-15 14:03:29', '张骞', 4, 'del', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (25, 8, NULL, 10050, '参数设置', 1, 1, 'pages/system/setting/list.html', 'system/setting/page', '', '2022-03-07 18:42:42', '2022-04-15 14:04:25', '张骞', 4, 'el-icon-setting', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (26, 25, NULL, 10051, '参数新增按钮', 2, 1, 'system/setting/toAdd', 'system/setting/save', '', '2022-03-07 18:43:05', '2022-04-15 14:04:32', '张骞', 3, 'add', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (27, 25, NULL, 10052, '参数修改按钮', 2, 1, 'system/setting/toEdit', 'system/setting/edit', '', '2022-03-07 18:43:25', '2022-04-15 14:04:51', '张骞', 3, 'update', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (28, 25, NULL, 10053, '参数删除按钮', 2, 1, 'system/setting/delete', 'system/setting/delete', '', '2022-03-07 18:43:39', '2022-04-15 14:04:59', '张骞', 3, 'del', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (29, 8, NULL, 10060, '系统日志管理', 1, 1, 'pages/system/logger/list.html', 'system/logger/page', '', '2022-03-07 18:45:22', '2022-04-15 14:05:11', '张骞', 5, 'el-icon-printer', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (30, NULL, NULL, 20000, '校区会员管理', 0, 1, 'school', NULL, '', '2022-03-07 23:43:29', '2022-04-14 22:42:59', '张骞', 3, 'el-icon-s-order', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (31, 30, NULL, 20010, '加盟校管理', 1, 1, 'pages/school/campus/list.html', 'school/campus/page', '', '2022-03-07 23:44:12', '2022-06-08 16:51:18', '张骞', 10, 'el-icon-school', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (32, 17, NULL, 10034, '角色授权按钮', 2, 1, 'system/role/author', 'system/role/author', '', '2022-03-08 10:14:17', '2022-04-15 14:02:45', '张骞', 3, 'author', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (35, 21, NULL, 10044, '用户角色按钮', 2, 1, 'system/user/userRoleList', NULL, '', '2022-03-08 10:28:45', '2022-04-15 00:00:39', '张骞', 3, 'role', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (36, 21, NULL, 10045, '用户角色保存按钮', 2, 1, 'system/user/updateRole', 'system/user/updateRole', '', '2022-03-08 10:29:33', '2022-04-15 14:04:15', '张骞', 5, 'add', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (38, 31, NULL, 20011, '加盟校新增按钮', 2, 1, 'school/campus/toAdd', 'school/campus/save', '', '2022-03-08 14:08:34', '2022-06-08 18:08:29', '张骞', 3, 'add', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (39, 31, NULL, 20012, '加盟校修改按钮', 2, 1, 'school/campus/toEdit', 'school/campus/edit', '按钮图标实际上是按钮标识符', '2022-03-08 14:08:54', '2022-06-08 18:10:59', '张骞', 7, 'update', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (45, 9, NULL, 10014, '部门修改回显', 2, 1, 'system/dept/findById', 'system/dept/findById', '', '2022-04-15 15:39:59', '2022-04-15 16:32:52', '张骞', 4, NULL, NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (46, 21, NULL, 10046, '用户修改回显', 2, 1, '/system/user/findById', '/system/user/findById', '', '2022-04-15 16:36:30', '2022-04-15 16:36:30', '张骞', 1, '1', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (47, 21, NULL, 10047, '用户关联部门分类', 2, 1, '/system/dept/list', '/system/dept/list', '', '2022-04-15 16:37:03', '2022-04-15 16:37:03', '张骞', 1, '1', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (48, 13, NULL, 10024, '模块查询全部接口', 2, 1, '/system/module/list', '/system/module/list', '', '2022-04-15 16:46:13', '2022-04-15 16:46:13', '张骞', 1, '1', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (49, 17, NULL, 10035, '角色权限保存请求', 2, 1, '/system/role/updateRoleModule', '/system/role/updateRoleModule', '', '2022-04-15 16:52:03', '2022-04-15 16:52:03', '张骞', 1, NULL, NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (50, 21, NULL, 10048, '用户请求角色授权回显', 2, 1, 'system/user/userRoleList', 'system/user/userRoleList', '', '2022-04-15 17:00:42', '2022-04-15 17:02:41', '张骞', 2, 'system/user/userRoleList', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (54, NULL, NULL, 30000, '课程内容管理', 0, 1, 'pages/', 'pages/', '', '2022-06-08 16:25:18', '2022-06-08 16:41:06', '张骞', 3, 'el-icon-s-management', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (55, NULL, NULL, 40000, '平台线索管理', 0, 1, 'pages/clue/list.html', '/pages', '', '2022-06-08 16:25:41', '2022-06-10 18:12:51', '张骞', 3, 'el-icon-phone', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (56, 54, NULL, 30010, '课程管理', 1, 1, 'pages/course/course/list.html', 'course/course/page', '', '2022-06-08 16:36:09', '2022-06-10 14:58:46', '张骞', 5, 'el-icon-tickets', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (57, 55, NULL, 40010, '平台线索清单', 1, 1, 'pages/clue/list.html', 'pages/clue/list', '', '2022-06-08 16:38:46', '2022-06-09 14:10:00', '张骞', 2, 'el-icon-phone-outline', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (58, 31, NULL, 20013, '加盟校删除按钮', 2, 1, 'school/campus/delete', 'school/campus/delete', '', '2022-06-08 18:14:19', '2022-06-08 18:14:19', '张骞', 1, 'del', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (59, 31, NULL, 20014, '加盟校会员管理按钮', 2, 1, 'school/user/list.html', 'school/user/list', '', '2022-06-08 18:21:57', '2022-06-09 14:12:26', '张骞', 2, 'account', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (60, 31, NULL, 20015, '加盟校授权管理按钮', 2, 1, 'page', 'page', '', '2022-06-09 09:33:04', '2022-06-09 09:33:04', '张骞', 1, 'author', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (63, 30, NULL, 20020, '课程组管理', 1, 1, 'pages/school/group/list.html', 'pages/school/group/page', '', '2022-06-09 17:17:50', '2022-06-09 17:17:50', '张骞', 1, 'el-icon-receiving', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (64, 63, NULL, 20021, '课程组管理新增', 2, 1, 'page', 'page', '', '2022-06-09 17:18:15', '2022-06-09 17:18:15', '张骞', 1, 'add', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (65, 63, NULL, 20022, '课程组管理修改', 2, 1, 'page', 'page', '', '2022-06-09 17:18:46', '2022-06-09 17:18:46', '张骞', 1, 'update', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (66, 63, NULL, 20023, '课程组管理删除', 2, 1, 'pages', 'pages', '', '2022-06-09 17:19:11', '2022-06-09 17:19:11', '张骞', 1, 'del', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (67, 63, NULL, 20024, '课程组管理授权', 2, 1, 'pages', 'pages', '', '2022-06-09 17:19:35', '2022-06-09 17:19:35', '张骞', 1, 'author', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (68, 30, NULL, 20030, '登录日志', 1, 1, 'pages/school/logger/list.html', 'school/userlog/page', '', '2022-06-09 17:21:20', '2022-06-14 11:25:58', '张骞', 3, 'el-icon-notebook-2', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (69, 30, NULL, 20040, '在线状态', 1, 1, 'pages/school/online/list.html', 'pages/school/online/page', '', '2022-06-09 17:22:22', '2022-06-09 17:22:22', '张骞', 1, 'el-icon-link', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (70, 56, NULL, 30011, '课程管理新增按钮', 2, 1, 'pages', 'pages', '', '2022-06-10 10:37:09', '2022-06-10 10:37:09', '张骞', 1, 'add', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (71, 56, NULL, 30012, '课程管理修改按钮', 2, 1, 'pages', 'pages', '', '2022-06-10 10:37:34', '2022-06-10 10:37:34', '张骞', 1, 'update', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (72, 56, NULL, 30013, '课程管理删除按钮', 2, 1, 'pages', 'pages', '', '2022-06-10 10:37:57', '2022-06-10 10:37:57', '张骞', 1, 'del', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (73, 54, NULL, 30020, '级别管理', 1, 1, 'pages/course/level/list.html', '/course/level/page', '', '2022-06-10 14:51:33', '2022-06-10 14:55:03', '张骞', 2, 'el-icon-document-copy', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (74, 73, NULL, 30021, '级别管理新增按钮', 2, 1, 'pages', 'course/level/save', '', '2022-06-10 14:55:37', '2022-06-10 14:55:37', '张骞', 1, 'add', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (75, 73, NULL, 30022, '级别管理修改按钮', 2, 1, 'pages', 'course/level/update', '', '2022-06-10 14:56:07', '2022-06-10 14:56:07', '张骞', 1, 'update', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (76, 73, NULL, 30023, '级别管理删除按钮', 2, 1, 'pages', 'course/level/delete', '', '2022-06-10 14:56:40', '2022-06-10 14:56:40', '张骞', 1, 'del', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (77, 73, NULL, 30024, '级别管理教案按钮', 2, 1, 'pages', 'pages', '', '2022-06-10 14:57:09', '2022-06-10 14:57:09', '张骞', 1, 'pdf', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (78, 73, NULL, 30025, '级别管理课件按钮', 2, 1, 'pages', 'pages', '', '2022-06-10 14:57:29', '2022-06-10 14:57:29', '张骞', 1, 'ppt', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (79, 54, NULL, 30030, '培训视频', 1, 1, 'pages/course/video/list.html', '/course/vedio/list', '', '2022-06-10 16:07:25', '2022-06-10 16:33:12', '张骞', 2, 'el-icon-film', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (80, 79, NULL, 30031, '培训视频新增按钮', 2, 1, 'pages', 'pages', '', '2022-06-10 16:08:02', '2022-06-10 16:08:02', '张骞', 1, 'add', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (81, 79, NULL, 30032, '培训视频修改按钮', 2, 1, 'pages', 'pages', '', '2022-06-10 16:08:23', '2022-06-10 16:08:23', '张骞', 1, 'update', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (82, 79, NULL, 30033, '培训视频删除按钮', 2, 1, 'pages', 'pages', '', '2022-06-10 16:08:44', '2022-06-10 16:08:44', '张骞', 1, 'del', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (83, 57, NULL, 40011, '平台线索清单领取按钮', 2, 1, 'pages', 'pages', '', '2022-06-10 18:28:00', '2022-06-10 18:28:00', '张骞', 1, 'receive', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (84, 68, NULL, 20031, '登录日志删除按钮', 2, 1, 'campus/userlog/delete', 'school/userlog/delete', '', '2022-06-14 11:24:16', '2022-06-14 11:25:49', '张骞', 2, 'del', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (85, 30, NULL, 20050, '教案笔记', 1, 1, 'pages/school/note/list.html', 'school/pdfNote/page', '', '2022-06-15 16:30:48', '2022-06-16 12:17:11', '张骞', 3, 'el-icon-edit', NULL, NULL, 0);
INSERT INTO `tb_module` VALUES (86, 85, NULL, 20051, '教案笔记删除按钮', 2, 1, 'school/note/delete', 'school/pdfNote/delete', '', '2022-06-15 16:31:37', '2022-06-16 12:20:20', '张骞', 2, 'del', NULL, NULL, 0);

-- ----------------------------
-- Table structure for tb_module_copy1
-- ----------------------------
DROP TABLE IF EXISTS `tb_module_copy1`;
CREATE TABLE `tb_module_copy1`  (
  `module_id` bigint(40) NOT NULL AUTO_INCREMENT COMMENT '模块id',
  `parent_id` bigint(40) NULL DEFAULT NULL COMMENT '自关联父模块id',
  `parent_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '自关联父模块名称',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模块名称',
  `ctype` decimal(11, 0) NULL DEFAULT NULL COMMENT '0 主菜单/1 左侧菜单/2按钮/3 链接/4 状态',
  `state` decimal(11, 0) NULL DEFAULT NULL COMMENT '1启用0停用',
  `curl` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模块地址',
  `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `created` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `operator` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '记录最后一次编辑人',
  `version` int(255) NULL DEFAULT 1 COMMENT 'mybatisplus乐观锁版本号',
  PRIMARY KEY (`module_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 40 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of tb_module_copy1
-- ----------------------------
INSERT INTO `tb_module_copy1` VALUES (8, NULL, NULL, '平台系统管理', 0, 1, 'system', '', '2022-03-07 18:33:45', '2022-03-07 18:33:45', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (9, 8, NULL, '部门管理', 1, 1, 'system/dept/list', '', '2022-03-07 18:34:28', '2022-03-08 10:27:32', '张骞', 3);
INSERT INTO `tb_module_copy1` VALUES (10, 9, NULL, '部门新增按钮', 2, 1, 'system/dept/Add', '', '2022-03-07 18:35:00', '2022-03-07 18:35:00', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (11, 9, NULL, '部门删除按钮', 2, 1, 'system/dept/delete', '', '2022-03-07 18:35:38', '2022-03-07 18:35:38', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (12, 9, NULL, '部门修改按钮', 2, 1, 'system/dept/toEdit', '', '2022-03-07 18:36:34', '2022-03-07 18:36:34', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (13, 8, NULL, '模块管理', 1, 1, 'system/module/list', '', '2022-03-07 18:37:05', '2022-03-07 18:37:05', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (14, 13, NULL, '模块新增按钮', 2, 1, 'system/module/toAdd', '', '2022-03-07 18:37:46', '2022-03-07 18:37:46', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (15, 13, NULL, '模块修改按钮', 2, 1, 'system/module/toEdit', '', '2022-03-07 18:38:03', '2022-03-07 18:38:03', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (16, 13, NULL, '模块删除按钮', 2, 1, 'system/module/delete', '', '2022-03-07 18:38:19', '2022-03-07 18:38:19', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (17, 8, NULL, '角色管理', 1, 1, 'system/role/list', '', '2022-03-07 18:38:48', '2022-03-08 10:27:17', '张骞', 4);
INSERT INTO `tb_module_copy1` VALUES (18, 17, NULL, '角色新增按钮', 2, 1, 'system/role/toAdd', '', '2022-03-07 18:39:43', '2022-03-07 18:39:43', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (19, 17, NULL, '角色修改按钮', 2, 1, 'system/role/toEdit', '', '2022-03-07 18:40:01', '2022-03-07 18:40:01', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (20, 17, NULL, '角色删除按钮', 2, 1, 'system/role/delete', '', '2022-03-07 18:40:16', '2022-03-07 18:40:16', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (21, 8, NULL, '用户管理', 1, 1, 'system/user/list', '', '2022-03-07 18:40:58', '2022-03-07 18:40:58', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (22, 21, NULL, '用户新增按钮', 2, 1, 'system/user/toAdd', '', '2022-03-07 18:41:33', '2022-03-07 18:41:33', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (23, 21, NULL, '用户修改按钮', 2, 1, 'system/user/toEdit', '', '2022-03-07 18:41:49', '2022-03-07 18:41:49', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (24, 21, NULL, '用户删除按钮', 2, 1, 'system/user/delete', '', '2022-03-07 18:42:16', '2022-03-07 18:42:16', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (25, 8, NULL, '参数设置', 1, 1, 'system/setting/list', '', '2022-03-07 18:42:42', '2022-03-07 18:42:42', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (26, 25, NULL, '参数新增按钮', 2, 1, 'system/setting/toAdd', '', '2022-03-07 18:43:05', '2022-03-07 18:43:05', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (27, 25, NULL, '参数修改按钮', 2, 1, 'system/setting/toEdit', '', '2022-03-07 18:43:25', '2022-03-07 18:43:25', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (28, 25, NULL, '参数删除按钮', 2, 1, 'system/setting/delete', '', '2022-03-07 18:43:39', '2022-03-07 18:43:39', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (29, 8, NULL, '系统日志管理', 1, 1, 'system/logger/list', '', '2022-03-07 18:45:22', '2022-03-07 22:52:30', '张骞', 2);
INSERT INTO `tb_module_copy1` VALUES (30, NULL, NULL, '校区会员管理', 0, 1, 'school', '', '2022-03-07 23:43:29', '2022-03-07 23:43:29', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (31, 30, NULL, '加盟校管理', 1, 1, 'school/campus/list', '', '2022-03-07 23:44:12', '2022-03-08 14:07:45', '张骞', 2);
INSERT INTO `tb_module_copy1` VALUES (32, 17, NULL, '角色授权按钮', 2, 1, 'system/role/author', '', '2022-03-08 10:14:17', '2022-03-08 10:14:17', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (33, 9, NULL, '部门列表', 2, 1, 'system/dept/list', '', '2022-03-08 10:23:12', '2022-03-08 10:23:12', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (34, 17, NULL, '角色列表', 2, 1, 'system/role/list', '', '2022-03-08 10:24:02', '2022-03-08 10:24:02', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (35, 21, NULL, '用户角色按钮', 2, 1, 'system/user/userRoleList', '', '2022-03-08 10:28:45', '2022-03-08 10:28:45', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (36, 21, NULL, '用户角色保存按钮', 2, 1, 'system/user/updateRole', '', '2022-03-08 10:29:33', '2022-03-08 10:29:33', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (37, 31, NULL, '加盟校数据列表', 2, 1, 'school/campus/list', '', '2022-03-08 14:08:07', '2022-03-08 14:08:07', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (38, 31, NULL, '加盟校新增按钮', 2, 1, 'school/campus/toAdd', '', '2022-03-08 14:08:34', '2022-03-08 14:08:34', '张骞', 1);
INSERT INTO `tb_module_copy1` VALUES (39, 31, NULL, '加盟校修改按钮', 2, 1, 'school/campus/toEdit', '', '2022-03-08 14:08:54', '2022-03-08 14:08:54', '张骞', 1);

-- ----------------------------
-- Table structure for tb_role
-- ----------------------------
DROP TABLE IF EXISTS `tb_role`;
CREATE TABLE `tb_role`  (
  `role_id` bigint(40) NOT NULL AUTO_INCREMENT COMMENT '角色id',
  `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称',
  `remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色描述/备注',
  `created` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `operator` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '记录最后一次编辑人',
  `version` int(255) NULL DEFAULT 1 COMMENT 'mybatisplus乐观锁版本号',
  `operator_id` bigint(20) NULL DEFAULT NULL COMMENT '最后一次更新数据用户Id',
  `operator_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最后一次更新数据用户名',
  `deleted` int(1) NULL DEFAULT 0 COMMENT '逻辑删除标记',
  PRIMARY KEY (`role_id`) USING BTREE,
  UNIQUE INDEX `Idx_id`(`role_id`) USING BTREE COMMENT '主键索引，唯一索引',
  INDEX `Idx_name`(`name`) USING BTREE COMMENT '名称索引，普通索引',
  INDEX `Idx_updated`(`updated`) USING BTREE COMMENT '更新时间索引，普通索引',
  INDEX `ROLE_ADMIN_ID`(`operator_id`) USING BTREE,
  INDEX `ROLE_ADMIN_NAME`(`operator_name`) USING BTREE,
  CONSTRAINT `ROLE_ADMIN_ID` FOREIGN KEY (`operator_id`) REFERENCES `tb_admin` (`admin_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `ROLE_ADMIN_NAME` FOREIGN KEY (`operator_name`) REFERENCES `tb_admin` (`name`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of tb_role
-- ----------------------------
INSERT INTO `tb_role` VALUES (3, '超级管理员', '拥有全部权限', '2022-03-07 19:26:52', '2022-03-08 10:14:43', '张骞', 2, NULL, NULL, 0);
INSERT INTO `tb_role` VALUES (4, '内容管理员', '全部课程维护的权限', '2022-03-07 19:27:12', '2022-03-08 10:10:48', '张骞', 2, NULL, NULL, 0);

-- ----------------------------
-- Table structure for tb_role_admin
-- ----------------------------
DROP TABLE IF EXISTS `tb_role_admin`;
CREATE TABLE `tb_role_admin`  (
  `admin_id` bigint(40) NOT NULL COMMENT '用户id',
  `role_id` bigint(40) NOT NULL COMMENT '角色id',
  PRIMARY KEY (`role_id`, `admin_id`) USING BTREE,
  INDEX `Idx_adminId`(`admin_id`) USING BTREE COMMENT '管理员用户id索引，普通索引',
  INDEX `Idx_roleId`(`role_id`) USING BTREE COMMENT '角色id索引，普通索引',
  CONSTRAINT `FK_Reference_10` FOREIGN KEY (`admin_id`) REFERENCES `tb_admin` (`admin_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `FK_Reference_11` FOREIGN KEY (`role_id`) REFERENCES `tb_role` (`role_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of tb_role_admin
-- ----------------------------
INSERT INTO `tb_role_admin` VALUES (1, 3);

-- ----------------------------
-- Table structure for tb_role_module
-- ----------------------------
DROP TABLE IF EXISTS `tb_role_module`;
CREATE TABLE `tb_role_module`  (
  `role_id` bigint(40) NOT NULL COMMENT '角色id',
  `module_id` bigint(40) NOT NULL COMMENT '模块id',
  PRIMARY KEY (`role_id`, `module_id`) USING BTREE,
  INDEX `Idx_moduleId`(`module_id`) USING BTREE COMMENT '模块id索引，普通索引',
  INDEX `Idx_roleId`(`role_id`) USING BTREE COMMENT '角色id索引，普通索引',
  CONSTRAINT `FK_Reference_5` FOREIGN KEY (`role_id`) REFERENCES `tb_role` (`role_id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `FK_Reference_6` FOREIGN KEY (`module_id`) REFERENCES `tb_module` (`module_id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of tb_role_module
-- ----------------------------
INSERT INTO `tb_role_module` VALUES (3, 8);
INSERT INTO `tb_role_module` VALUES (15, 8);
INSERT INTO `tb_role_module` VALUES (3, 9);
INSERT INTO `tb_role_module` VALUES (15, 9);
INSERT INTO `tb_role_module` VALUES (3, 10);
INSERT INTO `tb_role_module` VALUES (15, 10);
INSERT INTO `tb_role_module` VALUES (3, 11);
INSERT INTO `tb_role_module` VALUES (3, 12);
INSERT INTO `tb_role_module` VALUES (3, 13);
INSERT INTO `tb_role_module` VALUES (3, 14);
INSERT INTO `tb_role_module` VALUES (3, 15);
INSERT INTO `tb_role_module` VALUES (3, 16);
INSERT INTO `tb_role_module` VALUES (3, 17);
INSERT INTO `tb_role_module` VALUES (3, 18);
INSERT INTO `tb_role_module` VALUES (3, 19);
INSERT INTO `tb_role_module` VALUES (3, 20);
INSERT INTO `tb_role_module` VALUES (3, 21);
INSERT INTO `tb_role_module` VALUES (3, 22);
INSERT INTO `tb_role_module` VALUES (3, 23);
INSERT INTO `tb_role_module` VALUES (3, 24);
INSERT INTO `tb_role_module` VALUES (3, 25);
INSERT INTO `tb_role_module` VALUES (3, 26);
INSERT INTO `tb_role_module` VALUES (3, 27);
INSERT INTO `tb_role_module` VALUES (3, 28);
INSERT INTO `tb_role_module` VALUES (3, 29);
INSERT INTO `tb_role_module` VALUES (3, 30);
INSERT INTO `tb_role_module` VALUES (3, 31);
INSERT INTO `tb_role_module` VALUES (3, 32);
INSERT INTO `tb_role_module` VALUES (3, 35);
INSERT INTO `tb_role_module` VALUES (3, 36);
INSERT INTO `tb_role_module` VALUES (3, 38);
INSERT INTO `tb_role_module` VALUES (3, 39);
INSERT INTO `tb_role_module` VALUES (3, 45);
INSERT INTO `tb_role_module` VALUES (3, 46);
INSERT INTO `tb_role_module` VALUES (3, 47);
INSERT INTO `tb_role_module` VALUES (3, 48);
INSERT INTO `tb_role_module` VALUES (3, 49);
INSERT INTO `tb_role_module` VALUES (3, 50);
INSERT INTO `tb_role_module` VALUES (3, 54);
INSERT INTO `tb_role_module` VALUES (3, 55);
INSERT INTO `tb_role_module` VALUES (3, 56);
INSERT INTO `tb_role_module` VALUES (3, 57);
INSERT INTO `tb_role_module` VALUES (3, 58);
INSERT INTO `tb_role_module` VALUES (3, 59);
INSERT INTO `tb_role_module` VALUES (3, 60);
INSERT INTO `tb_role_module` VALUES (3, 63);
INSERT INTO `tb_role_module` VALUES (3, 64);
INSERT INTO `tb_role_module` VALUES (3, 65);
INSERT INTO `tb_role_module` VALUES (3, 66);
INSERT INTO `tb_role_module` VALUES (3, 67);
INSERT INTO `tb_role_module` VALUES (3, 68);
INSERT INTO `tb_role_module` VALUES (3, 69);
INSERT INTO `tb_role_module` VALUES (3, 70);
INSERT INTO `tb_role_module` VALUES (3, 71);
INSERT INTO `tb_role_module` VALUES (3, 72);
INSERT INTO `tb_role_module` VALUES (3, 73);
INSERT INTO `tb_role_module` VALUES (3, 74);
INSERT INTO `tb_role_module` VALUES (3, 75);
INSERT INTO `tb_role_module` VALUES (3, 76);
INSERT INTO `tb_role_module` VALUES (3, 77);
INSERT INTO `tb_role_module` VALUES (3, 78);
INSERT INTO `tb_role_module` VALUES (3, 79);
INSERT INTO `tb_role_module` VALUES (3, 80);
INSERT INTO `tb_role_module` VALUES (3, 81);
INSERT INTO `tb_role_module` VALUES (3, 82);
INSERT INTO `tb_role_module` VALUES (3, 83);
INSERT INTO `tb_role_module` VALUES (3, 85);
INSERT INTO `tb_role_module` VALUES (3, 86);

-- ----------------------------
-- Table structure for tb_setting
-- ----------------------------
DROP TABLE IF EXISTS `tb_setting`;
CREATE TABLE `tb_setting`  (
  `id` bigint(64) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `sort` int(255) NULL DEFAULT NULL COMMENT '序号',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设置项名称',
  `param` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设置具体内容',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设置具体',
  `created` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `operator` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最后一次编辑人',
  `version` int(255) NULL DEFAULT 1 COMMENT '乐观锁版本号',
  `operator_id` bigint(20) NULL DEFAULT NULL COMMENT '最后一次更新数据用户Id',
  `operator_name` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最后一次更新数据用户名',
  `deleted` int(1) NULL DEFAULT 0 COMMENT '逻辑删除标记',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `Idx_name`(`name`) USING BTREE COMMENT '设置名称索引，普通索引',
  INDEX `Idx_sort`(`sort`) USING BTREE COMMENT '排序索引，普通索引',
  INDEX `SET_ADMIN_ID`(`operator_id`) USING BTREE,
  INDEX `SET_ADMIN_NAME`(`operator_name`) USING BTREE,
  CONSTRAINT `SET_ADMIN_ID` FOREIGN KEY (`operator_id`) REFERENCES `tb_admin` (`admin_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `SET_ADMIN_NAME` FOREIGN KEY (`operator_name`) REFERENCES `tb_admin` (`name`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of tb_setting
-- ----------------------------
INSERT INTO `tb_setting` VALUES (1, 1, 'test', 'test', '测试数据', '2022-03-08 11:30:08', '2022-04-09 23:50:07', '张骞', 3, NULL, NULL, 0);
INSERT INTO `tb_setting` VALUES (5, 2, 'test02', 'E:\\\\001', '测试数据', '2022-03-08 11:49:21', '2022-03-08 11:49:21', '张骞', 1, NULL, NULL, 0);


SET FOREIGN_KEY_CHECKS = 1;