userlog

userlog — Clustered. Stores general purpose status log data, such as when an entry is deleted or logging post-by-e-mail activity. The initiator of the event is stored here so we can look back and say, for example: "this person deleted the entry". This works for communities and individual journals, and the actions are logged on the account that lost the entry. The basic format is [ action, actiontarget ].

userlog

Column name Type Null Default Description
userid int unsigned   0  
logtime int unsigned   0  
action varchar(30)   A textual description of what happened (up to 30 characters).
actiontarget int unsigned YES Optional, but is likely some numeric value.
remoteid int unsigned YES  
ip varchar(15) YES  
uniq varchar(15) YES  
extra varchar(255) YES  
logid int unsigned auto_increment    
Key name Type Column(s)
PRIMARY PRIMARY
userid INDEX