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 | 43 ++++++++++++++++++++++++++-----------------
1 files changed, 26 insertions(+), 17 deletions(-)
diff --git a/script/sql/oracle/oracle_ry_vue_5.X.sql b/script/sql/oracle/oracle_ry_vue_5.X.sql
index 63b38ef..68edb59 100644
--- a/script/sql/oracle/oracle_ry_vue_5.X.sql
+++ b/script/sql/oracle/oracle_ry_vue_5.X.sql
@@ -92,7 +92,7 @@
-- ----------------------------
create table sys_dept (
dept_id number(20) not null,
- tenant_id varchar2(20) not null,
+ tenant_id varchar2(20) default '000000',
parent_id number(20) default 0,
ancestors varchar2(500) default '',
dept_name varchar2(30) default '',
@@ -149,7 +149,7 @@
-- ----------------------------
create table sys_user (
user_id number(20) not null,
- tenant_id varchar2(20) not null,
+ tenant_id varchar2(20) default '000000',
dept_id number(20) default null,
user_name varchar2(40) not null,
nick_name varchar2(40) not null,
@@ -208,7 +208,7 @@
-- ----------------------------
create table sys_post (
post_id number(20) not null,
- tenant_id varchar2(20) not null,
+ tenant_id varchar2(20) default '000000',
post_code varchar2(64) not null,
post_name varchar2(50) not null,
post_sort number(4) not null,
@@ -251,7 +251,7 @@
-- ----------------------------
create table sys_role (
role_id number(20) not null,
- tenant_id varchar2(20) not null,
+ tenant_id varchar2(20) default '000000',
role_name varchar2(30) not null,
role_key varchar2(100) not null,
role_sort number(4) not null,
@@ -353,7 +353,7 @@
insert into sys_menu values('6', '绉熸埛绠＄悊', '0', '2', 'tenant', null, '', 1, 0, 'M', '0', '0', '', 'chart', 103, 1, sysdate, null, null, '绉熸埛绠＄悊鐩綍');
insert into sys_menu values('2', '绯荤粺鐩戞帶', '0', '3', 'monitor', null, '', 1, 0, 'M', '0', '0', '', 'monitor', 103, 1, sysdate, null, null, '绯荤粺鐩戞帶鐩綍');
insert into sys_menu values('3', '绯荤粺宸ュ叿', '0', '4', 'tool', null, '', 1, 0, 'M', '0', '0', '', 'tool', 103, 1, sysdate, null, null, '绯荤粺宸ュ叿鐩綍');
-insert into sys_menu values('4', 'PLUS瀹樼綉', '0', '5', 'https://gitee.com/JavaLionLi/RuoYi-Vue-Plus', null, '', 0, 0, 'M', '0', '0', '', 'guide', 103, 1, sysdate, null, null, 'RuoYi-Vue-Plus瀹樼綉鍦板潃');
+insert into sys_menu values('4', 'PLUS瀹樼綉', '0', '5', 'https://gitee.com/dromara/RuoYi-Vue-Plus', null, '', 0, 0, 'M', '0', '0', '', 'guide', 103, 1, sysdate, null, null, 'RuoYi-Vue-Plus瀹樼綉鍦板潃');
-- 浜岀骇鑿滃崟
insert into sys_menu values('100', '鐢ㄦ埛绠＄悊', '1', '1', 'user', 'system/user/index', '', 1, 0, 'C', '0', '0', 'system:user:list', 'user', 103, 1, sysdate, null, null, '鐢ㄦ埛绠＄悊鑿滃崟');
insert into sys_menu values('101', '瑙掕壊绠＄悊', '1', '2', 'role', 'system/role/index', '', 1, 0, 'C', '0', '0', 'system:role:list', 'peoples', 103, 1, sysdate, null, null, '瑙掕壊绠＄悊鑿滃崟');
@@ -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, '鎿嶄綔鏃ュ織鑿滃崟');
@@ -634,7 +634,7 @@
-- ----------------------------
create table sys_oper_log (
oper_id number(20) not null,
- tenant_id varchar2(20) not null,
+ tenant_id varchar2(20) default '000000',
title varchar2(50) default '',
business_type number(2) default 0,
method varchar2(100) default '',
@@ -649,10 +649,14 @@
json_result varchar2(2100) default '',
status number(1) default 0,
error_msg varchar2(2100) default '',
- oper_time date
+ oper_time date,
+ cost_time number(20) default 0
);
alter table sys_oper_log add constraint pk_sys_oper_log primary key (oper_id);
+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 '鏃ュ織涓婚敭';
@@ -672,6 +676,7 @@
comment on column sys_oper_log.status is '鎿嶄綔鐘舵�侊紙0姝ｅ父 1寮傚父锛�';
comment on column sys_oper_log.error_msg is '閿欒娑堟伅';
comment on column sys_oper_log.oper_time is '鎿嶄綔鏃堕棿';
+comment on column sys_oper_log.cost_time is '娑堣�楁椂闂�';
-- ----------------------------
@@ -679,7 +684,7 @@
-- ----------------------------
create table sys_dict_type (
dict_id number(20) not null,
- tenant_id varchar2(20) not null,
+ tenant_id varchar2(20) default '000000',
dict_name varchar2(100) default '',
dict_type varchar2(100) default '',
status char(1) default '0',
@@ -722,7 +727,7 @@
-- ----------------------------
create table sys_dict_data (
dict_code number(20) not null,
- tenant_id varchar2(20) not null,
+ tenant_id varchar2(20) default '000000',
dict_sort number(4) default 0,
dict_label varchar2(100) default '',
dict_value varchar2(100) default '',
@@ -791,7 +796,7 @@
-- ----------------------------
create table sys_config (
config_id number(20) not null,
- tenant_id varchar2(20) not null,
+ tenant_id varchar2(20) default '000000',
config_name varchar2(100) default '',
config_key varchar2(100) default '',
config_value varchar2(100) default '',
@@ -831,7 +836,7 @@
-- ----------------------------
create table sys_logininfor (
info_id number(20) not null,
- tenant_id varchar2(20) not null,
+ tenant_id varchar2(20) default '000000',
user_name varchar2(50) default '',
ipaddr varchar2(128) default '',
login_location varchar2(255) default '',
@@ -843,6 +848,8 @@
);
alter table sys_logininfor add constraint pk_sys_logininfor primary key (info_id);
+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';
@@ -862,7 +869,7 @@
-- ----------------------------
create table sys_notice (
notice_id number(20) not null,
- tenant_id varchar2(20) not null,
+ tenant_id varchar2(20) default '000000',
notice_title varchar2(50) not null,
notice_type char(1) not null,
notice_content clob default null,
@@ -903,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,
@@ -929,6 +937,7 @@
comment on table gen_table is '浠ｇ爜鐢熸垚涓氬姟琛�';
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 '鍏宠仈瀛愯〃鐨勮〃鍚�';
@@ -1013,7 +1022,7 @@
-- ----------------------------
create table sys_oss (
oss_id number(20) not null,
- tenant_id varchar2(20) not null,
+ tenant_id varchar2(20) default '000000',
file_name varchar(255) not null,
original_name varchar(255) not null,
file_suffix varchar(10) not null,
@@ -1048,7 +1057,7 @@
-- ----------------------------
create table sys_oss_config (
oss_config_id number(20) not null,
- tenant_id varchar2(20) not null,
+ tenant_id varchar2(20) default '000000',
config_key varchar(20) not null,
access_key varchar(255) default '',
secret_key varchar(255) default '',
@@ -1084,7 +1093,7 @@
comment on column sys_oss_config.is_https is '鏄惁https锛圷=鏄�,N=鍚︼級';
comment on column sys_oss_config.region is '鍩�';
comment on column sys_oss_config.access_policy is '妗舵潈闄愮被鍨�(0=private 1=public 2=custom)';
-comment on column sys_oss_config.status is '鐘舵�侊紙0=姝ｅ父,1=鍋滅敤锛�';
+comment on column sys_oss_config.status is '鏄惁榛樿锛�0=鏄�,1=鍚︼級';
comment on column sys_oss_config.ext1 is '鎵╁睍瀛楁';
comment on column sys_oss_config.remark is '澶囨敞';
comment on column sys_oss_config.create_dept is '鍒涘缓閮ㄩ棬';
--
Gitblit v1.9.3