From 92e15c2f16fb5e7fc7426241557da55a7fdcf136 Mon Sep 17 00:00:00 2001 From: 疯狂的狮子Li <15040126243@163.com> Date: 星期四, 30 三月 2023 22:53:00 +0800 Subject: [PATCH] reset !pr324 有逻辑性问题 暂时回滚 --- script/sql/oracle/oracle_ry_vue_5.X.sql | 10 +++++----- 1 files changed, 5 insertions(+), 5 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..0456f11 100644 --- a/script/sql/oracle/oracle_ry_vue_5.X.sql +++ b/script/sql/oracle/oracle_ry_vue_5.X.sql @@ -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'; -- Gitblit v1.9.3