Skip to content

Instantly share code, notes, and snippets.

@oscar-reales-interactiv4
Created September 23, 2013 15:10
Show Gist options
  • Save oscar-reales-interactiv4/6671893 to your computer and use it in GitHub Desktop.
Save oscar-reales-interactiv4/6671893 to your computer and use it in GitHub Desktop.
Updating directory_contry_region to have the right names and accents in the spanish regions.
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment