Database Table: usermsg
From Dreamwidth Notes
This is a clustered table.
Definition
CREATE TABLE usermsg ( journalid INT UNSIGNED NOT NULL, msgid INT UNSIGNED NOT NULL, TYPE ENUM('in','out') NOT NULL, parent_msgid INT UNSIGNED, otherid INT UNSIGNED NOT NULL, timesent INT UNSIGNED, state CHAR(1) DEFAULT 'A', PRIMARY KEY (journalid,msgid), INDEX (journalid,TYPE,otherid), INDEX (journalid,timesent) )