mysql/core_cities_merge.sql
authorEdward <edward@roojs.com>
Tue, 24 Jun 2014 13:06:33 +0000 (21:06 +0800)
committerEdward <edward@roojs.com>
Tue, 24 Jun 2014 13:06:33 +0000 (21:06 +0800)
mysql/core_cities_merge.sql

index 95bb56e..fa73d7d 100644 (file)
@@ -46,9 +46,9 @@ CREATE FUNCTION core_cities_merge_country()  RETURNS INT DETERMINISTIC
 
             SELECT id INTO v_id_tmp FROM core_geoip_country WHERE code = v_iso;
 
---             IF(v_id_tmp = 0) THEN
---                 INSERT INTO core_geoip_country (code, name, continent_id) VALUES (v_iso, v_local_name, 0);
---             END IF;
+            IF(v_id_tmp = 0) THEN
+                INSERT INTO core_geoip_country (code, name, continent_id) VALUES (v_iso, v_local_name, 0);
+            END IF;
                 
             IF v_count = v_total THEN
               LEAVE co_loop;