From a2a1f2a22db7c2e53275359fb5f8d6c0dd15d8d6 Mon Sep 17 00:00:00 2001 From: kongzy <kongzy> Date: 星期五, 09 八月 2024 16:25:58 +0800 Subject: [PATCH] update --- 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