From 9a8a4a431c61d22a334003b2e8a52571ea809920 Mon Sep 17 00:00:00 2001 From: heheng <475597332@qq.com> Date: 星期一, 24 三月 2025 13:15:34 +0800 Subject: [PATCH] 增加业务类别 --- assess-admin/src/main/resources/db/migration/V20231204003_estimate_schedule.sql | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/assess-admin/src/main/resources/db/migration/V20231204003_estimate_schedule.sql b/assess-admin/src/main/resources/db/migration/V20231204003_estimate_schedule.sql index 0dff831..eae0c54 100644 --- a/assess-admin/src/main/resources/db/migration/V20231204003_estimate_schedule.sql +++ b/assess-admin/src/main/resources/db/migration/V20231204003_estimate_schedule.sql @@ -2,7 +2,6 @@ -- ---------------------------- -- 评价日程安排表 -- ---------------------------- -drop table if exists `smart_assess`.`ass_estimate_schedule`; CREATE TABLE `smart_assess`.`ass_estimate_schedule` ( `id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL COMMENT '日程名称', @@ -10,6 +9,7 @@ `start_date` datetime NOT NULL COMMENT '开始时间', `end_date` datetime NOT NULL COMMENT '结束时间', `project_id` bigint NOT NULL COMMENT '项目id', +`sort` int NULL DEFAULT 0 COMMENT '序号', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志(0正常,1删除,默认0)', `version` int NULL DEFAULT 0 COMMENT '乐观锁', `create_by` varchar(20) NULL COMMENT '创建人', -- Gitblit v1.9.2