Database Table: usermsg

From Dreamwidth Notes
Revision as of 11:59, 27 January 2010 by Exor674Bot (Talk | contribs)

Jump to: navigation, search

"{{{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)
)

Relationships