# /** # Source Server Version: 8.0.31 # Source Database: backendsys # Date: 2023/05/23 17:09:22 # */ # # DROP TABLE IF EXISTS `ds_chat`; # CREATE TABLE `ds_chat` ( # PRIMARY KEY (`id`), # `id` BIGINT AUTO_INCREMENT COMMENT 'ID', # `model` VARCHAR(255) COMMENT '模型', # `history_code` VARCHAR(64) NOT NULL COMMENT '对话历史记录ID', # `user_id` BIGINT COMMENT '用户ID', # `user_nickname` VARCHAR(255) COMMENT '用户名', # `role` VARCHAR(255) COMMENT '对话角色 (user, assistant, system, tool)', # `content` VARCHAR(5000) NOT NULL COMMENT '对话内容', # `content_type` VARCHAR(255) NOT NULL COMMENT '对话内容类型 (THINK: 思考, REPLY: 回复)', # `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', # INDEX `idx_history_code` (`history_code`), # INDEX `idx_user_id` (`user_id`), # INDEX `idx_model` (`model`) # ) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='Deepseek对话表'; # # INSERT INTO ds_chat(model, history_code, user_id, user_nickname, role, content_type, content) VALUES # ('deepseek-reasoner', '5670822e-f0f7-4635-b766-c9c61edef0fa', 1, '超人', 'user', 'REPLY', '生成一条关于制作蛋糕的文案,适用于家用,用料是纯天然无添加剂,主打绿色健康美味的理念'), # ('deepseek-reasoner', '5670822e-f0f7-4635-b766-c9c61edef0fa', null, null, null, 'THINK', '让我想想用户说这段话的含义'), # ('deepseek-reasoner', '5670822e-f0f7-4635-b766-c9c61edef0fa', null, null, 'assistant', 'REPLY', '在家也能享受绿色健康美味!用纯天然无添加剂的食材,带给你和家人最纯净的美味。从选购新鲜食材到烘焙出炉,每一步都充满温馨与乐趣。让我们一起回归自然,享受绿色健康的蛋糕时光!'), # ('deepseek-chat', '4e69922c-f0e7-4f82-905d-0b375e094092', 1, '超人', 'user', 'REPLY', '你好'), # ('deepseek-chat', '4e69922c-f0e7-4f82-905d-0b375e094092', null, null, 'assistant', 'REPLY', '你好,朋友') # ;