/*
 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: 11/02/2025 10:55:56
*/

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, 1, 2, '2025-02-05 14:16:51', 2, '2025-02-05 14:16:51', NULL);
COMMIT;

-- ----------------------------
-- Table structure for sys_ai_param
-- ----------------------------
DROP TABLE IF EXISTS `sys_ai_param`;
CREATE TABLE `sys_ai_param` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `uuid` varchar(255) DEFAULT NULL COMMENT '编号',
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `model_code` varchar(255) DEFAULT NULL COMMENT '模型编码',
  `provider` varchar(255) DEFAULT NULL COMMENT '供应商',
  `chat_url` varchar(512) DEFAULT NULL COMMENT '聊天地址',
  `api_key` varchar(512) DEFAULT NULL COMMENT 'API密钥',
  `model_name` varchar(255) DEFAULT NULL COMMENT '模型名称',
  `system_prompt` text COMMENT '系统提示词',
  `max_context_messages` int(11) DEFAULT NULL COMMENT '上下文轮数',
  `default_flag` int(1) NOT NULL DEFAULT '0' COMMENT '默认模型{1:是,0:否}',
  `sort` int(11) 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_ai_param_model_code` (`model_code`),
  KEY `idx_ai_param_deleted_code` (`deleted`,`model_code`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_ai_param
-- ----------------------------
BEGIN;
INSERT INTO `sys_ai_param` (`id`, `uuid`, `name`, `model_code`, `provider`, `chat_url`, `api_key`, `model_name`, `system_prompt`, `max_context_messages`, `default_flag`, `sort`, `status`, `deleted`, `tenant_id`, `create_by`, `create_time`, `update_by`, `update_time`, `memo`) VALUES (1, '6702082748514305', 'DEEPSEEK', 'deepseek-ai/DeepSeek-V3.2', 'openai', 'https://api.siliconflow.cn', NULL, 'deepseek-ai/DeepSeek-V3.2', '你是WMS系统内的智能助手，回答时优先保持准确、简洁，并结合上下文帮助用户理解仓储业务。', 12, 1, 1, 1, 0, 1, 2, '2026-03-11 14:13:22', 2, '2026-03-11 15:03:30', '默认演示模型');
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=17 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 AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_host
-- ----------------------------
BEGIN;
INSERT INTO `sys_host` (`id`, `name`, `status`, `deleted`, `create_time`, `update_time`, `memo`) VALUES (1, '1', 1, 0, '2025-02-06 13:49:54', '2025-02-06 13:49:54', NULL);
INSERT INTO `sys_host` (`id`, `name`, `status`, `deleted`, `create_time`, `update_time`, `memo`) VALUES (2, '2', 1, 0, '2025-02-06 13:50:00', '2025-02-06 13:50:00', NULL);
INSERT INTO `sys_host` (`id`, `name`, `status`, `deleted`, `create_time`, `update_time`, `memo`) VALUES (3, '3', 1, 0, '2025-02-06 14:55:30', '2025-02-06 14:55:30', NULL);
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=47 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, 'menu.system', '1', 'menu.system', '/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, 'Query User', 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, 'Create User', 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, 'Update User', 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, 'Delete User', 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, 'menu.system', '1', 'menu.system', '/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, 'Query Role', 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, 'Create Role', 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, 'Update Role', 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, 'Delete Role', 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, 'menu.system', '1', 'menu.system', '/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, 'Query Menu', 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, 'Create Menu', 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, 'Update Menu', 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, 'Delete Menu', 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, 'Query Host', 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, 'Create Host', 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, 'Update Host', 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, 'Delete Host', 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, 'Query Department', 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, 'Create Department', 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, 'Update Department', 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, 'Delete Department', 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, 'menu.system', '1', 'menu.system', '/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, 'Query Token', 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, 'Create Token', 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, 'Update Token', 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, 'Delete Token', 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, 'Query Operation', 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, 'Create Operation', 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, 'Update Operation', 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, 'Delete Operation', 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, '1,37', 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, '1,37', 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, '1,37', 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, '1,37', 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, '1.42', 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, '1.42', 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, '1.42', 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, '1.42', NULL, NULL, NULL, NULL, NULL, 1, 'system:tenant: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 (47, 'menu.aiParam', 1, 'menu.system', '1', 'menu.system', '/system/aiParam', 'aiParam', NULL, NULL, 0, NULL, 'SmartToy', 9, NULL, 1, 1, 0, NULL, NULL, '2024-09-10 15:08:30', 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 (48, 'Query AiParam', 47, NULL, '1,47', NULL, NULL, NULL, NULL, NULL, 1, 'system:aiParam: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 (49, 'Create AiParam', 47, NULL, '1,47', NULL, NULL, NULL, NULL, NULL, 1, 'system:aiParam: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 (50, 'Update AiParam', 47, NULL, '1,47', NULL, NULL, NULL, NULL, NULL, 1, 'system:aiParam: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 (51, 'Delete AiParam', 47, NULL, '1,47', NULL, NULL, NULL, NULL, NULL, 1, 'system:aiParam: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 (52, 'Export AiParam', 47, NULL, '1,47', NULL, NULL, NULL, NULL, NULL, 1, 'system:aiParam:list', NULL, 4, 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=35 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);
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 (3, 'Create Host', '/rsf-server/host/save', NULL, '1738820994470', '127.0.0.1', '{\"createTime\":1738820994470,\"createTime$\":\"2025-02-06 13:49:54\",\"id\":1,\"name\":\"1\",\"status\":1,\"statusBool\":true,\"updateTime\":1738820994470,\"updateTime$\":\"2025-02-06 13:49:54\"} ', '{\"msg\":\"Save Success\",\"code\":200,\"data\":{\"createTime\":1738820994470,\"createTime$\":\"2025-02-06 13:49:54\",\"id\":1,\"name\":\"1\",\"status\":1,\"statusBool\":true,\"updateTime\":1738820994470,\"updateTime$\":\"2025-02-06 13:49:54\"}}', 55, NULL, 1, 2, 1, '2025-02-06 13:49:55', 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 (4, 'Create Host', '/rsf-server/host/save', NULL, '1738821000008', '127.0.0.1', '{\"createTime\":1738821000008,\"createTime$\":\"2025-02-06 13:50:00\",\"id\":2,\"name\":\"2\",\"status\":1,\"statusBool\":true,\"updateTime\":1738821000008,\"updateTime$\":\"2025-02-06 13:50:00\"} ', '{\"msg\":\"Save Success\",\"code\":200,\"data\":{\"createTime\":1738821000008,\"createTime$\":\"2025-02-06 13:50:00\",\"id\":2,\"name\":\"2\",\"status\":1,\"statusBool\":true,\"updateTime\":1738821000008,\"updateTime$\":\"2025-02-06 13:50:00\"}}', 4, NULL, 1, 2, 1, '2025-02-06 13:50:00', 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 (14, 'Update Tenant', '/rsf-server/tenant/update', NULL, '1738914313417', '127.0.0.1', '{\"createTime$\":\"\",\"flag\":\"001\",\"id\":1,\"name\":\"Google\",\"status\":1,\"statusBool\":true,\"updateTime\":1738914313417,\"updateTime$\":\"2025-02-07 15:45:13\"} ', '{\"msg\":\"Update Success\",\"code\":200,\"data\":{\"createTime$\":\"\",\"flag\":\"001\",\"id\":1,\"name\":\"Google\",\"status\":1,\"statusBool\":true,\"updateTime\":1738914313417,\"updateTime$\":\"2025-02-07 15:45:13\"}}', 11, NULL, 1, 2, 1, '2025-02-07 15:45:13', 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 (15, 'Update Tenant', '/rsf-server/tenant/update', NULL, '1738914319315', '127.0.0.1', '{\"createTime$\":\"\",\"flag\":\"002\",\"id\":2,\"name\":\"META\",\"status\":1,\"statusBool\":true,\"updateTime\":1738914319315,\"updateTime$\":\"2025-02-07 15:45:19\"} ', '{\"msg\":\"Update Success\",\"code\":200,\"data\":{\"createTime$\":\"\",\"flag\":\"002\",\"id\":2,\"name\":\"META\",\"status\":1,\"statusBool\":true,\"updateTime\":1738914319315,\"updateTime$\":\"2025-02-07 15:45:19\"}}', 6, NULL, 1, 2, 1, '2025-02-07 15:45:19', 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 (16, 'Update User', '/rsf-server/user/update', NULL, '1738977759775', '127.0.0.1', '{\"accountNonExpired\":true,\"accountNonLocked\":true,\"createTime$\":\"\",\"credentialsNonExpired\":true,\"enabled\":true,\"id\":19,\"idCard\":\"aa\",\"nickname\":\"Alexander Hall\",\"phone\":\"18368337803\",\"roleIds\":[1,6],\"sex\":1,\"sex$\":\"男\",\"status\":1,\"status$\":\"正常\",\"statusBool\":true,\"updateBy\":2,\"updateBy$\":\"ROOT\",\"updateTime\":1738977759790,\"updateTime$\":\"2025-02-08 09:22:39\",\"userRoleIds\":[1,6],\"username\":\"1-202-555-0105\"} ', '{\"msg\":\"Update Success\",\"code\":200,\"data\":{\"accountNonExpired\":true,\"accountNonLocked\":true,\"createTime$\":\"\",\"credentialsNonExpired\":true,\"enabled\":true,\"id\":19,\"idCard\":\"aa\",\"nickname\":\"Alexander Hall\",\"phone\":\"18368337803\",\"roleIds\":[1,6],\"sex\":1,\"sex$\":\"男\",\"status\":1,\"status$\":\"正常\",\"statusBool\":true,\"updateBy\":2,\"updateBy$\":\"ROOT\",\"updateTime\":1738977759790,\"updateTime$\":\"2025-02-08 09:22:39\",\"userRoleIds\":[1,6],\"username\":\"1-202-555-0105\"}}', 31, NULL, 1, 2, 1, '2025-02-08 09:22:40', 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 (17, 'Update UserInfo', '/rsf-server/auth/user', NULL, '1739001048279', '127.0.0.1', '{\"accountNonExpired\":true,\"accountNonLocked\":false,\"code\":\"1234\",\"createTime$\":\"\",\"credentialsNonExpired\":true,\"email\":\"\",\"enabled\":true,\"id\":2,\"idCard\":\"330421199511233211\",\"nickname\":\"ROOT\",\"phone\":\"15988786205\",\"realName\":\"vincent\",\"sex\":1,\"sex$\":\"男\",\"updateTime$\":\"\",\"userRoleIds\":[1]} ', '{\"msg\":\"Save Success\",\"code\":200,\"data\":{\"accountNonExpired\":true,\"accountNonLocked\":true,\"authorities\":[{\"authority\":\"system:operationRecord:list\",\"createTime$\":\"\",\"deleted\":0,\"id\":33,\"name\":\"查询操作日志\",\"parentId\":32,\"parentName\":\"操作日志\",\"path\":\"1,32\",\"pathName\":\"系统管理,操作日志\",\"sort\":0,\"status\":1,\"statusBool\":true,\"tenantId\":1,\"tenantId$\":\"Google\",\"type\":1,\"type$\":\"按钮\",\"updateTime$\":\"\"},{\"authority\":\"system:tenant:list\",\"createTime$\":\"\",\"deleted\":0,\"id\":43,\"name\":\"Query Tenant\",\"parentId\":42,\"sort\":0,\"status\":1,\"statusBool\":true,\"tenantId\":1,\"tenantId$\":\"Google\",\"type\":1,\"type$\":\"按钮\",\"updateTime$\":\"\"},{\"authority\":\"system:dept:list\",\"createTime$\":\"\",\"deleted\":0,\"id\":23,\"name\":\"查询部门\",\"parentId\":22,\"parentName\":\"部门管理\",\"path\":\"1,22\",\"pathName\":\"系统管理,部门管理\",\"sort\":0,\"status\":1,\"statusBool\":true,\"tenantId\":1,\"tenantId$\":\"Google\",\"type\":1,\"type$\":\"按钮\",\"updateTime$\":\"\"},{\"authority\":\"system:userLogin:list\",\"createTime$\":\"\",\"deleted\":0,\"id\":28,\"name\":\"查询登录日志\",\"parentId\":27,\"parentName\":\"登录日志\",\"path\":', 38, NULL, 1, 2, 1, '2025-02-08 15:50:48', 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 (18, 'Update UserInfo', '/rsf-server/auth/user', NULL, '1739001103252', '127.0.0.1', '{\"accountNonExpired\":true,\"accountNonLocked\":false,\"code\":\"1234\",\"createTime$\":\"\",\"credentialsNonExpired\":true,\"email\":\"\",\"enabled\":true,\"id\":2,\"idCard\":\"330421199511233211\",\"nickname\":\"ROOT\",\"phone\":\"15988786205\",\"realName\":\"陆晓涛\",\"sex\":1,\"sex$\":\"男\",\"updateTime$\":\"\",\"userRoleIds\":[1]} ', '{\"msg\":\"Save Success\",\"code\":200,\"data\":{\"accountNonExpired\":true,\"accountNonLocked\":true,\"authorities\":[{\"authority\":\"system:operationRecord:list\",\"createTime$\":\"\",\"deleted\":0,\"id\":33,\"name\":\"查询操作日志\",\"parentId\":32,\"parentName\":\"操作日志\",\"path\":\"1,32\",\"pathName\":\"系统管理,操作日志\",\"sort\":0,\"status\":1,\"statusBool\":true,\"tenantId\":1,\"tenantId$\":\"Google\",\"type\":1,\"type$\":\"按钮\",\"updateTime$\":\"\"},{\"authority\":\"system:tenant:list\",\"createTime$\":\"\",\"deleted\":0,\"id\":43,\"name\":\"Query Tenant\",\"parentId\":42,\"sort\":0,\"status\":1,\"statusBool\":true,\"tenantId\":1,\"tenantId$\":\"Google\",\"type\":1,\"type$\":\"按钮\",\"updateTime$\":\"\"},{\"authority\":\"system:dept:list\",\"createTime$\":\"\",\"deleted\":0,\"id\":23,\"name\":\"查询部门\",\"parentId\":22,\"parentName\":\"部门管理\",\"path\":\"1,22\",\"pathName\":\"系统管理,部门管理\",\"sort\":0,\"status\":1,\"statusBool\":true,\"tenantId\":1,\"tenantId$\":\"Google\",\"type\":1,\"type$\":\"按钮\",\"updateTime$\":\"\"},{\"authority\":\"system:userLogin:list\",\"createTime$\":\"\",\"deleted\":0,\"id\":28,\"name\":\"查询登录日志\",\"parentId\":27,\"parentName\":\"登录日志\",\"path\":', 34, NULL, 1, 2, 1, '2025-02-08 15:51:43', 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 (19, 'Update UserInfo', '/rsf-server/auth/user', NULL, '1739001109439', '127.0.0.1', '{\"accountNonExpired\":true,\"accountNonLocked\":false,\"code\":\"1234\",\"createTime$\":\"\",\"credentialsNonExpired\":true,\"email\":\"\",\"enabled\":true,\"id\":2,\"idCard\":\"330421199511233211\",\"nickname\":\"ROOT\",\"phone\":\"15988786205\",\"realName\":\"vincent\",\"sex\":1,\"sex$\":\"男\",\"updateTime$\":\"\",\"userRoleIds\":[1]} ', '{\"msg\":\"Save Success\",\"code\":200,\"data\":{\"accountNonExpired\":true,\"accountNonLocked\":true,\"authorities\":[{\"authority\":\"system:operationRecord:list\",\"createTime$\":\"\",\"deleted\":0,\"id\":33,\"name\":\"查询操作日志\",\"parentId\":32,\"parentName\":\"操作日志\",\"path\":\"1,32\",\"pathName\":\"系统管理,操作日志\",\"sort\":0,\"status\":1,\"statusBool\":true,\"tenantId\":1,\"tenantId$\":\"Google\",\"type\":1,\"type$\":\"按钮\",\"updateTime$\":\"\"},{\"authority\":\"system:tenant:list\",\"createTime$\":\"\",\"deleted\":0,\"id\":43,\"name\":\"Query Tenant\",\"parentId\":42,\"sort\":0,\"status\":1,\"statusBool\":true,\"tenantId\":1,\"tenantId$\":\"Google\",\"type\":1,\"type$\":\"按钮\",\"updateTime$\":\"\"},{\"authority\":\"system:dept:list\",\"createTime$\":\"\",\"deleted\":0,\"id\":23,\"name\":\"查询部门\",\"parentId\":22,\"parentName\":\"部门管理\",\"path\":\"1,22\",\"pathName\":\"系统管理,部门管理\",\"sort\":0,\"status\":1,\"statusBool\":true,\"tenantId\":1,\"tenantId$\":\"Google\",\"type\":1,\"type$\":\"按钮\",\"updateTime$\":\"\"},{\"authority\":\"system:userLogin:list\",\"createTime$\":\"\",\"deleted\":0,\"id\":28,\"name\":\"查询登录日志\",\"parentId\":27,\"parentName\":\"登录日志\",\"path\":', 35, NULL, 1, 2, 1, '2025-02-08 15:51:49', 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 (20, 'Update UserInfo', '/rsf-server/auth/user', NULL, '1739001556230', '127.0.0.1', '{\"accountNonExpired\":true,\"accountNonLocked\":false,\"code\":\"12343\",\"createTime$\":\"\",\"credentialsNonExpired\":true,\"email\":\"\",\"enabled\":true,\"id\":2,\"idCard\":\"330421199511233211\",\"nickname\":\"ROOT\",\"phone\":\"15988786205\",\"realName\":\"vincent\",\"sex\":1,\"sex$\":\"男\",\"updateTime$\":\"\",\"userRoleIds\":[1]} ', '{\"msg\":\"Save Success\",\"code\":200,\"data\":{\"accountNonExpired\":true,\"accountNonLocked\":true,\"authorities\":[{\"authority\":\"system:operationRecord:list\",\"createTime$\":\"\",\"deleted\":0,\"id\":33,\"name\":\"查询操作日志\",\"parentId\":32,\"parentName\":\"操作日志\",\"path\":\"1,32\",\"pathName\":\"系统管理,操作日志\",\"sort\":0,\"status\":1,\"statusBool\":true,\"tenantId\":1,\"tenantId$\":\"Google\",\"type\":1,\"type$\":\"按钮\",\"updateTime$\":\"\"},{\"authority\":\"system:tenant:list\",\"createTime$\":\"\",\"deleted\":0,\"id\":43,\"name\":\"Query Tenant\",\"parentId\":42,\"sort\":0,\"status\":1,\"statusBool\":true,\"tenantId\":1,\"tenantId$\":\"Google\",\"type\":1,\"type$\":\"按钮\",\"updateTime$\":\"\"},{\"authority\":\"system:dept:list\",\"createTime$\":\"\",\"deleted\":0,\"id\":23,\"name\":\"查询部门\",\"parentId\":22,\"parentName\":\"部门管理\",\"path\":\"1,22\",\"pathName\":\"系统管理,部门管理\",\"sort\":0,\"status\":1,\"statusBool\":true,\"tenantId\":1,\"tenantId$\":\"Google\",\"type\":1,\"type$\":\"按钮\",\"updateTime$\":\"\"},{\"authority\":\"system:userLogin:list\",\"createTime$\":\"\",\"deleted\":0,\"id\":28,\"name\":\"查询登录日志\",\"parentId\":27,\"parentName\":\"登录日志\",\"path\":', 37, NULL, 1, 2, 1, '2025-02-08 15:59:16', 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 (21, 'Update UserInfo', '/rsf-server/auth/user', NULL, '1739001793107', '127.0.0.1', '{\"accountNonExpired\":true,\"accountNonLocked\":false,\"code\":\"123431\",\"createTime$\":\"\",\"credentialsNonExpired\":true,\"email\":\"\",\"enabled\":true,\"id\":2,\"idCard\":\"330421199511233211\",\"nickname\":\"ROOT\",\"phone\":\"15988786205\",\"realName\":\"vincent\",\"sex\":1,\"sex$\":\"男\",\"updateTime$\":\"\",\"userRoleIds\":[1]} ', '{\"msg\":\"Save Success\",\"code\":200,\"data\":{\"accountNonExpired\":true,\"accountNonLocked\":true,\"authorities\":[{\"authority\":\"system:operationRecord:list\",\"createTime$\":\"\",\"deleted\":0,\"id\":33,\"name\":\"查询操作日志\",\"parentId\":32,\"parentName\":\"操作日志\",\"path\":\"1,32\",\"pathName\":\"系统管理,操作日志\",\"sort\":0,\"status\":1,\"statusBool\":true,\"tenantId\":1,\"tenantId$\":\"Google\",\"type\":1,\"type$\":\"按钮\",\"updateTime$\":\"\"},{\"authority\":\"system:tenant:list\",\"createTime$\":\"\",\"deleted\":0,\"id\":43,\"name\":\"Query Tenant\",\"parentId\":42,\"sort\":0,\"status\":1,\"statusBool\":true,\"tenantId\":1,\"tenantId$\":\"Google\",\"type\":1,\"type$\":\"按钮\",\"updateTime$\":\"\"},{\"authority\":\"system:dept:list\",\"createTime$\":\"\",\"deleted\":0,\"id\":23,\"name\":\"查询部门\",\"parentId\":22,\"parentName\":\"部门管理\",\"path\":\"1,22\",\"pathName\":\"系统管理,部门管理\",\"sort\":0,\"status\":1,\"statusBool\":true,\"tenantId\":1,\"tenantId$\":\"Google\",\"type\":1,\"type$\":\"按钮\",\"updateTime$\":\"\"},{\"authority\":\"system:userLogin:list\",\"createTime$\":\"\",\"deleted\":0,\"id\":28,\"name\":\"查询登录日志\",\"parentId\":27,\"parentName\":\"登录日志\",\"path\":', 37, NULL, 1, 2, 1, '2025-02-08 16:03:13', 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 (22, 'Reset Password', '/rsf-server/auth/reset/password', NULL, '1739145414694', '127.0.0.1', '{\"newPassword\":\"xltys1995\",\"oldPassword\":\"123123\"} ', '{\"msg\":\"The Current Password Was Incorrect\",\"code\":408}', 90, NULL, 1, 2, 1, '2025-02-10 07:56:55', 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 (23, 'Reset Password', '/rsf-server/auth/reset/password', NULL, '1739145459687', '127.0.0.1', '{\"newPassword\":\"xltys1995\",\"oldPassword\":\"123123\"} ', '{\"msg\":\"The Current Password Was Incorrect\",\"code\":408}', 93, NULL, 1, 2, 1, '2025-02-10 07:57:40', 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 (24, 'Reset Password', '/rsf-server/auth/reset/password', NULL, '1739145483173', '127.0.0.1', '{\"newPassword\":\"xltys1995\",\"oldPassword\":\"13456\"} ', '{\"msg\":\"The Current Password Was Incorrect\",\"code\":408}', 95, NULL, 1, 2, 1, '2025-02-10 07:58:03', 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 (25, 'Reset Password', '/rsf-server/auth/reset/password', NULL, '1739145492428', '127.0.0.1', '{\"newPassword\":\"xltys1995\",\"oldPassword\":\"13456\"} ', '{\"msg\":\"The Current Password Was Incorrect\",\"code\":408}', 96, NULL, 1, 2, 1, '2025-02-10 07:58:13', 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 (26, 'Reset Password', '/rsf-server/auth/reset/password', NULL, '1739145505791', '127.0.0.1', '{\"newPassword\":\"xltys1995\",\"oldPassword\":\"13456\"} ', '{\"msg\":\"The Current Password Was Incorrect\",\"code\":408}', 5292, NULL, 1, 2, 1, '2025-02-10 07:58:31', 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 (27, 'Reset Password', '/rsf-server/auth/reset/password', NULL, '1739145515167', '127.0.0.1', '{\"newPassword\":\"xltys1995\",\"oldPassword\":\"13456\"} ', '{\"msg\":\"The Current Password Was Incorrect\",\"code\":408}', 7114, NULL, 1, 2, 1, '2025-02-10 07:58:42', 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 (28, 'Reset Password', '/rsf-server/auth/reset/password', NULL, '1739145537752', '127.0.0.1', '{\"newPassword\":\"xltys1995\",\"oldPassword\":\"123456\"} ', '{\"msg\":\"Reset Password Success\",\"code\":200}', 14364, NULL, 1, 2, 1, '2025-02-10 07:59:12', 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 (29, 'Reset Password', '/rsf-server/auth/reset/password', NULL, '1739145599624', '127.0.0.1', '{\"newPassword\":\"xltys1995\",\"oldPassword\":\"132131\"} ', '{\"msg\":\"The Current Password Was Incorrect\",\"code\":408}', 96, NULL, 1, 2, 1, '2025-02-10 08:00:00', 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 (30, 'Reset Password', '/rsf-server/auth/reset/password', NULL, '1739145611877', '127.0.0.1', '{\"newPassword\":\"xltys19951\",\"oldPassword\":\"xltys1995\"} ', '{\"msg\":\"Reset Password Success\",\"code\":200}', 166, NULL, 1, 2, 1, '2025-02-10 08:00:12', 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 (31, 'Reset Password', '/rsf-server/auth/reset/password', NULL, '1739145670599', '127.0.0.1', '{\"newPassword\":\"123456\",\"oldPassword\":\"xltys19951\"} ', '{\"msg\":\"Reset Password Success\",\"code\":200}', 165, NULL, 1, 2, 1, '2025-02-10 08:01:11', 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 (34, 'Init Tenant', '/rsf-server/tenant/init', NULL, '1739236836272', '127.0.0.1', '{\"email\":\"\",\"flag\":\"dasd\",\"memo\":\"123123\",\"name\":\"adad\",\"password\":\"xltys1995\",\"username\":\"dasdas\"} ', '{\"msg\":\"Initialize Success\",\"code\":200}', 5289, NULL, 1, 2, 1, '2025-02-11 09:20:42', 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=11 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', 1, 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', 1, 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', 1, 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', 1, 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', 1, 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', 1, 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', 1, 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', 1, 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=47 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (1, 1, 1);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (2, 1, 2);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (3, 1, 3);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (4, 1, 4);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (5, 1, 5);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (6, 1, 6);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (7, 1, 7);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (8, 1, 8);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (9, 1, 9);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (10, 1, 10);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (11, 1, 11);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (12, 1, 12);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (13, 1, 13);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (14, 1, 14);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (15, 1, 15);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (16, 1, 16);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (17, 1, 17);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (18, 1, 18);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (19, 1, 19);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (20, 1, 20);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (21, 1, 21);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (22, 1, 22);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (23, 1, 23);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (24, 1, 24);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (25, 1, 25);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (26, 1, 26);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (27, 1, 27);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (28, 1, 28);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (29, 1, 29);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (30, 1, 30);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (31, 1, 31);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (32, 1, 32);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (33, 1, 33);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (34, 1, 34);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (35, 1, 35);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (36, 1, 36);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (37, 1, 37);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (38, 1, 38);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (39, 1, 39);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (40, 1, 40);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (41, 1, 41);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (42, 1, 42);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (43, 1, 43);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (44, 1, 44);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (45, 1, 45);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (46, 1, 46);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (47, 1, 47);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (48, 1, 48);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (49, 1, 49);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (50, 1, 50);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (51, 1, 51);
INSERT INTO `sys_role_menu` (`id`, `role_id`, `menu_id`) VALUES (52, 1, 52);
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 '名称(*)',
  `flag` varchar(255) NOT NULL COMMENT '代码',
  `root` bigint(20) NOT NULL COMMENT '管理员(sys_user)',
  `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=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sys_tenant
-- ----------------------------
BEGIN;
INSERT INTO `sys_tenant` (`id`, `name`, `flag`, `root`, `status`, `deleted`, `create_time`, `update_time`, `memo`) VALUES (1, 'Google', '001', 2, 1, 0, NULL, '2025-02-07 15:45:13', 'aa');
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, 1, 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$e/RsGSqU0R3wb9cdJQL91u868zgehzZbWGL684TTpAYsrbVJOc/AK', 'ROOT', NULL, '123431', 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, 1, 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, 1, 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, '', 1, 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, 1, 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, '18368337803', NULL, 0, 8, NULL, 'aa', NULL, NULL, 1, 1, 0, '2024-09-10 14:56:44', 2, '2025-02-08 09:22: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 (20, '1-202-555-0106', '$2a$10$.xOeEvSa7t29RZuY/85DAenT3b.N80vubC2OnlxBnAbp53YVRzxqa', 'Ryan Allen', NULL, NULL, 0, NULL, NULL, 0, 13, NULL, NULL, NULL, NULL, 1, 1, 0, '2024-09-10 17:05:52', 2, '2025-02-06 16:20:16', 20, 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, 1, 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, 1, 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, 1, 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, 1, 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, 1, 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, 1, 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, 1, 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, 1, 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, 1, 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, 1, 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, 1, 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, 1, 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, 1, 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=75 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, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-07 07:49:11', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (3, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-07 07:51:08', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (4, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-07 07:53:25', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (5, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-07 08:08:53', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (6, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-07 08:16:48', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (8, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-07 08:17:13', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (10, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-07 08:42:28', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (11, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-07 08:44:56', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (12, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-07 08:45:23', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (14, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-07 08:58:37', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (15, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-07 08:59:25', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (19, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-07 09:21:30', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (20, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-07 09:27:51', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (21, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-07 09:52:36', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (22, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-07 09:53:10', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (23, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-07 09:58:35', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (24, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-08 01:17:37', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (25, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-08 01:42:04', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (26, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-08 02:20:40', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (27, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-08 03:51:19', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (28, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-08 03:55:46', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (29, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-08 09:16:52', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (30, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-08 09:16:57', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (31, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 00:41:14', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (32, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 00:50:02', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (33, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 00:50:16', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (34, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 01:00:20', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (35, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 01:01:13', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (36, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 01:06:24', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (37, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 01:07:49', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (38, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 01:09:34', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (39, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 01:12:10', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (40, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 01:12:38', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (41, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 01:12:57', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (42, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 01:32:42', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (43, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 01:35:32', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (44, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 03:05:15', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (45, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 03:05:41', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (47, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 03:09:06', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (48, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 03:09:34', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (49, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 03:10:10', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (50, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 03:12:03', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (51, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 03:12:09', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (52, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 03:12:16', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (53, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 03:13:46', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (54, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 03:25:32', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (55, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 03:40:33', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (56, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 03:42:53', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (57, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 03:42:56', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (58, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 04:00:09', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (59, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 04:00:37', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (60, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 08:16:45', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (61, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 08:16:49', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (62, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 08:16:55', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (63, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 08:17:29', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (64, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 08:19:58', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (66, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 09:28:49', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (67, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 09:36:39', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (68, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 09:45:31', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (70, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-10 10:02:51', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (71, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-11 00:57:52', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (72, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-11 02:24:08', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (73, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-11 02:52:44', NULL, NULL);
INSERT INTO `sys_user_login` (`id`, `user_id`, `tenant_id`, `token`, `ip`, `type`, `create_time`, `system`, `memo`) VALUES (74, 2, 1, '[REDACTED], '127.0.0.1', 0, '2025-02-11 03:54:02', 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=80 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 (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);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (77, 20, 1);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (78, 19, 1);
INSERT INTO `sys_user_role` (`id`, `user_id`, `role_id`) VALUES (79, 19, 6);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
