loginlog

loginlog — Clustered. Stores data to give users access to view their logins in the past 30 days, if they're at all afraid that their account has been compromised.

loginlog

Column name Type Null Default Description
userid int unsigned   0  
logintime int unsigned   0  
sessid mediumint unsigned   0  
ip varchar(15) YES  
ua varchar(100) YES  
loginid int unsigned auto_increment    
Key name Type Column(s)
PRIMARY PRIMARY
userid INDEX