1 CREATE TABLE core_geoip_division (
2 id INT(11) NOT NULL AUTO_INCREMENT ,
3 code VARCHAR(32) NOT NULL DEFAULT '',
4 name VARCHAR(255) NOT NULL DEFAULT '',
5 country_id INT(11) NOT NULL DEFAULT 0,
9 CREATE INDEX code_idx ON core_geoip_division (code) USING BTREE;
10 CREATE INDEX name_idx ON core_geoip_division (name) USING BTREE;
11 CREATE INDEX country_id_idx ON core_geoip_division (country_id) USING BTREE;