1 DROP TABLE IF EXISTS core_geoip_network_mapping;
2 DROP TABLE IF EXISTS core_geoip_city_network_mapping;
4 -- CREATE TABLE core_geoip_city_network_mapping (
5 -- id INT(11) NOT NULL AUTO_INCREMENT ,
6 -- start_ip VARCHAR(128) NOT NULL DEFAULT '',
7 -- mask_length INT(11) NOT NULL DEFAULT 0,
8 -- city_id INT(11) NOT NULL DEFAULT 0,
9 -- is_anonymous_proxy INT(2) NOT NULL DEFAULT 0,
10 -- is_satellite_provider INT(2) NOT NULL DEFAULT 0,
14 -- CREATE INDEX start_ip_idx ON core_geoip_city_network_mapping (start_ip) USING BTREE;
15 -- CREATE INDEX mask_length_idx ON core_geoip_city_network_mapping (mask_length) USING BTREE;
16 -- CREATE INDEX city_id_idx ON core_geoip_city_network_mapping (city_id) USING BTREE;
17 -- CREATE INDEX is_anonymous_proxy_idx ON core_geoip_city_network_mapping (is_anonymous_proxy) USING BTREE;
18 -- CREATE INDEX is_satellite_provider_idx ON core_geoip_city_network_mapping (is_satellite_provider) USING BTREE;