CREATE TABLE ChoiceListDataType
(
    id BIGINT UNSIGNED NOT NULL,
    name VARCHAR(125) DEFAULT NULL,
    abbreviation VARCHAR(20) NOT NULL,
    lang_id CHAR(3) NOT NULL DEFAULT "",
    sort_order INT UNSIGNED NOT NULL,
    PRIMARY KEY ( id,lang_id,sort_order )

) ENGINE=INNODB CHARSET=UTF8 COMMENT="New datatype table for choice lists";
