492 lines
45 KiB
PL/PgSQL
492 lines
45 KiB
PL/PgSQL
/*
|
||
Navicat Premium Data Transfer
|
||
|
||
Source Server : 127.0.0.1 MySQL
|
||
Source Server Type : MySQL
|
||
Source Server Version : 80026
|
||
Source Host : localhost:3306
|
||
Source Schema : ruoyi-vue-pro-tenant-b
|
||
|
||
Target Server Type : MySQL
|
||
Target Server Version : 80026
|
||
File Encoding : 65001
|
||
|
||
Date: 28/02/2023 01:06:04
|
||
*/
|
||
|
||
SET NAMES utf8mb4;
|
||
SET FOREIGN_KEY_CHECKS = 0;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for system_dept
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `system_dept`;
|
||
CREATE TABLE `system_dept` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '部门id',
|
||
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '部门名称',
|
||
`parent_id` bigint NOT NULL DEFAULT '0' COMMENT '父部门id',
|
||
`sort` int NOT NULL DEFAULT '0' COMMENT '显示顺序',
|
||
`leader_user_id` bigint DEFAULT NULL COMMENT '负责人',
|
||
`phone` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '联系电话',
|
||
`email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮箱',
|
||
`status` tinyint NOT NULL COMMENT '部门状态（0正常 1停用）',
|
||
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
||
`tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='部门表';
|
||
|
||
-- ----------------------------
|
||
-- Records of system_dept
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for system_login_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `system_login_log`;
|
||
CREATE TABLE `system_login_log` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '访问ID',
|
||
`log_type` bigint NOT NULL COMMENT '日志类型',
|
||
`trace_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '链路追踪编号',
|
||
`user_id` bigint NOT NULL DEFAULT '0' COMMENT '用户编号',
|
||
`user_type` tinyint NOT NULL DEFAULT '0' COMMENT '用户类型',
|
||
`username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户账号',
|
||
`result` tinyint NOT NULL COMMENT '登陆结果',
|
||
`user_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户 IP',
|
||
`user_agent` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '浏览器 UA',
|
||
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
||
`tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2162 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统访问记录';
|
||
|
||
-- ----------------------------
|
||
-- Records of system_login_log
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for system_notice
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `system_notice`;
|
||
CREATE TABLE `system_notice` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '公告ID',
|
||
`title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '公告标题',
|
||
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '公告内容',
|
||
`type` tinyint NOT NULL COMMENT '公告类型（1通知 2公告）',
|
||
`status` tinyint NOT NULL DEFAULT '0' COMMENT '公告状态（0正常 1关闭）',
|
||
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
||
`tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='通知公告表';
|
||
|
||
-- ----------------------------
|
||
-- Records of system_notice
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for system_notify_message
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `system_notify_message`;
|
||
CREATE TABLE `system_notify_message` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID',
|
||
`user_id` bigint NOT NULL COMMENT '用户id',
|
||
`user_type` tinyint NOT NULL COMMENT '用户类型',
|
||
`template_id` bigint NOT NULL COMMENT '模版编号',
|
||
`template_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模板编码',
|
||
`template_nickname` varchar(63) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模版发送人名称',
|
||
`template_content` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模版内容',
|
||
`template_type` int NOT NULL COMMENT '模版类型',
|
||
`template_params` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模版参数',
|
||
`read_status` bit(1) NOT NULL COMMENT '是否已读',
|
||
`read_time` datetime DEFAULT NULL COMMENT '阅读时间',
|
||
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
||
`tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='站内信消息表';
|
||
|
||
-- ----------------------------
|
||
-- Records of system_notify_message
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for system_operate_log
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `system_operate_log`;
|
||
CREATE TABLE `system_operate_log` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '日志主键',
|
||
`trace_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '链路追踪编号',
|
||
`user_id` bigint NOT NULL COMMENT '用户编号',
|
||
`user_type` tinyint NOT NULL DEFAULT '0' COMMENT '用户类型',
|
||
`module` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '模块标题',
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '操作名',
|
||
`type` bigint NOT NULL DEFAULT '0' COMMENT '操作分类',
|
||
`content` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '操作内容',
|
||
`exts` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '拓展字段',
|
||
`request_method` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '请求方法名',
|
||
`request_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '请求地址',
|
||
`user_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户 IP',
|
||
`user_agent` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '浏览器 UA',
|
||
`java_method` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'Java 方法名',
|
||
`java_method_args` varchar(8000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT 'Java 方法的参数',
|
||
`start_time` datetime NOT NULL COMMENT '操作时间',
|
||
`duration` int NOT NULL COMMENT '执行时长',
|
||
`result_code` int NOT NULL DEFAULT '0' COMMENT '结果码',
|
||
`result_msg` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '结果提示',
|
||
`result_data` varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '结果数据',
|
||
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
||
`tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=6343 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='操作日志记录';
|
||
|
||
-- ----------------------------
|
||
-- Records of system_operate_log
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for system_post
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `system_post`;
|
||
CREATE TABLE `system_post` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '岗位ID',
|
||
`code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '岗位编码',
|
||
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '岗位名称',
|
||
`sort` int NOT NULL COMMENT '显示顺序',
|
||
`status` tinyint NOT NULL COMMENT '状态（0正常 1停用）',
|
||
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
|
||
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
||
`tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='岗位信息表';
|
||
|
||
-- ----------------------------
|
||
-- Records of system_post
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for system_role
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `system_role`;
|
||
CREATE TABLE `system_role` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '角色ID',
|
||
`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色名称',
|
||
`code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色权限字符串',
|
||
`sort` int NOT NULL COMMENT '显示顺序',
|
||
`data_scope` tinyint NOT NULL DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本部门数据权限 4：本部门及以下数据权限）',
|
||
`data_scope_dept_ids` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '数据范围(指定部门数组)',
|
||
`status` tinyint NOT NULL COMMENT '角色状态（0正常 1停用）',
|
||
`type` tinyint NOT NULL COMMENT '角色类型',
|
||
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
|
||
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
||
`tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='角色信息表';
|
||
|
||
-- ----------------------------
|
||
-- Records of system_role
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `system_role` (`id`, `name`, `code`, `sort`, `data_scope`, `data_scope_dept_ids`, `status`, `type`, `remark`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (119, '租户管理员', 'tenant_admin', 0, 1, '', 0, 1, '系统自动生成', '1', '2023-02-27 22:23:36', '1', '2023-02-27 22:23:36', b'0', 2172);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for system_role_menu
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `system_role_menu`;
|
||
CREATE TABLE `system_role_menu` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增编号',
|
||
`role_id` bigint NOT NULL COMMENT '角色ID',
|
||
`menu_id` bigint NOT NULL COMMENT '菜单ID',
|
||
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
||
`tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=2414 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='角色和菜单关联表';
|
||
|
||
-- ----------------------------
|
||
-- Records of system_role_menu
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2313, 119, 1, '1', '2023-02-27 22:23:36', '1', '2023-02-27 22:23:36', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2314, 119, 100, '1', '2023-02-27 22:23:36', '1', '2023-02-27 22:23:36', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2315, 119, 1001, '1', '2023-02-27 22:23:36', '1', '2023-02-27 22:23:36', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2316, 119, 1002, '1', '2023-02-27 22:23:36', '1', '2023-02-27 22:23:36', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2317, 119, 1003, '1', '2023-02-27 22:23:36', '1', '2023-02-27 22:23:36', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2318, 119, 1004, '1', '2023-02-27 22:23:36', '1', '2023-02-27 22:23:36', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2319, 119, 1005, '1', '2023-02-27 22:23:36', '1', '2023-02-27 22:23:36', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2320, 119, 1006, '1', '2023-02-27 22:23:36', '1', '2023-02-27 22:23:36', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2321, 119, 1007, '1', '2023-02-27 22:23:36', '1', '2023-02-27 22:23:36', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2322, 119, 2, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2323, 119, 1031, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2324, 119, 1032, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2325, 119, 1033, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2326, 119, 1034, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2327, 119, 1035, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2328, 119, 1050, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2329, 119, 1051, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2330, 119, 1052, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2331, 119, 1053, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2332, 119, 1054, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2333, 119, 1056, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2334, 119, 1057, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2335, 119, 1058, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2336, 119, 1059, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2337, 119, 1060, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2338, 119, 1066, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2339, 119, 1067, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2340, 119, 1070, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2341, 119, 1071, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2342, 119, 1072, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2343, 119, 1073, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2344, 119, 1074, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2345, 119, 1075, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2346, 119, 1076, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2347, 119, 1077, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2348, 119, 1078, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2349, 119, 1082, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2350, 119, 1083, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2351, 119, 1084, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2352, 119, 1085, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2353, 119, 1086, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2354, 119, 1087, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2355, 119, 1088, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2356, 119, 1089, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2357, 119, 1090, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2358, 119, 1091, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2359, 119, 1092, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2360, 119, 1237, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2361, 119, 1238, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2362, 119, 1239, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2363, 119, 1240, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2364, 119, 1241, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2365, 119, 1242, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2366, 119, 1243, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2367, 119, 1255, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2368, 119, 1256, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2369, 119, 1257, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2370, 119, 1258, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2371, 119, 106, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2372, 119, 1259, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2373, 119, 1260, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2374, 119, 110, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2375, 119, 111, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2376, 119, 112, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2377, 119, 113, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2378, 119, 114, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2379, 119, 115, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2380, 119, 116, '1', '2023-02-27 22:26:52', '1', '2023-02-27 22:26:52', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2381, 119, 1117, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2382, 119, 1126, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2383, 119, 1127, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2384, 119, 1128, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2385, 119, 1129, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2386, 119, 1130, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2387, 119, 1131, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2388, 119, 1132, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2389, 119, 1133, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2390, 119, 1134, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2391, 119, 1135, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2392, 119, 1136, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2393, 119, 1137, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2394, 119, 2161, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2395, 119, 1150, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2396, 119, 1161, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2397, 119, 1162, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2398, 119, 1163, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2399, 119, 1164, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2400, 119, 1165, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2401, 119, 1166, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2402, 119, 1173, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2403, 119, 1174, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2404, 119, 1175, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2405, 119, 1176, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2406, 119, 1177, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2407, 119, 1178, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2408, 119, 1179, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2409, 119, 1180, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2410, 119, 1181, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2411, 119, 1182, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2412, 119, 1183, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
INSERT INTO `system_role_menu` (`id`, `role_id`, `menu_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (2413, 119, 1184, '1', '2023-02-27 22:28:31', '1', '2023-02-27 22:28:31', b'0', 2172);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for system_social_user
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `system_social_user`;
|
||
CREATE TABLE `system_social_user` (
|
||
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键(自增策略)',
|
||
`type` tinyint NOT NULL COMMENT '社交平台的类型',
|
||
`openid` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '社交 openid',
|
||
`token` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '社交 token',
|
||
`raw_token_info` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '原始 Token 数据，一般是 JSON 格式',
|
||
`nickname` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户昵称',
|
||
`avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户头像',
|
||
`raw_user_info` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '原始用户数据，一般是 JSON 格式',
|
||
`code` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '最后一次的认证 code',
|
||
`state` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '最后一次的认证 state',
|
||
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
||
`tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='社交用户表';
|
||
|
||
-- ----------------------------
|
||
-- Records of system_social_user
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for system_social_user_bind
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `system_social_user_bind`;
|
||
CREATE TABLE `system_social_user_bind` (
|
||
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键(自增策略)',
|
||
`user_id` bigint NOT NULL COMMENT '用户编号',
|
||
`user_type` tinyint NOT NULL COMMENT '用户类型',
|
||
`social_type` tinyint NOT NULL COMMENT '社交平台的类型',
|
||
`social_user_id` bigint NOT NULL COMMENT '社交用户的编号',
|
||
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
||
`tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='社交绑定表';
|
||
|
||
-- ----------------------------
|
||
-- Records of system_social_user_bind
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for system_user_post
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `system_user_post`;
|
||
CREATE TABLE `system_user_post` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
|
||
`user_id` bigint NOT NULL DEFAULT '0' COMMENT '用户ID',
|
||
`post_id` bigint NOT NULL DEFAULT '0' COMMENT '岗位ID',
|
||
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
||
`tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=118 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户岗位表';
|
||
|
||
-- ----------------------------
|
||
-- Records of system_user_post
|
||
-- ----------------------------
|
||
BEGIN;
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for system_user_role
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `system_user_role`;
|
||
CREATE TABLE `system_user_role` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增编号',
|
||
`user_id` bigint NOT NULL COMMENT '用户ID',
|
||
`role_id` bigint NOT NULL COMMENT '角色ID',
|
||
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
||
`create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
||
`update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` bit(1) DEFAULT b'0' COMMENT '是否删除',
|
||
`tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户和角色关联表';
|
||
|
||
-- ----------------------------
|
||
-- Records of system_user_role
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `system_user_role` (`id`, `user_id`, `role_id`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (28, 123, 119, '1', '2023-02-27 22:23:36', '1', '2023-02-27 22:23:36', b'0', 2172);
|
||
COMMIT;
|
||
|
||
-- ----------------------------
|
||
-- Table structure for system_users
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS `system_users`;
|
||
CREATE TABLE `system_users` (
|
||
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID',
|
||
`username` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户账号',
|
||
`password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '密码',
|
||
`nickname` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户昵称',
|
||
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '备注',
|
||
`dept_id` bigint DEFAULT NULL COMMENT '部门ID',
|
||
`post_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '岗位编号数组',
|
||
`email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '用户邮箱',
|
||
`mobile` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '手机号码',
|
||
`sex` tinyint DEFAULT '0' COMMENT '用户性别',
|
||
`avatar` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '头像地址',
|
||
`status` tinyint NOT NULL DEFAULT '0' COMMENT '帐号状态（0正常 1停用）',
|
||
`login_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '最后登录IP',
|
||
`login_date` datetime DEFAULT NULL COMMENT '最后登录时间',
|
||
`creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '创建者',
|
||
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
|
||
`updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '更新者',
|
||
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
|
||
`deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
|
||
`tenant_id` bigint NOT NULL DEFAULT '0' COMMENT '租户编号',
|
||
PRIMARY KEY (`id`) USING BTREE,
|
||
UNIQUE KEY `idx_username` (`username`,`update_time`,`tenant_id`) USING BTREE
|
||
) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户信息表';
|
||
|
||
-- ----------------------------
|
||
-- Records of system_users
|
||
-- ----------------------------
|
||
BEGIN;
|
||
INSERT INTO `system_users` (`id`, `username`, `password`, `nickname`, `remark`, `dept_id`, `post_ids`, `email`, `mobile`, `sex`, `avatar`, `status`, `login_ip`, `login_date`, `creator`, `create_time`, `updater`, `update_time`, `deleted`, `tenant_id`) VALUES (123, 'testb', '$2a$10$3czquiO1CVXOwrITb2OYW.eff59qwxkNlZkGztzFyarW5rpyHO/Ge', '阿毛', NULL, NULL, NULL, '', '', 0, '', 0, '', NULL, '1', '2023-02-27 22:23:36', '1', '2023-02-27 22:23:36', b'0', 2172);
|
||
COMMIT;
|
||
|
||
SET FOREIGN_KEY_CHECKS = 1;
|