From dcdf423d669e64a9cbe5bd5854a000b78af1f7fe Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期三, 16 三月 2022 14:06:00 +0800
Subject: [PATCH] update 更新 sqlserver sql脚本 处理遇到的问题
---
script/sql/postgres/postgres_ry_vue_4.X.sql | 22 ++++------------------
1 files changed, 4 insertions(+), 18 deletions(-)
diff --git a/script/sql/postgres/postgres_ry_vue_4.X.sql b/script/sql/postgres/postgres_ry_vue_4.X.sql
index b93309d..7a1a60d 100644
--- a/script/sql/postgres/postgres_ry_vue_4.X.sql
+++ b/script/sql/postgres/postgres_ry_vue_4.X.sql
@@ -157,8 +157,8 @@
role_key varchar(100) not null,
role_sort int4 not null,
data_scope char default '1'::bpchar,
- menu_check_strictly smallint default 1,
- dept_check_strictly smallint default 1,
+ menu_check_strictly int2 default 1,
+ dept_check_strictly int2 default 1,
status char not null,
del_flag char default '0'::bpchar,
create_by varchar(64) default ''::varchar,
@@ -204,7 +204,7 @@
order_num int4 default 0,
path varchar(200) default ''::varchar,
component varchar(255) default null::varchar,
- query varchar(255) default null::varchar,
+ query_param varchar(255) default null::varchar,
is_frame int4 default 1,
is_cache int4 default 0,
menu_type char default ''::bpchar,
@@ -227,7 +227,7 @@
comment on column sys_menu.order_num is '鏄剧ず椤哄簭';
comment on column sys_menu.path is '璺敱鍦板潃';
comment on column sys_menu.component is '缁勪欢璺緞';
-comment on column sys_menu.query is '璺敱鍙傛暟';
+comment on column sys_menu.query_param is '璺敱鍙傛暟';
comment on column sys_menu.is_frame is '鏄惁涓哄閾撅紙0鏄� 1鍚︼級';
comment on column sys_menu.is_cache is '鏄惁缂撳瓨锛�0缂撳瓨 1涓嶇紦瀛橈級';
comment on column sys_menu.menu_type is '鑿滃崟绫诲瀷锛圡鐩綍 C鑿滃崟 F鎸夐挳锛�';
@@ -951,17 +951,3 @@
insert into sys_oss_config values (2, 'qiniu', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'http://XXX.XXXX.com', 'N', 'z0', '1', '', 'admin', now(), 'admin', now(), null);
insert into sys_oss_config values (3, 'aliyun', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'http://oss-cn-beijing.aliyuncs.com', 'N', '', '1', '', 'admin', now(), 'admin', now(), null);
insert into sys_oss_config values (4, 'qcloud', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi-1250000000', '', 'http://cos.ap-beijing.myqcloud.com', 'N', 'ap-beijing', '1', '', 'admin', now(), 'admin', now(), null);
-
--- ----------------------------
--- 鍑芥暟 锛屼唬鏇縨ysql鐨刦ind_in_set
--- 渚嬪锛� select * from sys_dept where FIND_IN_SET (101,ancestors) <> 0
--- ----------------------------
-create or replace function find_in_set(arg1 int8, arg2 varchar)
-returns int8 as $body$
-declare pos int8;
-begin
-select position(','||arg1||',' IN ','||arg2||',') into pos;
-return pos;
-end;
-$body$
-language plpgsql
--
Gitblit v1.9.3