From 8bd023b49fbdf2bc0677da8b7bbdce6c820f32f9 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期三, 02 十一月 2022 10:34:58 +0800
Subject: [PATCH] fix 修复 sqlserver 分页问题

---
 script/sql/oracle/oracle_ry_vue_4.X.sql |    7 ++++---
 1 files changed, 4 insertions(+), 3 deletions(-)

diff --git a/script/sql/oracle/oracle_ry_vue_4.X.sql b/script/sql/oracle/oracle_ry_vue_4.X.sql
index d4bbd29..ad3a442 100644
--- a/script/sql/oracle/oracle_ry_vue_4.X.sql
+++ b/script/sql/oracle/oracle_ry_vue_4.X.sql
@@ -228,7 +228,7 @@
 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鎸夐挳锛�';
-comment on column sys_menu.visible      is '鑿滃崟鐘舵�侊紙0鏄剧ず 1闅愯棌锛�';
+comment on column sys_menu.visible      is '鏄剧ず鐘舵�侊紙0鏄剧ず 1闅愯棌锛�';
 comment on column sys_menu.status       is '鑿滃崟鐘舵�侊紙0姝e父 1鍋滅敤锛�';
 comment on column sys_menu.perms        is '鏉冮檺鏍囪瘑';
 comment on column sys_menu.icon         is '鑿滃崟鍥炬爣';
@@ -642,6 +642,7 @@
 insert into sys_dict_data values(15, 2,  '鍏憡',     '2',       'sys_notice_type',     '',   'success', 'N', '0', 'admin', sysdate, '', null, '鍏憡');
 insert into sys_dict_data values(16, 1,  '姝e父',     '0',       'sys_notice_status',   '',   'primary', 'Y', '0', 'admin', sysdate, '', null, '姝e父鐘舵��');
 insert into sys_dict_data values(17, 2,  '鍏抽棴',     '1',       'sys_notice_status',   '',   'danger',  'N', '0', 'admin', sysdate, '', null, '鍏抽棴鐘舵��');
+insert into sys_dict_data values(29, 99, '鍏朵粬',     '0',       'sys_oper_type',       '',   'info',    'N', '0', 'admin', sysdate, '', null, '鍏朵粬鎿嶄綔');
 insert into sys_dict_data values(18, 1,  '鏂板',     '1',       'sys_oper_type',       '',   'info',    'N', '0', 'admin', sysdate, '', null, '鏂板鎿嶄綔');
 insert into sys_dict_data values(19, 2,  '淇敼',     '2',       'sys_oper_type',       '',   'info',    'N', '0', 'admin', sysdate, '', null, '淇敼鎿嶄綔');
 insert into sys_dict_data values(20, 3,  '鍒犻櫎',     '3',       'sys_oper_type',       '',   'danger',  'N', '0', 'admin', sysdate, '', null, '鍒犻櫎鎿嶄綔');
@@ -873,7 +874,7 @@
   original_name   varchar(255)  not null,
   file_suffix     varchar(10)  not null,
   url             varchar(500) not null,
-  service         varchar(10)  default 'minio' not null,
+  service         varchar(20)  default 'minio' not null,
   create_by       varchar(64)  default '',
   create_time     date,
   update_by       varchar(64)  default '',
@@ -900,7 +901,7 @@
 -- ----------------------------
 create table sys_oss_config (
   oss_config_id   number(20)    not null,
-  config_key      varchar(255)  not null,
+  config_key      varchar(20)   not null,
   access_key      varchar(255)  default '',
   secret_key      varchar(255)  default '',
   bucket_name     varchar(255)  default '',

--
Gitblit v1.9.3