From 1c1856781a28a5e8be3a477ce5e62761c7bc6c7b Mon Sep 17 00:00:00 2001 From: Edward Date: Thu, 26 Jun 2014 18:16:45 +0800 Subject: [PATCH] mysql/core_cities_merge.sql --- mysql/core_cities_merge.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/mysql/core_cities_merge.sql b/mysql/core_cities_merge.sql index 5aad08e2..3149e7c4 100644 --- a/mysql/core_cities_merge.sql +++ b/mysql/core_cities_merge.sql @@ -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; -- 2.39.2