/* Navicat Premium Data Transfer Source Server : 本机MySQL Source Server Type : MySQL Source Server Version : 50729 Source Host : localhost:3306 Source Schema : yb Target Server Type : MySQL Target Server Version : 50729 File Encoding : 65001 Date: 20/08/2021 22:53:16 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for gen_table -- ---------------------------- DROP TABLE IF EXISTS `gen_table`; CREATE TABLE `gen_table` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '编号', `table_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '表名称', `table_comment` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '表描述', `sub_table_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联子表的表名', `sub_table_fk_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '子表关联的外键名', `class_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '实体类名称', `tpl_category` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'crud' COMMENT '使用的模板（crud单表操作 tree树表操作 sub主子表操作）', `package_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生成包路径', `module_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生成模块名', `business_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生成业务名', `function_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生成功能名', `function_author` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生成功能作者', `gen_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '生成代码方式（0zip压缩包 1自定义路径）', `gen_path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '/' COMMENT '生成路径（不填默认项目路径）', `options` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '其它生成选项', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代码生成业务表' ROW_FORMAT = Dynamic; -- ---------------------------- -- ---------------------------- -- Table structure for gen_table_column -- ---------------------------- DROP TABLE IF EXISTS `gen_table_column`; CREATE TABLE `gen_table_column` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '编号', `table_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '归属表编号', `column_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '列名称', `column_comment` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '列描述', `column_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '列类型', `java_type` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'JAVA类型', `java_field` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'JAVA字段名', `is_pk` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否主键（1是）', `is_increment` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否自增（1是）', `is_required` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否必填（1是）', `is_insert` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否为插入字段（1是）', `is_edit` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否编辑字段（1是）', `is_list` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否列表字段（1是）', `is_query` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否查询字段（1是）', `query_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'EQ' COMMENT '查询方式（等于、不等于、大于、小于、范围）', `html_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）', `dict_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '字典类型', `sort` int(11) NULL DEFAULT NULL COMMENT '排序', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代码生成业务表字段' ROW_FORMAT = Dynamic; -- ---------------------------- -- ---------------------------- -- Table structure for platform_dept -- ---------------------------- DROP TABLE IF EXISTS `platform_dept`; CREATE TABLE `platform_dept` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门id', `parent_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '父部门id', `ancestors` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '祖级列表', `dept_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '部门名称', `dept_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门类型', `order_num` int(4) NULL DEFAULT 0 COMMENT '显示顺序', `leader` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '负责人', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系电话', `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱', `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '部门状态（0正常 1停用）', `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '部门表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of platform_dept -- ---------------------------- INSERT INTO `platform_dept` VALUES ('89678424698023676', '0', '0', '圣钰平台科技', 'yb', 0, '圣钰', '15888888888', 'yb@qq.com', '0', '0', 'admin', '2021-05-26 15:36:20', '', NULL); -- ---------------------------- -- Table structure for platform_logininfor -- ---------------------------- DROP TABLE IF EXISTS `platform_logininfor`; CREATE TABLE `platform_logininfor` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '访问ID', `login_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录账号', `ipaddr` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录IP地址', `login_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录地点', `browser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '浏览器类型', `os` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作系统', `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '登录状态（0成功 1失败）', `msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '提示消息', `login_time` datetime(0) NULL DEFAULT NULL COMMENT '访问时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统访问记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of platform_logininfor -- ---------------------------- -- ---------------------------- -- Table structure for platform_menu -- ---------------------------- DROP TABLE IF EXISTS `platform_menu`; CREATE TABLE `platform_menu` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单ID', `menu_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单名称', `parent_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '父菜单ID', `order_num` int(4) NULL DEFAULT 0 COMMENT '显示顺序', `url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '#' COMMENT '请求地址', `target` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '打开方式（menuItem页签 menuBlank新窗口）', `menu_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）', `visible` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）', `is_refresh` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '1' COMMENT '是否刷新（0刷新 1不刷新）', `perms` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限标识', `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '#' COMMENT '菜单图标', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '菜单权限表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of platform_menu -- ---------------------------- INSERT INTO `platform_menu` VALUES ('1', '系统管理', '0', 1, '#', '', 'M', '0', '1', '', 'fa fa-gear', 'admin', '2021-05-26 15:36:20', '', NULL, '系统管理目录'); INSERT INTO `platform_menu` VALUES ('100', '用户管理', '1', 1, '/platform/user', '', 'C', '0', '1', 'platform:user:view', 'fa fa-user-o', 'admin', '2021-05-26 15:36:20', '', NULL, '用户管理菜单'); INSERT INTO `platform_menu` VALUES ('1000', '用户查询', '100', 1, '#', '', 'F', '0', '1', 'platform:user:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1001', '用户新增', '100', 2, '#', '', 'F', '0', '1', 'platform:user:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1002', '用户修改', '100', 3, '#', '', 'F', '0', '1', 'platform:user:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1003', '用户删除', '100', 4, '#', '', 'F', '0', '1', 'platform:user:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1004', '用户导出', '100', 5, '#', '', 'F', '0', '1', 'platform:user:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1005', '用户导入', '100', 6, '#', '', 'F', '0', '1', 'platform:user:import', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1006', '重置密码', '100', 7, '#', '', 'F', '0', '1', 'platform:user:resetPwd', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1007', '角色查询', '101', 1, '#', '', 'F', '0', '1', 'platform:role:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1008', '角色新增', '101', 2, '#', '', 'F', '0', '1', 'platform:role:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1009', '角色修改', '101', 3, '#', '', 'F', '0', '1', 'platform:role:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('101', '角色管理', '1', 2, '/platform/role', '', 'C', '0', '1', 'platform:role:view', 'fa fa-user-secret', 'admin', '2021-05-26 15:36:20', '', NULL, '角色管理菜单'); INSERT INTO `platform_menu` VALUES ('1010', '角色删除', '101', 4, '#', '', 'F', '0', '1', 'platform:role:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1011', '角色导出', '101', 5, '#', '', 'F', '0', '1', 'platform:role:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1012', '菜单查询', '102', 1, '#', '', 'F', '0', '1', 'platform:saasMenu:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1013', '菜单新增', '102', 2, '#', '', 'F', '0', '1', 'platform:saasMenu:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1014', '菜单修改', '102', 3, '#', '', 'F', '0', '1', 'platform:saasMenu:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1015', '菜单删除', '102', 4, '#', '', 'F', '0', '1', 'platform:saasMenu:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1016', '部门查询', '103', 1, '#', '', 'F', '0', '1', 'platform:dept:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1017', '部门新增', '103', 2, '#', '', 'F', '0', '1', 'platform:dept:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1018', '部门修改', '103', 3, '#', '', 'F', '0', '1', 'platform:dept:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1019', '部门删除', '103', 4, '#', '', 'F', '0', '1', 'platform:dept:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('102', '租户菜单', '1422767818551267329', 3, '/platform/saasMenu', 'menuItem', 'C', '0', '1', 'platform:saasMenu:view', 'fa fa-th-list', 'admin', '2021-05-26 15:36:20', 'admin', '2021-08-04 11:55:11', '菜单管理菜单'); INSERT INTO `platform_menu` VALUES ('1020', '岗位查询', '104', 1, '#', '', 'F', '0', '1', 'platform:post:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1021', '岗位新增', '104', 2, '#', '', 'F', '0', '1', 'platform:post:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1022', '岗位修改', '104', 3, '#', '', 'F', '0', '1', 'platform:post:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1023', '岗位删除', '104', 4, '#', '', 'F', '0', '1', 'platform:post:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1024', '岗位导出', '104', 5, '#', '', 'F', '0', '1', 'platform:post:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1025', '字典查询', '105', 1, '#', '', 'F', '0', '1', 'platform:dict:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1026', '字典新增', '105', 2, '#', '', 'F', '0', '1', 'platform:dict:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1027', '字典修改', '105', 3, '#', '', 'F', '0', '1', 'platform:dict:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1028', '字典删除', '105', 4, '#', '', 'F', '0', '1', 'platform:dict:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1029', '字典导出', '105', 5, '#', '', 'F', '0', '1', 'platform:dict:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('103', '部门管理', '1', 4, '/platform/dept', '', 'C', '0', '1', 'platform:dept:view', 'fa fa-outdent', 'admin', '2021-05-26 15:36:20', '', NULL, '部门管理菜单'); INSERT INTO `platform_menu` VALUES ('1030', '参数查询', '106', 1, '#', '', 'F', '0', '1', 'platform:config:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1031', '参数新增', '106', 2, '#', '', 'F', '0', '1', 'platform:config:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1032', '参数修改', '106', 3, '#', '', 'F', '0', '1', 'platform:config:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1033', '参数删除', '106', 4, '#', '', 'F', '0', '1', 'platform:config:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1034', '参数导出', '106', 5, '#', '', 'F', '0', '1', 'platform:config:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1035', '公告查询', '107', 1, '#', '', 'F', '0', '1', 'platform:notice:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1036', '公告新增', '107', 2, '#', '', 'F', '0', '1', 'platform:notice:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1037', '公告修改', '107', 3, '#', '', 'F', '0', '1', 'platform:notice:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1038', '公告删除', '107', 4, '#', '', 'F', '0', '1', 'platform:notice:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1039', '操作查询', '500', 1, '#', '', 'F', '0', '1', 'platform:monitor:operlog:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('104', '岗位管理', '1', 5, '/platform/post', '', 'C', '0', '1', 'platform:post:view', 'fa fa-address-card-o', 'admin', '2021-05-26 15:36:20', '', NULL, '岗位管理菜单'); INSERT INTO `platform_menu` VALUES ('1040', '操作删除', '500', 2, '#', '', 'F', '0', '1', 'platform:monitor:operlog:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1041', '详细信息', '500', 3, '#', '', 'F', '0', '1', 'platform:monitor:operlog:detail', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1042', '日志导出', '500', 4, '#', '', 'F', '0', '1', 'platform:monitor:operlog:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1043', '登录查询', '501', 1, '#', '', 'F', '0', '1', 'platform:monitor:logininfor:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1044', '登录删除', '501', 2, '#', '', 'F', '0', '1', 'platform:monitor:logininfor:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1045', '日志导出', '501', 3, '#', '', 'F', '0', '1', 'platform:monitor:logininfor:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1046', '账户解锁', '501', 4, '#', '', 'F', '0', '1', 'platform:monitor:logininfor:unlock', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1047', '在线查询', '109', 1, '#', '', 'F', '0', '1', 'platform:monitor:online:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1048', '批量强退', '109', 2, '#', '', 'F', '0', '1', 'platform:monitor:online:batchForceLogout', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1049', '单条强退', '109', 3, '#', '', 'F', '0', '1', 'platform:monitor:online:forceLogout', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('105', '字典管理', '1', 6, '/platform/dict', '', 'C', '0', '1', 'platform:dict:view', 'fa fa-bookmark-o', 'admin', '2021-05-26 15:36:20', '', NULL, '字典管理菜单'); INSERT INTO `platform_menu` VALUES ('1050', '任务查询', '110', 1, '#', '', 'F', '0', '1', 'platform:monitor:job:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1051', '任务新增', '110', 2, '#', '', 'F', '0', '1', 'platform:monitor:job:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1052', '任务修改', '110', 3, '#', '', 'F', '0', '1', 'platform:monitor:job:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1053', '任务删除', '110', 4, '#', '', 'F', '0', '1', 'platform:monitor:job:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1054', '状态修改', '110', 5, '#', '', 'F', '0', '1', 'platform:monitor:job:changeStatus', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1055', '任务详细', '110', 6, '#', '', 'F', '0', '1', 'platform:monitor:job:detail', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1056', '任务导出', '110', 7, '#', '', 'F', '0', '1', 'platform:monitor:job:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1057', '生成查询', '115', 1, '#', '', 'F', '0', '1', 'tool:gen:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1058', '生成修改', '115', 2, '#', '', 'F', '0', '1', 'tool:gen:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1059', '生成删除', '115', 3, '#', '', 'F', '0', '1', 'tool:gen:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('106', '参数设置', '1', 7, '/platform/config', '', 'C', '0', '1', 'platform:config:view', 'fa fa-sun-o', 'admin', '2021-05-26 15:36:20', '', NULL, '参数设置菜单'); INSERT INTO `platform_menu` VALUES ('1060', '预览代码', '115', 4, '#', '', 'F', '0', '1', 'tool:gen:preview', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('1061', '生成代码', '115', 5, '#', '', 'F', '0', '1', 'tool:gen:code', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('107', '通知公告', '1', 8, '/platform/notice', '', 'C', '0', '1', 'platform:notice:view', 'fa fa-bullhorn', 'admin', '2021-05-26 15:36:20', '', NULL, '通知公告菜单'); INSERT INTO `platform_menu` VALUES ('108', '日志管理', '1', 9, '#', '', 'M', '0', '1', '', 'fa fa-pencil-square-o', 'admin', '2021-05-26 15:36:20', '', NULL, '日志管理菜单'); INSERT INTO `platform_menu` VALUES ('109', '在线用户', '2', 1, '/platform/monitor/online', '', 'C', '0', '1', 'platform:monitor:online:view', 'fa fa-user-circle', 'admin', '2021-05-26 15:36:20', '', NULL, '在线用户菜单'); INSERT INTO `platform_menu` VALUES ('110', '定时任务', '2', 2, '/platform/monitor/job', '', 'C', '0', '1', 'platform:monitor:job:view', 'fa fa-tasks', 'admin', '2021-05-26 15:36:20', '', NULL, '定时任务菜单'); INSERT INTO `platform_menu` VALUES ('111', '数据监控', '2', 3, '/platform/monitor/data', '', 'C', '0', '1', 'platform:monitor:data:view', 'fa fa-bug', 'admin', '2021-05-26 15:36:20', '', NULL, '数据监控菜单'); INSERT INTO `platform_menu` VALUES ('112', '服务监控', '2', 4, '/platform/monitor/server', '', 'C', '0', '1', 'platform:monitor:server:view', 'fa fa-server', 'admin', '2021-05-26 15:36:20', '', NULL, '服务监控菜单'); INSERT INTO `platform_menu` VALUES ('113', '缓存监控', '2', 5, '/platform/monitor/cache', '', 'C', '0', '1', 'platform:monitor:cache:view', 'fa fa-cube', 'admin', '2021-05-26 15:36:20', '', NULL, '缓存监控菜单'); INSERT INTO `platform_menu` VALUES ('114', '表单构建', '3', 1, '/tool/build', '', 'C', '0', '1', 'tool:build:view', 'fa fa-wpforms', 'admin', '2021-05-26 15:36:20', '', NULL, '表单构建菜单'); INSERT INTO `platform_menu` VALUES ('115', '代码生成', '3', 2, '/tool/gen1', '', 'C', '0', '1', 'tool:gen:view', 'fa fa-code', 'admin', '2021-05-26 15:36:20', '', NULL, '代码生成菜单'); INSERT INTO `platform_menu` VALUES ('116', '系统接口', '3', 3, '/tool/swagger', 'menuItem', 'C', '0', '1', 'tool:swagger:view', 'fa fa-gg', 'admin', '2021-05-26 15:36:20', 'admin', '2021-08-16 14:10:44', '系统接口菜单'); INSERT INTO `platform_menu` VALUES ('1422767818551267329', '租户管理', '0', 2, '', 'menuItem', 'M', '0', '1', '', 'fa fa-bank', 'admin', '2021-08-04 11:54:16', 'admin', '2021-08-04 11:54:16', ''); INSERT INTO `platform_menu` VALUES ('1423511840943562753', '租户角色', '1422767818551267329', 2, '/platform/saasRole', 'menuItem', 'C', '0', '1', 'platform:saasRole:view', 'fa fa-user-secret', 'admin', '2021-08-06 13:10:45', 'admin', '2021-08-06 13:10:45', ''); INSERT INTO `platform_menu` VALUES ('1423512072255234049', '查询', '1423511840943562753', 1, '', 'menuItem', 'F', '0', '1', 'platform:saasRole:list', '', 'admin', '2021-08-06 13:11:40', 'admin', '2021-08-06 13:11:40', ''); INSERT INTO `platform_menu` VALUES ('1423512193432870914', '新增', '1423511840943562753', 2, '', 'menuItem', 'F', '0', '1', 'platform:saasRole:add', '', 'admin', '2021-08-06 13:12:09', 'admin', '2021-08-06 13:12:09', ''); INSERT INTO `platform_menu` VALUES ('1423512294935027714', '修改', '1423511840943562753', 3, '', 'menuItem', 'F', '0', '1', 'platform:saasRole:edit', '', 'admin', '2021-08-06 13:12:33', 'admin', '2021-08-06 13:12:33', ''); INSERT INTO `platform_menu` VALUES ('1423512466557558785', '删除', '1423511840943562753', 4, '', 'menuItem', 'F', '0', '1', 'platform:saasRole:remove', '', 'admin', '2021-08-06 13:13:14', 'admin', '2021-08-06 13:13:14', ''); INSERT INTO `platform_menu` VALUES ('1423512555762016257', '导出', '1423511840943562753', 5, '', 'menuItem', 'F', '0', '1', 'platform:saasRole:export', '', 'admin', '2021-08-06 13:13:36', 'admin', '2021-08-06 13:13:36', ''); INSERT INTO `platform_menu` VALUES ('2', '系统监控', '0', 3, '#', 'menuItem', 'M', '0', '1', '', 'fa fa-video-camera', 'admin', '2021-05-26 15:36:20', 'admin', '2021-08-04 11:54:29', '系统监控目录'); INSERT INTO `platform_menu` VALUES ('2346345634563456', '租户列表', '1422767818551267329', 1, '/platform/tenant', 'menuItem', 'C', '0', '1', 'platform:tenant:view', '#', 'admin', '2021-07-03 17:35:54', 'admin', '2021-08-04 17:28:52', '租户列表菜单'); INSERT INTO `platform_menu` VALUES ('3', '系统工具', '0', 3, '#', '', 'M', '0', '1', '', 'fa fa-bars', 'admin', '2021-05-26 15:36:20', '', NULL, '系统工具目录'); INSERT INTO `platform_menu` VALUES ('4', '圣钰官网', '0', 4, 'https://gitee.com/jinzheyi/ruoyi-saas', 'menuBlank', 'C', '0', '1', '', 'fa fa-location-arrow', 'admin', '2021-05-26 15:36:20', '', NULL, '圣钰官网地址'); INSERT INTO `platform_menu` VALUES ('500', '操作日志', '108', 1, '/platform/monitor/operlog', '', 'C', '0', '1', 'platform:monitor:operlog:view', 'fa fa-address-book', 'admin', '2021-05-26 15:36:20', '', NULL, '操作日志菜单'); INSERT INTO `platform_menu` VALUES ('501', '登录日志', '108', 2, '/platform/monitor/logininfor', '', 'C', '0', '1', 'platform:monitor:logininfor:view', 'fa fa-file-image-o', 'admin', '2021-05-26 15:36:20', '', NULL, '登录日志菜单'); INSERT INTO `platform_menu` VALUES ('5674567456745673', '租户查询', '2346345634563456', 1, '#', '', 'F', '0', '1', 'platform:tenant:list', '#', 'admin', '2021-07-03 17:35:54', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('5675674534743564', '租户新增', '2346345634563456', 2, '#', '', 'F', '0', '1', 'platform:tenant:add', '#', 'admin', '2021-07-03 17:35:54', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('634564634567', '菜单管理', '1', 3, '/platform/menu', '', 'C', '0', '1', 'platform:saasMenu:view', 'fa fa-th-list', 'admin', '2021-05-26 15:36:20', '', NULL, '菜单管理菜单'); INSERT INTO `platform_menu` VALUES ('63456463456701', '菜单查询', '634564634567', 1, '#', '', 'F', '0', '1', 'platform:menu:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('63456463456702', '菜单新增', '634564634567', 2, '#', '', 'F', '0', '1', 'platform:menu:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('63456463456703', '菜单修改', '634564634567', 3, '#', '', 'F', '0', '1', 'platform:menu:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('63456463456704', '菜单删除', '634564634567', 4, '#', '', 'F', '0', '1', 'platform:menu:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('7890678967976856', '租户修改', '2346345634563456', 3, '#', '', 'F', '0', '1', 'platform:tenant:edit', '#', 'admin', '2021-07-03 17:35:54', '', NULL, ''); INSERT INTO `platform_menu` VALUES ('7967856734356235', '租户导出', '2346345634563456', 5, '#', '', 'F', '0', '1', 'platform:tenant:export', '#', 'admin', '2021-07-03 17:35:54', '', NULL, ''); -- ---------------------------- -- Table structure for platform_notice -- ---------------------------- DROP TABLE IF EXISTS `platform_notice`; CREATE TABLE `platform_notice` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公告ID', `notice_title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公告标题', `notice_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公告类型（1通知 2公告）', `notice_content` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公告内容', `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '公告状态（0正常 1关闭）', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '通知公告表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of platform_notice -- ---------------------------- -- ---------------------------- -- Table structure for platform_oper_log -- ---------------------------- DROP TABLE IF EXISTS `platform_oper_log`; CREATE TABLE `platform_oper_log` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '日志主键', `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '模块标题', `business_type` int(2) NULL DEFAULT 0 COMMENT '业务类型（0其它 1新增 2修改 3删除）', `method` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '方法名称', `request_method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '请求方式', `operator_type` int(1) NULL DEFAULT 0 COMMENT '操作类别（0其它 1后台用户 2手机端用户）', `oper_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作人员', `dept_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '部门名称', `oper_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '请求URL', `oper_ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '主机地址', `oper_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作地点', `oper_param` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '请求参数', `json_result` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '返回参数', `status` int(1) NULL DEFAULT 0 COMMENT '操作状态（0正常 1异常）', `error_msg` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '错误消息', `oper_time` datetime(0) NULL DEFAULT NULL COMMENT '操作时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '操作日志记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of platform_oper_log -- ---------------------------- -- ---------------------------- -- Table structure for platform_post -- ---------------------------- DROP TABLE IF EXISTS `platform_post`; CREATE TABLE `platform_post` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位ID', `post_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位编码', `post_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位名称', `post_sort` int(4) NOT NULL COMMENT '显示顺序', `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '状态（0正常 1停用）', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '岗位信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of platform_post -- ---------------------------- -- ---------------------------- -- Table structure for platform_role -- ---------------------------- DROP TABLE IF EXISTS `platform_role`; CREATE TABLE `platform_role` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色ID', `role_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色名称', `role_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色权限字符串', `role_sort` int(4) NOT NULL COMMENT '显示顺序', `data_scope` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）', `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色状态（0正常 1停用）', `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of platform_role -- ---------------------------- INSERT INTO `platform_role` VALUES ('674567345645676783889', '超级管理员', 'platform_admin', 1, '1', '0', '0', 'admin', '2021-05-26 15:36:20', '', NULL, '超级管理员'); -- ---------------------------- -- Table structure for platform_role_dept -- ---------------------------- DROP TABLE IF EXISTS `platform_role_dept`; CREATE TABLE `platform_role_dept` ( `role_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色ID', `dept_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门ID', PRIMARY KEY (`role_id`, `dept_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色和部门关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of platform_role_dept -- ---------------------------- -- ---------------------------- -- Table structure for platform_role_menu -- ---------------------------- DROP TABLE IF EXISTS `platform_role_menu`; CREATE TABLE `platform_role_menu` ( `role_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色ID', `menu_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单ID', PRIMARY KEY (`role_id`, `menu_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of platform_role_menu -- ---------------------------- -- ---------------------------- -- Table structure for platform_tenant -- ---------------------------- DROP TABLE IF EXISTS `platform_tenant`; CREATE TABLE `platform_tenant` ( `id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'id', `tenant_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '租户名称', `tenant_no` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '租户编号', `logo_url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户logo', `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '租户状态（0正常 1停用）', `remark` varchar(1500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', `start_date` datetime(0) NULL DEFAULT NULL COMMENT '租户系统开始时间', `end_date` datetime(0) NULL DEFAULT NULL COMMENT '租户系统到期时间', `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '租户表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of platform_tenant -- ---------------------------- INSERT INTO `platform_tenant` VALUES ('1411258341581467649', '一号租户', '0000000001', '', '0', '', '2021-08-04 00:00:00', '2050-03-07 00:00:00', 'admin', '2021-07-03 17:39:43', 'admin', '2021-08-12 20:25:33'); -- ---------------------------- -- Table structure for platform_user -- ---------------------------- DROP TABLE IF EXISTS `platform_user`; CREATE TABLE `platform_user` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID', `dept_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门ID', `login_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '登录账号', `user_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户昵称', `user_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '00' COMMENT '用户类型（00系统用户）', `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户邮箱', `phonenumber` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '手机号码', `sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）', `avatar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '头像路径', `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '密码', `salt` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '盐加密', `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '帐号状态（0正常 1停用）', `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `login_ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '最后登录IP', `login_date` datetime(0) NULL DEFAULT NULL COMMENT '最后登录时间', `pwd_update_date` datetime(0) NULL DEFAULT NULL COMMENT '密码最后更新时间', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of platform_user -- ---------------------------- INSERT INTO `platform_user` VALUES ('54634575686785679498', '89678424698023676', 'admin', '圣钰-平台管理员', 'yb', 'ruoyi@163.com', '15888888888', '1', '', '29c67a30398638269fe600f73a054934', '111111', '0', '0', '127.0.0.1', '2021-08-20 22:49:06', '2021-05-26 15:36:20', 'admin', '2021-05-26 15:36:20', 'ruoyi-system', '2021-08-20 22:49:06', '管理员'); -- ---------------------------- -- Table structure for platform_user_online -- ---------------------------- DROP TABLE IF EXISTS `platform_user_online`; CREATE TABLE `platform_user_online` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户会话id', `login_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录账号', `dept_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '部门名称', `ipaddr` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录IP地址', `login_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录地点', `browser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '浏览器类型', `os` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作系统', `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '在线状态on_line在线off_line离线', `start_timestamp` datetime(0) NULL DEFAULT NULL COMMENT 'session创建时间', `last_access_time` datetime(0) NULL DEFAULT NULL COMMENT 'session最后访问时间', `expire_time` int(5) NULL DEFAULT 0 COMMENT '超时时间，单位为分钟', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '在线用户记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of platform_user_online -- ---------------------------- -- ---------------------------- -- Table structure for platform_user_post -- ---------------------------- DROP TABLE IF EXISTS `platform_user_post`; CREATE TABLE `platform_user_post` ( `user_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID', `post_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位ID', PRIMARY KEY (`user_id`, `post_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户与岗位关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of platform_user_post -- ---------------------------- -- ---------------------------- -- Table structure for platform_user_role -- ---------------------------- DROP TABLE IF EXISTS `platform_user_role`; CREATE TABLE `platform_user_role` ( `user_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID', `role_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色ID', PRIMARY KEY (`user_id`, `role_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户和角色关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of platform_user_role -- ---------------------------- INSERT INTO `platform_user_role` VALUES ('54634575686785679498', '674567345645676783889'); -- ---------------------------- -- Table structure for sys_config -- ---------------------------- DROP TABLE IF EXISTS `sys_config`; CREATE TABLE `sys_config` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '参数主键', `config_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '参数名称', `config_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '参数键名', `config_value` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '参数键值', `config_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'N' COMMENT '系统内置（Y是 N否）', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '参数配置表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_config -- ---------------------------- INSERT INTO `sys_config` VALUES ('1', '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 'admin', '2021-05-26 15:36:21', '', NULL, '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow'); INSERT INTO `sys_config` VALUES ('2', '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 'admin', '2021-05-26 15:36:21', '', NULL, '初始化密码 123456'); INSERT INTO `sys_config` VALUES ('3', '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 'admin', '2021-05-26 15:36:21', '', NULL, '深黑主题theme-dark，浅色主题theme-light，深蓝主题theme-blue'); INSERT INTO `sys_config` VALUES ('4', '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 'admin', '2021-05-26 15:36:21', '', NULL, '是否开启注册用户功能（true开启，false关闭）'); INSERT INTO `sys_config` VALUES ('5', '用户管理-密码字符范围', 'sys.account.chrtype', '0', 'Y', 'admin', '2021-05-26 15:36:21', '', NULL, '默认任意字符范围，0任意（密码可以输入任意字符），1数字（密码只能为0-9数字），2英文字母（密码只能为a-z和A-Z字母），3字母和数字（密码必须包含字母，数字）,4字母数字和特殊字符（目前支持的特殊字符包括：~!@#$%^&*()-=_+）'); INSERT INTO `sys_config` VALUES ('6', '用户管理-初始密码修改策略', 'sys.account.initPasswordModify', '0', 'Y', 'admin', '2021-05-26 15:36:21', '', NULL, '0：初始密码修改策略关闭，没有任何提示，1：提醒用户，如果未修改初始密码，则在登录时就会提醒修改密码对话框'); INSERT INTO `sys_config` VALUES ('7', '用户管理-账号密码更新周期', 'sys.account.passwordValidateDays', '0', 'Y', 'admin', '2021-05-26 15:36:21', '', NULL, '密码更新周期（填写数字，数据初始化值为0不限制，若修改必须为大于0小于365的正整数），如果超过这个周期登录系统时，则在登录时就会提醒修改密码对话框'); INSERT INTO `sys_config` VALUES ('8', '主框架页-菜单导航显示风格', 'sys.index.menuStyle', 'default', 'Y', 'admin', '2021-05-26 15:36:21', '', NULL, '菜单导航显示风格（default为左侧导航菜单，topnav为顶部导航菜单）'); INSERT INTO `sys_config` VALUES ('9', '主框架页-是否开启页脚', 'sys.index.ignoreFooter', 'true', 'Y', 'admin', '2021-05-26 15:36:21', '', NULL, '是否开启底部页脚显示（true显示，false隐藏）'); -- ---------------------------- -- Table structure for sys_dept -- ---------------------------- DROP TABLE IF EXISTS `sys_dept`; CREATE TABLE `sys_dept` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门id', `parent_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '父部门id', `ancestors` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '祖级列表', `dept_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '部门名称', `dept_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门类型', `order_num` int(4) NULL DEFAULT 0 COMMENT '显示顺序', `leader` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '负责人', `phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系电话', `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱', `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '部门状态（0正常 1停用）', `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '部门表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_dept -- ---------------------------- INSERT INTO `sys_dept` VALUES ('567456834562247092', '0', '0', '圣钰SaaS科技', 'yb', 0, 'admin', '15888888888', 'ruoyi@qq.com', '0', '0', 'admin', '2021-05-26 15:36:20', 'admin', '2021-08-20 22:06:29', '1411258341581467649'); -- ---------------------------- -- Table structure for sys_dict_data -- ---------------------------- DROP TABLE IF EXISTS `sys_dict_data`; CREATE TABLE `sys_dict_data` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典编码', `dict_sort` int(4) NULL DEFAULT 0 COMMENT '字典排序', `dict_label` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '字典标签', `dict_value` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '字典键值', `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '字典类型', `css_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '样式属性（其他样式扩展）', `list_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '表格回显样式', `is_default` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'N' COMMENT '是否默认（Y是 N否）', `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '状态（0正常 1停用）', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '字典数据表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_dict_data -- ---------------------------- INSERT INTO `sys_dict_data` VALUES ('1', 1, '男', '0', 'sys_user_sex', '', '', 'Y', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '性别男'); INSERT INTO `sys_dict_data` VALUES ('10', 1, '默认', 'DEFAULT', 'sys_job_group', '', '', 'Y', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '默认分组'); INSERT INTO `sys_dict_data` VALUES ('11', 2, '系统', 'SYSTEM', 'sys_job_group', '', '', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '系统分组'); INSERT INTO `sys_dict_data` VALUES ('12', 1, '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '系统默认是'); INSERT INTO `sys_dict_data` VALUES ('13', 2, '否', 'N', 'sys_yes_no', '', 'danger', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '系统默认否'); INSERT INTO `sys_dict_data` VALUES ('14', 1, '通知', '1', 'sys_notice_type', '', 'warning', 'Y', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '通知'); INSERT INTO `sys_dict_data` VALUES ('15', 2, '公告', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '公告'); INSERT INTO `sys_dict_data` VALUES ('16', 1, '正常', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '正常状态'); INSERT INTO `sys_dict_data` VALUES ('17', 2, '关闭', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '关闭状态'); INSERT INTO `sys_dict_data` VALUES ('18', 99, '其他', '0', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '其他操作'); INSERT INTO `sys_dict_data` VALUES ('19', 1, '新增', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '新增操作'); INSERT INTO `sys_dict_data` VALUES ('2', 2, '女', '1', 'sys_user_sex', '', '', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '性别女'); INSERT INTO `sys_dict_data` VALUES ('20', 2, '修改', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '修改操作'); INSERT INTO `sys_dict_data` VALUES ('21', 3, '删除', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '删除操作'); INSERT INTO `sys_dict_data` VALUES ('22', 4, '授权', '4', 'sys_oper_type', '', 'primary', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '授权操作'); INSERT INTO `sys_dict_data` VALUES ('23', 5, '导出', '5', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '导出操作'); INSERT INTO `sys_dict_data` VALUES ('24', 6, '导入', '6', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '导入操作'); INSERT INTO `sys_dict_data` VALUES ('25', 7, '强退', '7', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '强退操作'); INSERT INTO `sys_dict_data` VALUES ('26', 8, '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '生成操作'); INSERT INTO `sys_dict_data` VALUES ('27', 9, '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '清空操作'); INSERT INTO `sys_dict_data` VALUES ('28', 1, '成功', '0', 'sys_common_status', '', 'primary', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '正常状态'); INSERT INTO `sys_dict_data` VALUES ('29', 2, '失败', '1', 'sys_common_status', '', 'danger', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '停用状态'); INSERT INTO `sys_dict_data` VALUES ('3', 3, '未知', '2', 'sys_user_sex', '', '', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '性别未知'); INSERT INTO `sys_dict_data` VALUES ('4', 1, '显示', '0', 'sys_show_hide', '', 'primary', 'Y', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '显示菜单'); INSERT INTO `sys_dict_data` VALUES ('5', 2, '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '隐藏菜单'); INSERT INTO `sys_dict_data` VALUES ('6', 1, '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '正常状态'); INSERT INTO `sys_dict_data` VALUES ('7', 2, '停用', '1', 'sys_normal_disable', '', 'danger', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '停用状态'); INSERT INTO `sys_dict_data` VALUES ('8', 1, '正常', '0', 'sys_job_status', '', 'primary', 'Y', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '正常状态'); INSERT INTO `sys_dict_data` VALUES ('9', 2, '暂停', '1', 'sys_job_status', '', 'danger', 'N', '0', 'admin', '2021-05-26 15:36:21', '', NULL, '停用状态'); -- ---------------------------- -- Table structure for sys_dict_type -- ---------------------------- DROP TABLE IF EXISTS `sys_dict_type`; CREATE TABLE `sys_dict_type` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '字典主键', `dict_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '字典名称', `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '字典类型', `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '状态（0正常 1停用）', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `dict_type`(`dict_type`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '字典类型表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_dict_type -- ---------------------------- INSERT INTO `sys_dict_type` VALUES ('1', '用户性别', 'sys_user_sex', '0', 'admin', '2021-05-26 15:36:20', '', NULL, '用户性别列表'); INSERT INTO `sys_dict_type` VALUES ('10', '系统状态', 'sys_common_status', '0', 'admin', '2021-05-26 15:36:20', '', NULL, '登录状态列表'); INSERT INTO `sys_dict_type` VALUES ('1422742173800628226', '完成状态', 'accomplish_status', '0', 'admin', '2021-08-04 10:12:22', 'admin', '2021-08-04 10:12:22', ''); INSERT INTO `sys_dict_type` VALUES ('2', '菜单状态', 'sys_show_hide', '0', 'admin', '2021-05-26 15:36:20', '', NULL, '菜单状态列表'); INSERT INTO `sys_dict_type` VALUES ('3', '系统开关', 'sys_normal_disable', '0', 'admin', '2021-05-26 15:36:20', '', NULL, '系统开关列表'); INSERT INTO `sys_dict_type` VALUES ('4', '任务状态', 'sys_job_status', '0', 'admin', '2021-05-26 15:36:20', '', NULL, '任务状态列表'); INSERT INTO `sys_dict_type` VALUES ('5', '任务分组', 'sys_job_group', '0', 'admin', '2021-05-26 15:36:20', '', NULL, '任务分组列表'); INSERT INTO `sys_dict_type` VALUES ('6', '系统是否', 'sys_yes_no', '0', 'admin', '2021-05-26 15:36:20', '', NULL, '系统是否列表'); INSERT INTO `sys_dict_type` VALUES ('7', '通知类型', 'sys_notice_type', '0', 'admin', '2021-05-26 15:36:20', '', NULL, '通知类型列表'); INSERT INTO `sys_dict_type` VALUES ('8', '通知状态', 'sys_notice_status', '0', 'admin', '2021-05-26 15:36:20', '', NULL, '通知状态列表'); INSERT INTO `sys_dict_type` VALUES ('9', '操作类型', 'sys_oper_type', '0', 'admin', '2021-05-26 15:36:20', '', NULL, '操作类型列表'); -- ---------------------------- -- Table structure for sys_job -- ---------------------------- DROP TABLE IF EXISTS `sys_job`; CREATE TABLE `sys_job` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务ID', `job_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '任务名称', `job_group` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'DEFAULT' COMMENT '任务组名', `invoke_target` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调用目标字符串', `cron_expression` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'cron执行表达式', `misfire_policy` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '3' COMMENT '计划执行错误策略（1立即执行 2执行一次 3放弃执行）', `concurrent` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '1' COMMENT '是否并发执行（0允许 1禁止）', `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '状态（0正常 1暂停）', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注信息', PRIMARY KEY (`id`, `job_name`, `job_group`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '定时任务调度表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_job -- ---------------------------- INSERT INTO `sys_job` VALUES ('1', '系统默认（无参）', 'DEFAULT', 'ybTask.ybNoParams', '0/10 * * * * ?', '3', '1', '1', 'admin', '2021-05-26 15:36:21', '', NULL, ''); INSERT INTO `sys_job` VALUES ('2', '系统默认（有参）', 'DEFAULT', 'ybTask.ybParams(\'yb\')', '0/15 * * * * ?', '3', '1', '1', 'admin', '2021-05-26 15:36:21', '', NULL, ''); INSERT INTO `sys_job` VALUES ('3', '系统默认（多参）', 'DEFAULT', 'ybTask.ybMultipleParams(\'yb\', true, 2000L, 316.50D, 100)', '0/20 * * * * ?', '3', '1', '1', 'admin', '2021-05-26 15:36:21', '', NULL, ''); -- ---------------------------- -- Table structure for sys_job_log -- ---------------------------- DROP TABLE IF EXISTS `sys_job_log`; CREATE TABLE `sys_job_log` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务日志ID', `job_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务名称', `job_group` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务组名', `invoke_target` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调用目标字符串', `job_message` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '日志信息', `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '执行状态（0正常 1失败）', `exception_info` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '异常信息', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '定时任务调度日志表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_job_log -- ---------------------------- -- ---------------------------- -- Table structure for sys_logininfor -- ---------------------------- DROP TABLE IF EXISTS `sys_logininfor`; CREATE TABLE `sys_logininfor` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '访问ID', `login_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录账号', `ipaddr` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录IP地址', `login_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录地点', `browser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '浏览器类型', `os` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作系统', `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '登录状态（0成功 1失败）', `msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '提示消息', `login_time` datetime(0) NULL DEFAULT NULL COMMENT '访问时间', `tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统访问记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_logininfor -- ---------------------------- -- ---------------------------- -- Table structure for sys_menu -- ---------------------------- DROP TABLE IF EXISTS `sys_menu`; CREATE TABLE `sys_menu` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单ID', `menu_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单名称', `parent_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '父菜单ID', `order_num` int(4) NULL DEFAULT 0 COMMENT '显示顺序', `url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '#' COMMENT '请求地址', `target` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '打开方式（menuItem页签 menuBlank新窗口）', `menu_c_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '00' COMMENT '菜单使用类型\r\n00 基本菜单（租户拥有的最基础的菜单，租户永久拥有）\r\n01 免费赠送菜单（以订单收费为0的形式赠送，收回的话直接修改订单）\r\n02 付费菜单（租户购买之后，有效期之内可以任意使用）', `menu_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）', `visible` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '菜单状态（0显示 1隐藏）', `is_refresh` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '1' COMMENT '是否刷新（0刷新 1不刷新）', `perms` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限标识', `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '#' COMMENT '菜单图标', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '菜单权限表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_menu -- ---------------------------- INSERT INTO `sys_menu` VALUES ('1', '系统管理', '0', 1, '#', '', '00', 'M', '0', '1', '', 'fa fa-gear', 'admin', '2021-05-26 15:36:20', '', NULL, '系统管理目录'); INSERT INTO `sys_menu` VALUES ('100', '用户管理', '1', 1, '/system/user', '', '00', 'C', '0', '1', 'system:user:view', 'fa fa-user-o', 'admin', '2021-05-26 15:36:20', '', NULL, '用户管理菜单'); INSERT INTO `sys_menu` VALUES ('1000', '用户查询', '100', 1, '#', '', '00', 'F', '0', '1', 'system:user:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1001', '用户新增', '100', 2, '#', '', '00', 'F', '0', '1', 'system:user:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1002', '用户修改', '100', 3, '#', '', '00', 'F', '0', '1', 'system:user:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1003', '用户删除', '100', 4, '#', '', '00', 'F', '0', '1', 'system:user:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1004', '用户导出', '100', 5, '#', '', '00', 'F', '0', '1', 'system:user:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1005', '用户导入', '100', 6, '#', '', '00', 'F', '0', '1', 'system:user:import', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1006', '重置密码', '100', 7, '#', '', '00', 'F', '0', '1', 'system:user:resetPwd', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1007', '角色查询', '101', 1, '#', '', '00', 'F', '0', '1', 'system:role:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1008', '角色新增', '101', 2, '#', '', '00', 'F', '0', '1', 'system:role:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1009', '角色修改', '101', 3, '#', '', '00', 'F', '0', '1', 'system:role:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('101', '内部角色', '1426117002031804417', 1, '/system/role', 'menuItem', '00', 'C', '0', '1', 'system:role:view', 'fa fa-user-secret', 'admin', '2021-05-26 15:36:20', 'admin', '2021-08-13 17:46:14', '角色管理菜单'); INSERT INTO `sys_menu` VALUES ('1010', '角色删除', '101', 4, '#', '', '00', 'F', '0', '1', 'system:role:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1011', '角色导出', '101', 5, '#', '', '00', 'F', '0', '1', 'system:role:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1016', '部门查询', '103', 1, '#', '', '00', 'F', '0', '1', 'system:dept:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1017', '部门新增', '103', 2, '#', '', '00', 'F', '0', '1', 'system:dept:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1018', '部门修改', '103', 3, '#', '', '00', 'F', '0', '1', 'system:dept:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1019', '部门删除', '103', 4, '#', '', '00', 'F', '0', '1', 'system:dept:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1020', '岗位查询', '104', 1, '#', '', '00', 'F', '0', '1', 'system:post:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1021', '岗位新增', '104', 2, '#', '', '00', 'F', '0', '1', 'system:post:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1022', '岗位修改', '104', 3, '#', '', '00', 'F', '0', '1', 'system:post:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1023', '岗位删除', '104', 4, '#', '', '00', 'F', '0', '1', 'system:post:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1024', '岗位导出', '104', 5, '#', '', '00', 'F', '0', '1', 'system:post:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('103', '部门管理', '1', 4, '/system/dept', '', '00', 'C', '0', '1', 'system:dept:view', 'fa fa-outdent', 'admin', '2021-05-26 15:36:20', '', NULL, '部门管理菜单'); INSERT INTO `sys_menu` VALUES ('1035', '公告查询', '107', 1, '#', '', '00', 'F', '0', '1', 'system:notice:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1036', '公告新增', '107', 2, '#', '', '00', 'F', '0', '1', 'system:notice:add', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1037', '公告修改', '107', 3, '#', '', '00', 'F', '0', '1', 'system:notice:edit', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1038', '公告删除', '107', 4, '#', '', '00', 'F', '0', '1', 'system:notice:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1039', '操作查询', '500', 1, '#', '', '00', 'F', '0', '1', 'monitor:operlog:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('104', '岗位管理', '1', 5, '/system/post', '', '00', 'C', '0', '1', 'system:post:view', 'fa fa-address-card-o', 'admin', '2021-05-26 15:36:20', '', NULL, '岗位管理菜单'); INSERT INTO `sys_menu` VALUES ('1040', '操作删除', '500', 2, '#', '', '00', 'F', '0', '1', 'monitor:operlog:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1041', '详细信息', '500', 3, '#', '', '00', 'F', '0', '1', 'monitor:operlog:detail', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1042', '日志导出', '500', 4, '#', '', '00', 'F', '0', '1', 'monitor:operlog:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1043', '登录查询', '501', 1, '#', '', '00', 'F', '0', '1', 'monitor:logininfor:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1044', '登录删除', '501', 2, '#', '', '00', 'F', '0', '1', 'monitor:logininfor:remove', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1045', '日志导出', '501', 3, '#', '', '00', 'F', '0', '1', 'monitor:logininfor:export', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1046', '账户解锁', '501', 4, '#', '', '00', 'F', '0', '1', 'monitor:logininfor:unlock', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1047', '在线查询', '109', 1, '#', '', '00', 'F', '0', '1', 'monitor:online:list', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1048', '批量强退', '109', 2, '#', '', '00', 'F', '0', '1', 'monitor:online:batchForceLogout', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('1049', '单条强退', '109', 3, '#', '', '00', 'F', '0', '1', 'monitor:online:forceLogout', '#', 'admin', '2021-05-26 15:36:20', '', NULL, ''); INSERT INTO `sys_menu` VALUES ('107', '通知公告', '1', 8, '/system/notice', '', '00', 'C', '0', '1', 'system:notice:view', 'fa fa-bullhorn', 'admin', '2021-05-26 15:36:20', '', NULL, '通知公告菜单'); INSERT INTO `sys_menu` VALUES ('108', '日志管理', '1', 10, '#', '', '00', 'M', '0', '1', '', 'fa fa-pencil-square-o', 'admin', '2021-05-26 15:36:20', '', NULL, '日志管理菜单'); INSERT INTO `sys_menu` VALUES ('109', '在线用户', '1423806481886625793', 9, '/monitor/online', 'menuItem', '00', 'C', '0', '1', 'monitor:online:view', 'fa fa-user-circle', 'admin', '2021-05-26 15:36:20', 'admin', '2021-08-07 08:42:09', '在线用户菜单'); INSERT INTO `sys_menu` VALUES ('1423806481886625793', '系统监控', '0', 2, '', 'menuItem', '00', 'M', '0', '1', '', 'fa fa-video-camera', 'admin', '2021-08-07 08:41:33', 'admin', '2021-08-07 08:41:33', ''); INSERT INTO `sys_menu` VALUES ('1426117002031804417', '角色管理', '1', 2, '', 'menuItem', '00', 'M', '0', '1', '', 'fa fa-street-view', 'admin', '2021-08-13 17:42:44', 'admin', '2021-08-13 17:42:44', ''); INSERT INTO `sys_menu` VALUES ('1426117817731657730', '平台角色', '1426117002031804417', 2, '/system/pf/role', 'menuItem', '00', 'C', '0', '1', 'system:pf:role:view', 'fa fa-users', 'admin', '2021-08-13 17:45:58', 'admin', '2021-08-13 17:45:58', ''); INSERT INTO `sys_menu` VALUES ('1426118022732460033', '查询', '1426117817731657730', 1, '', 'menuItem', '00', 'F', '0', '1', 'system:pf:role:list', '', 'admin', '2021-08-13 17:46:47', 'admin', '2021-08-13 17:46:47', ''); INSERT INTO `sys_menu` VALUES ('4', '圣钰官网', '0', 4, 'https://gitee.com/jinzheyi/ruoyi-saas', 'menuBlank', '00', 'C', '0', '1', '', 'fa fa-location-arrow', 'admin', '2021-05-26 15:36:20', '', NULL, '圣钰官网地址'); INSERT INTO `sys_menu` VALUES ('500', '操作日志', '108', 1, '/monitor/operlog', '', '00', 'C', '0', '1', 'monitor:operlog:view', 'fa fa-address-book', 'admin', '2021-05-26 15:36:20', '', NULL, '操作日志菜单'); INSERT INTO `sys_menu` VALUES ('501', '登录日志', '108', 2, '/monitor/logininfor', '', '00', 'C', '0', '1', 'monitor:logininfor:view', 'fa fa-file-image-o', 'admin', '2021-05-26 15:36:20', '', NULL, '登录日志菜单'); -- ---------------------------- -- Table structure for sys_notice -- ---------------------------- DROP TABLE IF EXISTS `sys_notice`; CREATE TABLE `sys_notice` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公告ID', `notice_title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公告标题', `notice_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公告类型（1通知 2公告）', `notice_content` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '公告内容', `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '公告状态（0正常 1关闭）', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '通知公告表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_notice -- ---------------------------- -- ---------------------------- -- Table structure for sys_oper_log -- ---------------------------- DROP TABLE IF EXISTS `sys_oper_log`; CREATE TABLE `sys_oper_log` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '日志主键', `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '模块标题', `business_type` int(2) NULL DEFAULT 0 COMMENT '业务类型（0其它 1新增 2修改 3删除）', `method` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '方法名称', `request_method` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '请求方式', `operator_type` int(1) NULL DEFAULT 0 COMMENT '操作类别（0其它 1后台用户 2手机端用户）', `oper_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作人员', `dept_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '部门名称', `oper_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '请求URL', `oper_ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '主机地址', `oper_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作地点', `oper_param` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '请求参数', `json_result` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '返回参数', `status` int(1) NULL DEFAULT 0 COMMENT '操作状态（0正常 1异常）', `error_msg` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '错误消息', `oper_time` datetime(0) NULL DEFAULT NULL COMMENT '操作时间', `tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '操作日志记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_oper_log -- ---------------------------- -- ---------------------------- -- Table structure for sys_post -- ---------------------------- DROP TABLE IF EXISTS `sys_post`; CREATE TABLE `sys_post` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位ID', `post_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位编码', `post_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位名称', `post_sort` int(4) NOT NULL COMMENT '显示顺序', `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '状态（0正常 1停用）', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '岗位信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_post -- ---------------------------- -- ---------------------------- -- Table structure for sys_role -- ---------------------------- DROP TABLE IF EXISTS `sys_role`; CREATE TABLE `sys_role` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色ID', `role_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色名称', `role_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色权限字符串', `role_sort` int(4) NOT NULL COMMENT '显示顺序', `data_scope` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）', `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色状态（0正常 1停用）', `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_role -- ---------------------------- INSERT INTO `sys_role` VALUES ('1424613086572085250', '董事长', '4787b203faa14f12b2bbc5611aba2157', 1, '1', '0', '0', 'admin', '2021-08-09 14:06:43', 'admin', '2021-08-09 14:06:43', '', 'platform_saas'); INSERT INTO `sys_role` VALUES ('54634567845232344567897', '租户管理员角色', 'saas_admin', 0, '1', '0', '0', 'admin', '2021-05-26 15:36:20', 'admin', '2021-08-13 17:48:15', '租户管理员角色', 'platform_saas'); -- ---------------------------- -- Table structure for sys_role_dept -- ---------------------------- DROP TABLE IF EXISTS `sys_role_dept`; CREATE TABLE `sys_role_dept` ( `role_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色ID', `dept_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门ID', `tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id', PRIMARY KEY (`role_id`, `dept_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色和部门关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_role_dept -- ---------------------------- -- ---------------------------- -- Table structure for sys_role_menu -- ---------------------------- DROP TABLE IF EXISTS `sys_role_menu`; CREATE TABLE `sys_role_menu` ( `role_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色ID', `menu_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单ID', PRIMARY KEY (`role_id`, `menu_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_role_menu -- ---------------------------- INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '100'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1000'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1001'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1002'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1003'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1004'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1005'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1006'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1016'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1017'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1018'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1019'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1020'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1021'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1022'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1023'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1024'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '103'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1035'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1036'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1037'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1038'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1039'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '104'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1040'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1041'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1042'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1043'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1044'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1045'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1046'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1047'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1048'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1049'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '107'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '108'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '109'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '1423806481886625793'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '4'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '500'); INSERT INTO `sys_role_menu` VALUES ('1424613086572085250', '501'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '100'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1000'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1001'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1002'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1003'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1004'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1005'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1006'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1007'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1008'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1009'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '101'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1010'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1011'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1016'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1017'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1018'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1019'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1020'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1021'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1022'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1023'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1024'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '103'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1035'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1036'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1037'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1038'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1039'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '104'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1040'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1041'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1042'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1043'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1044'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1045'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1046'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1047'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1048'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1049'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '107'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '108'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '109'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1423806481886625793'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1426117002031804417'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1426117817731657730'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '1426118022732460033'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '4'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '500'); INSERT INTO `sys_role_menu` VALUES ('54634567845232344567897', '501'); -- ---------------------------- -- Table structure for sys_user -- ---------------------------- DROP TABLE IF EXISTS `sys_user`; CREATE TABLE `sys_user` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID', `dept_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门ID', `login_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '登录账号', `user_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户昵称', `user_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '00' COMMENT '用户类型（00系统用户 01注册用户02租户超管）', `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '用户邮箱', `phonenumber` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '手机号码', `sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）', `avatar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '头像路径', `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '密码', `salt` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '盐加密', `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '帐号状态（0正常 1停用）', `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `login_ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '最后登录IP', `login_date` datetime(0) NULL DEFAULT NULL COMMENT '最后登录时间', `pwd_update_date` datetime(0) NULL DEFAULT NULL COMMENT '密码最后更新时间', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_user -- ---------------------------- INSERT INTO `sys_user` VALUES ('1408064610237779960', '567456834562247092', 'admin', '圣钰saas', 'yb', 'ruoyi@qq.com', '15888888888', '1', '/profile/avatar/2021/08/12/efe9fc9a-9b09-4b79-974c-401e1585c715.png', '29c67a30398638269fe600f73a054934', '111111', '0', '0', '127.0.0.1', '2021-08-20 22:35:52', '2021-05-26 15:36:20', 'admin', '2021-05-26 15:36:20', 'ruoyi-system', '2021-08-20 22:35:52', '管理员', '1411258341581467649'); -- ---------------------------- -- Table structure for sys_user_online -- ---------------------------- DROP TABLE IF EXISTS `sys_user_online`; CREATE TABLE `sys_user_online` ( `id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '用户会话id', `login_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录账号', `dept_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '部门名称', `ipaddr` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录IP地址', `login_location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '登录地点', `browser` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '浏览器类型', `os` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '操作系统', `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '在线状态on_line在线off_line离线', `start_timestamp` datetime(0) NULL DEFAULT NULL COMMENT 'session创建时间', `last_access_time` datetime(0) NULL DEFAULT NULL COMMENT 'session最后访问时间', `expire_time` int(5) NULL DEFAULT 0 COMMENT '超时时间，单位为分钟', `tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '在线用户记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_user_online -- ---------------------------- -- ---------------------------- -- Table structure for sys_user_post -- ---------------------------- DROP TABLE IF EXISTS `sys_user_post`; CREATE TABLE `sys_user_post` ( `user_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID', `post_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '岗位ID', `tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id', PRIMARY KEY (`user_id`, `post_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户与岗位关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_user_post -- ---------------------------- -- ---------------------------- -- Table structure for sys_user_role -- ---------------------------- DROP TABLE IF EXISTS `sys_user_role`; CREATE TABLE `sys_user_role` ( `user_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID', `role_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色ID', `tenant_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '租户id', PRIMARY KEY (`user_id`, `role_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户和角色关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_user_role -- ---------------------------- INSERT INTO `sys_user_role` VALUES ('1408064610237779960', '54634567845232344567897', '1411258341581467649'); SET FOREIGN_KEY_CHECKS = 1;