From 35ad3067307e40b89d3ea8c131ac35c17f62ff1c Mon Sep 17 00:00:00 2001
From: 三个三 <2029364173@qq.com>
Date: 星期六, 17 六月 2023 23:13:02 +0800
Subject: [PATCH] Merge branch '5.X' of gitee.com:dromara/RuoYi-Vue-Plus into JustAuth

---
 script/sql/oracle/oracle_ry_vue_5.X.sql |   16 +++++++++-------
 1 files changed, 9 insertions(+), 7 deletions(-)

diff --git a/script/sql/oracle/oracle_ry_vue_5.X.sql b/script/sql/oracle/oracle_ry_vue_5.X.sql
index 78ceb59..68edb59 100644
--- a/script/sql/oracle/oracle_ry_vue_5.X.sql
+++ b/script/sql/oracle/oracle_ry_vue_5.X.sql
@@ -374,8 +374,8 @@
 insert into sys_menu values('117',  'Admin鐩戞帶',   '2',    '5', 'Admin',            'monitor/admin/index',         '', 1, 0, 'C', '0', '0', 'monitor:admin:list',          'dashboard',     103, 1, sysdate, null, null, 'Admin鐩戞帶鑿滃崟');
 -- oss鑿滃崟
 insert into sys_menu values('118',  '鏂囦欢绠$悊',     '1',    '10', 'oss',             'system/oss/index',            '', 1, 0, 'C', '0', '0', 'system:oss:list',             'upload',        103, 1, sysdate, null, null, '鏂囦欢绠$悊鑿滃崟');
--- xxl-job-admin鎺у埗鍙�
-insert into sys_menu values('120',  '浠诲姟璋冨害涓績',  '2',    '5', 'XxlJob',           'monitor/xxljob/index',        '', 1, 0, 'C', '0', '0', 'monitor:xxljob:list',         'job',           103, 1, sysdate, null, null, 'Xxl-Job鎺у埗鍙拌彍鍗�');
+-- powerjob server鎺у埗鍙�
+insert into sys_menu values('120',  '浠诲姟璋冨害涓績',  '2',    '5', 'powerjob',           'monitor/powerjob/index',        '', 1, 0, 'C', '0', '0', 'monitor:powerjob:list',         'job',           103, 1, sysdate, null, null, 'PowerJob鎺у埗鍙拌彍鍗�');
 
 -- 涓夌骇鑿滃崟
 insert into sys_menu values('500',  '鎿嶄綔鏃ュ織', '108', '1', 'operlog',    'monitor/operlog/index',    '', 1, 0, 'C', '0', '0', 'monitor:operlog:list',    'form',          103, 1, sysdate, null, null, '鎿嶄綔鏃ュ織鑿滃崟');
@@ -654,9 +654,9 @@
 );
 
 alter table sys_oper_log add constraint pk_sys_oper_log primary key (oper_id);
-create unique index idx_sys_oper_log_bt on sys_oper_log (business_type);
-create unique index idx_sys_oper_log_s on sys_oper_log (status);
-create unique index idx_sys_oper_log_ot on sys_oper_log (oper_time);
+create index idx_sys_oper_log_bt on sys_oper_log (business_type);
+create index idx_sys_oper_log_s on sys_oper_log (status);
+create index idx_sys_oper_log_ot on sys_oper_log (oper_time);
 
 comment on table  sys_oper_log                is '鎿嶄綔鏃ュ織璁板綍';
 comment on column sys_oper_log.oper_id        is '鏃ュ織涓婚敭';
@@ -848,8 +848,8 @@
 );
 
 alter table sys_logininfor add constraint pk_sys_logininfor primary key (info_id);
-create unique index idx_sys_logininfor_s on sys_logininfor (status);
-create unique index idx_sys_logininfor_lt on sys_logininfor (login_time);
+create index idx_sys_logininfor_s on sys_logininfor (status);
+create index idx_sys_logininfor_lt on sys_logininfor (login_time);
 
 comment on table  sys_logininfor                is '绯荤粺璁块棶璁板綍';
 comment on column sys_logininfor.info_id        is '璁块棶ID';
@@ -910,6 +910,7 @@
 -- ----------------------------
 create table gen_table (
   table_id          number(20)       not null,
+  data_name         varchar2(200)    default '',
   table_name        varchar2(200)    default '',
   table_comment     varchar2(500)    default '',
   sub_table_name    varchar(64)      default null,
@@ -936,6 +937,7 @@
 
 comment on table  gen_table                   is '浠g爜鐢熸垚涓氬姟琛�';
 comment on column gen_table.table_id          is '缂栧彿';
+comment on column gen_table.data_name         is '鏁版嵁婧愬悕绉�';
 comment on column gen_table.table_name        is '琛ㄥ悕绉�';
 comment on column gen_table.table_comment     is '琛ㄦ弿杩�';
 comment on column gen_table.sub_table_name    is '鍏宠仈瀛愯〃鐨勮〃鍚�';

--
Gitblit v1.9.3