From 983bdb5b89932b38d08a11ad1eed6ea89d1597e1 Mon Sep 17 00:00:00 2001
From: kongzy <kongzy>
Date: 星期一, 29 一月 2024 10:07:31 +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