ema_project/sql/ema_projet.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 公司 MySql-172.16.0.212
 Source Server Type    : MySQL
 Source Server Version : 50744
 Source Host           : 172.16.0.212:3306
 Source Schema         : ema_projet

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

 Date: 15/05/2026 13:54:51
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for asset_status_history
-- ----------------------------
DROP TABLE IF EXISTS `asset_status_history`;
CREATE TABLE `asset_status_history`  (
  `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '主键',
  `asset_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '资产信息id',
  `use_company` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '使用公司',
  `use_dept` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '使用部门',
  `use_user` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '使用人',
  `use_status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '使用状态 在库、正常使用、已转移、报废中、维修中等',
  `cur_location` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '当前位置',
  `start_date` date NOT NULL COMMENT '生效开始日期',
  `end_date` date NOT NULL COMMENT '生效结束日期(当前有效为4712-12-31)',
  `operator_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '操作人',
  `operator_date` datetime NULL DEFAULT NULL COMMENT '操作时间',
  `assistant_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '协管员',
  `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `fk_asset_history`(`asset_id`) USING BTREE,
  CONSTRAINT `fk_asset_history` FOREIGN KEY (`asset_id`) REFERENCES `assets_info` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '资产状态历史表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of asset_status_history
-- ----------------------------
INSERT INTO `asset_status_history` VALUES ('412430304824160256', '412047813751787520', '111', '222', '333', '在库', '444', '2026-05-14', '2026-05-29', '222', '2026-05-14 15:29:53', '333', '44444');
INSERT INTO `asset_status_history` VALUES ('412439315543973888', '412047813751787520', '2222', '22', '22', '报废中', '22222', '2026-05-14', '2026-05-14', '222', NULL, '222', '222');

-- ----------------------------
-- Table structure for assets_info
-- ----------------------------
DROP TABLE IF EXISTS `assets_info`;
CREATE TABLE `assets_info`  (
  `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '主键',
  `dept_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '资产管理部门',
  `asset_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '资产编码',
  `asset_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '资产类型',
  `brand` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '品牌',
  `model` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '型号',
  `purchase_date` date NULL DEFAULT NULL COMMENT '购买日期',
  `purchase_value` decimal(12, 2) NULL DEFAULT NULL COMMENT '采购价值（元）',
  `invstk_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '未盘点' COMMENT '盘点状态',
  `last_invstk_time` datetime NULL DEFAULT NULL COMMENT '最后一次盘点时间',
  `attribute1` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '扩展字段1',
  `attribute2` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '扩展字段2',
  `attribute3` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '扩展字段3',
  `attribute4` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '扩展字段4',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '删除标识(0否 1 是)',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建人',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '资产信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of assets_info
-- ----------------------------
INSERT INTO `assets_info` VALUES ('412047813751787520', 'IT运维部', '2222', '333', '4444', '555', '2026-05-13', 666.00, '1', '2026-05-11 02:02:02', '888', '999', '1010', '11011', '777', '0', '2026-05-13 13:51:54', '2026-05-15 11:38:04', '406746437466292224', '406746437466292224');
INSERT INTO `assets_info` VALUES ('412456938570694656', 'IT运维部', '333', '33', '33', '33', '2026-05-14', 333.00, '1', '2026-05-15 00:00:00', '333', '3333', '3333', '3333', '3333', '0', '2026-05-14 16:57:37', '2026-05-15 11:24:43', '406746437466292224', '406746437466292224');
INSERT INTO `assets_info` VALUES ('412723191998734336', 'IT运维部', '444', '333', '华为', '笔记本电脑X3', '2026-05-13', 20000.00, '0', NULL, '', '', '', '', '', '0', '2026-05-15 10:35:37', '2026-05-15 11:38:12', '406746437466292224', '406746437466292224');

-- ----------------------------
-- Table structure for sys_department
-- ----------------------------
DROP TABLE IF EXISTS `sys_department`;
CREATE TABLE `sys_department`  (
  `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门id',
  `dept_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门编码',
  `dept_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门名称',
  `parent_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '上级部门ID',
  `sort` int(4) NULL DEFAULT NULL COMMENT '显示顺序',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '删除标识(0否 1 是)',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '部门信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_department
-- ----------------------------
INSERT INTO `sys_department` VALUES ('412101544581173248', 'ITYW', 'IT运维部', '0', 0, '0', '2026-05-13 17:25:25', '2026-05-13 17:25:25', '406746437466292224', '406746437466292224');

-- ----------------------------
-- Table structure for sys_department_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_department_user`;
CREATE TABLE `sys_department_user`  (
  `dept_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门id',
  `user_id` bigint(20) NOT NULL COMMENT '用户ID'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '部门用户关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_department_user
-- ----------------------------

-- ----------------------------
-- Table structure for sys_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_data`;
CREATE TABLE `sys_dict_data`  (
  `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '主键',
  `type_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字典类型',
  `code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '编码',
  `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '值',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注',
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态（0 停用 1 正常）',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '删除标识(0否 1 是)',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建人',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `code`(`code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '系统字典值表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
INSERT INTO `sys_dict_data` VALUES ('1', 'EMAIL_TEMPLATES', 'EMAIL_REGISTER_CODE', '尊敬的用户，您好！您正在注册【加特林SAAS系统】账号，本次操作的验证码是：{code}。该验证码 {expireTime} 分钟 内有效，请勿泄露给他人。', '注册验证码1', 1, 0, '0', '2026-04-28 22:45:26', '2026-05-13 18:39:41', NULL, '406746437466292224');
INSERT INTO `sys_dict_data` VALUES ('2', 'EMAIL_TEMPLATES', 'EMAIL_RESET_PWD_CODE', '尊敬的用户，您好！您正在重置【加特林SAAS系统】账号的密码，本次操作的验证码是：{code}。该验证码 {expireTime} 分钟 内有效，请勿泄露给他人。', '重置密码验证码', 1, 0, '0', '2026-04-28 22:48:53', '2026-04-28 22:51:04', NULL, NULL);
INSERT INTO `sys_dict_data` VALUES ('3', 'BAIDU_LANGUAGES', 'BAIDU_LANGUAGES_CODE', '[\n  {\n    \"name\": \"中文\",\n    \"code\": \"zh\"\n  },\n  {\n    \"name\": \"英语\",\n    \"code\": \"en\"\n  },\n  {\n    \"name\": \"日语\",\n    \"code\": \"jp\"\n  },\n  {\n    \"name\": \"韩语\",\n    \"code\": \"kor\"\n  },\n  {\n    \"name\": \"法语\",\n    \"code\": \"fra\"\n  },\n  {\n    \"name\": \"西班牙语\",\n    \"code\": \"spa\"\n  },\n  {\n    \"name\": \"泰语\",\n    \"code\": \"th\"\n  },\n  {\n    \"name\": \"阿拉伯语\",\n    \"code\": \"ara\"\n  },\n  {\n    \"name\": \"俄语\",\n    \"code\": \"ru\"\n  },\n  {\n    \"name\": \"葡萄牙语\",\n    \"code\": \"pt\"\n  },\n  {\n    \"name\": \"德语\",\n    \"code\": \"de\"\n  },\n  {\n    \"name\": \"意大利语\",\n    \"code\": \"it\"\n  },\n  {\n    \"name\": \"希腊语\",\n    \"code\": \"el\"\n  },\n  {\n    \"name\": \"荷兰语\",\n    \"code\": \"nl\"\n  },\n  {\n    \"name\": \"波兰语\",\n    \"code\": \"pl\"\n  },\n  {\n    \"name\": \"保加利亚语\",\n    \"code\": \"bul\"\n  },\n  {\n    \"name\": \"爱沙尼亚语\",\n    \"code\": \"est\"\n  },\n  {\n    \"name\": \"丹麦语\",\n    \"code\": \"dan\"\n  },\n  {\n    \"name\": \"芬兰语\",\n    \"code\": \"fin\"\n  },\n  {\n    \"name\": \"捷克语\",\n    \"code\": \"cs\"\n  },\n  {\n    \"name\": \"罗马尼亚语\",\n    \"code\": \"rom\"\n  },\n  {\n    \"name\": \"斯洛文尼亚语\",\n    \"code\": \"slo\"\n  },\n  {\n    \"name\": \"瑞典语\",\n    \"code\": \"swe\"\n  },\n  {\n    \"name\": \"匈牙利语\",\n    \"code\": \"hu\"\n  },\n  {\n    \"name\": \"越南语\",\n    \"code\": \"vie\"\n  },\n  {\n    \"name\": \"繁体中文\",\n    \"code\": \"cht\"\n  }\n]', '百度翻译语言代码', 1, 0, '0', '2026-04-28 22:56:04', '2026-04-28 23:03:24', NULL, NULL);
INSERT INTO `sys_dict_data` VALUES ('4', 'WHATSAPP_REGISTER', 'WHATSAPP_REGISTER_INIT_PARAMET', '{\r\n  \"OrganizationId\": \"6951e60a74cb1706c8bc3af1\",\r\n  \"CustomArgs\": \"{userId}\",\r\n  \"DevKey\": \"6951e5c03bae3b6f4a77a743\",\r\n  \"Logo\": \"https://yinghaibucket.oss-cn-shanghai.aliyuncs.com/yinghai/20260429/a73029844d454db5aa55963cf8aa7008.png\",\r\n  \"BspName\": \"瀛舟出海\",\r\n  \"RedirectUrl\": \"https://vcdtest.yuncsk.com/#/userAccount\"\r\n}', 'WhatsApp嵌入式注册初始化参数', 1, 0, '0', '2026-04-28 23:09:16', '2026-04-29 15:13:54', NULL, NULL);
INSERT INTO `sys_dict_data` VALUES ('412120291450740736', 'EMAIL_TEMPLATES', '222', '111', '333', 1, 0, '1', '2026-05-13 18:39:54', '2026-05-13 18:37:10', '406746437466292224', '406746437466292224');
INSERT INTO `sys_dict_data` VALUES ('412342457039503360', 'BAIDU_LANGUAGES', '111', '2222', '', 0, 0, '1', '2026-05-14 09:22:43', '2026-05-14 09:20:08', '406746437466292224', '406746437466292224');
INSERT INTO `sys_dict_data` VALUES ('412358286795771904', 'WHATSAPP_REGISTER', '1', '1', '', 1, 0, '0', '2026-05-14 10:25:37', '2026-05-14 10:25:37', '406746437466292224', '406746437466292224');
INSERT INTO `sys_dict_data` VALUES ('412358318013976576', 'WHATSAPP_REGISTER', '2', '222', '', 1, 0, '0', '2026-05-14 10:25:44', '2026-05-14 11:58:25', '406746437466292224', '406746437466292224');
INSERT INTO `sys_dict_data` VALUES ('412358351836844032', 'WHATSAPP_REGISTER', '3', '3', '', 1, 0, '0', '2026-05-14 10:25:52', '2026-05-14 10:25:52', '406746437466292224', '406746437466292224');
INSERT INTO `sys_dict_data` VALUES ('412358383336067072', 'WHATSAPP_REGISTER', '4', '4', '', 1, 0, '0', '2026-05-14 10:26:00', '2026-05-14 10:26:00', '406746437466292224', '406746437466292224');
INSERT INTO `sys_dict_data` VALUES ('412358414533300224', 'WHATSAPP_REGISTER', '5', '5', '', 1, 0, '0', '2026-05-14 10:26:07', '2026-05-14 10:26:07', '406746437466292224', '406746437466292224');
INSERT INTO `sys_dict_data` VALUES ('412358443935371264', 'WHATSAPP_REGISTER', '6', '6', '', 1, 0, '0', '2026-05-14 10:26:14', '2026-05-14 10:26:14', '406746437466292224', '406746437466292224');
INSERT INTO `sys_dict_data` VALUES ('412358589947482112', 'WHATSAPP_REGISTER', '7', '7', '', 1, 0, '0', '2026-05-14 10:26:49', '2026-05-14 10:26:49', '406746437466292224', '406746437466292224');
INSERT INTO `sys_dict_data` VALUES ('412358628056928256', 'WHATSAPP_REGISTER', '8', '8', '', 1, 0, '0', '2026-05-14 10:26:58', '2026-05-14 10:26:58', '406746437466292224', '406746437466292224');
INSERT INTO `sys_dict_data` VALUES ('412358656527863808', 'WHATSAPP_REGISTER', '9', '9', '', 1, 0, '0', '2026-05-14 10:27:05', '2026-05-14 10:27:05', '406746437466292224', '406746437466292224');
INSERT INTO `sys_dict_data` VALUES ('412358695820103680', 'WHATSAPP_REGISTER', '10', '10', '', 1, 0, '0', '2026-05-14 10:27:14', '2026-05-14 10:27:14', '406746437466292224', '406746437466292224');
INSERT INTO `sys_dict_data` VALUES ('412358728539869184', 'WHATSAPP_REGISTER', '11', '11', '', 1, 0, '0', '2026-05-14 10:27:22', '2026-05-14 10:27:22', '406746437466292224', '406746437466292224');
INSERT INTO `sys_dict_data` VALUES ('5', 'SYSTEM_PAGE_CONFIG', 'SUPPORT_WECHAT_CODE', '{\n  \"imgUrl\": \"https://yinghaibucket.oss-cn-shanghai.aliyuncs.com/yinghai/20260427/f476be13444a4ce2922529bf9381efec.\",\n  \"description\": \"购买账号请咨询客服\"\n}', '客服微信二维码2', 1, 0, '0', '2026-04-28 23:09:59', '2026-05-14 09:22:20', NULL, '406746437466292224');

-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;
CREATE TABLE `sys_dict_type`  (
  `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '主键',
  `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '名称',
  `code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '编码',
  `sort` int(11) NOT NULL COMMENT '排序',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '删除标识(0否 1 是)',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建人',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `code`(`code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '系统字典类型表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
INSERT INTO `sys_dict_type` VALUES ('393981617517268992', '邮件模板', 'EMAIL_TEMPLATES', 0, '', '0', '2026-03-24 17:23:17', '2026-03-24 17:23:17', '393629220102119424', '393629220102119424');
INSERT INTO `sys_dict_type` VALUES ('393981617517268993', '百度翻译语种', 'BAIDU_LANGUAGES', 1, NULL, '0', '2026-04-16 16:55:39', '2026-04-16 16:55:46', NULL, NULL);
INSERT INTO `sys_dict_type` VALUES ('393981617517268994', 'WhatsApp嵌入式注册', 'WHATSAPP_REGISTER', 2, NULL, '0', '2026-04-24 22:59:10', '2026-04-24 23:00:19', NULL, NULL);
INSERT INTO `sys_dict_type` VALUES ('393981617517268995', '系统页面相关展示配置', 'SYSTEM_PAGE_CONFIG', 3, NULL, '0', '2026-04-27 11:35:35', '2026-04-27 11:39:00', NULL, NULL);
INSERT INTO `sys_dict_type` VALUES ('412117791565819904', 'aaa', 'bbb', 1, 'ccccc', '1', '2026-05-13 18:29:58', '2026-05-13 18:27:12', '406746437466292224', '406746437466292224');

-- ----------------------------
-- Table structure for sys_file
-- ----------------------------
DROP TABLE IF EXISTS `sys_file`;
CREATE TABLE `sys_file`  (
  `id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件id',
  `url` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件访问地址',
  `size` bigint(20) NULL DEFAULT NULL COMMENT '文件大小，单位字节',
  `filename` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称',
  `original_filename` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '原始文件名',
  `base_path` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '基础存储路径',
  `path` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '存储路径',
  `ext` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件扩展名',
  `content_type` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'MIME类型',
  `platform` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '存储平台',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '删除标识(0否 1 是)',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `url`(`url`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '文件记录表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_file
-- ----------------------------

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单ID',
  `menu_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单名称',
  `parent_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '父菜单ID (0为顶级菜单)',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT '显示顺序',
  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '前端路由地址',
  `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '前端组件路径',
  `perms` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限标识 (例如: system:user:list)',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '#' COMMENT '菜单图标',
  `is_frame` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '是否为外链 (0否 1是)',
  `menu_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'C' COMMENT '菜单类型 (M目录 C菜单 F按钮)',
  `visible` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '1' COMMENT '菜单状态 (0隐藏 1显示)',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '1' COMMENT '菜单状态 (0停用 1正常)',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '删除标识(0否 1 是)',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `parent_id`(`parent_id`) USING BTREE,
  INDEX `perms`(`perms`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '菜单权限表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES ('400613972419358720', '系统设置', '0', 7, '', '', '', 'layui-icon-set', '0', 'M', '1', '1', '', '0', '2026-04-12 00:37:54', '2026-05-12 22:27:29', '399888727912583168', '406746437466292224');
INSERT INTO `sys_menu` VALUES ('400614363777282048', '用户管理', '400613972419358720', 1, 'user/user_list.html', '', 'sys:user:page', 'layui-icon-user', '0', 'C', '1', '1', '', '0', '2026-04-12 00:39:27', '2026-05-12 22:27:12', '399888727912583168', '406746437466292224');
INSERT INTO `sys_menu` VALUES ('400614795882868736', '角色管理', '400613972419358720', 2, 'role/role_list.html', '', 'sys:role:page', 'layui-icon-rate', '0', 'C', '1', '1', '', '0', '2026-04-12 00:41:10', '2026-05-12 22:27:09', '399888727912583168', '406746437466292224');
INSERT INTO `sys_menu` VALUES ('400615168148320256', '菜单管理', '400613972419358720', 3, 'menu/menu_list.html', '', 'sys:menu:page', 'layui-icon-list', '0', 'C', '1', '1', '', '0', '2026-04-12 00:42:39', '2026-05-12 22:25:03', '399888727912583168', '406746437466292224');
INSERT INTO `sys_menu` VALUES ('411814167266902016', '资产管理', '0', 0, 'assets/assets_list.html', '', '', 'layui-icon-chart-screen', '', 'C', '', '1', '', '0', '2026-05-12 22:23:29', '2026-05-13 13:45:23', '406746437466292224', '406746437466292224');
INSERT INTO `sys_menu` VALUES ('411823634511491072', '字典管理', '400613972419358720', 0, 'dict/dict_type_list.html', '', 'system:dict:list', 'layui-icon-table', '', 'C', '', '1', '', '0', '2026-05-12 23:01:06', '2026-05-12 23:02:36', '406746437466292224', '406746437466292224');
INSERT INTO `sys_menu` VALUES ('411823858185334784', '系统日志', '400613972419358720', 0, 'log/log_list.html', '', '', 'layui-icon-form', '', 'C', '', '1', '', '0', '2026-05-12 23:01:59', '2026-05-13 08:28:16', '406746437466292224', '406746437466292224');
INSERT INTO `sys_menu` VALUES ('412054490920169472', '部门管理', '400613972419358720', 0, 'department/department_list.html', '', '', 'layui-icon-app', '', 'M', '', '1', '', '0', '2026-05-13 14:18:26', '2026-05-13 14:18:26', '406746437466292224', '406746437466292224');
INSERT INTO `sys_menu` VALUES ('412457382307086336', '111', '0', 0, '11', '', '11', '', '', 'M', '', '1', '', '1', '2026-05-14 16:59:23', '2026-05-14 16:56:37', '406746437466292224', '406746437466292224');

-- ----------------------------
-- Table structure for sys_oper_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_oper_log`;
CREATE TABLE `sys_oper_log`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '日志主键',
  `type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '日志类型',
  `module` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模块名称',
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '日志标题',
  `method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求方法',
  `url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求url',
  `params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '请求参数',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '执行状态：0-异常；1-成功',
  `duration` bigint(20) NULL DEFAULT NULL COMMENT '请求耗时:毫秒',
  `error_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '错误消息',
  `user_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户ID',
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名称',
  `ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求IP',
  `region` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求地区',
  `browser` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '浏览器',
  `os` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作系统',
  `oper_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '操作时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '操作日志记录' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_oper_log
-- ----------------------------
INSERT INTO `sys_oper_log` VALUES ('412716232864071680', '0', '用户登录注册授权管理', '通过账号密码登录', 'SysAuthController.login', '/login', '[{\"account\":\"13111111111\",\"pwd\":\"******\",\"code\":\"IeAd\"}]', '1', 33, '', NULL, NULL, '0:0:0:0:0:0:0:1', NULL, 'Chrome', 'Windows', '2026-05-15 10:07:58');
INSERT INTO `sys_oper_log` VALUES ('412716260701667328', '0', '用户登录注册授权管理', '通过账号密码登录', 'SysAuthController.login', '/login', '[{\"account\":\"13111111111\",\"pwd\":\"******\",\"code\":\"cdy2\"}]', '1', 412, NULL, '406746437466292224', '系统管理员', '0:0:0:0:0:0:0:1', NULL, 'Chrome', 'Windows', '2026-05-15 10:08:04');

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色ID',
  `role_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色名称',
  `role_key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色权限Key (例如: admin, common)',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '1' COMMENT '角色状态 (0停用 1正常)',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '删除标识(0否 1 是)',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `role_key`(`role_key`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统角色信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES ('1', '超级管理员', 'surper-admin', '1', '', '0', '2026-04-11 19:00:11', '2026-05-13 14:18:55', NULL, '406746437466292224');
INSERT INTO `sys_role` VALUES ('2', 'SAAS用户', 'saas-user', '1', NULL, '1', '2026-04-22 22:54:24', '2026-05-12 22:48:59', NULL, '404571359404089344');
INSERT INTO `sys_role` VALUES ('406760559883374592', '平台运营', 'operation-user', '1', '', '1', '2026-04-28 23:42:15', '2026-05-12 22:48:53', '406746437466292224', '406747594410524672');
INSERT INTO `sys_role` VALUES ('411821237953294336', '资产运维', 'assets-user', '1', '', '0', '2026-05-12 22:51:34', '2026-05-15 09:35:01', '406746437466292224', '406746437466292224');

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu`  (
  `role_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色ID',
  `menu_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单ID'
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统角色和菜单关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
INSERT INTO `sys_role_menu` VALUES ('2', '400620787571961856');
INSERT INTO `sys_role_menu` VALUES ('2', '403861588342824960');
INSERT INTO `sys_role_menu` VALUES ('406760559883374592', '403078196685504512');
INSERT INTO `sys_role_menu` VALUES ('1', '411814167266902016');
INSERT INTO `sys_role_menu` VALUES ('1', '400613972419358720');
INSERT INTO `sys_role_menu` VALUES ('1', '411823634511491072');
INSERT INTO `sys_role_menu` VALUES ('1', '411823858185334784');
INSERT INTO `sys_role_menu` VALUES ('1', '412054490920169472');
INSERT INTO `sys_role_menu` VALUES ('1', '400614363777282048');
INSERT INTO `sys_role_menu` VALUES ('1', '400614795882868736');
INSERT INTO `sys_role_menu` VALUES ('1', '400615168148320256');
INSERT INTO `sys_role_menu` VALUES ('411821237953294336', '411814167266902016');

-- ----------------------------
-- Table structure for sys_timers_job
-- ----------------------------
DROP TABLE IF EXISTS `sys_timers_job`;
CREATE TABLE `sys_timers_job`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '定时器id',
  `timer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '任务名称',
  `action_class` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '执行任务的class的类名（实现了TimerTaskRunner接口的类的全称）',
  `cron` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '定时任务表达式',
  `job_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1' COMMENT '状态（1运行  2停止 3异常）',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '备注信息',
  `last_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '上次执行时间',
  `last_status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '1' COMMENT '上次执行状态（0失败 1成功）',
  `last_msg` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '上次执行消息',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '删除标识(0否 1 是)',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '创建人',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `timer_name`(`timer_name`) USING BTREE,
  INDEX `action_class`(`action_class`) USING BTREE,
  INDEX `job_status`(`job_status`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '定时任务' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_timers_job
-- ----------------------------
INSERT INTO `sys_timers_job` VALUES ('406392569852432381', '极光同步发送账号任务', 'com.gatling.admin.tasks.JiguangSyncPhonesTask', '0 0 * * * *', '1', '', '2026-04-29 10:00:06', '', '', '0', '2026-04-27 23:19:59', '2026-04-29 10:00:06', '399888727912583168', '399888727912583168');
INSERT INTO `sys_timers_job` VALUES ('406393632735203322', '极光同步Waba任务', 'com.gatling.admin.tasks.JiguangSyncWabaTask', '0 0/30 * * * *', '1', '', '2026-04-29 10:30:00', '1', '执行成功', '0', '2026-04-27 23:24:12', '2026-04-29 10:30:00', 'system', 'async');

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user`  (
  `id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID',
  `account` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户账号',
  `password` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像地址',
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户邮箱',
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号码',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '1' COMMENT '帐号状态(0停用 1正常)',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `dept_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '部门ID',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '删除标识(0否 1 是)',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '注册时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统用户信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES ('406746437466292224', '13111111111', 'e120ea280aa50693d5568d0071456460', '系统管理员', '', 'lijian541x@163.com', '13111111111', '1', '', '412101544581173248', '0', '2026-04-28 22:46:08', '2026-05-15 11:17:23', 'system', '406746437466292224');
INSERT INTO `sys_user` VALUES ('412730073668837376', '13111111112', 'e120ea280aa50693d5568d0071456460', '李四', '', '13111111112@163.com', '13111111112', '1', 'aaa', '412101544581173248', '0', '2026-05-15 11:02:58', '2026-05-15 11:02:58', '406746437466292224', '406746437466292224');

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role`  (
  `user_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID',
  `role_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`user_id`, `role_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统用户和角色关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
INSERT INTO `sys_user_role` VALUES ('', '1');
INSERT INTO `sys_user_role` VALUES ('', '2');
INSERT INTO `sys_user_role` VALUES ('', '406760559883374592');
INSERT INTO `sys_user_role` VALUES ('406746437466292224', '1');
INSERT INTO `sys_user_role` VALUES ('406747594410524672', '1');
INSERT INTO `sys_user_role` VALUES ('406759266916302848', '406760559883374592');
INSERT INTO `sys_user_role` VALUES ('407152211148431360', '2');
INSERT INTO `sys_user_role` VALUES ('407428264152555520', '2');
INSERT INTO `sys_user_role` VALUES ('407667616250093568', '2');
INSERT INTO `sys_user_role` VALUES ('411509325782339584', '2');
INSERT INTO `sys_user_role` VALUES ('411510166232780800', '2');
INSERT INTO `sys_user_role` VALUES ('411818900522266624', '1');
INSERT INTO `sys_user_role` VALUES ('411818900522266624', '2');
INSERT INTO `sys_user_role` VALUES ('411820032166457344', '1');
INSERT INTO `sys_user_role` VALUES ('411820032166457344', '411821237953294336');
INSERT INTO `sys_user_role` VALUES ('411820465526075392', '1');
INSERT INTO `sys_user_role` VALUES ('411820465526075392', '2');
INSERT INTO `sys_user_role` VALUES ('411820465526075392', '406760559883374592');
INSERT INTO `sys_user_role` VALUES ('412730073668837376', '411821237953294336');

SET FOREIGN_KEY_CHECKS = 1;