Database Table: codes

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