Startsida Utforska Hjälp
Registrera dig Logga in
Framework
/
urfatBro
2
0
Fork 0
Filer Ärenden 1 Pull-förfrågningar 0 Wiki
Träd: a60cfcec3a
Grenar Taggar
urfatBro
/
app
/
geo
/
state
/
db
/
001_brazil_states_seeding.sql

001_brazil_states_seeding.sql 4.1 KB
Historik Rå

123456789101112131415161718192021222324252627 
  1. insert into {geo_states} (name, code, shortname, country_id) VALUES('Are'                  ,12 ,'AC', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    2. 

  2. insert into {geo_states} (name, code, shortname, country_id) VALUES('Alagoas'	           ,27 ,'AL', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    3. 

  3. insert into {geo_states} (name, code, shortname, country_id) VALUES('Amapá'                ,16 ,'AP', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    4. 

  4. insert into {geo_states} (name, code, shortname, country_id) VALUES('Amazonas'             ,13 ,'AM', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    5. 

  5. insert into {geo_states} (name, code, shortname, country_id) VALUES('Bahia'                ,29 ,'BA', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    6. 

  6. insert into {geo_states} (name, code, shortname, country_id) VALUES('Ceará'                ,23 ,'CE', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    7. 

  7. insert into {geo_states} (name, code, shortname, country_id) VALUES('Distrito Federal'     ,53 ,'DF', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    8. 

  8. insert into {geo_states} (name, code, shortname, country_id) VALUES('Espírito Santo'       ,32 ,'ES', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    9. 

  9. insert into {geo_states} (name, code, shortname, country_id) VALUES('Goiás'                ,52 ,'GO', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    10. 

  10. insert into {geo_states} (name, code, shortname, country_id) VALUES('Maranhão'             ,21 ,'MA', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    11. 

  11. insert into {geo_states} (name, code, shortname, country_id) VALUES('Mato Grosso'          ,51 ,'MT', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    12. 

  12. insert into {geo_states} (name, code, shortname, country_id) VALUES('Mato Grosso do Sul'   ,50 ,'MS', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    13. 

  13. insert into {geo_states} (name, code, shortname, country_id) VALUES('Minas Gerais'         ,31 ,'MG', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    14. 

  14. insert into {geo_states} (name, code, shortname, country_id) VALUES('Pará'                 ,15 ,'PA', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    15. 

  15. insert into {geo_states} (name, code, shortname, country_id) VALUES('Paraíba'	           ,25 ,'PB', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    16. 

  16. insert into {geo_states} (name, code, shortname, country_id) VALUES('Paraná'               ,41 ,'PR', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    17. 

  17. insert into {geo_states} (name, code, shortname, country_id) VALUES('Pernambuco'           ,26 ,'PE', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    18. 

  18. insert into {geo_states} (name, code, shortname, country_id) VALUES('Piauí'                ,22 ,'PI', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    19. 

  19. insert into {geo_states} (name, code, shortname, country_id) VALUES('Rio Grande do Norte'  ,24 ,'RN', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    20. 

  20. insert into {geo_states} (name, code, shortname, country_id) VALUES('Rio Grande do Sul'    ,43 ,'RS', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    21. 

  21. insert into {geo_states} (name, code, shortname, country_id) VALUES('Rio de Janeiro'       ,33 ,'RJ', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    22. 

  22. insert into {geo_states} (name, code, shortname, country_id) VALUES('Rondônia'             ,11 ,'RO', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    23. 

  23. insert into {geo_states} (name, code, shortname, country_id) VALUES('Roraima'              ,14 ,'RR', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    24. 

  24. insert into {geo_states} (name, code, shortname, country_id) VALUES('Santa Catarina'       ,42 ,'SC', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    25. 

  25. insert into {geo_states} (name, code, shortname, country_id) VALUES('São Paulo'            ,35 ,'SP', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    26. 

  26. insert into {geo_states} (name, code, shortname, country_id) VALUES('Sergipe'	           ,28 ,'SE', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    27. 

  27. insert into {geo_states} (name, code, shortname, country_id) VALUES('Tocantins'            ,17 ,'TO', (SELECT id FROM {geo_countries} WHERE iso3 = 'BRA'));
    28.