From 0bf868d3cdf9226e178c076d3b588ed5207409a0 Mon Sep 17 00:00:00 2001
From: kongzy <kongzy>
Date: 星期五, 24 十一月 2023 17:51:40 +0800
Subject: [PATCH] merge

---
 assess-admin/src/main/resources/db/migration/V20231124002_attach.sql |   18 ++++++++++++++++++
 1 files changed, 18 insertions(+), 0 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
new file mode 100644
index 0000000..b970e5c
--- /dev/null
+++ b/assess-admin/src/main/resources/db/migration/V20231124002_attach.sql
@@ -0,0 +1,18 @@
+
+-- ----------------------------
+-- 系统上传文件表
+-- ----------------------------
+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_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
+`update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' 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
+) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统上传文件表' ROW_FORMAT = DYNAMIC;
\ No newline at end of file

--
Gitblit v1.9.2