From 5e492e5d5a2b743e2e99443220d343f72a633f6d Mon Sep 17 00:00:00 2001
From: Junjie <fallin.jie@qq.com>
Date: 星期二, 03 三月 2026 16:57:52 +0800
Subject: [PATCH] #
---
src/main/resources/sql/20260303_create_sys_llm_route.sql | 32 ++++++++++++++++++++++++++++++++
1 files changed, 32 insertions(+), 0 deletions(-)
diff --git a/src/main/resources/sql/20260303_create_sys_llm_route.sql b/src/main/resources/sql/20260303_create_sys_llm_route.sql
new file mode 100644
index 0000000..47d67ff
--- /dev/null
+++ b/src/main/resources/sql/20260303_create_sys_llm_route.sql
@@ -0,0 +1,32 @@
+CREATE TABLE IF NOT EXISTS `sys_llm_route` (
+ `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
+ `name` VARCHAR(64) NOT NULL COMMENT '璺敱鍚嶇О',
+ `base_url` VARCHAR(255) DEFAULT NULL COMMENT 'LLM API Base URL',
+ `api_key` VARCHAR(512) DEFAULT NULL COMMENT 'API Key',
+ `model` VARCHAR(128) DEFAULT NULL COMMENT '妯″瀷鍚�',
+ `thinking` TINYINT NOT NULL DEFAULT 0 COMMENT '鏄惁寮�鍚繁搴︽�濊��:1鏄�0鍚�',
+ `priority` INT NOT NULL DEFAULT 100 COMMENT '浼樺厛绾�(瓒婂皬瓒婁紭鍏�)',
+ `status` TINYINT NOT NULL DEFAULT 1 COMMENT '鐘舵��:1鍚敤0绂佺敤',
+ `switch_on_quota` TINYINT NOT NULL DEFAULT 1 COMMENT '棰濆害鑰楀敖鏃舵槸鍚﹀垏鎹�',
+ `switch_on_error` TINYINT NOT NULL DEFAULT 1 COMMENT '鏁呴殰鏃舵槸鍚﹀垏鎹�',
+ `cooldown_seconds` INT NOT NULL DEFAULT 300 COMMENT '鏁呴殰鍚庡喎鍗寸鏁�',
+ `cooldown_until` DATETIME DEFAULT NULL COMMENT '鍐峰嵈鎴鏃堕棿',
+ `fail_count` INT NOT NULL DEFAULT 0 COMMENT '鎬诲け璐ユ鏁�',
+ `success_count` INT NOT NULL DEFAULT 0 COMMENT '鎬绘垚鍔熸鏁�',
+ `consecutive_fail_count` INT NOT NULL DEFAULT 0 COMMENT '杩炵画澶辫触娆℃暟',
+ `last_error` VARCHAR(512) DEFAULT NULL COMMENT '鏈�杩戦敊璇憳瑕�',
+ `last_used_time` DATETIME DEFAULT NULL COMMENT '鏈�杩戞垚鍔熻皟鐢ㄦ椂闂�',
+ `last_fail_time` DATETIME DEFAULT NULL COMMENT '鏈�杩戝け璐ユ椂闂�',
+ `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+ `memo` VARCHAR(255) DEFAULT NULL COMMENT '澶囨敞',
+ PRIMARY KEY (`id`),
+ KEY `idx_sys_llm_route_status_priority` (`status`, `priority`),
+ KEY `idx_sys_llm_route_cooldown` (`cooldown_until`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='LLM 璺敱閰嶇疆(澶欰PI/澶氭ā鍨�/澶欿ey鑷姩鍒囨崲)';
+
+-- 绀轰緥鏁版嵁锛堟寜闇�淇敼鍚庢墽琛岋級
+-- INSERT INTO sys_llm_route(name, base_url, api_key, model, thinking, priority, status, switch_on_quota, switch_on_error, cooldown_seconds)
+-- VALUES ('涓昏矾鐢�-gpt5', 'https://api.xiaomimimo.com/v1', 'sk-xxxx', 'gpt-5', 1, 10, 1, 1, 1, 300);
+-- INSERT INTO sys_llm_route(name, base_url, api_key, model, thinking, priority, status, switch_on_quota, switch_on_error, cooldown_seconds)
+-- VALUES ('澶囪矾鐢�-mimo', 'https://api.xiaomimimo.com/v1', 'sk-yyyy', 'mimo-v2-flash', 0, 20, 1, 1, 1, 300);
--
Gitblit v1.9.1