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

index 92e843b..805629d 100644 (file)
@@ -25,7 +25,7 @@ CREATE FUNCTION core_cities_merge_country()  RETURNS INT DETERMINISTIC
 
         DECLARE co_csr CURSOR FOR 
         SELECT 
-            id,iso,local_name
+            id,iso,local_name,in_location
         FROM 
             meta_location
         WHERE
@@ -36,7 +36,7 @@ CREATE FUNCTION core_cities_merge_country()  RETURNS INT DETERMINISTIC
 
         OPEN co_csr;
         co_loop: LOOP
-            FETCH co_csr INTO v_id,v_iso,v_local_name;
+            FETCH co_csr INTO v_id,v_iso,v_local_name,v_in_location;
             
             SET v_count = v_count + 1;