Magento 1/2 Uruguay Regions

magento_uruguay_regions.sql

INSERT INTO directory_country_region VALUES (NULL,'UY','AR','Artigas');
INSERT INTO directory_country_region VALUES (NULL,'UY','CA','Canelones');
INSERT INTO directory_country_region VALUES (NULL,'UY','CL','Cerro Largo');
INSERT INTO directory_country_region VALUES (NULL,'UY','CO','Colonia');
INSERT INTO directory_country_region VALUES (NULL,'UY','DU','Durazno');
INSERT INTO directory_country_region VALUES (NULL,'UY','FS','Flores');
INSERT INTO directory_country_region VALUES (NULL,'UY','FD','Florida');
INSERT INTO directory_country_region VALUES (NULL,'UY','LA','Lavalleja');
INSERT INTO directory_country_region VALUES (NULL,'UY','MA','Maldonado');
INSERT INTO directory_country_region VALUES (NULL,'UY','MO','Montevideo');
INSERT INTO directory_country_region VALUES (NULL,'UY','PA','Paysandú');
INSERT INTO directory_country_region VALUES (NULL,'UY','RV','Rivera');
INSERT INTO directory_country_region VALUES (NULL,'UY','RO','Rocha');
INSERT INTO directory_country_region VALUES (NULL,'UY','RN','Río Negro');
INSERT INTO directory_country_region VALUES (NULL,'UY','SA','Salto');
INSERT INTO directory_country_region VALUES (NULL,'UY','SJ','San José');
INSERT INTO directory_country_region VALUES (NULL,'UY','SO','Soriano');
INSERT INTO directory_country_region VALUES (NULL,'UY','TA','Tacuarembó');
INSERT INTO directory_country_region VALUES (NULL,'UY','TT','Treinta y Tres');
INSERT INTO directory_country_region_name VALUES ('en_US',(SELECT region_id FROM directory_country_region WHERE country_id = 'UY' AND code = 'AR'),'Artigas');
INSERT INTO directory_country_region_name VALUES ('en_US',(SELECT region_id FROM directory_country_region WHERE country_id = 'UY' AND code = 'CA'),'Canelones');
INSERT INTO directory_country_region_name VALUES ('en_US',(SELECT region_id FROM directory_country_region WHERE country_id = 'UY' AND code = 'CL'),'Cerro Largo');
INSERT INTO directory_country_region_name VALUES ('en_US',(SELECT region_id FROM directory_country_region WHERE country_id = 'UY' AND code = 'CO'),'Colonia');
INSERT INTO directory_country_region_name VALUES ('en_US',(SELECT region_id FROM directory_country_region WHERE country_id = 'UY' AND code = 'DU'),'Durazno');
INSERT INTO directory_country_region_name VALUES ('en_US',(SELECT region_id FROM directory_country_region WHERE country_id = 'UY' AND code = 'FS'),'Flores');
INSERT INTO directory_country_region_name VALUES ('en_US',(SELECT region_id FROM directory_country_region WHERE country_id = 'UY' AND code = 'FD'),'Florida');
INSERT INTO directory_country_region_name VALUES ('en_US',(SELECT region_id FROM directory_country_region WHERE country_id = 'UY' AND code = 'LA'),'Lavalleja');
INSERT INTO directory_country_region_name VALUES ('en_US',(SELECT region_id FROM directory_country_region WHERE country_id = 'UY' AND code = 'MA'),'Maldonado');
INSERT INTO directory_country_region_name VALUES ('en_US',(SELECT region_id FROM directory_country_region WHERE country_id = 'UY' AND code = 'MO'),'Montevideo');
INSERT INTO directory_country_region_name VALUES ('en_US',(SELECT region_id FROM directory_country_region WHERE country_id = 'UY' AND code = 'PA'),'Paysandú');
INSERT INTO directory_country_region_name VALUES ('en_US',(SELECT region_id FROM directory_country_region WHERE country_id = 'UY' AND code = 'RV'),'Rivera');
INSERT INTO directory_country_region_name VALUES ('en_US',(SELECT region_id FROM directory_country_region WHERE country_id = 'UY' AND code = 'RO'),'Rocha');
INSERT INTO directory_country_region_name VALUES ('en_US',(SELECT region_id FROM directory_country_region WHERE country_id = 'UY' AND code = 'RN'),'Río Negro');
INSERT INTO directory_country_region_name VALUES ('en_US',(SELECT region_id FROM directory_country_region WHERE country_id = 'UY' AND code = 'SA'),'Salto');
INSERT INTO directory_country_region_name VALUES ('en_US',(SELECT region_id FROM directory_country_region WHERE country_id = 'UY' AND code = 'SJ'),'San José');
INSERT INTO directory_country_region_name VALUES ('en_US',(SELECT region_id FROM directory_country_region WHERE country_id = 'UY' AND code = 'SO'),'Soriano');
INSERT INTO directory_country_region_name VALUES ('en_US',(SELECT region_id FROM directory_country_region WHERE country_id = 'UY' AND code = 'TA'),'Tacuarembó');
INSERT INTO directory_country_region_name VALUES ('en_US',(SELECT region_id FROM directory_country_region WHERE country_id = 'UY' AND code = 'TT'),'Treinta y Tres');