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_add_ai_config_menu.sql | 46 ++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 46 insertions(+), 0 deletions(-)
diff --git a/src/main/resources/sql/20260303_add_ai_config_menu.sql b/src/main/resources/sql/20260303_add_ai_config_menu.sql
new file mode 100644
index 0000000..58c9a97
--- /dev/null
+++ b/src/main/resources/sql/20260303_add_ai_config_menu.sql
@@ -0,0 +1,46 @@
+-- 灏� AI閰嶇疆 鑿滃崟鎸傝浇鍒帮細寮�鍙戜笓鐢� -> AI閰嶇疆
+-- 璇存槑锛氭湰绯荤粺鑿滃崟鏉ユ簮浜� sys_resource锛屾墽琛屾湰鑴氭湰鍚庤鍦ㄢ�滆鑹叉巿鏉冣�濋噷缁欏搴旇鑹插嬀閫夋柊鑿滃崟銆�
+
+-- 1) 瀹氫綅鈥滃紑鍙戜笓鐢ㄢ�濅竴绾ц彍鍗�
+SET @dev_parent_id := (
+ SELECT id
+ FROM sys_resource
+ WHERE name = '寮�鍙戜笓鐢�' AND level = 1
+ ORDER BY id
+ LIMIT 1
+);
+
+-- 2) 鏂板浜岀骇鑿滃崟锛欰I閰嶇疆锛堥〉闈級
+INSERT INTO sys_resource(code, name, resource_id, level, sort, status)
+SELECT 'ai/llm_config.html', 'AI閰嶇疆', @dev_parent_id, 2, 999, 1
+FROM dual
+WHERE @dev_parent_id IS NOT NULL
+ AND NOT EXISTS (
+ SELECT 1
+ FROM sys_resource
+ WHERE code = 'ai/llm_config.html' AND level = 2
+ );
+
+-- 3) 鏂板涓夌骇鎸夐挳鏉冮檺锛氭煡鐪嬶紙鐢ㄤ簬瑙掕壊缁嗙矑搴︽巿鏉冿級
+SET @ai_cfg_id := (
+ SELECT id
+ FROM sys_resource
+ WHERE code = 'ai/llm_config.html' AND level = 2
+ ORDER BY id
+ LIMIT 1
+);
+
+INSERT INTO sys_resource(code, name, resource_id, level, sort, status)
+SELECT 'ai/llm_config.html#view', '鏌ョ湅', @ai_cfg_id, 3, 1, 1
+FROM dual
+WHERE @ai_cfg_id IS NOT NULL
+ AND NOT EXISTS (
+ SELECT 1
+ FROM sys_resource
+ WHERE code = 'ai/llm_config.html#view' AND level = 3
+ );
+
+-- 鍙�夋鏌�
+SELECT id, code, name, resource_id, level, sort, status
+FROM sys_resource
+WHERE code IN ('ai/llm_config.html', 'ai/llm_config.html#view');
--
Gitblit v1.9.1