From 40e4ce58f634598fafd205dfe54cb90e8b63b6f2 Mon Sep 17 00:00:00 2001 From: liding <756868258@qq.com> Date: 星期五, 20 六月 2025 17:30:15 +0800 Subject: [PATCH] 生产加工 --- basic-server/src/main/resources/db/migration/postgresql/V20250606163300__create_table_coal_field.sql | 18 +++++++++--------- 1 files changed, 9 insertions(+), 9 deletions(-) diff --git a/basic-server/src/main/resources/db/migration/postgresql/V20250606163300__create_table_coal_field.sql b/basic-server/src/main/resources/db/migration/postgresql/V20250606163300__create_table_coal_field.sql index 8e04bea..0380e56 100644 --- a/basic-server/src/main/resources/db/migration/postgresql/V20250606163300__create_table_coal_field.sql +++ b/basic-server/src/main/resources/db/migration/postgresql/V20250606163300__create_table_coal_field.sql @@ -1,16 +1,16 @@ -- 鍒涘缓鐓よ川淇℃伅琛� CREATE TABLE coal_field ( - id BIGSERIAL PRIMARY KEY, -- 涓婚敭ID锛岃嚜鍔ㄩ�掑 - fields VARCHAR(255) NOT NULL, --鐓よ川瀛楁 - field_name VARCHAR(255) NOT NULL, -- 鐓よ川鎻忚堪 - field_description VARCHAR(255) NOT NULL, -- 鐓よ川鎻忚堪 + id BIGSERIAL PRIMARY KEY, -- 涓婚敭ID锛岃嚜鍔ㄩ�掑 + fields VARCHAR(255) NOT NULL, --鐓よ川瀛楁 + field_name VARCHAR(255) NOT NULL, -- 鐓よ川鎻忚堪 + field_description VARCHAR(255), -- 鐓よ川鎻忚堪 - 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 -- 鏈�鍚庢洿鏂版椂闂达紝榛樿褰撳墠鏃堕棿 ); -- 琛ㄦ敞閲� -- Gitblit v1.9.3