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聊天记忆表';
|
