From b14fa6e12fe3b5d4ac0b5fa08999dddee79bfcff Mon Sep 17 00:00:00 2001 From: 疯狂的狮子li <15040126243@163.com> Date: 星期二, 14 三月 2023 11:23:17 +0800 Subject: [PATCH] update 优化 更改 sys_oss_config 表注释 避免误解 --- script/sql/oracle/oracle_ry_vue_5.X.sql | 35 +++++++++++++++++++++-------------- 1 files changed, 21 insertions(+), 14 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..99be72c 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, @@ -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 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); 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 unique index idx_sys_logininfor_s on sys_logininfor (status); +create unique 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, @@ -1013,7 +1020,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 +1055,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 +1091,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