From 92d4fac0b58498efc6be7764f00364535beb3d71 Mon Sep 17 00:00:00 2001 From: liding <756868258@qq.com> Date: 星期二, 08 七月 2025 18:02:00 +0800 Subject: [PATCH] 1.首页数据 2.装备数据 --- 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