|
-- ----------------------------
|
-- 系统访问记录
|
-- ----------------------------
|
drop table if exists sys_logininfor;
|
create table sys_logininfor (
|
id bigint(20) not null auto_increment comment '日志主键',
|
user_name varchar(50) default '' comment '用户账号',
|
ipaddr varchar(128) default '' comment '登录IP地址',
|
login_location varchar(255) default '' comment '登录地点',
|
browser varchar(50) default '' comment '浏览器类型',
|
os varchar(50) default '' comment '操作系统',
|
status tinyint default 0 comment '登录状态(0成功 1失败)',
|
msg varchar(255) default '' comment '提示消息',
|
login_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP comment '访问时间',
|
primary key (id),
|
key idx_sys_logininfor_lt (login_time)
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '系统访问记录表' ROW_FORMAT = Dynamic;
|