Database Table: usermsg

From Dreamwidth Notes
Revision as of 13:24, 2 October 2009 by Exor674Bot (Talk | contribs)

Jump to: navigation, search

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