Created
September 23, 2013 15:10
-
-
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.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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