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