1 DROP TABLE IF EXISTS core_geoip_division;
3 -- CREATE TABLE core_geoip_division (
4 -- id INT(11) NOT NULL AUTO_INCREMENT ,
5 -- code VARCHAR(32) NOT NULL DEFAULT '',
6 -- name VARCHAR(255) NOT NULL DEFAULT '',
7 -- country_id INT(11) NOT NULL DEFAULT 0,
11 -- CREATE INDEX code_idx ON core_geoip_division (code) USING BTREE;
12 -- CREATE INDEX name_idx ON core_geoip_division (name) USING BTREE;
13 -- CREATE INDEX country_id_idx ON core_geoip_division (country_id) USING BTREE;
15 -- CREATE INDEX cdoe_country_id_idx ON core_geoip_division (code,country_id) USING BTREE;