-
- cberni
 -
Total Posts: 10
Joined: 2009-05-11
Santa Maria - RS / Brazil
|
--estados_do_brasil.sql
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES
(’BR’, ‘AC’, ‘Acre’),
(’BR’, ‘AL’, ‘Alagoas’),
(’BR’, ‘AP’, ‘Amapá’),
(’BR’, ‘AM’, ‘Amazonas’),
(’BR’, ‘BA’, ‘Bahia’),
(’BR’, ‘CE’, ‘Ceará’),
(’BR’, ‘ES’, ‘Espírito Santo’),
(’BR’, ‘GO’, ‘Goiás’),
(’BR’, ‘MA’, ‘Maranhão’),
(’BR’, ‘MT’, ‘Mato Grosso’),
(’BR’, ‘MS’, ‘Mato Grosso do Sul’),
(’BR’, ‘MG’, ‘Minas Gerais’),
(’BR’, ‘PA’, ‘Pará’),
(’BR’, ‘PB’, ‘Paraíba’),
(’BR’, ‘PR’, ‘Paraná’),
(’BR’, ‘PE’, ‘Pernambuco’),
(’BR’, ‘PI’, ‘Piauí’),
(’BR’, ‘RJ’, ‘Rio de Janeiro’),
(’BR’, ‘RN’, ‘Rio Grande do Norte’),
(’BR’, ‘RS’, ‘Rio Grande do Sul’),
(’BR’, ‘RO’, ‘Rondônia’),
(’BR’, ‘RR’, ‘Roraima’),
(’BR’, ‘SC’, ‘Santa Catarina’),
(’BR’, ‘SP’, ‘São Paulo’),
(’BR’, ‘SE’, ‘Sergipe’),
(’BR’, ‘TO’, ‘Tocantins’),
(’BR’, ‘DF’, ‘Distrito Federal’);
--verificar os valores da region Id da tabela para depois fazer o insert abaixo:
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES
(’pt_BR’, 278, ‘Acre’),
(’pt_BR’, 279, ‘Alagoas’),
(’pt_BR’, 280, ‘Amapá’),
(’pt_BR’, 281, ‘Amazonas’),
(’pt_BR’, 282, ‘Bahia’),
(’pt_BR’, 283, ‘Ceará’),
(’pt_BR’, 284, ‘Espírito Santo’),
(’pt_BR’, 285, ‘Goiás’),
(’pt_BR’, 286, ‘Maranhão’),
(’pt_BR’, 287, ‘Mato Grosso’),
(’pt_BR’, 288, ‘Mato Grosso do Sul’),
(’pt_BR’, 289, ‘Minas Gerais’),
(’pt_BR’, 290, ‘Pará’),
(’pt_BR’, 291, ‘Paraíba’),
(’pt_BR’, 292, ‘Paraná’),
(’pt_BR’, 293, ‘Pernambuco’),
(’pt_BR’, 294, ‘Piauí’),
(’pt_BR’, 295, ‘Rio de Janeiro’),
(’pt_BR’, 296, ‘Rio Grande do Norte’),
(’pt_BR’, 297, ‘Rio Grande do Sul’),
(’pt_BR’, 298, ‘Rondônia’),
(’pt_BR’, 299, ‘Roraima’),
(’pt_BR’, 300, ‘Santa Catarina’),
(’pt_BR’, 301, ‘São Paulo’),
(’pt_BR’, 302, ‘Sergipe’),
(’pt_BR’, 303, ‘Tocantins’),
(’pt_BR’, 304, ‘Distrito Federal’);
File Attachments
|
