From a3ecc71558bbbc8243a4fdefff252ca3bc2234a2 Mon Sep 17 00:00:00 2001 From: Yjoioooo <5403234+zj_Gitttttttte@user.noreply.gitee.com> Date: 星期四, 09 三月 2023 17:54:55 +0800 Subject: [PATCH] !301 fix 修复 租户套餐导出接口地址错误 修复 删除弹窗提示错误 fix 修复 租户套餐导出接口地址错误 fix 修复 删除弹窗提示错误 --- script/sql/oracle/oracle_ry_vue_5.X.sql | 9 ++++++++- 1 files changed, 8 insertions(+), 1 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..067122a 100644 --- a/script/sql/oracle/oracle_ry_vue_5.X.sql +++ b/script/sql/oracle/oracle_ry_vue_5.X.sql @@ -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 '娑堣�楁椂闂�'; -- ---------------------------- @@ -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'; -- Gitblit v1.9.3