| | |
| | | status int(1) default 0 comment '操作状态(0正常 1异常)', |
| | | error_msg varchar(2000) default '' comment '错误消息', |
| | | oper_time datetime comment '操作时间', |
| | | primary key (oper_id) |
| | | cost_time bigint(20) default 0 comment '消耗时间', |
| | | 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 comment = '操作日志记录'; |
| | | |
| | | |
| | |
| | | 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 comment = '系统访问记录'; |
| | | |
| | | |