From c0cf736ff001bbaec59b7da6239f4670464952fd Mon Sep 17 00:00:00 2001 From: liding <756868258@qq.com> Date: 星期四, 12 六月 2025 16:32:05 +0800 Subject: [PATCH] 1.销售模块 2.时区优化 --- basic-server/src/main/resources/db/migration/postgresql/V20250606171000__create_table_coal_value.sql | 22 ++++++++++++---------- 1 files changed, 12 insertions(+), 10 deletions(-) diff --git a/basic-server/src/main/resources/db/migration/postgresql/V20250606171000__create_table_coal_value.sql b/basic-server/src/main/resources/db/migration/postgresql/V20250606171000__create_table_coal_value.sql index 59d6491..16355ac 100644 --- a/basic-server/src/main/resources/db/migration/postgresql/V20250606171000__create_table_coal_value.sql +++ b/basic-server/src/main/resources/db/migration/postgresql/V20250606171000__create_table_coal_value.sql @@ -1,18 +1,19 @@ -- 鍒涘缓鐓よ川淇℃伅琛� CREATE TABLE coal_value ( - id BIGSERIAL PRIMARY KEY, -- 涓婚敭ID锛岃嚜鍔ㄩ�掑 + id BIGSERIAL PRIMARY KEY, -- 涓婚敭ID锛岃嚜鍔ㄩ�掑 - plan_id VARCHAR(255) NOT NULL, --鍏宠仈鐓よ川鏂规涓婚敭ID - coal_value VARCHAR(255) NOT NULL, -- 瀛楁鍊� - fields VARCHAR(255) NOT NULL, -- 瀛楁 - field_name VARCHAR(255) NOT NULL, -- 瀛楁鍚� + plan_id VARCHAR(255) NOT NULL, --鍏宠仈鐓よ川鏂规涓婚敭ID + coal_value VARCHAR(255) NOT NULL, -- 瀛楁鍊� + fields VARCHAR(255) NOT NULL, -- 瀛楁 + field_name VARCHAR(255) NOT NULL, -- 瀛楁鍚� + type VARCHAR(255) NOT NULL, -- 1 閲囪喘/ 2 姝ｅ紡 鍏ュ簱 - deleted INT NOT NULL DEFAULT 0, -- 杞垹闄ゆ爣蹇楋細0=鏈垹闄わ紝1=宸插垹闄� - create_by VARCHAR(255), -- 鍒涘缓浜虹敤鎴峰悕 - create_time TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP, -- 鍒涘缓鏃堕棿锛岄粯璁ゅ綋鍓嶆椂闂� - update_by VARCHAR(255), -- 鏈�鍚庢洿鏂颁汉鐢ㄦ埛鍚� - update_time TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP -- 鏈�鍚庢洿鏂版椂闂达紝榛樿褰撳墠鏃堕棿 + 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 -- 鏈�鍚庢洿鏂版椂闂达紝榛樿褰撳墠鏃堕棿 ); -- 琛ㄦ敞閲� @@ -24,6 +25,7 @@ COMMENT ON COLUMN coal_value.coal_value IS '瀛楁鍊�'; COMMENT ON COLUMN coal_value.fields IS '瀛楁'; COMMENT ON COLUMN coal_value.field_name IS '瀛楁鍚�'; +COMMENT ON COLUMN coal_value.type IS '1 閲囪喘/ 2 姝ｅ紡 鍏ュ簱'; COMMENT ON COLUMN coal_value.deleted IS '杞垹闄ゆ爣蹇楋紝0=鏈垹闄わ紝1=宸插垹闄�'; COMMENT ON COLUMN coal_value.create_by IS '鍒涘缓璇ヨ褰曠殑鐢ㄦ埛'; COMMENT ON COLUMN coal_value.create_time IS '璁板綍鍒涘缓鏃堕棿'; -- Gitblit v1.9.3