Guest User

Untitled

a guest
Jul 3rd, 2018
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 30.81 KB | None | 0 0
  1. /* ============================================================================= */
  2. /* VERSAO 1.9.x DO MAGENTO - ATUALIZACAO DE DADOS */
  3. /* ============================================================================= */
  4.  
  5. SET NAMES 'utf8';
  6.  
  7. /* admin_role */
  8. UPDATE `admin_role` SET `role_name`='Administradores' WHERE `role_name`='Administrators';
  9.  
  10. /* api2_acl_role */
  11. /* UPDATE `api2_acl_role` SET `role_name`='Visitante' WHERE `role_name`='Guest'; */
  12. /* UPDATE `api2_acl_role` SET `role_name`='Cliente' WHERE `role_name`='Customer'; */
  13.  
  14. /* catalog_category_entity_varchar */
  15. /* Root Catalog, Default Category, Products */
  16.  
  17. /* cataloginventory_stock */
  18. /* UPDATE `cataloginventory_stock` SET `stock_name`='Padrão' WHERE `stock_name`='Default'; */
  19.  
  20. /* cms_block */
  21. UPDATE `cms_block` SET `title`='Links de Rodapé' WHERE `title`='Footer Links';
  22. 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>';
  23.  
  24. /* cms_page */
  25. UPDATE `cms_page` SET `title`='404 Não Encontrado' WHERE `title`='404 Not Found 1';
  26. UPDATE `cms_page` SET `title`='Página Inicial' WHERE `title`='Home page';
  27. UPDATE `cms_page` SET `title`='Sobre Nós' WHERE `title`='About Us';
  28. UPDATE `cms_page` SET `title`='Central de Atendimento' WHERE `title`='Customer Service';
  29. UPDATE `cms_page` SET `title`='Ativar Cookies' WHERE `title`='Enable Cookies';
  30. UPDATE `cms_page` SET `title`='Política de Privacidade' WHERE `title`='Privacy Policy';
  31. /* atualizar o content dessas paginas (?) */
  32.  
  33. /* core_config_data */
  34. /* UPDATE `core_config_data` SET `value`='America/Sao_Paulo' WHERE `path`='general/locale/timezone'; */
  35. /* UPDATE `core_config_data` SET `value`='BRL' WHERE `path`='currency/options/base'; */
  36. /* UPDATE `core_config_data` SET `value`='BRL' WHERE `path`='currency/options/default'; */
  37. /* UPDATE `core_config_data` SET `value`='BRL' WHERE `path`='currency/options/allow'; */
  38. /* UPDATE `core_config_data` SET `value`='BR' WHERE `path`='general/country/default'; */
  39.  
  40. /* core_store */
  41. UPDATE `core_store` SET `name`='Português (Brasil)' WHERE `name`='Default Store View';
  42.  
  43. /* core_store_group */
  44. UPDATE `core_store_group` SET `name`='Loja Principal' WHERE `name`='Main Website Store';
  45.  
  46. /* core_website */
  47. UPDATE `core_website` SET `name`='Website Principal' WHERE `name`='Main Website';
  48.  
  49. /* customer_group */
  50. UPDATE `customer_group` SET `customer_group_code`='Visitante' WHERE `customer_group_code`='NOT LOGGED IN';
  51. UPDATE `customer_group` SET `customer_group_code`='Comum' WHERE `customer_group_code`='General';
  52. UPDATE `customer_group` SET `customer_group_code`='Atacado' WHERE `customer_group_code`='Wholesale';
  53. UPDATE `customer_group` SET `customer_group_code`='Revenda' WHERE `customer_group_code`='Retailer';
  54.  
  55. /* dataflow_profile */
  56. UPDATE `dataflow_profile` SET `name`='Exportar Todos Produtos' WHERE `name`='Export All Products';
  57. UPDATE `dataflow_profile` SET `name`='Exportar Estoque Produtos' WHERE `name`='Export Product Stocks';
  58. UPDATE `dataflow_profile` SET `name`='Importar Todos Produtos' WHERE `name`='Import All Products';
  59. UPDATE `dataflow_profile` SET `name`='Importar Estoque Produtos' WHERE `name`='Import Product Stocks';
  60. UPDATE `dataflow_profile` SET `name`='Exportar Clientes' WHERE `name`='Export Customers';
  61. UPDATE `dataflow_profile` SET `name`='Importar Clientes' WHERE `name`='Import Customers';
  62.  
  63. /* eav_attribute */
  64. UPDATE `eav_attribute` SET `frontend_label`='Ativar Em' WHERE `frontend_label`='Active From';
  65. UPDATE `eav_attribute` SET `frontend_label`='Ativar Até' WHERE `frontend_label`='Active To';
  66. UPDATE `eav_attribute` SET `frontend_label`='Permitir Mensagem de Presente' WHERE `frontend_label`='Allow Gift Message';
  67. UPDATE `eav_attribute` SET `frontend_label`='Aplicar MAP' WHERE `frontend_label`='Apply MAP';
  68. UPDATE `eav_attribute` SET `frontend_label`='Aplicar Para' WHERE `frontend_label`='Apply To';
  69. UPDATE `eav_attribute` SET `frontend_label`='Aplicar Produtos' WHERE `frontend_label`='Apply To Products';
  70. UPDATE `eav_attribute` SET `frontend_label`='Associar ao Website' WHERE `frontend_label`='Associate to Website';
  71. UPDATE `eav_attribute` SET `frontend_label`='Ordem de Listagem dos Produtos Disponíveis' WHERE `frontend_label`='Available Product Listing Sort by';
  72. UPDATE `eav_attribute` SET `frontend_label`='Imagem Base' WHERE `frontend_label`='Base Image';
  73. UPDATE `eav_attribute` SET `frontend_label`='Contagem' WHERE `frontend_label`='Children Count';
  74. UPDATE `eav_attribute` SET `frontend_label`='Cidade' WHERE `frontend_label`='City';
  75. UPDATE `eav_attribute` SET `frontend_label`='Bloco CMS' WHERE `frontend_label`='CMS Block';
  76. UPDATE `eav_attribute` SET `frontend_label`='Empresa' WHERE `frontend_label`='Company';
  77. UPDATE `eav_attribute` SET `frontend_label`='Custo' WHERE `frontend_label`='Cost';
  78. UPDATE `eav_attribute` SET `frontend_label`='Cor' WHERE `frontend_label`='Color';
  79. UPDATE `eav_attribute` SET `frontend_label`='País' WHERE `frontend_label`='Country';
  80. UPDATE `eav_attribute` SET `frontend_label`='País Fabricante' WHERE `frontend_label`='Country of Manufacture';
  81. UPDATE `eav_attribute` SET `frontend_label`='Criado Em' WHERE `frontend_label`='Create In';
  82. UPDATE `eav_attribute` SET `frontend_label`='Criado Na' WHERE `frontend_label`='Created At';
  83. UPDATE `eav_attribute` SET `frontend_label`='Criado na Loja' WHERE `frontend_label`='Created From';
  84. UPDATE `eav_attribute` SET `frontend_label`='Design Personalizado' WHERE `frontend_label`='Custom Design';
  85. UPDATE `eav_attribute` SET `frontend_label`='Atualização de Leiaute' WHERE `frontend_label`='Custom Layout Update';
  86. UPDATE `eav_attribute` SET `frontend_label`='Data de Nascimento' WHERE `frontend_label`='Date Of Birth';
  87. UPDATE `eav_attribute` SET `frontend_label`='Endereço de Cobrança Padrão' WHERE `frontend_label`='Default Billing Address';
  88. UPDATE `eav_attribute` SET `frontend_label`='Ordem de Listagem Padrão dos Produtos' WHERE `frontend_label`='Default Product Listing Sort by';
  89. UPDATE `eav_attribute` SET `frontend_label`='Endereço de Entrega Padrão' WHERE `frontend_label`='Default Shipping Address';
  90. UPDATE `eav_attribute` SET `frontend_label`='Descrição' WHERE `frontend_label`='Description';
  91. 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';
  92. UPDATE `eav_attribute` SET `frontend_label`='Exibir Preço Atual' WHERE `frontend_label`='Display Actual Price';
  93. UPDATE `eav_attribute` SET `frontend_label`='Modo de Exibição' WHERE `frontend_label`='Display Mode';
  94. UPDATE `eav_attribute` SET `frontend_label`='Exibir Opções do Produto Em' WHERE `frontend_label`='Display Product Options In';
  95. UPDATE `eav_attribute` SET `frontend_label`='Email' WHERE `frontend_label`='Email';
  96. UPDATE `eav_attribute` SET `frontend_label`='Habilitar Perfil Recorrente' WHERE `frontend_label`='Enable Recurring Profile';
  97. UPDATE `eav_attribute` SET `frontend_label`='Celular' WHERE `frontend_label`='Fax';
  98. UPDATE `eav_attribute` SET `frontend_label`='Nome' WHERE `frontend_label`='First Name';
  99. UPDATE `eav_attribute` SET `frontend_label`='Sexo' WHERE `frontend_label`='Gender';
  100. UPDATE `eav_attribute` SET `frontend_label`='Grupo' WHERE `frontend_label`='Group';
  101. UPDATE `eav_attribute` SET `frontend_label`='Grupo de Preços' WHERE `frontend_label`='Group Price';
  102. UPDATE `eav_attribute` SET `frontend_label`='Imagem' WHERE `frontend_label`='Image';
  103. UPDATE `eav_attribute` SET `frontend_label`='Galeria de Imagens' WHERE `frontend_label`='Image Gallery';
  104. UPDATE `eav_attribute` SET `frontend_label`='Descrição da Imagem' WHERE `frontend_label`='Image Label';
  105. UPDATE `eav_attribute` SET `frontend_label`='Incluir no Menu de Navegação' WHERE `frontend_label`='Include in Navigation Menu';
  106. UPDATE `eav_attribute` SET `frontend_label`='Ativar' WHERE `frontend_label`='Is Active';
  107. UPDATE `eav_attribute` SET `frontend_label`='Navegável' WHERE `frontend_label`='Is Anchor';
  108. UPDATE `eav_attribute` SET `frontend_label`='Confirmado' WHERE `frontend_label`='Is Confirmed';
  109. UPDATE `eav_attribute` SET `frontend_label`='Permitir Comprar Usando Google Checkout' WHERE `frontend_label`='Is Product Available for Purchase with Google Checkout';
  110. UPDATE `eav_attribute` SET `frontend_label`='Sobrenome' WHERE `frontend_label`='Last Name';
  111. UPDATE `eav_attribute` SET `frontend_label`='Camada de Navegação Etapa Preço' WHERE `frontend_label`='Layered Navigation Price Step';
  112. UPDATE `eav_attribute` SET `frontend_label`='Nível' WHERE `frontend_label`='Level';
  113. UPDATE `eav_attribute` SET `frontend_label`='Links podem ser adquiridos separadamente' WHERE `frontend_label`='Links can be purchased separately';
  114. UPDATE `eav_attribute` SET `frontend_label`='Título do Link' WHERE `frontend_label`='Links title';
  115. UPDATE `eav_attribute` SET `frontend_label`='Fabricante' WHERE `frontend_label`='Manufacturer';
  116. UPDATE `eav_attribute` SET `frontend_label`='Preço de Venda Sugerido pelo Fabricante' WHERE `frontend_label`='Manufacturer\'s Suggested Retail Price';
  117. UPDATE `eav_attribute` SET `frontend_label`='Galeria de Mídia' WHERE `frontend_label`='Media Gallery';
  118. UPDATE `eav_attribute` SET `frontend_label`='Descrição da Página' WHERE `frontend_label`='Meta Description';
  119. UPDATE `eav_attribute` SET `frontend_label`='Palavras-Chave' WHERE `frontend_label`='Meta Keywords';
  120. UPDATE `eav_attribute` SET `frontend_label`='Título da Página' WHERE `frontend_label`='Meta Title';
  121. UPDATE `eav_attribute` SET `frontend_label`='Assinatura' WHERE `frontend_label`='Middle Name/Initial';
  122. UPDATE `eav_attribute` SET `frontend_label`='Preço Mínimo' WHERE `frontend_label`='Minimal Price';
  123. UPDATE `eav_attribute` SET `frontend_label`='Nome' WHERE `frontend_label`='Name';
  124. UPDATE `eav_attribute` SET `frontend_label`='Formato da Página' WHERE `frontend_label`='Page Layout';
  125. UPDATE `eav_attribute` SET `frontend_label`='Título da Página' WHERE `frontend_label`='Page Title';
  126. UPDATE `eav_attribute` SET `frontend_label`='Caminho' WHERE `frontend_label`='Path';
  127. UPDATE `eav_attribute` SET `frontend_label`='Situação' WHERE `frontend_label`='Position';
  128. UPDATE `eav_attribute` SET `frontend_label`='Prefixo' WHERE `frontend_label`='Prefix';
  129. UPDATE `eav_attribute` SET `frontend_label`='Preço' WHERE `frontend_label`='Price';
  130. UPDATE `eav_attribute` SET `frontend_label`='Preço a Vista' WHERE `frontend_label`='Price View';
  131. UPDATE `eav_attribute` SET `frontend_label`='Perfil de Pagamento Recorrente' WHERE `frontend_label`='Recurring Payment Profile';
  132. UPDATE `eav_attribute` SET `frontend_label`='Título Amostra' WHERE `frontend_label`='Samples title';
  133. UPDATE `eav_attribute` SET `frontend_label`='Novo Produto em' WHERE `frontend_label`='Set Product as New from Date';
  134. UPDATE `eav_attribute` SET `frontend_label`='Novo Produto até' WHERE `frontend_label`='Set Product as New to Date';
  135. UPDATE `eav_attribute` SET `frontend_label`='Entrega' WHERE `frontend_label`='Shipment';
  136. UPDATE `eav_attribute` SET `frontend_label`='Descrição Resumida' WHERE `frontend_label`='Short Description';
  137. UPDATE `eav_attribute` SET `frontend_label`='Código Identificador (SKU)' WHERE `frontend_label`='SKU';
  138. UPDATE `eav_attribute` SET `frontend_label`='Imagem Reduzida' WHERE `frontend_label`='Small Image';
  139. UPDATE `eav_attribute` SET `frontend_label`='Descrição Imagem Reduzida' WHERE `frontend_label`='Small Image Label';
  140. UPDATE `eav_attribute` SET `frontend_label`='Preço Promocional' WHERE `frontend_label`='Special Price';
  141. UPDATE `eav_attribute` SET `frontend_label`='Preço Promocional em' WHERE `frontend_label`='Special Price From Date';
  142. UPDATE `eav_attribute` SET `frontend_label`='Preço Promocional até' WHERE `frontend_label`='Special Price To Date';
  143. UPDATE `eav_attribute` SET `frontend_label`='Estado' WHERE `frontend_label`='State/Province';
  144. UPDATE `eav_attribute` SET `frontend_label`='Status' WHERE `frontend_label`='Status';
  145. UPDATE `eav_attribute` SET `frontend_label`='Endereço' WHERE `frontend_label`='Street Address';
  146. UPDATE `eav_attribute` SET `frontend_label`='Sufixo' WHERE `frontend_label`='Suffix';
  147. UPDATE `eav_attribute` SET `frontend_label`='Classe de Impostos' WHERE `frontend_label`='Tax Class';
  148. UPDATE `eav_attribute` SET `frontend_label`='CPF/CNPJ' WHERE `frontend_label`='Tax/VAT Number';
  149. UPDATE `eav_attribute` SET `frontend_label`='Telefone' WHERE `frontend_label`='Telephone';
  150. UPDATE `eav_attribute` SET `frontend_label`='Miniatura' WHERE `frontend_label`='Thumbnail';
  151. UPDATE `eav_attribute` SET `frontend_label`='Imagem Miniatura' WHERE `frontend_label`='Thumbnail Image';
  152. UPDATE `eav_attribute` SET `frontend_label`='Descrição Miniatura' WHERE `frontend_label`='Thumbnail Label';
  153. UPDATE `eav_attribute` SET `frontend_label`='Faixa de Preços' WHERE `frontend_label`='Tier Price';
  154. UPDATE `eav_attribute` SET `frontend_label`='Nome na URL' WHERE `frontend_label`='URL Key';
  155. UPDATE `eav_attribute` SET `frontend_label`='Utilizar Configurações das Categorias Acima' WHERE `frontend_label`='Use Parent Category Settings';
  156. UPDATE `eav_attribute` SET `frontend_label`='CPF' WHERE `frontend_label`='VAT number';
  157. UPDATE `eav_attribute` SET `frontend_label`='Validação de data do CPF' WHERE `frontend_label`='VAT number validation request date';
  158. UPDATE `eav_attribute` SET `frontend_label`='Validação do ID do CPF' WHERE `frontend_label`='VAT number validation request ID';
  159. UPDATE `eav_attribute` SET `frontend_label`='CPF validado com sucesso' WHERE `frontend_label`='VAT number validation request success';
  160. UPDATE `eav_attribute` SET `frontend_label`='Validação de CPF' WHERE `frontend_label`='VAT number validity';
  161. UPDATE `eav_attribute` SET `frontend_label`='Visibilidade' WHERE `frontend_label`='Visibility';
  162. UPDATE `eav_attribute` SET `frontend_label`='Peso' WHERE `frontend_label`='Weight';
  163. UPDATE `eav_attribute` SET `frontend_label`='CEP' WHERE `frontend_label`='Zip/Postal Code';
  164. UPDATE `eav_attribute` SET `frontend_label`='Tamanho' WHERE `frontend_label`='Size';
  165.  
  166. /* eav_attribute_option_value */
  167. UPDATE `eav_attribute_option_value` SET `value`='Masculino' WHERE `value`='Male';
  168. UPDATE `eav_attribute_option_value` SET `value`='Feminino' WHERE `value`='Female';
  169.  
  170. /* eav_form_fieldset_label */
  171. UPDATE `eav_form_fieldset_label` SET `label`='Informações Pessoais' WHERE `label`='Personal Information';
  172. UPDATE `eav_form_fieldset_label` SET `label`='Informações de Endereços' WHERE `label`='Address Information';
  173.  
  174. /* poll */
  175. UPDATE `poll` SET `poll_title`='Qual sua cor favorita' WHERE `poll_title`='What is your favorite color';
  176.  
  177. /* poll_answer */
  178. UPDATE `poll_answer` SET `answer_title`='Verde' WHERE `answer_title`='Green';
  179. UPDATE `poll_answer` SET `answer_title`='Vermelho' WHERE `answer_title`='Red';
  180. UPDATE `poll_answer` SET `answer_title`='Preto' WHERE `answer_title`='Black';
  181. UPDATE `poll_answer` SET `answer_title`='Magenta' WHERE `answer_title`='Magenta';
  182.  
  183. /* rating */
  184. UPDATE `rating` SET `rating_code`='Qualidade' WHERE `rating_code`='Quality';
  185. UPDATE `rating` SET `rating_code`='Aprovação' WHERE `rating_code`='Value';
  186. UPDATE `rating` SET `rating_code`='Preço' WHERE `rating_code`='Price';
  187.  
  188. /* review_status - nao pode alterar o codigo pq eh usado em hardcode (!) */
  189. /* UPDATE `review_status` SET `status_code`='Aprovado' WHERE `status_code`='Approved'; */
  190. /* UPDATE `review_status` SET `status_code`='Pendente' WHERE `status_code`='Pending'; */
  191. /* UPDATE `review_status` SET `status_code`='Reprovado' WHERE `status_code`='Not Approved'; */
  192.  
  193. /* sales_order_status */
  194. UPDATE `sales_order_status` SET `label`='Cancelado' WHERE `label`='Canceled';
  195. UPDATE `sales_order_status` SET `label`='Fechado' WHERE `label`='Closed';
  196. UPDATE `sales_order_status` SET `label`='Completo' WHERE `label`='Complete';
  197. UPDATE `sales_order_status` SET `label`='Suspeita de Fraude' WHERE `label`='Suspected Fraud';
  198. UPDATE `sales_order_status` SET `label`='Segurado' WHERE `label`='On Hold';
  199. UPDATE `sales_order_status` SET `label`='Análise de Pagamento' WHERE `label`='Payment Review';
  200. UPDATE `sales_order_status` SET `label`='Reversão Cancelada do PayPal' WHERE `label`='PayPal Canceled Reversal';
  201. UPDATE `sales_order_status` SET `label`='Reversão do PayPal' WHERE `label`='PayPal Reversed';
  202. UPDATE `sales_order_status` SET `label`='Pendente' WHERE `label`='Pending';
  203. UPDATE `sales_order_status` SET `label`='Pagamento Pendente' WHERE `label`='Pending Payment';
  204. UPDATE `sales_order_status` SET `label`='PayPal Pendente' WHERE `label`='Pending PayPal';
  205. UPDATE `sales_order_status` SET `label`='Processando' WHERE `label`='Processing';
  206.  
  207. /* tax_class */
  208. /* UPDATE `tax_class` SET `class_name`='Mercadoria Tributável' WHERE `class_name`='Taxable Goods'; */
  209. /* UPDATE `tax_class` SET `class_name`='Cliente Varejo' WHERE `class_name`='Retail Customer'; */
  210. /* UPDATE `tax_class` SET `class_name`='Entrega' WHERE `class_name`='Shipping'; */
  211.  
  212. /* ============================================================================= */
  213. /* VERSAO 1.9.x DO MAGENTO - INSERINDO DADOS */
  214. /* ============================================================================= */
  215.  
  216. /* directory_country_region */
  217. /* directory_country_region_name */
  218.  
  219. 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;
  220. 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;
  221.  
  222. 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;
  223. 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;
  224.  
  225. 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;
  226. 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;
  227.  
  228. 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;
  229. 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;
  230.  
  231. 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;
  232. 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;
  233.  
  234. 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;
  235. 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;
  236.  
  237. 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;
  238. 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;
  239.  
  240. 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;
  241. 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;
  242.  
  243. 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;
  244. 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;
  245.  
  246. 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;
  247. 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;
  248.  
  249. 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;
  250. 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;
  251.  
  252. 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;
  253. 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;
  254.  
  255. 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;
  256. 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;
  257.  
  258. 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;
  259. 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;
  260.  
  261. 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;
  262. 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;
  263.  
  264. 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;
  265. 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;
  266.  
  267. 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;
  268. 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;
  269.  
  270. 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;
  271. 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;
  272.  
  273. 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;
  274. 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;
  275.  
  276. 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;
  277. 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;
  278.  
  279. 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;
  280. 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;
  281.  
  282. 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;
  283. 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;
  284.  
  285. 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;
  286. 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;
  287.  
  288. 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;
  289. 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;
  290.  
  291. 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;
  292. 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;
  293.  
  294. 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;
  295. 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;
  296.  
  297. 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;
  298. 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;
Add Comment
Please, Sign In to add comment