/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80032
 Source Host           : localhost:3306
 Source Schema         : lq_db

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

 Date: 22/01/2026 21:10:57
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for app_permissions
-- ----------------------------
DROP TABLE IF EXISTS `app_permissions`;
CREATE TABLE `app_permissions`  (
  `app_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '应用ID',
  `permission_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '权限代码',
  `permission_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '权限名称',
  `description` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '权限描述',
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '主键ID',
  `created_at` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` tinyint(1) NULL DEFAULT NULL COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `app_id`(`app_id`) USING BTREE,
  CONSTRAINT `app_permissions_ibfk_1` FOREIGN KEY (`app_id`) REFERENCES `apps` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of app_permissions
-- ----------------------------

-- ----------------------------
-- Table structure for apps
-- ----------------------------
DROP TABLE IF EXISTS `apps`;
CREATE TABLE `apps`  (
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '应用名称',
  `app_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '应用Key',
  `app_secret` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '应用Secret',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '应用描述',
  `icon_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '应用图标',
  `redirect_uris` json NOT NULL COMMENT '回调URL列表',
  `scope` json NULL COMMENT '权限范围',
  `is_active` tinyint(1) NULL DEFAULT NULL COMMENT '是否激活',
  `is_trusted` tinyint(1) NULL DEFAULT NULL COMMENT '是否受信任应用',
  `access_token_expires` int(0) NULL DEFAULT NULL COMMENT '访问令牌过期时间(秒)',
  `refresh_token_expires` int(0) NULL DEFAULT NULL COMMENT '刷新令牌过期时间(秒)',
  `created_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '创建者ID',
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '主键ID',
  `created_at` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` tinyint(1) NULL DEFAULT NULL COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `app_key`(`app_key`) USING BTREE,
  INDEX `created_by`(`created_by`) USING BTREE,
  CONSTRAINT `apps_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of apps
-- ----------------------------
INSERT INTO `apps` VALUES ('test', 'WviiGL8KQE20tQhmhQPQhhJ5QpFK51F6', '9WXP88hEHJiHRSiUdmx7ip5oQPzY0bnJNsEswQoO4sk6juCplyJTcnAiZsv7e3lJ', '测试', '', '[\"http://www.test.com/callback\", \"http://192.168.1.12:8001/callback\"]', '[\"profile\", \"email\", \"phone\", \"roles\"]', 1, 0, 7200, 2592000, 'ed6a79d3-0083-4d81-8b48-fc522f686f74', '05b36e43-fe4b-4d72-9271-a24bd2195fa1', '2025-12-21 22:03:52', '2025-12-21 22:04:32', NULL);
INSERT INTO `apps` VALUES ('test-11', 'jSvjbXIQgG0VQtDUImm0GsRoqbeXOnhw', 'xhxlb42oXEcLqkV3G4KRQC01PbW8YRdyYhllozSn9ffbKNAjw3Z6K1sGNmeWssng', 'test-11', '', '[\"http://www.bait.com/callback\"]', '[\"profile\", \"email\"]', 0, 0, 7200, 2592000, 'ed6a79d3-0083-4d81-8b48-fc522f686f74', '34c18aa1-a76d-4ef8-8901-514eea255c9a', '2026-01-15 20:45:59', '2026-01-15 20:46:23', NULL);
INSERT INTO `apps` VALUES ('子系统案例应用', 'eqhoIdAyAWbA8MsYHsNqQqNLJbCayTjY', '0070ebeYOmYQU28T85nkpedikDd6kBbkZ6LxVJzgznJvrb83HzcfOB1LCOwio4ML', '这是编辑功能的测试描述up', 'https://example.com/test-icon.png', '[\"http://localhost:3001/callback\", \"http://localhost:8001/auth/callback\"]', '[\"profile\", \"email\", \"openid\"]', 1, 0, 3600, 1800000, 'ed6a79d3-0083-4d81-8b48-fc522f686f74', 'b0886209-7eb8-433e-82ac-2a19d947215b', '2025-12-20 13:53:13', '2025-12-22 10:08:47', 0);
INSERT INTO `apps` VALUES ('app-1', 'j2e3i6psnhyQUEwso8t3m4Obx14q2MhJ', 'RRVZBviuHm4M3Rm05kvk2h2iXwFxiusIJxA3KuzhetFvJzZ5W8cQtJ7QsEDmP14c', '应用1', '', '[\"http://192.168.12/app1\"]', '[\"profile\", \"email\"]', 1, 0, 7200, 2592000, '357f8ac2-a271-440a-a003-0db32d15d302', 'c956ab97-641a-4327-8b08-5332549be104', '2025-12-29 22:26:36', '2025-12-29 22:26:36', NULL);

-- ----------------------------
-- Table structure for login_logs
-- ----------------------------
DROP TABLE IF EXISTS `login_logs`;
CREATE TABLE `login_logs`  (
  `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户ID',
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户名',
  `login_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '登录方式',
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'IP地址',
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '用户代理',
  `success` tinyint(1) NULL DEFAULT NULL COMMENT '是否成功',
  `failure_reason` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '失败原因',
  `login_at` datetime(0) NULL DEFAULT NULL COMMENT '登录时间',
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '主键ID',
  `created_at` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` tinyint(1) NULL DEFAULT NULL COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `user_id`(`user_id`) USING BTREE,
  CONSTRAINT `login_logs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of login_logs
-- ----------------------------
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'python-requests/2.32.3', 1, NULL, '2026-01-15 08:47:05', '015173e5-4e79-4f8c-8a03-bd8c8698ad48', '2026-01-15 16:47:04', '2026-01-15 16:47:04', 0);
INSERT INTO `login_logs` VALUES (NULL, 'zhangsan', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, '用户不存在', '2026-01-16 13:56:59', '019d1546-537a-4586-9300-17ffd0800b49', '2026-01-16 21:56:58', '2026-01-16 21:56:58', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-15 07:35:20', '02809359-1e4e-4e1a-988d-92d3c0e6eb5c', '2026-01-15 15:35:19', '2026-01-15 15:35:19', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 14:12:39', '05ccd8ec-085a-4a43-9ec9-2bec0adeb2bf', '2026-01-16 22:12:38', '2026-01-16 22:12:38', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 15:51:00', '0679ed85-b99b-47d8-9f4d-b26cd996d8df', '2026-01-16 23:50:59', '2026-01-16 23:50:59', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 17:16:59', '06d83360-c6da-4fa4-ba82-429d04df12a2', '2026-01-17 01:16:58', '2026-01-17 01:16:58', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-15 10:45:36', '0861740b-0939-4c92-a3d3-7c3ea2a6857c', '2026-01-15 18:45:35', '2026-01-15 18:45:35', 0);
INSERT INTO `login_logs` VALUES ('d3e906de-b9a6-4a78-a643-233252252776', 'zhangsan', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 15:53:15', '08fcd469-87cf-41ce-ab53-9e98c0e06b80', '2026-01-16 23:53:14', '2026-01-16 23:53:14', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, '密码错误，还有4次尝试机会', '2026-01-16 04:53:55', '090224ad-e31a-4e1a-b35c-15c5f22d62fd', '2026-01-16 12:53:55', '2026-01-16 12:53:55', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-15 12:21:43', '0b1874bf-0a01-483b-99a7-3d081dbd0568', '2026-01-15 20:21:43', '2026-01-15 20:21:43', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 13:27:26', '0e038ced-90c2-44b6-b81a-55a559348a5b', '2026-01-16 21:27:25', '2026-01-16 21:27:25', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-15 11:00:16', '1116e7f1-ea1b-43e5-9e5e-2faf304c5362', '2026-01-15 19:00:16', '2026-01-15 19:00:16', 0);
INSERT INTO `login_logs` VALUES ('d3e906de-b9a6-4a78-a643-233252252776', 'zhangsan', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 15:39:07', '180d3034-d451-4a57-a7da-8be65871d971', '2026-01-16 23:39:06', '2026-01-16 23:39:06', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 03:42:59', '1a32bf81-707c-438c-bcf5-9f6d691e4097', '2026-01-16 11:42:59', '2026-01-16 11:42:59', 0);
INSERT INTO `login_logs` VALUES (NULL, 'zhangsan', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, '用户不存在', '2026-01-16 14:12:07', '1a9ba987-d06c-4a56-9475-73d7deb3fd71', '2026-01-16 22:12:07', '2026-01-16 22:12:07', 0);
INSERT INTO `login_logs` VALUES (NULL, 'zhangsan', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, '用户不存在', '2026-01-16 14:03:36', '1a9f41d6-eafe-469c-b749-f1cf574b87f1', '2026-01-16 22:03:36', '2026-01-16 22:03:36', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-17 13:51:25', '254c73e8-5a02-41cc-a2c4-e4d9afe7ce7f', '2026-01-17 21:51:25', '2026-01-17 21:51:25', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 15:34:03', '25d9a7a6-0906-4cdf-a26e-939f8eeec149', '2026-01-16 23:34:02', '2026-01-16 23:34:02', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'python-requests/2.32.3', 1, NULL, '2026-01-15 07:37:51', '2698241a-cde8-4a1e-926a-bda5c07a626e', '2026-01-15 15:37:51', '2026-01-15 15:37:51', 0);
INSERT INTO `login_logs` VALUES (NULL, 'zhangsan', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, '用户不存在', '2026-01-16 13:27:09', '27823254-d4a8-4c19-8baa-28f8a8b28fde', '2026-01-16 21:27:09', '2026-01-16 21:27:09', 0);
INSERT INTO `login_logs` VALUES ('d3e906de-b9a6-4a78-a643-233252252776', 'zhangsan', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 14:32:45', '2dbdb5a8-f034-4184-898c-90560a28f918', '2026-01-16 22:32:44', '2026-01-16 22:32:44', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'python-requests/2.32.3', 1, NULL, '2026-01-15 07:16:13', '2e158080-d36e-4d14-a46e-a08a848122e4', '2026-01-15 15:16:12', '2026-01-15 15:16:12', 0);
INSERT INTO `login_logs` VALUES ('d3e906de-b9a6-4a78-a643-233252252776', 'zhangsan', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 15:50:24', '2fa451fb-9805-4777-b21e-378286de3214', '2026-01-16 23:50:23', '2026-01-16 23:50:23', 0);
INSERT INTO `login_logs` VALUES ('d3e906de-b9a6-4a78-a643-233252252776', 'zhangsan', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 15:59:51', '33895869-2661-4631-8883-db9cdc70242a', '2026-01-16 23:59:50', '2026-01-16 23:59:50', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 13:20:28', '3bd6d06b-3ea8-4589-af0b-168294ae2c23', '2026-01-16 21:20:28', '2026-01-16 21:20:28', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, '密码错误，还有4次尝试机会', '2026-01-16 15:33:36', '3c67f66c-f495-4d4d-aad5-db440c26a28f', '2026-01-16 23:33:36', '2026-01-16 23:33:36', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-15 11:40:43', '449eaed4-f2c1-404d-9d8a-8daf7e4cb493', '2026-01-15 19:40:43', '2026-01-15 19:40:43', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 16:09:48', '46830e1a-3344-4e6d-b51b-8d5988b68b75', '2026-01-17 00:09:48', '2026-01-17 00:09:48', 0);
INSERT INTO `login_logs` VALUES (NULL, 'zhangsan', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, '用户不存在', '2026-01-16 13:25:23', '4a37b7b9-07b8-4cbf-8dac-c998048abbe4', '2026-01-16 21:25:23', '2026-01-16 21:25:23', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, '密码错误，还有4次尝试机会', '2026-01-16 15:18:05', '4b1ff279-8db7-4d3c-912e-ae25a6ff523e', '2026-01-16 23:18:04', '2026-01-16 23:18:04', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, '密码错误，还有3次尝试机会', '2026-01-16 04:54:14', '536c7599-9d49-4a99-a303-6721e2512b71', '2026-01-16 12:54:13', '2026-01-16 12:54:13', 0);
INSERT INTO `login_logs` VALUES ('357f8ac2-a271-440a-a003-0db32d15d302', 'app', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 14:33:13', '577b72e9-8f55-4c03-baa9-48ebc0c0af99', '2026-01-16 22:33:13', '2026-01-16 22:33:13', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'python-requests/2.32.3', 1, NULL, '2026-01-15 08:47:44', '597a830a-6a72-4092-9e8b-c05bcba6f167', '2026-01-15 16:47:44', '2026-01-15 16:47:44', 0);
INSERT INTO `login_logs` VALUES (NULL, 'zhangsan', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, '用户不存在', '2026-01-16 13:46:51', '5a6c98b9-36d7-4cad-804b-6ec2de09a8b3', '2026-01-16 21:46:50', '2026-01-16 21:46:50', 0);
INSERT INTO `login_logs` VALUES ('d3e906de-b9a6-4a78-a643-233252252776', 'zhangsan', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 16:06:34', '5ed2ea29-8692-427f-bd82-10858ba784f6', '2026-01-17 00:06:33', '2026-01-17 00:06:33', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 15:18:17', '65486584-444e-49a6-aa56-088ab16ba64d', '2026-01-16 23:18:16', '2026-01-16 23:18:16', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'python-requests/2.32.3', 0, '密码错误，还有4次尝试机会', '2026-01-15 07:22:54', '6ac00a23-6dba-439a-90cb-742cf058d857', '2026-01-15 15:22:54', '2026-01-15 15:22:54', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Test Script', 0, '密码错误，还有4次尝试机会', '2026-01-16 04:51:04', '729e6298-8b65-4683-9241-ad71ef866c7a', '2026-01-16 12:51:03', '2026-01-16 12:51:03', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 13:45:52', '743326f9-97eb-47bf-9fc3-1a17dd30d53e', '2026-01-16 21:45:51', '2026-01-16 21:45:51', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-15 11:26:18', '7835dfad-f11e-4308-ae3e-6e127eb7933b', '2026-01-15 19:26:18', '2026-01-15 19:26:18', 0);
INSERT INTO `login_logs` VALUES ('d3e906de-b9a6-4a78-a643-233252252776', 'zhangsan', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 15:34:40', '78fd7315-4786-4b99-8eb8-9d3d2c9ddfba', '2026-01-16 23:34:40', '2026-01-16 23:34:40', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 14:15:51', '7f28ce30-3618-44ab-8973-15f1da392f68', '2026-01-16 22:15:50', '2026-01-16 22:15:50', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-15 11:03:02', '86396600-dc31-492b-bafe-6fc077395253', '2026-01-15 19:03:02', '2026-01-15 19:03:02', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'python-requests/2.32.3', 1, NULL, '2026-01-15 07:37:47', '86dd8bc5-7b28-4b4a-9346-72d4f690e630', '2026-01-15 15:37:46', '2026-01-15 15:37:46', 0);
INSERT INTO `login_logs` VALUES (NULL, 'wuming', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, '用户不存在', '2026-01-16 13:47:00', '8999a5d2-79b4-4dd8-9e31-1888de3f3b6e', '2026-01-16 21:46:59', '2026-01-16 21:46:59', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 15:28:58', '90395468-3dba-417d-8fb4-284c7dd3ff71', '2026-01-16 23:28:57', '2026-01-16 23:28:57', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'python-requests/2.32.3', 1, NULL, '2026-01-16 04:59:19', '90f32be9-a1da-4420-9547-b80b1296747c', '2026-01-16 12:59:19', '2026-01-16 12:59:19', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 16:09:47', '96216e5d-3070-4a00-b689-efef9043e59e', '2026-01-17 00:09:46', '2026-01-17 00:09:46', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-15 08:20:24', '9907a19d-7620-403c-bcac-3fb9fe5439a8', '2026-01-15 16:20:24', '2026-01-15 16:20:24', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, '密码错误，还有3次尝试机会', '2026-01-16 15:31:54', '9d122a5e-be49-4fd9-bfb6-38c1e07e4a77', '2026-01-16 23:31:54', '2026-01-16 23:31:54', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-19 08:55:32', 'a1d6ec41-1692-4d34-b4c2-d964958832bd', '2026-01-19 16:55:32', '2026-01-19 16:55:32', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 15:32:02', 'a415976c-7f93-4f55-9993-cf7de9ce3802', '2026-01-16 23:32:02', '2026-01-16 23:32:02', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-15 10:59:30', 'a968be2a-e7c5-4931-8d0c-3cbb312412ee', '2026-01-15 18:59:29', '2026-01-15 18:59:29', 0);
INSERT INTO `login_logs` VALUES (NULL, 'zhangsan', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, '用户不存在', '2026-01-16 13:26:49', 'ab6c9ccd-3ab8-43a1-9a86-0f6a0725e487', '2026-01-16 21:26:48', '2026-01-16 21:26:48', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'python-requests/2.32.3', 1, NULL, '2026-01-15 07:29:25', 'b5f31827-bdc8-4a44-b712-2c9fb19fe3ce', '2026-01-15 15:29:25', '2026-01-15 15:29:25', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 04:54:36', 'b7d9550f-68c5-47ea-8f3e-d748028a2d11', '2026-01-16 12:54:36', '2026-01-16 12:54:36', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'python-requests/2.32.3', 1, NULL, '2026-01-15 07:22:50', 'ba98e8ff-522e-4ed5-94cb-06bda3f6ce7a', '2026-01-15 15:22:50', '2026-01-15 15:22:50', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-17 12:20:26', 'bb7f2583-2c8b-4f85-8922-2843ed4e25d8', '2026-01-17 20:20:26', '2026-01-17 20:20:26', 0);
INSERT INTO `login_logs` VALUES (NULL, 'wuming', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, '用户不存在', '2026-01-16 13:28:46', 'bc9a9866-5a69-4bb6-aac7-27563df6d92f', '2026-01-16 21:28:46', '2026-01-16 21:28:46', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, '密码错误，还有4次尝试机会', '2026-01-16 15:28:48', 'c4cb6b92-bc0b-40ad-be40-8ede78d13880', '2026-01-16 23:28:47', '2026-01-16 23:28:47', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-15 12:43:45', 'c50546c4-5fac-4058-912c-f7570cd86abf', '2026-01-15 20:43:45', '2026-01-15 20:43:45', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, '密码错误，还有4次尝试机会', '2026-01-16 15:31:44', 'c5bac267-441c-44bc-8ddf-482388c16ecc', '2026-01-16 23:31:44', '2026-01-16 23:31:44', 0);
INSERT INTO `login_logs` VALUES (NULL, 'zhangsan', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, '用户不存在', '2026-01-16 14:16:58', 'c5bef977-3cc6-4fc7-9b4b-64231db45aa0', '2026-01-16 22:16:57', '2026-01-16 22:16:57', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-15 07:35:40', 'c6118578-2e8e-404e-9f6f-a61b0dc5c256', '2026-01-15 15:35:39', '2026-01-15 15:35:39', 0);
INSERT INTO `login_logs` VALUES ('d3e906de-b9a6-4a78-a643-233252252776', 'zhangsan', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 15:40:00', 'cfe47968-be60-406c-a81f-65b3b39cfe4c', '2026-01-16 23:40:00', '2026-01-16 23:40:00', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-15 10:43:24', 'd16591f9-31be-4d1e-8828-0ff5331b9772', '2026-01-15 18:43:23', '2026-01-15 18:43:23', 0);
INSERT INTO `login_logs` VALUES (NULL, 'zhangsan', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, '用户不存在', '2026-01-16 14:30:35', 'd3365b97-1167-46f6-85e9-f2ffac27fc8f', '2026-01-16 22:30:35', '2026-01-16 22:30:35', 0);
INSERT INTO `login_logs` VALUES (NULL, 'test', 'password', '127.0.0.1', 'python-requests/2.32.3', 0, '用户不存在', '2026-01-16 13:37:10', 'd380cfc6-3f74-438a-9d3e-a364457a31e9', '2026-01-16 21:37:09', '2026-01-16 21:37:09', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'python-requests/2.32.3', 1, NULL, '2026-01-15 07:28:23', 'd5fea584-3ef2-402e-b2c3-54c534e32a85', '2026-01-15 15:28:23', '2026-01-15 15:28:23', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'python-requests/2.32.3', 1, NULL, '2026-01-15 08:50:36', 'd669dc49-b4b3-41ec-9f1b-e126af63891b', '2026-01-15 16:50:35', '2026-01-15 16:50:35', 0);
INSERT INTO `login_logs` VALUES (NULL, 'zhangsan', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, '用户不存在', '2026-01-16 14:03:27', 'd6800f6f-7b91-4b24-84bb-df6820c09146', '2026-01-16 22:03:27', '2026-01-16 22:03:27', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'python-requests/2.32.3', 1, NULL, '2026-01-16 13:37:03', 'da8de6fa-68f5-42b2-a62d-becf12c5633e', '2026-01-16 21:37:03', '2026-01-16 21:37:03', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-15 10:55:23', 'dbfd9205-be87-4186-8e2d-b9bc47c95e10', '2026-01-15 18:55:22', '2026-01-15 18:55:22', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'python-requests/2.32.3', 1, NULL, '2026-01-15 07:15:23', 'dc9b80db-f04f-4100-8ba1-625bf517ba31', '2026-01-15 15:15:22', '2026-01-15 15:15:22', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-15 10:33:39', 'dd86f2f4-0bf0-4785-af4c-033b580a6433', '2026-01-15 18:33:38', '2026-01-15 18:33:38', 0);
INSERT INTO `login_logs` VALUES ('d3e906de-b9a6-4a78-a643-233252252776', 'zhangsan', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 16:09:08', 'e1bc683b-3e31-4d00-a9ce-3a6ebdeef1da', '2026-01-17 00:09:08', '2026-01-17 00:09:08', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-15 07:38:18', 'e22eef77-29e3-42c3-b65c-9b2385c3e241', '2026-01-15 15:38:17', '2026-01-15 15:38:17', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 14:36:26', 'e43e3f74-9cef-43b1-b8a0-455d42d397dd', '2026-01-16 22:36:25', '2026-01-16 22:36:25', 0);
INSERT INTO `login_logs` VALUES (NULL, 'zhangsan', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, '用户不存在', '2026-01-16 14:29:18', 'e595c816-88f3-43fa-9a29-33c2a7ef6e95', '2026-01-16 22:29:18', '2026-01-16 22:29:18', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'python-requests/2.32.3', 1, NULL, '2026-01-15 07:30:14', 'e8fefc94-bb55-4078-9a62-fdff5cec6e5a', '2026-01-15 15:30:13', '2026-01-15 15:30:13', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-15 07:42:11', 'eaae3305-7a88-477b-90da-6d49538393ea', '2026-01-15 15:42:11', '2026-01-15 15:42:11', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'python-requests/2.32.3', 0, '密码错误，还有4次尝试机会', '2026-01-15 07:12:06', 'eae6ae14-2465-4302-9a93-26e658d04516', '2026-01-15 15:12:05', '2026-01-15 15:12:05', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, '密码错误，还有4次尝试机会', '2026-01-16 13:20:10', 'ee4e8089-5f2a-4fb9-83e8-261b33b63386', '2026-01-16 21:20:09', '2026-01-16 21:20:09', 0);
INSERT INTO `login_logs` VALUES (NULL, 'zhangsan', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, '用户不存在', '2026-01-16 13:46:42', 'ef3eeccc-8b62-47e6-88cf-2bbd6f72deab', '2026-01-16 21:46:41', '2026-01-16 21:46:41', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 13:25:48', 'f0afe0df-c6ff-4da9-b44d-c83185afb681', '2026-01-16 21:25:47', '2026-01-16 21:25:47', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Test Script', 1, NULL, '2026-01-16 04:52:24', 'f292acab-4bb0-4be1-9dd4-b16f6051fdb3', '2026-01-16 12:52:23', '2026-01-16 12:52:23', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'python-requests/2.32.3', 1, NULL, '2026-01-15 08:54:11', 'f44fff69-dbd9-4ab7-9abd-025f2836abc4', '2026-01-15 16:54:11', '2026-01-15 16:54:11', 0);
INSERT INTO `login_logs` VALUES (NULL, 'zhangsan', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 0, '用户不存在', '2026-01-16 14:15:59', 'f786393e-a255-413e-b887-443bf5686f5a', '2026-01-16 22:15:59', '2026-01-16 22:15:59', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-16 13:53:09', 'fa67bc08-8776-4956-84ff-a5d332239916', '2026-01-16 21:53:08', '2026-01-16 21:53:08', 0);
INSERT INTO `login_logs` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'admin', 'password', '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36', 1, NULL, '2026-01-15 08:51:26', 'fd0409c4-3233-40cb-bd85-bba2736a221f', '2026-01-15 16:51:25', '2026-01-15 16:51:25', 0);

-- ----------------------------
-- Table structure for menus
-- ----------------------------
DROP TABLE IF EXISTS `menus`;
CREATE TABLE `menus`  (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'uuid()',
  `parent_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '菜单名称',
  `title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '菜单标题',
  `path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '菜单路径',
  `component` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '组件路径',
  `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '菜单图标',
  `sort_order` int(0) NULL DEFAULT 0 COMMENT '排序顺序',
  `menu_type` enum('menu','button') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT 'menu' COMMENT '菜单类型',
  `is_hidden` tinyint(1) NULL DEFAULT 0 COMMENT '是否隐藏',
  `is_active` tinyint(1) NULL DEFAULT 1 COMMENT '是否启用',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '菜单描述',
  `created_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `updated_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_parent_id`(`parent_id`) USING BTREE,
  INDEX `idx_path`(`path`) USING BTREE,
  INDEX `idx_sort_order`(`sort_order`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '系统菜单表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of menus
-- ----------------------------
INSERT INTO `menus` VALUES ('admin-dashboard', 'admin-main', 'admin-dashboard', '管理概览', '/admin/dashboard', 'admin/Dashboard', 'Monitor', 1, 'menu', 0, 1, '管理员仪表盘', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('admin-dashboard-app-mgmt-btn', 'admin-dashboard', 'admin-dashboard-app-mgmt', '应用管理', NULL, NULL, 'Grid', 3, 'button', 0, 1, '快速跳转到应用管理', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('admin-dashboard-create-app-btn', 'admin-dashboard', 'admin-dashboard-create-app', '创建应用', NULL, NULL, 'Plus', 4, 'button', 0, 1, '快速创建应用', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('admin-dashboard-create-user-btn', 'admin-dashboard', 'admin-dashboard-create-user', '创建用户', NULL, NULL, 'Plus', 2, 'button', 0, 1, '快速创建用户', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('admin-dashboard-export-logs-btn', 'admin-dashboard', 'admin-dashboard-export-logs', '导出日志', NULL, NULL, 'Download', 6, 'button', 0, 1, '快速导出日志', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('admin-dashboard-settings-btn', 'admin-dashboard', 'admin-dashboard-settings', '系统设置', NULL, NULL, 'Tools', 7, 'button', 0, 1, '快速跳转到系统设置', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('admin-dashboard-user-mgmt-btn', 'admin-dashboard', 'admin-dashboard-user-mgmt', '用户管理', NULL, NULL, 'UserFilled', 1, 'button', 0, 1, '快速跳转到用户管理', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('admin-dashboard-view-logs-btn', 'admin-dashboard', 'admin-dashboard-view-logs', '查看日志', NULL, NULL, 'View', 5, 'button', 0, 1, '快速查看系统日志', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('admin-main', NULL, 'admin', '系统管理', '/admin', NULL, 'Setting', 3, 'menu', 0, 1, '系统管理功能', '2025-12-28 20:12:03', '2025-12-28 20:12:03');
INSERT INTO `menus` VALUES ('app-create-btn', 'app-management', 'app-create', '创建应用', NULL, NULL, 'Plus', 1, 'button', 0, 1, '创建OAuth2应用', '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `menus` VALUES ('app-delete-btn', 'app-management', 'app-delete', '删除应用', NULL, NULL, 'Delete', 3, 'button', 0, 1, '删除应用', '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `menus` VALUES ('app-edit-btn', 'app-management', 'app-edit', '编辑应用', NULL, NULL, 'Edit', 2, 'button', 0, 1, '编辑应用信息', '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `menus` VALUES ('app-management', 'admin-main', 'app-management', '应用管理', '/admin/apps', 'admin/Apps', 'Grid', 6, 'menu', 0, 1, 'OAuth2应用管理', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('app-reset-secret-btn', 'app-management', 'app-reset-secret', '重置密钥', NULL, NULL, 'RefreshRight', 5, 'button', 0, 1, '重置应用密钥', '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `menus` VALUES ('app-view-logs-btn', 'app-management', 'app-view-logs', '查看日志', NULL, NULL, 'Document', 6, 'button', 0, 1, '查看应用相关日志', '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `menus` VALUES ('app-view-secret-btn', 'app-management', 'app-view-secret', '查看密钥', NULL, NULL, 'View', 4, 'button', 0, 1, '查看应用密钥', '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `menus` VALUES ('dashboard-main', NULL, 'dashboard', '仪表盘', '/dashboard', 'dashboard/Index', 'House', 1, 'menu', 0, 1, '系统概览和统计信息', '2025-12-28 20:12:03', '2025-12-28 20:12:03');
INSERT INTO `menus` VALUES ('log-clear-btn', 'log-management', 'log-clear', '清理日志', NULL, NULL, 'Delete', 3, 'button', 0, 1, '清理历史日志', '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `menus` VALUES ('log-export-btn', 'log-management', 'log-export', '导出日志', NULL, NULL, 'Download', 2, 'button', 0, 1, '导出系统日志', '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `menus` VALUES ('log-management', 'admin-main', 'log-management', '系统日志', '/admin/logs', 'admin/Logs', 'Document', 7, 'menu', 0, 1, '系统操作日志', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('log-view-btn', 'log-management', 'log-view', '查看日志', NULL, NULL, 'View', 1, 'button', 0, 1, '查看系统日志', '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `menus` VALUES ('menu-create-btn', 'menu-management', 'menu-create', '创建菜单', NULL, NULL, 'Plus', 1, 'button', 0, 1, '创建新菜单', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('menu-delete-btn', 'menu-management', 'menu-delete', '删除菜单', NULL, NULL, 'Delete', 3, 'button', 0, 1, '删除菜单', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('menu-edit-btn', 'menu-management', 'menu-edit', '编辑菜单', NULL, NULL, 'Edit', 2, 'button', 0, 1, '编辑菜单信息', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('menu-management', 'admin-main', 'menu-management', '菜单管理', '/admin/menus', 'admin/Menus', 'Menu', 4, 'menu', 0, 1, '菜单结构管理', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('menu-sort-btn', 'menu-management', 'menu-sort', '排序菜单', NULL, NULL, 'Sort', 4, 'button', 0, 1, '调整菜单排序', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('permission-create-btn', 'permission-management', 'permission-create', '创建权限', NULL, NULL, 'Plus', 1, 'button', 0, 1, '创建新权限', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('permission-delete-btn', 'permission-management', 'permission-delete', '删除权限', NULL, NULL, 'Delete', 3, 'button', 0, 1, '删除权限', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('permission-edit-btn', 'permission-management', 'permission-edit', '编辑权限', NULL, NULL, 'Edit', 2, 'button', 0, 1, '编辑权限信息', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('permission-management', 'admin-main', 'permission-management', '权限管理', '/admin/permissions', 'admin/Permissions', 'Key', 5, 'menu', 0, 1, '权限配置管理', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('permission-view-roles-btn', 'permission-management', 'permission-view-roles', '查看角色', NULL, NULL, 'View', 4, 'button', 0, 1, '查看权限关联的角色', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('profile-change-password-btn', 'profile-main', 'profile-change-password', '修改密码', NULL, NULL, 'Key', 3, 'button', 0, 1, '修改登录密码', '2025-12-28 20:12:03', '2025-12-28 20:12:03');
INSERT INTO `menus` VALUES ('profile-main', NULL, 'profile', '个人资料', '/profile', 'user/Profile', 'User', 2, 'menu', 0, 1, '个人信息管理', '2025-12-28 20:12:03', '2025-12-29 21:24:37');
INSERT INTO `menus` VALUES ('profile-reset-btn', 'profile-main', 'profile-reset', '重置', NULL, NULL, 'RefreshLeft', 2, 'button', 0, 1, '重置个人资料表单', '2025-12-28 20:12:03', '2025-12-28 20:12:03');
INSERT INTO `menus` VALUES ('profile-save-btn', 'profile-main', 'profile-save', '保存修改', NULL, NULL, 'Check', 1, 'button', 0, 1, '保存个人资料修改', '2025-12-28 20:12:03', '2025-12-28 20:12:03');
INSERT INTO `menus` VALUES ('role-create-btn', 'role-management', 'role-create', '创建角色', NULL, NULL, 'Plus', 1, 'button', 0, 1, '创建新角色', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('role-delete-btn', 'role-management', 'role-delete', '删除角色', NULL, NULL, 'Delete', 3, 'button', 0, 1, '删除角色', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('role-edit-btn', 'role-management', 'role-edit', '编辑角色', NULL, NULL, 'Edit', 2, 'button', 0, 1, '编辑角色信息', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('role-management', 'admin-main', 'role-management', '角色管理', '/admin/roles', 'admin/Roles', 'Avatar', 3, 'menu', 0, 1, '角色权限管理', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('role-permission-mgmt-btn', 'role-management', 'role-permission-mgmt', '权限管理', NULL, NULL, 'Key', 4, 'button', 0, 1, '管理角色权限', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('settings-edit-btn', 'system-settings', 'settings-edit', '修改设置', NULL, NULL, 'Edit', 2, 'button', 0, 1, '修改系统设置', '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `menus` VALUES ('settings-view-btn', 'system-settings', 'settings-view', '查看设置', NULL, NULL, 'View', 1, 'button', 0, 1, '查看系统设置', '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `menus` VALUES ('system-settings', 'admin-main', 'system-settings', '系统设置', '/admin/settings', 'admin/Settings', 'Tools', 8, 'menu', 0, 1, '系统配置设置', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('user-assign-role-btn', 'user-management', 'user-assign-role', '分配角色', NULL, NULL, 'Avatar', 5, 'button', 0, 1, '为用户分配角色', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('user-batch-delete-btn', 'user-management', 'user-batch-delete', '批量删除用户', NULL, NULL, 'DeleteFilled', 4, 'button', 0, 1, '批量删除用户', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('user-create-btn', 'user-management', 'user-create', '创建用户', NULL, NULL, 'Plus', 1, 'button', 0, 1, '创建新用户', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('user-delete-btn', 'user-management', 'user-delete', '删除用户', NULL, NULL, 'Delete', 3, 'button', 0, 1, '删除用户', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('user-edit-btn', 'user-management', 'user-edit', '编辑用户', NULL, NULL, 'Edit', 2, 'button', 0, 1, '编辑用户信息', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('user-management', 'admin-main', 'user-management', '用户管理', '/admin/users', 'admin/Users', 'UserFilled', 2, 'menu', 0, 1, '用户信息管理', '2025-12-28 20:12:04', '2025-12-28 20:12:04');
INSERT INTO `menus` VALUES ('user-reset-password-btn', 'user-management', 'user-reset-password', '重置密码', NULL, NULL, 'Key', 6, 'button', 0, 1, '重置用户密码', '2025-12-28 20:12:04', '2025-12-28 20:12:04');

-- ----------------------------
-- Table structure for oauth_access_tokens
-- ----------------------------
DROP TABLE IF EXISTS `oauth_access_tokens`;
CREATE TABLE `oauth_access_tokens`  (
  `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户ID',
  `app_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '应用ID（系统内部登录时可为空）',
  `token` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '访问令牌',
  `refresh_token` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '刷新令牌',
  `token_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '令牌类型',
  `scope` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '权限范围',
  `expires_at` datetime(0) NOT NULL COMMENT '过期时间',
  `revoked` tinyint(1) NULL DEFAULT NULL COMMENT '是否撤销',
  `last_used_at` datetime(0) NULL DEFAULT NULL COMMENT '最后使用时间',
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '主键ID',
  `created_at` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` tinyint(1) NULL DEFAULT NULL COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `token`(`token`) USING BTREE,
  UNIQUE INDEX `refresh_token`(`refresh_token`) USING BTREE,
  INDEX `user_id`(`user_id`) USING BTREE,
  INDEX `app_id`(`app_id`) USING BTREE,
  CONSTRAINT `oauth_access_tokens_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `oauth_access_tokens_ibfk_2` FOREIGN KEY (`app_id`) REFERENCES `apps` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of oauth_access_tokens
-- ----------------------------
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 16:04:03', 0, NULL, '01ab2ea6-ccc9-4a85-b0bf-b1fbcef31a54', '2026-01-16 23:34:02', '2026-01-16 23:34:02', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 13:55:48', 0, '2026-01-16 13:25:48', '04972ce7-e866-4805-8b77-991f69e5ed05', '2026-01-16 21:25:47', '2026-01-16 21:25:48', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 13:13:45', 0, '2026-01-15 12:43:45', '06e74418-ddf2-4bee-9c08-79b331aea03b', '2026-01-15 20:43:45', '2026-01-15 20:43:45', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 08:12:11', 0, NULL, '0766972d-e1c7-477c-90e7-7d642dd58d32', '2026-01-15 15:42:11', '2026-01-15 15:42:11', 0);
INSERT INTO `oauth_access_tokens` VALUES ('d3e906de-b9a6-4a78-a643-233252252776', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 16:39:08', 0, NULL, '154a01a7-d70a-4f9b-8920-38172deb588c', '2026-01-17 00:09:08', '2026-01-17 00:09:08', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 15:48:17', 0, NULL, '188ec5bd-10fb-4ee9-a878-97f25a8f1b7d', '2026-01-16 23:18:16', '2026-01-16 23:18:16', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-19 09:25:32', 0, '2026-01-19 09:02:36', '19b3d123-179c-4c2b-8c87-e00c3535c81a', '2026-01-19 16:55:32', '2026-01-19 17:02:35', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 08:50:24', 0, NULL, '1be15c8b-ee99-4dcd-87d4-4dab05d63e2a', '2026-01-15 16:20:24', '2026-01-15 16:20:24', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 08:05:40', 0, NULL, '22081fde-f3d5-43b6-bcd5-0b499eb354d3', '2026-01-15 15:35:39', '2026-01-15 15:35:39', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 05:22:24', 0, NULL, '2217a24c-5cee-4f16-bd6b-d0d166717fb9', '2026-01-16 12:52:23', '2026-01-16 12:52:23', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 09:21:26', 0, '2026-01-15 08:51:28', '24a12aa6-ddf8-4993-89f4-63e07e44ca5a', '2026-01-15 16:51:25', '2026-01-15 16:51:28', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 11:03:39', 0, '2026-01-15 10:33:39', '29903e10-70d3-4177-9fa1-39769f2a62ef', '2026-01-15 18:33:39', '2026-01-15 18:33:39', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 14:15:49', 0, '2026-01-16 13:45:52', '2bbb98c6-d772-4473-bb3a-826c24c7909c', '2026-01-16 21:45:51', '2026-01-16 21:45:51', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 11:25:23', 0, '2026-01-15 10:55:23', '316900f6-d7a4-46f8-9f2c-d35010eee126', '2026-01-15 18:55:22', '2026-01-15 18:55:22', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 14:07:03', 0, NULL, '34af98f8-5b25-45e0-acdf-9912a32eaded', '2026-01-16 21:37:03', '2026-01-16 21:37:03', 0);
INSERT INTO `oauth_access_tokens` VALUES ('d3e906de-b9a6-4a78-a643-233252252776', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 16:36:34', 0, NULL, '3e735c46-0e2b-4b9a-b2b4-be033ba14c7a', '2026-01-17 00:06:33', '2026-01-17 00:06:33', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 11:29:30', 0, '2026-01-15 10:59:30', '3f90461a-8891-4123-b52c-3f0e89503a6f', '2026-01-15 18:59:29', '2026-01-15 18:59:30', 0);
INSERT INTO `oauth_access_tokens` VALUES ('357f8ac2-a271-440a-a003-0db32d15d302', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 15:03:13', 0, '2026-01-16 14:33:13', '425cd6f3-30bb-4036-89b6-b750357c390a', '2026-01-16 22:33:13', '2026-01-16 22:33:13', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 11:15:36', 0, '2026-01-15 10:45:36', '44e315c3-0504-4e82-bdf7-6792ad629b76', '2026-01-15 18:45:35', '2026-01-15 18:45:36', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 12:51:43', 0, '2026-01-15 12:21:46', '45ca6ea2-b432-48e3-8917-f9e90d76373c', '2026-01-15 20:21:43', '2026-01-15 20:21:45', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 17:46:59', 0, '2026-01-16 17:16:59', '45ef27db-bfd1-4251-847b-e279a6a59367', '2026-01-17 01:16:58', '2026-01-17 01:16:58', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 05:29:19', 0, NULL, '4a3a37ef-a0f4-4093-af75-35f5a6b5bd14', '2026-01-16 12:59:19', '2026-01-16 12:59:19', 0);
INSERT INTO `oauth_access_tokens` VALUES ('d3e906de-b9a6-4a78-a643-233252252776', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 16:10:00', 0, NULL, '4c0ac3d4-a7d4-416c-bad7-0f345daefa11', '2026-01-16 23:40:00', '2026-01-16 23:40:00', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 15:06:26', 0, '2026-01-16 14:36:28', '4c6c0191-6855-4c60-a7d2-f55b9fee5f1f', '2026-01-16 22:36:25', '2026-01-16 22:36:27', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 08:05:20', 0, NULL, '500336f4-9de7-480d-b757-d5421db220d3', '2026-01-15 15:35:19', '2026-01-15 15:35:19', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 14:45:51', 0, '2026-01-16 14:15:51', '5b9d9fc8-060e-41b3-8e67-bd639ae01689', '2026-01-16 22:15:50', '2026-01-16 22:15:50', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 11:13:24', 0, '2026-01-15 10:43:24', '5c898b5f-45ed-41e8-bdb0-2012e4ea373b', '2026-01-15 18:43:23', '2026-01-15 18:43:24', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 13:50:28', 0, '2026-01-16 13:20:29', '6047879d-71a1-470d-bc8e-4400bc86824a', '2026-01-16 21:20:28', '2026-01-16 21:20:28', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 16:21:00', 0, NULL, '65412b9c-176c-4590-9682-9b0580a39318', '2026-01-16 23:50:59', '2026-01-16 23:50:59', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-17 12:50:26', 0, '2026-01-17 12:20:27', '6984468d-f9be-495f-b893-23fa438008cb', '2026-01-17 20:20:26', '2026-01-17 20:20:26', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 08:07:51', 0, NULL, '72c5756c-42cc-479c-8ac9-a7a2a86c533e', '2026-01-15 15:37:51', '2026-01-15 15:37:51', 0);
INSERT INTO `oauth_access_tokens` VALUES ('d3e906de-b9a6-4a78-a643-233252252776', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 16:20:24', 0, NULL, '74de929d-1e34-479f-8543-465953e72232', '2026-01-16 23:50:23', '2026-01-16 23:50:23', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 05:24:36', 0, '2026-01-16 05:01:22', '7d6ee32f-baf3-4d3e-b78f-9c9324a8e746', '2026-01-16 12:54:36', '2026-01-16 13:01:21', 0);
INSERT INTO `oauth_access_tokens` VALUES ('d3e906de-b9a6-4a78-a643-233252252776', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 16:09:07', 0, NULL, '817f5e9d-6f2f-43f4-9620-c39415673ca1', '2026-01-16 23:39:06', '2026-01-16 23:39:06', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 07:45:23', 0, NULL, '828d4d8e-2c8f-450c-9046-8a8efa434775', '2026-01-15 15:15:22', '2026-01-15 15:15:22', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 04:12:59', 0, '2026-01-16 03:49:52', '8a10fb8c-d557-48b5-8214-f3e378073c5f', '2026-01-16 11:42:59', '2026-01-16 11:49:51', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 11:33:02', 0, '2026-01-15 11:26:04', '91e287e8-9154-49ae-ac22-3d99056709d8', '2026-01-15 19:03:02', '2026-01-15 19:26:03', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-17 14:21:25', 0, '2026-01-17 13:51:25', '978b341c-9861-4606-acee-dea2dba79693', '2026-01-17 21:51:25', '2026-01-17 21:51:25', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 12:10:43', 0, '2026-01-15 11:40:44', '99ebe918-1ebb-4e61-bea3-1116f35302e0', '2026-01-15 19:40:43', '2026-01-15 19:40:43', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 11:30:16', 0, '2026-01-15 11:00:16', '9a196489-cab3-4ab5-aa11-6e1e137f395c', '2026-01-15 19:00:16', '2026-01-15 19:00:16', 0);
INSERT INTO `oauth_access_tokens` VALUES ('d3e906de-b9a6-4a78-a643-233252252776', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 15:02:45', 0, '2026-01-16 14:32:45', '9c9ce86f-3907-4ef4-a967-dabd3082fb63', '2026-01-16 22:32:44', '2026-01-16 22:32:45', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 07:58:23', 0, NULL, 'a0d21a29-d7c3-47fa-ae4e-ac5066bf305c', '2026-01-15 15:28:23', '2026-01-15 15:28:23', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 08:08:18', 0, NULL, 'a19fe082-cf0c-4908-9e8a-31bddf28b959', '2026-01-15 15:38:17', '2026-01-15 15:38:17', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 09:17:44', 0, NULL, 'a38bb218-b064-4fd2-9d2c-5a6c9fafe6c0', '2026-01-15 16:47:44', '2026-01-15 16:47:44', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 09:20:36', 0, '2026-01-15 08:50:40', 'a57556bf-1a3e-4039-9646-7b6024553add', '2026-01-15 16:50:35', '2026-01-15 16:50:40', 0);
INSERT INTO `oauth_access_tokens` VALUES ('d3e906de-b9a6-4a78-a643-233252252776', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 16:23:15', 0, NULL, 'ab33d96b-d6f9-4500-ad24-032943619792', '2026-01-16 23:53:14', '2026-01-16 23:53:14', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 07:46:17', 0, '2026-01-15 07:16:17', 'affe9f44-c772-44ad-86e3-271c8146d6e6', '2026-01-15 15:16:12', '2026-01-15 15:16:17', 0);
INSERT INTO `oauth_access_tokens` VALUES ('d3e906de-b9a6-4a78-a643-233252252776', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 16:29:51', 0, NULL, 'b8b3ff0a-c7f8-4019-91fd-a42ef50681a4', '2026-01-16 23:59:50', '2026-01-16 23:59:50', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 07:59:25', 0, NULL, 'be4bafc8-e401-434d-8328-8253b4d49155', '2026-01-15 15:29:25', '2026-01-15 15:29:25', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 14:42:39', 0, '2026-01-16 14:12:39', 'c514dd31-1ea3-41ee-9780-1906d22a5489', '2026-01-16 22:12:38', '2026-01-16 22:12:38', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 14:23:09', 0, '2026-01-16 13:53:11', 'c7101bd1-de71-47a9-87c7-d8bdc8c853ab', '2026-01-16 21:53:08', '2026-01-16 21:53:10', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 16:39:48', 0, NULL, 'ceab528b-327b-418d-bd65-76808b62ba12', '2026-01-17 00:09:48', '2026-01-17 00:09:48', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 08:07:47', 0, NULL, 'd1981de0-a6c2-450f-aaad-fe4803133804', '2026-01-15 15:37:46', '2026-01-15 15:37:46', 0);
INSERT INTO `oauth_access_tokens` VALUES ('d3e906de-b9a6-4a78-a643-233252252776', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 16:04:40', 0, NULL, 'd47b353b-227a-4644-af39-0eaac5ade3f3', '2026-01-16 23:34:40', '2026-01-16 23:34:40', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 13:57:26', 0, '2026-01-16 13:27:26', 'da14db9f-d434-4c94-9559-8fca96061990', '2026-01-16 21:27:25', '2026-01-16 21:27:26', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 07:52:50', 0, '2026-01-15 07:22:52', 'ddd66acf-5361-43b1-9b81-9d8ba3b4488f', '2026-01-15 15:22:50', '2026-01-15 15:22:52', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 09:24:18', 0, '2026-01-15 08:54:18', 'df92442e-2152-43f8-b0c2-ae1df77cf25a', '2026-01-15 16:54:11', '2026-01-15 16:54:17', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 08:00:14', 0, NULL, 'e0ea55c3-727c-4d98-896b-c95a7a51c6a9', '2026-01-15 15:30:13', '2026-01-15 15:30:13', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 16:39:47', 0, NULL, 'e624ab12-1388-4934-a43d-57549f01966a', '2026-01-17 00:09:46', '2026-01-17 00:09:46', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 11:56:18', 0, '2026-01-15 11:26:18', 'ebade98b-aba5-4c57-b264-8fe49adf884e', '2026-01-15 19:26:18', '2026-01-15 19:26:18', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-15 09:17:05', 0, NULL, 'f1a4cf47-2bb8-4efc-880d-225b6afad682', '2026-01-15 16:47:04', '2026-01-15 16:47:04', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 15:58:58', 0, NULL, 'f1c5542c-1079-4adb-82d8-dded385eca11', '2026-01-16 23:28:57', '2026-01-16 23:28:57', 0);
INSERT INTO `oauth_access_tokens` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', NULL, '[REDACTED], '[REDACTED], 'Bearer', 'profile email', '2026-01-16 16:02:02', 0, NULL, 'ff2c343b-2bc4-43a8-9dc9-80feafe718df', '2026-01-16 23:32:02', '2026-01-16 23:32:02', 0);

-- ----------------------------
-- Table structure for oauth_authorization_codes
-- ----------------------------
DROP TABLE IF EXISTS `oauth_authorization_codes`;
CREATE TABLE `oauth_authorization_codes`  (
  `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户ID',
  `app_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '应用ID',
  `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '授权码',
  `redirect_uri` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '回调URL',
  `scope` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '权限范围',
  `expires_at` datetime(0) NOT NULL COMMENT '过期时间',
  `used` tinyint(1) NULL DEFAULT NULL COMMENT '是否已使用',
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '主键ID',
  `created_at` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` tinyint(1) NULL DEFAULT NULL COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `code`(`code`) USING BTREE,
  INDEX `user_id`(`user_id`) USING BTREE,
  INDEX `app_id`(`app_id`) USING BTREE,
  CONSTRAINT `oauth_authorization_codes_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `oauth_authorization_codes_ibfk_2` FOREIGN KEY (`app_id`) REFERENCES `apps` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of oauth_authorization_codes
-- ----------------------------
INSERT INTO `oauth_authorization_codes` VALUES ('d3e906de-b9a6-4a78-a643-233252252776', 'b0886209-7eb8-433e-82ac-2a19d947215b', '7aCzG_OwiI2kmoUGkOHzUxnwjqmUGKWJLst8wKrbbms', 'http://localhost:8001/auth/callback', 'profile email', '2026-01-17 00:16:37', 0, '026b6571-ca16-4a38-926b-b5586376fb40', '2026-01-17 00:06:37', '2026-01-17 00:06:37', 0);
INSERT INTO `oauth_authorization_codes` VALUES ('d3e906de-b9a6-4a78-a643-233252252776', 'b0886209-7eb8-433e-82ac-2a19d947215b', 'DXFUF6pdBr56_UwC2t9-V44LbPIBMVJU78iDQKBRsIE', 'http://localhost:8001/auth/callback', 'profile email', '2026-01-17 00:19:10', 1, '798d5ece-9b22-4cb0-84f2-dcc10bad52ec', '2026-01-17 00:09:09', '2026-01-17 00:09:10', 0);
INSERT INTO `oauth_authorization_codes` VALUES ('ed6a79d3-0083-4d81-8b48-fc522f686f74', 'b0886209-7eb8-433e-82ac-2a19d947215b', '-OQp0xEqLtgbiJL-4Rl2IIHi0qxEfMnLL-_wpOLkZ2c', 'http://localhost:8001/auth/callback', 'profile email', '2026-01-17 00:19:48', 1, 'f3f8bb45-6386-460c-92c1-a05d15966042', '2026-01-17 00:09:47', '2026-01-17 00:09:48', 0);

-- ----------------------------
-- Table structure for operation_logs
-- ----------------------------
DROP TABLE IF EXISTS `operation_logs`;
CREATE TABLE `operation_logs`  (
  `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '用户ID',
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户名',
  `operation_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '操作类型',
  `target_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '目标类型',
  `target_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '目标ID',
  `operation_detail` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '操作详情',
  `ip_address` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT 'IP地址',
  `user_agent` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '用户代理',
  `operation_time` datetime(0) NULL DEFAULT NULL COMMENT '操作时间',
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '主键ID',
  `created_at` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` tinyint(1) NULL DEFAULT NULL COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `user_id`(`user_id`) USING BTREE,
  CONSTRAINT `operation_logs_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of operation_logs
-- ----------------------------

-- ----------------------------
-- Table structure for permissions
-- ----------------------------
DROP TABLE IF EXISTS `permissions`;
CREATE TABLE `permissions`  (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'uuid()',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '权限名称',
  `display_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '权限显示名称',
  `resource` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '资源标识',
  `action` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '操作类型',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '权限描述',
  `is_active` tinyint(1) NULL DEFAULT 1 COMMENT '是否启用',
  `created_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `updated_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `name`(`name`) USING BTREE,
  UNIQUE INDEX `uk_resource_action`(`resource`, `action`) USING BTREE,
  INDEX `idx_name`(`name`) USING BTREE,
  INDEX `idx_resource_action`(`resource`, `action`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '权限表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of permissions
-- ----------------------------
INSERT INTO `permissions` VALUES ('1112cb4b-6aa1-4a33-a101-19f03a9cf97d', 'profile.reset', '重置个人资料', 'profile', 'reset', '重置个人资料表单', 1, '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `permissions` VALUES ('1dfd0c16-4e37-45b1-8d9c-199a37bbc3dd', 'permission.create', '创建权限', 'permission', 'create', '创建新权限', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('2a0e73eb-2ae7-4931-adcf-f19ebd803086', 'permission.edit', '编辑权限', 'permission', 'edit', '编辑权限信息', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('39bfae6f-cd22-4181-93c3-484f1cd92bde', 'admin.quick_create_user', '快速创建用户', 'admin', 'quick_create_user', '快速创建用户', 1, '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `permissions` VALUES ('3a3eb9b3-5f9d-4db3-a0f4-c88df89432bb', 'permission.view', '查看权限', 'permission', 'view', '查看权限列表和详情', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('3f37eac8-95e0-4309-9fea-107f012c1d50', 'role.create', '创建角色', 'role', 'create', '创建新角色', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('3fc9e4ff-0799-44ab-a931-015492bec262', 'menu.view', '查看菜单', 'menu', 'view', '查看菜单列表和详情', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('424ddb3b-3f5c-43ac-a395-ba1bf7b731b1', 'profile.change_password', '修改密码', 'profile', 'change_password', '修改登录密码', 1, '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `permissions` VALUES ('4e567594-cddb-46e0-93c8-3e3eca11e857', 'app.view_logs', '查看应用日志', 'app', 'view_logs', '查看应用相关日志', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('62e50fed-8f7d-4528-b9d1-952c602c3f7e', 'user.assign_role', '分配用户角色', 'user', 'assign_role', '为用户分配角色', 1, '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `permissions` VALUES ('634ff303-c07d-4894-b578-dc26e95b4dd1', 'menu.edit', '编辑菜单', 'menu', 'edit', '编辑菜单信息', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('6b645f42-d968-462c-855b-4c670ff75473', 'user.delete', '删除用户', 'user', 'delete', '删除用户', 1, '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `permissions` VALUES ('6b73e1ca-a449-471b-8209-1a6bb7367fa6', 'menu.delete', '删除菜单', 'menu', 'delete', '删除菜单', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('6b8e5541-9c6b-4221-bb8b-cee868038bc9', 'permission.delete', '删除权限', 'permission', 'delete', '删除权限', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('6f2263c0-e21b-4b89-967a-c0b9b675e215', 'app.edit', '编辑应用', 'app', 'edit', '编辑应用信息', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('723b8e42-b440-466e-88f3-e22a68e2c50d', 'role.permission_mgmt', '角色权限管理', 'role', 'permission_mgmt', '管理角色权限', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('72caa485-c205-491f-9df1-0f1dea041b09', 'admin.quick_view_logs', '快速查看日志', 'admin', 'quick_view_logs', '快速查看系统日志', 1, '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `permissions` VALUES ('78580ca0-a5fd-441f-8a3f-fe85550dc3f9', 'log.clear', '清理系统日志', 'log', 'clear', '清理历史日志', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('7bf1c1bb-1e56-45ce-8f4c-8c3a78336ca5', 'admin.quick_app_mgmt', '快速应用管理', 'admin', 'quick_app_mgmt', '快速跳转到应用管理', 1, '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `permissions` VALUES ('7ed8db1b-65e6-4bf4-aa1d-9230782995dc', 'role.delete', '删除角色', 'role', 'delete', '删除角色', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('7f5894b1-f887-4395-8a58-d86aeaea76f4', 'admin.quick_create_app', '快速创建应用', 'admin', 'quick_create_app', '快速创建应用', 1, '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `permissions` VALUES ('98171660-41ac-44be-823c-70d2cd7cf9ea', 'log.export', '导出系统日志', 'log', 'export', '导出系统日志', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('9cf0a039-964c-4ae2-9d8a-13ffeee8f31a', 'permission.view_roles', '查看权限角色', 'permission', 'view_roles', '查看权限关联的角色', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('a3a5e0ad-7835-42aa-97ea-dba6dfe8a372', 'settings.view', '查看系统设置', 'settings', 'view', '查看系统配置', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('a487d73b-2f48-44be-8a2e-ec4b9c0cd757', 'settings.edit', '修改系统设置', 'settings', 'edit', '修改系统配置', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('a5a4a35a-0669-4e45-9ea2-ecdf1d21e0d6', 'app.delete', '删除应用', 'app', 'delete', '删除应用', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('aba948f2-6be3-408a-9267-d81ff5f7ffbd', 'role.view', '查看角色', 'role', 'view', '查看角色列表和详情', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('b1243446-dcf6-4442-9cd4-c9d05cdb6e31', 'app.view', '查看应用', 'app', 'view', '查看应用列表和详情', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('b27ef5d4-9c7e-4430-bafe-572a30204361', 'user.reset_password', '重置用户密码', 'user', 'reset_password', '重置用户密码', 1, '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `permissions` VALUES ('b29d2fdf-c77d-4aa3-bccc-43c453bcfa38', 'admin.quick_settings', '快速系统设置', 'admin', 'quick_settings', '快速跳转到系统设置', 1, '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `permissions` VALUES ('b2cb3d37-c637-448d-8dac-023b6fe90cf5', 'profile.save', '保存个人资料', 'profile', 'save', '保存个人资料修改', 1, '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `permissions` VALUES ('b73490e8-cec3-4b3a-9293-f7a84a81ee3c', 'user.create', '创建用户', 'user', 'create', '创建新用户', 1, '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `permissions` VALUES ('bbec381d-8e5c-43e8-bf01-69f4f4febd72', 'user.view', '查看用户', 'user', 'view', '查看用户列表和详情', 1, '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `permissions` VALUES ('c1cf31b4-d4a2-41c3-b138-5ea4286f8477', 'user.batch_delete', '批量删除用户', 'user', 'batch_delete', '批量删除用户', 1, '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `permissions` VALUES ('c20d7fb2-37c5-4440-9794-4bc6f0b4ca00', 'app.reset_secret', '重置应用密钥', 'app', 'reset_secret', '重置应用密钥', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('c4f58f90-c90c-48b2-9d29-1314e0ab67f3', 'app.view_secret', '查看应用密钥', 'app', 'view_secret', '查看应用密钥', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('c595ac1e-a81a-4fef-b841-a1284eb73efb', 'menu.sort', '排序菜单', 'menu', 'sort', '调整菜单排序', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('c8e52fa1-352f-4f77-acac-72eaf6c43844', 'admin.quick_export_logs', '快速导出日志', 'admin', 'quick_export_logs', '快速导出日志', 1, '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `permissions` VALUES ('ca3d82f2-e141-4567-aea1-31f1119f8fc8', 'role.edit', '编辑角色', 'role', 'edit', '编辑角色信息', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('d80327b7-4b9d-4d8e-a6b4-babe12c652fc', 'app.create', '创建应用', 'app', 'create', '创建OAuth2应用', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('d865df3b-6191-4afc-b7b6-21769f2eb707', 'admin.quick_user_mgmt', '快速用户管理', 'admin', 'quick_user_mgmt', '快速跳转到用户管理', 1, '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `permissions` VALUES ('da8e2c18-b9ff-47fb-b458-65e4011e4c9b', 'menu.create', '创建菜单', 'menu', 'create', '创建新菜单', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');
INSERT INTO `permissions` VALUES ('e33e8f5f-c3ab-4044-93d3-667a82b0bfcf', 'user.edit', '编辑用户', 'user', 'edit', '编辑用户信息', 1, '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `permissions` VALUES ('eb50fc6e-072d-4a20-85bc-ecc0ffb5ac22', 'admin.dashboard', '管理概览', 'admin', 'dashboard', '查看管理概览', 1, '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `permissions` VALUES ('f43ae9a1-8fa5-436e-9bdb-a0f9f04e0726', 'log.view', '查看系统日志', 'log', 'view', '查看系统操作日志', 1, '2025-12-28 20:12:06', '2025-12-28 20:12:06');

-- ----------------------------
-- Table structure for role_menus
-- ----------------------------
DROP TABLE IF EXISTS `role_menus`;
CREATE TABLE `role_menus`  (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'uuid()',
  `role_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `menu_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `created_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_role_menu`(`role_id`, `menu_id`) USING BTREE,
  INDEX `idx_role_id`(`role_id`) USING BTREE,
  INDEX `idx_menu_id`(`menu_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色菜单关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of role_menus
-- ----------------------------
INSERT INTO `role_menus` VALUES ('3d029ecb-e3f4-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', 'dashboard-main', '2025-12-28 21:50:58');
INSERT INTO `role_menus` VALUES ('40d7d14c-e4c0-11f0-b8db-54e1ad33a445', '17d6801a-ef95-4290-b097-22a7e34805e0', 'admin-main', '2025-12-29 22:11:22');
INSERT INTO `role_menus` VALUES ('4af7ff5c-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'dashboard-main', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af8146f-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'profile-main', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af82119-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'profile-save-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af82e39-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'profile-reset-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af83d19-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'profile-change-password-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af84a81-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'admin-main', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af859b6-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'admin-dashboard', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af869fa-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'admin-dashboard-user-mgmt-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af87a3f-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'admin-dashboard-create-user-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af88649-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'admin-dashboard-app-mgmt-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af8920c-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'admin-dashboard-create-app-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af8c647-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'admin-dashboard-view-logs-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af8d855-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'admin-dashboard-export-logs-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af8e79d-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'admin-dashboard-settings-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af8fa73-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'user-management', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af90ca2-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'user-create-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af9206c-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'user-edit-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af92c39-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'user-delete-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af9402d-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'user-batch-delete-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af96843-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'user-assign-role-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af9800e-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'user-reset-password-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af99e8b-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'role-management', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af9ad85-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'role-create-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af9b97b-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'role-edit-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af9c555-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'role-delete-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af9d393-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'role-permission-mgmt-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af9df1a-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'menu-management', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af9ea64-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'menu-create-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4af9f5da-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'menu-edit-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4afa0111-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'menu-delete-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4afa0c47-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'menu-sort-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4afa17d4-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'permission-management', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4afa23df-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'permission-create-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4afa2f4b-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'permission-edit-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4afa3a89-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'permission-delete-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4afa460c-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'permission-view-roles-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4afa5143-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'app-management', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4afa61ac-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'app-create-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4afa6d17-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'app-edit-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4afa7a72-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'app-delete-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4afa8856-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'app-view-secret-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4afa943b-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'app-reset-secret-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4afaa0ca-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'app-view-logs-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4afaac23-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'log-management', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4afab988-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'log-view-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4afac4cd-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'log-export-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4afacf9b-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'log-clear-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4afad8b9-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'system-settings', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4afae336-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'settings-view-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('4afaed2e-e4bb-11f0-b8db-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'settings-edit-btn', '2025-12-29 21:35:51');
INSERT INTO `role_menus` VALUES ('71436011-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'dashboard-main', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('714797e5-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'profile-main', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('714bc214-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'admin-main', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('71500d5c-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'admin-dashboard', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('71543bb2-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'user-management', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('715883a1-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'role-management', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('715c9bfa-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'admin-dashboard-app-mgmt-btn', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('7160f72d-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'admin-dashboard-create-app-btn', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('71650d35-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'admin-dashboard-create-user-btn', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('71695fa9-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'admin-dashboard-export-logs-btn', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('716d7c50-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'admin-dashboard-settings-btn', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('7171d85c-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'admin-dashboard-user-mgmt-btn', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('7175f6f6-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'admin-dashboard-view-logs-btn', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('717a54a1-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'profile-change-password-btn', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('718467b6-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'profile-reset-btn', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('71889c08-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'profile-save-btn', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('718ce099-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'role-create-btn', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('719102be-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'role-delete-btn', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('7195489a-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'role-edit-btn', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('719971e5-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'role-permission-mgmt-btn', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('719dbb9e-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'user-assign-role-btn', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('71a1e5d1-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'user-batch-delete-btn', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('71a6386d-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'user-create-btn', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('71aa611b-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'user-delete-btn', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('71ae9f1e-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'user-edit-btn', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('71b2da11-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'user-reset-password-btn', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('71b7419c-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'dashboard-main', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('71bb3a28-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'profile-main', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('71bf8e46-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'admin-main', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('71c3b5e7-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'admin-dashboard', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('71c803cf-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'app-management', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('71cc33b5-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'admin-dashboard-app-mgmt-btn', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('71d07406-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'admin-dashboard-create-app-btn', '2025-12-28 20:12:13');
INSERT INTO `role_menus` VALUES ('71d4aaaa-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'admin-dashboard-create-user-btn', '2025-12-28 20:12:14');
INSERT INTO `role_menus` VALUES ('71d91ce3-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'admin-dashboard-export-logs-btn', '2025-12-28 20:12:14');
INSERT INTO `role_menus` VALUES ('71dd10fe-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'admin-dashboard-settings-btn', '2025-12-28 20:12:14');
INSERT INTO `role_menus` VALUES ('71e14e50-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'admin-dashboard-user-mgmt-btn', '2025-12-28 20:12:14');
INSERT INTO `role_menus` VALUES ('71e571c0-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'admin-dashboard-view-logs-btn', '2025-12-28 20:12:14');
INSERT INTO `role_menus` VALUES ('71e9c4ec-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'app-create-btn', '2025-12-28 20:12:14');
INSERT INTO `role_menus` VALUES ('71ede72a-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'app-delete-btn', '2025-12-28 20:12:14');
INSERT INTO `role_menus` VALUES ('71fb58cc-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'app-edit-btn', '2025-12-28 20:12:14');
INSERT INTO `role_menus` VALUES ('71ffc56a-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'app-reset-secret-btn', '2025-12-28 20:12:14');
INSERT INTO `role_menus` VALUES ('72057e95-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'app-view-logs-btn', '2025-12-28 20:12:14');
INSERT INTO `role_menus` VALUES ('7209e51f-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'app-view-secret-btn', '2025-12-28 20:12:14');
INSERT INTO `role_menus` VALUES ('720defcb-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'profile-change-password-btn', '2025-12-28 20:12:14');
INSERT INTO `role_menus` VALUES ('7212555a-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'profile-reset-btn', '2025-12-28 20:12:14');
INSERT INTO `role_menus` VALUES ('72165bf8-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'profile-save-btn', '2025-12-28 20:12:14');
INSERT INTO `role_menus` VALUES ('95e55bb3-f20f-11f0-a29a-00d0f8000001', '70a3680d-fa7c-40bf-9561-15d3f9b1b5fe', 'dashboard-main', '2026-01-15 20:42:00');
INSERT INTO `role_menus` VALUES ('95e572bf-f20f-11f0-a29a-00d0f8000001', '70a3680d-fa7c-40bf-9561-15d3f9b1b5fe', 'profile-main', '2026-01-15 20:42:00');
INSERT INTO `role_menus` VALUES ('95e5862a-f20f-11f0-a29a-00d0f8000001', '70a3680d-fa7c-40bf-9561-15d3f9b1b5fe', 'profile-save-btn', '2026-01-15 20:42:00');
INSERT INTO `role_menus` VALUES ('95e5954b-f20f-11f0-a29a-00d0f8000001', '70a3680d-fa7c-40bf-9561-15d3f9b1b5fe', 'profile-reset-btn', '2026-01-15 20:42:00');
INSERT INTO `role_menus` VALUES ('95e5a5b2-f20f-11f0-a29a-00d0f8000001', '70a3680d-fa7c-40bf-9561-15d3f9b1b5fe', 'profile-change-password-btn', '2026-01-15 20:42:00');
INSERT INTO `role_menus` VALUES ('a747e138-e4be-11f0-b8db-54e1ad33a445', '17d6801a-ef95-4290-b097-22a7e34805e0', 'dashboard-main', '2025-12-29 21:59:54');
INSERT INTO `role_menus` VALUES ('a747f591-e4be-11f0-b8db-54e1ad33a445', '17d6801a-ef95-4290-b097-22a7e34805e0', 'profile-main', '2025-12-29 21:59:54');
INSERT INTO `role_menus` VALUES ('a7480767-e4be-11f0-b8db-54e1ad33a445', '17d6801a-ef95-4290-b097-22a7e34805e0', 'profile-save-btn', '2025-12-29 21:59:54');
INSERT INTO `role_menus` VALUES ('a74817df-e4be-11f0-b8db-54e1ad33a445', '17d6801a-ef95-4290-b097-22a7e34805e0', 'profile-reset-btn', '2025-12-29 21:59:54');
INSERT INTO `role_menus` VALUES ('a7482bdb-e4be-11f0-b8db-54e1ad33a445', '17d6801a-ef95-4290-b097-22a7e34805e0', 'profile-change-password-btn', '2025-12-29 21:59:54');
INSERT INTO `role_menus` VALUES ('a7483d5a-e4be-11f0-b8db-54e1ad33a445', '17d6801a-ef95-4290-b097-22a7e34805e0', 'admin-dashboard', '2025-12-29 21:59:54');
INSERT INTO `role_menus` VALUES ('a7484e28-e4be-11f0-b8db-54e1ad33a445', '17d6801a-ef95-4290-b097-22a7e34805e0', 'admin-dashboard-user-mgmt-btn', '2025-12-29 21:59:54');
INSERT INTO `role_menus` VALUES ('a748614d-e4be-11f0-b8db-54e1ad33a445', '17d6801a-ef95-4290-b097-22a7e34805e0', 'admin-dashboard-create-user-btn', '2025-12-29 21:59:54');
INSERT INTO `role_menus` VALUES ('a7487361-e4be-11f0-b8db-54e1ad33a445', '17d6801a-ef95-4290-b097-22a7e34805e0', 'admin-dashboard-app-mgmt-btn', '2025-12-29 21:59:54');
INSERT INTO `role_menus` VALUES ('a74881ad-e4be-11f0-b8db-54e1ad33a445', '17d6801a-ef95-4290-b097-22a7e34805e0', 'admin-dashboard-create-app-btn', '2025-12-29 21:59:54');
INSERT INTO `role_menus` VALUES ('a7488e82-e4be-11f0-b8db-54e1ad33a445', '17d6801a-ef95-4290-b097-22a7e34805e0', 'admin-dashboard-view-logs-btn', '2025-12-29 21:59:54');
INSERT INTO `role_menus` VALUES ('a748a754-e4be-11f0-b8db-54e1ad33a445', '17d6801a-ef95-4290-b097-22a7e34805e0', 'admin-dashboard-export-logs-btn', '2025-12-29 21:59:54');
INSERT INTO `role_menus` VALUES ('a748be1f-e4be-11f0-b8db-54e1ad33a445', '17d6801a-ef95-4290-b097-22a7e34805e0', 'admin-dashboard-settings-btn', '2025-12-29 21:59:54');

-- ----------------------------
-- Table structure for role_permissions
-- ----------------------------
DROP TABLE IF EXISTS `role_permissions`;
CREATE TABLE `role_permissions`  (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'uuid()',
  `role_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `permission_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `created_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_role_permission`(`role_id`, `permission_id`) USING BTREE,
  INDEX `idx_role_id`(`role_id`) USING BTREE,
  INDEX `idx_permission_id`(`permission_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色权限关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of role_permissions
-- ----------------------------
INSERT INTO `role_permissions` VALUES ('6d83f702-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', 'b2cb3d37-c637-448d-8dac-023b6fe90cf5', '2025-12-28 20:12:06');
INSERT INTO `role_permissions` VALUES ('6d880995-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', '1112cb4b-6aa1-4a33-a101-19f03a9cf97d', '2025-12-28 20:12:06');
INSERT INTO `role_permissions` VALUES ('6d8c6496-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', '424ddb3b-3f5c-43ac-a395-ba1bf7b731b1', '2025-12-28 20:12:06');
INSERT INTO `role_permissions` VALUES ('6d90955c-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', 'eb50fc6e-072d-4a20-85bc-ecc0ffb5ac22', '2025-12-28 20:12:06');
INSERT INTO `role_permissions` VALUES ('6d94d6fb-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', 'd865df3b-6191-4afc-b7b6-21769f2eb707', '2025-12-28 20:12:06');
INSERT INTO `role_permissions` VALUES ('6d98fbec-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', '39bfae6f-cd22-4181-93c3-484f1cd92bde', '2025-12-28 20:12:06');
INSERT INTO `role_permissions` VALUES ('6d9d44f8-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', '7bf1c1bb-1e56-45ce-8f4c-8c3a78336ca5', '2025-12-28 20:12:06');
INSERT INTO `role_permissions` VALUES ('6da163b3-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', '7f5894b1-f887-4395-8a58-d86aeaea76f4', '2025-12-28 20:12:06');
INSERT INTO `role_permissions` VALUES ('6da5b69c-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', '72caa485-c205-491f-9df1-0f1dea041b09', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6da9d4c4-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', 'c8e52fa1-352f-4f77-acac-72eaf6c43844', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6dae2dca-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', 'b29d2fdf-c77d-4aa3-bccc-43c453bcfa38', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6db2512e-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', 'bbec381d-8e5c-43e8-bf01-69f4f4febd72', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6db69f17-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', 'b73490e8-cec3-4b3a-9293-f7a84a81ee3c', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6dbab6bc-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', 'e33e8f5f-c3ab-4044-93d3-667a82b0bfcf', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6dbf0594-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', '6b645f42-d968-462c-855b-4c670ff75473', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6dc34f13-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', 'c1cf31b4-d4a2-41c3-b138-5ea4286f8477', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6dc79638-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', '62e50fed-8f7d-4528-b9d1-952c602c3f7e', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6dcb9f7b-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', 'b27ef5d4-9c7e-4430-bafe-572a30204361', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6dcfef06-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', 'aba948f2-6be3-408a-9267-d81ff5f7ffbd', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6dd4179a-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', '3f37eac8-95e0-4309-9fea-107f012c1d50', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6dd86015-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', 'ca3d82f2-e141-4567-aea1-31f1119f8fc8', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6ddc7fa3-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', '7ed8db1b-65e6-4bf4-aa1d-9230782995dc', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6de0d1e2-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', '723b8e42-b440-466e-88f3-e22a68e2c50d', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6de4faa6-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', '3fc9e4ff-0799-44ab-a931-015492bec262', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6de94ac8-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', 'da8e2c18-b9ff-47fb-b458-65e4011e4c9b', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6ded64df-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', '634ff303-c07d-4894-b578-dc26e95b4dd1', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6df1b53b-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', '6b73e1ca-a449-471b-8209-1a6bb7367fa6', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6df5d7d5-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', 'c595ac1e-a81a-4fef-b841-a1284eb73efb', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6dfa2da1-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', '3a3eb9b3-5f9d-4db3-a0f4-c88df89432bb', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6dfe530c-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', '1dfd0c16-4e37-45b1-8d9c-199a37bbc3dd', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6e02ac07-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', '2a0e73eb-2ae7-4931-adcf-f19ebd803086', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6e06bc12-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', '6b8e5541-9c6b-4221-bb8b-cee868038bc9', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6e0afc6a-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', '9cf0a039-964c-4ae2-9d8a-13ffeee8f31a', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6e0f313e-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', 'b1243446-dcf6-4442-9cd4-c9d05cdb6e31', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6e136d86-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', 'd80327b7-4b9d-4d8e-a6b4-babe12c652fc', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6e17a7aa-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', '6f2263c0-e21b-4b89-967a-c0b9b675e215', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6e1be4a0-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', 'a5a4a35a-0669-4e45-9ea2-ecdf1d21e0d6', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6e2018aa-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', 'c4f58f90-c90c-48b2-9d29-1314e0ab67f3', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6e245ce7-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', 'c20d7fb2-37c5-4440-9794-4bc6f0b4ca00', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6e289ebf-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', '4e567594-cddb-46e0-93c8-3e3eca11e857', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6e2cc603-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', 'f43ae9a1-8fa5-436e-9bdb-a0f9f04e0726', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6e30ff8c-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', '98171660-41ac-44be-823c-70d2cd7cf9ea', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6e3554b7-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', '78580ca0-a5fd-441f-8a3f-fe85550dc3f9', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6e398a0e-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', 'a3a5e0ad-7835-42aa-97ea-dba6dfe8a372', '2025-12-28 20:12:07');
INSERT INTO `role_permissions` VALUES ('6e3dc505-e3e6-11f0-a398-54e1ad33a445', '07ea6c51-b076-4f59-ab0d-273f03b664ee', 'a487d73b-2f48-44be-8a2e-ec4b9c0cd757', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6e420284-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'b2cb3d37-c637-448d-8dac-023b6fe90cf5', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6e462f40-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', '1112cb4b-6aa1-4a33-a101-19f03a9cf97d', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6e4a711d-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', '424ddb3b-3f5c-43ac-a395-ba1bf7b731b1', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6e4e9ec3-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'eb50fc6e-072d-4a20-85bc-ecc0ffb5ac22', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6e52d6fa-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'd865df3b-6191-4afc-b7b6-21769f2eb707', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6e5707f8-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', '39bfae6f-cd22-4181-93c3-484f1cd92bde', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6e5b335e-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', '7bf1c1bb-1e56-45ce-8f4c-8c3a78336ca5', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6e5f784d-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', '7f5894b1-f887-4395-8a58-d86aeaea76f4', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6e63c0d1-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', '72caa485-c205-491f-9df1-0f1dea041b09', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6e68036f-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'c8e52fa1-352f-4f77-acac-72eaf6c43844', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6e6c4ab3-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'b29d2fdf-c77d-4aa3-bccc-43c453bcfa38', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6e7083e4-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'bbec381d-8e5c-43e8-bf01-69f4f4febd72', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6e74a4a8-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'b73490e8-cec3-4b3a-9293-f7a84a81ee3c', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6e78e6ac-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'e33e8f5f-c3ab-4044-93d3-667a82b0bfcf', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6e7d0634-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', '6b645f42-d968-462c-855b-4c670ff75473', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6e813dbc-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'c1cf31b4-d4a2-41c3-b138-5ea4286f8477', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6e856cac-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', '62e50fed-8f7d-4528-b9d1-952c602c3f7e', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6e89b503-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'b27ef5d4-9c7e-4430-bafe-572a30204361', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6e8de396-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'aba948f2-6be3-408a-9267-d81ff5f7ffbd', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6e922089-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', '3f37eac8-95e0-4309-9fea-107f012c1d50', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6e965a6d-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'ca3d82f2-e141-4567-aea1-31f1119f8fc8', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6e9aa073-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', '7ed8db1b-65e6-4bf4-aa1d-9230782995dc', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6e9ece8c-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', '723b8e42-b440-466e-88f3-e22a68e2c50d', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6ea30a0a-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', '3fc9e4ff-0799-44ab-a931-015492bec262', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6ea73938-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'da8e2c18-b9ff-47fb-b458-65e4011e4c9b', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6eab8cb3-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', '634ff303-c07d-4894-b578-dc26e95b4dd1', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6eafbd49-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', '6b73e1ca-a449-471b-8209-1a6bb7367fa6', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6eb3f3ff-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'c595ac1e-a81a-4fef-b841-a1284eb73efb', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6eb81996-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', '3a3eb9b3-5f9d-4db3-a0f4-c88df89432bb', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6ebc70c8-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', '1dfd0c16-4e37-45b1-8d9c-199a37bbc3dd', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6ec094d8-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', '2a0e73eb-2ae7-4931-adcf-f19ebd803086', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6ec4d46b-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', '6b8e5541-9c6b-4221-bb8b-cee868038bc9', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6ec8ffbe-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', '9cf0a039-964c-4ae2-9d8a-13ffeee8f31a', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6ecd44b9-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'b1243446-dcf6-4442-9cd4-c9d05cdb6e31', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6ed179c2-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'd80327b7-4b9d-4d8e-a6b4-babe12c652fc', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6ed5ba9d-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', '6f2263c0-e21b-4b89-967a-c0b9b675e215', '2025-12-28 20:12:08');
INSERT INTO `role_permissions` VALUES ('6ed9e1bf-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'a5a4a35a-0669-4e45-9ea2-ecdf1d21e0d6', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6ede2a97-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'c4f58f90-c90c-48b2-9d29-1314e0ab67f3', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6ee2618c-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'c20d7fb2-37c5-4440-9794-4bc6f0b4ca00', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6ee69d0e-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', '4e567594-cddb-46e0-93c8-3e3eca11e857', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6eead348-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'f43ae9a1-8fa5-436e-9bdb-a0f9f04e0726', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6eef1dc2-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', '98171660-41ac-44be-823c-70d2cd7cf9ea', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6ef33cdd-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', '78580ca0-a5fd-441f-8a3f-fe85550dc3f9', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6ef784fc-e3e6-11f0-a398-54e1ad33a445', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'a3a5e0ad-7835-42aa-97ea-dba6dfe8a372', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6efbb138-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'b2cb3d37-c637-448d-8dac-023b6fe90cf5', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6efffa20-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', '1112cb4b-6aa1-4a33-a101-19f03a9cf97d', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f042435-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', '424ddb3b-3f5c-43ac-a395-ba1bf7b731b1', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f086e91-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'eb50fc6e-072d-4a20-85bc-ecc0ffb5ac22', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f0c9954-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'd865df3b-6191-4afc-b7b6-21769f2eb707', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f10e5c9-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'bbec381d-8e5c-43e8-bf01-69f4f4febd72', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f150db0-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'b73490e8-cec3-4b3a-9293-f7a84a81ee3c', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f194c71-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'e33e8f5f-c3ab-4044-93d3-667a82b0bfcf', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f1d8853-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', '6b645f42-d968-462c-855b-4c670ff75473', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f21cfb3-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'c1cf31b4-d4a2-41c3-b138-5ea4286f8477', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f25ecc5-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', '62e50fed-8f7d-4528-b9d1-952c602c3f7e', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f2a3269-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'b27ef5d4-9c7e-4430-bafe-572a30204361', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f2e63d1-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'aba948f2-6be3-408a-9267-d81ff5f7ffbd', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f32a840-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', '3f37eac8-95e0-4309-9fea-107f012c1d50', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f36de66-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'ca3d82f2-e141-4567-aea1-31f1119f8fc8', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f3b258f-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', '7ed8db1b-65e6-4bf4-aa1d-9230782995dc', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f3f40ef-e3e6-11f0-a398-54e1ad33a445', '3f10ee04-2876-40be-bfe5-3248ef272eaa', '723b8e42-b440-466e-88f3-e22a68e2c50d', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f438f8d-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'b2cb3d37-c637-448d-8dac-023b6fe90cf5', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f47bfff-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', '1112cb4b-6aa1-4a33-a101-19f03a9cf97d', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f4bfcdd-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', '424ddb3b-3f5c-43ac-a395-ba1bf7b731b1', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f504c68-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'eb50fc6e-072d-4a20-85bc-ecc0ffb5ac22', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f547b7a-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', '7bf1c1bb-1e56-45ce-8f4c-8c3a78336ca5', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f589c63-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'b1243446-dcf6-4442-9cd4-c9d05cdb6e31', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f5cdfca-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'd80327b7-4b9d-4d8e-a6b4-babe12c652fc', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f610b5f-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', '6f2263c0-e21b-4b89-967a-c0b9b675e215', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f6ce8b8-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'a5a4a35a-0669-4e45-9ea2-ecdf1d21e0d6', '2025-12-28 20:12:09');
INSERT INTO `role_permissions` VALUES ('6f711b9c-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'c4f58f90-c90c-48b2-9d29-1314e0ab67f3', '2025-12-28 20:12:10');
INSERT INTO `role_permissions` VALUES ('6f756ab0-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', 'c20d7fb2-37c5-4440-9794-4bc6f0b4ca00', '2025-12-28 20:12:10');
INSERT INTO `role_permissions` VALUES ('6f798c3c-e3e6-11f0-a398-54e1ad33a445', '8e8782c9-3294-4662-81dc-71c2b4323170', '4e567594-cddb-46e0-93c8-3e3eca11e857', '2025-12-28 20:12:10');
INSERT INTO `role_permissions` VALUES ('6f7de39a-e3e6-11f0-a398-54e1ad33a445', '17d6801a-ef95-4290-b097-22a7e34805e0', 'b2cb3d37-c637-448d-8dac-023b6fe90cf5', '2025-12-28 20:12:10');
INSERT INTO `role_permissions` VALUES ('6f81e6c5-e3e6-11f0-a398-54e1ad33a445', '17d6801a-ef95-4290-b097-22a7e34805e0', '1112cb4b-6aa1-4a33-a101-19f03a9cf97d', '2025-12-28 20:12:10');
INSERT INTO `role_permissions` VALUES ('6f864e51-e3e6-11f0-a398-54e1ad33a445', '17d6801a-ef95-4290-b097-22a7e34805e0', '424ddb3b-3f5c-43ac-a395-ba1bf7b731b1', '2025-12-28 20:12:10');

-- ----------------------------
-- Table structure for roles
-- ----------------------------
DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles`  (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'uuid()',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '角色名称',
  `display_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '角色显示名称',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '角色描述',
  `is_active` tinyint(1) NULL DEFAULT 1 COMMENT '是否启用',
  `is_system` tinyint(1) NULL DEFAULT 0 COMMENT '是否系统角色',
  `created_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `updated_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `name`(`name`) USING BTREE,
  INDEX `idx_name`(`name`) USING BTREE,
  INDEX `idx_is_active`(`is_active`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '角色表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of roles
-- ----------------------------
INSERT INTO `roles` VALUES ('07ea6c51-b076-4f59-ab0d-273f03b664ee', 'super_admin', '超级管理员', '拥有系统所有权限的超级管理员', 1, 1, '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `roles` VALUES ('17d6801a-ef95-4290-b097-22a7e34805e0', 'user', '普通用户', '系统普通用户', 1, 1, '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `roles` VALUES ('3f10ee04-2876-40be-bfe5-3248ef272eaa', 'user_manager', '用户管理员', '负责用户和角色管理的管理员', 1, 1, '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `roles` VALUES ('70a3680d-fa7c-40bf-9561-15d3f9b1b5fe', 'test', 'test1', 'test1', 1, 0, '2026-01-15 20:37:51', '2026-01-15 20:38:04');
INSERT INTO `roles` VALUES ('8e8782c9-3294-4662-81dc-71c2b4323170', 'app_manager', '应用管理员', '负责应用管理的管理员', 1, 1, '2025-12-28 20:12:05', '2025-12-28 20:12:05');
INSERT INTO `roles` VALUES ('ee278cce-fde6-4044-a6b5-7e733025bb7f', 'admin', '管理员', '系统管理员，拥有大部分管理权限', 1, 1, '2025-12-28 20:12:05', '2025-12-28 20:12:05');

-- ----------------------------
-- Table structure for sync_logs
-- ----------------------------
DROP TABLE IF EXISTS `sync_logs`;
CREATE TABLE `sync_logs`  (
  `app_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '应用ID',
  `sync_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '同步类型',
  `sync_status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '同步状态',
  `records_count` int(0) NULL DEFAULT NULL COMMENT '记录数量',
  `success_count` int(0) NULL DEFAULT NULL COMMENT '成功数量',
  `failure_count` int(0) NULL DEFAULT NULL COMMENT '失败数量',
  `error_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL COMMENT '错误信息',
  `start_time` datetime(0) NULL DEFAULT NULL COMMENT '开始时间',
  `end_time` datetime(0) NULL DEFAULT NULL COMMENT '结束时间',
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '主键ID',
  `created_at` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` tinyint(1) NULL DEFAULT NULL COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `app_id`(`app_id`) USING BTREE,
  CONSTRAINT `sync_logs_ibfk_1` FOREIGN KEY (`app_id`) REFERENCES `apps` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sync_logs
-- ----------------------------

-- ----------------------------
-- Table structure for t_basis_of_preparation
-- ----------------------------
DROP TABLE IF EXISTS `t_basis_of_preparation`;
CREATE TABLE `t_basis_of_preparation`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '标准唯一标识符',
  `chinese_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '中文标准名称',
  `english_name` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '英文标准名称',
  `standard_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '标准编号',
  `issuing_authority` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '发布机构',
  `release_date` date NULL DEFAULT NULL COMMENT '发布日期',
  `implementation_date` date NULL DEFAULT NULL COMMENT '实施日期',
  `drafting_unit` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '起草单位',
  `approving_department` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '批准部门',
  `document_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '标准类型: national-国家标准, industry-行业标准, local-地方标准, enterprise-企业标准',
  `professional_field` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '专业领域:Laws-法律,Technical-技术规范,Reference-参考规范,Internal-内部规范',
  `engineering_phase` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '工程阶段',
  `participating_units` varchar(800) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '参编单位',
  `reference_basis_list` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '参考依据列表',
  `file_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '文件路径',
  `status` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '状态：current-现行，作废-void',
  `created_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '记录创建时间',
  `updated_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '记录更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_standard_no`(`standard_no`) USING BTREE COMMENT '标准编号索引',
  INDEX `idx_chinese_name`(`chinese_name`(100)) USING BTREE COMMENT '中文名称索引',
  INDEX `idx_release_date`(`release_date`) USING BTREE COMMENT '发布日期索引',
  INDEX `idx_document_type`(`document_type`) USING BTREE COMMENT '标准类型索引',
  INDEX `idx_professional_field`(`professional_field`) USING BTREE COMMENT '专业领域索引'
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '编制依据基本信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_basis_of_preparation
-- ----------------------------
INSERT INTO `t_basis_of_preparation` VALUES (1, '中华人民共和国安全生产法', NULL, NULL, NULL, '2021-06-10', NULL, NULL, NULL, 'national', 'Laws', NULL, NULL, NULL, 'https://safety.jining.gov.cn/module/download/downfile.jsp?classid=0&showname=%E4%B8%AD%E5%8D%8E%E4%BA%BA%E6%B0%91%E5%85%B1%E5%92%8C%E5%9B%BD%E5%AE%89%E5%85%A8%E7%94%9F%E4%BA%A7%E6%B3%95%EF%BC%882021%E5%B9%B46%E6%9C%8810%E6%97%A5%E4%BF%AE%E8%AE%A2%E7%89%88%EF%BC%89.pdf&filename=3b0ee62a494049869e9361ec8ee4fb83.pdf', 'current', '2025-11-14 17:27:57', '2025-11-14 17:27:57');
INSERT INTO `t_basis_of_preparation` VALUES (2, '公路水运工程质量监督管理规定', NULL, NULL, '交通运输部', '2017-09-14', NULL, NULL, NULL, 'industry', 'Laws', NULL, NULL, NULL, 'https://xxgk.mot.gov.cn/2020/jigou/fgs/202006/t20200623_3307899.html', 'current', '2025-11-14 17:27:57', '2025-11-14 17:27:57');
INSERT INTO `t_basis_of_preparation` VALUES (3, '公路水运工程拟淘汰危及生产安全施工工艺、设备和材料目录', NULL, NULL, '交通运输部', NULL, NULL, NULL, NULL, 'industry', 'Technical', NULL, NULL, NULL, 'http://ztjfjt.jtgs.taizhou.gov.cn/cms_files/filemanager/1718223565/attach/20235/7485f997a006433f9d2530c46a4b9861.pdf', 'current', '2025-11-14 17:27:57', '2025-11-14 17:27:57');
INSERT INTO `t_basis_of_preparation` VALUES (4, '公路桥涵施工技术规范', NULL, 'JTG/T3650-2020', '交通运输部', NULL, NULL, NULL, NULL, 'industry', 'Technical', NULL, NULL, NULL, 'https://xxgk.mot.gov.cn/2020/jigou/glj/202006/P020200630665628060420.pdf', 'current', '2025-11-14 17:27:57', '2025-11-14 17:27:57');
INSERT INTO `t_basis_of_preparation` VALUES (5, '公路工程质量检验评定标准', NULL, 'JTGF80-1-2017', NULL, NULL, NULL, NULL, NULL, 'industry', 'Technical', NULL, NULL, NULL, 'https://jtst.mot.gov.cn/hb/search/stdHBDetailed?id=dd2ffc7d8c33835bad290e9d741f0634', 'current', '2025-11-14 17:27:57', '2025-11-14 17:27:57');
INSERT INTO `t_basis_of_preparation` VALUES (6, '公路工程施工安全技术规范', NULL, 'JTGF90-2015', NULL, NULL, NULL, NULL, NULL, 'industry', 'Technical', NULL, NULL, NULL, 'https://jtst.mot.gov.cn/hb/search/stdHBDetailed?id=4c4ab59797b5b4013c4089972fbb2290', 'current', '2025-11-14 17:27:57', '2025-11-14 17:27:57');
INSERT INTO `t_basis_of_preparation` VALUES (7, '混凝土结构工程施工质量验收规范', NULL, 'GB50204-2015', NULL, NULL, NULL, NULL, NULL, 'industry', 'Technical', NULL, NULL, NULL, 'http://www.cdapm.com.cn/upload/%E6%B7%B7%E5%87%9D%E5%9C%9F%E7%BB%93%E6%9E%84%E5%B7%A5%E7%A8%8B%E6%96%BD%E5%B7%A5%E8%B4%A8%E9%87%8F%E9%AA%8C%E6%94%B6%E8%A7%84%E8%8C%83GB%2050204-2015.pdf', 'current', '2025-11-14 17:27:57', '2025-11-14 17:27:57');
INSERT INTO `t_basis_of_preparation` VALUES (8, '施工现场临时用电安全技术规范', NULL, 'JGJ46-2016', NULL, NULL, NULL, NULL, NULL, 'industry', 'Technical', NULL, NULL, NULL, 'https://zjw.sh.gov.cn/cmsres/73/7320cf3c54aa4a34827bfecbe6ea293d/5a01c703dcca637c3b9247f4c001542f.pdf', 'current', '2025-11-14 17:27:57', '2025-11-14 17:27:57');
INSERT INTO `t_basis_of_preparation` VALUES (9, '建筑施工塔式起重机安装、使用、拆卸安全技术规范', NULL, 'JGJ196-2010', NULL, NULL, NULL, NULL, NULL, 'industry', 'Technical', NULL, NULL, NULL, 'https://zjw.sh.gov.cn/cmsres/99/99e29d723c8e49a488df5f787a529711/1314c992b03eb944fe2a020c26d457ae.pdf', 'current', '2025-11-14 17:27:57', '2025-11-14 17:27:57');
INSERT INTO `t_basis_of_preparation` VALUES (10, '建筑施工高空作业安全技术规范', NULL, 'JGJ80-2016', NULL, NULL, NULL, NULL, NULL, 'industry', 'Technical', NULL, NULL, NULL, 'https://zjw.sh.gov.cn/cmsres/dd/dd2874d657124e648b54c66a113fb0b1/2b641c95070e63127349d11cc3109bc6.pdf', 'current', '2025-11-14 17:27:57', '2025-11-14 17:27:57');
INSERT INTO `t_basis_of_preparation` VALUES (11, '混凝土结构设计规范2015 年版', NULL, 'GB50010-2010', NULL, NULL, NULL, NULL, NULL, 'industry', 'Technical', NULL, NULL, NULL, 'https://www.gbwindows.net/ow-content/uploads/download/gfbzdown/1.0.5%E6%9D%A1/%E5%85%B3%E8%81%94%E6%A0%87%E5%87%86/GB50010-2010(2015%E7%89%88)%20%20%E6%B7%B7%E5%87%9D%E5%9C%9F%E7%BB%93%E6%9E%84%E8%AE%BE%E8%AE%A1%E8%A7%84%E8%8C%83.pdf', 'current', '2025-11-14 17:27:57', '2025-11-14 17:27:57');
INSERT INTO `t_basis_of_preparation` VALUES (12, '混凝土结构工程施工质量验收规范', NULL, 'GB50204-2015', NULL, NULL, NULL, NULL, NULL, 'industry', 'Technical', NULL, NULL, NULL, 'http://www.cdapm.com.cn/upload/%E6%B7%B7%E5%87%9D%E5%9C%9F%E7%BB%93%E6%9E%84%E5%B7%A5%E7%A8%8B%E6%96%BD%E5%B7%A5%E8%B4%A8%E9%87%8F%E9%AA%8C%E6%94%B6%E8%A7%84%E8%8C%83GB%2050204-2015.pdf', 'current', '2025-11-14 17:27:57', '2025-11-14 17:27:57');
INSERT INTO `t_basis_of_preparation` VALUES (13, '建筑施工模板安全技术规程', NULL, 'JGJ162-2008', NULL, NULL, NULL, NULL, NULL, 'industry', 'Technical', NULL, NULL, NULL, 'http://www.cdapm.com.cn/upload/%E5%BB%BA%E7%AD%91%E6%96%BD%E5%B7%A5%E6%A8%A1%E6%9D%BF%E5%AE%89%E5%85%A8%E6%8A%80%E6%9C%AF%E8%A7%84%E8%8C%83JGJ162-2008.pdf', 'current', '2025-11-14 17:27:57', '2025-11-14 17:27:57');
INSERT INTO `t_basis_of_preparation` VALUES (14, 'G4216 线屏山新市至金阳段高速公路 XJ4 标段两阶段施工设计图纸', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'enterprise', 'Reference', NULL, NULL, NULL, NULL, 'current', '2025-11-14 17:27:57', '2025-11-14 17:27:57');
INSERT INTO `t_basis_of_preparation` VALUES (15, '建设单位明确的工程施工工期、质量和环境保护要求以及关键工程控制要点', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'enterprise', 'Laws', NULL, NULL, NULL, NULL, 'current', '2025-11-14 17:27:57', '2025-11-14 17:27:57');
INSERT INTO `t_basis_of_preparation` VALUES (16, '本项目总体施工组织设计', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'enterprise', 'Reference', NULL, NULL, NULL, NULL, 'current', '2025-11-14 17:27:57', '2025-11-14 17:27:57');
INSERT INTO `t_basis_of_preparation` VALUES (17, '四川路桥集团《工程技术管理办法》及《工程质量管理办法》', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'enterprise', 'Internal', NULL, NULL, NULL, NULL, 'current', '2025-11-14 17:27:57', '2025-11-14 17:27:57');
INSERT INTO `t_basis_of_preparation` VALUES (18, '《起重机械安全规程》', NULL, 'B6067-2010', NULL, NULL, NULL, NULL, NULL, 'industry', 'Technical', NULL, NULL, NULL, 'https://openstd.samr.gov.cn/bzgk/gb/newGbInfo?hcno=9DED7058601D511BFD5EEE88677548D8', 'current', '2025-11-14 17:27:57', '2025-11-14 17:27:57');
INSERT INTO `t_basis_of_preparation` VALUES (19, '《架桥机通用技术条件》', NULL, 'GB/T26470-2011', NULL, NULL, NULL, NULL, NULL, 'industry', 'Technical', NULL, NULL, NULL, 'https://openstd.samr.gov.cn/bzgk/gb/newGbInfo?hcno=F8FC50E035D93142F37F28F0F5E8B678', 'current', '2025-11-14 17:27:57', '2025-11-14 17:27:57');
INSERT INTO `t_basis_of_preparation` VALUES (20, '《架桥机安全规程》', NULL, 'GB 26496-2011', NULL, NULL, NULL, NULL, NULL, 'industry', 'Technical', NULL, NULL, NULL, 'https://openstd.samr.gov.cn/bzgk/gb/newGbInfo?hcno=DF194527717A2C929434449D62FF8196', 'current', '2025-11-14 17:27:57', '2025-11-14 17:27:57');
INSERT INTO `t_basis_of_preparation` VALUES (21, '《公路水运工程安全生产监督管理办法》', NULL, '交通运输部令2017 年第25号', '交通运输部', NULL, NULL, NULL, NULL, 'industry', 'Laws', NULL, NULL, NULL, 'https://xxgk.mot.gov.cn/2020/gz/202112/t20211227_3633480.html', 'current', '2025-11-14 17:27:57', '2025-11-14 17:27:57');
INSERT INTO `t_basis_of_preparation` VALUES (22, '《危险性较大的分部分项工程安全管理规定》', NULL, '住建部令第37 号', '住房和城乡建设部', NULL, NULL, NULL, NULL, 'industry', 'Laws', NULL, NULL, NULL, 'https://www.gov.cn/gongbao/content/2018/content_5294422.htm', 'current', '2025-11-14 17:27:57', '2025-11-14 17:27:57');

-- ----------------------------
-- Table structure for t_document_main
-- ----------------------------
DROP TABLE IF EXISTS `t_document_main`;
CREATE TABLE `t_document_main`  (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `standard_no` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `issuing_authority` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `release_date` date NULL DEFAULT NULL,
  `document_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `professional_field` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `validity` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '现行',
  `created_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `created_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `updated_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  `conversion_status` tinyint(0) NULL DEFAULT 0,
  `conversion_progress` int(0) NULL DEFAULT 0,
  `converted_file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `conversion_error` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `whether_to_enter` tinyint(0) NULL DEFAULT 0,
  `source_type` enum('basis','work','job') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `source_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `file_url` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `file_extension` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `primary_category_id` int(0) NULL DEFAULT NULL,
  `secondary_category_id` int(0) NULL DEFAULT NULL,
  `year` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_document_main
-- ----------------------------

-- ----------------------------
-- Table structure for test_tab
-- ----------------------------
DROP TABLE IF EXISTS `test_tab`;
CREATE TABLE `test_tab`  (
  `id` int(0) NOT NULL AUTO_INCREMENT COMMENT '用户唯一标识符',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户姓名',
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户邮箱，唯一',
  `age` int(0) NULL DEFAULT NULL COMMENT '用户年龄',
  `status` enum('active','inactive') CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT 'active' COMMENT '用户状态：active-活跃, inactive-非活跃',
  `created_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '记录创建时间',
  `updated_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '记录最后更新时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `idx_email`(`email`) USING BTREE COMMENT '邮箱索引，用于快速查找',
  INDEX `idx_status`(`status`) USING BTREE COMMENT '状态索引，用于按状态筛选'
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin COMMENT = '用户信息表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of test_tab
-- ----------------------------
INSERT INTO `test_tab` VALUES (1, '李四', 'test_email——upt', 22, 'active', '2025-11-14 11:40:00', '2025-11-14 13:24:11');
INSERT INTO `test_tab` VALUES (2, 'test_name', 'test_email', 18, 'active', '2025-11-14 11:40:39', '2025-11-14 11:40:39');
INSERT INTO `test_tab` VALUES (3, '执行任务', '10001', 18, 'active', '2025-11-14 11:42:24', '2025-11-14 11:42:24');
INSERT INTO `test_tab` VALUES (4, '张三', '10002', 18, 'active', '2025-11-14 12:56:07', '2025-11-14 12:56:07');

-- ----------------------------
-- Table structure for token_blacklist
-- ----------------------------
DROP TABLE IF EXISTS `token_blacklist`;
CREATE TABLE `token_blacklist`  (
  `token` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '令牌',
  `token_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '令牌类型',
  `expires_at` datetime(0) NOT NULL COMMENT '过期时间',
  `added_at` datetime(0) NULL DEFAULT NULL COMMENT '加入时间',
  `reason` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '加入原因',
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '主键ID',
  `created_at` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` tinyint(1) NULL DEFAULT NULL COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `token`(`token`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of token_blacklist
-- ----------------------------
INSERT INTO `token_blacklist` VALUES ('[REDACTED], 'access_token', '2026-01-16 22:23:08', '2026-01-16 13:56:54', '用户登出', '14478c58-353f-482e-aa4e-0a155d5e5733', '2026-01-16 21:56:54', '2026-01-16 21:56:54', 0);
INSERT INTO `token_blacklist` VALUES ('[REDACTED], 'access_token', '2026-01-15 16:50:24', '2026-01-15 08:20:25', '用户登出', '2c4d0115-4359-4203-bd72-d89a228b6af7', '2026-01-15 16:20:24', '2026-01-15 16:20:24', 0);
INSERT INTO `token_blacklist` VALUES ('[REDACTED], 'access_token', '2026-01-15 19:03:38', '2026-01-15 10:43:09', '用户登出', '2f753c40-892d-4bee-a26e-21117db34447', '2026-01-15 18:43:08', '2026-01-15 18:43:08', 0);
INSERT INTO `token_blacklist` VALUES ('[REDACTED], 'access_token', '2026-01-15 19:15:35', '2026-01-15 10:55:16', '用户登出', '50caca71-17bd-41ba-a1bf-6e8c5c673a78', '2026-01-15 18:55:16', '2026-01-15 18:55:16', 0);
INSERT INTO `token_blacklist` VALUES ('[REDACTED], 'access_token', '2026-01-16 22:42:38', '2026-01-16 14:15:45', '用户登出', '594d4516-5dbc-404f-8a4c-4672cef3273b', '2026-01-16 22:15:45', '2026-01-16 22:15:45', 0);
INSERT INTO `token_blacklist` VALUES ('[REDACTED], 'access_token', '2026-01-16 21:50:28', '2026-01-16 13:25:19', '用户登出', '62c0eeaa-c505-4c2f-aa43-314d2161b3fc', '2026-01-16 21:25:19', '2026-01-16 21:25:19', 0);
INSERT INTO `token_blacklist` VALUES ('[REDACTED], 'access_token', '2026-01-15 16:07:46', '2026-01-15 07:37:49', '用户登出', '658821c0-b0a8-4037-9ffe-ad9def5b74fc', '2026-01-15 15:37:49', '2026-01-15 15:37:49', 0);
INSERT INTO `token_blacklist` VALUES ('[REDACTED], 'access_token', '2026-01-16 23:02:44', '2026-01-16 14:33:07', '用户登出', '67ede89a-74b4-4dcb-a534-e8a0133c1f90', '2026-01-16 22:33:07', '2026-01-16 22:33:07', 0);
INSERT INTO `token_blacklist` VALUES ('[REDACTED], 'access_token', '2026-01-16 21:55:47', '2026-01-16 13:26:43', '用户登出', '70718cdd-0381-4dfc-8c60-539a3fc1e39c', '2026-01-16 21:26:42', '2026-01-16 21:26:42', 0);
INSERT INTO `token_blacklist` VALUES ('[REDACTED], 'access_token', '2026-01-15 20:51:43', '2026-01-15 12:43:41', '用户登出', '7adabd20-9b64-4d15-8baf-605bb4f01a0f', '2026-01-15 20:43:40', '2026-01-15 20:43:40', 0);
INSERT INTO `token_blacklist` VALUES ('[REDACTED], 'access_token', '2026-01-16 23:03:13', '2026-01-16 14:33:22', '用户登出', '950a577e-f23f-401e-99f3-5c6d83cb7d63', '2026-01-16 22:33:22', '2026-01-16 22:33:22', 0);
INSERT INTO `token_blacklist` VALUES ('[REDACTED], 'access_token', '2026-01-15 19:13:23', '2026-01-15 10:45:31', '用户登出', '95709072-a68a-4a9d-bfc1-25577c0ce2d1', '2026-01-15 18:45:30', '2026-01-15 18:45:30', 0);
INSERT INTO `token_blacklist` VALUES ('[REDACTED], 'access_token', '2026-01-16 22:45:50', '2026-01-16 14:15:55', '用户登出', '9aac633c-78f5-44b9-9bb9-8d0d08f82039', '2026-01-16 22:15:55', '2026-01-16 22:15:55', 0);
INSERT INTO `token_blacklist` VALUES ('[REDACTED], 'access_token', '2026-01-15 19:25:22', '2026-01-15 10:59:28', '用户登出', 'a55b7e59-4eb5-43e2-86de-91db9a86723c', '2026-01-15 18:59:28', '2026-01-15 18:59:28', 0);
INSERT INTO `token_blacklist` VALUES ('[REDACTED], 'access_token', '2026-01-15 16:12:11', '2026-01-15 07:42:11', '用户登出', 'a9980e91-9270-4729-bef7-cdcc113c39c2', '2026-01-15 15:42:11', '2026-01-15 15:42:11', 0);
INSERT INTO `token_blacklist` VALUES ('[REDACTED], 'access_token', '2026-01-15 19:33:02', '2026-01-15 11:26:07', '用户登出', 'aa13483c-b8c9-40b5-af27-ea55af9125d6', '2026-01-15 19:26:07', '2026-01-15 19:26:07', 0);
INSERT INTO `token_blacklist` VALUES ('[REDACTED], 'access_token', '2026-01-16 22:15:49', '2026-01-16 13:46:38', '用户登出', 'aee54b46-c56a-40f7-b316-7c6c0838bc94', '2026-01-16 21:46:38', '2026-01-16 21:46:38', 0);
INSERT INTO `token_blacklist` VALUES ('[REDACTED], 'access_token', '2026-01-15 16:08:17', '2026-01-15 07:38:18', '用户登出', 'b3446d6b-8fda-4839-931b-6cf8aaa5a51d', '2026-01-15 15:38:18', '2026-01-15 15:38:18', 0);
INSERT INTO `token_blacklist` VALUES ('[REDACTED], 'access_token', '2026-01-15 19:29:29', '2026-01-15 11:00:15', '用户登出', 'b44e7206-317e-48de-9231-72fbf2879136', '2026-01-15 19:00:14', '2026-01-15 19:00:14', 0);
INSERT INTO `token_blacklist` VALUES ('[REDACTED], 'access_token', '2026-01-15 16:07:51', '2026-01-15 07:37:54', '用户登出', 'b496cb48-a2a2-49a7-a3ea-ef6e3a3a5e95', '2026-01-15 15:37:53', '2026-01-15 15:37:53', 0);
INSERT INTO `token_blacklist` VALUES ('[REDACTED], 'access_token', '2026-01-16 21:57:25', '2026-01-16 13:28:29', '用户登出', 'b9b32572-e173-4ece-a4cd-43e78287f068', '2026-01-16 21:28:28', '2026-01-16 21:28:28', 0);
INSERT INTO `token_blacklist` VALUES ('[REDACTED], 'access_token', '2026-01-15 19:56:18', '2026-01-15 11:40:41', '用户登出', 'e3531977-5824-4530-99c2-acad1fb376b1', '2026-01-15 19:40:41', '2026-01-15 19:40:41', 0);
INSERT INTO `token_blacklist` VALUES ('[REDACTED], 'access_token', '2026-01-15 19:30:16', '2026-01-15 11:02:57', '用户登出', 'fbd08ef2-c0c8-4b42-9d98-e5ee872dfa88', '2026-01-15 19:02:56', '2026-01-15 19:02:56', 0);

-- ----------------------------
-- Table structure for user_profiles
-- ----------------------------
DROP TABLE IF EXISTS `user_profiles`;
CREATE TABLE `user_profiles`  (
  `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户ID',
  `real_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '真实姓名',
  `gender` tinyint(0) NULL DEFAULT NULL COMMENT '性别 0:未知 1:男 2:女',
  `birth_date` date NULL DEFAULT NULL COMMENT '出生日期',
  `address` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '地址',
  `company` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '公司',
  `department` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '部门',
  `position` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '职位',
  `extra_info` json NULL COMMENT '扩展信息',
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '主键ID',
  `created_at` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` tinyint(1) NULL DEFAULT NULL COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `user_id`(`user_id`) USING BTREE,
  CONSTRAINT `user_profiles_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_profiles
-- ----------------------------
INSERT INTO `user_profiles` VALUES ('afa20a1c-ea0a-4f65-9928-d2faf9eae6ef', '测试', NULL, NULL, NULL, '测试', '测试', NULL, NULL, '0997e737-8a5d-44ef-91f4-b32595273d3a', '2025-12-27 13:49:12', '2026-01-19 16:56:40', NULL);
INSERT INTO `user_profiles` VALUES ('357f8ac2-a271-440a-a003-0db32d15d302', 'app', NULL, NULL, NULL, 'app', 'app', NULL, NULL, '12fe4ace-edfe-4d1f-a1f7-6613630a43dd', '2025-12-29 21:29:16', '2025-12-29 22:17:18', NULL);
INSERT INTO `user_profiles` VALUES ('feb58a17-f436-43bb-9db8-d6a7bb6a836a', '李四', NULL, NULL, NULL, 'test', 'test', NULL, NULL, '1420c2af-ba3e-402f-8663-ea480786c437', '2026-01-15 19:42:13', '2026-01-15 20:47:31', NULL);
INSERT INTO `user_profiles` VALUES ('44d9ebb2-2c45-41a4-8067-9ba294c20037', 'test', NULL, NULL, NULL, '', 'test', NULL, NULL, '2ba03e43-0e35-4f0b-8e31-e5e078c4460d', '2026-01-16 21:22:08', '2026-01-16 21:55:37', NULL);
INSERT INTO `user_profiles` VALUES ('d3e906de-b9a6-4a78-a643-233252252776', '张三', NULL, NULL, NULL, 'test', 'test', NULL, NULL, '67b6be23-d2a1-43d5-80e8-81e98736cdaa', '2025-12-28 21:45:15', '2026-01-16 21:55:19', NULL);
INSERT INTO `user_profiles` VALUES ('3d0efc90-7c0c-42ca-8426-82bad3fdd0c7', 'admin', NULL, NULL, NULL, 'admin', 'admin', NULL, NULL, 'a116ecd5-249d-40d6-af0d-466cedf71a30', '2025-12-29 21:35:23', '2025-12-29 21:36:08', NULL);
INSERT INTO `user_profiles` VALUES ('545dc3f9-413d-422e-8748-692d9f390d5d', '王二', NULL, NULL, NULL, '121', 'test', NULL, NULL, 'f13e2286-849c-4417-841d-77cd47ad48e3', '2026-01-16 21:56:45', '2026-01-16 21:56:45', NULL);

-- ----------------------------
-- Table structure for user_roles
-- ----------------------------
DROP TABLE IF EXISTS `user_roles`;
CREATE TABLE `user_roles`  (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'uuid()',
  `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `role_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `assigned_by` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '分配者ID',
  `assigned_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `expires_at` timestamp(0) NULL DEFAULT NULL COMMENT '过期时间',
  `is_active` tinyint(1) NULL DEFAULT 1 COMMENT '是否启用',
  `created_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
  `updated_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_user_role`(`user_id`, `role_id`) USING BTREE,
  INDEX `idx_user_id`(`user_id`) USING BTREE,
  INDEX `idx_role_id`(`role_id`) USING BTREE,
  INDEX `idx_expires_at`(`expires_at`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户角色关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_roles
-- ----------------------------
INSERT INTO `user_roles` VALUES ('3ab46c67-2abe-47c9-88aa-23df2f9ee7b3', 'd3e906de-b9a6-4a78-a643-233252252776', '17d6801a-ef95-4290-b097-22a7e34805e0', 'ed6a79d3-0083-4d81-8b48-fc522f686f74', '2026-01-16 21:55:19', NULL, 1, '2026-01-16 21:55:19', '2026-01-16 21:55:19');
INSERT INTO `user_roles` VALUES ('722fd82a-e3e6-11f0-a398-54e1ad33a445', 'ed6a79d3-0083-4d81-8b48-fc522f686f74', '07ea6c51-b076-4f59-ab0d-273f03b664ee', NULL, '2025-12-28 20:12:14', NULL, 1, '2025-12-28 20:12:14', '2025-12-28 20:12:14');
INSERT INTO `user_roles` VALUES ('92bd5672-9df0-4f26-adec-9f0bf6763788', '357f8ac2-a271-440a-a003-0db32d15d302', '8e8782c9-3294-4662-81dc-71c2b4323170', 'ed6a79d3-0083-4d81-8b48-fc522f686f74', '2025-12-29 22:17:18', NULL, 1, '2025-12-29 22:17:18', '2025-12-29 22:17:18');
INSERT INTO `user_roles` VALUES ('d62d0ca7-1b43-4adf-9e83-af3515a2f7aa', '3d0efc90-7c0c-42ca-8426-82bad3fdd0c7', 'ee278cce-fde6-4044-a6b5-7e733025bb7f', 'ed6a79d3-0083-4d81-8b48-fc522f686f74', '2025-12-29 21:36:08', NULL, 1, '2025-12-29 21:36:08', '2025-12-29 21:36:08');
INSERT INTO `user_roles` VALUES ('ed3a3ec8-8317-4e7b-9f53-d53c818f9894', '545dc3f9-413d-422e-8748-692d9f390d5d', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'ed6a79d3-0083-4d81-8b48-fc522f686f74', '2026-01-16 21:56:45', NULL, 1, '2026-01-16 21:56:45', '2026-01-16 21:56:45');
INSERT INTO `user_roles` VALUES ('f36b3af1-08f7-42da-a4d2-1a678a010c8c', 'afa20a1c-ea0a-4f65-9928-d2faf9eae6ef', '17d6801a-ef95-4290-b097-22a7e34805e0', 'ed6a79d3-0083-4d81-8b48-fc522f686f74', '2026-01-19 16:56:42', NULL, 1, '2026-01-19 16:56:42', '2026-01-19 16:56:42');
INSERT INTO `user_roles` VALUES ('f548cb41-1b96-4ab1-aacd-2cb2a47206f0', 'afa20a1c-ea0a-4f65-9928-d2faf9eae6ef', '3f10ee04-2876-40be-bfe5-3248ef272eaa', 'ed6a79d3-0083-4d81-8b48-fc522f686f74', '2026-01-19 16:56:40', NULL, 1, '2026-01-19 16:56:40', '2026-01-19 16:56:40');

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户名',
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '邮箱',
  `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '手机号',
  `password_hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '密码哈希',
  `avatar_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '头像URL',
  `is_active` tinyint(1) NULL DEFAULT NULL COMMENT '是否激活',
  `is_superuser` tinyint(1) NULL DEFAULT NULL COMMENT '是否超级管理员',
  `last_login_at` datetime(0) NULL DEFAULT NULL COMMENT '最后登录时间',
  `last_login_ip` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '最后登录IP',
  `failed_login_attempts` int(0) NULL DEFAULT NULL COMMENT '失败登录次数',
  `locked_until` datetime(0) NULL DEFAULT NULL COMMENT '锁定直到时间',
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '主键ID',
  `created_at` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `updated_at` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `is_deleted` tinyint(1) NULL DEFAULT NULL COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `username`(`username`) USING BTREE,
  UNIQUE INDEX `email`(`email`) USING BTREE,
  UNIQUE INDEX `phone`(`phone`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES ('app', 'app@163.com', '122323', 'sha256$aa3c0fdaa484834558ffa778fe5b55d5$f801add1c0010f79423dd43b2f40119e8381e7d61fec1824fb544ee9042c81f0', NULL, 1, 0, '2026-01-16 14:33:13', '127.0.0.1', 0, NULL, '357f8ac2-a271-440a-a003-0db32d15d302', '2025-12-29 21:29:16', '2026-01-16 22:33:13', 0);
INSERT INTO `users` VALUES ('admin2', 'admin2@qq.com', '121223', 'sha256$bd70a86c14727dcb94501fa65a5c084b$68c6ba38a94db679c529f0edd66387b6a2c25ace41f4a20ffa2d0c70c61e2808', NULL, 1, 0, NULL, NULL, NULL, NULL, '3d0efc90-7c0c-42ca-8426-82bad3fdd0c7', '2025-12-29 21:35:23', '2025-12-29 21:36:08', 0);
INSERT INTO `users` VALUES ('wuming', 'wuming@123.com', '152312121', '$2b$12$ZNMn5VgpS/BOT4IE7cnzUOZ9Qkfy5tAtTOA12XqJ1fd9XZglbjCVS', NULL, 1, 0, NULL, NULL, NULL, NULL, '44d9ebb2-2c45-41a4-8067-9ba294c20037', '2026-01-16 21:22:08', '2026-01-16 21:55:37', 0);
INSERT INTO `users` VALUES ('wanger', 'wanger@163.com', '12121', '$2b$12$j0TyxO2VNk/OELxhLNR.SeTfw39nxbaOujd6KjaSF9aRRZBZ8K1ni', NULL, 1, 0, NULL, NULL, NULL, NULL, '545dc3f9-413d-422e-8748-692d9f390d5d', '2026-01-16 21:56:45', '2026-01-16 21:56:45', 0);
INSERT INTO `users` VALUES ('test', 'test@163.com', '', '$2b$12$3zKd5oS/0sy6DikVwkD/g.j/XSRPI3QbVSwfpr8ArbueDVlvVXTT.', NULL, 1, 0, NULL, NULL, NULL, NULL, 'afa20a1c-ea0a-4f65-9928-d2faf9eae6ef', '2025-12-27 13:49:12', '2026-01-19 16:56:40', 0);
INSERT INTO `users` VALUES ('zhangsan', 'zhangsan@qq.com', '143454545', '$2b$12$Cd2tbkzjKLNUwW79WqQ6kuxjS9T6f9YSlLjnOLqKnVnvd4dJjRo8G', NULL, 1, 0, '2026-01-16 16:09:08', '127.0.0.1', 0, NULL, 'd3e906de-b9a6-4a78-a643-233252252776', '2025-12-28 21:45:15', '2026-01-17 00:09:08', 0);
INSERT INTO `users` VALUES ('admin', 'admin@example.com', NULL, '$2b$12$DfKV5Sym0joX1TfwJvq6/OU6xfOWtTV4/0I6britY3ux8xE6.Xsnq', NULL, 1, 1, '2026-01-19 08:55:32', '127.0.0.1', 0, NULL, 'ed6a79d3-0083-4d81-8b48-fc522f686f74', '2025-12-20 13:53:13', '2026-01-19 16:55:32', 0);
INSERT INTO `users` VALUES ('lisi', 'lisi@163.com', '1212', 'sha256$acf8f69f3eb2dd30d02af946a922e3d4$6a3df9ff9f3f0248918dad1fbae0b63b796340bf4543fa18e1bfd72ed189cd2b', NULL, 0, 0, NULL, NULL, NULL, NULL, 'feb58a17-f436-43bb-9db8-d6a7bb6a836a', '2026-01-15 19:42:13', '2026-01-15 20:47:31', 0);

SET FOREIGN_KEY_CHECKS = 1;
