From 5d2cfd4562f74496a5263db3451c1e78ff53aead Mon Sep 17 00:00:00 2001
From: heheng <475597332@qq.com>
Date: 星期四, 27 三月 2025 08:44:16 +0800
Subject: [PATCH] 单据增加查询返回字段

---
 assess-admin/src/main/resources/db/migration/V20231123006_notice.sql |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/assess-admin/src/main/resources/db/migration/V20231123006_notice.sql b/assess-admin/src/main/resources/db/migration/V20231123006_notice.sql
index 67711f2..02c6daf 100644
--- a/assess-admin/src/main/resources/db/migration/V20231123006_notice.sql
+++ b/assess-admin/src/main/resources/db/migration/V20231123006_notice.sql
@@ -2,12 +2,12 @@
 -- ----------------------------
 -- 系统通知表
 -- ----------------------------
-drop table if exists `smart_assess`.`sys_notice`;
 CREATE TABLE `smart_assess`.`sys_notice`  (
 `id` bigint NOT NULL AUTO_INCREMENT,
 `title` varchar(50) NOT NULL COMMENT '通知标题',
-`content` text NULL COMMENT '通知内容',
+`content` mediumtext NULL COMMENT '通知内容',
 `status` tinyint(2) NULL DEFAULT 0 COMMENT '通知状态(0正常，1关闭 默认0)',
+`version` int NULL DEFAULT 0 COMMENT '乐观锁',
 `create_by` varchar(20) NULL COMMENT '创建人',
 `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 `update_by` varchar(20) NULL COMMENT '更新人',

--
Gitblit v1.9.2