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/V20231206002_project_material.sql |    5 ++---
 1 files changed, 2 insertions(+), 3 deletions(-)

diff --git a/assess-admin/src/main/resources/db/migration/V20231206002_project_material.sql b/assess-admin/src/main/resources/db/migration/V20231206002_project_material.sql
index 7dff537..bfb3ea6 100644
--- a/assess-admin/src/main/resources/db/migration/V20231206002_project_material.sql
+++ b/assess-admin/src/main/resources/db/migration/V20231206002_project_material.sql
@@ -2,11 +2,10 @@
 -- ----------------------------
 -- 项目归档文件表
 -- ----------------------------
-drop table if exists `smart_assess`.`sys_project_material`;
-CREATE TABLE `smart_assess`.`sys_project_material`  (
+CREATE TABLE `smart_assess`.`ass_project_material`  (
 `id` bigint NOT NULL AUTO_INCREMENT,
 `name` varchar(50) NOT NULL COMMENT '名称',
-`type` tinyint NOT NULL COMMENT '类型',
+`type` tinyint NOT NULL DEFAULT 1 COMMENT '是否是文件，0否 1是 默认1',
 `project_id` bigint NOT NULL COMMENT '项目id',
 `file_id` bigint  NULL COMMENT '评估文件id',
 `version` int NULL DEFAULT 0 COMMENT '乐观锁',

--
Gitblit v1.9.2