Database Table: codes

From Dreamwidth Notes
Revision as of 16:01, 22 July 2010 by Exor674Bot (Talk | contribs)

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

This is a global table. This table stores coded values for a number of lists, including countries, states/provinces, and certain sets of colors. See upgrading/base-data.sql for initial content.

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