文件名从 sql/ry_20230221.sql 修改 |
| | |
| | | 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 = '操作日志记录';
|
| | |
|
| | |
|
| | |
| | | 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 = '系统访问记录';
|
| | |
|
| | |
|