From 936e157e4a36642fdbe9206a9309b2de060db7e3 Mon Sep 17 00:00:00 2001 From: ageer <ageerle@163.com> Date: 星期一, 05 五月 2025 15:02:57 +0800 Subject: [PATCH] feat: sql脚本 --- script/sql/update/20250407.sql | 0 script/sql/update/20250505.sql | 38 ++++++++++++++++++++++++++++++++++++++ 2 files changed, 38 insertions(+), 0 deletions(-) diff --git a/script/sql/update/updatdata20250407.sql b/script/sql/update/20250407.sql similarity index 100% rename from script/sql/update/updatdata20250407.sql rename to script/sql/update/20250407.sql diff --git a/script/sql/update/20250505.sql b/script/sql/update/20250505.sql new file mode 100644 index 0000000..0417c11 --- /dev/null +++ b/script/sql/update/20250505.sql @@ -0,0 +1,38 @@ +/* + 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; -- Gitblit v1.9.3