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