Skip to content

Instantly share code, notes, and snippets.

@tinchodev

tinchodev/magento_uruguay_regions.sql

Created October 26, 2020 20:01
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save tinchodev/c8a6260d6d73414782a56ec22f64ed13 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save tinchodev/c8a6260d6d73414782a56ec22f64ed13 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. tinchodev created this gist Oct 26, 2020.
    38 changes: 38 additions & 0 deletions magento_uruguay_regions.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,38 @@
    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');