SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; ALTER TABLE `adminnotification_inbox` ENGINE = InnoDB; ALTER TABLE `admin_assert` ENGINE = InnoDB; ALTER TABLE `admin_role` ENGINE = InnoDB; ALTER TABLE `admin_rule` ENGINE = InnoDB; ALTER TABLE `admin_user` ENGINE = InnoDB; ALTER TABLE `api_assert` ENGINE = InnoDB; ALTER TABLE `api_role` ENGINE = InnoDB; ALTER TABLE `api_rule` ENGINE = InnoDB; ALTER TABLE `api_session` ENGINE = InnoDB; ALTER TABLE `api_user` ENGINE = InnoDB; ALTER TABLE `catalogindex_aggregation` ENGINE = InnoDB; ALTER TABLE `catalogindex_aggregation_tag` ENGINE = InnoDB; ALTER TABLE `catalogindex_aggregation_to_tag` ENGINE = InnoDB; ALTER TABLE `catalogindex_eav` ENGINE = InnoDB; ALTER TABLE `catalogindex_minimal_price` ENGINE = InnoDB; ALTER TABLE `catalogindex_price` ENGINE = InnoDB; ALTER TABLE `cataloginventory_stock` ENGINE = InnoDB; ALTER TABLE `cataloginventory_stock_item` ENGINE = InnoDB; ALTER TABLE `cataloginventory_stock_status` ENGINE = InnoDB; ALTER TABLE `cataloginventory_stock_status_idx` ENGINE = InnoDB; ALTER TABLE `catalogrule` ENGINE = InnoDB; ALTER TABLE `catalogrule_affected_product` ENGINE = InnoDB; ALTER TABLE `catalogrule_group_website` ENGINE = InnoDB; ALTER TABLE `catalogrule_product` ENGINE = InnoDB; ALTER TABLE `catalogrule_product_price` ENGINE = InnoDB; ALTER TABLE `catalogsearch_query` ENGINE = InnoDB; ALTER TABLE `catalogsearch_result` ENGINE = InnoDB; ALTER TABLE `catalog_category_anc_categs_index_idx` ENGINE = InnoDB; ALTER TABLE `catalog_category_anc_products_index_idx` ENGINE = InnoDB; ALTER TABLE `catalog_category_entity` ENGINE = InnoDB; ALTER TABLE `catalog_category_entity_datetime` ENGINE = InnoDB; ALTER TABLE `catalog_category_entity_decimal` ENGINE = InnoDB; ALTER TABLE `catalog_category_entity_int` ENGINE = InnoDB; ALTER TABLE `catalog_category_entity_text` ENGINE = InnoDB; ALTER TABLE `catalog_category_entity_varchar` ENGINE = InnoDB; ALTER TABLE `catalog_category_flat_store_1` ENGINE = InnoDB; ALTER TABLE `catalog_category_product` ENGINE = InnoDB; ALTER TABLE `catalog_category_product_index` ENGINE = InnoDB; ALTER TABLE `catalog_category_product_index_enbl_idx` ENGINE = InnoDB; ALTER TABLE `catalog_category_product_index_idx` ENGINE = InnoDB; ALTER TABLE `catalog_compare_item` ENGINE = InnoDB; ALTER TABLE `catalog_eav_attribute` ENGINE = InnoDB; ALTER TABLE `catalog_product_bundle_option` ENGINE = InnoDB; ALTER TABLE `catalog_product_bundle_option_value` ENGINE = InnoDB; ALTER TABLE `catalog_product_bundle_price_index` ENGINE = InnoDB; ALTER TABLE `catalog_product_bundle_selection` ENGINE = InnoDB; ALTER TABLE `catalog_product_bundle_stock_index` ENGINE = InnoDB; ALTER TABLE `catalog_product_enabled_index` ENGINE = InnoDB; ALTER TABLE `catalog_product_entity` ENGINE = InnoDB; ALTER TABLE `catalog_product_entity_datetime` ENGINE = InnoDB; ALTER TABLE `catalog_product_entity_decimal` ENGINE = InnoDB; ALTER TABLE `catalog_product_entity_gallery` ENGINE = InnoDB; ALTER TABLE `catalog_product_entity_int` ENGINE = InnoDB; ALTER TABLE `catalog_product_entity_media_gallery` ENGINE = InnoDB; ALTER TABLE `catalog_product_entity_media_gallery_value` ENGINE = InnoDB; ALTER TABLE `catalog_product_entity_text` ENGINE = InnoDB; ALTER TABLE `catalog_product_entity_tier_price` ENGINE = InnoDB; ALTER TABLE `catalog_product_entity_varchar` ENGINE = InnoDB; ALTER TABLE `catalog_product_flat_1` ENGINE = InnoDB; ALTER TABLE `catalog_product_index_eav` ENGINE = InnoDB; ALTER TABLE `catalog_product_index_eav_decimal` ENGINE = InnoDB; ALTER TABLE `catalog_product_index_eav_decimal_idx` ENGINE = InnoDB; ALTER TABLE `catalog_product_index_eav_idx` ENGINE = InnoDB; ALTER TABLE `catalog_product_index_price` ENGINE = InnoDB; ALTER TABLE `catalog_product_index_price_bundle_idx` ENGINE = InnoDB; ALTER TABLE `catalog_product_index_price_bundle_opt_idx` ENGINE = InnoDB; ALTER TABLE `catalog_product_index_price_bundle_sel_idx` ENGINE = InnoDB; ALTER TABLE `catalog_product_index_price_cfg_opt_agr_idx` ENGINE = InnoDB; ALTER TABLE `catalog_product_index_price_cfg_opt_idx` ENGINE = InnoDB; ALTER TABLE `catalog_product_index_price_downlod_idx` ENGINE = InnoDB; ALTER TABLE `catalog_product_index_price_final_idx` ENGINE = InnoDB; ALTER TABLE `catalog_product_index_price_idx` ENGINE = InnoDB; ALTER TABLE `catalog_product_index_price_opt_agr_idx` ENGINE = InnoDB; ALTER TABLE `catalog_product_index_price_opt_idx` ENGINE = InnoDB; ALTER TABLE `catalog_product_index_tier_price` ENGINE = InnoDB; ALTER TABLE `catalog_product_index_website` ENGINE = InnoDB; ALTER TABLE `catalog_product_link` ENGINE = InnoDB; ALTER TABLE `catalog_product_link_attribute` ENGINE = InnoDB; ALTER TABLE `catalog_product_link_attribute_decimal` ENGINE = InnoDB; ALTER TABLE `catalog_product_link_attribute_int` ENGINE = InnoDB; ALTER TABLE `catalog_product_link_attribute_varchar` ENGINE = InnoDB; ALTER TABLE `catalog_product_link_type` ENGINE = InnoDB; ALTER TABLE `catalog_product_option` ENGINE = InnoDB; ALTER TABLE `catalog_product_option_price` ENGINE = InnoDB; ALTER TABLE `catalog_product_option_title` ENGINE = InnoDB; ALTER TABLE `catalog_product_option_type_price` ENGINE = InnoDB; ALTER TABLE `catalog_product_option_type_title` ENGINE = InnoDB; ALTER TABLE `catalog_product_option_type_value` ENGINE = InnoDB; ALTER TABLE `catalog_product_relation` ENGINE = InnoDB; ALTER TABLE `catalog_product_super_attribute` ENGINE = InnoDB; ALTER TABLE `catalog_product_super_attribute_label` ENGINE = InnoDB; ALTER TABLE `catalog_product_super_attribute_pricing` ENGINE = InnoDB; ALTER TABLE `catalog_product_super_link` ENGINE = InnoDB; ALTER TABLE `catalog_product_website` ENGINE = InnoDB; ALTER TABLE `checkout_agreement` ENGINE = InnoDB; ALTER TABLE `checkout_agreement_store` ENGINE = InnoDB; ALTER TABLE `cms_block` ENGINE = InnoDB; ALTER TABLE `cms_block_store` ENGINE = InnoDB; ALTER TABLE `cms_page` ENGINE = InnoDB; ALTER TABLE `cms_page_store` ENGINE = InnoDB; ALTER TABLE `core_cache` ENGINE = InnoDB; ALTER TABLE `core_cache_option` ENGINE = InnoDB; ALTER TABLE `core_cache_tag` ENGINE = InnoDB; ALTER TABLE `core_config_data` ENGINE = InnoDB; ALTER TABLE `core_email_template` ENGINE = InnoDB; ALTER TABLE `core_flag` ENGINE = InnoDB; ALTER TABLE `core_layout_link` ENGINE = InnoDB; ALTER TABLE `core_layout_update` ENGINE = InnoDB; ALTER TABLE `core_resource` ENGINE = InnoDB; ALTER TABLE `core_session` ENGINE = InnoDB; ALTER TABLE `core_store` ENGINE = InnoDB; ALTER TABLE `core_store_group` ENGINE = InnoDB; ALTER TABLE `core_translate` ENGINE = InnoDB; ALTER TABLE `core_url_rewrite` ENGINE = InnoDB; ALTER TABLE `core_variable` ENGINE = InnoDB; ALTER TABLE `core_variable_value` ENGINE = InnoDB; ALTER TABLE `core_website` ENGINE = InnoDB; ALTER TABLE `coupon_aggregated` ENGINE = InnoDB; ALTER TABLE `coupon_aggregated_order` ENGINE = InnoDB; ALTER TABLE `cron_schedule` ENGINE = InnoDB; ALTER TABLE `customer_address_entity` ENGINE = InnoDB; ALTER TABLE `customer_address_entity_datetime` ENGINE = InnoDB; ALTER TABLE `customer_address_entity_decimal` ENGINE = InnoDB; ALTER TABLE `customer_address_entity_int` ENGINE = InnoDB; ALTER TABLE `customer_address_entity_text` ENGINE = InnoDB; ALTER TABLE `customer_address_entity_varchar` ENGINE = InnoDB; ALTER TABLE `customer_eav_attribute` ENGINE = InnoDB; ALTER TABLE `customer_entity` ENGINE = InnoDB; ALTER TABLE `customer_entity_datetime` ENGINE = InnoDB; ALTER TABLE `customer_entity_decimal` ENGINE = InnoDB; ALTER TABLE `customer_entity_int` ENGINE = InnoDB; ALTER TABLE `customer_entity_text` ENGINE = InnoDB; ALTER TABLE `customer_entity_varchar` ENGINE = InnoDB; ALTER TABLE `customer_group` ENGINE = InnoDB; ALTER TABLE `dataflow_batch` ENGINE = InnoDB; ALTER TABLE `dataflow_batch_export` ENGINE = InnoDB; ALTER TABLE `dataflow_batch_import` ENGINE = InnoDB; ALTER TABLE `dataflow_import_data` ENGINE = InnoDB; ALTER TABLE `dataflow_profile` ENGINE = InnoDB; ALTER TABLE `dataflow_profile_history` ENGINE = InnoDB; ALTER TABLE `dataflow_session` ENGINE = InnoDB; ALTER TABLE `design_change` ENGINE = InnoDB; ALTER TABLE `directory_country` ENGINE = InnoDB; ALTER TABLE `directory_country_format` ENGINE = InnoDB; ALTER TABLE `directory_country_region` ENGINE = InnoDB; ALTER TABLE `directory_country_region_name` ENGINE = InnoDB; ALTER TABLE `directory_currency_rate` ENGINE = InnoDB; ALTER TABLE `downloadable_link` ENGINE = InnoDB; ALTER TABLE `downloadable_link_price` ENGINE = InnoDB; ALTER TABLE `downloadable_link_purchased` ENGINE = InnoDB; ALTER TABLE `downloadable_link_purchased_item` ENGINE = InnoDB; ALTER TABLE `downloadable_link_title` ENGINE = InnoDB; ALTER TABLE `downloadable_sample` ENGINE = InnoDB; ALTER TABLE `downloadable_sample_title` ENGINE = InnoDB; ALTER TABLE `eav_attribute` ENGINE = InnoDB; ALTER TABLE `eav_attribute_group` ENGINE = InnoDB; ALTER TABLE `eav_attribute_label` ENGINE = InnoDB; ALTER TABLE `eav_attribute_option` ENGINE = InnoDB; ALTER TABLE `eav_attribute_option_value` ENGINE = InnoDB; ALTER TABLE `eav_attribute_set` ENGINE = InnoDB; ALTER TABLE `eav_entity` ENGINE = InnoDB; ALTER TABLE `eav_entity_attribute` ENGINE = InnoDB; ALTER TABLE `eav_entity_datetime` ENGINE = InnoDB; ALTER TABLE `eav_entity_decimal` ENGINE = InnoDB; ALTER TABLE `eav_entity_int` ENGINE = InnoDB; ALTER TABLE `eav_entity_store` ENGINE = InnoDB; ALTER TABLE `eav_entity_text` ENGINE = InnoDB; ALTER TABLE `eav_entity_type` ENGINE = InnoDB; ALTER TABLE `eav_entity_varchar` ENGINE = InnoDB; ALTER TABLE `eav_form_element` ENGINE = InnoDB; ALTER TABLE `eav_form_fieldset` ENGINE = InnoDB; ALTER TABLE `eav_form_fieldset_label` ENGINE = InnoDB; ALTER TABLE `eav_form_type` ENGINE = InnoDB; ALTER TABLE `eav_form_type_entity` ENGINE = InnoDB; ALTER TABLE `gift_message` ENGINE = InnoDB; ALTER TABLE `googlebase_attributes` ENGINE = InnoDB; ALTER TABLE `googlebase_items` ENGINE = InnoDB; ALTER TABLE `googlebase_types` ENGINE = InnoDB; ALTER TABLE `googlecheckout_api_debug` ENGINE = InnoDB; ALTER TABLE `googleoptimizer_code` ENGINE = InnoDB; ALTER TABLE `index_event` ENGINE = InnoDB; ALTER TABLE `index_process` ENGINE = InnoDB; ALTER TABLE `index_process_event` ENGINE = InnoDB; ALTER TABLE `log_customer` ENGINE = InnoDB; ALTER TABLE `log_quote` ENGINE = InnoDB; ALTER TABLE `log_summary` ENGINE = InnoDB; ALTER TABLE `log_summary_type` ENGINE = InnoDB; ALTER TABLE `log_url` ENGINE = InnoDB; ALTER TABLE `log_url_info` ENGINE = InnoDB; ALTER TABLE `log_visitor` ENGINE = InnoDB; ALTER TABLE `log_visitor_info` ENGINE = InnoDB; ALTER TABLE `log_visitor_online` ENGINE = InnoDB; ALTER TABLE `newsletter_problem` ENGINE = InnoDB; ALTER TABLE `newsletter_queue` ENGINE = InnoDB; ALTER TABLE `newsletter_queue_link` ENGINE = InnoDB; ALTER TABLE `newsletter_queue_store_link` ENGINE = InnoDB; ALTER TABLE `newsletter_subscriber` ENGINE = InnoDB; ALTER TABLE `newsletter_template` ENGINE = InnoDB; ALTER TABLE `paygate_authorizenet_debug` ENGINE = InnoDB; ALTER TABLE `paypaluk_api_debug` ENGINE = InnoDB; ALTER TABLE `paypal_api_debug` ENGINE = InnoDB; ALTER TABLE `paypal_settlement_report` ENGINE = InnoDB; ALTER TABLE `paypal_settlement_report_row` ENGINE = InnoDB; ALTER TABLE `poll` ENGINE = InnoDB; ALTER TABLE `poll_answer` ENGINE = InnoDB; ALTER TABLE `poll_store` ENGINE = InnoDB; ALTER TABLE `poll_vote` ENGINE = InnoDB; ALTER TABLE `product_alert_price` ENGINE = InnoDB; ALTER TABLE `product_alert_stock` ENGINE = InnoDB; ALTER TABLE `rating` ENGINE = InnoDB; ALTER TABLE `rating_entity` ENGINE = InnoDB; ALTER TABLE `rating_option` ENGINE = InnoDB; ALTER TABLE `rating_option_vote` ENGINE = InnoDB; ALTER TABLE `rating_option_vote_aggregated` ENGINE = InnoDB; ALTER TABLE `rating_store` ENGINE = InnoDB; ALTER TABLE `rating_title` ENGINE = InnoDB; ALTER TABLE `report_compared_product_index` ENGINE = InnoDB; ALTER TABLE `report_event` ENGINE = InnoDB; ALTER TABLE `report_event_types` ENGINE = InnoDB; ALTER TABLE `report_viewed_product_index` ENGINE = InnoDB; ALTER TABLE `review` ENGINE = InnoDB; ALTER TABLE `review_detail` ENGINE = InnoDB; ALTER TABLE `review_entity` ENGINE = InnoDB; ALTER TABLE `review_entity_summary` ENGINE = InnoDB; ALTER TABLE `review_status` ENGINE = InnoDB; ALTER TABLE `review_store` ENGINE = InnoDB; ALTER TABLE `salesrule` ENGINE = InnoDB; ALTER TABLE `salesrule_coupon` ENGINE = InnoDB; ALTER TABLE `salesrule_coupon_usage` ENGINE = InnoDB; ALTER TABLE `salesrule_customer` ENGINE = InnoDB; ALTER TABLE `salesrule_label` ENGINE = InnoDB; ALTER TABLE `sales_bestsellers_aggregated_daily` ENGINE = InnoDB; ALTER TABLE `sales_bestsellers_aggregated_monthly` ENGINE = InnoDB; ALTER TABLE `sales_bestsellers_aggregated_yearly` ENGINE = InnoDB; ALTER TABLE `sales_billing_agreement` ENGINE = InnoDB; ALTER TABLE `sales_billing_agreement_order` ENGINE = InnoDB; ALTER TABLE `sales_flat_creditmemo` ENGINE = InnoDB; ALTER TABLE `sales_flat_creditmemo_comment` ENGINE = InnoDB; ALTER TABLE `sales_flat_creditmemo_grid` ENGINE = InnoDB; ALTER TABLE `sales_flat_creditmemo_item` ENGINE = InnoDB; ALTER TABLE `sales_flat_invoice` ENGINE = InnoDB; ALTER TABLE `sales_flat_invoice_comment` ENGINE = InnoDB; ALTER TABLE `sales_flat_invoice_grid` ENGINE = InnoDB; ALTER TABLE `sales_flat_invoice_item` ENGINE = InnoDB; ALTER TABLE `sales_flat_order` ENGINE = InnoDB; ALTER TABLE `sales_flat_order_address` ENGINE = InnoDB; ALTER TABLE `sales_flat_order_grid` ENGINE = InnoDB; ALTER TABLE `sales_flat_order_item` ENGINE = InnoDB; ALTER TABLE `sales_flat_order_payment` ENGINE = InnoDB; ALTER TABLE `sales_flat_order_status_history` ENGINE = InnoDB; ALTER TABLE `sales_flat_quote` ENGINE = InnoDB; ALTER TABLE `sales_flat_quote_address` ENGINE = InnoDB; ALTER TABLE `sales_flat_quote_address_item` ENGINE = InnoDB; ALTER TABLE `sales_flat_quote_item` ENGINE = InnoDB; ALTER TABLE `sales_flat_quote_item_option` ENGINE = InnoDB; ALTER TABLE `sales_flat_quote_payment` ENGINE = InnoDB; ALTER TABLE `sales_flat_quote_shipping_rate` ENGINE = InnoDB; ALTER TABLE `sales_flat_shipment` ENGINE = InnoDB; ALTER TABLE `sales_flat_shipment_comment` ENGINE = InnoDB; ALTER TABLE `sales_flat_shipment_grid` ENGINE = InnoDB; ALTER TABLE `sales_flat_shipment_item` ENGINE = InnoDB; ALTER TABLE `sales_flat_shipment_track` ENGINE = InnoDB; ALTER TABLE `sales_invoiced_aggregated` ENGINE = InnoDB; ALTER TABLE `sales_invoiced_aggregated_order` ENGINE = InnoDB; ALTER TABLE `sales_order_aggregated_created` ENGINE = InnoDB; ALTER TABLE `sales_order_tax` ENGINE = InnoDB; ALTER TABLE `sales_payment_transaction` ENGINE = InnoDB; ALTER TABLE `sales_recurring_profile` ENGINE = InnoDB; ALTER TABLE `sales_recurring_profile_order` ENGINE = InnoDB; ALTER TABLE `sales_refunded_aggregated` ENGINE = InnoDB; ALTER TABLE `sales_refunded_aggregated_order` ENGINE = InnoDB; ALTER TABLE `sales_shipping_aggregated` ENGINE = InnoDB; ALTER TABLE `sales_shipping_aggregated_order` ENGINE = InnoDB; ALTER TABLE `shipping_tablerate` ENGINE = InnoDB; ALTER TABLE `sitemap` ENGINE = InnoDB; ALTER TABLE `tag` ENGINE = InnoDB; ALTER TABLE `tag_properties` ENGINE = InnoDB; ALTER TABLE `tag_relation` ENGINE = InnoDB; ALTER TABLE `tag_summary` ENGINE = InnoDB; ALTER TABLE `tax_calculation` ENGINE = InnoDB; ALTER TABLE `tax_calculation_rate` ENGINE = InnoDB; ALTER TABLE `tax_calculation_rate_title` ENGINE = InnoDB; ALTER TABLE `tax_calculation_rule` ENGINE = InnoDB; ALTER TABLE `tax_class` ENGINE = InnoDB; ALTER TABLE `tax_order_aggregated_created` ENGINE = InnoDB; ALTER TABLE `weee_discount` ENGINE = InnoDB; ALTER TABLE `weee_tax` ENGINE = InnoDB; ALTER TABLE `widget` ENGINE = InnoDB; ALTER TABLE `widget_instance` ENGINE = InnoDB; ALTER TABLE `widget_instance_page` ENGINE = InnoDB; ALTER TABLE `widget_instance_page_layout` ENGINE = InnoDB; ALTER TABLE `wishlist` ENGINE = InnoDB; ALTER TABLE `wishlist_item` ENGINE = InnoDB; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;