1 DROP TABLE IF EXISTS core_geoip_city;
3 -- CREATE TABLE core_geoip_city (
4 -- id INT(11) NOT NULL AUTO_INCREMENT ,
5 -- name VARCHAR(255) NOT NULL DEFAULT '',
6 -- country_id INT(11) NOT NULL DEFAULT 0,
7 -- division_id INT(11) NOT NULL DEFAULT 0,
8 -- postal_code VARCHAR(128) NOT NULL DEFAULT '',
9 -- metro_code VARCHAR(128) NOT NULL DEFAULT 0,
10 -- time_zone VARCHAR(128) NOT NULL DEFAULT '',
14 -- CREATE INDEX name_idx ON core_geoip_city (name) USING BTREE;
15 -- CREATE INDEX country_id_idx ON core_geoip_city (country_id) USING BTREE;
16 -- CREATE INDEX division_id_idx ON core_geoip_city (division_id) USING BTREE;
17 -- CREATE INDEX postal_code_idx ON core_geoip_city (postal_code) USING BTREE;
18 -- CREATE INDEX metro_code_idx ON core_geoip_city (metro_code) USING BTREE;
19 -- CREATE INDEX time_zone_idx ON core_geoip_city (time_zone) USING BTREE;
21 -- CREATE INDEX name_country_id_division_id_idx ON core_geoip_city (name,country_id,division_id) USING BTREE;