Difference between revisions of "Database Table: ml text"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: Updating: Format, definition)
 
(One intermediate revision by one other user not shown)
Line 11: Line 11:
 
     text    TEXT NOT NULL,
 
     text    TEXT NOT NULL,
 
     userid  INT UNSIGNED NOT NULL
 
     userid  INT UNSIGNED NOT NULL
) TYPE=MYISAM
+
) ENGINE=MYISAM
 
</source>
 
</source>
 
{{Database Table Footer}}
 
{{Database Table Footer}}
 
la la la
 

Latest revision as of 23:07, 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
) ENGINE=MYISAM

Relationships