sql/core_geoip_division.sql

diff --git a/sql/core_geoip_division.sql b/sql/core_geoip_division.sql
index e0a26f2..0f7fb71 100644 (file)
--- a/sql/core_geoip_division.sql
+++ b/sql/core_geoip_division.sql
@@ -9,3 +9,5 @@ CREATE  TABLE core_geoip_division (
 CREATE INDEX code_idx ON core_geoip_division (code) USING BTREE;
 CREATE INDEX name_idx ON core_geoip_division (name) USING BTREE;
 CREATE INDEX country_id_idx ON core_geoip_division (country_id) USING BTREE;
+
+CREATE INDEX cdoe_country_id_idx ON core_geoip_division (code,country_id) USING BTREE;