sql/core_geoip_city.sql

diff --git a/sql/core_geoip_city.sql b/sql/core_geoip_city.sql
index 5ebc6f4..49c7424 100644 (file)
--- a/sql/core_geoip_city.sql
+++ b/sql/core_geoip_city.sql
@@ -16,3 +16,5 @@ CREATE INDEX postal_code_idx ON core_geoip_city (postal_code) USING BTREE;
 CREATE INDEX metro_code_idx ON core_geoip_city (metro_code) USING BTREE;
 CREATE INDEX time_zone_idx ON core_geoip_city (time_zone) USING BTREE;
 
+CREATE INDEX name_country_id_division_id_idx ON core_geoip_city (name,country_id,division_id) USING BTREE;
+