From e7afed8cdb301a311dbad5ed23c7ff9f826b2c48 Mon Sep 17 00:00:00 2001 From: kongzy <kongzy> Date: 星期三, 30 十月 2024 11:11:06 +0800 Subject: [PATCH] update import --- assess-admin/src/main/resources/db/migration/V20231123006_notice.sql | 10 +++++----- 1 files changed, 5 insertions(+), 5 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 1272c78..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,16 +2,16 @@ -- ---------------------------- -- 系统通知表 -- ---------------------------- -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` varchar(2000) NULL DEFAULT '' COMMENT '通知内容', +`content` mediumtext NULL COMMENT '通知内容', `status` tinyint(2) NULL DEFAULT 0 COMMENT '通知状态(0正常，1关闭 默认0)', -`create_by` varchar(20) NULL DEFAULT '' COMMENT '创建人', +`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 DEFAULT '' COMMENT '更新人', +`update_by` varchar(20) NULL COMMENT '更新人', `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', -`remark` varchar(100) NULL DEFAULT '' COMMENT '备注', +`remark` varchar(100) NULL COMMENT '备注', PRIMARY KEY (`id`) )ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '通知表' ROW_FORMAT = Dynamic; -- Gitblit v1.9.2