Database Table: ml_text

From Dreamwidth Notes
Revision as of 15:54, 22 July 2010 by Exor674Bot (Talk | contribs)

Jump to: navigation, search

This is a global table.

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