CREATE TABLE IF NOT EXISTS cscart_cities
            (
                city_id      mediumint unsigned NOT NULL AUTO_INCREMENT,
                state_code   varchar(32)        NOT NULL DEFAULT '',
                country_code varchar(2)         NOT NULL DEFAULT '',
                code         varchar(32)        NOT NULL DEFAULT '',
                status       char(1)            NOT NULL DEFAULT 'A',
                position     smallint           NOT NULL DEFAULT 999,
                is_new       char(1)            NOT NULL DEFAULT 'N',
                PRIMARY KEY (city_id),
                UNIQUE KEY cs (country_code, state_code, code),
                KEY state_code (state_code),
                KEY code (code),
                KEY country_code (country_code)
            ) ENGINE=MyISAM DEFAULT CHARSET=utf8