/*
 Navicat Premium Data Transfer

 Source Server         : li
 Source Server Type    : MySQL
 Source Server Version : 80036 (8.0.36)
 Source Host           : localhost:3306
 Source Schema         : chatai

 Target Server Type    : MySQL
 Target Server Version : 80036 (8.0.36)
 File Encoding         : 65001

 Date: 16/09/2024 22:46:35
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for chat
-- ----------------------------
DROP TABLE IF EXISTS `chat`;
CREATE TABLE `chat`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `userID` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `date` date NULL DEFAULT NULL,
  `time_add` datetime NULL DEFAULT NULL,
  `time_update` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 37 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chat
-- ----------------------------
INSERT INTO `chat` VALUES (1, 1, '第一次对话', '2024-09-14', '2024-09-14 16:57:50', '2024-09-14 16:57:50');
INSERT INTO `chat` VALUES (2, 2, '第二次对话', '2024-09-14', '2024-09-14 16:57:50', '2024-09-14 16:57:50');
INSERT INTO `chat` VALUES (25, 1, '新对话222', '2024-09-15', NULL, NULL);

-- ----------------------------
-- Table structure for chat_detail
-- ----------------------------
DROP TABLE IF EXISTS `chat_detail`;
CREATE TABLE `chat_detail`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `chatID` int NOT NULL,
  `role` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
  `time_add` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `chat_id`(`chatID` ASC) USING BTREE,
  CONSTRAINT `chat_detail_ibfk_1` FOREIGN KEY (`chatID`) REFERENCES `chat` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 96 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chat_detail
-- ----------------------------
INSERT INTO `chat_detail` VALUES (1, 1, 'user', '你好，今天的天气怎么样？', '2024-09-14 16:58:01');
INSERT INTO `chat_detail` VALUES (2, 1, 'system', '天气很好，阳光明媚。', '2024-09-14 16:58:01');
INSERT INTO `chat_detail` VALUES (3, 2, 'user', '我今天有什么计划？', '2024-09-14 16:58:01');
INSERT INTO `chat_detail` VALUES (4, 2, 'system', '你今天的计划是完成项目报告。', '2024-09-14 16:58:01');
INSERT INTO `chat_detail` VALUES (74, 25, 'user', '心情不好', NULL);
INSERT INTO `chat_detail` VALUES (75, 25, 'system', '心情不好的时候确实会让人感到有些低落和压抑，愿意和我多说一说为什么心情不好吗？是因为最近发生了什么特别的事情，还是积累的压力一时间涌了上来？', NULL);
INSERT INTO `chat_detail` VALUES (76, 25, 'user', '下雨了', NULL);
INSERT INTO `chat_detail` VALUES (77, 25, 'system', '下雨的时候，世界会变得湿漉漉的，空气中弥漫着清新的气息。你是因为下雨感到欣喜，还是给你的出行带来了不便呢？', NULL);
INSERT INTO `chat_detail` VALUES (78, 25, 'user', '不能出去玩', NULL);
INSERT INTO `chat_detail` VALUES (79, 25, 'system', '不能出去玩确实会让人感到有些失落呢，能和我多说一说为什么不能出去玩吗？ 是因为天气不好、工作/学习任务繁重，还是其他的原因？', NULL);
INSERT INTO `chat_detail` VALUES (80, 1, 'user', '我很生气', NULL);
INSERT INTO `chat_detail` VALUES (81, 1, 'system', '哎呀，别气别气，能和我说说为啥这么生气吗？', NULL);
INSERT INTO `chat_detail` VALUES (82, 25, 'user', '怎么办，失眠了', NULL);
INSERT INTO `chat_detail` VALUES (83, 25, 'system', '失眠确实不好受，别着急，咱们可以试试下面这些方法来改善：\n1. 放松身心：做一些缓慢的深呼吸，或者冥想，让身体和思维都平静下来。\n2. 调整环境：保持卧室安静、黑暗和凉爽，合适的环境有助于睡眠。\n3. 避免使用电子设备：手机、电脑等发出的蓝光会干扰睡眠，尽量不要在睡前使用。\n4. 喝一杯温牛奶：有助于放松身体，促进睡眠。\n5. 泡个热水澡：让身体肌肉放松，缓解紧张情绪。\n6. 听轻柔的音乐：比如一些舒缓的古典音乐或者自然声音，如雨声、海浪声。\n7. 阅读枯燥的书籍：如果躺着睡不着，可以坐起来看一本不太感兴趣或者比较枯燥的书，可能会让你产生困意。\n8. 适度运动：但不要在临近睡觉的时候进行剧烈运动，可以在白天适当锻炼。\n\n你可以想想是不是最近有什么事情让你压力太大或者情绪波动，导致失眠的呢？', NULL);
INSERT INTO `chat_detail` VALUES (84, 1, 'user', '怎么办', NULL);
INSERT INTO `chat_detail` VALUES (85, 1, 'system', '不太清楚您说“怎么办”具体指的是什么情况呀，能跟我多说一说，让我更明白您的困扰吗？ ', NULL);
INSERT INTO `chat_detail` VALUES (86, 25, 'user', '今天天气很好', NULL);
INSERT INTO `chat_detail` VALUES (87, 25, 'system', '那真是太棒啦，好天气往往能带来好心情，很适合出门走走，享受阳光和清新的空气，你有没有什么特别的计划来度过这美好的一天呢？', NULL);
INSERT INTO `chat_detail` VALUES (88, 25, 'user', '但是我还是不开心', NULL);
INSERT INTO `chat_detail` VALUES (89, 25, 'system', '不开心肯定是有原因的，愿意和我多说一说为什么会这样吗？', NULL);

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `account` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `account`(`account` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'zh', '123', '123');
INSERT INTO `user` VALUES (2, 'li', '1234', '1234');
INSERT INTO `user` VALUES (3, 'lisa', '12345', '12345');

SET FOREIGN_KEY_CHECKS = 1;