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.表格调整 --- basic-server/src/main/resources/db/migration/postgresql/V20250606170900__create_table_coal_plan.sql | 21 +++++++++++---------- 1 files changed, 11 insertions(+), 10 deletions(-) diff --git a/basic-server/src/main/resources/db/migration/postgresql/V20250606170900__create_table_coal_plan.sql b/basic-server/src/main/resources/db/migration/postgresql/V20250606170900__create_table_coal_plan.sql index d339eec..2d4170c 100644 --- a/basic-server/src/main/resources/db/migration/postgresql/V20250606170900__create_table_coal_plan.sql +++ b/basic-server/src/main/resources/db/migration/postgresql/V20250606170900__create_table_coal_plan.sql @@ -1,17 +1,17 @@ -- 鍒涘缓鐓よ川淇℃伅琛� CREATE TABLE coal_plan ( - id BIGSERIAL PRIMARY KEY, -- 涓婚敭ID锛岃嚜鍔ㄩ�掑 + id BIGSERIAL PRIMARY KEY, -- 涓婚敭ID锛岃嚜鍔ㄩ�掑 + plan VARCHAR(255) NOT NULL, --鐓よ川鏂规 + field_ids VARCHAR(255) NOT NULL, --鐓よ川鏂规瀛楁id + coal_fields BIGINT NOT NULL, -- 鐓よ川鏂规瀛楁 + scheme_desc VARCHAR(255), -- 瀛楁鎻忚堪 - plan VARCHAR(255) NOT NULL, --鐓よ川鏂规 - field_ids VARCHAR(255) NOT NULL, --鐓よ川鏂规瀛楁id - coal_fields BIGINT 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 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 -- 鏈�鍚庢洿鏂版椂闂达紝榛樿褰撳墠鏃堕棿 ); -- 琛ㄦ敞閲� @@ -22,6 +22,7 @@ COMMENT ON COLUMN coal_plan.plan IS '鐓よ川鏂规'; COMMENT ON COLUMN coal_plan.coal_fields IS '鐓よ川鏂规瀛楁'; COMMENT ON COLUMN coal_plan.field_ids IS '鐓よ川鏂规瀛楁id'; +COMMENT ON COLUMN coal_plan.scheme_desc IS '瀛楁鎻忚堪'; COMMENT ON COLUMN coal_plan.deleted IS '杞垹闄ゆ爣蹇楋紝0=鏈垹闄わ紝1=宸插垹闄�'; COMMENT ON COLUMN coal_plan.create_by IS '鍒涘缓璇ヨ褰曠殑鐢ㄦ埛'; COMMENT ON COLUMN coal_plan.create_time IS '璁板綍鍒涘缓鏃堕棿'; -- Gitblit v1.9.3