Database Table: usermsg
From Dreamwidth Notes
Revision as of 11:59, 27 January 2010 by Exor674Bot (Talk | contribs)
"{{{repo}}}" is not in the list of possible values (dw-free, dw-nonfree) for this property. 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) )