mysql/core_cities_merge.sql

diff --git a/mysql/core_cities_merge.sql b/mysql/core_cities_merge.sql
index d0596c8..da3bb5c 100644 (file)
--- a/mysql/core_cities_merge.sql
+++ b/mysql/core_cities_merge.sql
@@ -279,10 +279,10 @@ CREATE FUNCTION core_country_locations()  RETURNS INT DETERMINISTIC
             END IF;
 
             IF (v_country_iso_code != '') THEN
-                SELECT id INTO v_country_id FROM core_geoip_continent WHERE code = v_continent_code;
+                SELECT id INTO v_country_id FROM core_geoip_country WHERE code = v_country_iso_code;
 
                 IF v_continent_id = 0 THEN
-                    INSERT INTO core_geoip_continent (code, name) VALUES (v_continent_code, v_continent_name);
+                    INSERT INTO core_geoip_country (code, name, continent_id) VALUES (v_country_iso_code, v_country_name, v_continent_id);
                 END IF;
                 
             END IF;