| 123456789101112131415161718192021222324252627282930 |
- # /**
- # 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', '你好，朋友')
- # ;
|
