Database Table: ml items

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

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

Definition

CREATE TABLE ml_items
(
   dmid    TINYINT UNSIGNED NOT NULL,
   itid    MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL,
   PRIMARY KEY (dmid, itid),
   itcode  VARCHAR(80) NOT NULL,
   UNIQUE  (dmid, itcode),
   notes   MEDIUMTEXT
) TYPE=MYISAM

Relationships

Location

Global database