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

index f7d9963..483d76e 100644 (file)
@@ -33,6 +33,9 @@ CREATE FUNCTION core_cities_merge_country()  RETURNS INT DETERMINISTIC
         DECLARE CONTINUE HANDLER FOR NOT FOUND SET co_done = TRUE;
 
 
+        SELECT count(id) INTO v_id FROM meta_location WHERE type = 'CO';
+        RETURN v_id;
+
         SET v_count = 0;
 
         OPEN co_csr;