usermsg

usermsg — Clustered. Stores metadata about all user-to-user messages. The actual content is stored in usermsgtext.

usermsg

Column name Type Null Default Description
journalid int unsigned   0  
msgid int unsigned   0  
type enum('in','out')   in  
parent_msgid int unsigned YES  
otherid int unsigned   0  
timesent int unsigned YES  
state char(1) YES A  
Key name Type Column(s)
PRIMARY PRIMARY
journalid INDEX
journalid_2 INDEX