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

index 7ab278a..4a35d08 100644 (file)
@@ -505,11 +505,11 @@ CREATE FUNCTION core_city_blocks()  RETURNS INT DETERMINISTIC
 
             SELECT country_iso_code,subdivision_iso_name,city_name INTO v_country_iso_code, v_subdivision_name v_city_name FROM city_locations WHERE geoname_id = v_geoname_id;
 
-            IF (v_country_iso_code != '') THEN
+            IF v_country_iso_code != '' THEN
                 SELECT id INTO v_country_id FROM core_geoip_country WHERE code = v_country_iso_code;
             END IF;
 
-            IF (v_subdivision_name != '') THEN
+            IF v_subdivision_name != '' THEN
                 SELECT id INTO v_divison_id FROM core_geoip_division WHERE name = v_subdivision_name AND country_id = v_country_id;
             END IF;