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 | 24 ++++++++++--------------
1 files changed, 10 insertions(+), 14 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 346927a..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 -- 澶囨敞
);
@@ -227,8 +227,8 @@
component VARCHAR(255) DEFAULT NULL,
query VARCHAR(255) DEFAULT NULL,
route_name VARCHAR(50) DEFAULT '',
- is_frame INTEGER DEFAULT 1,
- is_cache INTEGER DEFAULT 0,
+ is_frame VARCHAR(10) DEFAULT 1,
+ is_cache VARCHAR(10) DEFAULT 0,
menu_type CHAR(1) DEFAULT '',
visible CHAR(1) DEFAULT '0',
status INTEGER DEFAULT 0,
@@ -1158,14 +1158,10 @@
COMMENT ON COLUMN sys_notice.remark IS '澶囨敞';
-- 鎻掑叆鍒濆鍖栨暟鎹�
-INSERT INTO sys_notice (notice_id, notice_title, notice_type, notice_content, status, create_by, create_time, update_by,
- update_time, remark)
-VALUES (1, '娓╅Θ鎻愰啋锛�2018-07-01 鑻ヤ緷鏂扮増鏈彂甯冨暒', '2', E'\\x鏂扮増鏈唴瀹�'::bytea, '0', 'admin', NOW(), '', NULL,
- '绠＄悊鍛�'),
- (2, '缁存姢閫氱煡锛�2018-07-01 鑻ヤ緷绯荤粺鍑屾櫒缁存姢', '1', E'\\x缁存姢鍐呭'::bytea, '0', 'admin', NOW(), '', NULL, '绠＄悊鍛�');
-
-
-
+INSERT INTO sys_notice
+VALUES ('1', '娓╅Θ鎻愰啋锛�2018-07-01 鑻ヤ緷鏂扮増鏈彂甯冨暒', '2', '鏂扮増鏈唴瀹�', '0', 'admin', NOW(), '', NULL, '绠＄悊鍛�');
+INSERT INTO sys_notice
+VALUES ('2', '缁存姢閫氱煡锛�2018-07-01 鑻ヤ緷绯荤粺鍑屾櫒缁存姢', '1', '缁存姢鍐呭', '0', 'admin', NOW(), '', NULL, '绠＄悊鍛�');
-- ----------------------------
-- 18銆佷唬鐮佺敓鎴愪笟鍔¤〃
--
Gitblit v1.9.3