Skip to content

Instantly share code, notes, and snippets.

@elisei elisei/traducao.sql
Created Jul 3, 2018

Embed
What would you like to do?
SQL de tradução do magento 1 incluindo unidades federativas.
/* ============================================================================= */
/* VERSAO 1.9.x DO MAGENTO - ATUALIZACAO DE DADOS */
/* ============================================================================= */
SET NAMES 'utf8';
/* admin_role */
UPDATE `admin_role` SET `role_name`='Administradores' WHERE `role_name`='Administrators';
/* api2_acl_role */
/* UPDATE `api2_acl_role` SET `role_name`='Visitante' WHERE `role_name`='Guest'; */
/* UPDATE `api2_acl_role` SET `role_name`='Cliente' WHERE `role_name`='Customer'; */
/* catalog_category_entity_varchar */
/* Root Catalog, Default Category, Products */
/* cataloginventory_stock */
/* UPDATE `cataloginventory_stock` SET `stock_name`='Padrão' WHERE `stock_name`='Default'; */
/* cms_block */
UPDATE `cms_block` SET `title`='Links de Rodapé' WHERE `title`='Footer Links';
UPDATE `cms_block` SET `content`='<ul>\r\n<li><a href=\"{{store direct_url=\"about-magento-demo-store\"}}\">Sobre Nós</a></li>\r\n<li><a href=\"{{store direct_url=\"customer-service\"}}\">Central de Atendimento</a></li>\r\n<li class=\"last privacy\">\r\n<a href=\"{{store direct_url=\"privacy-policy-cookie-restriction-mode\"}}\">Política de Privacidade</a></li>\r\n</ul>' WHERE `content`='<ul>\r\n<li><a href=\"{{store direct_url=\"about-magento-demo-store\"}}\">About Us</a></li>\r\n<li><a href=\"{{store direct_url=\"customer-service\"}}\">Customer Service</a></li>\r\n<li class=\"last privacy\">\r\n<a href=\"{{store direct_url=\"privacy-policy-cookie-restriction-mode\"}}\">Privacy Policy</a></li>\r\n</ul>';
/* cms_page */
UPDATE `cms_page` SET `title`='404 Não Encontrado' WHERE `title`='404 Not Found 1';
UPDATE `cms_page` SET `title`='Página Inicial' WHERE `title`='Home page';
UPDATE `cms_page` SET `title`='Sobre Nós' WHERE `title`='About Us';
UPDATE `cms_page` SET `title`='Central de Atendimento' WHERE `title`='Customer Service';
UPDATE `cms_page` SET `title`='Ativar Cookies' WHERE `title`='Enable Cookies';
UPDATE `cms_page` SET `title`='Política de Privacidade' WHERE `title`='Privacy Policy';
/* atualizar o content dessas paginas (?) */
/* core_config_data */
/* UPDATE `core_config_data` SET `value`='America/Sao_Paulo' WHERE `path`='general/locale/timezone'; */
/* UPDATE `core_config_data` SET `value`='BRL' WHERE `path`='currency/options/base'; */
/* UPDATE `core_config_data` SET `value`='BRL' WHERE `path`='currency/options/default'; */
/* UPDATE `core_config_data` SET `value`='BRL' WHERE `path`='currency/options/allow'; */
/* UPDATE `core_config_data` SET `value`='BR' WHERE `path`='general/country/default'; */
/* core_store */
UPDATE `core_store` SET `name`='Português (Brasil)' WHERE `name`='Default Store View';
/* core_store_group */
UPDATE `core_store_group` SET `name`='Loja Principal' WHERE `name`='Main Website Store';
/* core_website */
UPDATE `core_website` SET `name`='Website Principal' WHERE `name`='Main Website';
/* customer_group */
UPDATE `customer_group` SET `customer_group_code`='Visitante' WHERE `customer_group_code`='NOT LOGGED IN';
UPDATE `customer_group` SET `customer_group_code`='Comum' WHERE `customer_group_code`='General';
UPDATE `customer_group` SET `customer_group_code`='Atacado' WHERE `customer_group_code`='Wholesale';
UPDATE `customer_group` SET `customer_group_code`='Revenda' WHERE `customer_group_code`='Retailer';
/* dataflow_profile */
UPDATE `dataflow_profile` SET `name`='Exportar Todos Produtos' WHERE `name`='Export All Products';
UPDATE `dataflow_profile` SET `name`='Exportar Estoque Produtos' WHERE `name`='Export Product Stocks';
UPDATE `dataflow_profile` SET `name`='Importar Todos Produtos' WHERE `name`='Import All Products';
UPDATE `dataflow_profile` SET `name`='Importar Estoque Produtos' WHERE `name`='Import Product Stocks';
UPDATE `dataflow_profile` SET `name`='Exportar Clientes' WHERE `name`='Export Customers';
UPDATE `dataflow_profile` SET `name`='Importar Clientes' WHERE `name`='Import Customers';
/* eav_attribute */
UPDATE `eav_attribute` SET `frontend_label`='Ativar Em' WHERE `frontend_label`='Active From';
UPDATE `eav_attribute` SET `frontend_label`='Ativar Até' WHERE `frontend_label`='Active To';
UPDATE `eav_attribute` SET `frontend_label`='Permitir Mensagem de Presente' WHERE `frontend_label`='Allow Gift Message';
UPDATE `eav_attribute` SET `frontend_label`='Aplicar MAP' WHERE `frontend_label`='Apply MAP';
UPDATE `eav_attribute` SET `frontend_label`='Aplicar Para' WHERE `frontend_label`='Apply To';
UPDATE `eav_attribute` SET `frontend_label`='Aplicar Produtos' WHERE `frontend_label`='Apply To Products';
UPDATE `eav_attribute` SET `frontend_label`='Associar ao Website' WHERE `frontend_label`='Associate to Website';
UPDATE `eav_attribute` SET `frontend_label`='Ordem de Listagem dos Produtos Disponíveis' WHERE `frontend_label`='Available Product Listing Sort by';
UPDATE `eav_attribute` SET `frontend_label`='Imagem Base' WHERE `frontend_label`='Base Image';
UPDATE `eav_attribute` SET `frontend_label`='Contagem' WHERE `frontend_label`='Children Count';
UPDATE `eav_attribute` SET `frontend_label`='Cidade' WHERE `frontend_label`='City';
UPDATE `eav_attribute` SET `frontend_label`='Bloco CMS' WHERE `frontend_label`='CMS Block';
UPDATE `eav_attribute` SET `frontend_label`='Empresa' WHERE `frontend_label`='Company';
UPDATE `eav_attribute` SET `frontend_label`='Custo' WHERE `frontend_label`='Cost';
UPDATE `eav_attribute` SET `frontend_label`='Cor' WHERE `frontend_label`='Color';
UPDATE `eav_attribute` SET `frontend_label`='País' WHERE `frontend_label`='Country';
UPDATE `eav_attribute` SET `frontend_label`='País Fabricante' WHERE `frontend_label`='Country of Manufacture';
UPDATE `eav_attribute` SET `frontend_label`='Criado Em' WHERE `frontend_label`='Create In';
UPDATE `eav_attribute` SET `frontend_label`='Criado Na' WHERE `frontend_label`='Created At';
UPDATE `eav_attribute` SET `frontend_label`='Criado na Loja' WHERE `frontend_label`='Created From';
UPDATE `eav_attribute` SET `frontend_label`='Design Personalizado' WHERE `frontend_label`='Custom Design';
UPDATE `eav_attribute` SET `frontend_label`='Atualização de Leiaute' WHERE `frontend_label`='Custom Layout Update';
UPDATE `eav_attribute` SET `frontend_label`='Data de Nascimento' WHERE `frontend_label`='Date Of Birth';
UPDATE `eav_attribute` SET `frontend_label`='Endereço de Cobrança Padrão' WHERE `frontend_label`='Default Billing Address';
UPDATE `eav_attribute` SET `frontend_label`='Ordem de Listagem Padrão dos Produtos' WHERE `frontend_label`='Default Product Listing Sort by';
UPDATE `eav_attribute` SET `frontend_label`='Endereço de Entrega Padrão' WHERE `frontend_label`='Default Shipping Address';
UPDATE `eav_attribute` SET `frontend_label`='Descrição' WHERE `frontend_label`='Description';
UPDATE `eav_attribute` SET `frontend_label`='Desabilitar Automaticamente Alterações de Grupo Baseado no ID VAT' WHERE `frontend_label`='Disable Automatic Group Change Based on VAT ID';
UPDATE `eav_attribute` SET `frontend_label`='Exibir Preço Atual' WHERE `frontend_label`='Display Actual Price';
UPDATE `eav_attribute` SET `frontend_label`='Modo de Exibição' WHERE `frontend_label`='Display Mode';
UPDATE `eav_attribute` SET `frontend_label`='Exibir Opções do Produto Em' WHERE `frontend_label`='Display Product Options In';
UPDATE `eav_attribute` SET `frontend_label`='Email' WHERE `frontend_label`='Email';
UPDATE `eav_attribute` SET `frontend_label`='Habilitar Perfil Recorrente' WHERE `frontend_label`='Enable Recurring Profile';
UPDATE `eav_attribute` SET `frontend_label`='Celular' WHERE `frontend_label`='Fax';
UPDATE `eav_attribute` SET `frontend_label`='Nome' WHERE `frontend_label`='First Name';
UPDATE `eav_attribute` SET `frontend_label`='Sexo' WHERE `frontend_label`='Gender';
UPDATE `eav_attribute` SET `frontend_label`='Grupo' WHERE `frontend_label`='Group';
UPDATE `eav_attribute` SET `frontend_label`='Grupo de Preços' WHERE `frontend_label`='Group Price';
UPDATE `eav_attribute` SET `frontend_label`='Imagem' WHERE `frontend_label`='Image';
UPDATE `eav_attribute` SET `frontend_label`='Galeria de Imagens' WHERE `frontend_label`='Image Gallery';
UPDATE `eav_attribute` SET `frontend_label`='Descrição da Imagem' WHERE `frontend_label`='Image Label';
UPDATE `eav_attribute` SET `frontend_label`='Incluir no Menu de Navegação' WHERE `frontend_label`='Include in Navigation Menu';
UPDATE `eav_attribute` SET `frontend_label`='Ativar' WHERE `frontend_label`='Is Active';
UPDATE `eav_attribute` SET `frontend_label`='Navegável' WHERE `frontend_label`='Is Anchor';
UPDATE `eav_attribute` SET `frontend_label`='Confirmado' WHERE `frontend_label`='Is Confirmed';
UPDATE `eav_attribute` SET `frontend_label`='Permitir Comprar Usando Google Checkout' WHERE `frontend_label`='Is Product Available for Purchase with Google Checkout';
UPDATE `eav_attribute` SET `frontend_label`='Sobrenome' WHERE `frontend_label`='Last Name';
UPDATE `eav_attribute` SET `frontend_label`='Camada de Navegação Etapa Preço' WHERE `frontend_label`='Layered Navigation Price Step';
UPDATE `eav_attribute` SET `frontend_label`='Nível' WHERE `frontend_label`='Level';
UPDATE `eav_attribute` SET `frontend_label`='Links podem ser adquiridos separadamente' WHERE `frontend_label`='Links can be purchased separately';
UPDATE `eav_attribute` SET `frontend_label`='Título do Link' WHERE `frontend_label`='Links title';
UPDATE `eav_attribute` SET `frontend_label`='Fabricante' WHERE `frontend_label`='Manufacturer';
UPDATE `eav_attribute` SET `frontend_label`='Preço de Venda Sugerido pelo Fabricante' WHERE `frontend_label`='Manufacturer\'s Suggested Retail Price';
UPDATE `eav_attribute` SET `frontend_label`='Galeria de Mídia' WHERE `frontend_label`='Media Gallery';
UPDATE `eav_attribute` SET `frontend_label`='Descrição da Página' WHERE `frontend_label`='Meta Description';
UPDATE `eav_attribute` SET `frontend_label`='Palavras-Chave' WHERE `frontend_label`='Meta Keywords';
UPDATE `eav_attribute` SET `frontend_label`='Título da Página' WHERE `frontend_label`='Meta Title';
UPDATE `eav_attribute` SET `frontend_label`='Assinatura' WHERE `frontend_label`='Middle Name/Initial';
UPDATE `eav_attribute` SET `frontend_label`='Preço Mínimo' WHERE `frontend_label`='Minimal Price';
UPDATE `eav_attribute` SET `frontend_label`='Nome' WHERE `frontend_label`='Name';
UPDATE `eav_attribute` SET `frontend_label`='Formato da Página' WHERE `frontend_label`='Page Layout';
UPDATE `eav_attribute` SET `frontend_label`='Título da Página' WHERE `frontend_label`='Page Title';
UPDATE `eav_attribute` SET `frontend_label`='Caminho' WHERE `frontend_label`='Path';
UPDATE `eav_attribute` SET `frontend_label`='Situação' WHERE `frontend_label`='Position';
UPDATE `eav_attribute` SET `frontend_label`='Prefixo' WHERE `frontend_label`='Prefix';
UPDATE `eav_attribute` SET `frontend_label`='Preço' WHERE `frontend_label`='Price';
UPDATE `eav_attribute` SET `frontend_label`='Preço a Vista' WHERE `frontend_label`='Price View';
UPDATE `eav_attribute` SET `frontend_label`='Perfil de Pagamento Recorrente' WHERE `frontend_label`='Recurring Payment Profile';
UPDATE `eav_attribute` SET `frontend_label`='Título Amostra' WHERE `frontend_label`='Samples title';
UPDATE `eav_attribute` SET `frontend_label`='Novo Produto em' WHERE `frontend_label`='Set Product as New from Date';
UPDATE `eav_attribute` SET `frontend_label`='Novo Produto até' WHERE `frontend_label`='Set Product as New to Date';
UPDATE `eav_attribute` SET `frontend_label`='Entrega' WHERE `frontend_label`='Shipment';
UPDATE `eav_attribute` SET `frontend_label`='Descrição Resumida' WHERE `frontend_label`='Short Description';
UPDATE `eav_attribute` SET `frontend_label`='Código Identificador (SKU)' WHERE `frontend_label`='SKU';
UPDATE `eav_attribute` SET `frontend_label`='Imagem Reduzida' WHERE `frontend_label`='Small Image';
UPDATE `eav_attribute` SET `frontend_label`='Descrição Imagem Reduzida' WHERE `frontend_label`='Small Image Label';
UPDATE `eav_attribute` SET `frontend_label`='Preço Promocional' WHERE `frontend_label`='Special Price';
UPDATE `eav_attribute` SET `frontend_label`='Preço Promocional em' WHERE `frontend_label`='Special Price From Date';
UPDATE `eav_attribute` SET `frontend_label`='Preço Promocional até' WHERE `frontend_label`='Special Price To Date';
UPDATE `eav_attribute` SET `frontend_label`='Estado' WHERE `frontend_label`='State/Province';
UPDATE `eav_attribute` SET `frontend_label`='Status' WHERE `frontend_label`='Status';
UPDATE `eav_attribute` SET `frontend_label`='Endereço' WHERE `frontend_label`='Street Address';
UPDATE `eav_attribute` SET `frontend_label`='Sufixo' WHERE `frontend_label`='Suffix';
UPDATE `eav_attribute` SET `frontend_label`='Classe de Impostos' WHERE `frontend_label`='Tax Class';
UPDATE `eav_attribute` SET `frontend_label`='CPF/CNPJ' WHERE `frontend_label`='Tax/VAT Number';
UPDATE `eav_attribute` SET `frontend_label`='Telefone' WHERE `frontend_label`='Telephone';
UPDATE `eav_attribute` SET `frontend_label`='Miniatura' WHERE `frontend_label`='Thumbnail';
UPDATE `eav_attribute` SET `frontend_label`='Imagem Miniatura' WHERE `frontend_label`='Thumbnail Image';
UPDATE `eav_attribute` SET `frontend_label`='Descrição Miniatura' WHERE `frontend_label`='Thumbnail Label';
UPDATE `eav_attribute` SET `frontend_label`='Faixa de Preços' WHERE `frontend_label`='Tier Price';
UPDATE `eav_attribute` SET `frontend_label`='Nome na URL' WHERE `frontend_label`='URL Key';
UPDATE `eav_attribute` SET `frontend_label`='Utilizar Configurações das Categorias Acima' WHERE `frontend_label`='Use Parent Category Settings';
UPDATE `eav_attribute` SET `frontend_label`='CPF' WHERE `frontend_label`='VAT number';
UPDATE `eav_attribute` SET `frontend_label`='Validação de data do CPF' WHERE `frontend_label`='VAT number validation request date';
UPDATE `eav_attribute` SET `frontend_label`='Validação do ID do CPF' WHERE `frontend_label`='VAT number validation request ID';
UPDATE `eav_attribute` SET `frontend_label`='CPF validado com sucesso' WHERE `frontend_label`='VAT number validation request success';
UPDATE `eav_attribute` SET `frontend_label`='Validação de CPF' WHERE `frontend_label`='VAT number validity';
UPDATE `eav_attribute` SET `frontend_label`='Visibilidade' WHERE `frontend_label`='Visibility';
UPDATE `eav_attribute` SET `frontend_label`='Peso' WHERE `frontend_label`='Weight';
UPDATE `eav_attribute` SET `frontend_label`='CEP' WHERE `frontend_label`='Zip/Postal Code';
UPDATE `eav_attribute` SET `frontend_label`='Tamanho' WHERE `frontend_label`='Size';
/* eav_attribute_option_value */
UPDATE `eav_attribute_option_value` SET `value`='Masculino' WHERE `value`='Male';
UPDATE `eav_attribute_option_value` SET `value`='Feminino' WHERE `value`='Female';
/* eav_form_fieldset_label */
UPDATE `eav_form_fieldset_label` SET `label`='Informações Pessoais' WHERE `label`='Personal Information';
UPDATE `eav_form_fieldset_label` SET `label`='Informações de Endereços' WHERE `label`='Address Information';
/* poll */
UPDATE `poll` SET `poll_title`='Qual sua cor favorita' WHERE `poll_title`='What is your favorite color';
/* poll_answer */
UPDATE `poll_answer` SET `answer_title`='Verde' WHERE `answer_title`='Green';
UPDATE `poll_answer` SET `answer_title`='Vermelho' WHERE `answer_title`='Red';
UPDATE `poll_answer` SET `answer_title`='Preto' WHERE `answer_title`='Black';
UPDATE `poll_answer` SET `answer_title`='Magenta' WHERE `answer_title`='Magenta';
/* rating */
UPDATE `rating` SET `rating_code`='Qualidade' WHERE `rating_code`='Quality';
UPDATE `rating` SET `rating_code`='Aprovação' WHERE `rating_code`='Value';
UPDATE `rating` SET `rating_code`='Preço' WHERE `rating_code`='Price';
/* review_status - nao pode alterar o codigo pq eh usado em hardcode (!) */
/* UPDATE `review_status` SET `status_code`='Aprovado' WHERE `status_code`='Approved'; */
/* UPDATE `review_status` SET `status_code`='Pendente' WHERE `status_code`='Pending'; */
/* UPDATE `review_status` SET `status_code`='Reprovado' WHERE `status_code`='Not Approved'; */
/* sales_order_status */
UPDATE `sales_order_status` SET `label`='Cancelado' WHERE `label`='Canceled';
UPDATE `sales_order_status` SET `label`='Fechado' WHERE `label`='Closed';
UPDATE `sales_order_status` SET `label`='Completo' WHERE `label`='Complete';
UPDATE `sales_order_status` SET `label`='Suspeita de Fraude' WHERE `label`='Suspected Fraud';
UPDATE `sales_order_status` SET `label`='Segurado' WHERE `label`='On Hold';
UPDATE `sales_order_status` SET `label`='Análise de Pagamento' WHERE `label`='Payment Review';
UPDATE `sales_order_status` SET `label`='Reversão Cancelada do PayPal' WHERE `label`='PayPal Canceled Reversal';
UPDATE `sales_order_status` SET `label`='Reversão do PayPal' WHERE `label`='PayPal Reversed';
UPDATE `sales_order_status` SET `label`='Pendente' WHERE `label`='Pending';
UPDATE `sales_order_status` SET `label`='Pagamento Pendente' WHERE `label`='Pending Payment';
UPDATE `sales_order_status` SET `label`='PayPal Pendente' WHERE `label`='Pending PayPal';
UPDATE `sales_order_status` SET `label`='Processando' WHERE `label`='Processing';
/* tax_class */
/* UPDATE `tax_class` SET `class_name`='Mercadoria Tributável' WHERE `class_name`='Taxable Goods'; */
/* UPDATE `tax_class` SET `class_name`='Cliente Varejo' WHERE `class_name`='Retail Customer'; */
/* UPDATE `tax_class` SET `class_name`='Entrega' WHERE `class_name`='Shipping'; */
/* ============================================================================= */
/* VERSAO 1.9.x DO MAGENTO - INSERINDO DADOS */
/* ============================================================================= */
/* directory_country_region */
/* directory_country_region_name */
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'AC', 'Acre') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Acre') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Acre') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Acre') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'AL', 'Alagoas') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Alagoas') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Alagoas') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Alagoas') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'AP', 'Amapá') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Amapá') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Amapá') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Amapá') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'AM', 'Amazonas') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Amazonas') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Amazonas') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Amazonas') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'BA', 'Bahia') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Bahia') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Bahia') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Bahia') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'CE', 'Ceará') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Ceará') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Ceará') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Ceará') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'ES', 'Espírito Santo') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Espírito Santo') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Espírito Santo') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Espírito Santo') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'GO', 'Goiás') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Goiás') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Goiás') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Goiás') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'MA', 'Maranhão') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Maranhão') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Maranhão') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Maranhão') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'MT', 'Mato Grosso') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Mato Grosso') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Mato Grosso') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Mato Grosso') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'MS', 'Mato Grosso do Sul') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Mato Grosso do Sul') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Mato Grosso do Sul') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Mato Grosso do Sul') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'MG', 'Minas Gerais') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Minas Gerais') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Minas Gerais') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Minas Gerais') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'PA', 'Pará') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Pará') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Pará') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Pará') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'PB', 'Paraíba') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Paraíba') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Paraíba') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Paraíba') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'PR', 'Paraná') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Paraná') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Paraná') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Paraná') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'PE', 'Pernambuco') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Pernambuco') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Pernambuco') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Pernambuco') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'PI', 'Piauí') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Piauí') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Piauí') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Piauí') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'RJ', 'Rio de Janeiro') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Rio de Janeiro') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Rio de Janeiro') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Rio de Janeiro') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'RN', 'Rio Grande do Norte') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Rio Grande do Norte') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Rio Grande do Norte') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Rio Grande do Norte') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'RS', 'Rio Grande do Sul') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Rio Grande do Sul') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Rio Grande do Sul') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Rio Grande do Sul') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'RO', 'Rondônia') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Rondônia') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Rondônia') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Rondônia') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'RR', 'Roraima') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Roraima') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Roraima') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Roraima') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'SC', 'Santa Catarina') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Santa Catarina') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Santa Catarina') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Santa Catarina') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'SP', 'São Paulo') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='São Paulo') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'São Paulo') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='São Paulo') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'SE', 'Sergipe') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Sergipe') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Sergipe') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Sergipe') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'TO', 'Tocantins') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Tocantins') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Tocantins') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Tocantins') LIMIT 1;
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) SELECT * FROM (SELECT 'BR', 'DF', 'Distrito Federal') AS tmp WHERE NOT EXISTS (SELECT `default_name` FROM `directory_country_region` WHERE `default_name`='Distrito Federal') LIMIT 1;
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) SELECT * FROM (SELECT 'pt_BR', LAST_INSERT_ID(), 'Distrito Federal') AS tmp WHERE NOT EXISTS (SELECT `name` FROM `directory_country_region_name` WHERE `name`='Distrito Federal') LIMIT 1;
@malkahakuk

This comment has been minimized.

Copy link

commented Jul 10, 2019

A onde devo colocar esse text?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.