2

liusuyi

2026-05-12 9b5c9db9189493fbc6db48f55a7b7311b2a3253c

1
2
3
4
5
6
7
8
CREATE TABLE `spring_ai_chat_memory` (
                                         `conversation_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '会话ID',
                                         `content` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '消息内容',
                                         `type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '消息类型: USER, ASSISTANT, SYSTEM, TOOL',
                                         `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '时间戳',
                                         KEY `idx_conversation_id` (`conversation_id`),
                                         KEY `idx_timestamp` (`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='AI聊天记忆表';