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/V20231205003_accessory_file.sql | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/assess-admin/src/main/resources/db/migration/V20231205003_accessory_file.sql b/assess-admin/src/main/resources/db/migration/V20231205003_accessory_file.sql index 34492ad..45364c2 100644 --- a/assess-admin/src/main/resources/db/migration/V20231205003_accessory_file.sql +++ b/assess-admin/src/main/resources/db/migration/V20231205003_accessory_file.sql @@ -2,12 +2,12 @@ -- ---------------------------- -- 评估文件上传记录表 -- ---------------------------- -drop table if exists `smart_assess`.`sys_accessory_file`; -CREATE TABLE `smart_assess`.`sys_accessory_file` ( +CREATE TABLE `smart_assess`.`ass_accessory_file` ( `id` bigint NOT NULL AUTO_INCREMENT, `file_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件名称', +`origin_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件原始名称', `path` varchar(70) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件存放路径', -`module_type` tinyint NOT NULL COMMENT '模块code', +`module_type` int NOT NULL COMMENT '模块code', `project_id` bigint NOT NULL COMMENT '项目id', `version` int NULL DEFAULT 0 COMMENT '乐观锁', `del_flag` tinyint NULL DEFAULT 0 COMMENT '删除标志(0正常，1删除，默认0)', -- Gitblit v1.9.2