/*
|
Navicat MySQL Data Transfer
|
|
Source Server : 129.211.24.7
|
Source Server Type : MySQL
|
Source Server Version : 50744
|
Source Host : 129.211.24.7:3306
|
Source Schema : ry-vue
|
|
Target Server Type : MySQL
|
Target Server Version : 50744
|
File Encoding : 65001
|
|
Date: 05/05/2025 15:01:08
|
*/
|
|
SET NAMES utf8mb4;
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
-- ----------------------------
|
-- Table structure for chat_session
|
-- ----------------------------
|
DROP TABLE IF EXISTS `chat_session`;
|
CREATE TABLE `chat_session` (
|
`id` bigint(20) NOT NULL COMMENT '主键',
|
`user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户id',
|
`session_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '会话标题',
|
`session_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '会话内容',
|
`create_dept` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门',
|
`create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者',
|
`create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
|
`update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者',
|
`update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
|
`remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '会话管理' ROW_FORMAT = Dynamic;
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
|
ALTER TABLE `chat_message`
|
ADD COLUMN `session_id` bigint(20) NULL COMMENT '会话id' AFTER `id`;
|
