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/V20231124002_attach.sql | 5 ++--- 1 files changed, 2 insertions(+), 3 deletions(-) diff --git a/assess-admin/src/main/resources/db/migration/V20231124002_attach.sql b/assess-admin/src/main/resources/db/migration/V20231124002_attach.sql index b970e5c..bc2c532 100644 --- a/assess-admin/src/main/resources/db/migration/V20231124002_attach.sql +++ b/assess-admin/src/main/resources/db/migration/V20231124002_attach.sql @@ -2,16 +2,15 @@ -- ---------------------------- -- 系统上传文件表 -- ---------------------------- -drop table if exists `smart_assess`.`sys_attach`; CREATE TABLE `smart_assess`.`sys_attach` ( `id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件名称', `path` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件存放路径', `type` tinyint NOT NULL COMMENT '文件所属类型(1社保，2医保，3工资单)', `user_id` bigint NOT NULL COMMENT '用户id', -`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建人', +`create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, -`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新人', +`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `index_name`(`name`) USING BTREE -- Gitblit v1.9.2