-- BCASH
UPDATE `oc_setting` SET `value`= ''           WHERE `code`='bcash' AND `key`='bcash_email';
UPDATE `oc_setting` SET `value`= 0            WHERE `code`='bcash' AND `key`='bcash_status';
UPDATE `oc_setting` SET `value`= MD5(NOW()+0) WHERE `code`='bcash' AND `key`='bcash_token';

-- CIELO
UPDATE `oc_setting` SET `value`= ''           WHERE `code`='cielo' AND `key`='cielo_afiliacao';
UPDATE `oc_setting` SET `value`= 0            WHERE `code`='cielo' AND `key`='cielo_status';
UPDATE `oc_setting` SET `value`= MD5(NOW()+0) WHERE `code`='cielo' AND `key`='cielo_chave';

-- CIELO CC
UPDATE `oc_setting` SET `value`= 'COPIE-E-COLE-SEU-MID-AQUI' WHERE `code`='cielo_cc' AND `key`='cielo_cc_merchant_id';
UPDATE `oc_setting` SET `value`= 0                           WHERE `code`='cielo_cc' AND `key`='cielo_cc_status';

-- CIELO SI
UPDATE `oc_setting` SET `value`= 'COPIE-E-COLE-SEU-MID-AQUI' WHERE `code`='cielo_si' AND `key`='cielo_si_merchant_id';
UPDATE `oc_setting` SET `value`= 0                           WHERE `code`='cielo_si' AND `key`='cielo_si_status';

-- CONFIG
UPDATE `oc_setting` SET `value`= ''           WHERE `code`='config' AND `key`='config_email';
UPDATE `oc_setting` SET `value`= MD5(NOW()+0) WHERE `code`='config' AND `key`='config_encryption';

UPDATE `oc_setting` SET `value`= '' WHERE `code`='config' AND `key`='config_ftp_hostname';
UPDATE `oc_setting` SET `value`= '' WHERE `code`='config' AND `key`='config_ftp_username';
UPDATE `oc_setting` SET `value`= '' WHERE `code`='config' AND `key`='config_ftp_password';
UPDATE `oc_setting` SET `value`= 0  WHERE `code`='config' AND `key`='config_ftp_status';

UPDATE `oc_setting` SET `value`= '' WHERE `code`='config' AND `key`='config_google_analytics';
UPDATE `oc_setting` SET `value`= 0  WHERE `code`='config' AND `key`='config_google_analytics_status';

UPDATE `oc_setting` SET `value`= '' WHERE `code`='config' AND `key`='config_google_captcha_public';
UPDATE `oc_setting` SET `value`= '' WHERE `code`='config' AND `key`='config_google_captcha_secret';
UPDATE `oc_setting` SET `value`= 0  WHERE `code`='config' AND `key`='config_google_captcha_status';

UPDATE `oc_setting` SET `value`= 'mail' WHERE `code`='config' AND `key`='config_mail_protocol';
UPDATE `oc_setting` SET `value`= ''     WHERE `code`='config' AND `key`='config_mail_parameter';
UPDATE `oc_setting` SET `value`= ''     WHERE `code`='config' AND `key`='config_mail_smtp_hostname';
UPDATE `oc_setting` SET `value`= ''     WHERE `code`='config' AND `key`='config_mail_smtp_username';
UPDATE `oc_setting` SET `value`= ''     WHERE `code`='config' AND `key`='config_mail_smtp_password';

-- CORREIOS
UPDATE `oc_setting` SET `value`= '' WHERE `code`='correios' AND `key`='correios_contrato_codigo';
UPDATE `oc_setting` SET `value`= '' WHERE `code`='correios' AND `key`='correios_contrato_senha';
UPDATE `oc_setting` SET `value`= '' WHERE `code`='correios' AND `key`='correios_postcode';
UPDATE `oc_setting` SET `value`= 0  WHERE `code`='correios' AND `key`='correios_status';

-- MOIP
UPDATE `oc_setting` SET `value`= 0                                  WHERE `code`='moip' AND `key`='moip_status';
UPDATE `oc_setting` SET `value`= 'GERE-SEU-TOKEN-NO-PAINEL-DO-MOIP' WHERE `code`='moip' AND `key`='moip_token';
UPDATE `oc_setting` SET `value`= 'GERE-SUA-CHAVE-NO-PAINEL-DO-MOIP' WHERE `code`='moip' AND `key`='moip_key';

-- PAGARME
UPDATE `oc_setting` SET `value`= 0                                     WHERE `code`='pagar_me_checkout' AND `key`='pagar_me_checkout_status';
UPDATE `oc_setting` SET `value`= 'GERE-SUA-CHAVE-NO-PAINEL-DO-PAGARME' WHERE `code`='pagar_me_checkout' AND `key`='pagar_me_checkout_criptografia';
UPDATE `oc_setting` SET `value`= 'GERE-SUA-CHAVE-NO-PAINEL-DO-PAGARME' WHERE `code`='pagar_me_checkout' AND `key`='pagar_me_checkout_api';

-- PAGSEGURO NORMAL
UPDATE `oc_setting` SET `value`= ''           WHERE `code`='pagseguro' AND `key`='pagseguro_email';
UPDATE `oc_setting` SET `value`= 0            WHERE `code`='pagseguro' AND `key`='pagseguro_status';
UPDATE `oc_setting` SET `value`= MD5(NOW()+0) WHERE `code`='pagseguro' AND `key`='pagseguro_token';

-- PAGSEGURO BOLETO
UPDATE `oc_setting` SET `value`= ''           WHERE `code`='pagseguro_boleto' AND `key`='pagseguro_boleto_email';
UPDATE `oc_setting` SET `value`= 0            WHERE `code`='pagseguro_boleto' AND `key`='pagseguro_boleto_status';
UPDATE `oc_setting` SET `value`= MD5(NOW()+0) WHERE `code`='pagseguro_boleto' AND `key`='pagseguro_boleto_token';

-- PAGSEGURO CREDIT CARD
UPDATE `oc_setting` SET `value`= ''           WHERE `code`='pagseguro_credit_card' AND `key`='pagseguro_credit_card_email';
UPDATE `oc_setting` SET `value`= 0            WHERE `code`='pagseguro_credit_card' AND `key`='pagseguro_credit_card_status';
UPDATE `oc_setting` SET `value`= MD5(NOW()+0) WHERE `code`='pagseguro_credit_card' AND `key`='pagseguro_credit_card_token';

-- PAGSEGURO EFT
UPDATE `oc_setting` SET `value`= ''           WHERE `code`='pagseguro_eft' AND `key`='pagseguro_eft_email';
UPDATE `oc_setting` SET `value`= 0            WHERE `code`='pagseguro_eft' AND `key`='pagseguro_eft_status';
UPDATE `oc_setting` SET `value`= MD5(NOW()+0) WHERE `code`='pagseguro_eft' AND `key`='pagseguro_eft_token';

-- PP_STANDARD
UPDATE `oc_setting` SET `value`= '' WHERE `code`='pp_standard_hdw' AND `key`='pp_standard_hdw_email';
UPDATE `oc_setting` SET `value`= 0  WHERE `code`='pp_standard_hdw' AND `key`='pp_standard_hdw_status';

-- OUTROS MODULOS
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='bank_transfer_hdw' AND `key`='bank_transfer_hdw_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='bndes'             AND `key`='bndes_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='boleto_manual'     AND `key`='boleto_manual_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='cheque_hdw'        AND `key`='cheque_hdw_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='cod'               AND `key`='cod_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='combinar'          AND `key`='combinar_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='combinar2'         AND `key`='combinar2_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='combinar3'         AND `key`='combinar3_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='combinar4'         AND `key`='combinar4_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='combinar5'         AND `key`='combinar5_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='desconto'          AND `key`='desconto_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='flat_hdw'          AND `key`='flat_hdw_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='free_hdw'          AND `key`='free_hdw_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='handling'          AND `key`='handling_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='item_hdw'          AND `key`='item_hdw_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='jadlog'            AND `key`='jadlog_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='jamef'             AND `key`='jamef_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='low_order_fee'     AND `key`='low_order_fee_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='mp_standard'       AND `key`='mp_standard_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='mp_ticket'         AND `key`='mp_ticket_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='mp_transparente'   AND `key`='mp_transparente_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='redepay'           AND `key`='redepay_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='sob_consulta'      AND `key`='sob_consulta_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='tax'               AND `key`='tax_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='totalexpress'      AND `key`='totalexpress_status';
UPDATE `oc_setting` SET `value`= 0 WHERE `code`='weight_hdw'        AND `key`='weight_hdw_status';

-- DESABILITA MOEDAS
UPDATE `oc_currency` SET `status`= 0 WHERE `currency_id`=1;
UPDATE `oc_currency` SET `status`= 0 WHERE `currency_id`=2;
UPDATE `oc_currency` SET `status`= 0 WHERE `currency_id`=3;

-- DESABILITA ENGLISH
UPDATE `oc_language` SET `status`= 0 WHERE `language_id`=1;
UPDATE `oc_language` SET `status`= 0 WHERE `language_id`=3;

-- LIMPA TABELAS
TRUNCATE TABLE `oc_address` ;
TRUNCATE TABLE `oc_affiliate` ;
TRUNCATE TABLE `oc_affiliate_activity` ;
TRUNCATE TABLE `oc_affiliate_login` ;
TRUNCATE TABLE `oc_affiliate_transaction` ;
TRUNCATE TABLE `oc_cielo_consultas` ;
TRUNCATE TABLE `oc_cielo_transacoes` ;
TRUNCATE TABLE `oc_coupon` ;
TRUNCATE TABLE `oc_coupon_category` ;
TRUNCATE TABLE `oc_coupon_history` ;
TRUNCATE TABLE `oc_coupon_product` ;
TRUNCATE TABLE `oc_customer` ;
TRUNCATE TABLE `oc_customer_activity` ;
TRUNCATE TABLE `oc_customer_ban_ip` ;
TRUNCATE TABLE `oc_customer_history` ;
TRUNCATE TABLE `oc_customer_ip` ;
TRUNCATE TABLE `oc_customer_login` ;
TRUNCATE TABLE `oc_customer_online` ;
TRUNCATE TABLE `oc_customer_reward` ;
TRUNCATE TABLE `oc_customer_transaction` ;
TRUNCATE TABLE `oc_download` ;
TRUNCATE TABLE `oc_download_description` ;
TRUNCATE TABLE `oc_order` ;
TRUNCATE TABLE `oc_order_custom_field` ;
TRUNCATE TABLE `oc_order_history` ;
TRUNCATE TABLE `oc_order_option` ;
TRUNCATE TABLE `oc_order_product` ;
TRUNCATE TABLE `oc_order_recurring` ;
TRUNCATE TABLE `oc_order_recurring_transaction` ;
TRUNCATE TABLE `oc_order_total` ;
TRUNCATE TABLE `oc_order_voucher` ;
TRUNCATE TABLE `oc_product_recurring` ;
TRUNCATE TABLE `oc_product_to_download` ;
TRUNCATE TABLE `oc_recurring` ;
TRUNCATE TABLE `oc_recurring_description` ;
TRUNCATE TABLE `oc_return` ;
TRUNCATE TABLE `oc_return_history` ;
TRUNCATE TABLE `oc_review` ;
TRUNCATE TABLE `oc_store` ;
TRUNCATE TABLE `oc_tax_class` ;
TRUNCATE TABLE `oc_tax_rate` ;
TRUNCATE TABLE `oc_tax_rate_to_customer_group` ;
TRUNCATE TABLE `oc_tax_rule` ;
TRUNCATE TABLE `oc_upload` ;
TRUNCATE TABLE `oc_voucher` ;
TRUNCATE TABLE `oc_voucher_history` ;

ALTER TABLE `oc_setting` CHANGE `value` `value` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

ALTER TABLE `oc_information_description` CHANGE `description` `description` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;

-- INSERE INFOS PADRAO
INSERT INTO `oc_address` (`address_id`, `customer_id`, `firstname`, `lastname`, `company`, `address_1`, `address_2`, `city`, `postcode`, `country_id`, `zone_id`, `custom_field`) VALUES
(1, 1, 'Desenvolvimento', 'Hotel da WEB', '', 'Rua XYZ', 'Centro', 'Curitiba', '81670-000', 30, 455, 'a:2:{s:6:"numero";s:4:"1234";s:11:"complemento";s:0:"";}');

INSERT INTO `oc_customer` (`customer_id`, `customer_group_id`, `store_id`, `firstname`, `lastname`, `email`, `telephone`, `fax`, `password`, `salt`, `cart`, `wishlist`, `newsletter`, `address_id`, `custom_field`, `ip`, `status`, `approved`, `safe`, `token`, `date_added`) VALUES
(1, 1, 0, 'Desenvolvimento', 'Hotel da WEB', 'desenvolvimento@hoteldaweb.com.br', '(41) 3333-3333', '', '41b62b102ba08ef37379cceb0d1c3e7ed554cd79', 'df79cc086', 'a:0:{}', 'a:3:{i:0;i:42;i:1;i:40;i:2;i:30;}', 0, 23, 'a:10:{s:10:"country_id";s:2:"30";s:7:"celular";s:15:"(41) 99876-5432";s:4:"sexo";s:1:"m";s:10:"nascimento";s:10:"2000-01-01";s:4:"tipo";s:1:"f";s:3:"cpf";s:14:"000.000.003-53";s:2:"rg";s:9:"123456789";s:5:"razao";s:0:"";s:4:"cnpj";s:0:"";s:2:"ie";s:0:"";}', '127.0.0.1', 1, 1, 0, '', '2015-09-29 15:28:02');

-- MODULES
TRUNCATE TABLE `oc_module`;
INSERT INTO `oc_module` (`module_id`, `name`, `code`, `setting`) VALUES
(30, 'Home Banner pequeno 1 (desktop) 720 x 300', 'banner', 'a:9:{s:4:"name";s:41:"Home Banner pequeno 1 (desktop) 720 x 300";s:9:"banner_id";s:3:"206";s:6:"screen";s:2:"lg";s:7:"columns";s:2:"c4";s:8:"cssclass";s:0:"";s:5:"width";s:3:"720";s:6:"height";s:3:"300";s:7:"timeout";s:1:"4";s:6:"status";s:1:"1";}'),
(69, 'Home Banner pequeno 1 (smartphone) 720 x 150', 'banner', 'a:9:{s:4:"name";s:44:"Home Banner pequeno 1 (smartphone) 720 x 150";s:9:"banner_id";s:3:"220";s:6:"screen";s:2:"sm";s:7:"columns";s:3:"c12";s:8:"cssclass";s:0:"";s:5:"width";s:3:"720";s:6:"height";s:3:"150";s:7:"timeout";s:1:"4";s:6:"status";s:1:"1";}'),
(44, 'Home Banner pequeno 1 (tablet) 440 x 400', 'banner', 'a:9:{s:4:"name";s:40:"Home Banner pequeno 1 (tablet) 440 x 400";s:9:"banner_id";s:3:"211";s:6:"screen";s:2:"md";s:7:"columns";s:2:"c4";s:8:"cssclass";s:0:"";s:5:"width";s:3:"440";s:6:"height";s:3:"400";s:7:"timeout";s:1:"4";s:6:"status";s:1:"1";}'),
(42, 'Home Banner pequeno 2 (desktop) 720 x 300', 'banner', 'a:9:{s:4:"name";s:41:"Home Banner pequeno 2 (desktop) 720 x 300";s:9:"banner_id";s:3:"209";s:6:"screen";s:2:"lg";s:7:"columns";s:2:"c4";s:8:"cssclass";s:0:"";s:5:"width";s:3:"720";s:6:"height";s:3:"300";s:7:"timeout";s:1:"4";s:6:"status";s:1:"1";}'),
(70, 'Home Banner pequeno 2 (smartphone) 720 x 150', 'banner', 'a:9:{s:4:"name";s:44:"Home Banner pequeno 2 (smartphone) 720 x 150";s:9:"banner_id";s:3:"221";s:6:"screen";s:2:"sm";s:7:"columns";s:3:"c12";s:8:"cssclass";s:0:"";s:5:"width";s:3:"720";s:6:"height";s:3:"150";s:7:"timeout";s:1:"4";s:6:"status";s:1:"1";}'),
(45, 'Home Banner pequeno 2 (tablet) 440 x 400', 'banner', 'a:9:{s:4:"name";s:40:"Home Banner pequeno 2 (tablet) 440 x 400";s:9:"banner_id";s:3:"212";s:6:"screen";s:2:"md";s:7:"columns";s:2:"c4";s:8:"cssclass";s:0:"";s:5:"width";s:3:"440";s:6:"height";s:3:"400";s:7:"timeout";s:1:"4";s:6:"status";s:1:"1";}'),
(43, 'Home Banner pequeno 3 (desktop) 720 x 300', 'banner', 'a:9:{s:4:"name";s:41:"Home Banner pequeno 3 (desktop) 720 x 300";s:9:"banner_id";s:3:"210";s:6:"screen";s:2:"lg";s:7:"columns";s:2:"c4";s:8:"cssclass";s:0:"";s:5:"width";s:3:"720";s:6:"height";s:3:"300";s:7:"timeout";s:1:"4";s:6:"status";s:1:"1";}'),
(71, 'Home Banner pequeno 3 (smartphone) 720 x 150', 'banner', 'a:9:{s:4:"name";s:44:"Home Banner pequeno 3 (smartphone) 720 x 150";s:9:"banner_id";s:3:"222";s:6:"screen";s:2:"sm";s:7:"columns";s:3:"c12";s:8:"cssclass";s:0:"";s:5:"width";s:3:"720";s:6:"height";s:3:"150";s:7:"timeout";s:1:"4";s:6:"status";s:1:"1";}'),
(46, 'Home Banner pequeno 3 (tablet) 440 x 400', 'banner', 'a:9:{s:4:"name";s:40:"Home Banner pequeno 3 (tablet) 440 x 400";s:9:"banner_id";s:3:"213";s:6:"screen";s:2:"md";s:7:"columns";s:2:"c4";s:8:"cssclass";s:0:"";s:5:"width";s:3:"440";s:6:"height";s:3:"400";s:7:"timeout";s:1:"4";s:6:"status";s:1:"1";}'),
(65, 'Rodapé Bcash (desktop/tablet) 1140 x 75', 'banner', 'a:9:{s:4:"name";s:40:"Rodapé Bcash (desktop/tablet) 1140 x 75";s:9:"banner_id";s:3:"216";s:6:"screen";s:4:"n-sm";s:7:"columns";s:3:"c12";s:8:"cssclass";s:0:"";s:5:"width";s:4:"1140";s:6:"height";s:2:"75";s:7:"timeout";s:1:"4";s:6:"status";s:1:"1";}'),
(66, 'Rodapé Bcash (smartphones) 720 x 140', 'banner', 'a:9:{s:4:"name";s:37:"Rodapé Bcash (smartphones) 720 x 140";s:9:"banner_id";s:3:"217";s:6:"screen";s:2:"sm";s:7:"columns";s:3:"c12";s:8:"cssclass";s:0:"";s:5:"width";s:3:"720";s:6:"height";s:3:"140";s:7:"timeout";s:1:"4";s:6:"status";s:1:"1";}'),
(63, 'Rodapé Pagseguro (desktop/tablet) 1140 x 75', 'banner', 'a:9:{s:4:"name";s:44:"Rodapé Pagseguro (desktop/tablet) 1140 x 75";s:9:"banner_id";s:3:"214";s:6:"screen";s:4:"n-sm";s:7:"columns";s:3:"c12";s:8:"cssclass";s:0:"";s:5:"width";s:4:"1140";s:6:"height";s:2:"75";s:7:"timeout";s:1:"4";s:6:"status";s:1:"1";}'),
(64, 'Rodapé Pagseguro (smartphones) 720 x 140', 'banner', 'a:9:{s:4:"name";s:41:"Rodapé Pagseguro (smartphones) 720 x 140";s:9:"banner_id";s:3:"215";s:6:"screen";s:2:"sm";s:7:"columns";s:3:"c12";s:8:"cssclass";s:0:"";s:5:"width";s:3:"720";s:6:"height";s:3:"140";s:7:"timeout";s:1:"4";s:6:"status";s:1:"1";}'),
(67, 'Rodapé Paypal (desktop/tablet) 1140 x 75', 'banner', 'a:9:{s:4:"name";s:41:"Rodapé Paypal (desktop/tablet) 1140 x 75";s:9:"banner_id";s:3:"218";s:6:"screen";s:4:"n-sm";s:7:"columns";s:3:"c12";s:8:"cssclass";s:0:"";s:5:"width";s:4:"1140";s:6:"height";s:2:"75";s:7:"timeout";s:1:"4";s:6:"status";s:1:"1";}'),
(68, 'Rodapé Paypal (smartphones) 720 x 140', 'banner', 'a:9:{s:4:"name";s:38:"Rodapé Paypal (smartphones) 720 x 140";s:9:"banner_id";s:3:"219";s:6:"screen";s:2:"sm";s:7:"columns";s:3:"c12";s:8:"cssclass";s:0:"";s:5:"width";s:3:"720";s:6:"height";s:3:"140";s:7:"timeout";s:1:"4";s:6:"status";s:1:"1";}'),
(33, 'Mais vendidos - Home', 'bestseller', 'a:8:{s:4:"name";s:20:"Mais vendidos - Home";s:6:"screen";s:0:"";s:7:"columns";s:1:"6";s:5:"title";a:2:{i:2;s:14:"Mais vendidos!";i:1;s:14:"Mais vendidos!";}s:5:"limit";s:1:"4";s:5:"width";s:3:"200";s:6:"height";s:3:"200";s:6:"status";s:1:"1";}'),
(29, 'Home Fabricantes', 'carousel', 'a:9:{s:4:"name";s:16:"Home Fabricantes";s:9:"banner_id";s:3:"208";s:6:"screen";s:0:"";s:7:"columns";s:1:"6";s:8:"cssclass";s:0:"";s:5:"width";s:3:"130";s:6:"height";s:3:"100";s:7:"timeout";s:1:"2";s:6:"status";s:1:"1";}'),
(49, 'Like Box - Home', 'fblikebox', 'a:10:{s:4:"name";s:15:"Like Box - Home";s:6:"screen";s:2:"lg";s:7:"columns";s:1:"3";s:4:"href";s:39:"https://www.facebook.com/opencartbrasil";s:6:"height";s:3:"490";s:13:"show_facepile";s:1:"1";s:10:"show_posts";s:1:"1";s:10:"hide_cover";s:1:"0";s:12:"small_header";s:1:"0";s:6:"status";s:1:"1";}'),
(28, 'Destaques - Home', 'featured', 'a:9:{s:4:"name";s:16:"Destaques - Home";s:6:"screen";s:0:"";s:7:"columns";s:1:"6";s:5:"title";a:2:{i:2;s:10:"Destaques!";i:1;s:9:"Featured!";}s:7:"product";a:4:{i:0;s:2:"40";i:1;s:2:"42";i:2;s:2:"30";i:3;s:2:"41";}s:5:"limit";s:1:"4";s:5:"width";s:3:"200";s:6:"height";s:3:"200";s:6:"status";s:1:"1";}'),
(75, 'Mensagem de manutenção', 'html', 'a:6:{s:4:"name";s:24:"Mensagem de manutenção";s:6:"screen";s:0:"";s:7:"columns";s:1:"6";s:8:"cssclass";s:14:"msg-manutencao";s:6:"status";s:1:"1";s:18:"module_description";a:3:{i:2;a:2:{s:5:"title";s:275:"<style>#content, .msg-manutencao h2, #header-nav, #header-main .col-xs-12:nth-child(2),  #header-main .col-xs-12:nth-child(3), #header-menu, #footer-main, .oc-banner { display:none; }#header-main .col-xs-12:nth-child(1){ width: 100%; text-align: center; }</style>";s:11:"description";s:525:"<div class="oc-content-inner"><div style="text-align: center;line-height: 1.5;"><span style="font-size: 24px; font-weight: bold;">No momento estamos realizando uma manutenção agendada. </span></div><span style="font-weight: bold;"><div style="text-align: center;line-height: 1.5;"><span style="font-size: 24px;">Estaremos de volta o mais rápido possível.</span></div></span></div>";}i:1;a:2:{s:5:"title";s:275:"<style>#content, .msg-manutencao h2, #header-nav, #header-main .col-xs-12:nth-child(2),  #header-main .col-xs-12:nth-child(3), #header-menu, #footer-main, .oc-banner { display:none; }#header-main .col-xs-12:nth-child(1){ width: 100%; text-align: center; }</style>";s:11:"description";s:525:"<div class="oc-content-inner"><div style="text-align: center;line-height: 1.5;"><span style="font-size: 24px; font-weight: bold;">No momento estamos realizando uma manutenção agendada. </span></div><span style="font-weight: bold;"><div style="text-align: center;line-height: 1.5;"><span style="font-size: 24px;">Estaremos de volta o mais rápido possível.</span></div></span></div>";}i:3;a:2:{s:5:"title";s:275:"<style>#content, .msg-manutencao h2, #header-nav, #header-main .col-xs-12:nth-child(2),  #header-main .col-xs-12:nth-child(3), #header-menu, #footer-main, .oc-banner { display:none; }#header-main .col-xs-12:nth-child(1){ width: 100%; text-align: center; }</style>";s:11:"description";s:525:"<div class="oc-content-inner"><div style="text-align: center;line-height: 1.5;"><span style="font-size: 24px; font-weight: bold;">No momento estamos realizando uma manutenção agendada. </span></div><span style="font-weight: bold;"><div style="text-align: center;line-height: 1.5;"><span style="font-size: 24px;">Estaremos de volta o mais rápido possível.</span></div></span></div>";}}}'),
(78, 'Selos de segurança no rodapé', 'html', 'a:6:{s:4:"name";s:30:"Selos de segurança no rodapé";s:6:"screen";s:0:"";s:7:"columns";s:1:"0";s:8:"cssclass";s:12:"selos-rodape";s:6:"status";s:1:"0";s:18:"module_description";a:3:{i:2;a:2:{s:5:"title";s:96:"<style>.selos-rodape { background:#333; } .selos-rodape h2 { display:none; }</style>";s:11:"description";s:1033:"<div class="container"><div style="padding:20px 0;"><div class="row"><div class="col-xs-12 text-center" style="margin:10px 0;"><a href="https://www.sslshopper.com/ssl-checker.html#hostname=seudominio.com.br" target="_blank"><img src="/image/catalog/selos/selo-lets-encrypt.png" title="Site seguro!" style="width:130px;"></a>   <img src="/image/catalog/selos/selo-norton-secured.png" title="Aprovado por Norton Secured" style="width:150px; margin:0 20px;">   <a href="https://www.google.com/transparencyreport/safebrowsing/diagnostic/index.html#url=https://seudominio.com.br/" target="_blank"><img src="/image/catalog/selos/selo-google-safe-browsing.png" title="Aprovado por Google Safe Browsing" style="width:150px;"></a></div></div></div></div>";}i:1;a:2:{s:5:"title";s:96:"<style>.selos-rodape { background:#333; } .selos-rodape h2 { display:none; }</style>";s:11:"description";s:1033:"<div class="container"><div style="padding:20px 0;"><div class="row"><div class="col-xs-12 text-center" style="margin:10px 0;"><a href="https://www.sslshopper.com/ssl-checker.html#hostname=seudominio.com.br" target="_blank"><img src="/image/catalog/selos/selo-lets-encrypt.png" title="Site seguro!" style="width:130px;"></a>   <img src="/image/catalog/selos/selo-norton-secured.png" title="Aprovado por Norton Secured" style="width:150px; margin:0 20px;">   <a href="https://www.google.com/transparencyreport/safebrowsing/diagnostic/index.html#url=https://seudominio.com.br/" target="_blank"><img src="/image/catalog/selos/selo-google-safe-browsing.png" title="Aprovado por Google Safe Browsing" style="width:150px;"></a></div></div></div></div>";}i:3;a:2:{s:5:"title";s:96:"<style>.selos-rodape { background:#333; } .selos-rodape h2 { display:none; }</style>";s:11:"description";s:1033:"<div class="container"><div style="padding:20px 0;"><div class="row"><div class="col-xs-12 text-center" style="margin:10px 0;"><a href="https://www.sslshopper.com/ssl-checker.html#hostname=seudominio.com.br" target="_blank"><img src="/image/catalog/selos/selo-lets-encrypt.png" title="Site seguro!" style="width:130px;"></a>   <img src="/image/catalog/selos/selo-norton-secured.png" title="Aprovado por Norton Secured" style="width:150px; margin:0 20px;">   <a href="https://www.google.com/transparencyreport/safebrowsing/diagnostic/index.html#url=https://seudominio.com.br/" target="_blank"><img src="/image/catalog/selos/selo-google-safe-browsing.png" title="Aprovado por Google Safe Browsing" style="width:150px;"></a></div></div></div></div>";}}}'),
(34, 'Novidades - Home', 'latest', 'a:8:{s:4:"name";s:16:"Novidades - Home";s:6:"screen";s:0:"";s:7:"columns";s:1:"6";s:5:"title";a:2:{i:2;s:10:"Novidades!";i:1;s:10:"Novidades!";}s:5:"limit";s:1:"8";s:5:"width";s:3:"200";s:6:"height";s:3:"200";s:6:"status";s:1:"1";}'),
(48, 'Aleatórios - Home', 'random', 'a:9:{s:4:"name";s:18:"Aleatórios - Home";s:6:"screen";s:0:"";s:7:"columns";s:1:"6";s:8:"cssclass";s:0:"";s:5:"title";a:2:{i:2;s:21:"Produtos aleatórios!";i:1;s:21:"Produtos aleatórios!";}s:5:"limit";s:1:"4";s:5:"width";s:3:"200";s:6:"height";s:3:"200";s:6:"status";s:1:"1";}'),
(76, 'Ajustes no layout', 'scripts', 'a:3:{s:4:"name";s:17:"Ajustes no layout";s:6:"status";s:1:"1";s:18:"module_description";a:3:{i:2;a:1:{s:11:"description";s:29:"<style>\r\n</style>";}i:1;a:1:{s:11:"description";s:29:"<style>\r\n</style>";}i:3;a:1:{s:11:"description";s:29:"<style>\r\n</style>";}}}'),
(77, 'Chat online', 'scripts', 'a:3:{s:4:"name";s:11:"Chat online";s:6:"status";s:1:"1";s:18:"module_description";a:3:{i:2;a:1:{s:11:"description";s:633:"<!-- CADASTRE-SE EM UM SERVIÇO DE CHAT PARA ATENDIMENTO ONLINE: -->\r\n<!-- https://www.zendesk.com.br/chat/ -->\r\n<!-- https://www.olark.com/ -->\r\n<!-- https://www.smartsupp.com/ -->\r\n<!-- https://www.livechatinc.com/kb/ -->\r\n<!-- https://www.jivochat.com.br/ -->\r\n<!-- https://www.contako.com.br/ -->\r\n<!-- https://www.tolvnow.com/ -->\r\n<!-- http://www.reweb.com.br/sistema-de-chat-para-atendimento-online-ao-cliente-pelo-site -->\r\n<!-- https://www.omnize.com.br/sistema-de-atendimento-e-chat-online-para-sites -->\r\n<!-- DEPOIS COPIE O CÓDIGO DO CHAT E COLE AQUI -->";}i:1;a:1:{s:11:"description";s:633:"<!-- CADASTRE-SE EM UM SERVIÇO DE CHAT PARA ATENDIMENTO ONLINE: -->\r\n<!-- https://www.zendesk.com.br/chat/ -->\r\n<!-- https://www.olark.com/ -->\r\n<!-- https://www.smartsupp.com/ -->\r\n<!-- https://www.livechatinc.com/kb/ -->\r\n<!-- https://www.jivochat.com.br/ -->\r\n<!-- https://www.contako.com.br/ -->\r\n<!-- https://www.tolvnow.com/ -->\r\n<!-- http://www.reweb.com.br/sistema-de-chat-para-atendimento-online-ao-cliente-pelo-site -->\r\n<!-- https://www.omnize.com.br/sistema-de-atendimento-e-chat-online-para-sites -->\r\n<!-- DEPOIS COPIE O CÓDIGO DO CHAT E COLE AQUI -->";}i:3;a:1:{s:11:"description";s:633:"<!-- CADASTRE-SE EM UM SERVIÇO DE CHAT PARA ATENDIMENTO ONLINE: -->\r\n<!-- https://www.zendesk.com.br/chat/ -->\r\n<!-- https://www.olark.com/ -->\r\n<!-- https://www.smartsupp.com/ -->\r\n<!-- https://www.livechatinc.com/kb/ -->\r\n<!-- https://www.jivochat.com.br/ -->\r\n<!-- https://www.contako.com.br/ -->\r\n<!-- https://www.tolvnow.com/ -->\r\n<!-- http://www.reweb.com.br/sistema-de-chat-para-atendimento-online-ao-cliente-pelo-site -->\r\n<!-- https://www.omnize.com.br/sistema-de-atendimento-e-chat-online-para-sites -->\r\n<!-- DEPOIS COPIE O CÓDIGO DO CHAT E COLE AQUI -->";}}}'),
(27, 'Home Banner grande (desktop/tablet) 1140 x 380', 'slideshow', 'a:9:{s:4:"name";s:46:"Home Banner grande (desktop/tablet) 1140 x 380";s:9:"banner_id";s:3:"207";s:6:"screen";s:4:"n-sm";s:7:"columns";s:1:"6";s:8:"cssclass";s:0:"";s:5:"width";s:4:"1140";s:6:"height";s:3:"380";s:7:"timeout";s:1:"5";s:6:"status";s:1:"1";}'),
(72, 'Home Banner grande (smartphones) 720 x 320', 'slideshow', 'a:9:{s:4:"name";s:42:"Home Banner grande (smartphones) 720 x 320";s:9:"banner_id";s:3:"223";s:6:"screen";s:2:"sm";s:7:"columns";s:1:"6";s:8:"cssclass";s:0:"";s:5:"width";s:3:"720";s:6:"height";s:3:"320";s:7:"timeout";s:1:"5";s:6:"status";s:1:"1";}'),
(32, 'Promoções - Home', 'special', 'a:8:{s:4:"name";s:18:"Promoções - Home";s:6:"screen";s:0:"";s:7:"columns";s:1:"3";s:5:"title";a:2:{i:2;s:12:"Promoções!";i:1;s:12:"Promoções!";}s:5:"limit";s:1:"2";s:5:"width";s:3:"200";s:6:"height";s:3:"200";s:6:"status";s:1:"1";}');

-- BANNERS
TRUNCATE TABLE `oc_banner`;
INSERT INTO `oc_banner` (`banner_id`, `name`, `status`) VALUES
(208, 'Carrossel Fabricantes', 1),
(207, 'Home Grande Slideshow (desktop/tablet) 1140 x 380', 1),
(223, 'Home Grande Slideshow (smartphones) 720 x 320', 1),
(206, 'Home Pequeno 1 (desktop) 720 x 300', 1),
(220, 'Home Pequeno 1 (smartphone) 720 x 150', 1),
(211, 'Home Pequeno 1 (tablet) 440 x 400', 1),
(209, 'Home Pequeno 2 (desktop) 720 x 300', 1),
(221, 'Home Pequeno 2 (smartphone) 720 x 150', 1),
(212, 'Home Pequeno 2 (tablet) 440 x 400', 1),
(210, 'Home Pequeno 3 (desktop) 720 x 300', 1),
(222, 'Home Pequeno 3 (smartphone) 720 x 150', 1),
(213, 'Home Pequeno 3 (tablet) 440 x 400', 1),
(216, 'Rodapé Bcash (desktop) 1140 x 75', 1),
(217, 'Rodapé Bcash (smartphones) 720 x 140', 1),
(214, 'Rodapé Pagseguro (desktop) 1140 x 75', 1),
(215, 'Rodapé Pagseguro (smartphones) 720 x 140', 1),
(218, 'Rodapé Paypal (desktop) 1140 x 75', 1),
(219, 'Rodapé Paypal (smartphones) 720 x 140', 1);

TRUNCATE TABLE `oc_banner_image`;
INSERT INTO `oc_banner_image` (`banner_image_id`, `banner_id`, `link`, `image`, `target`, `popup_width`, `popup_height`, `sort_order`) VALUES
(266, 206, '', 'catalog/banners/demo/banner-pequeno-1-desktop.png', 'new', 600, 400, 10),
(262, 207, '', 'catalog/banners/demo/banner-grande-1.png', 'new', 600, 400, 10),
(263, 207, '', 'catalog/banners/demo/banner-grande-2.png', 'new', 600, 400, 20),
(250, 208, '', 'catalog/fabricantes/canon.png', 'new', 600, 400, 10),
(251, 208, '', 'catalog/fabricantes/burgerking.png', 'new', 600, 400, 20),
(252, 208, '', 'catalog/fabricantes/cocacola.png', 'new', 600, 400, 30),
(253, 208, '', 'catalog/fabricantes/sony.png', 'new', 600, 400, 40),
(254, 208, '', 'catalog/fabricantes/redbull.png', 'new', 600, 400, 50),
(255, 208, '', 'catalog/fabricantes/nfl.png', 'new', 600, 400, 60),
(256, 208, '', 'catalog/fabricantes/harley.png', 'new', 600, 400, 70),
(257, 208, '', 'catalog/fabricantes/dell.png', 'new', 600, 400, 80),
(258, 208, '', 'catalog/fabricantes/disney.png', 'new', 600, 400, 90),
(259, 208, '', 'catalog/fabricantes/starbucks.png', 'new', 600, 400, 100),
(260, 208, '', 'catalog/fabricantes/nintendo.png', 'new', 600, 400, 110),
(261, 208, '', 'catalog/fabricantes/shell.png', 'new', 600, 400, 120),
(269, 209, '', 'catalog/banners/demo/banner-pequeno-2-desktop.png', 'new', 600, 400, 10),
(272, 210, '', 'catalog/banners/demo/banner-pequeno-3-desktop.png', 'new', 600, 400, 10),
(268, 211, '', 'catalog/banners/demo/banner-pequeno-1-tablet.png', 'new', 600, 400, 10),
(271, 212, '', 'catalog/banners/demo/banner-pequeno-2-tablet.png', 'new', 600, 400, 10),
(274, 213, '', 'catalog/banners/demo/banner-pequeno-3-tablet.png', 'new', 600, 400, 10),
(277, 214, '', 'catalog/banners/banner-rodape-pagseguro-desktop.png', 'new', 600, 400, 0),
(278, 215, '', 'catalog/banners/banner-rodape-pagseguro-smartphones.png', 'new', 600, 400, 0),
(275, 216, '', 'catalog/banners/banner-rodape-bcash-desktop.png', 'new', 600, 400, 0),
(276, 217, '', 'catalog/banners/banner-rodape-bcash-smartphones.png', 'new', 600, 400, 0),
(279, 218, '', 'catalog/banners/banner-rodape-paypal-desktop.png', 'new', 600, 400, 0),
(280, 219, '', 'catalog/banners/banner-rodape-paypal-smartphones.png', 'new', 600, 400, 0),
(267, 220, '', 'catalog/banners/demo/banner-pequeno-1-smartphone.png', 'new', 600, 400, 10),
(270, 221, '', 'catalog/banners/demo/banner-pequeno-2-smartphone.png', 'new', 600, 400, 10),
(273, 222, '', 'catalog/banners/demo/banner-pequeno-3-smartphone.png', 'new', 600, 400, 0),
(264, 223, '', 'catalog/banners/demo/banner-grande-1-smartphones.png', 'new', 600, 400, 10),
(265, 223, '', 'catalog/banners/demo/banner-grande-2-smartphones.png', 'new', 600, 400, 20);

TRUNCATE TABLE `oc_banner_image_description`;
INSERT INTO `oc_banner_image_description` (`banner_image_id`, `language_id`, `banner_id`, `title`) VALUES
(266, 1, 206, ''),
(266, 2, 206, ''),
(266, 3, 206, ''),
(262, 1, 207, ''),
(262, 2, 207, ''),
(262, 3, 207, ''),
(263, 1, 207, ''),
(263, 2, 207, ''),
(263, 3, 207, ''),
(250, 1, 208, ''),
(250, 2, 208, ''),
(250, 3, 208, ''),
(251, 1, 208, ''),
(251, 2, 208, ''),
(251, 3, 208, ''),
(252, 1, 208, ''),
(252, 2, 208, ''),
(252, 3, 208, ''),
(253, 1, 208, ''),
(253, 2, 208, ''),
(253, 3, 208, ''),
(254, 1, 208, ''),
(254, 2, 208, ''),
(254, 3, 208, ''),
(255, 1, 208, ''),
(255, 2, 208, ''),
(255, 3, 208, ''),
(256, 1, 208, ''),
(256, 2, 208, ''),
(256, 3, 208, ''),
(257, 1, 208, ''),
(257, 2, 208, ''),
(257, 3, 208, ''),
(258, 1, 208, ''),
(258, 2, 208, ''),
(258, 3, 208, ''),
(259, 1, 208, ''),
(259, 2, 208, ''),
(259, 3, 208, ''),
(260, 1, 208, ''),
(260, 2, 208, ''),
(260, 3, 208, ''),
(261, 1, 208, ''),
(261, 2, 208, ''),
(261, 3, 208, ''),
(269, 1, 209, ''),
(269, 2, 209, ''),
(269, 3, 209, ''),
(272, 1, 210, ''),
(272, 2, 210, ''),
(272, 3, 210, ''),
(268, 1, 211, ''),
(268, 2, 211, ''),
(268, 3, 211, ''),
(271, 1, 212, ''),
(271, 2, 212, ''),
(271, 3, 212, ''),
(274, 1, 213, ''),
(274, 2, 213, ''),
(274, 3, 213, ''),
(277, 1, 214, ''),
(277, 2, 214, ''),
(277, 3, 214, ''),
(278, 1, 215, ''),
(278, 2, 215, ''),
(278, 3, 215, ''),
(275, 1, 216, ''),
(275, 2, 216, ''),
(275, 3, 216, ''),
(276, 1, 217, ''),
(276, 2, 217, ''),
(276, 3, 217, ''),
(279, 1, 218, ''),
(279, 2, 218, ''),
(279, 3, 218, ''),
(280, 1, 219, ''),
(280, 2, 219, ''),
(280, 3, 219, ''),
(267, 1, 220, ''),
(267, 2, 220, ''),
(267, 3, 220, ''),
(270, 1, 221, ''),
(270, 2, 221, ''),
(270, 3, 221, ''),
(273, 1, 222, ''),
(273, 2, 222, ''),
(273, 3, 222, ''),
(264, 1, 223, ''),
(264, 2, 223, ''),
(264, 3, 223, ''),
(265, 1, 223, ''),
(265, 2, 223, ''),
(265, 3, 223, '');


ALTER TABLE `oc_address` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_affiliate` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_affiliate_activity` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_affiliate_login` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_affiliate_transaction` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_api` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_attribute` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_attribute_description` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_attribute_group` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_attribute_group_description` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_banner` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_banner_image` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_banner_image_description` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_category` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_category_description` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_category_filter` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_category_path` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_category_to_layout` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_category_to_store` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_cielo_consultas` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_cielo_transacoes` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_country` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_coupon` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_coupon_category` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_coupon_history` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_coupon_product` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_currency` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_customer` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_customer_activity` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_customer_ban_ip` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_customer_group` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_customer_group_description` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_customer_history` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_customer_ip` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_customer_login` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_customer_online` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_customer_reward` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_customer_transaction` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_custom_field` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_custom_field_customer_group` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_custom_field_description` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_custom_field_value` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_custom_field_value_description` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_download` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_download_description` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_event` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_extension` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_filter` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_filter_description` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_filter_group` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_filter_group_description` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_geo_zone` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_information` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_information_description` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_information_to_layout` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_information_to_store` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_language` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_layout` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_layout_module` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_layout_route` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_length_class` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_length_class_description` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_location` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_manufacturer` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_manufacturer_to_store` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_marketing` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_modification` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_module` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_openbay_faq` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_option` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_option_description` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_option_value` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_option_value_description` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_order` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_order_custom_field` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_order_history` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_order_option` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_order_product` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_order_recurring` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_order_recurring_transaction` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_order_status` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_order_total` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_order_voucher` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_product` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_product_attribute` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_product_description` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_product_discount` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_product_filter` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_product_image` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_product_option` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_product_option_combination` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_product_option_value` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_product_recurring` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_product_related` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_product_reward` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_product_special` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_product_to_category` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_product_to_download` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_product_to_layout` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_product_to_store` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_recurring` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_recurring_description` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_return` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_return_action` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_return_history` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_return_reason` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_return_status` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_review` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_setting` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_stock_status` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_store` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_tax_class` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_tax_rate` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_tax_rate_to_customer_group` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_tax_rule` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_upload` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_url_alias` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_user` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_user_group` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_voucher` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_voucher_history` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_voucher_theme` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_voucher_theme_description` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_weight_class` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_weight_class_description` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_zone` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `oc_zone_to_geo_zone` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

ALTER TABLE `oc_product` CHANGE `upc` `upc` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `oc_product` CHANGE `ean` `ean` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `oc_product` CHANGE `jan` `jan` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
ALTER TABLE `oc_product` CHANGE `isbn` `isbn` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;