From 6f915f95bc23849a81bc522a6f158aa79ff49a07 Mon Sep 17 00:00:00 2001
From: RuoYi <yzz_ivy@163.com>
Date: 星期四, 23 二月 2023 10:01:41 +0800
Subject: [PATCH] 日志管理使用索引提升查询性能

---
 sql/ry_20230223.sql |    9 +++++++--
 1 files changed, 7 insertions(+), 2 deletions(-)

diff --git a/sql/ry_20230221.sql b/sql/ry_20230223.sql
similarity index 99%
rename from sql/ry_20230221.sql
rename to sql/ry_20230223.sql
index 123fab2..45c2ebb 100644
--- a/sql/ry_20230221.sql
+++ b/sql/ry_20230223.sql
@@ -433,7 +433,10 @@
   error_msg         varchar(2000)   default ''                 comment '閿欒娑堟伅',
   oper_time         datetime                                   comment '鎿嶄綔鏃堕棿',
   cost_time         bigint(20)      default 0                  comment '娑堣�楁椂闂�',
-  primary key (oper_id)
+  primary key (oper_id),
+  key idx_sys_oper_log_bt (business_type),
+  key idx_sys_oper_log_s  (status),
+  key idx_sys_oper_log_ot (oper_time)
 ) engine=innodb auto_increment=100 comment = '鎿嶄綔鏃ュ織璁板綍';
 
 
@@ -562,7 +565,9 @@
   status         char(1)        default '0'               comment '鐧诲綍鐘舵�侊紙0鎴愬姛 1澶辫触锛�',
   msg            varchar(255)   default ''                comment '鎻愮ず娑堟伅',
   login_time     datetime                                 comment '璁块棶鏃堕棿',
-  primary key (info_id)
+  primary key (info_id),
+  key idx_sys_logininfor_s  (status),
+  key idx_sys_logininfor_lt (login_time)
 ) engine=innodb auto_increment=100 comment = '绯荤粺璁块棶璁板綍';
 
 

--
Gitblit v1.9.3