mysql/core_cities_merge.sql
authorEdward <edward@roojs.com>
Thu, 26 Jun 2014 10:16:45 +0000 (18:16 +0800)
committerEdward <edward@roojs.com>
Thu, 26 Jun 2014 10:16:45 +0000 (18:16 +0800)
mysql/core_cities_merge.sql

index 5aad08e..3149e7c 100644 (file)
@@ -265,7 +265,8 @@ CREATE FUNCTION core_country_locations()  RETURNS INT DETERMINISTIC
             
             SET v_count = v_count + 1;
             
-            SET v_id = 0;
+            SET v_country_id = 0;
+            SET v_continent_id = 0;
             
             SELECT id INTO v_id_tmp FROM core_geoip_country WHERE code = v_iso;