Difference between revisions of "Database Table: ml text"

From Dreamwidth Notes
Jump to: navigation, search
(Robot: Updating: Format)
Line 14: Line 14:
 
</source>
 
</source>
 
{{Database Table Footer}}
 
{{Database Table Footer}}
 +
 +
la la la

Revision as of 22:37, 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

la la la