From 5d2cfd4562f74496a5263db3451c1e78ff53aead Mon Sep 17 00:00:00 2001 From: heheng <475597332@qq.com> Date: 星期四, 27 三月 2025 08:44:16 +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