From 56e3c708eb0286b1f38b94a90f5b2038d4f5a50b Mon Sep 17 00:00:00 2001
From: 18586361686 <1207669650@qq.com>
Date: 星期三, 28 五月 2025 10:03:53 +0800
Subject: [PATCH] update: 更新sql
---
sql/aiflowy.data.sql | 1038 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 1,009 insertions(+), 29 deletions(-)
diff --git a/sql/aiflowy.data.sql b/sql/aiflowy.data.sql
index 6314a63..76582c0 100644
--- a/sql/aiflowy.data.sql
+++ b/sql/aiflowy.data.sql
@@ -1,67 +1,956 @@
-INSERT INTO `tb_ai_bot` VALUES (274724831961026560, 1, 1000000, '澶╂皵鏌ヨ', '澶╂皵鏌ヨ', NULL, 273418062806761472, '{\"systemPrompt\":\"浣犳槸澶╂皵鏌ヨ鍔╂墜\"}', NULL, '2025-04-29 15:19:24', 1, '2025-04-29 15:19:24', 1);
+SET NAMES utf8mb4;
+SET FOREIGN_KEY_CHECKS = 0;
+-- ----------------------------
+-- Table structure for qrtz_blob_triggers
+-- ----------------------------
+DROP TABLE IF EXISTS `qrtz_blob_triggers`;
+CREATE TABLE `qrtz_blob_triggers` (
+ `SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `TRIGGER_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `TRIGGER_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `BLOB_DATA` blob NULL,
+ PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
+ INDEX `SCHED_NAME`(`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
+ CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
+-- ----------------------------
+-- Records of qrtz_blob_triggers
+-- ----------------------------
-INSERT INTO `tb_ai_bot_knowledge` VALUES (6, 267746165268017152, 267751447398232064, NULL);
-INSERT INTO `tb_ai_bot_knowledge` VALUES (10, 269226938047168512, 273274084509630464, NULL);
-INSERT INTO `tb_ai_bot_knowledge` VALUES (11, 267778325987205120, 273416394929192960, NULL);
+-- ----------------------------
+-- Table structure for qrtz_calendars
+-- ----------------------------
+DROP TABLE IF EXISTS `qrtz_calendars`;
+CREATE TABLE `qrtz_calendars` (
+ `SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `CALENDAR_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `CALENDAR` blob NOT NULL,
+ PRIMARY KEY (`SCHED_NAME`, `CALENDAR_NAME`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
+-- ----------------------------
+-- Records of qrtz_calendars
+-- ----------------------------
+-- ----------------------------
+-- Table structure for qrtz_cron_triggers
+-- ----------------------------
+DROP TABLE IF EXISTS `qrtz_cron_triggers`;
+CREATE TABLE `qrtz_cron_triggers` (
+ `SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `TRIGGER_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `TRIGGER_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `CRON_EXPRESSION` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `TIME_ZONE_ID` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
+ CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
+-- ----------------------------
+-- Records of qrtz_cron_triggers
+-- ----------------------------
+-- ----------------------------
+-- Table structure for qrtz_fired_triggers
+-- ----------------------------
+DROP TABLE IF EXISTS `qrtz_fired_triggers`;
+CREATE TABLE `qrtz_fired_triggers` (
+ `SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `ENTRY_ID` varchar(95) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `TRIGGER_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `TRIGGER_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `INSTANCE_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `FIRED_TIME` bigint(0) NOT NULL,
+ `SCHED_TIME` bigint(0) NOT NULL,
+ `PRIORITY` int(0) NOT NULL,
+ `STATE` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `JOB_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `JOB_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ PRIMARY KEY (`SCHED_NAME`, `ENTRY_ID`) USING BTREE,
+ INDEX `IDX_QRTZ_FT_TRIG_INST_NAME`(`SCHED_NAME`, `INSTANCE_NAME`) USING BTREE,
+ INDEX `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY`(`SCHED_NAME`, `INSTANCE_NAME`, `REQUESTS_RECOVERY`) USING BTREE,
+ INDEX `IDX_QRTZ_FT_J_G`(`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) USING BTREE,
+ INDEX `IDX_QRTZ_FT_JG`(`SCHED_NAME`, `JOB_GROUP`) USING BTREE,
+ INDEX `IDX_QRTZ_FT_T_G`(`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
+ INDEX `IDX_QRTZ_FT_TG`(`SCHED_NAME`, `TRIGGER_GROUP`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
+-- ----------------------------
+-- Records of qrtz_fired_triggers
+-- ----------------------------
-INSERT INTO `tb_ai_bot_plugins` VALUES (267770208130498560, 267769906283216896, 267769494146711552, NULL);
-INSERT INTO `tb_ai_bot_plugins` VALUES (274649868264542208, 269226938047168512, 267769494146711552, NULL);
-INSERT INTO `tb_ai_bot_plugins` VALUES (274727326384918528, 274724831961026560, 273726420990324736, NULL);
-INSERT INTO `tb_ai_bot_plugins` VALUES (274728813039194112, 267848016181075968, 267769494146711552, NULL);
+-- ----------------------------
+-- Table structure for qrtz_job_details
+-- ----------------------------
+DROP TABLE IF EXISTS `qrtz_job_details`;
+CREATE TABLE `qrtz_job_details` (
+ `SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `JOB_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `JOB_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `DESCRIPTION` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `JOB_CLASS_NAME` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `IS_DURABLE` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `IS_UPDATE_DATA` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `JOB_DATA` blob NULL,
+ PRIMARY KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) USING BTREE,
+ INDEX `IDX_QRTZ_J_REQ_RECOVERY`(`SCHED_NAME`, `REQUESTS_RECOVERY`) USING BTREE,
+ INDEX `IDX_QRTZ_J_GRP`(`SCHED_NAME`, `JOB_GROUP`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
+-- ----------------------------
+-- Records of qrtz_job_details
+-- ----------------------------
+-- ----------------------------
+-- Table structure for qrtz_locks
+-- ----------------------------
+DROP TABLE IF EXISTS `qrtz_locks`;
+CREATE TABLE `qrtz_locks` (
+ `SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `LOCK_NAME` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ PRIMARY KEY (`SCHED_NAME`, `LOCK_NAME`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-INSERT INTO `tb_ai_chat_topic` VALUES (269265123934486528, 1, '鏈懡鍚�', '2025-04-14 13:44:28', NULL);
+-- ----------------------------
+-- Records of qrtz_locks
+-- ----------------------------
+INSERT INTO `qrtz_locks` VALUES ('quartzScheduler', 'TRIGGER_ACCESS');
+-- ----------------------------
+-- Table structure for qrtz_paused_trigger_grps
+-- ----------------------------
+DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
+CREATE TABLE `qrtz_paused_trigger_grps` (
+ `SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `TRIGGER_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ PRIMARY KEY (`SCHED_NAME`, `TRIGGER_GROUP`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-INSERT INTO `tb_ai_llm` VALUES (273418062806761472, 1, 1000000, '鏄熺伀澶фā鍨�', 'spark', NULL, NULL, 1, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'wss://spark-api.xf-yun.com/v3.5/chat', 'wss://spark-api.xf-yun.com/v3.5/chat', '', '', NULL);
+-- ----------------------------
+-- Records of qrtz_paused_trigger_grps
+-- ----------------------------
+-- ----------------------------
+-- Table structure for qrtz_scheduler_state
+-- ----------------------------
+DROP TABLE IF EXISTS `qrtz_scheduler_state`;
+CREATE TABLE `qrtz_scheduler_state` (
+ `SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `INSTANCE_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `LAST_CHECKIN_TIME` bigint(0) NOT NULL,
+ `CHECKIN_INTERVAL` bigint(0) NOT NULL,
+ PRIMARY KEY (`SCHED_NAME`, `INSTANCE_NAME`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-INSERT INTO `tb_ai_plugin` VALUES (273726420990324736, '鍜岄澶╂皵', '姣忔棩澶╂皵棰勬姤API锛屾彁渚涘叏鐞冨煄甯傛湭鏉�3-30澶╁ぉ姘旈鎶ワ紝鍖呮嫭锛氭棩鍑烘棩钀姐�佹湀鍗囨湀钀姐�佹渶楂樻渶浣庢俯搴︺�佸ぉ姘旂櫧澶╁拰澶滈棿鐘跺喌銆侀鍔涖�侀閫熴�侀鍚戙�佺浉瀵规箍搴︺�佸ぇ姘斿帇寮恒�侀檷姘撮噺銆侀湶鐐规俯搴︺�佺传澶栫嚎寮哄害銆佽兘瑙佸害绛夈��', NULL, 'https://jw54e3j6ha.re.qweatherapi.com', 'apiKey', '2025-04-26 21:12:04', '/attachment/2025/04-26/cfa688d9-9bc5-4d3f-a50c-2501604e8bed.jpg', 'query', '[{\"label\":\"X-QW-Api-Key\",\"value\":\"2ad5de1c5dddd44e589bece44fdad4258\"}]', 'q', '', NULL, NULL, NULL);
+-- ----------------------------
+-- Records of qrtz_scheduler_state
+-- ----------------------------
+-- ----------------------------
+-- Table structure for qrtz_simple_triggers
+-- ----------------------------
+DROP TABLE IF EXISTS `qrtz_simple_triggers`;
+CREATE TABLE `qrtz_simple_triggers` (
+ `SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `TRIGGER_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `TRIGGER_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `REPEAT_COUNT` bigint(0) NOT NULL,
+ `REPEAT_INTERVAL` bigint(0) NOT NULL,
+ `TIMES_TRIGGERED` bigint(0) NOT NULL,
+ PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
+ CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
-INSERT INTO `tb_ai_plugin_tool` VALUES (273931608955039744, 273726420990324736, 'get_weather', '鏌ヨ鏌愪釜鍩庡競鍦版柟鏈潵涓夊ぉ鐨勫ぉ姘�', '/v7/weather/3d', '2025-04-27 10:47:25', NULL, '[{\"name\":\"location\",\"description\":\"鍩庡競 LocationID锛堝 101010100 浠ｈ〃鍖椾含锛夛紝鍙�氳繃鍩庡競鍒楄〃鏌ヨ锛屽綋鐢ㄦ埛闂強渚嬪鍖椾含鐨勫ぉ姘旂殑鏃跺�欙紝澶фā鍨嬮渶瑕佹煡璇㈠寳浜浆鎹负瀵瑰簲鐨勫煄甯俰d\",\"type\":\"String\",\"method\":\"Query\",\"required\":true,\"defaultValue\":\"101010100\",\"enabled\":true,\"key\":\"1745905802390\"}]', NULL, 'Get', 0, 0);
-INSERT INTO `tb_ai_plugin_tool` VALUES (275035209345548290, 273726420990324736, 'get_cityId', '鍩庡競鎼滅储API鎻愪緵鍏ㄧ悆鍦扮悊浣嶄綅缃�佸叏鐞冨煄甯傛悳绱㈡湇鍔★紝鏀寔缁忕含搴﹀潗鏍囧弽鏌ャ�佸璇█銆佹ā绯婃悳绱㈢瓑鍔熻兘銆�', '/geo/v2/city/lookup', '2025-04-30 11:52:44', NULL, '[{\"name\":\"location\",\"description\":\"闇�瑕佹煡璇㈠湴鍖虹殑鍚嶇О锛屾敮鎸佹枃瀛椼�佷互鑻辨枃閫楀彿鍒嗛殧鐨勭粡搴�,绾害鍧愭爣锛堝崄杩涘埗锛屾渶澶氭敮鎸佸皬鏁扮偣鍚庝袱浣嶏級銆丩ocationID鎴朅dcode锛堜粎闄愪腑鍥藉煄甯傦級銆備緥濡� location=鍖椾含 鎴� location=116.41,39.92\",\"type\":\"String\",\"method\":\"Query\",\"required\":true,\"defaultValue\":\"\",\"enabled\":true,\"key\":\"1745985221077\"}]', NULL, 'Get', 0, 0);
+-- ----------------------------
+-- Records of qrtz_simple_triggers
+-- ----------------------------
+-- ----------------------------
+-- Table structure for qrtz_simprop_triggers
+-- ----------------------------
+DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
+CREATE TABLE `qrtz_simprop_triggers` (
+ `SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `TRIGGER_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `TRIGGER_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `STR_PROP_1` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `STR_PROP_2` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `STR_PROP_3` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `INT_PROP_1` int(0) NULL DEFAULT NULL,
+ `INT_PROP_2` int(0) NULL DEFAULT NULL,
+ `LONG_PROP_1` bigint(0) NULL DEFAULT NULL,
+ `LONG_PROP_2` bigint(0) NULL DEFAULT NULL,
+ `DEC_PROP_1` decimal(13, 4) NULL DEFAULT NULL,
+ `DEC_PROP_2` decimal(13, 4) NULL DEFAULT NULL,
+ `BOOL_PROP_1` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `BOOL_PROP_2` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
+ CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
+-- ----------------------------
+-- Records of qrtz_simprop_triggers
+-- ----------------------------
-INSERT INTO `tb_ai_plugins` VALUES (267769494146711552, 1, 1000000, 1, 'get_ip_info', '鏍规嵁ip鑾峰彇鍖哄煙淇℃伅', '{\"method\":\"GET\",\"url\":\"https://qifu-api.baidubce.com/ip/geo/v1/district\",\"headers\":[],\"params\":[{\"key\":\"ip\",\"value\":\"\",\"desc\":\"IP鍦板潃\"}],\"body\":{}}', 1, '2025-04-10 10:41:22', 1, '2025-04-29 10:21:07', 1, '', 0, NULL);
-INSERT INTO `tb_ai_plugins` VALUES (269229432299077632, 1, 1000000, 1, 'test', 'test', NULL, 1, '2025-04-14 11:22:39', 1, '2025-04-14 11:22:39', 1, '', 0, '/attachment/2025/04-14/e2f3e5a5-a4fa-4abe-8fe6-49d10c3d8dbe.jpeg');
+-- ----------------------------
+-- Table structure for qrtz_triggers
+-- ----------------------------
+DROP TABLE IF EXISTS `qrtz_triggers`;
+CREATE TABLE `qrtz_triggers` (
+ `SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `TRIGGER_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `TRIGGER_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `JOB_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `JOB_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `DESCRIPTION` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `NEXT_FIRE_TIME` bigint(0) NULL DEFAULT NULL,
+ `PREV_FIRE_TIME` bigint(0) NULL DEFAULT NULL,
+ `PRIORITY` int(0) NULL DEFAULT NULL,
+ `TRIGGER_STATE` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `TRIGGER_TYPE` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `START_TIME` bigint(0) NOT NULL,
+ `END_TIME` bigint(0) NULL DEFAULT NULL,
+ `CALENDAR_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `MISFIRE_INSTR` smallint(0) NULL DEFAULT NULL,
+ `JOB_DATA` blob NULL,
+ PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
+ INDEX `IDX_QRTZ_T_J`(`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) USING BTREE,
+ INDEX `IDX_QRTZ_T_JG`(`SCHED_NAME`, `JOB_GROUP`) USING BTREE,
+ INDEX `IDX_QRTZ_T_C`(`SCHED_NAME`, `CALENDAR_NAME`) USING BTREE,
+ INDEX `IDX_QRTZ_T_G`(`SCHED_NAME`, `TRIGGER_GROUP`) USING BTREE,
+ INDEX `IDX_QRTZ_T_STATE`(`SCHED_NAME`, `TRIGGER_STATE`) USING BTREE,
+ INDEX `IDX_QRTZ_T_N_STATE`(`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`, `TRIGGER_STATE`) USING BTREE,
+ INDEX `IDX_QRTZ_T_N_G_STATE`(`SCHED_NAME`, `TRIGGER_GROUP`, `TRIGGER_STATE`) USING BTREE,
+ INDEX `IDX_QRTZ_T_NEXT_FIRE_TIME`(`SCHED_NAME`, `NEXT_FIRE_TIME`) USING BTREE,
+ INDEX `IDX_QRTZ_T_NFT_ST`(`SCHED_NAME`, `TRIGGER_STATE`, `NEXT_FIRE_TIME`) USING BTREE,
+ INDEX `IDX_QRTZ_T_NFT_MISFIRE`(`SCHED_NAME`, `MISFIRE_INSTR`, `NEXT_FIRE_TIME`) USING BTREE,
+ INDEX `IDX_QRTZ_T_NFT_ST_MISFIRE`(`SCHED_NAME`, `MISFIRE_INSTR`, `NEXT_FIRE_TIME`, `TRIGGER_STATE`) USING BTREE,
+ INDEX `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP`(`SCHED_NAME`, `MISFIRE_INSTR`, `NEXT_FIRE_TIME`, `TRIGGER_GROUP`, `TRIGGER_STATE`) USING BTREE,
+ CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
+-- ----------------------------
+-- Records of qrtz_triggers
+-- ----------------------------
+-- ----------------------------
+-- Table structure for tb_ai_bot
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_ai_bot`;
+CREATE TABLE `tb_ai_bot` (
+ `id` bigint(0) UNSIGNED NOT NULL COMMENT '涓婚敭ID',
+ `dept_id` bigint(0) UNSIGNED NOT NULL COMMENT '閮ㄩ棬ID',
+ `tenant_id` bigint(0) UNSIGNED NOT NULL COMMENT '绉熸埛ID',
+ `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏍囬',
+ `description` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎻忚堪',
+ `icon` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍥炬爣',
+ `llm_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT 'LLM ID',
+ `llm_options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT 'LLM閫夐」',
+ `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '閫夐」',
+ `created` datetime(0) NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ `created_by` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '鍒涘缓鑰匢D',
+ `modified` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃堕棿',
+ `modified_by` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '淇敼鑰匢D',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
+-- ----------------------------
+-- Records of tb_ai_bot
+-- ----------------------------
+-- ----------------------------
+-- Table structure for tb_ai_bot_conversation_message
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_ai_bot_conversation_message`;
+CREATE TABLE `tb_ai_bot_conversation_message` (
+ `session_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '浼氳瘽id',
+ `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '浼氳瘽鏍囬',
+ `bot_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT 'botid',
+ `account_id` bigint(0) UNSIGNED NULL DEFAULT NULL,
+ `created` datetime(0) NULL DEFAULT NULL,
+ PRIMARY KEY (`session_id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_ai_bot_conversation_message
+-- ----------------------------
+
+-- ----------------------------
+-- Table structure for tb_ai_bot_knowledge
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_ai_bot_knowledge`;
+CREATE TABLE `tb_ai_bot_knowledge` (
+ `id` bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT,
+ `bot_id` bigint(0) UNSIGNED NULL DEFAULT NULL,
+ `knowledge_id` bigint(0) UNSIGNED NULL DEFAULT NULL,
+ `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_ai_bot_knowledge
+-- ----------------------------
+
+-- ----------------------------
+-- Table structure for tb_ai_bot_llm
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_ai_bot_llm`;
+CREATE TABLE `tb_ai_bot_llm` (
+ `id` bigint(0) UNSIGNED NOT NULL,
+ `bot_id` bigint(0) UNSIGNED NULL DEFAULT NULL,
+ `llm_id` bigint(0) UNSIGNED NULL DEFAULT NULL,
+ `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_ai_bot_llm
+-- ----------------------------
+
+-- ----------------------------
+-- Table structure for tb_ai_bot_message
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_ai_bot_message`;
+CREATE TABLE `tb_ai_bot_message` (
+ `id` bigint(0) UNSIGNED NOT NULL,
+ `bot_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT 'Bot ID',
+ `account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '鍏宠仈鐨勮处鎴稩D',
+ `session_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '浼氳瘽ID',
+ `role` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
+ `image` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `prompt_tokens` int(0) NULL DEFAULT NULL,
+ `completion_tokens` int(0) NULL DEFAULT NULL,
+ `total_tokens` int(0) NULL DEFAULT NULL,
+ `functions` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鏂规硶瀹氫箟',
+ `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
+ `created` datetime(0) NULL DEFAULT NULL,
+ `modified` datetime(0) NULL DEFAULT NULL,
+ `is_external_msg` int(0) NULL DEFAULT NULL COMMENT '1鏄痚xternal 娑堟伅锛�0: bot椤甸潰娑堟伅',
+ PRIMARY KEY (`id`) USING BTREE,
+ INDEX `bot_id`(`bot_id`) USING BTREE,
+ INDEX `account_id`(`account_id`) USING BTREE,
+ INDEX `session_id`(`session_id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'Bot 娑堟伅璁板綍琛�' ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_ai_bot_message
+-- ----------------------------
+
+-- ----------------------------
+-- Table structure for tb_ai_bot_plugins
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_ai_bot_plugins`;
+CREATE TABLE `tb_ai_bot_plugins` (
+ `id` bigint(0) UNSIGNED NOT NULL,
+ `bot_id` bigint(0) UNSIGNED NULL DEFAULT NULL,
+ `plugin_tool_id` bigint(0) UNSIGNED NULL DEFAULT NULL,
+ `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_ai_bot_plugins
+-- ----------------------------
+INSERT INTO `tb_ai_bot_plugins` VALUES (280116466740240384, 278011369393938432, 277283081642319872, NULL);
+INSERT INTO `tb_ai_bot_plugins` VALUES (280133559255355392, 267769906283216896, 280111871524397056, NULL);
+INSERT INTO `tb_ai_bot_plugins` VALUES (281897987377704960, 274724831961026560, 275035209345548290, NULL);
+INSERT INTO `tb_ai_bot_plugins` VALUES (281970760775086080, 277283496643534848, 277283081642319872, NULL);
+INSERT INTO `tb_ai_bot_plugins` VALUES (282255082572685312, 267769906283216896, 273931608955039744, NULL);
+INSERT INTO `tb_ai_bot_plugins` VALUES (282355755859443712, 281900928474001408, 273931608955039744, NULL);
+INSERT INTO `tb_ai_bot_plugins` VALUES (282360824344604672, 281900928474001408, 275035209345548290, NULL);
+
+-- ----------------------------
+-- Table structure for tb_ai_bot_workflow
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_ai_bot_workflow`;
+CREATE TABLE `tb_ai_bot_workflow` (
+ `id` bigint(0) UNSIGNED NOT NULL,
+ `bot_id` bigint(0) UNSIGNED NULL DEFAULT NULL,
+ `workflow_id` bigint(0) UNSIGNED NULL DEFAULT NULL,
+ `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_ai_bot_workflow
+-- ----------------------------
+INSERT INTO `tb_ai_bot_workflow` VALUES (277733999076483072, 277279510330875904, 277622882927935488, NULL);
+INSERT INTO `tb_ai_bot_workflow` VALUES (277735203709952000, 274752243065470976, 277554862343864320, NULL);
+INSERT INTO `tb_ai_bot_workflow` VALUES (280097469102350336, 278011369393938432, 279343858202828800, NULL);
+INSERT INTO `tb_ai_bot_workflow` VALUES (283405968522584064, 267769906283216896, 280863596110540800, NULL);
+
+-- ----------------------------
+-- Table structure for tb_ai_chat_message
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_ai_chat_message`;
+CREATE TABLE `tb_ai_chat_message` (
+ `id` bigint(0) UNSIGNED NOT NULL,
+ `topic_id` bigint(0) UNSIGNED NULL DEFAULT NULL,
+ `role` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
+ `image` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `prompt_tokens` int(0) NULL DEFAULT NULL,
+ `completion_tokens` int(0) NULL DEFAULT NULL,
+ `total_tokens` int(0) NULL DEFAULT NULL,
+ `tools` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
+ `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
+ `created` datetime(0) NULL DEFAULT NULL,
+ `modified` datetime(0) NULL DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE,
+ INDEX `topic_id`(`topic_id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'AI 娑堟伅璁板綍琛�' ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_ai_chat_message
+-- ----------------------------
+
+-- ----------------------------
+-- Table structure for tb_ai_chat_topic
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_ai_chat_topic`;
+CREATE TABLE `tb_ai_chat_topic` (
+ `id` bigint(0) UNSIGNED NOT NULL,
+ `account_id` bigint(0) UNSIGNED NULL DEFAULT NULL,
+ `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
+ `created` datetime(0) NULL DEFAULT NULL,
+ `modified` datetime(0) NULL DEFAULT NULL,
+ PRIMARY KEY (`id`) USING BTREE,
+ INDEX `account_id`(`account_id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'AI 璇濋琛�' ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_ai_chat_topic
+-- ----------------------------
+
+-- ----------------------------
+-- Table structure for tb_ai_document
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_ai_document`;
+CREATE TABLE `tb_ai_document` (
+ `id` bigint(0) UNSIGNED NOT NULL,
+ `knowledge_id` bigint(0) UNSIGNED NOT NULL COMMENT '鐭ヨ瘑搴揑D',
+ `document_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏂囨。绫诲瀷 pdf/word/aieditor 绛�',
+ `document_path` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏂囨。璺緞',
+ `title` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏍囬',
+ `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鍐呭',
+ `content_type` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍐呭绫诲瀷',
+ `slug` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'URL 鍒悕',
+ `order_no` int(0) NULL DEFAULT NULL COMMENT '鎺掑簭搴忓彿',
+ `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鍏朵粬閰嶇疆椤�',
+ `created` datetime(0) NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ `created_by` bigint(0) NULL DEFAULT NULL COMMENT '鍒涘缓浜篒D',
+ `modified` datetime(0) NULL DEFAULT NULL COMMENT '鏈�鍚庣殑淇敼鏃堕棿',
+ `modified_by` bigint(0) NULL DEFAULT NULL COMMENT '鏈�鍚庣殑淇敼浜虹殑ID',
+ PRIMARY KEY (`id`) USING BTREE,
+ INDEX `knowledge_id`(`knowledge_id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鏂囨。' ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_ai_document
+-- ----------------------------
+
+-- ----------------------------
+-- Table structure for tb_ai_document_chunk
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_ai_document_chunk`;
+CREATE TABLE `tb_ai_document_chunk` (
+ `id` bigint(0) UNSIGNED NOT NULL,
+ `document_id` bigint(0) UNSIGNED NOT NULL COMMENT '鏂囨。ID',
+ `knowledge_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '鐭ヨ瘑搴揑D',
+ `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鍒嗗潡鍐呭',
+ `sorting` int(0) UNSIGNED NULL DEFAULT NULL COMMENT '鍒嗗壊椤哄簭',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_ai_document_chunk
+-- ----------------------------
+
+-- ----------------------------
+-- Table structure for tb_ai_document_history
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_ai_document_history`;
+CREATE TABLE `tb_ai_document_history` (
+ `id` bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT,
+ `document_id` bigint(0) NULL DEFAULT NULL COMMENT '淇敼鐨勬枃妗D',
+ `old_title` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏃ф爣棰�',
+ `new_title` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏂版爣棰�',
+ `old_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鏃у唴瀹�',
+ `new_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鏂板唴瀹�',
+ `old_document_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏃х殑鏂囨。绫诲瀷',
+ `new_document_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏂扮殑棰濇枃妗ｇ被鍨�',
+ `created` datetime(0) NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ `created_by` bigint(0) NULL DEFAULT NULL COMMENT '鍒涘缓浜篒D',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_ai_document_history
+-- ----------------------------
+
+-- ----------------------------
+-- Table structure for tb_ai_knowledge
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_ai_knowledge`;
+CREATE TABLE `tb_ai_knowledge` (
+ `id` bigint(0) UNSIGNED NOT NULL,
+ `dept_id` bigint(0) UNSIGNED NOT NULL COMMENT '閮ㄩ棬ID',
+ `tenant_id` bigint(0) UNSIGNED NOT NULL COMMENT '绉熸埛ID',
+ `icon` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'ICON',
+ `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏍囬',
+ `description` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎻忚堪',
+ `slug` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'URL 鍒悕',
+ `vector_store_enable` tinyint(1) NULL DEFAULT NULL COMMENT '鏄惁鍚敤鍚戦噺瀛樺偍',
+ `vector_store_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍚戦噺鏁版嵁搴撶被鍨�',
+ `vector_store_collection` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍚戦噺鏁版嵁搴撻泦鍚�',
+ `vector_store_config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鍚戦噺鏁版嵁搴撻厤缃�',
+ `vector_embed_llm_id` bigint(0) NULL DEFAULT NULL COMMENT 'Embedding 妯″瀷ID',
+ `created` datetime(0) NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ `created_by` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '鍒涘缓鐢ㄦ埛ID',
+ `modified` datetime(0) NULL DEFAULT NULL COMMENT '鏈�鍚庝竴娆′慨鏀规椂闂�',
+ `modified_by` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '鏈�鍚庝竴娆′慨鏀圭敤鎴稩D',
+ `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鍏朵粬閰嶇疆',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐭ヨ瘑搴�' ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_ai_knowledge
+-- ----------------------------
+
+-- ----------------------------
+-- Table structure for tb_ai_llm
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_ai_llm`;
+CREATE TABLE `tb_ai_llm` (
+ `id` bigint(0) UNSIGNED NOT NULL,
+ `dept_id` bigint(0) UNSIGNED NOT NULL COMMENT '閮ㄩ棬ID',
+ `tenant_id` bigint(0) UNSIGNED NOT NULL COMMENT '绉熸埛ID',
+ `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏍囬鎴栧悕绉�',
+ `brand` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍝佺墝',
+ `icon` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'ICON',
+ `description` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎻忚堪',
+ `support_chat` tinyint(1) NULL DEFAULT NULL COMMENT '鏄惁鏀寔瀵硅瘽',
+ `support_function_calling` tinyint(1) NULL DEFAULT NULL COMMENT '鏄惁鏀寔鏂规硶璋冪敤',
+ `support_embed` tinyint(1) NULL DEFAULT NULL COMMENT '鏄惁鏀寔鍚戦噺鍖�',
+ `support_reranker` tinyint(1) NULL DEFAULT NULL COMMENT '鏄惁鏀寔閲嶆帓',
+ `support_text_to_image` tinyint(1) NULL DEFAULT NULL COMMENT '鏄惁鏀寔鏂囧瓧鐢熸垚鍥剧墖',
+ `support_image_to_image` tinyint(1) NULL DEFAULT NULL COMMENT '鏄惁鏀寔鍥剧墖鐢熸垚鍥剧墖',
+ `support_text_to_audio` tinyint(1) NULL DEFAULT NULL COMMENT '鏄惁鏀寔鏂囧瓧鐢熸垚璇煶',
+ `support_audio_to_audio` tinyint(1) NULL DEFAULT NULL COMMENT '鏄惁鏀寔璇煶鐢熸垚璇煶',
+ `support_text_to_video` tinyint(1) NULL DEFAULT NULL COMMENT '鏄惁鏀寔鏂囧瓧鐢熸垚瑙嗛',
+ `support_image_to_video` tinyint(1) NULL DEFAULT NULL COMMENT '鏄惁鏀寔鍥剧墖鐢熸垚瑙嗛',
+ `llm_endpoint` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶фā鍨嬭姹傚湴鍧�',
+ `llm_model` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶фā鍨嬪悕绉�',
+ `llm_api_key` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶фā鍨� API KEY',
+ `llm_extra_config` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '澶фā鍨嬪叾浠栧睘鎬ч厤缃�',
+ `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鍏朵粬閰嶇疆鍐呭',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_ai_llm
+-- ----------------------------
+
+-- ----------------------------
+-- Table structure for tb_ai_plugin
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_ai_plugin`;
+CREATE TABLE `tb_ai_plugin` (
+ `id` bigint(0) NOT NULL COMMENT '鎻掍欢id',
+ `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鍚嶇О',
+ `description` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎻忚堪',
+ `type` int(0) NULL DEFAULT NULL COMMENT '绫诲瀷',
+ `base_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍩虹URL',
+ `auth_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '璁よ瘉鏂瑰紡 銆恆piKey/none銆�',
+ `created` datetime(0) NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍥炬爣鍦板潃',
+ `position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '璁よ瘉鍙傛暟浣嶇疆 銆恏eaders, query銆�',
+ `headers` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '璇锋眰澶�',
+ `token_key` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'token閿�',
+ `token_value` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'token鍊�',
+ `dept_id` bigint(0) NULL DEFAULT NULL COMMENT '閮ㄩ棬id',
+ `tenant_id` bigint(0) NULL DEFAULT NULL COMMENT '绉熸埛id',
+ `created_by` bigint(0) NULL DEFAULT NULL COMMENT '鍒涘缓浜�',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_ai_plugin
+-- ----------------------------
+
+-- ----------------------------
+-- Table structure for tb_ai_plugin_categories
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_ai_plugin_categories`;
+CREATE TABLE `tb_ai_plugin_categories` (
+ `id` int(0) NOT NULL AUTO_INCREMENT,
+ `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
+ `created_at` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_ai_plugin_categories
+-- ----------------------------
+
+-- ----------------------------
+-- Table structure for tb_ai_plugin_category_relation
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_ai_plugin_category_relation`;
+CREATE TABLE `tb_ai_plugin_category_relation` (
+ `category_id` int(0) NOT NULL,
+ `plugin_id` bigint(0) NOT NULL
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_ai_plugin_category_relation
+-- ----------------------------
+
+-- ----------------------------
+-- Table structure for tb_ai_plugin_tool
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_ai_plugin_tool`;
+CREATE TABLE `tb_ai_plugin_tool` (
+ `id` bigint(0) NOT NULL COMMENT '鎻掍欢宸ュ叿id',
+ `plugin_id` bigint(0) NOT NULL COMMENT '鎻掍欢id',
+ `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鍚嶇О',
+ `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎻忚堪',
+ `base_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍩虹璺緞',
+ `created` datetime(0) NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ `status` int(0) NULL DEFAULT NULL COMMENT '鏄惁鍚敤',
+ `input_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '杈撳叆鍙傛暟',
+ `output_data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '杈撳嚭鍙傛暟',
+ `request_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '璇锋眰鏂瑰紡銆怭ost, Get, Put, Delete銆�',
+ `service_status` int(0) NULL DEFAULT NULL COMMENT '鏈嶅姟鐘舵�乕0 涓嬬嚎 1 涓婄嚎]',
+ `debug_status` int(0) NULL DEFAULT NULL COMMENT '璋冭瘯鐘舵�併��0澶辫触 1鎴愬姛銆�',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_ai_plugin_tool
+-- ----------------------------
+
+-- ----------------------------
+-- Table structure for tb_ai_plugins
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_ai_plugins`;
+CREATE TABLE `tb_ai_plugins` (
+ `id` bigint(0) UNSIGNED NOT NULL COMMENT '涓婚敭',
+ `dept_id` bigint(0) UNSIGNED NOT NULL COMMENT '閮ㄩ棬ID',
+ `tenant_id` bigint(0) UNSIGNED NOT NULL COMMENT '绉熸埛ID',
+ `plugin_type` tinyint(0) NOT NULL DEFAULT 1 COMMENT '鎻掍欢绫诲瀷',
+ `plugin_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鎻掍欢鍚嶇О',
+ `plugin_desc` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鎻掍欢鎻忚堪',
+ `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鎻掍欢閰嶇疆',
+ `status` tinyint(0) NOT NULL DEFAULT 0 COMMENT '鏁版嵁鐘舵��',
+ `created` datetime(0) NOT NULL COMMENT '鍒涘缓鏃堕棿',
+ `created_by` bigint(0) UNSIGNED NOT NULL COMMENT '鍒涘缓鑰�',
+ `modified` datetime(0) NOT NULL COMMENT '淇敼鏃堕棿',
+ `modified_by` bigint(0) UNSIGNED NOT NULL COMMENT '淇敼鑰�',
+ `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '澶囨敞',
+ `is_deleted` tinyint(0) NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囪瘑',
+ `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鍥炬爣',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鎻掍欢' ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_ai_plugins
+-- ----------------------------
+
+-- ----------------------------
+-- Table structure for tb_ai_workflow
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_ai_workflow`;
+CREATE TABLE `tb_ai_workflow` (
+ `id` bigint(0) UNSIGNED NOT NULL COMMENT 'ID 涓婚敭',
+ `dept_id` bigint(0) UNSIGNED NOT NULL COMMENT '閮ㄩ棬ID',
+ `tenant_id` bigint(0) UNSIGNED NOT NULL COMMENT '绉熸埛ID',
+ `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏍囬',
+ `description` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎻忚堪',
+ `icon` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'ICON',
+ `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '宸ヤ綔娴佽璁＄殑 JSON 鍐呭',
+ `created` datetime(0) NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ `created_by` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '鍒涘缓浜�',
+ `modified` datetime(0) NULL DEFAULT NULL COMMENT '鏈�鍚庝慨鏀规椂闂�',
+ `modified_by` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '鏈�鍚庝慨鏀圭殑浜�',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_ai_workflow
+-- ----------------------------
+
+-- ----------------------------
+-- Table structure for tb_sys_account
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_sys_account`;
+CREATE TABLE `tb_sys_account` (
+ `id` bigint(0) UNSIGNED NOT NULL COMMENT '涓婚敭',
+ `dept_id` bigint(0) UNSIGNED NOT NULL COMMENT '閮ㄩ棬ID',
+ `tenant_id` bigint(0) UNSIGNED NOT NULL COMMENT '绉熸埛ID',
+ `login_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鐧诲綍璐﹀彿',
+ `password` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '瀵嗙爜',
+ `account_type` tinyint(0) NOT NULL DEFAULT 0 COMMENT '璐︽埛绫诲瀷',
+ `nickname` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '鏄电О',
+ `mobile` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '鎵嬫満鐢佃瘽',
+ `email` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '閭欢',
+ `avatar` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '璐︽埛澶村儚',
+ `data_scope` int(0) NULL DEFAULT 1 COMMENT '鏁版嵁鏉冮檺绫诲瀷',
+ `dept_id_list` json NULL COMMENT '鑷畾涔夐儴闂ㄦ潈闄�',
+ `status` tinyint(0) NOT NULL DEFAULT 0 COMMENT '鏁版嵁鐘舵��',
+ `created` datetime(0) NOT NULL COMMENT '鍒涘缓鏃堕棿',
+ `created_by` bigint(0) UNSIGNED NOT NULL COMMENT '鍒涘缓鑰�',
+ `modified` datetime(0) NOT NULL COMMENT '淇敼鏃堕棿',
+ `modified_by` bigint(0) UNSIGNED NOT NULL COMMENT '淇敼鑰�',
+ `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '澶囨敞',
+ `is_deleted` tinyint(0) NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囪瘑',
+ PRIMARY KEY (`id`) USING BTREE,
+ UNIQUE INDEX `uni_login_name`(`login_name`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐢ㄦ埛琛�' ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_sys_account
+-- ----------------------------
INSERT INTO `tb_sys_account` VALUES (1, 1, 1000000, 'admin', '$2a$10$S8HVnrS8m7iygQBS7r1dYuOstEUl5q/W1yhgFcS1uyL6o2/23yUYO', 99, '瓒呯骇绠＄悊鍛�', '15555555555', 'aaa@qq.com', '/attachment/2025/04-10/59866709-5bc5-4e9f-9445-ecb603ff2d82.jpg', 1, NULL, 1, '2025-04-10 16:33:48', 1, '2025-04-10 17:56:17', 1, '', 0);
+-- ----------------------------
+-- Table structure for tb_sys_account_position
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_sys_account_position`;
+CREATE TABLE `tb_sys_account_position` (
+ `id` bigint(0) UNSIGNED NOT NULL COMMENT '涓婚敭',
+ `account_id` bigint(0) UNSIGNED NOT NULL COMMENT '鐢ㄦ埛ID',
+ `position_id` bigint(0) UNSIGNED NOT NULL COMMENT '鑱屼綅ID',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐢ㄦ埛-鑱屼綅琛�' ROW_FORMAT = Dynamic;
+-- ----------------------------
+-- Records of tb_sys_account_position
+-- ----------------------------
INSERT INTO `tb_sys_account_position` VALUES (267858187553452032, 1, 259067270360543232);
+-- ----------------------------
+-- Table structure for tb_sys_account_role
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_sys_account_role`;
+CREATE TABLE `tb_sys_account_role` (
+ `id` bigint(0) UNSIGNED NOT NULL COMMENT '涓婚敭',
+ `account_id` bigint(0) UNSIGNED NOT NULL COMMENT '鐢ㄦ埛ID',
+ `role_id` bigint(0) UNSIGNED NOT NULL COMMENT '瑙掕壊ID',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鐢ㄦ埛-瑙掕壊琛�' ROW_FORMAT = Dynamic;
+-- ----------------------------
+-- Records of tb_sys_account_role
+-- ----------------------------
INSERT INTO `tb_sys_account_role` VALUES (267858187456983040, 1, 1);
+-- ----------------------------
+-- Table structure for tb_sys_api_key
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_sys_api_key`;
+CREATE TABLE `tb_sys_api_key` (
+ `id` bigint(0) NOT NULL COMMENT 'id',
+ `api_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'apiKey',
+ `created` datetime(0) NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ `status` tinyint(0) NULL DEFAULT NULL COMMENT '鐘舵��1鍚敤 2澶辨晥',
+ `dept_id` bigint(0) NULL DEFAULT NULL COMMENT '閮ㄩ棬id',
+ `tenant_id` bigint(0) NULL DEFAULT NULL COMMENT '绉熸埛id',
+ `expired_at` datetime(0) NULL DEFAULT NULL COMMENT '澶辨晥鏃堕棿',
+ `user_id` bigint(0) NULL DEFAULT NULL COMMENT '鍒涘缓浜�',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
+-- ----------------------------
+-- Records of tb_sys_api_key
+-- ----------------------------
-INSERT INTO `tb_sys_api_key` VALUES (275081657634275328, '8e8ca1ff71d1430d9ad2a074f5901ed8', '2025-04-30 14:57:18', 1, 1, 1000000, '2025-05-30 00:00:00', 1);
+-- ----------------------------
+-- Table structure for tb_sys_dept
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_sys_dept`;
+CREATE TABLE `tb_sys_dept` (
+ `id` bigint(0) UNSIGNED NOT NULL COMMENT '涓婚敭',
+ `tenant_id` bigint(0) UNSIGNED NOT NULL COMMENT '绉熸埛ID',
+ `parent_id` bigint(0) UNSIGNED NOT NULL COMMENT '鐖剁骇ID',
+ `ancestors` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '鐖剁骇閮ㄩ棬ID闆嗗悎',
+ `dept_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '閮ㄩ棬鍚嶇О',
+ `dept_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '閮ㄩ棬缂栫爜',
+ `sort_no` int(0) NULL DEFAULT 0 COMMENT '鎺掑簭',
+ `status` tinyint(0) NOT NULL DEFAULT 0 COMMENT '鏁版嵁鐘舵��',
+ `created` datetime(0) NOT NULL COMMENT '鍒涘缓鏃堕棿',
+ `created_by` bigint(0) UNSIGNED NOT NULL COMMENT '鍒涘缓鑰�',
+ `modified` datetime(0) NOT NULL COMMENT '淇敼鏃堕棿',
+ `modified_by` bigint(0) UNSIGNED NOT NULL COMMENT '淇敼鑰�',
+ `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '澶囨敞',
+ `is_deleted` tinyint(0) NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囪瘑',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '閮ㄩ棬琛�' ROW_FORMAT = Dynamic;
-
-
+-- ----------------------------
+-- Records of tb_sys_dept
+-- ----------------------------
INSERT INTO `tb_sys_dept` VALUES (1, 1000000, 0, '0', '鎬诲叕鍙�', 'root_dept', 0, 1, '2025-03-17 09:09:57', 1, '2025-03-17 09:10:00', 1, '', 0);
+-- ----------------------------
+-- Table structure for tb_sys_dict
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_sys_dict`;
+CREATE TABLE `tb_sys_dict` (
+ `id` bigint(0) UNSIGNED NOT NULL COMMENT '涓婚敭',
+ `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鏁版嵁瀛楀吀鍚嶇О',
+ `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '瀛楀吀缂栫爜',
+ `description` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '瀛楀吀鎻忚堪鎴栧娉�',
+ `dict_type` tinyint(0) NULL DEFAULT NULL COMMENT '瀛楀吀绫诲瀷 1 鑷畾涔夊瓧鍏搞��2 鏁版嵁琛ㄥ瓧鍏搞�� 3 鏋氫妇绫诲瓧鍏搞�� 4 绯荤粺瀛楀吀锛堣嚜瀹氫箟 DictLoader锛�',
+ `sort_no` int(0) NULL DEFAULT NULL COMMENT '鎺掑簭缂栧彿',
+ `status` tinyint(0) NULL DEFAULT NULL COMMENT '鏄惁鍚敤',
+ `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鎵╁睍瀛楀吀 瀛樻斁 json',
+ `created` datetime(0) NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ `modified` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃堕棿',
+ PRIMARY KEY (`id`) USING BTREE,
+ UNIQUE INDEX `key`(`code`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '绯荤粺瀛楀吀琛�' ROW_FORMAT = Dynamic;
-
+-- ----------------------------
+-- Records of tb_sys_dict
+-- ----------------------------
INSERT INTO `tb_sys_dict` VALUES (268213400717598720, 'test', 'test', 'test', 1, NULL, NULL, '{}', '2025-04-11 16:05:18', '2025-04-11 16:05:18');
+-- ----------------------------
+-- Table structure for tb_sys_dict_item
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_sys_dict_item`;
+CREATE TABLE `tb_sys_dict_item` (
+ `id` bigint(0) UNSIGNED NOT NULL COMMENT '涓婚敭',
+ `dict_id` bigint(0) UNSIGNED NOT NULL COMMENT '褰掑睘鍝釜瀛楀吀',
+ `text` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '鍚嶇О鎴栧唴瀹�',
+ `value` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '鍊�',
+ `description` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎻忚堪',
+ `sort_no` int(0) NOT NULL DEFAULT 0 COMMENT '鎺掑簭',
+ `css_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT 'css鏍峰紡鍐呭',
+ `css_class` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'css鏍峰紡绫诲悕',
+ `remark` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '澶囨敞',
+ `status` tinyint(0) NULL DEFAULT 0 COMMENT '鐘舵��',
+ `created` datetime(0) NULL DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
+ `modified` datetime(0) NULL DEFAULT NULL COMMENT '淇敼鏃堕棿',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鏁版嵁瀛楀吀鍐呭' ROW_FORMAT = Dynamic;
+-- ----------------------------
+-- Records of tb_sys_dict_item
+-- ----------------------------
+-- ----------------------------
+-- Table structure for tb_sys_job
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_sys_job`;
+CREATE TABLE `tb_sys_job` (
+ `id` bigint(0) UNSIGNED NOT NULL COMMENT '涓婚敭',
+ `dept_id` bigint(0) UNSIGNED NOT NULL COMMENT '閮ㄩ棬ID',
+ `tenant_id` bigint(0) UNSIGNED NOT NULL COMMENT '绉熸埛ID',
+ `job_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '浠诲姟鍚嶇О',
+ `job_type` int(0) NOT NULL COMMENT '浠诲姟绫诲瀷',
+ `job_params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '浠诲姟鍙傛暟',
+ `cron_expression` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'cron琛ㄨ揪寮�',
+ `allow_concurrent` int(0) NOT NULL DEFAULT 0 COMMENT '鏄惁骞跺彂鎵ц',
+ `misfire_policy` int(0) NOT NULL DEFAULT 3 COMMENT '閿欒繃绛栫暐',
+ `options` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鍏朵粬閰嶇疆',
+ `status` tinyint(0) NOT NULL DEFAULT 0 COMMENT '鏁版嵁鐘舵��',
+ `created` datetime(0) NOT NULL COMMENT '鍒涘缓鏃堕棿',
+ `created_by` bigint(0) UNSIGNED NOT NULL COMMENT '鍒涘缓鑰�',
+ `modified` datetime(0) NOT NULL COMMENT '淇敼鏃堕棿',
+ `modified_by` bigint(0) UNSIGNED NOT NULL COMMENT '淇敼鑰�',
+ `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '澶囨敞',
+ `is_deleted` tinyint(0) NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囪瘑',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '绯荤粺浠诲姟琛�' ROW_FORMAT = Dynamic;
+-- ----------------------------
+-- Records of tb_sys_job
+-- ----------------------------
+-- ----------------------------
+-- Table structure for tb_sys_job_log
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_sys_job_log`;
+CREATE TABLE `tb_sys_job_log` (
+ `id` bigint(0) UNSIGNED NOT NULL COMMENT '涓婚敭',
+ `job_id` bigint(0) UNSIGNED NOT NULL COMMENT '浠诲姟ID',
+ `job_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '浠诲姟鍚嶇О',
+ `job_params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '浠诲姟鍙傛暟',
+ `job_result` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鎵ц缁撴灉',
+ `error_info` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '閿欒淇℃伅',
+ `status` int(0) NOT NULL COMMENT '鎵ц鐘舵��',
+ `start_time` datetime(0) NOT NULL COMMENT '寮�濮嬫椂闂�',
+ `end_time` datetime(0) NOT NULL COMMENT '缁撴潫鏃堕棿',
+ `created` datetime(0) NOT NULL COMMENT '鍒涘缓鏃堕棿',
+ `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '澶囨敞',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '绯荤粺浠诲姟鏃ュ織' ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_sys_job_log
+-- ----------------------------
+
+-- ----------------------------
+-- Table structure for tb_sys_log
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_sys_log`;
+CREATE TABLE `tb_sys_log` (
+ `id` bigint(0) UNSIGNED NOT NULL,
+ `account_id` bigint(0) UNSIGNED NULL DEFAULT NULL COMMENT '鎿嶄綔浜�',
+ `action_name` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎿嶄綔鍚嶇О',
+ `action_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎿嶄綔鐨勭被鍨�',
+ `action_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎿嶄綔娑夊強鐨勭被',
+ `action_method` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎿嶄綔娑夊強鐨勬柟娉�',
+ `action_url` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎿嶄綔娑夊強鐨� URL 鍦板潃',
+ `action_ip` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '鎿嶄綔娑夊強鐨勭敤鎴� IP 鍦板潃',
+ `action_params` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鎿嶄綔璇锋眰鍙傛暟',
+ `action_body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '鎿嶄綔璇锋眰body',
+ `status` tinyint(0) NULL DEFAULT NULL COMMENT '鎿嶄綔鐘舵�� 1 鎴愬姛 9 澶辫触',
+ `created` datetime(0) NULL DEFAULT NULL COMMENT '鎿嶄綔鏃堕棿',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鎿嶄綔鏃ュ織琛�' ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_sys_log
+-- ----------------------------
+
+-- ----------------------------
+-- Table structure for tb_sys_menu
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_sys_menu`;
+CREATE TABLE `tb_sys_menu` (
+ `id` bigint(0) UNSIGNED NOT NULL COMMENT '涓婚敭',
+ `parent_id` bigint(0) UNSIGNED NOT NULL COMMENT '鐖惰彍鍗昳d',
+ `menu_type` int(0) NOT NULL COMMENT '鑿滃崟绫诲瀷',
+ `menu_title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鑿滃崟鏍囬',
+ `menu_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '鑿滃崟url',
+ `component` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '缁勪欢璺緞',
+ `menu_icon` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '鍥炬爣/鍥剧墖鍦板潃',
+ `is_show` int(0) NOT NULL DEFAULT 1 COMMENT '鏄惁鏄剧ず',
+ `permission_tag` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '鏉冮檺鏍囪瘑',
+ `sort_no` int(0) NULL DEFAULT 0 COMMENT '鎺掑簭',
+ `status` tinyint(0) NOT NULL DEFAULT 0 COMMENT '鏁版嵁鐘舵��',
+ `created` datetime(0) NOT NULL COMMENT '鍒涘缓鏃堕棿',
+ `created_by` bigint(0) UNSIGNED NOT NULL COMMENT '鍒涘缓鑰�',
+ `modified` datetime(0) NOT NULL COMMENT '淇敼鏃堕棿',
+ `modified_by` bigint(0) UNSIGNED NOT NULL COMMENT '淇敼鑰�',
+ `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '澶囨敞',
+ `is_deleted` tinyint(0) NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囪瘑',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鑿滃崟琛�' ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_sys_menu
+-- ----------------------------
INSERT INTO `tb_sys_menu` VALUES (258052082618335232, 0, 0, '绯荤粺绠＄悊', '', '', 'ControlOutlined', 1, '', 999, 0, '2025-03-14 15:07:51', 1, '2025-04-08 11:12:00', 1, '', 0);
INSERT INTO `tb_sys_menu` VALUES (258052774330368000, 258052082618335232, 0, '鐢ㄦ埛绠＄悊', '/sys/sysAccount', '', 'UserOutlined', 1, '', 0, 0, '2025-03-14 15:10:36', 1, '2025-03-14 15:10:36', 1, '', 0);
INSERT INTO `tb_sys_menu` VALUES (258075705244676096, 258052082618335232, 0, '瑙掕壊绠＄悊', '/sys/sysRole', '', 'FrownOutlined', 1, '', 11, 0, '2025-03-14 16:41:43', 1, '2025-03-14 16:41:43', 1, '', 0);
@@ -79,26 +968,100 @@
INSERT INTO `tb_sys_menu` VALUES (259169540360232960, 0, 0, 'AI鑳藉姏', '', '', NULL, 1, '', 21, 0, '2025-03-17 17:08:14', 1, '2025-03-17 17:08:14', 1, '', 0);
INSERT INTO `tb_sys_menu` VALUES (259169689438380032, 259169540360232960, 0, '澶фā鍨嬪晢搴�', '/ai/ollama', '', 'SlackSquareFilled', 1, '', 1111, 0, '2025-03-17 17:08:49', 1, '2025-04-08 12:24:03', 1, '', 0);
INSERT INTO `tb_sys_menu` VALUES (259169837824466944, 259169540360232960, 0, 'Bots', '/ai/bots', '', 'TwitchOutlined', 1, '', 11, 0, '2025-03-17 17:09:24', 1, '2025-03-17 17:09:24', 1, '', 0);
-INSERT INTO `tb_sys_menu` VALUES (259169982154661888, 259169540360232960, 0, '鎻掍欢', '/ai/plugin', '', 'RobotOutlined', 1, '', 21, 0, '2025-03-17 17:09:59', 1, '2025-04-25 11:23:15', 1, '', 0);
+INSERT INTO `tb_sys_menu` VALUES (259169982154661888, 259169540360232960, 0, '鎻掍欢', '/ai/plugin', '', 'RobotOutlined', 1, '', 21, 0, '2025-03-17 17:09:59', 1, '2025-04-30 16:19:11', 1, '', 0);
INSERT INTO `tb_sys_menu` VALUES (259170117110587392, 259169540360232960, 0, '宸ヤ綔娴�', '/ai/workflow', '', 'BranchesOutlined', 1, '', 31, 0, '2025-03-17 17:10:31', 1, '2025-03-17 17:10:31', 1, '', 0);
INSERT INTO `tb_sys_menu` VALUES (259170422338478080, 259169540360232960, 0, '鐭ヨ瘑搴�', '/ai/knowledge', '', 'ReadOutlined', 1, '', 51, 0, '2025-03-17 17:11:44', 1, '2025-03-17 17:11:44', 1, '', 0);
INSERT INTO `tb_sys_menu` VALUES (259170538264846336, 259169540360232960, 0, '澶фā鍨�', '/ai/llms', '', 'SlidersOutlined', 1, '', 61, 0, '2025-03-17 17:12:11', 1, '2025-04-14 10:49:05', 1, '', 0);
INSERT INTO `tb_sys_menu` VALUES (269220820365377536, 259170422338478080, 0, '鐭ヨ瘑搴�', '/ai/knowledge/document', '', 'ZhihuSquareFilled', 1, '', 1, 0, '2025-04-14 10:48:25', 1, '2025-04-14 10:50:19', 1, '', 1);
INSERT INTO `tb_sys_menu` VALUES (269221948243083264, 259170422338478080, 1, '鐭ヨ瘑搴�', '/ai/knowledge/Document', '', 'BookFilled', 1, '', 1, 0, '2025-04-14 10:52:54', 1, '2025-04-14 10:52:54', 1, '', 1);
-INSERT INTO `tb_sys_menu` VALUES (270761213536096256, 258052082618335232, 0, 'apiKey', '/sys/sysApiKey', '', 'PoundOutlined', 1, '', 22, 0, '2025-04-18 16:49:24', 1, '2025-04-30 14:55:15', 1, '', 0);
+INSERT INTO `tb_sys_menu` VALUES (270761213536096256, 259168688849412096, 0, 'apiKey', '/sys/sysApiKey', '', 'PoundOutlined', 1, '', 22, 0, '2025-04-18 16:49:24', 1, '2025-05-28 09:22:33', 1, '', 0);
+INSERT INTO `tb_sys_menu` VALUES (282254669269082112, 258052082618335232, 0, '瀹氭椂浠诲姟', '/sys/sysJob', '', 'ClockCircleOutlined', 1, '', 53, 0, '2025-05-20 10:00:17', 1, '2025-05-20 10:00:17', 1, '', 0);
+INSERT INTO `tb_sys_menu` VALUES (282635110523305984, 259169540360232960, 0, '鎻掍欢甯傚満', '/ai/plugin/market', '', 'DeploymentUnitOutlined', 1, '', 71, 0, '2025-05-21 11:12:01', 1, '2025-05-21 11:12:01', 1, '', 1);
+INSERT INTO `tb_sys_menu` VALUES (284467996239060992, 259168688849412096, 0, 'token', 'sys/sysToken', '', 'BarChartOutlined', 1, '', 31, 0, '2025-05-26 12:35:15', 1, '2025-05-28 09:23:15', 1, '', 0);
+-- ----------------------------
+-- Table structure for tb_sys_option
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_sys_option`;
+CREATE TABLE `tb_sys_option` (
+ `tenant_id` bigint(0) UNSIGNED NOT NULL COMMENT '绉熸埛ID',
+ `key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '閰嶇疆KEY',
+ `value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '閰嶇疆鍐呭',
+ INDEX `uni_key`(`tenant_id`, `key`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '绯荤粺閰嶇疆淇℃伅琛�' ROW_FORMAT = Dynamic;
+-- ----------------------------
+-- Records of tb_sys_option
+-- ----------------------------
+INSERT INTO `tb_sys_option` VALUES (1000000, 'model_of_chat', 'openai');
+INSERT INTO `tb_sys_option` VALUES (1000000, 'spark_ai_version', 'v3.5');
+-- ----------------------------
+-- Table structure for tb_sys_position
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_sys_position`;
+CREATE TABLE `tb_sys_position` (
+ `id` bigint(0) UNSIGNED NOT NULL COMMENT '涓婚敭',
+ `tenant_id` bigint(0) UNSIGNED NOT NULL COMMENT '绉熸埛ID',
+ `dept_id` bigint(0) UNSIGNED NOT NULL COMMENT '閮ㄩ棬ID',
+ `position_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '宀椾綅鍚嶇О',
+ `position_code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '宀椾綅缂栫爜',
+ `sort_no` int(0) NULL DEFAULT 0 COMMENT '鎺掑簭',
+ `status` tinyint(0) NOT NULL DEFAULT 0 COMMENT '鏁版嵁鐘舵��',
+ `created` datetime(0) NOT NULL COMMENT '鍒涘缓鏃堕棿',
+ `created_by` bigint(0) UNSIGNED NOT NULL COMMENT '鍒涘缓鑰�',
+ `modified` datetime(0) NOT NULL COMMENT '淇敼鏃堕棿',
+ `modified_by` bigint(0) UNSIGNED NOT NULL COMMENT '淇敼鑰�',
+ `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '澶囨敞',
+ `is_deleted` tinyint(0) NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囪瘑',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '鑱屼綅琛�' ROW_FORMAT = Dynamic;
+-- ----------------------------
+-- Records of tb_sys_position
+-- ----------------------------
+INSERT INTO `tb_sys_position` VALUES (259067270360543232, 1000000, 1, '鎬婚儴CTO', '', 0, 0, '2025-03-17 10:21:50', 1, '2025-05-19 14:55:53', 1, '', 0);
-INSERT INTO `tb_sys_position` VALUES (259067270360543232, 1000000, 1, '鎬婚儴CTO', '', 0, 1, '2025-03-17 10:21:50', 1, '2025-03-17 10:21:50', 1, '', 0);
+-- ----------------------------
+-- Table structure for tb_sys_role
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_sys_role`;
+CREATE TABLE `tb_sys_role` (
+ `id` bigint(0) UNSIGNED NOT NULL COMMENT '涓婚敭',
+ `tenant_id` bigint(0) UNSIGNED NOT NULL COMMENT '绉熸埛ID',
+ `role_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '瑙掕壊鍚嶇О',
+ `role_key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '瑙掕壊鏍囪瘑',
+ `status` tinyint(0) NOT NULL DEFAULT 0 COMMENT '鏁版嵁鐘舵��',
+ `created` datetime(0) NOT NULL COMMENT '鍒涘缓鏃堕棿',
+ `created_by` bigint(0) UNSIGNED NOT NULL COMMENT '鍒涘缓鑰�',
+ `modified` datetime(0) NOT NULL COMMENT '淇敼鏃堕棿',
+ `modified_by` bigint(0) UNSIGNED NOT NULL COMMENT '淇敼鑰�',
+ `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '澶囨敞',
+ `is_deleted` tinyint(0) NULL DEFAULT 0 COMMENT '鍒犻櫎鏍囪瘑',
+ PRIMARY KEY (`id`) USING BTREE,
+ UNIQUE INDEX `uni_tenant_role`(`tenant_id`, `role_key`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '绯荤粺瑙掕壊' ROW_FORMAT = Dynamic;
-
-
+-- ----------------------------
+-- Records of tb_sys_role
+-- ----------------------------
INSERT INTO `tb_sys_role` VALUES (1, 1000000, '瓒呯骇绠＄悊鍛�', 'super_admin', 1, '2025-03-14 14:52:37', 1, '2025-03-14 14:52:37', 1, '', 0);
+INSERT INTO `tb_sys_role` VALUES (281969673543282688, 1000000, '鏅�氱敤鎴�', 'user', 1, '2025-05-19 15:07:49', 1, '2025-05-19 15:07:49', 1, '', 0);
+-- ----------------------------
+-- Table structure for tb_sys_role_menu
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_sys_role_menu`;
+CREATE TABLE `tb_sys_role_menu` (
+ `id` bigint(0) UNSIGNED NOT NULL COMMENT '涓婚敭',
+ `role_id` bigint(0) UNSIGNED NOT NULL COMMENT '瑙掕壊ID',
+ `menu_id` bigint(0) UNSIGNED NOT NULL COMMENT '鑿滃崟ID',
+ PRIMARY KEY (`id`) USING BTREE
+) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '瑙掕壊-鑿滃崟琛�' ROW_FORMAT = Dynamic;
-
+-- ----------------------------
+-- Records of tb_sys_role_menu
+-- ----------------------------
INSERT INTO `tb_sys_role_menu` VALUES (259111372649250817, 1, 258052774330368000);
INSERT INTO `tb_sys_role_menu` VALUES (259111372649250818, 1, 258075705244676096);
INSERT INTO `tb_sys_role_menu` VALUES (259111372649250819, 1, 258075850434703360);
@@ -119,9 +1082,26 @@
INSERT INTO `tb_sys_role_menu` VALUES (259170422447529984, 1, 259170422338478080);
INSERT INTO `tb_sys_role_menu` VALUES (259170538378092544, 1, 259170538264846336);
INSERT INTO `tb_sys_role_menu` VALUES (270761213603205120, 1, 270761213536096256);
-
--- v1.0.3 data start --
-INSERT INTO `tb_sys_menu` VALUES (282254669269082112, 258052082618335232, 0, '瀹氭椂浠诲姟', '/sys/sysJob', '', 'ClockCircleOutlined', 1, '', 53, 0, '2025-05-20 10:00:17', 1, '2025-05-20 10:00:17', 1, '', 0);
INSERT INTO `tb_sys_role_menu` VALUES (282254669390716928, 1, 282254669269082112);
--- v1.0.3 data end --
+INSERT INTO `tb_sys_role_menu` VALUES (284467996348112896, 1, 284467996239060992);
+-- ----------------------------
+-- Table structure for tb_sys_token
+-- ----------------------------
+DROP TABLE IF EXISTS `tb_sys_token`;
+CREATE TABLE `tb_sys_token` (
+ `id` bigint(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
+ `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '鐢熸垚鐨� token 鍊�',
+ `user_id` bigint(0) NOT NULL COMMENT '鍏宠仈鐢ㄦ埛ID',
+ `expire_time` datetime(0) NOT NULL COMMENT '杩囨湡鏃堕棿',
+ `created_at` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) COMMENT '鍒涘缓鏃堕棿',
+ `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'Token 鎻忚堪锛堝彲閫夛級',
+ PRIMARY KEY (`id`) USING BTREE,
+ UNIQUE INDEX `uk_token`(`token`) USING BTREE
+) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'iframe 宓屽叆鐢� Token 琛�' ROW_FORMAT = Dynamic;
+
+-- ----------------------------
+-- Records of tb_sys_token
+-- ----------------------------
+
+SET FOREIGN_KEY_CHECKS = 1;
--
Gitblit v1.8.0