2 DROP FUNCTION IF EXISTS core_cities_merge;
4 CREATE FUNCTION core_cities_merge() RETURNS TEXT DETERMINISTIC
6 DECLARE done INT DEFAULT FALSE;
7 DECLARE v_iso TEXT DEFAULT '';
8 DECLARE v_local_name TEXT DEFAULT '';
9 DECLARE v_type TEXT DEFAULT '';
10 DECLARE v_in_location INT DEFAULT 0;
11 DECLARE v_id INT DEFAULT 0;
13 DECLARE csr CURSOR FOR
15 iso,local_name,type,in_location
19 DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
23 FETCH csr INTO v_iso,v_local_name,v_type,v_in_location;
28 SELECT id INTO v_id FROM core_geoip_country WHERE code = v_iso;
30 INSERT INTO core_geoip_country (code, name, continent_id) VALUES (v_iso, v_local_name, 0);