From 6523fe59a299b2f159b0793deab73271fd65f463 Mon Sep 17 00:00:00 2001 From: RuoYi <yzz_ivy@163.com> Date: 星期四, 23 二月 2023 10:01:16 +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.2