Difference between revisions of "Database Table: ml text"

From Dreamwidth Notes
Jump to: navigation, search
(Undo revision 10956 by Exor674 (talk))
Line 14: Line 14:
 
</source>
 
</source>
 
{{Database Table Footer}}
 
{{Database Table Footer}}
 
la la la
 

Revision as of 22:38, 28 November 2012

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