From bd9cf1a87d50cc7cb29118cc85f397a7ab7228e9 Mon Sep 17 00:00:00 2001
From: heheng <heheng@123456>
Date: 星期一, 16 十二月 2024 16:51:01 +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