__ds_chat_history.sql 1.1 KB

1234567891011121314151617181920212223
  1. # /**
  2. # Source Server Version: 8.0.31
  3. # Source Database: backendsys
  4. # Date: 2023/05/23 17:09:22
  5. # */
  6. #
  7. # DROP TABLE IF EXISTS `ds_chat_history`;
  8. # CREATE TABLE `ds_chat_history` (
  9. # PRIMARY KEY (`id`),
  10. # `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
  11. # `history_code` VARCHAR(36) NOT NULL COMMENT '对话历史记录ID',
  12. # `user_id` BIGINT NOT NULL COMMENT '用户ID',
  13. # `last_content` VARCHAR(255) NOT NULL COMMENT '最后一次的对话内容',
  14. # `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  15. # `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  16. # INDEX `idx_user_id` (`user_id`)
  17. # ) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='Deepseek对话历史记录表';
  18. #
  19. # INSERT INTO ds_chat_history(history_code, user_id, last_content) VALUES
  20. # ('5670822e-f0f7-4635-b766-c9c61edef0fa', 1, '生成一条关于制作蛋糕的文案,适用于家用,用料是纯天然无添加剂,主打绿色健康美味的理念'),
  21. # ('3e69922c-f0e7-4f82-905d-0b375e09409c', 1, '你好'),
  22. # ('bd55b4e6-9a4b-4904-99cc-b474bc0a86e4', 2, 'Hello')
  23. # ;