From 4c57c2a04408fb8f9c0c08cf8d1919c76a90658c Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期一, 11 四月 2022 11:50:16 +0800
Subject: [PATCH] update springboot-admin 2.6.5 => 2.6.6 update qiniu 7.9.3 => 7.9.5 update qcloud 5.6.68 => 5.6.72 update minio 8.3.7 => 8.3.8 update okhttp 4.9.2 => 4.9.3
---
script/sql/oracle/oracle_ry_vue_4.X.sql | 30 +++++++-----------------------
1 files changed, 7 insertions(+), 23 deletions(-)
diff --git a/script/sql/oracle/oracle_ry_vue_4.X.sql b/script/sql/oracle/oracle_ry_vue_4.X.sql
index 9fda738..3c62649 100644
--- a/script/sql/oracle/oracle_ry_vue_4.X.sql
+++ b/script/sql/oracle/oracle_ry_vue_4.X.sql
@@ -57,8 +57,8 @@
create table sys_user (
user_id number(20) not null,
dept_id number(20) default null,
- user_name varchar2(30) not null,
- nick_name varchar2(30) not null,
+ user_name varchar2(40) not null,
+ nick_name varchar2(40) not null,
user_type varchar2(10) default 'sys_user',
email varchar2(50) default '',
phonenumber varchar2(11) default '',
@@ -200,7 +200,7 @@
order_num number(4) default 0,
path varchar(200) default '',
component varchar(255) default null,
- query varchar(255) default null,
+ query_param varchar(255) default null,
is_frame number(1) default 1,
is_cache number(1) default 0,
menu_type char(1) default '',
@@ -224,7 +224,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鎸夐挳锛�';
@@ -522,10 +522,10 @@
oper_url varchar2(255) default '',
oper_ip varchar2(128) default '',
oper_location varchar2(255) default '',
- oper_param varchar2(2000) default '',
- json_result varchar2(2000) default '',
+ oper_param varchar2(2100) default '',
+ json_result varchar2(2100) default '',
status number(1) default 0,
- error_msg varchar2(2000) default '' ,
+ error_msg varchar2(2100) default '' ,
oper_time date
);
@@ -939,22 +939,6 @@
insert into sys_oss_config values (2, 'qiniu', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'http://XXX.XXXX.com', 'N', 'z0', '1', '', NULL, 'admin', sysdate, 'admin', sysdate);
insert into sys_oss_config values (3, 'aliyun', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'http://oss-cn-beijing.aliyuncs.com', 'N', '', '1', '', NULL, 'admin', sysdate, 'admin', sysdate);
insert into sys_oss_config values (4, 'qcloud', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi-1250000000', '', 'http://cos.ap-beijing.myqcloud.com', 'N', 'ap-beijing', '1', '', NULL, 'admin', sysdate, 'admin', sysdate);
-
-
--- ----------------------------
--- 鍑芥暟 锛屼唬鏇縨ysql鐨刦ind_in_set
--- 渚嬪锛� select * from sys_dept where FIND_IN_SET (101,ancestors) <> 0
--- mysql鍙帴鍙�0鎴栧叾瀹僴umber鍋氫负where 鏉′欢锛宱racle鍙帴鍙楄〃杈惧紡鍋氫负where 鏉′欢
--- ----------------------------
-create or replace function find_in_set(arg1 in varchar2,arg2 in varchar)
-return number is Result number;
-begin
-select instr(','||arg2||',' , ','||arg1||',') into Result from dual;
-return(Result);
-end find_in_set;
-
--- 鍑芥暟鍒嗛殧绗�
-/
-- ----------------------------
-- 閽╁瓙 锛岀敤浜巗ession杩炴帴涔嬪悗 鑷姩璁剧疆榛樿鐨刣ate绫诲瀷鏍煎紡鍖� 绠�鍖栨椂闂存煡璇�
--
Gitblit v1.9.3