/*
 Navicat Premium Dump SQL

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50730 (5.7.30-0ubuntu0.18.04.1)
 Source Host           : localhost:3306
 Source Schema         : rsf

 Target Server Type    : MySQL
 Target Server Version : 50730 (5.7.30-0ubuntu0.18.04.1)
 File Encoding         : 65001

 Date: 05/02/2025 14:40:43
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `uuid` varchar(255) DEFAULT NULL COMMENT '编号',
  `name` varchar(255) DEFAULT NULL COMMENT '名称(*)',
  `flag` varchar(255) DEFAULT NULL COMMENT '标识',
  `type` int(1) DEFAULT NULL COMMENT '类型{1:boolean,2:number,3:string,4:json,5:date}',
  `val` varchar(255) DEFAULT NULL COMMENT '字典值',
  `content` varchar(1024) DEFAULT NULL COMMENT '字典文本',
  `status` int(1) NOT NULL DEFAULT '1' COMMENT '状态{1:正常,0:冻结}',
  `deleted` int(1) NOT NULL DEFAULT '0' COMMENT '是否删除{1:是,0:否}',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '租户[sys_tenant]',
  `create_by` bigint(20) DEFAULT NULL COMMENT '添加人员[sys_user]',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  `update_by` bigint(20) DEFAULT NULL COMMENT '修改人员[sys_user]',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '修改时间',
  `memo` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`),
  KEY `idx_config_flag` (`flag`),
  KEY `idx_config_deleted_flag` (`deleted`,`flag`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_config
-- ----------------------------
BEGIN;
INSERT INTO `sys_config` (`id`, `uuid`, `name`, `flag`, `type`, `val`, `content`, `status`, `deleted`, `tenant_id`, `create_by`, `create_time`, `update_by`, `update_time`, `memo`) VALUES (1, '6702082748514304', '系统开关', 'Execution', 1, 'true', NULL, 1, 0, NULL, 2, '2025-02-05 14:16:51', 2, '2025-02-05 14:16:51', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) NOT NULL COMMENT '名称(*)',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '上级部门',
  `parent_name` varchar(255) DEFAULT NULL COMMENT '上级部门名',
  `path` varchar(255) DEFAULT NULL COMMENT '关联路径',
  `path_name` varchar(255) DEFAULT NULL COMMENT '关联路径名',
  `full_name` varchar(255) DEFAULT NULL COMMENT '全称',
  `brief` varchar(255) DEFAULT NULL COMMENT '简述',
  `code` varchar(255) DEFAULT NULL COMMENT '标识',
  `type` int(11) DEFAULT NULL COMMENT '类型',
  `leader` varchar(255) DEFAULT NULL COMMENT '负责人',
  `count` int(11) DEFAULT NULL COMMENT '数量',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '所属机构[sys_host]',
  `status` int(11) DEFAULT '1' COMMENT '状态{1:正常,0:禁用}',
  `deleted` int(11) DEFAULT '0' COMMENT '是否删除{1:是,0:否}',
  `create_time` datetime DEFAULT NULL COMMENT '添加时间',
  `create_by` bigint(20) DEFAULT NULL COMMENT '添加人员[sys_user]',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint(20) DEFAULT NULL COMMENT '修改人员[sys_user]',
  `memo` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `full_name`, `brief`, `code`, `type`, `leader`, `count`, `sort`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (6, 'R&D Center', 0, NULL, '', '', '研发中心', NULL, NULL, NULL, 'Chris Brown', NULL, 3, 1, 1, 0, '2024-02-20 13:12:14', 2, '2024-09-10 16:55:14', 2, NULL);
INSERT INTO `sys_dept` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `full_name`, `brief`, `code`, `type`, `leader`, `count`, `sort`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (7, 'Human Resources Department', 0, NULL, '', '', '人事部', NULL, NULL, NULL, 'Sarah Miller', NULL, 4, 1, 1, 0, '2024-02-20 13:13:12', 2, '2024-09-10 16:54:54', 2, NULL);
INSERT INTO `sys_dept` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `full_name`, `brief`, `code`, `type`, `leader`, `count`, `sort`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (8, 'Production Workshop', 0, NULL, '', '', '生产车间', NULL, NULL, NULL, 'David Smith', NULL, 6, 1, 1, 0, '2024-02-20 13:13:28', 2, '2024-09-10 16:54:42', 2, NULL);
INSERT INTO `sys_dept` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `full_name`, `brief`, `code`, `type`, `leader`, `count`, `sort`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (9, 'Sales Department', 0, NULL, '', '', '销售部', NULL, NULL, NULL, 'Emma Martin', NULL, 2, 1, 1, 0, '2024-02-20 13:13:51', 2, '2024-09-10 16:55:07', 2, NULL);
INSERT INTO `sys_dept` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `full_name`, `brief`, `code`, `type`, `leader`, `count`, `sort`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (10, 'President’s Office', 0, NULL, '', '', '总裁办', NULL, NULL, NULL, 'James Anderson', NULL, 1, 1, 1, 0, '2024-02-20 13:14:04', 2, '2024-09-10 16:52:27', 2, NULL);
INSERT INTO `sys_dept` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `full_name`, `brief`, `code`, `type`, `leader`, `count`, `sort`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (11, 'Operations Department', 0, NULL, '', '', '运营部', NULL, NULL, NULL, 'Daniel Taylor', NULL, 5, 1, 1, 0, '2024-02-20 13:14:24', 2, '2024-09-10 16:54:48', 2, NULL);
INSERT INTO `sys_dept` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `full_name`, `brief`, `code`, `type`, `leader`, `count`, `sort`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (12, 'Software Department', 6, 'R&D Center', '6', 'R&D Center', '软件部', NULL, NULL, NULL, 'Andrew Clark', NULL, 1, 1, 1, 0, '2024-02-20 13:22:40', 2, '2024-09-10 16:55:00', 2, NULL);
INSERT INTO `sys_dept` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `full_name`, `brief`, `code`, `type`, `leader`, `count`, `sort`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (13, 'Electrical Department', 6, 'R&D Center', '6', 'R&D Center', '电气部', NULL, NULL, NULL, 'Joshua Harris', NULL, 2, 1, 1, 0, '2024-02-20 13:22:49', 2, '2024-09-10 16:55:20', 2, NULL);
INSERT INTO `sys_dept` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `full_name`, `brief`, `code`, `type`, `leader`, `count`, `sort`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (14, 'Mechanical Department', 6, 'R&D Center', '6', 'R&D Center', '机械部', NULL, NULL, NULL, 'Matthew Wilson', NULL, 3, 1, 1, 0, '2024-02-20 13:22:57', 2, '2024-09-10 16:55:27', 2, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_host
-- ----------------------------
DROP TABLE IF EXISTS `sys_host`;
CREATE TABLE `sys_host` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) NOT NULL COMMENT '名称(*)',
  `status` int(11) DEFAULT '1' COMMENT '状态{1:正常,0:禁用}',
  `deleted` int(11) DEFAULT '0' COMMENT '是否删除{1:是,0:否}',
  `create_time` datetime DEFAULT NULL COMMENT '添加时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `memo` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_host
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) NOT NULL COMMENT '名称(*)',
  `parent_id` bigint(20) DEFAULT NULL COMMENT '上级菜单',
  `parent_name` varchar(255) DEFAULT NULL COMMENT '上级菜单名',
  `path` varchar(255) DEFAULT NULL COMMENT '关联路径',
  `path_name` varchar(255) DEFAULT NULL COMMENT '关联路径名',
  `route` varchar(255) DEFAULT NULL COMMENT '路由地址',
  `component` varchar(255) DEFAULT NULL COMMENT '页面组件',
  `brief` varchar(255) DEFAULT NULL COMMENT '简述',
  `code` varchar(255) DEFAULT NULL COMMENT '标识',
  `type` int(11) DEFAULT NULL COMMENT '类型{0:菜单,1:按钮}',
  `authority` varchar(255) DEFAULT NULL COMMENT '权限标识',
  `icon` varchar(255) DEFAULT NULL COMMENT '菜单图标',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `meta` varchar(255) DEFAULT NULL COMMENT '元信息',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '所属机构[sys_host]',
  `status` int(11) DEFAULT '1' COMMENT '状态{1:正常,0:禁用}',
  `deleted` int(11) DEFAULT '0' COMMENT '是否删除{1:是,0:否}',
  `create_time` datetime DEFAULT NULL COMMENT '添加时间',
  `create_by` bigint(20) DEFAULT NULL COMMENT '添加人员[sys_user]',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint(20) DEFAULT NULL COMMENT '修改人员[sys_user]',
  `memo` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=194 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (1, 'menu.system', 0, NULL, '', '', '/system', NULL, NULL, NULL, 0, NULL, 'Settings', 10, NULL, 1, 1, 0, NULL, NULL, '2024-09-13 08:23:51', 2, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (2, 'menu.user', 1, '系统管理', '1', '系统管理', '/system/user', 'user', NULL, NULL, 0, NULL, 'People', 1, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (3, '查询用户', 2, '用户管理', '1,2', '系统管理,用户管理', NULL, NULL, NULL, NULL, 1, 'system:user:list', NULL, 1, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (4, '添加用户', 2, '用户管理', '1,2', '系统管理,用户管理', NULL, NULL, NULL, NULL, 1, 'system:user:save', NULL, 2, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (5, '修改用户', 2, '用户管理', '1,2', '系统管理,用户管理', NULL, NULL, NULL, NULL, 1, 'system:user:update', NULL, 3, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (6, '删除用户', 2, '用户管理', '1,2', '系统管理,用户管理', NULL, NULL, NULL, NULL, 1, 'system:user:remove', NULL, 4, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (7, 'menu.role', 1, '系统管理', '1', '系统管理', '/system/role', 'role', NULL, NULL, 0, NULL, 'Style', 2, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (8, '查询角色', 7, '角色管理', '1,7', '系统管理,角色管理', NULL, NULL, NULL, NULL, 1, 'system:role:list', NULL, 1, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (9, '添加角色', 7, '角色管理', '1,7', '系统管理,角色管理', NULL, NULL, NULL, NULL, 1, 'system:role:save', NULL, 2, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (10, '修改角色', 7, '角色管理', '1,7', '系统管理,角色管理', NULL, NULL, NULL, NULL, 1, 'system:role:update', NULL, 3, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (11, '删除角色', 7, '角色管理', '1,7', '系统管理,角色管理', NULL, NULL, NULL, NULL, 1, 'system:role:remove', NULL, 4, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (12, 'menu.menu', 1, '系统管理', '1', '系统管理', '/system/menu', 'menu', NULL, NULL, 0, NULL, 'MenuOpen', 3, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (13, '查询菜单', 12, '菜单管理', '1,12', '系统管理,菜单管理', NULL, NULL, NULL, NULL, 1, 'system:menu:list', NULL, 1, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (14, '添加菜单', 12, '菜单管理', '1,12', '系统管理,菜单管理', NULL, NULL, NULL, NULL, 1, 'system:menu:save', NULL, 2, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (15, '修改菜单', 12, '菜单管理', '1,12', '系统管理,菜单管理', NULL, NULL, NULL, NULL, 1, 'system:menu:update', NULL, 3, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (16, '删除菜单', 12, '菜单管理', '1,12', '系统管理,菜单管理', NULL, NULL, NULL, NULL, 1, 'system:menu:remove', NULL, 4, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (17, 'menu.host', 1, 'menu.system', '1', 'menu.system', '/system/host', 'host', NULL, NULL, 0, NULL, 'TripOrigin', 9, NULL, 1, 1, 0, NULL, NULL, '2024-09-10 15:07:40', 2, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (18, '查询机构', 17, '机构管理', '1,17', '系统管理,机构管理', NULL, NULL, NULL, NULL, 1, 'system:host:list', NULL, 1, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (19, '添加机构', 17, '机构管理', '1,17', '系统管理,机构管理', NULL, NULL, NULL, NULL, 1, 'system:host:save', NULL, 2, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (20, '修改机构', 17, '机构管理', '1,17', '系统管理,机构管理', NULL, NULL, NULL, NULL, 1, 'system:host:update', NULL, 3, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (21, '删除机构', 17, '机构管理', '1,17', '系统管理,机构管理', NULL, NULL, NULL, NULL, 1, 'system:host:remove', NULL, 4, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (22, 'menu.department', 1, 'menu.system', '1', 'menu.system', '/system/dept', 'dept', NULL, NULL, 0, NULL, 'Groups', 4, NULL, 1, 1, 0, NULL, NULL, '2024-09-10 15:07:34', 2, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (23, '查询部门', 22, '部门管理', '1,22', '系统管理,部门管理', NULL, NULL, NULL, NULL, 1, 'system:dept:list', NULL, 0, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (24, '添加部门', 22, '部门管理', '1,22', '系统管理,部门管理', NULL, NULL, NULL, NULL, 1, 'system:dept:save', NULL, 1, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (25, '修改部门', 22, '部门管理', '1,22', '系统管理,部门管理', NULL, NULL, NULL, NULL, 1, 'system:dept:update', NULL, 2, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (26, '删除部门', 22, '部门管理', '1,22', '系统管理,部门管理', NULL, NULL, NULL, NULL, 1, 'system:dept:remove', NULL, 3, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (27, 'menu.token', 1, '系统管理', '1', '系统管理', '/system/userLogin', 'userLogin', NULL, NULL, 0, NULL, 'Token', 6, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (28, '查询登录日志', 27, '登录日志', '1,27', '系统管理,登录日志', NULL, NULL, NULL, NULL, 1, 'system:userLogin:list', NULL, 0, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (29, '添加登录日志', 27, '登录日志', '1,27', '系统管理,登录日志', NULL, NULL, NULL, NULL, 1, 'system:userLogin:save', NULL, 1, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (30, '修改登录日志', 27, '登录日志', '1,27', '系统管理,登录日志', NULL, NULL, NULL, NULL, 1, 'system:userLogin:update', NULL, 2, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (31, '删除登录日志', 27, '登录日志', '1,27', '系统管理,登录日志', NULL, NULL, NULL, NULL, 1, 'system:userLogin:remove', NULL, 3, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (32, 'menu.operation', 1, 'menu.system', '1', 'menu.system', '/system/operationRecord', 'operationRecord', NULL, NULL, 0, NULL, 'Dvr', 5, NULL, 1, 1, 0, NULL, NULL, '2024-09-10 15:08:04', 2, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (33, '查询操作日志', 32, '操作日志', '1,32', '系统管理,操作日志', NULL, NULL, NULL, NULL, 1, 'system:operationRecord:list', NULL, 0, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (34, '添加操作日志', 32, '操作日志', '1,32', '系统管理,操作日志', NULL, NULL, NULL, NULL, 1, 'system:operationRecord:save', NULL, 1, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (35, '修改操作日志', 32, '操作日志', '1,32', '系统管理,操作日志', NULL, NULL, NULL, NULL, 1, 'system:operationRecord:update', NULL, 2, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (36, '删除操作日志', 32, '操作日志', '1,32', '系统管理,操作日志', NULL, NULL, NULL, NULL, 1, 'system:operationRecord:remove', NULL, 3, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (37, 'menu.config', 1, 'menu.system', '1', 'menu.system', '/system/config', 'config', NULL, NULL, 0, NULL, 'ConfirmationNumber', 7, NULL, 1, 1, 0, NULL, NULL, '2024-09-10 15:08:20', 2, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (38, 'Query Config', 37, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'system:config:list', NULL, 0, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (39, 'Create Config', 37, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'system:config:save', NULL, 1, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (40, 'Update Config', 37, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'system:config:update', NULL, 2, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (41, 'Delete Config', 37, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'system:config:remove', NULL, 3, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (42, 'menu.tenant', 1, 'menu.system', '1', 'menu.system', '/system/tenant', 'tenant', NULL, NULL, 0, NULL, 'Engineering', 8, NULL, 1, 1, 0, NULL, NULL, '2024-09-10 15:08:26', 2, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (43, 'Query Tenant', 42, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'system:tenant:list', NULL, 0, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (44, 'Create Tenant', 42, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'system:tenant:save', NULL, 1, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (45, 'Update Tenant', 42, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'system:tenant:update', NULL, 2, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `sys_menu` (`id`, `name`, `parent_id`, `parent_name`, `path`, `path_name`, `route`, `component`, `brief`, `code`, `type`, `authority`, `icon`, `sort`, `meta`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (46, 'Delete Tenant', 42, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 'system:tenant:remove', NULL, 3, NULL, 1, 1, 0, NULL, NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_operation_record
-- ----------------------------
DROP TABLE IF EXISTS `sys_operation_record`;
CREATE TABLE `sys_operation_record` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `namespace` varchar(255) DEFAULT NULL COMMENT '名称空间(*)',
  `url` varchar(255) DEFAULT NULL COMMENT '接口地址',
  `appkey` varchar(255) DEFAULT NULL COMMENT '平台密钥',
  `timestamp` varchar(255) DEFAULT NULL COMMENT '时间戳',
  `client_ip` varchar(255) DEFAULT NULL COMMENT '客户端IP',
  `request` longtext COMMENT '请求内容',
  `response` longtext COMMENT '响应内容',
  `spend_time` int(11) DEFAULT NULL COMMENT '消耗时间',
  `err` longtext COMMENT '异常内容',
  `result` int(11) DEFAULT NULL COMMENT '结果{1:成功,0:失败}',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户[sys_user]',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '所属机构[sys_host]',
  `create_time` datetime DEFAULT NULL COMMENT '添加时间',
  `memo` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_operation_record
-- ----------------------------
BEGIN;
INSERT INTO `sys_operation_record` (`id`, `namespace`, `url`, `appkey`, `timestamp`, `client_ip`, `request`, `response`, `spend_time`, `err`, `result`, `user_id`, `tenant_id`, `create_time`, `memo`) VALUES (1, 'Create Config', '/rsf-server/config/save', NULL, '1738736211245', '127.0.0.1', '{\"createBy\":2,\"createBy$\":\"ROOT\",\"createTime\":1738736211251,\"createTime$\":\"2025-02-05 14:16:51\",\"flag\":\"Execution\",\"id\":1,\"name\":\"系统开关\",\"status\":1,\"status$\":\"正常\",\"statusBool\":true,\"type\":1,\"type$\":\"boolean\",\"updateBy\":2,\"updateBy$\":\"ROOT\",\"updateTime\":1738736211251,\"updateTime$\":\"2025-02-05 14:16:51\",\"uuid\":\"6702082748514304\",\"val\":\"true\"} ', '{\"msg\":\"Save Success\",\"code\":200,\"data\":{\"createBy\":2,\"createBy$\":\"ROOT\",\"createTime\":1738736211251,\"createTime$\":\"2025-02-05 14:16:51\",\"flag\":\"Execution\",\"id\":1,\"name\":\"系统开关\",\"status\":1,\"status$\":\"正常\",\"statusBool\":true,\"type\":1,\"type$\":\"boolean\",\"updateBy\":2,\"updateBy$\":\"ROOT\",\"updateTime\":1738736211251,\"updateTime$\":\"2025-02-05 14:16:51\",\"uuid\":\"6702082748514304\",\"val\":\"true\"}}', 15, NULL, 1, 2, 1, '2025-02-05 14:16:51', NULL);
INSERT INTO `sys_operation_record` (`id`, `namespace`, `url`, `appkey`, `timestamp`, `client_ip`, `request`, `response`, `spend_time`, `err`, `result`, `user_id`, `tenant_id`, `create_time`, `memo`) VALUES (2, 'Update Tenant', '/rsf-server/tenant/update', NULL, '1738736435414', '127.0.0.1', '{\"createTime$\":\"\",\"id\":4,\"name\":\"China\",\"status\":1,\"statusBool\":true,\"updateTime\":1738736435414,\"updateTime$\":\"2025-02-05 14:20:35\"} ', '{\"msg\":\"Update Success\",\"code\":200,\"data\":{\"createTime$\":\"\",\"id\":4,\"name\":\"China\",\"status\":1,\"statusBool\":true,\"updateTime\":1738736435414,\"updateTime$\":\"2025-02-05 14:20:35\"}}', 11, NULL, 1, 2, 1, '2025-02-05 14:20:35', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) NOT NULL COMMENT '名称(*)',
  `code` varchar(255) DEFAULT NULL COMMENT '标识',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '所属机构[sys_host]',
  `status` int(11) DEFAULT '1' COMMENT '状态{1:正常,0:禁用}',
  `deleted` int(11) DEFAULT '0' COMMENT '是否删除{1:是,0:否}',
  `create_time` datetime DEFAULT NULL COMMENT '添加时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `memo` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`id`, `name`, `code`, `tenant_id`, `status`, `deleted`, `create_time`, `update_time`, `memo`) VALUES (1, '管理员', 'admin', 1, 1, 0, NULL, '2024-09-06 15:13:11', NULL);
INSERT INTO `sys_role` (`id`, `name`, `code`, `tenant_id`, `status`, `deleted`, `create_time`, `update_time`, `memo`) VALUES (2, '操作员', 'Operator', NULL, 1, 0, '2024-09-03 16:16:46', '2024-09-10 16:48:33', '访客');
INSERT INTO `sys_role` (`id`, `name`, `code`, `tenant_id`, `status`, `deleted`, `create_time`, `update_time`, `memo`) VALUES (3, '维修工程师', 'Maintenance Engineer', NULL, 1, 0, '2024-09-10 16:48:44', '2024-09-10 16:48:44', NULL);
INSERT INTO `sys_role` (`id`, `name`, `code`, `tenant_id`, `status`, `deleted`, `create_time`, `update_time`, `memo`) VALUES (4, '调度员', 'Dispatcher', NULL, 1, 0, '2024-09-10 16:48:53', '2024-09-10 16:48:53', NULL);
INSERT INTO `sys_role` (`id`, `name`, `code`, `tenant_id`, `status`, `deleted`, `create_time`, `update_time`, `memo`) VALUES (5, '数据分析师', 'DataAnalyst', NULL, 1, 0, '2024-09-10 16:49:11', '2024-09-10 16:49:11', NULL);
INSERT INTO `sys_role` (`id`, `name`, `code`, `tenant_id`, `status`, `deleted`, `create_time`, `update_time`, `memo`) VALUES (6, '安全监控员', 'SafetyMonitor', NULL, 1, 0, '2024-09-10 16:49:20', '2024-09-10 16:49:20', NULL);
INSERT INTO `sys_role` (`id`, `name`, `code`, `tenant_id`, `status`, `deleted`, `create_time`, `update_time`, `memo`) VALUES (7, '项目经理', 'ProjectManager', NULL, 1, 0, '2024-09-10 16:49:31', '2024-09-10 16:49:31', NULL);
INSERT INTO `sys_role` (`id`, `name`, `code`, `tenant_id`, `status`, `deleted`, `create_time`, `update_time`, `memo`) VALUES (8, '用户支持', 'UserSupport', NULL, 1, 0, '2024-09-10 16:49:45', '2024-09-10 16:49:45', NULL);
INSERT INTO `sys_role` (`id`, `name`, `code`, `tenant_id`, `status`, `deleted`, `create_time`, `update_time`, `memo`) VALUES (9, '仓库管理员', 'WarehouseManager', NULL, 1, 0, '2024-09-10 16:50:03', '2024-09-10 16:50:03', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role_id` bigint(20) NOT NULL,
  `menu_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3450 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3262, 1, 193);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3263, 1, 77);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3264, 1, 172);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3265, 1, 23);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3266, 1, 92);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3267, 1, 57);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3268, 1, 67);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3269, 1, 117);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3270, 1, 102);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3271, 1, 191);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3272, 1, 137);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3273, 1, 38);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3274, 1, 127);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3275, 1, 107);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3276, 1, 167);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3277, 1, 177);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3278, 1, 162);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3279, 1, 62);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3280, 1, 33);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3281, 1, 82);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3282, 1, 43);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3283, 1, 28);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3284, 1, 187);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3285, 1, 152);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3286, 1, 72);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3287, 1, 182);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3288, 1, 142);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3289, 1, 97);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3290, 1, 112);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3291, 1, 87);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3292, 1, 132);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3293, 1, 161);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3294, 1, 122);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3295, 1, 192);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3296, 1, 157);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3297, 1, 147);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3298, 1, 83);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3299, 1, 3);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3300, 1, 29);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3301, 1, 188);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3302, 1, 148);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3303, 1, 58);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3304, 1, 173);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3305, 1, 44);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3306, 1, 108);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3307, 1, 121);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3308, 1, 183);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3309, 1, 63);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3310, 1, 34);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3311, 1, 123);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3312, 1, 24);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3313, 1, 73);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3314, 1, 166);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3315, 1, 39);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3316, 1, 88);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3317, 1, 143);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3318, 1, 13);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3319, 1, 54);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3320, 1, 8);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3321, 1, 93);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3322, 1, 96);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3323, 1, 168);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3324, 1, 178);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3325, 1, 118);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3326, 1, 2);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3327, 1, 103);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3328, 1, 158);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3329, 1, 133);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3330, 1, 18);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3331, 1, 68);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3332, 1, 128);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3333, 1, 98);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3334, 1, 78);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3335, 1, 153);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3336, 1, 106);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3337, 1, 138);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3338, 1, 163);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3339, 1, 113);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3340, 1, 174);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3341, 1, 69);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3342, 1, 189);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3343, 1, 154);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3344, 1, 149);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3345, 1, 4);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3346, 1, 104);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3347, 1, 30);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3348, 1, 52);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3349, 1, 7);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3350, 1, 164);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3351, 1, 45);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3352, 1, 79);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3353, 1, 126);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3354, 1, 169);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3355, 1, 109);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3356, 1, 139);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3357, 1, 159);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3358, 1, 176);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3359, 1, 144);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3360, 1, 179);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3361, 1, 99);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3362, 1, 184);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3363, 1, 84);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3364, 1, 119);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3365, 1, 40);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3366, 1, 134);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3367, 1, 74);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3368, 1, 59);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3369, 1, 25);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3370, 1, 9);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3371, 1, 19);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3372, 1, 89);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3373, 1, 71);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3374, 1, 35);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3375, 1, 124);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3376, 1, 64);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3377, 1, 114);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3378, 1, 101);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3379, 1, 94);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3380, 1, 14);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3381, 1, 129);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3382, 1, 181);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3383, 1, 36);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3384, 1, 90);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3385, 1, 5);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3386, 1, 110);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3387, 1, 120);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3388, 1, 53);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3389, 1, 31);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3390, 1, 60);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3391, 1, 165);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3392, 1, 46);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3393, 1, 156);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3394, 1, 155);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3395, 1, 100);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3396, 1, 26);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3397, 1, 170);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3398, 1, 85);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3399, 1, 10);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3400, 1, 115);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3401, 1, 86);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3402, 1, 125);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3403, 1, 175);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3404, 1, 150);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3405, 1, 41);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3406, 1, 20);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3407, 1, 145);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3408, 1, 111);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3409, 1, 185);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3410, 1, 12);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3411, 1, 190);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3412, 1, 180);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3413, 1, 105);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3414, 1, 80);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3415, 1, 70);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3416, 1, 140);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3417, 1, 75);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3418, 1, 95);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3419, 1, 65);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3420, 1, 130);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3421, 1, 135);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3422, 1, 160);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3423, 1, 15);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3424, 1, 61);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3425, 1, 11);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3426, 1, 81);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3427, 1, 21);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3428, 1, 186);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3429, 1, 16);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3430, 1, 22);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3431, 1, 6);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3432, 1, 55);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3433, 1, 116);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3434, 1, 32);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3435, 1, 91);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3436, 1, 171);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3437, 1, 66);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3438, 1, 27);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3439, 1, 141);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3440, 1, 37);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3441, 1, 146);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3442, 1, 42);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3443, 1, 151);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3444, 1, 17);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3445, 1, 131);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3446, 1, 1);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3447, 1, 56);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3448, 1, 136);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3449, 1, 76);
COMMIT;

-- ----------------------------
-- Table structure for sys_tenant
-- ----------------------------
DROP TABLE IF EXISTS `sys_tenant`;
CREATE TABLE `sys_tenant` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) NOT NULL COMMENT '名称(*)',
  `status` int(1) DEFAULT '1' COMMENT '状态{1:正常,0:禁用}',
  `deleted` int(1) DEFAULT '0' COMMENT '是否删除{1:是,0:否}',
  `create_time` datetime DEFAULT NULL COMMENT '添加时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `memo` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_tenant
-- ----------------------------
BEGIN;
INSERT INTO `sys_tenant` (`id`, `name`, `status`, `deleted`, `create_time`, `update_time`, `memo`) VALUES (3, 'Vincent', 0, 0, NULL, '2024-09-03 15:31:56', 'aa');
INSERT INTO `sys_tenant` (`id`, `name`, `status`, `deleted`, `create_time`, `update_time`, `memo`) VALUES (4, 'China', 1, 0, NULL, '2025-02-05 14:20:35', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `username` varchar(255) NOT NULL COMMENT '账号',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `nickname` varchar(255) DEFAULT NULL COMMENT '昵称(*)',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `code` varchar(255) DEFAULT NULL COMMENT '工号',
  `sex` int(11) DEFAULT '0' COMMENT '性别{0:未知,1:男,2:女}',
  `phone` varchar(255) DEFAULT NULL COMMENT '手机号',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `email_verified` int(11) DEFAULT '0' COMMENT '邮箱验证{0:否,1:是}',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '所属部门[sys_dept]',
  `real_name` varchar(255) DEFAULT NULL COMMENT '真实姓名',
  `id_card` varchar(255) DEFAULT NULL COMMENT '身份证号',
  `birthday` varchar(10) DEFAULT NULL COMMENT '出生日期',
  `introduction` varchar(255) DEFAULT NULL COMMENT '个人简介',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '所属机构[sys_host]',
  `status` int(11) DEFAULT '1' COMMENT '状态{1:正常,0:禁用}',
  `deleted` int(11) DEFAULT '0' COMMENT '是否删除{1:是,0:否}',
  `create_time` datetime DEFAULT NULL COMMENT '添加时间',
  `create_by` bigint(20) DEFAULT NULL COMMENT '添加人员[sys_user]',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` bigint(20) DEFAULT NULL COMMENT '修改人员[sys_user]',
  `memo` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `avatar`, `code`, `sex`, `phone`, `email`, `email_verified`, `dept_id`, `real_name`, `id_card`, `birthday`, `introduction`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (1, 'super', NULL, 'SUPER', NULL, NULL, 0, NULL, NULL, 0, 10, NULL, NULL, NULL, NULL, NULL, 1, 0, '2024-02-09 13:04:22', NULL, '2024-11-14 15:23:17', 2, NULL);
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `avatar`, `code`, `sex`, `phone`, `email`, `email_verified`, `dept_id`, `real_name`, `id_card`, `birthday`, `introduction`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (2, 'root', '$2a$10$NWQhgr9zt.1UNHoPIJYAreKmTFezZ26ZHb766StqiYXi/OcaZj9VK', 'ROOT', NULL, '1234', 1, '15988786205', '', 0, 10, 'vincent', '330421199511233211', NULL, 'software enginer', 1, 1, 0, '2024-09-09 13:04:22', NULL, '2024-11-14 15:23:09', 2, NULL);
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `avatar`, `code`, `sex`, `phone`, `email`, `email_verified`, `dept_id`, `real_name`, `id_card`, `birthday`, `introduction`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (15, '1-202-555-0101', '', 'Andrew Clark', NULL, '', 1, '', 't1341870251@163.com', 0, 10, '', '', NULL, NULL, NULL, 1, 0, '2024-09-10 11:04:50', 2, '2024-09-10 16:58:58', 2, 'aa');
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `avatar`, `code`, `sex`, `phone`, `email`, `email_verified`, `dept_id`, `real_name`, `id_card`, `birthday`, `introduction`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (16, '1-202-555-0102', '', 'Joshua Lewis', NULL, NULL, 1, NULL, NULL, 0, 12, NULL, NULL, NULL, NULL, NULL, 1, 0, '2024-09-10 11:06:06', 2, '2024-09-10 16:59:32', 2, NULL);
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `avatar`, `code`, `sex`, `phone`, `email`, `email_verified`, `dept_id`, `real_name`, `id_card`, `birthday`, `introduction`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (17, '1-202-555-0103', '', 'Ethan Robinson', NULL, NULL, 1, NULL, NULL, 0, 13, NULL, NULL, NULL, '', NULL, 1, 0, '2024-09-10 11:13:12', 2, '2024-09-10 16:59:56', 2, NULL);
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `avatar`, `code`, `sex`, `phone`, `email`, `email_verified`, `dept_id`, `real_name`, `id_card`, `birthday`, `introduction`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (18, '1-202-555-0104', '', 'Daniel Walker', NULL, '', 1, NULL, NULL, 0, 11, NULL, NULL, NULL, NULL, NULL, 1, 0, '2024-09-10 14:27:58', 2, '2024-09-10 17:00:25', 2, NULL);
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `avatar`, `code`, `sex`, `phone`, `email`, `email_verified`, `dept_id`, `real_name`, `id_card`, `birthday`, `introduction`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (19, '1-202-555-0105', '', 'Alexander Hall', NULL, NULL, 1, '159887862051', NULL, 0, 8, NULL, 'aa', NULL, NULL, NULL, 1, 0, '2024-09-10 14:56:44', 2, '2024-09-10 17:00:48', 2, NULL);
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `avatar`, `code`, `sex`, `phone`, `email`, `email_verified`, `dept_id`, `real_name`, `id_card`, `birthday`, `introduction`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (20, '1-202-555-0106', '$2a$10$.xOeEvSa7t29RZuY/85DAenT3b.N80vubC2OnlxBnAbp53YVRzxqa', 'Ryan Allen', NULL, NULL, 0, NULL, NULL, 0, 13, NULL, NULL, NULL, NULL, NULL, 1, 0, '2024-09-10 17:05:52', 2, '2024-09-10 17:05:52', 2, NULL);
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `avatar`, `code`, `sex`, `phone`, `email`, `email_verified`, `dept_id`, `real_name`, `id_card`, `birthday`, `introduction`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (21, '1-202-555-0201', '', 'Emily Harris', NULL, NULL, 2, NULL, NULL, 0, 11, NULL, NULL, NULL, NULL, NULL, 1, 0, '2024-09-10 17:06:14', 2, '2024-09-10 17:06:21', 2, NULL);
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `avatar`, `code`, `sex`, `phone`, `email`, `email_verified`, `dept_id`, `real_name`, `id_card`, `birthday`, `introduction`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (22, '1-202-555-0202', '$2a$10$Donommx9.9zYmJTksO8tO.MZXBr5lsjHGbB1me38c44to34y0OUmu', 'Amanda Clark', NULL, NULL, 2, NULL, NULL, 0, 9, NULL, NULL, NULL, NULL, NULL, 1, 0, '2024-09-10 17:06:40', 2, '2024-09-10 17:06:40', 2, NULL);
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `avatar`, `code`, `sex`, `phone`, `email`, `email_verified`, `dept_id`, `real_name`, `id_card`, `birthday`, `introduction`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (23, '1-202-555-0203', '$2a$10$d7qQLr21NGuHCsrkVCmFluY5fwhhgRXM1KONs815fqQu167taS27S', 'Laura Lewis', NULL, NULL, 2, NULL, NULL, 0, 8, NULL, NULL, NULL, NULL, NULL, 1, 0, '2024-09-10 17:06:59', 2, '2024-09-10 17:06:59', 2, NULL);
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `avatar`, `code`, `sex`, `phone`, `email`, `email_verified`, `dept_id`, `real_name`, `id_card`, `birthday`, `introduction`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (24, '1-202-555-0204', '$2a$10$yw2.WjeZtObppG.TTe/7Re71JrnqVefB20/FhoKZgIHOQXp6ZTGRe', 'Megan Robinson', NULL, NULL, 2, NULL, NULL, 0, 12, NULL, NULL, NULL, NULL, NULL, 1, 0, '2024-09-10 17:07:19', 2, '2024-09-10 17:07:19', 2, NULL);
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `avatar`, `code`, `sex`, `phone`, `email`, `email_verified`, `dept_id`, `real_name`, `id_card`, `birthday`, `introduction`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (25, '1-202-555-0205', '$2a$10$sqy0zp2EM2tgIvywnvasqeczRn9XuxpqQs4Y3.n5FuL26DugJy/pa', 'Rachel Walker', NULL, NULL, 2, NULL, NULL, 0, 10, NULL, NULL, NULL, NULL, NULL, 1, 0, '2024-09-10 17:07:41', 2, '2024-09-10 17:07:41', 2, NULL);
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `avatar`, `code`, `sex`, `phone`, `email`, `email_verified`, `dept_id`, `real_name`, `id_card`, `birthday`, `introduction`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (26, '1-202-555-0206', '$2a$10$tqzMJsMZsiCYq56Tl.QHsO63ephjgq/pAXJB5hwhW9CpFEQsCRPWW', 'Natalie Hall', NULL, NULL, 2, NULL, NULL, 0, 14, NULL, NULL, NULL, NULL, NULL, 1, 0, '2024-09-10 17:08:00', 2, '2024-09-10 17:08:00', 2, NULL);
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `avatar`, `code`, `sex`, `phone`, `email`, `email_verified`, `dept_id`, `real_name`, `id_card`, `birthday`, `introduction`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (27, '1-202-555-0207', '$2a$10$q1ro90xkbv7TQmCKLrgb9etDmDFLENA6uggJt/YV8iOwEXveMcOwu', 'Hannah Allen', NULL, NULL, 2, NULL, NULL, 0, 13, NULL, NULL, NULL, NULL, NULL, 1, 0, '2024-09-10 17:08:16', 2, '2024-09-10 17:08:16', 2, NULL);
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `avatar`, `code`, `sex`, `phone`, `email`, `email_verified`, `dept_id`, `real_name`, `id_card`, `birthday`, `introduction`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (28, '1-202-555-0210', '$2a$10$AazS1k4yqNfTNjg8JAVKNe3PF4Bg8GOm39SaGrHVHDsHL.61nTZgO', 'Chloe Wright', NULL, NULL, 2, NULL, NULL, 0, 8, NULL, NULL, NULL, NULL, NULL, 1, 0, '2024-09-10 17:08:35', 2, '2024-09-10 17:08:35', 2, NULL);
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `avatar`, `code`, `sex`, `phone`, `email`, `email_verified`, `dept_id`, `real_name`, `id_card`, `birthday`, `introduction`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (29, '1-202-555-0113', '$2a$10$IR89jI.xU3u7BmbSbZ5jRuQb5U6e7yKlIhLbqvFCzKYNQaQRXwEdK', 'William Brooks', NULL, NULL, 1, NULL, NULL, 0, 0, NULL, NULL, NULL, NULL, NULL, 1, 0, '2024-09-10 17:08:54', 2, '2024-09-10 17:08:54', 2, NULL);
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `avatar`, `code`, `sex`, `phone`, `email`, `email_verified`, `dept_id`, `real_name`, `id_card`, `birthday`, `introduction`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (30, '1-202-555-0111', '$2a$10$ndnc1U0LVnAA3285rFNN2.UVLU07N4g5.k9.SVy63sdzIJHbXCyga', 'Michael Carter', NULL, NULL, 1, NULL, NULL, 0, 11, NULL, NULL, NULL, NULL, NULL, 1, 0, '2024-09-10 17:09:12', 2, '2024-09-10 17:09:12', 2, NULL);
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `avatar`, `code`, `sex`, `phone`, `email`, `email_verified`, `dept_id`, `real_name`, `id_card`, `birthday`, `introduction`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (31, '1-202-555-0108', '$2a$10$bDrj531wT1g3i8kF/W5rquXhb28EV/NaWtkK/izki34lGq1bKL8Z2', 'Lucas Scott', NULL, NULL, 1, NULL, NULL, 0, 12, NULL, NULL, NULL, NULL, NULL, 1, 0, '2024-09-10 17:09:32', 2, '2024-09-10 17:09:32', 2, NULL);
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `avatar`, `code`, `sex`, `phone`, `email`, `email_verified`, `dept_id`, `real_name`, `id_card`, `birthday`, `introduction`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (32, '1-202-555-0115', '$2a$10$yTg/iSVGtiy46xw0/8EuVOoo9UeGGla2nri4dkxxmqJqowcsKOIJ.', 'John Taylor', NULL, NULL, 1, NULL, NULL, 0, 9, NULL, NULL, NULL, NULL, NULL, 1, 0, '2024-09-10 17:09:51', 2, '2024-09-10 17:09:51', 2, NULL);
INSERT INTO `sys_user` (`id`, `username`, `password`, `nickname`, `avatar`, `code`, `sex`, `phone`, `email`, `email_verified`, `dept_id`, `real_name`, `id_card`, `birthday`, `introduction`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`) VALUES (33, '1-202-555-0215', '$2a$10$YuX3NlTUIevIsZ3Fy3akX.X6XI/IvFb3nVxdLxJDjwW9KAsFVAnQ.', 'Charlotte King', NULL, NULL, 2, NULL, NULL, 0, 10, NULL, NULL, NULL, NULL, NULL, 1, 0, '2024-09-10 17:10:09', 2, '2024-09-10 17:10:09', 2, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_login
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_login`;
CREATE TABLE `sys_user_login` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_id` bigint(20) NOT NULL COMMENT '用户[sys_user]',
  `tenant_id` bigint(20) DEFAULT NULL COMMENT '机构[sys_host]',
  `token` varchar(255) DEFAULT NULL COMMENT '密钥(*)',
  `ip` varchar(255) DEFAULT NULL COMMENT '登录ip',
  `type` int(11) DEFAULT NULL COMMENT '类型',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '添加时间',
  `system` varchar(255) DEFAULT NULL COMMENT '登录系统',
  `memo` varchar(255) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_user_login
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (1, 2, NULL, '[REDACTED], '127.0.0.1', 0, '2025-02-05 05:39:56', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (2, 2, NULL, '[REDACTED], '127.0.0.1', 0, '2025-02-05 07:20:04', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (3, 2, NULL, '[REDACTED], '127.0.0.1', 0, '2025-02-05 07:22:05', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (4, 2, NULL, '[REDACTED], '127.0.0.1', 0, '2025-02-05 07:30:59', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (5, 2, NULL, '[REDACTED], '127.0.0.1', 0, '2025-02-05 07:32:14', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL,
  `role_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (37, 15, 2);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (38, 15, 1);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (39, 16, 2);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (40, 16, 5);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (41, 17, 7);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (42, 17, 3);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (43, 18, 2);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (44, 18, 9);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (45, 19, 1);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (46, 19, 6);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (49, 20, 8);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (51, 21, 5);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (52, 22, 6);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (53, 23, 3);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (54, 24, 1);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (55, 25, 6);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (56, 26, 3);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (57, 27, 4);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (58, 28, 4);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (59, 29, 4);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (60, 29, 8);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (61, 30, 9);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (62, 31, 4);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (63, 31, 9);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (64, 32, 5);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (65, 33, 7);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (72, 2, 1);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (73, 1, 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
