From 1e8ccfec6ebcf7787def13165d9932b0cccefc49 Mon Sep 17 00:00:00 2001 From: liding <756868258@qq.com> Date: 星期五, 20 六月 2025 14:34:45 +0800 Subject: [PATCH] 1.文件上传格式调整 2.表格调整 --- main-business/src/main/resources/db/migration/postgresql/V20250610161313__create_table_archive.sql | 26 +++++++++++++------------- 1 files changed, 13 insertions(+), 13 deletions(-) diff --git a/main-business/src/main/resources/db/migration/postgresql/V20250610161313__create_table_archive.sql b/main-business/src/main/resources/db/migration/postgresql/V20250610161313__create_table_archive.sql index 7cd894a..dba4929 100644 --- a/main-business/src/main/resources/db/migration/postgresql/V20250610161313__create_table_archive.sql +++ b/main-business/src/main/resources/db/migration/postgresql/V20250610161313__create_table_archive.sql @@ -1,21 +1,20 @@ -- 鍒涘缓妗ｆ琛� CREATE TABLE archive ( - id BIGSERIAL PRIMARY KEY, -- 涓婚敭ID锛岃嚜鍔ㄩ�掑 + id BIGSERIAL PRIMARY KEY, -- 涓婚敭ID + name VARCHAR(255) NOT NULL, -- 妗ｆ鍚嶇О + type VARCHAR(255) NOT NULL, -- 妗ｆ绫诲瀷锛屼緥濡傦細鍚堝悓銆佹姤鍛娿�佽瘉浠剁瓑 + status VARCHAR(50) NOT NULL, -- 妗ｆ鐘舵�侊紝渚嬪锛氭湁鏁堛�佽繃鏈熴�佷綔搴� - name VARCHAR(255) NOT NULL, -- 妗ｆ鍚嶇О - type VARCHAR(255) NOT NULL, -- 妗ｆ绫诲瀷锛堝锛氬悎鍚屻�佹姤鍛娿�佽瘉浠剁瓑锛� - status VARCHAR(50) NOT NULL, -- 鐘舵�侊紙濡傦細鏈夋晥銆佽繃鏈熴�佷綔搴燂級 - - deleted INT NOT NULL DEFAULT 0, -- 杞垹闄ゆ爣蹇楋細0=鏈垹闄わ紝1=宸插垹闄� - create_by VARCHAR(255), -- 鍒涘缓浜虹敤鎴峰悕 - create_time TIMESTAMP WITHOUT TIME ZONE, -- 鍒涘缓鏃堕棿锛岄粯璁ゅ綋鍓嶆椂闂� - update_by VARCHAR(255), -- 鏈�鍚庢洿鏂颁汉鐢ㄦ埛鍚� - update_time TIMESTAMP WITHOUT TIME ZONE -- 鏈�鍚庢洿鏂版椂闂达紝榛樿褰撳墠鏃堕棿-- 鐧昏鏃ユ湡 + deleted INTEGER DEFAULT 0 NOT NULL, -- 杞垹闄ゆ爣蹇楋紝0=鏈垹闄わ紝1=宸插垹闄� + create_by VARCHAR(255), -- 鍒涘缓璇ヨ褰曠殑鐢ㄦ埛 + create_time TIMESTAMP(6), -- 璁板綍鍒涘缓鏃堕棿锛岄粯璁ゅ綋鍓嶆椂闂� + update_by VARCHAR(255), -- 鏈�鍚庝慨鏀硅璁板綍鐨勭敤鎴� + update_time TIMESTAMP WITHOUT TIME ZONE DEFAULT CURRENT_TIMESTAMP, -- 鏈�鍚庢洿鏂版椂闂达紝榛樿褰撳墠鏃堕棿 + tree_id BIGINT -- 鏍戣妭鐐笽D ); --- 琛ㄦ敞閲� -COMMENT ON TABLE archive IS '妗ｆ淇℃伅琛紝璁板綍绯荤粺涓悇绫绘。妗堢殑鍩烘湰淇℃伅'; +COMMENT ON TABLE archive IS '妗ｆ淇℃伅琛�'; -- 瀛楁娉ㄩ噴 COMMENT ON COLUMN archive.id IS '涓婚敭ID'; @@ -26,4 +25,5 @@ COMMENT ON COLUMN archive.create_by IS '鍒涘缓璇ヨ褰曠殑鐢ㄦ埛'; COMMENT ON COLUMN archive.create_time IS '璁板綍鍒涘缓鏃堕棿'; COMMENT ON COLUMN archive.update_by IS '鏈�鍚庝慨鏀硅璁板綍鐨勭敤鎴�'; -COMMENT ON COLUMN archive.update_time IS '璁板綍鏈�鍚庢洿鏂版椂闂�'; \ No newline at end of file +COMMENT ON COLUMN archive.update_time IS '璁板綍鏈�鍚庢洿鏂版椂闂�'; +COMMENT ON COLUMN archive.tree_id IS '鏍戣妭鐐笽D'; \ No newline at end of file -- Gitblit v1.9.3