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/V20250603102701__create_table_coal_info.sql | 5 ++--- 1 files changed, 2 insertions(+), 3 deletions(-) diff --git a/basic-server/src/main/resources/db/migration/postgresql/V20250603102701__create_table_coal_info.sql b/basic-server/src/main/resources/db/migration/postgresql/V20250603102701__create_table_coal_info.sql index a59dcd0..fa5fdf7 100644 --- a/basic-server/src/main/resources/db/migration/postgresql/V20250603102701__create_table_coal_info.sql +++ b/basic-server/src/main/resources/db/migration/postgresql/V20250603102701__create_table_coal_info.sql @@ -6,12 +6,11 @@ maintainer_id int4 NOT NULL DEFAULT 0, -- 缁存姢浜猴紝涓嶅厑璁镐负绌� maintenance_date DATE NOT NULL, -- 缁存姢鏃ユ湡锛屼笉鍏佽涓虹┖ - -- 鏂板瀛楁 deleted int4 NOT NULL DEFAULT 0, -- 鏄惁鍒犻櫎锛堣蒋鍒犻櫎鏍囧織锛� create_by VARCHAR(255), -- 鍒涘缓浜� - create_time TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP, -- 鍒涘缓鏃堕棿锛岄粯璁ゅ綋鍓嶆椂闂� + create_time TIMESTAMP WITHOUT TIME ZONE, -- 鍒涘缓鏃堕棿锛岄粯璁ゅ綋鍓嶆椂闂� update_by VARCHAR(255), -- 鏈�鍚庢洿鏂颁汉 - update_time TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP -- 鏈�鍚庢洿鏂版椂闂达紝榛樿褰撳墠鏃堕棿 + update_time TIMESTAMP WITHOUT TIME ZONE -- 鏈�鍚庢洿鏂版椂闂达紝榛樿褰撳墠鏃堕棿 ); -- 涓鸿〃娣诲姞娉ㄩ噴 -- Gitblit v1.9.3