Database Table: codes

From Dreamwidth Notes
Revision as of 05:45, 21 March 2009 by SlowSculpture (Talk | contribs)

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

Definition

CREATE TABLE codes (
  TYPE VARCHAR(10) NOT NULL DEFAULT '',
  code VARCHAR(7) NOT NULL DEFAULT '',
  item VARCHAR(80) DEFAULT NULL,
  sortorder SMALLINT(6) NOT NULL DEFAULT '0',
  PRIMARY KEY  (TYPE,code)
) PACK_KEYS=1

Relationships

Location

Global database

Retrieved from "http://wiki.dreamwidth.net/wiki/index.php?title=Database_Table:_codes&oldid=2761"