From 84e908b9f0800b6c18aa951b515683ccbb13d10f Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期二, 03 六月 2025 13:56:08 +0800
Subject: [PATCH] mysql中find_in_set改成PostgreSQL 的 string_to_array + = ANY()
---
ruoyi-admin/src/main/resources/db/beforeSql/postgresql/beforeSQL__sys.sql | 18 +++++++-----------
1 files changed, 7 insertions(+), 11 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 af37cc5..0062192 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
@@ -227,11 +227,11 @@
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 CHAR(1) DEFAULT '0',
+ status INTEGER DEFAULT 0,
perms VARCHAR(100) DEFAULT NULL,
icon VARCHAR(100) DEFAULT '#',
create_by VARCHAR(64) DEFAULT '',
@@ -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