update-spanish-regions.sql

LOCK TABLES `directory_country_region` WRITE;

UPDATE `directory_country_region`
SET default_name = 'A Coruña'
WHERE region_id = 130;

UPDATE `directory_country_region`
SET default_name = 'Álava'
WHERE country_id = 'ES' AND code = 'Alava';

UPDATE `directory_country_region`
SET default_name = 'Almería'
WHERE country_id = 'ES' AND code = 'Almeria';

UPDATE `directory_country_region`
SET default_name = 'Ávila'
WHERE country_id = 'ES' AND code = 'Avila';

UPDATE `directory_country_region`
SET default_name = 'Cáceres'
WHERE country_id = 'ES' AND code = 'Caceres';

UPDATE `directory_country_region`
SET default_name = 'Cádiz'
WHERE country_id = 'ES' AND code = 'Cadiz';

UPDATE `directory_country_region`
SET default_name = 'Castellón'
WHERE country_id = 'ES' AND code = 'Castellon';

UPDATE `directory_country_region`
SET default_name = 'Córdoba'
WHERE country_id = 'ES' AND code = 'Cordoba';

UPDATE `directory_country_region`
SET default_name = 'Guipúzcoa'
WHERE country_id = 'ES' AND code = 'Guipuzcoa';

UPDATE `directory_country_region`
SET default_name = 'Jaén'
WHERE country_id = 'ES' AND code = 'Jaen';

UPDATE `directory_country_region`
SET default_name = 'León'
WHERE country_id = 'ES' AND code = 'Leon';

UPDATE `directory_country_region`
SET default_name = 'Málaga'
WHERE country_id = 'ES' AND code = 'Malaga';

UNLOCK TABLES;