From 5e40dee0e0a4e4cff4a1aafca2444f61c39cbf32 Mon Sep 17 00:00:00 2001
From: zhou zhou <3272660260@qq.com>
Date: 星期四, 19 三月 2026 11:17:14 +0800
Subject: [PATCH] #AI.会话能力增强

---
 version/db/ai_feature.sql |   17 +++++++++++++++++
 1 files changed, 17 insertions(+), 0 deletions(-)

diff --git a/version/db/ai_feature.sql b/version/db/ai_feature.sql
index d5cd06f..529ea30 100644
--- a/version/db/ai_feature.sql
+++ b/version/db/ai_feature.sql
@@ -76,6 +76,7 @@
   `user_id` bigint(20) NOT NULL COMMENT '鐢ㄦ埛 ID',
   `tenant_id` bigint(20) DEFAULT NULL COMMENT '绉熸埛',
   `last_message_time` datetime DEFAULT NULL COMMENT '鏈�鍚庢秷鎭椂闂�',
+  `pinned` tinyint(1) DEFAULT '0' COMMENT '鏄惁缃《',
   `status` int(11) DEFAULT '1' COMMENT '鐘舵��',
   `deleted` int(11) DEFAULT '0' COMMENT '鍒犻櫎鏍囪',
   `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿',
@@ -117,6 +118,22 @@
 EXECUTE builtin_code_stmt;
 DEALLOCATE PREPARE builtin_code_stmt;
 
+SET @chat_session_pinned_exists := (
+  SELECT COUNT(1)
+  FROM `information_schema`.`COLUMNS`
+  WHERE `TABLE_SCHEMA` = DATABASE()
+    AND `TABLE_NAME` = 'sys_ai_chat_session'
+    AND `COLUMN_NAME` = 'pinned'
+);
+SET @chat_session_pinned_sql := IF(
+  @chat_session_pinned_exists = 0,
+  'ALTER TABLE `sys_ai_chat_session` ADD COLUMN `pinned` tinyint(1) DEFAULT ''0'' COMMENT ''鏄惁缃《'' AFTER `last_message_time`',
+  'SELECT 1'
+);
+PREPARE chat_session_pinned_stmt FROM @chat_session_pinned_sql;
+EXECUTE chat_session_pinned_stmt;
+DEALLOCATE PREPARE chat_session_pinned_stmt;
+
 BEGIN;
 INSERT INTO `sys_ai_prompt`
 (`id`, `name`, `code`, `scene`, `system_prompt`, `user_prompt_template`, `tenant_id`, `status`, `deleted`, `create_time`, `create_by`, `update_time`, `update_by`, `memo`)

--
Gitblit v1.9.1