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.时区优化
---
ruoyi-admin/src/main/resources/db/beforeSql/postgresql/beforeSQL__sys.sql | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/ruoyi-admin/src/main/resources/db/beforeSql/postgresql/beforeSQL__sys.sql b/ruoyi-admin/src/main/resources/db/beforeSql/postgresql/beforeSQL__sys.sql
index 0062192..2a01533 100644
--- a/ruoyi-admin/src/main/resources/db/beforeSql/postgresql/beforeSQL__sys.sql
+++ b/ruoyi-admin/src/main/resources/db/beforeSql/postgresql/beforeSQL__sys.sql
@@ -16,9 +16,9 @@
status CHAR(1) DEFAULT '0', -- 閮ㄩ棬鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�
del_flag CHAR(1) DEFAULT '0', -- 鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�
create_by VARCHAR(64) DEFAULT '', -- 鍒涘缓鑰�
- create_time TIMESTAMP, -- 鍒涘缓鏃堕棿
+ create_time TIMESTAMP WITHOUT TIME ZONE, -- 鍒涘缓鏃堕棿
update_by VARCHAR(64) DEFAULT '', -- 鏇存柊鑰�
- update_time TIMESTAMP -- 鏇存柊鏃堕棿
+ update_time TIMESTAMP WITHOUT TIME ZONE -- 鏇存柊鏃堕棿
);
COMMENT ON TABLE sys_dept IS '閮ㄩ棬琛�';
@@ -86,9 +86,9 @@
login_ip VARCHAR(128) DEFAULT '', -- 鏈�鍚庣櫥褰旾P
login_date TIMESTAMP, -- 鏈�鍚庣櫥褰曟椂闂�
create_by VARCHAR(64) DEFAULT '', -- 鍒涘缓鑰�
- create_time TIMESTAMP, -- 鍒涘缓鏃堕棿
+ create_time TIMESTAMP WITHOUT TIME ZONE, -- 鍒涘缓鏃堕棿
update_by VARCHAR(64) DEFAULT '', -- 鏇存柊鑰�
- update_time TIMESTAMP, -- 鏇存柊鏃堕棿
+ update_time TIMESTAMP WITHOUT TIME ZONE, -- 鏇存柊鏃堕棿
remark VARCHAR(500) DEFAULT NULL -- 澶囨敞
);
--
Gitblit v1.9.3