When trying to upgrade a Magento 1.4.2.0 site I encountered the error ‘Cannot add foreign key constraint’, when trying to update the database to 1.5, 1.6, 1.7 or 1.8.
I was using a copy of the current website’s database, with fresh Magento 1.4.2.0 files.
General error: 1215 Cannot add foreign key constraint
Here’s the error in full;
Error in file: “/###/###/###/###/app/code/core/Mage/Catalog/sql/catalog_setup/upgrade-1.6.0.0.9-1.6.0.0.10.php” – SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint
Trace:
#0 /###/###/###/###/app/code/core/Mage/Core/Model/Resource/Setup.php(645): Mage::exception(‘Mage_Core’, ‘Error in file: …’)
#1 /###/###/###/###/app/code/core/Mage/Core/Model/Resource/Setup.php(437): Mage_Core_Model_Resource_Setup->_modifyResourceDb(‘upgrade’, ‘1.6.0.0.9’, ‘1.6.0.0.18’)
#2 /###/###/###/###/app/code/core/Mage/Core/Model/Resource/Setup.php(320): Mage_Core_Model_Resource_Setup->_upgradeResourceDb(‘1.6.0.0.9’, ‘1.6.0.0.18’)
#3 /###/###/###/###/app/code/core/Mage/Core/Model/Resource/Setup.php(235): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /###/###/###/###/app/code/core/Mage/Core/Model/App.php(417): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /###/###/###/###/app/code/core/Mage/Core/Model/App.php(343): Mage_Core_Model_App->_initModules()
#6 /###/###/###/###/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#7 /###/###/###/###/index.php(87): Mage::run(”, ‘store’)
#8 {main}
As this is now quite an old version of Magento (1.4.2) I found it hard to find anything relevant on discussion boards (Magento has since upgraded theirs so I needed to use Wayback machine to find working links).
Foreign key restraint discussion
The foreign key restraint posts in stackoverflow seemed to mostly concern custom code.
However I found one post where the author answered his own question that helped me resolve the issue.
Solution
Switching table engine from MyISAM to InnoDB
As I was migrating the site from another host, it was possible that the site was originally configured as InnoDB. I’ve never faced this issue before but as it was on a test server it wasn’t an issue to try.
However, you can’t convert all database tables from MyISAM into InnoDB without a script.
Stackoverflow again helped;
Run this SQL statement (in phpMyAdmin, SQL tab) to retrieve all the MyISAM tables in your database.
Replace value of the name_of_your_db
variable with your database name.
SET @DATABASE_NAME = 'name_of_your_db'; SELECT CONCAT('ALTER TABLE `', table_name, '` ENGINE=InnoDB;') AS sql_statements FROM information_schema.tables AS tb WHERE table_schema = @DATABASE_NAME AND `ENGINE` = 'MyISAM' AND `TABLE_TYPE` = 'BASE TABLE' ORDER BY table_name DESC;
Then copy the output code produced and run this as a new SQL query.
Here’s my code below;
ALTER TABLE `wishlist_item` ENGINE=InnoDB; ALTER TABLE `wishlist` ENGINE=InnoDB; ALTER TABLE `widget_instance_page_layout` ENGINE=InnoDB; ALTER TABLE `widget_instance_page` ENGINE=InnoDB; ALTER TABLE `widget_instance` ENGINE=InnoDB; ALTER TABLE `widget` ENGINE=InnoDB; ALTER TABLE `weee_tax` ENGINE=InnoDB; ALTER TABLE `weee_discount` ENGINE=InnoDB; ALTER TABLE `tax_order_aggregated_created` ENGINE=InnoDB; ALTER TABLE `tax_class` ENGINE=InnoDB; ALTER TABLE `tax_calculation_rule` ENGINE=InnoDB; ALTER TABLE `tax_calculation_rate_title` ENGINE=InnoDB; ALTER TABLE `tax_calculation_rate` ENGINE=InnoDB; ALTER TABLE `tax_calculation` ENGINE=InnoDB; ALTER TABLE `tag_summary` ENGINE=InnoDB; ALTER TABLE `tag_relation` ENGINE=InnoDB; ALTER TABLE `tag_properties` ENGINE=InnoDB; ALTER TABLE `tag` ENGINE=InnoDB; ALTER TABLE `smtppro_email_log` ENGINE=InnoDB; ALTER TABLE `sitemap` ENGINE=InnoDB; ALTER TABLE `shipping_tablerate` ENGINE=InnoDB; ALTER TABLE `shipping_matrixrate` ENGINE=InnoDB; ALTER TABLE `sendfriend_log` ENGINE=InnoDB; ALTER TABLE `sales_shipping_aggregated_order` ENGINE=InnoDB; ALTER TABLE `sales_shipping_aggregated` ENGINE=InnoDB; ALTER TABLE `sales_refunded_aggregated_order` ENGINE=InnoDB; ALTER TABLE `sales_refunded_aggregated` ENGINE=InnoDB; ALTER TABLE `sales_recurring_profile_order` ENGINE=InnoDB; ALTER TABLE `sales_recurring_profile` ENGINE=InnoDB; ALTER TABLE `sales_payment_transaction` ENGINE=InnoDB; ALTER TABLE `sales_order_tax` ENGINE=InnoDB; ALTER TABLE `sales_order_aggregated_created` ENGINE=InnoDB; ALTER TABLE `sales_invoiced_aggregated_order` ENGINE=InnoDB; ALTER TABLE `sales_invoiced_aggregated` ENGINE=InnoDB; ALTER TABLE `sales_flat_shipment_track` ENGINE=InnoDB; ALTER TABLE `sales_flat_shipment_item` ENGINE=InnoDB; ALTER TABLE `sales_flat_shipment_grid` ENGINE=InnoDB; ALTER TABLE `sales_flat_shipment_comment` ENGINE=InnoDB; ALTER TABLE `sales_flat_shipment` ENGINE=InnoDB; ALTER TABLE `sales_flat_quote_shipping_rate` ENGINE=InnoDB; ALTER TABLE `sales_flat_quote_payment` ENGINE=InnoDB; ALTER TABLE `sales_flat_quote_item_option` ENGINE=InnoDB; ALTER TABLE `sales_flat_quote_item` ENGINE=InnoDB; ALTER TABLE `sales_flat_quote_address_item` ENGINE=InnoDB; ALTER TABLE `sales_flat_quote_address` ENGINE=InnoDB; ALTER TABLE `sales_flat_quote` ENGINE=InnoDB; ALTER TABLE `sales_flat_order_status_history` ENGINE=InnoDB; ALTER TABLE `sales_flat_order_payment` ENGINE=InnoDB; ALTER TABLE `sales_flat_order_item` ENGINE=InnoDB; ALTER TABLE `sales_flat_order_grid` ENGINE=InnoDB; ALTER TABLE `sales_flat_order_address` ENGINE=InnoDB; ALTER TABLE `sales_flat_order` ENGINE=InnoDB; ALTER TABLE `sales_flat_invoice_item` ENGINE=InnoDB; ALTER TABLE `sales_flat_invoice_grid` ENGINE=InnoDB; ALTER TABLE `sales_flat_invoice_comment` ENGINE=InnoDB; ALTER TABLE `sales_flat_invoice` ENGINE=InnoDB; ALTER TABLE `sales_flat_creditmemo_item` ENGINE=InnoDB; ALTER TABLE `sales_flat_creditmemo_grid` ENGINE=InnoDB; ALTER TABLE `sales_flat_creditmemo_comment` ENGINE=InnoDB; ALTER TABLE `sales_flat_creditmemo` ENGINE=InnoDB; ALTER TABLE `sales_billing_agreement_order` ENGINE=InnoDB; ALTER TABLE `sales_billing_agreement` ENGINE=InnoDB; ALTER TABLE `sales_bestsellers_aggregated_yearly` ENGINE=InnoDB; ALTER TABLE `sales_bestsellers_aggregated_monthly` ENGINE=InnoDB; ALTER TABLE `sales_bestsellers_aggregated_daily` ENGINE=InnoDB; ALTER TABLE `salesrule_product_attribute` ENGINE=InnoDB; ALTER TABLE `salesrule_label` ENGINE=InnoDB; ALTER TABLE `salesrule_customer` ENGINE=InnoDB; ALTER TABLE `salesrule_coupon_usage` ENGINE=InnoDB; ALTER TABLE `salesrule_coupon` ENGINE=InnoDB; ALTER TABLE `salesrule` ENGINE=InnoDB; ALTER TABLE `sagepay_api_debug` ENGINE=InnoDB; ALTER TABLE `sagepaysuite_transaction_queue` ENGINE=InnoDB; ALTER TABLE `sagepaysuite_transaction` ENGINE=InnoDB; ALTER TABLE `sagepaysuite_tokencard` ENGINE=InnoDB; ALTER TABLE `sagepaysuite_session` ENGINE=InnoDB; ALTER TABLE `sagepaysuite_paypaltransaction` ENGINE=InnoDB; ALTER TABLE `sagepaysuite_fraud` ENGINE=InnoDB; ALTER TABLE `sagepaysuite_debug` ENGINE=InnoDB; ALTER TABLE `sagepaysuite_action` ENGINE=InnoDB; ALTER TABLE `sagepayreporting_fraud` ENGINE=InnoDB; ALTER TABLE `review_store` ENGINE=InnoDB; ALTER TABLE `review_status` ENGINE=InnoDB; ALTER TABLE `review_entity_summary` ENGINE=InnoDB; ALTER TABLE `review_entity` ENGINE=InnoDB; ALTER TABLE `review_detail` ENGINE=InnoDB; ALTER TABLE `review` ENGINE=InnoDB; ALTER TABLE `report_viewed_product_index` ENGINE=InnoDB; ALTER TABLE `report_event_types` ENGINE=InnoDB; ALTER TABLE `report_event` ENGINE=InnoDB; ALTER TABLE `report_compared_product_index` ENGINE=InnoDB; ALTER TABLE `rating_title` ENGINE=InnoDB; ALTER TABLE `rating_store` ENGINE=InnoDB; ALTER TABLE `rating_option_vote_aggregated` ENGINE=InnoDB; ALTER TABLE `rating_option_vote` ENGINE=InnoDB; ALTER TABLE `rating_option` ENGINE=InnoDB; ALTER TABLE `rating_entity` ENGINE=InnoDB; ALTER TABLE `rating` ENGINE=InnoDB; ALTER TABLE `protxDirect_TempData` ENGINE=InnoDB; ALTER TABLE `protxDirect_debug` ENGINE=InnoDB; ALTER TABLE `product_alert_stock` ENGINE=InnoDB; ALTER TABLE `product_alert_price` ENGINE=InnoDB; ALTER TABLE `productdebate` ENGINE=InnoDB; ALTER TABLE `poll_vote` ENGINE=InnoDB; ALTER TABLE `poll_store` ENGINE=InnoDB; ALTER TABLE `poll_answer` ENGINE=InnoDB; ALTER TABLE `poll` ENGINE=InnoDB; ALTER TABLE `permission_variable` ENGINE=InnoDB; ALTER TABLE `permission_block` ENGINE=InnoDB; ALTER TABLE `paypal_settlement_report_row` ENGINE=InnoDB; ALTER TABLE `paypal_settlement_report` ENGINE=InnoDB; ALTER TABLE `paypal_api_debug` ENGINE=InnoDB; ALTER TABLE `paypaluk_api_debug` ENGINE=InnoDB; ALTER TABLE `paygate_authorizenet_debug` ENGINE=InnoDB; ALTER TABLE `newsletter_template` ENGINE=InnoDB; ALTER TABLE `newsletter_subscriber` ENGINE=InnoDB; ALTER TABLE `newsletter_queue_store_link` ENGINE=InnoDB; ALTER TABLE `newsletter_queue_link` ENGINE=InnoDB; ALTER TABLE `newsletter_queue` ENGINE=InnoDB; ALTER TABLE `newsletter_problem` ENGINE=InnoDB; ALTER TABLE `log_visitor_online` ENGINE=InnoDB; ALTER TABLE `log_visitor_info` ENGINE=InnoDB; ALTER TABLE `log_visitor` ENGINE=InnoDB; ALTER TABLE `log_url_info` ENGINE=InnoDB; ALTER TABLE `log_url` ENGINE=InnoDB; ALTER TABLE `log_summary_type` ENGINE=InnoDB; ALTER TABLE `log_summary` ENGINE=InnoDB; ALTER TABLE `log_quote` ENGINE=InnoDB; ALTER TABLE `log_customer` ENGINE=InnoDB; ALTER TABLE `index_process_event` ENGINE=InnoDB; ALTER TABLE `index_process` ENGINE=InnoDB; ALTER TABLE `index_event` ENGINE=InnoDB; ALTER TABLE `googleoptimizer_code` ENGINE=InnoDB; ALTER TABLE `googlecheckout_notification` ENGINE=InnoDB; ALTER TABLE `googlecheckout_api_debug` ENGINE=InnoDB; ALTER TABLE `googlebase_types` ENGINE=InnoDB; ALTER TABLE `googlebase_items` ENGINE=InnoDB; ALTER TABLE `googlebase_attributes` ENGINE=InnoDB; ALTER TABLE `gift_message` ENGINE=InnoDB; ALTER TABLE `find_feed_import_codes` ENGINE=InnoDB; ALTER TABLE `eav_form_type_entity` ENGINE=InnoDB; ALTER TABLE `eav_form_type` ENGINE=InnoDB; ALTER TABLE `eav_form_fieldset_label` ENGINE=InnoDB; ALTER TABLE `eav_form_fieldset` ENGINE=InnoDB; ALTER TABLE `eav_form_element` ENGINE=InnoDB; ALTER TABLE `eav_entity_varchar` ENGINE=InnoDB; ALTER TABLE `eav_entity_type` ENGINE=InnoDB; ALTER TABLE `eav_entity_text` ENGINE=InnoDB; ALTER TABLE `eav_entity_store` ENGINE=InnoDB; ALTER TABLE `eav_entity_int` ENGINE=InnoDB; ALTER TABLE `eav_entity_decimal` ENGINE=InnoDB; ALTER TABLE `eav_entity_datetime` ENGINE=InnoDB; ALTER TABLE `eav_entity_attribute` ENGINE=InnoDB; ALTER TABLE `eav_entity` ENGINE=InnoDB; ALTER TABLE `eav_attribute_set` ENGINE=InnoDB; ALTER TABLE `eav_attribute_option_value` ENGINE=InnoDB; ALTER TABLE `eav_attribute_option` ENGINE=InnoDB; ALTER TABLE `eav_attribute_label` ENGINE=InnoDB; ALTER TABLE `eav_attribute_group` ENGINE=InnoDB; ALTER TABLE `eav_attribute` ENGINE=InnoDB; ALTER TABLE `downloadable_sample_title` ENGINE=InnoDB; ALTER TABLE `downloadable_sample` ENGINE=InnoDB; ALTER TABLE `downloadable_link_title` ENGINE=InnoDB; ALTER TABLE `downloadable_link_purchased_item` ENGINE=InnoDB; ALTER TABLE `downloadable_link_purchased` ENGINE=InnoDB; ALTER TABLE `downloadable_link_price` ENGINE=InnoDB; ALTER TABLE `downloadable_link` ENGINE=InnoDB; ALTER TABLE `directory_currency_rate` ENGINE=InnoDB; ALTER TABLE `directory_country_region_name` ENGINE=InnoDB; ALTER TABLE `directory_country_region` ENGINE=InnoDB; ALTER TABLE `directory_country_format` ENGINE=InnoDB; ALTER TABLE `directory_country` ENGINE=InnoDB; ALTER TABLE `design_change` ENGINE=InnoDB; ALTER TABLE `dataflow_session` ENGINE=InnoDB; ALTER TABLE `dataflow_profile_history` ENGINE=InnoDB; ALTER TABLE `dataflow_profile` ENGINE=InnoDB; ALTER TABLE `dataflow_import_data` ENGINE=InnoDB; ALTER TABLE `dataflow_batch_import` ENGINE=InnoDB; ALTER TABLE `dataflow_batch_export` ENGINE=InnoDB; ALTER TABLE `dataflow_batch` ENGINE=InnoDB; ALTER TABLE `custommenu_store` ENGINE=InnoDB; ALTER TABLE `custommenu` ENGINE=InnoDB; ALTER TABLE `customer_group` ENGINE=InnoDB; ALTER TABLE `customer_form_attribute` ENGINE=InnoDB; ALTER TABLE `customer_entity_varchar` ENGINE=InnoDB; ALTER TABLE `customer_entity_text` ENGINE=InnoDB; ALTER TABLE `customer_entity_int` ENGINE=InnoDB; ALTER TABLE `customer_entity_decimal` ENGINE=InnoDB; ALTER TABLE `customer_entity_datetime` ENGINE=InnoDB; ALTER TABLE `customer_entity` ENGINE=InnoDB; ALTER TABLE `customer_eav_attribute_website` ENGINE=InnoDB; ALTER TABLE `customer_eav_attribute` ENGINE=InnoDB; ALTER TABLE `customer_address_entity_varchar` ENGINE=InnoDB; ALTER TABLE `customer_address_entity_text` ENGINE=InnoDB; ALTER TABLE `customer_address_entity_int` ENGINE=InnoDB; ALTER TABLE `customer_address_entity_decimal` ENGINE=InnoDB; ALTER TABLE `customer_address_entity_datetime` ENGINE=InnoDB; ALTER TABLE `customer_address_entity` ENGINE=InnoDB; ALTER TABLE `cron_schedule` ENGINE=InnoDB; ALTER TABLE `coupon_aggregated_order` ENGINE=InnoDB; ALTER TABLE `coupon_aggregated` ENGINE=InnoDB; ALTER TABLE `core_variable_value` ENGINE=InnoDB; ALTER TABLE `core_variable` ENGINE=InnoDB; ALTER TABLE `core_url_rewrite` ENGINE=InnoDB; ALTER TABLE `core_translate` ENGINE=InnoDB; ALTER TABLE `core_store_group` ENGINE=InnoDB; ALTER TABLE `core_store` ENGINE=InnoDB; ALTER TABLE `core_session` ENGINE=InnoDB; ALTER TABLE `core_resource` ENGINE=InnoDB; ALTER TABLE `core_layout_update` ENGINE=InnoDB; ALTER TABLE `core_layout_link` ENGINE=InnoDB; ALTER TABLE `core_flag` ENGINE=InnoDB; ALTER TABLE `core_email_template` ENGINE=InnoDB; ALTER TABLE `core_config_data` ENGINE=InnoDB; ALTER TABLE `core_cache_tag` ENGINE=InnoDB; ALTER TABLE `core_cache_option` ENGINE=InnoDB; ALTER TABLE `core_cache` ENGINE=InnoDB; ALTER TABLE `cms_page_store` ENGINE=InnoDB; ALTER TABLE `cms_page` ENGINE=InnoDB; ALTER TABLE `cms_block_store` ENGINE=InnoDB; ALTER TABLE `cms_block` ENGINE=InnoDB; ALTER TABLE `checkout_agreement_store` ENGINE=InnoDB; ALTER TABLE `checkout_agreement` ENGINE=InnoDB; ALTER TABLE `catalog_product_super_link` ENGINE=InnoDB; ALTER TABLE `catalog_product_super_attribute_pricing` ENGINE=InnoDB; ALTER TABLE `catalog_product_super_attribute_label` ENGINE=InnoDB; ALTER TABLE `catalog_product_super_attribute` ENGINE=InnoDB; ALTER TABLE `catalog_product_relation` ENGINE=InnoDB; ALTER TABLE `catalog_product_option_type_value` ENGINE=InnoDB; ALTER TABLE `catalog_product_option_type_title` ENGINE=InnoDB; ALTER TABLE `catalog_product_option_type_price` ENGINE=InnoDB; ALTER TABLE `catalog_product_option_title` ENGINE=InnoDB; ALTER TABLE `catalog_product_option_price` ENGINE=InnoDB; ALTER TABLE `catalog_product_option` ENGINE=InnoDB; ALTER TABLE `catalog_product_link_type` ENGINE=InnoDB; ALTER TABLE `catalog_product_link_attribute_varchar` ENGINE=InnoDB; ALTER TABLE `catalog_product_link_attribute_int` ENGINE=InnoDB; ALTER TABLE `catalog_product_link_attribute_decimal` ENGINE=InnoDB; ALTER TABLE `catalog_product_link_attribute` ENGINE=InnoDB; ALTER TABLE `catalog_product_link` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_website` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_tier_price` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_opt_idx` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_opt_agr_idx` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_idx` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_final_idx` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_downlod_idx` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_cfg_opt_idx` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_cfg_opt_agr_id` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_bundle_sel_idx` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_bundle_opt_idx` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price_bundle_idx` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_price` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_eav_idx` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_eav_decimal_idx` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_eav_decimal` ENGINE=InnoDB; ALTER TABLE `catalog_product_index_eav` ENGINE=InnoDB; ALTER TABLE `catalog_product_flat_1` ENGINE=InnoDB; ALTER TABLE `catalog_product_entity_varchar` ENGINE=InnoDB; ALTER TABLE `catalog_product_entity_tier_price` ENGINE=InnoDB; ALTER TABLE `catalog_product_entity_text` ENGINE=InnoDB; ALTER TABLE `catalog_product_entity_media_gallery_value` ENGINE=InnoDB; ALTER TABLE `catalog_product_entity_media_gallery` ENGINE=InnoDB; ALTER TABLE `catalog_product_entity_int` ENGINE=InnoDB; ALTER TABLE `catalog_product_entity_gallery` ENGINE=InnoDB; ALTER TABLE `catalog_product_entity_decimal` ENGINE=InnoDB; ALTER TABLE `catalog_product_entity_datetime` ENGINE=InnoDB; ALTER TABLE `catalog_product_enabled_index` ENGINE=InnoDB; ALTER TABLE `catalog_product_bundle_stock_index` ENGINE=InnoDB; ALTER TABLE `catalog_product_bundle_selection_price` ENGINE=InnoDB; ALTER TABLE `catalog_product_bundle_selection` ENGINE=InnoDB; ALTER TABLE `catalog_product_bundle_price_index` ENGINE=InnoDB; ALTER TABLE `catalog_product_bundle_option_value` ENGINE=InnoDB; ALTER TABLE `catalog_product_bundle_option` ENGINE=InnoDB; ALTER TABLE `catalog_eav_attribute` ENGINE=InnoDB; ALTER TABLE `catalog_compare_item` ENGINE=InnoDB; ALTER TABLE `catalog_category_product_index_idx` ENGINE=InnoDB; ALTER TABLE `catalog_category_product_index_enbl_idx` ENGINE=InnoDB; ALTER TABLE `catalog_category_product_index` ENGINE=InnoDB; ALTER TABLE `catalog_category_product` ENGINE=InnoDB; ALTER TABLE `catalog_category_flat_store_1` ENGINE=InnoDB; ALTER TABLE `catalog_category_entity_varchar` ENGINE=InnoDB; ALTER TABLE `catalog_category_entity_text` ENGINE=InnoDB; ALTER TABLE `catalog_category_entity_int` ENGINE=InnoDB; ALTER TABLE `catalog_category_entity_decimal` ENGINE=InnoDB; ALTER TABLE `catalog_category_entity_datetime` ENGINE=InnoDB; ALTER TABLE `catalog_category_entity` ENGINE=InnoDB; ALTER TABLE `catalog_category_anc_products_index_idx` ENGINE=InnoDB; ALTER TABLE `catalog_category_anc_categs_index_idx` ENGINE=InnoDB; ALTER TABLE `catalogsearch_result` ENGINE=InnoDB; ALTER TABLE `catalogsearch_query` ENGINE=InnoDB; ALTER TABLE `catalogsearch_fulltext` ENGINE=InnoDB; ALTER TABLE `catalogrule_product_price` ENGINE=InnoDB; ALTER TABLE `catalogrule_product` ENGINE=InnoDB; ALTER TABLE `catalogrule_group_website` ENGINE=InnoDB; ALTER TABLE `catalogrule_affected_product` ENGINE=InnoDB; ALTER TABLE `catalogrule` ENGINE=InnoDB; ALTER TABLE `cataloginventory_stock_status_idx` ENGINE=InnoDB; ALTER TABLE `cataloginventory_stock_status` ENGINE=InnoDB; ALTER TABLE `cataloginventory_stock_item` ENGINE=InnoDB; ALTER TABLE `cataloginventory_stock` ENGINE=InnoDB; ALTER TABLE `catalogindex_price` ENGINE=InnoDB; ALTER TABLE `catalogindex_minimal_price` ENGINE=InnoDB; ALTER TABLE `catalogindex_eav` ENGINE=InnoDB; ALTER TABLE `catalogindex_aggregation_to_tag` ENGINE=InnoDB; ALTER TABLE `catalogindex_aggregation_tag` ENGINE=InnoDB; ALTER TABLE `catalogindex_aggregation` ENGINE=InnoDB; ALTER TABLE `api_user` ENGINE=InnoDB; ALTER TABLE `api_session` ENGINE=InnoDB; ALTER TABLE `api_rule` ENGINE=InnoDB; ALTER TABLE `api_role` ENGINE=InnoDB; ALTER TABLE `api_assert` ENGINE=InnoDB; ALTER TABLE `aitsys_status` ENGINE=InnoDB; ALTER TABLE `aitsys_news` ENGINE=InnoDB; ALTER TABLE `aitexporter_profile` ENGINE=InnoDB; ALTER TABLE `aitexporter_import_error` ENGINE=InnoDB; ALTER TABLE `aitexporter_import` ENGINE=InnoDB; ALTER TABLE `aitexporter_export_order` ENGINE=InnoDB; ALTER TABLE `aitexporter_export` ENGINE=InnoDB; ALTER TABLE `admin_user` ENGINE=InnoDB; ALTER TABLE `admin_rule` ENGINE=InnoDB; ALTER TABLE `admin_role` ENGINE=InnoDB; ALTER TABLE `admin_assert` ENGINE=InnoDB; ALTER TABLE `adminnotification_inbox` ENGINE=InnoDB;