CREATE TABLE COUNTY (
    ID_INTERNAL            INT(11) AUTO_INCREMENT,
    CODE                   CHAR(2) NOT NULL,
	KEY_DISTRICT           INT(11) NOT NULL,
	NAME                   VARCHAR(255),
    KEY_ROOT_DOMAIN_OBJECT INT(11) NOT NULL DEFAULT 1,
    CREATION_ENTITY        TEXT,
    CREATION_ENTITY_DATE   DATE,
    UPDATE_ENTITY          TEXT,
    UPDATE_ENTITY_DATE     DATETIME,
	DISTRICT_CODE          CHAR(2),
    PRIMARY KEY(ID_INTERNAL),
  	INDEX (KEY_DISTRICT),
    KEY `KEY_ROOT_DOMAIN_OBJECT` (`KEY_ROOT_DOMAIN_OBJECT`)
);
