Database Table: ml text

From Dreamwidth Notes
Revision as of 17:29, 22 March 2009 by SlowSculpture (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Definition

CREATE TABLE ml_text
(
   dmid  TINYINT UNSIGNED NOT NULL,
   txtid  INT UNSIGNED AUTO_INCREMENT NOT NULL,
   PRIMARY KEY (dmid, txtid),
   lnid   SMALLINT UNSIGNED NOT NULL,
   itid   SMALLINT UNSIGNED NOT NULL,
   INDEX (lnid, dmid, itid),
   text    TEXT NOT NULL,
   userid  INT UNSIGNED NOT NULL
) TYPE=MYISAM

Relationships

Location

Global database