Magento Forums
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

database repair tool

SOLVED
Go to solution
‎09-03-2015 09:24 AM
‎09-03-2015 09:24 AM

database repair tool

Hi everyone,

 

I just ran the database repair tool as a test on my test server. The first time it had a long list of required fixes and ended saying completed.

 

Is there anything in this log I should worry about when running it on the live server?

 

    Add missing foreign key(s) "FK_CATALOG_EAV_ATTRIBUTE_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID" to table "catalog_eav_attribute"
    Add missing foreign key(s) "FK_CAT_PRD_BNDL_OPT_PARENT_ID_CAT_PRD_ENTT_ENTT_ID" to table "catalog_product_bundle_option"
    Add missing foreign key(s) "FK_CAT_PRD_BNDL_OPT_VAL_OPT_ID_CAT_PRD_BNDL_OPT_OPT_ID" to table "catalog_product_bundle_option_value"
    Add missing foreign key(s) "FK_CAT_PRD_BNDL_PRICE_IDX_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID, FK_CAT_PRD_BNDL_PRICE_IDX_ENTT_ID_CAT_PRD_ENTT_ENTT_ID, FK_CAT_PRD_BNDL_PRICE_IDX_WS_ID_CORE_WS_WS_ID" to table "catalog_product_bundle_price_index"
    Add missing foreign key(s) "FK_CAT_PRD_BNDL_SELECTION_OPT_ID_CAT_PRD_BNDL_OPT_OPT_ID, FK_CAT_PRD_BNDL_SELECTION_PRD_ID_CAT_PRD_ENTT_ENTT_ID" to table "catalog_product_bundle_selection"
    Add missing foreign key(s) "FK_CAT_PRD_BNDL_SELECTION_PRICE_WS_ID_CORE_WS_WS_ID, FK_DCF37523AA05D770A70AA4ED7C2616E4" to table "catalog_product_bundle_selection_price"
    Add missing foreign key(s) "FK_CAT_PRD_ENABLED_IDX_PRD_ID_CAT_PRD_ENTT_ENTT_ID, FK_CATALOG_PRODUCT_ENABLED_INDEX_STORE_ID_CORE_STORE_STORE_ID" to table "catalog_product_enabled_index"
    Add missing foreign key(s) "FK_CAT_PRD_ENTT_ATTR_SET_ID_EAV_ATTR_SET_ATTR_SET_ID, FK_CAT_PRD_ENTT_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID" to table "catalog_product_entity"
    Add missing foreign key(s) "FK_CAT_PRD_ENTT_DTIME_ATTR_ID_EAV_ATTR_ATTR_ID, FK_CAT_PRD_ENTT_DTIME_ENTT_ID_CAT_PRD_ENTT_ENTT_ID, FK_CATALOG_PRODUCT_ENTITY_DATETIME_STORE_ID_CORE_STORE_STORE_ID" to table "catalog_product_entity_datetime"
    Add missing foreign key(s) "FK_CAT_PRD_ENTT_DEC_ATTR_ID_EAV_ATTR_ATTR_ID, FK_CAT_PRD_ENTT_DEC_ENTT_ID_CAT_PRD_ENTT_ENTT_ID, FK_CATALOG_PRODUCT_ENTITY_DECIMAL_STORE_ID_CORE_STORE_STORE_ID" to table "catalog_product_entity_decimal"
    Add missing foreign key(s) "FK_CAT_PRD_ENTT_GLR_ATTR_ID_EAV_ATTR_ATTR_ID, FK_CAT_PRD_ENTT_GLR_ENTT_ID_CAT_PRD_ENTT_ENTT_ID, FK_CATALOG_PRODUCT_ENTITY_GALLERY_STORE_ID_CORE_STORE_STORE_ID" to table "catalog_product_entity_gallery"
    Add missing foreign key(s) "FK_DF909D22C11B60B1E5E3EE64AB220ECE, FK_CAT_PRD_ENTT_GROUP_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID, FK_CAT_PRD_ENTT_GROUP_PRICE_WS_ID_CORE_WS_WS_ID" to table "catalog_product_entity_group_price"
    Add missing foreign key(s) "FK_CAT_PRD_ENTT_INT_ATTR_ID_EAV_ATTR_ATTR_ID, FK_CAT_PRD_ENTT_INT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID, FK_CATALOG_PRODUCT_ENTITY_INT_STORE_ID_CORE_STORE_STORE_ID" to table "catalog_product_entity_int"
    Add missing foreign key(s) "FK_CAT_PRD_ENTT_MDA_GLR_ATTR_ID_EAV_ATTR_ATTR_ID, FK_CAT_PRD_ENTT_MDA_GLR_ENTT_ID_CAT_PRD_ENTT_ENTT_ID" to table "catalog_product_entity_media_gallery"
    Add missing foreign key(s) "FK_CAT_PRD_ENTT_MDA_GLR_VAL_VAL_ID_CAT_PRD_ENTT_MDA_GLR_VAL_ID, FK_CAT_PRD_ENTT_MDA_GLR_VAL_STORE_ID_CORE_STORE_STORE_ID" to table "catalog_product_entity_media_gallery_value"
    Add missing foreign key(s) "FK_CAT_PRD_ENTT_TEXT_ATTR_ID_EAV_ATTR_ATTR_ID, FK_CAT_PRD_ENTT_TEXT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID, FK_CATALOG_PRODUCT_ENTITY_TEXT_STORE_ID_CORE_STORE_STORE_ID" to table "catalog_product_entity_text"
    Add missing foreign key(s) "FK_6E08D719F0501DD1D8E6D4EFF2511C85, FK_CAT_PRD_ENTT_TIER_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID, FK_CAT_PRD_ENTT_TIER_PRICE_WS_ID_CORE_WS_WS_ID" to table "catalog_product_entity_tier_price"
    Add missing foreign key(s) "FK_CAT_PRD_ENTT_VCHR_ATTR_ID_EAV_ATTR_ATTR_ID, FK_CAT_PRD_ENTT_VCHR_ENTT_ID_CAT_PRD_ENTT_ENTT_ID, FK_CATALOG_PRODUCT_ENTITY_VARCHAR_STORE_ID_CORE_STORE_STORE_ID" to table "catalog_product_entity_varchar"
    Add missing foreign key(s) "FK_CAT_PRD_IDX_EAV_ATTR_ID_EAV_ATTR_ATTR_ID, FK_CAT_PRD_IDX_EAV_ENTT_ID_CAT_PRD_ENTT_ENTT_ID, FK_CATALOG_PRODUCT_INDEX_EAV_STORE_ID_CORE_STORE_STORE_ID" to table "catalog_product_index_eav"
    Add missing foreign key(s) "FK_CAT_PRD_IDX_EAV_DEC_ATTR_ID_EAV_ATTR_ATTR_ID, FK_CAT_PRD_IDX_EAV_DEC_ENTT_ID_CAT_PRD_ENTT_ENTT_ID, FK_CAT_PRD_IDX_EAV_DEC_STORE_ID_CORE_STORE_STORE_ID" to table "catalog_product_index_eav_decimal"
    Add missing foreign key(s) "FK_195DF97C81B0BDD6A2EEC50F870E16D1, FK_CAT_PRD_IDX_GROUP_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID, FK_CAT_PRD_IDX_GROUP_PRICE_WS_ID_CORE_WS_WS_ID" to table "catalog_product_index_group_price"
    Add missing foreign key(s) "FK_CAT_PRD_IDX_PRICE_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID, FK_CAT_PRD_IDX_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID, FK_CAT_PRD_IDX_PRICE_WS_ID_CORE_WS_WS_ID" to table "catalog_product_index_price"
    Add missing foreign key(s) "FK_CAT_PRD_IDX_TIER_PRICE_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID, FK_CAT_PRD_IDX_TIER_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID, FK_CAT_PRD_IDX_TIER_PRICE_WS_ID_CORE_WS_WS_ID" to table "catalog_product_index_tier_price"
    Add missing foreign key(s) "FK_CAT_PRD_IDX_WS_WS_ID_CORE_WS_WS_ID" to table "catalog_product_index_website"
    Add missing foreign key(s) "FK_CAT_PRD_LNK_LNKED_PRD_ID_CAT_PRD_ENTT_ENTT_ID, FK_CAT_PRD_LNK_PRD_ID_CAT_PRD_ENTT_ENTT_ID, FK_CAT_PRD_LNK_LNK_TYPE_ID_CAT_PRD_LNK_TYPE_LNK_TYPE_ID" to table "catalog_product_link"
    Add missing foreign key(s) "FK_CAT_PRD_LNK_ATTR_LNK_TYPE_ID_CAT_PRD_LNK_TYPE_LNK_TYPE_ID" to table "catalog_product_link_attribute"
    Add missing foreign key(s) "FK_CAT_PRD_LNK_ATTR_DEC_LNK_ID_CAT_PRD_LNK_LNK_ID, FK_AB2EFA9A14F7BCF1D5400056203D14B6" to table "catalog_product_link_attribute_decimal"
    Add missing foreign key(s) "FK_D6D878F8BA2A4282F8DDED7E6E3DE35C, FK_CAT_PRD_LNK_ATTR_INT_LNK_ID_CAT_PRD_LNK_LNK_ID" to table "catalog_product_link_attribute_int"
    Add missing foreign key(s) "FK_CAT_PRD_LNK_ATTR_VCHR_LNK_ID_CAT_PRD_LNK_LNK_ID, FK_DEE9C4DA61CFCC01DFCF50F0D79CEA51" to table "catalog_product_link_attribute_varchar"
    Add missing foreign key(s) "FK_CAT_PRD_OPT_PRD_ID_CAT_PRD_ENTT_ENTT_ID" to table "catalog_product_option"
    Add missing foreign key(s) "FK_CAT_PRD_OPT_PRICE_OPT_ID_CAT_PRD_OPT_OPT_ID, FK_CATALOG_PRODUCT_OPTION_PRICE_STORE_ID_CORE_STORE_STORE_ID" to table "catalog_product_option_price"
    Add missing foreign key(s) "FK_CAT_PRD_OPT_TTL_OPT_ID_CAT_PRD_OPT_OPT_ID, FK_CATALOG_PRODUCT_OPTION_TITLE_STORE_ID_CORE_STORE_STORE_ID" to table "catalog_product_option_title"
    Add missing foreign key(s) "FK_B523E3378E8602F376CC415825576B7F, FK_CAT_PRD_OPT_TYPE_PRICE_STORE_ID_CORE_STORE_STORE_ID" to table "catalog_product_option_type_price"
    Add missing foreign key(s) "FK_C085B9CF2C2A302E8043FDEA1937D6A2, FK_CAT_PRD_OPT_TYPE_TTL_STORE_ID_CORE_STORE_STORE_ID" to table "catalog_product_option_type_title"
    Add missing foreign key(s) "FK_CAT_PRD_OPT_TYPE_VAL_OPT_ID_CAT_PRD_OPT_OPT_ID" to table "catalog_product_option_type_value"
    Add missing foreign key(s) "FK_CAT_PRD_RELATION_CHILD_ID_CAT_PRD_ENTT_ENTT_ID, FK_CAT_PRD_RELATION_PARENT_ID_CAT_PRD_ENTT_ENTT_ID" to table "catalog_product_relation"
    Add missing foreign key(s) "FK_CAT_PRD_SPR_ATTR_PRD_ID_CAT_PRD_ENTT_ENTT_ID" to table "catalog_product_super_attribute"
    Add missing foreign key(s) "FK_309442281DF7784210ED82B2CC51E5D5, FK_CAT_PRD_SPR_ATTR_LBL_STORE_ID_CORE_STORE_STORE_ID" to table "catalog_product_super_attribute_label"
    Add missing foreign key(s) "FK_CAT_PRD_SPR_ATTR_PRICING_WS_ID_CORE_WS_WS_ID, FK_CDE8813117106CFAA3AD209358F66332" to table "catalog_product_super_attribute_pricing"
    Add missing foreign key(s) "FK_CAT_PRD_SPR_LNK_PRD_ID_CAT_PRD_ENTT_ENTT_ID, FK_CAT_PRD_SPR_LNK_PARENT_ID_CAT_PRD_ENTT_ENTT_ID" to table "catalog_product_super_link"
    Add missing foreign key(s) "FK_CATALOG_PRODUCT_WEBSITE_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID, FK_CAT_PRD_WS_PRD_ID_CAT_PRD_ENTT_ENTT_ID" to table "catalog_product_website"
    Add missing foreign key(s) "FK_CHKT_AGRT_STORE_AGRT_ID_CHKT_AGRT_AGRT_ID, FK_CHECKOUT_AGREEMENT_STORE_STORE_ID_CORE_STORE_STORE_ID" to table "checkout_agreement_store"
    Add missing foreign key(s) "FK_CMS_BLOCK_STORE_BLOCK_ID_CMS_BLOCK_BLOCK_ID, FK_CMS_BLOCK_STORE_STORE_ID_CORE_STORE_STORE_ID" to table "cms_block_store"
    Add missing foreign key(s) "FK_CMS_PAGE_STORE_PAGE_ID_CMS_PAGE_PAGE_ID, FK_CMS_PAGE_STORE_STORE_ID_CORE_STORE_STORE_ID" to table "cms_page_store"
    Add missing foreign key(s) "FK_6F4948F3ABF97DE12127EF14B140802A" to table "core_email_queue_recipients"
    Add missing foreign key(s) "FK_CORE_LAYOUT_LINK_STORE_ID_CORE_STORE_STORE_ID, FK_CORE_LYT_LNK_LYT_UPDATE_ID_CORE_LYT_UPDATE_LYT_UPDATE_ID" to table "core_layout_link"
    Add missing foreign key(s) "FK_CORE_STORE_GROUP_ID_CORE_STORE_GROUP_GROUP_ID, FK_CORE_STORE_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID" to table "core_store"
    Add missing foreign key(s) "FK_CORE_STORE_GROUP_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID" to table "core_store_group"
    Add missing foreign key(s) "FK_CORE_TRANSLATE_STORE_ID_CORE_STORE_STORE_ID" to table "core_translate"
    Add missing foreign key(s) "FK_CORE_URL_REWRITE_PRODUCT_ID_CATALOG_CATEGORY_ENTITY_ENTITY_ID, FK_CORE_URL_REWRITE_CTGR_ID_CAT_CTGR_ENTT_ENTT_ID, FK_CORE_URL_REWRITE_STORE_ID_CORE_STORE_STORE_ID" to table "core_url_rewrite"
    Add missing foreign key(s) "FK_CORE_VARIABLE_VALUE_STORE_ID_CORE_STORE_STORE_ID, FK_CORE_VARIABLE_VALUE_VARIABLE_ID_CORE_VARIABLE_VARIABLE_ID" to table "core_variable_value"
    Add missing foreign key(s) "FK_COUPON_AGGREGATED_STORE_ID_CORE_STORE_STORE_ID" to table "coupon_aggregated"
    Add missing foreign key(s) "FK_COUPON_AGGREGATED_ORDER_STORE_ID_CORE_STORE_STORE_ID" to table "coupon_aggregated_order"
    Add missing foreign key(s) "FK_COUPON_AGGREGATED_UPDATED_STORE_ID_CORE_STORE_STORE_ID" to table "coupon_aggregated_updated"
    Add missing foreign key(s) "FK_CUSTOMER_ADDRESS_ENTITY_PARENT_ID_CUSTOMER_ENTITY_ENTITY_ID" to table "customer_address_entity"
    Add missing foreign key(s) "FK_CSTR_ADDR_ENTT_DTIME_ATTR_ID_EAV_ATTR_ATTR_ID, FK_CSTR_ADDR_ENTT_DTIME_ENTT_ID_CSTR_ADDR_ENTT_ENTT_ID, FK_CSTR_ADDR_ENTT_DTIME_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID" to table "customer_address_entity_datetime"
    Add missing foreign key(s) "FK_CSTR_ADDR_ENTT_DEC_ATTR_ID_EAV_ATTR_ATTR_ID, FK_CSTR_ADDR_ENTT_DEC_ENTT_ID_CSTR_ADDR_ENTT_ENTT_ID, FK_CSTR_ADDR_ENTT_DEC_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID" to table "customer_address_entity_decimal"
    Add missing foreign key(s) "FK_CSTR_ADDR_ENTT_INT_ATTR_ID_EAV_ATTR_ATTR_ID, FK_CSTR_ADDR_ENTT_INT_ENTT_ID_CSTR_ADDR_ENTT_ENTT_ID, FK_CSTR_ADDR_ENTT_INT_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID" to table "customer_address_entity_int"
    Add missing foreign key(s) "FK_CSTR_ADDR_ENTT_TEXT_ATTR_ID_EAV_ATTR_ATTR_ID, FK_CSTR_ADDR_ENTT_TEXT_ENTT_ID_CSTR_ADDR_ENTT_ENTT_ID, FK_CSTR_ADDR_ENTT_TEXT_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID" to table "customer_address_entity_text"
    Add missing foreign key(s) "FK_CSTR_ADDR_ENTT_VCHR_ATTR_ID_EAV_ATTR_ATTR_ID, FK_CSTR_ADDR_ENTT_VCHR_ENTT_ID_CSTR_ADDR_ENTT_ENTT_ID, FK_CSTR_ADDR_ENTT_VCHR_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID" to table "customer_address_entity_varchar"
    Add missing foreign key(s) "FK_CSTR_EAV_ATTR_ATTR_ID_EAV_ATTR_ATTR_ID" to table "customer_eav_attribute"
    Add missing foreign key(s) "FK_CSTR_EAV_ATTR_WS_ATTR_ID_EAV_ATTR_ATTR_ID, FK_CSTR_EAV_ATTR_WS_WS_ID_CORE_WS_WS_ID" to table "customer_eav_attribute_website"
    Add missing foreign key(s) "FK_CUSTOMER_ENTITY_STORE_ID_CORE_STORE_STORE_ID, FK_CUSTOMER_ENTITY_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID" to table "customer_entity"
    Add missing foreign key(s) "FK_CSTR_ENTT_DTIME_ATTR_ID_EAV_ATTR_ATTR_ID, FK_CUSTOMER_ENTITY_DATETIME_ENTITY_ID_CUSTOMER_ENTITY_ENTITY_ID, FK_CSTR_ENTT_DTIME_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID" to table "customer_entity_datetime"
    Add missing foreign key(s) "FK_CSTR_ENTT_DEC_ATTR_ID_EAV_ATTR_ATTR_ID, FK_CUSTOMER_ENTITY_DECIMAL_ENTITY_ID_CUSTOMER_ENTITY_ENTITY_ID, FK_CSTR_ENTT_DEC_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID" to table "customer_entity_decimal"
    Add missing foreign key(s) "FK_CUSTOMER_ENTITY_INT_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID, FK_CUSTOMER_ENTITY_INT_ENTITY_ID_CUSTOMER_ENTITY_ENTITY_ID, FK_CSTR_ENTT_INT_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID" to table "customer_entity_int"
    Add missing foreign key(s) "FK_CUSTOMER_ENTITY_TEXT_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID, FK_CUSTOMER_ENTITY_TEXT_ENTITY_ID_CUSTOMER_ENTITY_ENTITY_ID, FK_CSTR_ENTT_TEXT_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID" to table "customer_entity_text"
    Add missing foreign key(s) "FK_CSTR_ENTT_VCHR_ATTR_ID_EAV_ATTR_ATTR_ID, FK_CUSTOMER_ENTITY_VARCHAR_ENTITY_ID_CUSTOMER_ENTITY_ENTITY_ID, FK_CSTR_ENTT_VCHR_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID" to table "customer_entity_varchar"
    Add missing foreign key(s) "FK_CSTR_FORM_ATTR_ATTR_ID_EAV_ATTR_ATTR_ID" to table "customer_form_attribute"
    Add missing foreign key(s) "FK_DATAFLOW_BATCH_PROFILE_ID_DATAFLOW_PROFILE_PROFILE_ID, FK_DATAFLOW_BATCH_STORE_ID_CORE_STORE_STORE_ID" to table "dataflow_batch"
    Add missing foreign key(s) "FK_DATAFLOW_BATCH_EXPORT_BATCH_ID_DATAFLOW_BATCH_BATCH_ID" to table "dataflow_batch_export"
    Add missing foreign key(s) "FK_DATAFLOW_BATCH_IMPORT_BATCH_ID_DATAFLOW_BATCH_BATCH_ID" to table "dataflow_batch_import"
    Add missing foreign key(s) "FK_DATAFLOW_IMPORT_DATA_SESSION_ID_DATAFLOW_SESSION_SESSION_ID" to table "dataflow_import_data"
    Add missing foreign key(s) "FK_AEA06B0C500063D3CE6EA671AE776645" to table "dataflow_profile_history"
    Add missing foreign key(s) "FK_DESIGN_CHANGE_STORE_ID_CORE_STORE_STORE_ID" to table "design_change"
    Add missing foreign key(s) "FK_D7CFDEB379F775328EB6F62695E2B3E1" to table "directory_country_region_name"
    Add missing foreign key(s) "FK_DOWNLOADABLE_LINK_PRODUCT_ID_CATALOG_PRODUCT_ENTITY_ENTITY_ID" to table "downloadable_link"
    Add missing foreign key(s) "FK_DOWNLOADABLE_LINK_PRICE_LINK_ID_DOWNLOADABLE_LINK_LINK_ID, FK_DOWNLOADABLE_LINK_PRICE_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID" to table "downloadable_link_price"
    Add missing foreign key(s) "FK_DL_LNK_PURCHASED_CSTR_ID_CSTR_ENTT_ENTT_ID, FK_DL_LNK_PURCHASED_ORDER_ID_SALES_FLAT_ORDER_ENTT_ID" to table "downloadable_link_purchased"
    Add missing foreign key(s) "FK_46CC8E252307CE62F00A8F1887512A39, FK_B219BF25756700DEE44550B21220ECCE" to table "downloadable_link_purchased_item"
    Add missing foreign key(s) "FK_DOWNLOADABLE_LINK_TITLE_LINK_ID_DOWNLOADABLE_LINK_LINK_ID, FK_DOWNLOADABLE_LINK_TITLE_STORE_ID_CORE_STORE_STORE_ID" to table "downloadable_link_title"
    Add missing foreign key(s) "FK_DL_SAMPLE_PRD_ID_CAT_PRD_ENTT_ENTT_ID" to table "downloadable_sample"
    Add missing foreign key(s) "FK_DL_SAMPLE_TTL_SAMPLE_ID_DL_SAMPLE_SAMPLE_ID, FK_DOWNLOADABLE_SAMPLE_TITLE_STORE_ID_CORE_STORE_STORE_ID" to table "downloadable_sample_title"
    Add missing foreign key(s) "FK_EAV_ATTRIBUTE_ENTITY_TYPE_ID_EAV_ENTITY_TYPE_ENTITY_TYPE_ID" to table "eav_attribute"
    Add missing foreign key(s) "FK_EAV_ATTR_GROUP_ATTR_SET_ID_EAV_ATTR_SET_ATTR_SET_ID" to table "eav_attribute_group"
    Add missing foreign key(s) "FK_EAV_ATTRIBUTE_LABEL_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID, FK_EAV_ATTRIBUTE_LABEL_STORE_ID_CORE_STORE_STORE_ID" to table "eav_attribute_label"
    Add missing foreign key(s) "FK_EAV_ATTRIBUTE_OPTION_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID" to table "eav_attribute_option"
    Add missing foreign key(s) "FK_EAV_ATTR_OPT_VAL_OPT_ID_EAV_ATTR_OPT_OPT_ID, FK_EAV_ATTRIBUTE_OPTION_VALUE_STORE_ID_CORE_STORE_STORE_ID" to table "eav_attribute_option_value"
    Add missing foreign key(s) "FK_EAV_ATTR_SET_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID" to table "eav_attribute_set"
    Add missing foreign key(s) "FK_EAV_ENTITY_ENTITY_TYPE_ID_EAV_ENTITY_TYPE_ENTITY_TYPE_ID, FK_EAV_ENTITY_STORE_ID_CORE_STORE_STORE_ID" to table "eav_entity"
    Add missing foreign key(s) "FK_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID, FK_EAV_ENTT_ATTR_ATTR_GROUP_ID_EAV_ATTR_GROUP_ATTR_GROUP_ID" to table "eav_entity_attribute"
    Add missing foreign key(s) "FK_EAV_ENTITY_DATETIME_ENTITY_ID_EAV_ENTITY_ENTITY_ID, FK_EAV_ENTT_DTIME_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID, FK_EAV_ENTITY_DATETIME_STORE_ID_CORE_STORE_STORE_ID" to table "eav_entity_datetime"
    Add missing foreign key(s) "FK_EAV_ENTITY_DECIMAL_ENTITY_ID_EAV_ENTITY_ENTITY_ID, FK_EAV_ENTT_DEC_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID, FK_EAV_ENTITY_DECIMAL_STORE_ID_CORE_STORE_STORE_ID" to table "eav_entity_decimal"
    Add missing foreign key(s) "FK_EAV_ENTITY_INT_ENTITY_ID_EAV_ENTITY_ENTITY_ID, FK_EAV_ENTITY_INT_ENTITY_TYPE_ID_EAV_ENTITY_TYPE_ENTITY_TYPE_ID, FK_EAV_ENTITY_INT_STORE_ID_CORE_STORE_STORE_ID" to table "eav_entity_int"
    Add missing foreign key(s) "FK_EAV_ENTT_STORE_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID, FK_EAV_ENTITY_STORE_STORE_ID_CORE_STORE_STORE_ID" to table "eav_entity_store"
    Add missing foreign key(s) "FK_EAV_ENTITY_TEXT_ENTITY_ID_EAV_ENTITY_ENTITY_ID, FK_EAV_ENTITY_TEXT_ENTITY_TYPE_ID_EAV_ENTITY_TYPE_ENTITY_TYPE_ID, FK_EAV_ENTITY_TEXT_STORE_ID_CORE_STORE_STORE_ID" to table "eav_entity_text"
0 Kudos
Reply
1 ACCEPTED SOLUTION

Accepted Solutions
‎09-03-2015 12:07 PM
‎09-03-2015 12:07 PM

Re: database repair tool

Ok, tried it on another version of the same database, no errors at all. Seems that my clone operation sprung a error.

 

Disregard the question Smiley Wink

View solution in original post

0 Kudos
Reply
2 REPLIES 2
‎09-03-2015 09:25 AM
‎09-03-2015 09:25 AM

Re: database repair tool 

    Add missing foreign key(s) "FK_EAV_ENTITY_VARCHAR_ENTITY_ID_EAV_ENTITY_ENTITY_ID, FK_EAV_ENTT_VCHR_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID, FK_EAV_ENTITY_VARCHAR_STORE_ID_CORE_STORE_STORE_ID" to table "eav_entity_varchar"
    Add missing foreign key(s) "FK_EAV_FORM_ELEMENT_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID, FK_EAV_FORM_ELEMENT_FIELDSET_ID_EAV_FORM_FIELDSET_FIELDSET_ID, FK_EAV_FORM_ELEMENT_TYPE_ID_EAV_FORM_TYPE_TYPE_ID" to table "eav_form_element"
    Add missing foreign key(s) "FK_EAV_FORM_FIELDSET_TYPE_ID_EAV_FORM_TYPE_TYPE_ID" to table "eav_form_fieldset"
    Add missing foreign key(s) "FK_EAV_FORM_FSET_LBL_FSET_ID_EAV_FORM_FSET_FSET_ID, FK_EAV_FORM_FIELDSET_LABEL_STORE_ID_CORE_STORE_STORE_ID" to table "eav_form_fieldset_label"
    Add missing foreign key(s) "FK_EAV_FORM_TYPE_STORE_ID_CORE_STORE_STORE_ID" to table "eav_form_type"
    Add missing foreign key(s) "FK_EAV_FORM_TYPE_ENTT_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID, FK_EAV_FORM_TYPE_ENTITY_TYPE_ID_EAV_FORM_TYPE_TYPE_ID" to table "eav_form_type_entity"
    Add missing foreign key(s) "FK_INDEX_PROCESS_EVENT_EVENT_ID_INDEX_EVENT_EVENT_ID, FK_INDEX_PROCESS_EVENT_PROCESS_ID_INDEX_PROCESS_PROCESS_ID" to table "index_process_event"
    Add missing foreign key(s) "FK_NEWSLETTER_PROBLEM_QUEUE_ID_NEWSLETTER_QUEUE_QUEUE_ID, FK_NLTTR_PROBLEM_SUBSCRIBER_ID_NLTTR_SUBSCRIBER_SUBSCRIBER_ID" to table "newsletter_problem"
    Add missing foreign key(s) "FK_NEWSLETTER_QUEUE_TEMPLATE_ID_NEWSLETTER_TEMPLATE_TEMPLATE_ID" to table "newsletter_queue"
    Add missing foreign key(s) "FK_NEWSLETTER_QUEUE_LINK_QUEUE_ID_NEWSLETTER_QUEUE_QUEUE_ID, FK_NLTTR_QUEUE_LNK_SUBSCRIBER_ID_NLTTR_SUBSCRIBER_SUBSCRIBER_ID" to table "newsletter_queue_link"
    Add missing foreign key(s) "FK_NLTTR_QUEUE_STORE_LNK_QUEUE_ID_NLTTR_QUEUE_QUEUE_ID, FK_NEWSLETTER_QUEUE_STORE_LINK_STORE_ID_CORE_STORE_STORE_ID" to table "newsletter_queue_store_link"
    Add missing foreign key(s) "FK_NEWSLETTER_SUBSCRIBER_STORE_ID_CORE_STORE_STORE_ID" to table "newsletter_subscriber"
    Add missing foreign key(s) "FK_OAUTH_TOKEN_ADMIN_ID_ADMIN_USER_USER_ID, FK_OAUTH_TOKEN_CONSUMER_ID_OAUTH_CONSUMER_ENTITY_ID, FK_OAUTH_TOKEN_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID" to table "oauth_token"
    Add missing foreign key(s) "FK_PAYPAL_CERT_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID" to table "paypal_cert"
    Add missing foreign key(s) "FK_E183E488F593E0DE10C6EBFFEBAC9B55" to table "paypal_settlement_report_row"
    Add missing foreign key(s) "FK_PERSISTENT_SESSION_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID, FK_PERSISTENT_SESSION_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID" to table "persistent_session"
    Add missing foreign key(s) "FK_POLL_STORE_ID_CORE_STORE_STORE_ID" to table "poll"
    Add missing foreign key(s) "FK_POLL_ANSWER_POLL_ID_POLL_POLL_ID" to table "poll_answer"
    Add missing foreign key(s) "FK_POLL_STORE_POLL_ID_POLL_POLL_ID, FK_POLL_STORE_STORE_ID_CORE_STORE_STORE_ID" to table "poll_store"
    Add missing foreign key(s) "FK_POLL_VOTE_POLL_ANSWER_ID_POLL_ANSWER_ANSWER_ID" to table "poll_vote"
    Add missing foreign key(s) "FK_PRODUCT_ALERT_PRICE_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID, FK_PRD_ALERT_PRICE_PRD_ID_CAT_PRD_ENTT_ENTT_ID, FK_PRODUCT_ALERT_PRICE_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID" to table "product_alert_price"
    Add missing foreign key(s) "FK_PRODUCT_ALERT_STOCK_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID, FK_PRODUCT_ALERT_STOCK_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID, FK_PRD_ALERT_STOCK_PRD_ID_CAT_PRD_ENTT_ENTT_ID" to table "product_alert_stock"
    Add missing foreign key(s) "FK_RATING_ENTITY_ID_RATING_ENTITY_ENTITY_ID" to table "rating"
    Add missing foreign key(s) "FK_RATING_OPTION_RATING_ID_RATING_RATING_ID" to table "rating_option"
    Add missing foreign key(s) "FK_RATING_OPTION_VOTE_REVIEW_ID_REVIEW_REVIEW_ID, FK_RATING_OPTION_VOTE_OPTION_ID_RATING_OPTION_OPTION_ID" to table "rating_option_vote"
    Add missing foreign key(s) "FK_RATING_OPTION_VOTE_AGGREGATED_RATING_ID_RATING_RATING_ID, FK_RATING_OPTION_VOTE_AGGREGATED_STORE_ID_CORE_STORE_STORE_ID" to table "rating_option_vote_aggregated"
    Add missing foreign key(s) "FK_RATING_STORE_STORE_ID_CORE_STORE_STORE_ID, FK_RATING_STORE_RATING_ID_RATING_RATING_ID" to table "rating_store"
    Add missing foreign key(s) "FK_RATING_TITLE_RATING_ID_RATING_RATING_ID, FK_RATING_TITLE_STORE_ID_CORE_STORE_STORE_ID" to table "rating_title"
    Add missing foreign key(s) "FK_REPORT_CMPD_PRD_IDX_CSTR_ID_CSTR_ENTT_ENTT_ID, FK_REPORT_CMPD_PRD_IDX_PRD_ID_CAT_PRD_ENTT_ENTT_ID, FK_REPORT_COMPARED_PRODUCT_INDEX_STORE_ID_CORE_STORE_STORE_ID" to table "report_compared_product_index"
    Add missing foreign key(s) "FK_REPORT_EVENT_STORE_ID_CORE_STORE_STORE_ID, FK_REPORT_EVENT_EVENT_TYPE_ID_REPORT_EVENT_TYPES_EVENT_TYPE_ID" to table "report_event"
    Add missing foreign key(s) "FK_REPORT_VIEWED_PRD_AGGRED_DAILY_STORE_ID_CORE_STORE_STORE_ID, FK_REPORT_VIEWED_PRD_AGGRED_DAILY_PRD_ID_CAT_PRD_ENTT_ENTT_ID" to table "report_viewed_product_aggregated_daily"
    Add missing foreign key(s) "FK_REPORT_VIEWED_PRD_AGGRED_MONTHLY_STORE_ID_CORE_STORE_STORE_ID, FK_REPORT_VIEWED_PRD_AGGRED_MONTHLY_PRD_ID_CAT_PRD_ENTT_ENTT_ID" to table "report_viewed_product_aggregated_monthly"
    Add missing foreign key(s) "FK_REPORT_VIEWED_PRD_AGGRED_YEARLY_STORE_ID_CORE_STORE_STORE_ID, FK_REPORT_VIEWED_PRD_AGGRED_YEARLY_PRD_ID_CAT_PRD_ENTT_ENTT_ID" to table "report_viewed_product_aggregated_yearly"
    Add missing foreign key(s) "FK_REPORT_VIEWED_PRD_IDX_CSTR_ID_CSTR_ENTT_ENTT_ID, FK_REPORT_VIEWED_PRD_IDX_PRD_ID_CAT_PRD_ENTT_ENTT_ID, FK_REPORT_VIEWED_PRODUCT_INDEX_STORE_ID_CORE_STORE_STORE_ID" to table "report_viewed_product_index"
    Add missing foreign key(s) "FK_REVIEW_ENTITY_ID_REVIEW_ENTITY_ENTITY_ID, FK_REVIEW_STATUS_ID_REVIEW_STATUS_STATUS_ID" to table "review"
    Add missing foreign key(s) "FK_REVIEW_DETAIL_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID, FK_REVIEW_DETAIL_REVIEW_ID_REVIEW_REVIEW_ID, FK_REVIEW_DETAIL_STORE_ID_CORE_STORE_STORE_ID" to table "review_detail"
    Add missing foreign key(s) "FK_REVIEW_ENTITY_SUMMARY_STORE_ID_CORE_STORE_STORE_ID" to table "review_entity_summary"
    Add missing foreign key(s) "FK_REVIEW_STORE_REVIEW_ID_REVIEW_REVIEW_ID, FK_REVIEW_STORE_STORE_ID_CORE_STORE_STORE_ID" to table "review_store"
    Add missing foreign key(s) "FK_SALES_BESTSELLERS_AGGRED_DAILY_STORE_ID_CORE_STORE_STORE_ID, FK_SALES_BESTSELLERS_AGGRED_DAILY_PRD_ID_CAT_PRD_ENTT_ENTT_ID" to table "sales_bestsellers_aggregated_daily"
    Add missing foreign key(s) "FK_SALES_BESTSELLERS_AGGRED_MONTHLY_STORE_ID_CORE_STORE_STORE_ID, FK_SALES_BESTSELLERS_AGGRED_MONTHLY_PRD_ID_CAT_PRD_ENTT_ENTT_ID" to table "sales_bestsellers_aggregated_monthly"
    Add missing foreign key(s) "FK_SALES_BESTSELLERS_AGGRED_YEARLY_STORE_ID_CORE_STORE_STORE_ID, FK_SALES_BESTSELLERS_AGGRED_YEARLY_PRD_ID_CAT_PRD_ENTT_ENTT_ID" to table "sales_bestsellers_aggregated_yearly"
    Add missing foreign key(s) "FK_SALES_BILLING_AGREEMENT_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID, FK_SALES_BILLING_AGREEMENT_STORE_ID_CORE_STORE_STORE_ID" to table "sales_billing_agreement"
    Add missing foreign key(s) "FK_SALES_BILLING_AGRT_ORDER_AGRT_ID_SALES_BILLING_AGRT_AGRT_ID, FK_SALES_BILLING_AGRT_ORDER_ORDER_ID_SALES_FLAT_ORDER_ENTT_ID" to table "sales_billing_agreement_order"
    Add missing foreign key(s) "FK_SALES_FLAT_CREDITMEMO_ORDER_ID_SALES_FLAT_ORDER_ENTITY_ID, FK_SALES_FLAT_CREDITMEMO_STORE_ID_CORE_STORE_STORE_ID" to table "sales_flat_creditmemo"
    Add missing foreign key(s) "FK_B0FCB0B5467075BE63D474F2CD5F7804" to table "sales_flat_creditmemo_comment"
    Add missing foreign key(s) "FK_78C711B225167A11CC077B03D1C8E1CC, FK_SALES_FLAT_CREDITMEMO_GRID_STORE_ID_CORE_STORE_STORE_ID" to table "sales_flat_creditmemo_grid"
    Add missing foreign key(s) "FK_306DAC836C699F0B5E13BE486557AC8A" to table "sales_flat_creditmemo_item"
    Add missing foreign key(s) "FK_SALES_FLAT_INVOICE_ORDER_ID_SALES_FLAT_ORDER_ENTITY_ID, FK_SALES_FLAT_INVOICE_STORE_ID_CORE_STORE_STORE_ID" to table "sales_flat_invoice"
    Add missing foreign key(s) "FK_5C4B36BBE5231A76AB8018B281ED50BC" to table "sales_flat_invoice_comment"
    Add missing foreign key(s) "FK_SALES_FLAT_INVOICE_GRID_ENTT_ID_SALES_FLAT_INVOICE_ENTT_ID, FK_SALES_FLAT_INVOICE_GRID_STORE_ID_CORE_STORE_STORE_ID" to table "sales_flat_invoice_grid"
    Add missing foreign key(s) "FK_SALES_FLAT_INVOICE_ITEM_PARENT_ID_SALES_FLAT_INVOICE_ENTT_ID" to table "sales_flat_invoice_item"
    Add missing foreign key(s) "FK_SALES_FLAT_ORDER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID, FK_SALES_FLAT_ORDER_STORE_ID_CORE_STORE_STORE_ID" to table "sales_flat_order"
    Add missing foreign key(s) "FK_SALES_FLAT_ORDER_ADDRESS_PARENT_ID_SALES_FLAT_ORDER_ENTITY_ID" to table "sales_flat_order_address"
    Add missing foreign key(s) "FK_SALES_FLAT_ORDER_GRID_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID, FK_SALES_FLAT_ORDER_GRID_ENTITY_ID_SALES_FLAT_ORDER_ENTITY_ID, FK_SALES_FLAT_ORDER_GRID_STORE_ID_CORE_STORE_STORE_ID" to table "sales_flat_order_grid"
    Add missing foreign key(s) "FK_SALES_FLAT_ORDER_ITEM_ORDER_ID_SALES_FLAT_ORDER_ENTITY_ID, FK_SALES_FLAT_ORDER_ITEM_STORE_ID_CORE_STORE_STORE_ID" to table "sales_flat_order_item"
    Add missing foreign key(s) "FK_SALES_FLAT_ORDER_PAYMENT_PARENT_ID_SALES_FLAT_ORDER_ENTITY_ID" to table "sales_flat_order_payment"
    Add missing foreign key(s) "FK_CE7C71E74CB74DDACED337CEE6753D5E" to table "sales_flat_order_status_history"
    Add missing foreign key(s) "FK_SALES_FLAT_QUOTE_STORE_ID_CORE_STORE_STORE_ID" to table "sales_flat_quote"
    Add missing foreign key(s) "FK_SALES_FLAT_QUOTE_ADDRESS_QUOTE_ID_SALES_FLAT_QUOTE_ENTITY_ID" to table "sales_flat_quote_address"
    Add missing foreign key(s) "FK_2EF8E28181D666D94D4E30DC2B0F80BF, FK_A345FC758F20C314169CE27DCE53477F, FK_B521389746C00700D1B2B76EBBE53854" to table "sales_flat_quote_address_item"
    Add missing foreign key(s) "FK_B201DEB5DE51B791AF5C5BF87053C5A7, FK_SALES_FLAT_QUOTE_ITEM_PRD_ID_CAT_PRD_ENTT_ENTT_ID, FK_SALES_FLAT_QUOTE_ITEM_QUOTE_ID_SALES_FLAT_QUOTE_ENTITY_ID, FK_SALES_FLAT_QUOTE_ITEM_STORE_ID_CORE_STORE_STORE_ID" to table "sales_flat_quote_item"
    Add missing foreign key(s) "FK_5F20E478CA64B6891EA8A9D6C2735739" to table "sales_flat_quote_item_option"
    Add missing foreign key(s) "FK_SALES_FLAT_QUOTE_PAYMENT_QUOTE_ID_SALES_FLAT_QUOTE_ENTITY_ID" to table "sales_flat_quote_payment"
    Add missing foreign key(s) "FK_B1F177EFB73D3EDF5322BA64AC48D150" to table "sales_flat_quote_shipping_rate"
    Add missing foreign key(s) "FK_SALES_FLAT_SHIPMENT_ORDER_ID_SALES_FLAT_ORDER_ENTITY_ID, FK_SALES_FLAT_SHIPMENT_STORE_ID_CORE_STORE_STORE_ID" to table "sales_flat_shipment"
    Add missing foreign key(s) "FK_C2D69CC1FB03D2B2B794B0439F6650CF" to table "sales_flat_shipment_comment"
    Add missing foreign key(s) "FK_SALES_FLAT_SHIPMENT_GRID_ENTT_ID_SALES_FLAT_SHIPMENT_ENTT_ID, FK_SALES_FLAT_SHIPMENT_GRID_STORE_ID_CORE_STORE_STORE_ID" to table "sales_flat_shipment_grid"
    Add missing foreign key(s) "FK_3AECE5007D18F159231B87E8306FC02A" to table "sales_flat_shipment_item"
    Add missing foreign key(s) "FK_BCD2FA28717D29F37E10A153E6F2F841" to table "sales_flat_shipment_track"
    Add missing foreign key(s) "FK_SALES_INVOICED_AGGREGATED_STORE_ID_CORE_STORE_STORE_ID" to table "sales_invoiced_aggregated"
    Add missing foreign key(s) "FK_SALES_INVOICED_AGGREGATED_ORDER_STORE_ID_CORE_STORE_STORE_ID" to table "sales_invoiced_aggregated_order"
    Add missing foreign key(s) "FK_SALES_ORDER_AGGREGATED_CREATED_STORE_ID_CORE_STORE_STORE_ID" to table "sales_order_aggregated_created"
    Add missing foreign key(s) "FK_SALES_ORDER_AGGREGATED_UPDATED_STORE_ID_CORE_STORE_STORE_ID" to table "sales_order_aggregated_updated"
    Add missing foreign key(s) "FK_SALES_ORDER_STATUS_LABEL_STATUS_SALES_ORDER_STATUS_STATUS, FK_SALES_ORDER_STATUS_LABEL_STORE_ID_CORE_STORE_STORE_ID" to table "sales_order_status_label"
    Add missing foreign key(s) "FK_SALES_ORDER_STATUS_STATE_STATUS_SALES_ORDER_STATUS_STATUS" to table "sales_order_status_state"
    Add missing foreign key(s) "FK_SALES_ORDER_TAX_ITEM_ITEM_ID_SALES_FLAT_ORDER_ITEM_ITEM_ID, FK_SALES_ORDER_TAX_ITEM_TAX_ID_SALES_ORDER_TAX_TAX_ID" to table "sales_order_tax_item"
    Add missing foreign key(s) "FK_SALES_PAYMENT_TRANSACTION_ORDER_ID_SALES_FLAT_ORDER_ENTITY_ID, FK_B99FF1A06402D725EBDB0F3A7ECD47A2, FK_DA51A10B2405B64A4DAEF77A64F0DAAD" to table "sales_payment_transaction"
    Add missing foreign key(s) "FK_SALES_RECURRING_PROFILE_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID, FK_SALES_RECURRING_PROFILE_STORE_ID_CORE_STORE_STORE_ID" to table "sales_recurring_profile"
    Add missing foreign key(s) "FK_7FF85741C66DCD37A4FBE3E3255A5A01, FK_B8A7A5397B67455786E55461748C59F4" to table "sales_recurring_profile_order"
    Add missing foreign key(s) "FK_SALES_REFUNDED_AGGREGATED_STORE_ID_CORE_STORE_STORE_ID" to table "sales_refunded_aggregated"
    Add missing foreign key(s) "FK_SALES_REFUNDED_AGGREGATED_ORDER_STORE_ID_CORE_STORE_STORE_ID" to table "sales_refunded_aggregated_order"
    Add missing foreign key(s) "FK_SALES_SHIPPING_AGGREGATED_STORE_ID_CORE_STORE_STORE_ID" to table "sales_shipping_aggregated"
    Add missing foreign key(s) "FK_SALES_SHIPPING_AGGREGATED_ORDER_STORE_ID_CORE_STORE_STORE_ID" to table "sales_shipping_aggregated_order"
    Add missing foreign key(s) "FK_SALESRULE_COUPON_RULE_ID_SALESRULE_RULE_ID" to table "salesrule_coupon"
    Add missing foreign key(s) "FK_SALESRULE_COUPON_USAGE_COUPON_ID_SALESRULE_COUPON_COUPON_ID, FK_SALESRULE_COUPON_USAGE_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID" to table "salesrule_coupon_usage"
    Add missing foreign key(s) "FK_SALESRULE_CUSTOMER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID, FK_SALESRULE_CUSTOMER_RULE_ID_SALESRULE_RULE_ID" to table "salesrule_customer"
    Add missing foreign key(s) "FK_SALESRULE_CUSTOMER_GROUP_RULE_ID_SALESRULE_RULE_ID, FK_SALESRULE_CSTR_GROUP_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID" to table "salesrule_customer_group"
    Add missing foreign key(s) "FK_SALESRULE_LABEL_RULE_ID_SALESRULE_RULE_ID, FK_SALESRULE_LABEL_STORE_ID_CORE_STORE_STORE_ID" to table "salesrule_label"
    Add missing foreign key(s) "FK_SALESRULE_PRD_ATTR_ATTR_ID_EAV_ATTR_ATTR_ID, FK_SALESRULE_PRD_ATTR_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID, FK_SALESRULE_PRODUCT_ATTRIBUTE_RULE_ID_SALESRULE_RULE_ID, FK_SALESRULE_PRD_ATTR_WS_ID_CORE_WS_WS_ID" to table "salesrule_product_attribute"
    Add missing foreign key(s) "FK_SALESRULE_WEBSITE_RULE_ID_SALESRULE_RULE_ID, FK_SALESRULE_WEBSITE_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID" to table "salesrule_website"
    Add missing foreign key(s) "FK_SITEMAP_STORE_ID_CORE_STORE_STORE_ID" to table "sitemap"
    Add missing foreign key(s) "FK_TAG_FIRST_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID, FK_TAG_FIRST_STORE_ID_CORE_STORE_STORE_ID" to table "tag"
    Add missing foreign key(s) "FK_TAG_PROPERTIES_STORE_ID_CORE_STORE_STORE_ID, FK_TAG_PROPERTIES_TAG_ID_TAG_TAG_ID" to table "tag_properties"
    Add missing foreign key(s) "FK_TAG_RELATION_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID, FK_TAG_RELATION_PRODUCT_ID_CATALOG_PRODUCT_ENTITY_ENTITY_ID, FK_TAG_RELATION_STORE_ID_CORE_STORE_STORE_ID, FK_TAG_RELATION_TAG_ID_TAG_TAG_ID" to table "tag_relation"
    Add missing foreign key(s) "FK_TAG_SUMMARY_STORE_ID_CORE_STORE_STORE_ID, FK_TAG_SUMMARY_TAG_ID_TAG_TAG_ID" to table "tag_summary"
    Add missing foreign key(s) "FK_TAX_CALCULATION_PRODUCT_TAX_CLASS_ID_TAX_CLASS_CLASS_ID, FK_TAX_CALCULATION_CUSTOMER_TAX_CLASS_ID_TAX_CLASS_CLASS_ID, FK_TAX_CALC_TAX_CALC_RATE_ID_TAX_CALC_RATE_TAX_CALC_RATE_ID, FK_TAX_CALC_TAX_CALC_RULE_ID_TAX_CALC_RULE_TAX_CALC_RULE_ID" to table "tax_calculation"
    Add missing foreign key(s) "FK_TAX_CALCULATION_RATE_TITLE_STORE_ID_CORE_STORE_STORE_ID, FK_37FB965F786AD5897BB3AE90470C42AB" to table "tax_calculation_rate_title"
    Add missing foreign key(s) "FK_TAX_ORDER_AGGREGATED_CREATED_STORE_ID_CORE_STORE_STORE_ID" to table "tax_order_aggregated_created"
    Add missing foreign key(s) "FK_TAX_ORDER_AGGREGATED_UPDATED_STORE_ID_CORE_STORE_STORE_ID" to table "tax_order_aggregated_updated"
    Add missing foreign key(s) "FK_WEEE_DISCOUNT_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID, FK_WEEE_DISCOUNT_ENTITY_ID_CATALOG_PRODUCT_ENTITY_ENTITY_ID, FK_WEEE_DISCOUNT_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID" to table "weee_discount"
    Add missing foreign key(s) "FK_WEEE_TAX_COUNTRY_DIRECTORY_COUNTRY_COUNTRY_ID, FK_WEEE_TAX_ENTITY_ID_CATALOG_PRODUCT_ENTITY_ENTITY_ID, FK_WEEE_TAX_WEBSITE_ID_CORE_WEBSITE_WEBSITE_ID, FK_WEEE_TAX_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID" to table "weee_tax"
    Add missing foreign key(s) "FK_WIDGET_INSTANCE_PAGE_INSTANCE_ID_WIDGET_INSTANCE_INSTANCE_ID" to table "widget_instance_page"
    Add missing foreign key(s) "FK_WIDGET_INSTANCE_PAGE_LYT_PAGE_ID_WIDGET_INSTANCE_PAGE_PAGE_ID, FK_0A5D06DCEC6A6845F50E5FAAC5A1C96D" to table "widget_instance_page_layout"
    Add missing foreign key(s) "FK_WISHLIST_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID" to table "wishlist"
    Add missing foreign key(s) "FK_WISHLIST_ITEM_WISHLIST_ID_WISHLIST_WISHLIST_ID, FK_WISHLIST_ITEM_PRODUCT_ID_CATALOG_PRODUCT_ENTITY_ENTITY_ID, FK_WISHLIST_ITEM_STORE_ID_CORE_STORE_STORE_ID" to table "wishlist_item"
    Add missing foreign key(s) "FK_A014B30B04B72DD0EAB3EECD779728D6" to table "wishlist_item_option"
0 Kudos
Reply
‎09-03-2015 12:07 PM
‎09-03-2015 12:07 PM

Re: database repair tool

Ok, tried it on another version of the same database, no errors at all. Seems that my clone operation sprung a error.

 

Disregard the question Smiley Wink

0 Kudos
Reply