Skip to content

Instantly share code, notes, and snippets.

@SchumacherFM

SchumacherFM/pt-duplicate-key-checker.sql

Last active February 5, 2023 15:10
Show Gist options
  • Save SchumacherFM/9968730 to your computer and use it in GitHub Desktop.
Save SchumacherFM/9968730 to your computer and use it in GitHub Desktop.
Download ZIP
pt-duplicate-key-checker for Magento 1.8 MySQL database. Less indexes the faster the update/insert statement
Raw
pt-duplicate-key-checker.sql
# ########################################################################
# api2_acl_attribute
# ########################################################################
# IDX_API2_ACL_ATTRIBUTE_USER_TYPE is a left-prefix of UNQ_API2_ACL_ATTRIBUTE_USER_TYPE_RESOURCE_ID_OPERATION
# Key definitions:
# KEY `IDX_API2_ACL_ATTRIBUTE_USER_TYPE` (`user_type`)
# UNIQUE KEY `UNQ_API2_ACL_ATTRIBUTE_USER_TYPE_RESOURCE_ID_OPERATION` (`user_type`,`resource_id`,`operation`),
# Column types:
# `user_type` varchar(20) not null comment 'type of user'
# `resource_id` varchar(255) not null comment 'resource id'
# `operation` varchar(20) not null comment 'operation'
# To remove this duplicate index, execute:
ALTER TABLE `api2_acl_attribute` DROP INDEX `IDX_API2_ACL_ATTRIBUTE_USER_TYPE`;
# ########################################################################
# catalog_category_entity
# ########################################################################
# Key IDX_CATALOG_CATEGORY_ENTITY_PATH_ENTITY_ID ends with a prefix of the clustered index
# Key definitions:
# KEY `IDX_CATALOG_CATEGORY_ENTITY_PATH_ENTITY_ID` (`path`,`entity_id`)
# PRIMARY KEY (`entity_id`),
# Column types:
# `path` varchar(255) not null comment 'tree path'
# `entity_id` int(10) unsigned not null auto_increment comment 'entity id'
# To shorten this duplicate clustered index, execute:
ALTER TABLE `catalog_category_entity` DROP INDEX `IDX_CATALOG_CATEGORY_ENTITY_PATH_ENTITY_ID`, ADD INDEX `IDX_CATALOG_CATEGORY_ENTITY_PATH_ENTITY_ID` (`path`);
# ########################################################################
# catalog_compare_item
# ########################################################################
# IDX_CATALOG_COMPARE_ITEM_CUSTOMER_ID is a left-prefix of IDX_CATALOG_COMPARE_ITEM_CUSTOMER_ID_PRODUCT_ID
# Key definitions:
# KEY `IDX_CATALOG_COMPARE_ITEM_CUSTOMER_ID` (`customer_id`),
# KEY `IDX_CATALOG_COMPARE_ITEM_CUSTOMER_ID_PRODUCT_ID` (`customer_id`,`product_id`),
# Column types:
# `customer_id` int(10) unsigned default null comment 'customer id'
# `product_id` int(10) unsigned not null default '0' comment 'product id'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_compare_item` DROP INDEX `IDX_CATALOG_COMPARE_ITEM_CUSTOMER_ID`;
# ########################################################################
# catalog_product_entity_datetime
# ########################################################################
# IDX_CATALOG_PRODUCT_ENTITY_DATETIME_ENTITY_ID is a left-prefix of UNQ_CAT_PRD_ENTT_DTIME_ENTT_ID_ATTR_ID_STORE_ID
# Key definitions:
# KEY `IDX_CATALOG_PRODUCT_ENTITY_DATETIME_ENTITY_ID` (`entity_id`),
# UNIQUE KEY `UNQ_CAT_PRD_ENTT_DTIME_ENTT_ID_ATTR_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
# Column types:
# `entity_id` int(10) unsigned not null comment 'entity id'
# `attribute_id` smallint(5) unsigned not null comment 'attribute id'
# `store_id` smallint(5) unsigned not null comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_entity_datetime` DROP INDEX `IDX_CATALOG_PRODUCT_ENTITY_DATETIME_ENTITY_ID`;
# ########################################################################
# catalog_product_entity_decimal
# ########################################################################
# IDX_CATALOG_PRODUCT_ENTITY_DECIMAL_ENTITY_ID is a left-prefix of UNQ_CAT_PRD_ENTT_DEC_ENTT_ID_ATTR_ID_STORE_ID
# Key definitions:
# KEY `IDX_CATALOG_PRODUCT_ENTITY_DECIMAL_ENTITY_ID` (`entity_id`),
# UNIQUE KEY `UNQ_CAT_PRD_ENTT_DEC_ENTT_ID_ATTR_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
# Column types:
# `entity_id` int(10) unsigned not null comment 'entity id'
# `attribute_id` smallint(5) unsigned not null comment 'attribute id'
# `store_id` smallint(5) unsigned not null comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_entity_decimal` DROP INDEX `IDX_CATALOG_PRODUCT_ENTITY_DECIMAL_ENTITY_ID`;
# ########################################################################
# catalog_product_entity_group_price
# ########################################################################
# IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_ENTITY_ID is a left-prefix of CC12C83765B562314470A24F2BDD0F36
# Key definitions:
# KEY `IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_ENTITY_ID` (`entity_id`),
# UNIQUE KEY `CC12C83765B562314470A24F2BDD0F36` (`entity_id`,`all_groups`,`customer_group_id`,`website_id`),
# Column types:
# `entity_id` int(10) unsigned not null default '0' comment 'entity id'
# `all_groups` smallint(5) unsigned not null default '1' comment 'is applicable to all customer groups'
# `customer_group_id` smallint(5) unsigned not null default '0' comment 'customer group id'
# `website_id` smallint(5) unsigned not null comment 'website id'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_entity_group_price` DROP INDEX `IDX_CATALOG_PRODUCT_ENTITY_GROUP_PRICE_ENTITY_ID`;
# ########################################################################
# catalog_product_entity_int
# ########################################################################
# IDX_CATALOG_PRODUCT_ENTITY_INT_ENTITY_ID is a left-prefix of UNQ_CATALOG_PRODUCT_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID
# Key definitions:
# KEY `IDX_CATALOG_PRODUCT_ENTITY_INT_ENTITY_ID` (`entity_id`),
# UNIQUE KEY `UNQ_CATALOG_PRODUCT_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
# Column types:
# `entity_id` int(10) unsigned not null comment 'entity id'
# `attribute_id` smallint(5) unsigned not null comment 'attribute id'
# `store_id` smallint(5) unsigned not null comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_entity_int` DROP INDEX `IDX_CATALOG_PRODUCT_ENTITY_INT_ENTITY_ID`;
# ########################################################################
# catalog_product_entity_text
# ########################################################################
# IDX_CATALOG_PRODUCT_ENTITY_TEXT_ENTITY_ID is a left-prefix of UNQ_CATALOG_PRODUCT_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID
# Key definitions:
# KEY `IDX_CATALOG_PRODUCT_ENTITY_TEXT_ENTITY_ID` (`entity_id`),
# UNIQUE KEY `UNQ_CATALOG_PRODUCT_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
# Column types:
# `entity_id` int(10) unsigned not null comment 'entity id'
# `attribute_id` smallint(5) unsigned not null comment 'attribute id'
# `store_id` smallint(5) unsigned not null comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_entity_text` DROP INDEX `IDX_CATALOG_PRODUCT_ENTITY_TEXT_ENTITY_ID`;
# ########################################################################
# catalog_product_entity_tier_price
# ########################################################################
# IDX_CATALOG_PRODUCT_ENTITY_TIER_PRICE_ENTITY_ID is a left-prefix of E8AB433B9ACB00343ABB312AD2FAB087
# Key definitions:
# KEY `IDX_CATALOG_PRODUCT_ENTITY_TIER_PRICE_ENTITY_ID` (`entity_id`),
# UNIQUE KEY `E8AB433B9ACB00343ABB312AD2FAB087` (`entity_id`,`all_groups`,`customer_group_id`,`qty`,`website_id`),
# Column types:
# `entity_id` int(10) unsigned not null default '0' comment 'entity id'
# `all_groups` smallint(5) unsigned not null default '1' comment 'is applicable to all customer groups'
# `customer_group_id` smallint(5) unsigned not null default '0' comment 'customer group id'
# `qty` decimal(12,4) not null default '1.0000' comment 'qty'
# `website_id` smallint(5) unsigned not null default '0' comment 'website id'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_entity_tier_price` DROP INDEX `IDX_CATALOG_PRODUCT_ENTITY_TIER_PRICE_ENTITY_ID`;
# ########################################################################
# catalog_product_entity_varchar
# ########################################################################
# IDX_CATALOG_PRODUCT_ENTITY_VARCHAR_ENTITY_ID is a left-prefix of UNQ_CAT_PRD_ENTT_VCHR_ENTT_ID_ATTR_ID_STORE_ID
# Key definitions:
# KEY `IDX_CATALOG_PRODUCT_ENTITY_VARCHAR_ENTITY_ID` (`entity_id`),
# UNIQUE KEY `UNQ_CAT_PRD_ENTT_VCHR_ENTT_ID_ATTR_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
# Column types:
# `entity_id` int(10) unsigned not null comment 'entity id'
# `attribute_id` smallint(5) unsigned not null comment 'attribute id'
# `store_id` smallint(5) unsigned not null comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_entity_varchar` DROP INDEX `IDX_CATALOG_PRODUCT_ENTITY_VARCHAR_ENTITY_ID`;
# ########################################################################
# catalog_product_index_eav
# ########################################################################
# IDX_CATALOG_PRODUCT_INDEX_EAV_ENTITY_ID is a left-prefix of PRIMARY
# Key definitions:
# KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_ENTITY_ID` (`entity_id`),
# PRIMARY KEY (`entity_id`,`attribute_id`,`store_id`,`value`),
# Column types:
# `entity_id` int(10) unsigned not null default '0' comment 'entity id'
# `attribute_id` smallint(5) unsigned not null default '0' comment 'attribute id'
# `store_id` smallint(5) unsigned not null default '0' comment 'store id'
# `value` int(10) unsigned not null default '0' comment 'value'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_index_eav` DROP INDEX `IDX_CATALOG_PRODUCT_INDEX_EAV_ENTITY_ID`;
# ########################################################################
# catalog_product_index_eav_decimal
# ########################################################################
# IDX_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_ENTITY_ID is a left-prefix of PRIMARY
# Key definitions:
# KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_ENTITY_ID` (`entity_id`),
# PRIMARY KEY (`entity_id`,`attribute_id`,`store_id`),
# Column types:
# `entity_id` int(10) unsigned not null default '0' comment 'entity id'
# `attribute_id` smallint(5) unsigned not null default '0' comment 'attribute id'
# `store_id` smallint(5) unsigned not null default '0' comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_index_eav_decimal` DROP INDEX `IDX_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_ENTITY_ID`;
# ########################################################################
# catalog_product_index_eav_decimal_idx
# ########################################################################
# IDX_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_IDX_ENTITY_ID is a left-prefix of PRIMARY
# Key definitions:
# KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_IDX_ENTITY_ID` (`entity_id`),
# PRIMARY KEY (`entity_id`,`attribute_id`,`store_id`,`value`),
# Column types:
# `entity_id` int(10) unsigned not null default '0' comment 'entity id'
# `attribute_id` smallint(5) unsigned not null default '0' comment 'attribute id'
# `store_id` smallint(5) unsigned not null default '0' comment 'store id'
# `value` decimal(12,4) not null default '0.0000' comment 'value'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_index_eav_decimal_idx` DROP INDEX `IDX_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_IDX_ENTITY_ID`;
# ########################################################################
# catalog_product_index_eav_decimal_tmp
# ########################################################################
# IDX_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_TMP_ENTITY_ID is a left-prefix of PRIMARY
# Key definitions:
# KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_TMP_ENTITY_ID` (`entity_id`),
# PRIMARY KEY (`entity_id`,`attribute_id`,`store_id`),
# Column types:
# `entity_id` int(10) unsigned not null default '0' comment 'entity id'
# `attribute_id` smallint(5) unsigned not null default '0' comment 'attribute id'
# `store_id` smallint(5) unsigned not null default '0' comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_index_eav_decimal_tmp` DROP INDEX `IDX_CATALOG_PRODUCT_INDEX_EAV_DECIMAL_TMP_ENTITY_ID`;
# ########################################################################
# catalog_product_index_eav_idx
# ########################################################################
# IDX_CATALOG_PRODUCT_INDEX_EAV_IDX_ENTITY_ID is a left-prefix of PRIMARY
# Key definitions:
# KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_IDX_ENTITY_ID` (`entity_id`),
# PRIMARY KEY (`entity_id`,`attribute_id`,`store_id`,`value`),
# Column types:
# `entity_id` int(10) unsigned not null default '0' comment 'entity id'
# `attribute_id` smallint(5) unsigned not null default '0' comment 'attribute id'
# `store_id` smallint(5) unsigned not null default '0' comment 'store id'
# `value` int(10) unsigned not null default '0' comment 'value'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_index_eav_idx` DROP INDEX `IDX_CATALOG_PRODUCT_INDEX_EAV_IDX_ENTITY_ID`;
# ########################################################################
# catalog_product_index_eav_tmp
# ########################################################################
# IDX_CATALOG_PRODUCT_INDEX_EAV_TMP_ENTITY_ID is a left-prefix of PRIMARY
# Key definitions:
# KEY `IDX_CATALOG_PRODUCT_INDEX_EAV_TMP_ENTITY_ID` (`entity_id`),
# PRIMARY KEY (`entity_id`,`attribute_id`,`store_id`,`value`),
# Column types:
# `entity_id` int(10) unsigned not null default '0' comment 'entity id'
# `attribute_id` smallint(5) unsigned not null default '0' comment 'attribute id'
# `store_id` smallint(5) unsigned not null default '0' comment 'store id'
# `value` int(10) unsigned not null default '0' comment 'value'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_index_eav_tmp` DROP INDEX `IDX_CATALOG_PRODUCT_INDEX_EAV_TMP_ENTITY_ID`;
# ########################################################################
# catalog_product_index_price
# ########################################################################
# IDX_CATALOG_PRODUCT_INDEX_PRICE_WEBSITE_ID is a left-prefix of IDX_CAT_PRD_IDX_PRICE_WS_ID_CSTR_GROUP_ID_MIN_PRICE
# Key definitions:
# KEY `IDX_CATALOG_PRODUCT_INDEX_PRICE_WEBSITE_ID` (`website_id`),
# KEY `IDX_CAT_PRD_IDX_PRICE_WS_ID_CSTR_GROUP_ID_MIN_PRICE` (`website_id`,`customer_group_id`,`min_price`),
# Column types:
# `website_id` smallint(5) unsigned not null default '0' comment 'website id'
# `customer_group_id` smallint(5) unsigned not null default '0' comment 'customer group id'
# `min_price` decimal(12,4) default null comment 'min price'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_index_price` DROP INDEX `IDX_CATALOG_PRODUCT_INDEX_PRICE_WEBSITE_ID`;
# ########################################################################
# catalog_product_link
# ########################################################################
# IDX_CATALOG_PRODUCT_LINK_LINK_TYPE_ID is a left-prefix of UNQ_CAT_PRD_LNK_LNK_TYPE_ID_PRD_ID_LNKED_PRD_ID
# Key definitions:
# KEY `IDX_CATALOG_PRODUCT_LINK_LINK_TYPE_ID` (`link_type_id`),
# UNIQUE KEY `UNQ_CAT_PRD_LNK_LNK_TYPE_ID_PRD_ID_LNKED_PRD_ID` (`link_type_id`,`product_id`,`linked_product_id`),
# Column types:
# `link_type_id` smallint(5) unsigned not null default '0' comment 'link type id'
# `product_id` int(10) unsigned not null default '0' comment 'product id'
# `linked_product_id` int(10) unsigned not null default '0' comment 'linked product id'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_link` DROP INDEX `IDX_CATALOG_PRODUCT_LINK_LINK_TYPE_ID`;
# ########################################################################
# catalog_product_link_attribute_decimal
# ########################################################################
# IDX_CAT_PRD_LNK_ATTR_DEC_PRD_LNK_ATTR_ID is a left-prefix of UNQ_CAT_PRD_LNK_ATTR_DEC_PRD_LNK_ATTR_ID_LNK_ID
# Key definitions:
# KEY `IDX_CAT_PRD_LNK_ATTR_DEC_PRD_LNK_ATTR_ID` (`product_link_attribute_id`),
# UNIQUE KEY `UNQ_CAT_PRD_LNK_ATTR_DEC_PRD_LNK_ATTR_ID_LNK_ID` (`product_link_attribute_id`,`link_id`),
# Column types:
# `product_link_attribute_id` smallint(5) unsigned default null comment 'product link attribute id'
# `link_id` int(10) unsigned not null default '0' comment 'link id'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_link_attribute_decimal` DROP INDEX `IDX_CAT_PRD_LNK_ATTR_DEC_PRD_LNK_ATTR_ID`;
# ########################################################################
# catalog_product_link_attribute_int
# ########################################################################
# IDX_CATALOG_PRODUCT_LINK_ATTRIBUTE_INT_PRODUCT_LINK_ATTRIBUTE_ID is a left-prefix of UNQ_CAT_PRD_LNK_ATTR_INT_PRD_LNK_ATTR_ID_LNK_ID
# Key definitions:
# KEY `IDX_CATALOG_PRODUCT_LINK_ATTRIBUTE_INT_PRODUCT_LINK_ATTRIBUTE_ID` (`product_link_attribute_id`),
# UNIQUE KEY `UNQ_CAT_PRD_LNK_ATTR_INT_PRD_LNK_ATTR_ID_LNK_ID` (`product_link_attribute_id`,`link_id`),
# Column types:
# `product_link_attribute_id` smallint(5) unsigned default null comment 'product link attribute id'
# `link_id` int(10) unsigned not null default '0' comment 'link id'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_link_attribute_int` DROP INDEX `IDX_CATALOG_PRODUCT_LINK_ATTRIBUTE_INT_PRODUCT_LINK_ATTRIBUTE_ID`;
# ########################################################################
# catalog_product_link_attribute_varchar
# ########################################################################
# IDX_CAT_PRD_LNK_ATTR_VCHR_PRD_LNK_ATTR_ID is a left-prefix of UNQ_CAT_PRD_LNK_ATTR_VCHR_PRD_LNK_ATTR_ID_LNK_ID
# Key definitions:
# KEY `IDX_CAT_PRD_LNK_ATTR_VCHR_PRD_LNK_ATTR_ID` (`product_link_attribute_id`),
# UNIQUE KEY `UNQ_CAT_PRD_LNK_ATTR_VCHR_PRD_LNK_ATTR_ID_LNK_ID` (`product_link_attribute_id`,`link_id`),
# Column types:
# `product_link_attribute_id` smallint(5) unsigned not null default '0' comment 'product link attribute id'
# `link_id` int(10) unsigned not null default '0' comment 'link id'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_link_attribute_varchar` DROP INDEX `IDX_CAT_PRD_LNK_ATTR_VCHR_PRD_LNK_ATTR_ID`;
# ########################################################################
# catalog_product_option_price
# ########################################################################
# IDX_CATALOG_PRODUCT_OPTION_PRICE_OPTION_ID is a left-prefix of UNQ_CATALOG_PRODUCT_OPTION_PRICE_OPTION_ID_STORE_ID
# Key definitions:
# KEY `IDX_CATALOG_PRODUCT_OPTION_PRICE_OPTION_ID` (`option_id`),
# UNIQUE KEY `UNQ_CATALOG_PRODUCT_OPTION_PRICE_OPTION_ID_STORE_ID` (`option_id`,`store_id`),
# Column types:
# `option_id` int(10) unsigned not null default '0' comment 'option id'
# `store_id` smallint(5) unsigned not null default '0' comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_option_price` DROP INDEX `IDX_CATALOG_PRODUCT_OPTION_PRICE_OPTION_ID`;
# ########################################################################
# catalog_product_option_title
# ########################################################################
# IDX_CATALOG_PRODUCT_OPTION_TITLE_OPTION_ID is a left-prefix of UNQ_CATALOG_PRODUCT_OPTION_TITLE_OPTION_ID_STORE_ID
# Key definitions:
# KEY `IDX_CATALOG_PRODUCT_OPTION_TITLE_OPTION_ID` (`option_id`),
# UNIQUE KEY `UNQ_CATALOG_PRODUCT_OPTION_TITLE_OPTION_ID_STORE_ID` (`option_id`,`store_id`),
# Column types:
# `option_id` int(10) unsigned not null default '0' comment 'option id'
# `store_id` smallint(5) unsigned not null default '0' comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_option_title` DROP INDEX `IDX_CATALOG_PRODUCT_OPTION_TITLE_OPTION_ID`;
# ########################################################################
# catalog_product_option_type_price
# ########################################################################
# IDX_CATALOG_PRODUCT_OPTION_TYPE_PRICE_OPTION_TYPE_ID is a left-prefix of UNQ_CATALOG_PRODUCT_OPTION_TYPE_PRICE_OPTION_TYPE_ID_STORE_ID
# Key definitions:
# KEY `IDX_CATALOG_PRODUCT_OPTION_TYPE_PRICE_OPTION_TYPE_ID` (`option_type_id`),
# UNIQUE KEY `UNQ_CATALOG_PRODUCT_OPTION_TYPE_PRICE_OPTION_TYPE_ID_STORE_ID` (`option_type_id`,`store_id`),
# Column types:
# `option_type_id` int(10) unsigned not null default '0' comment 'option type id'
# `store_id` smallint(5) unsigned not null default '0' comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_option_type_price` DROP INDEX `IDX_CATALOG_PRODUCT_OPTION_TYPE_PRICE_OPTION_TYPE_ID`;
# ########################################################################
# catalog_product_option_type_title
# ########################################################################
# IDX_CATALOG_PRODUCT_OPTION_TYPE_TITLE_OPTION_TYPE_ID is a left-prefix of UNQ_CATALOG_PRODUCT_OPTION_TYPE_TITLE_OPTION_TYPE_ID_STORE_ID
# Key definitions:
# KEY `IDX_CATALOG_PRODUCT_OPTION_TYPE_TITLE_OPTION_TYPE_ID` (`option_type_id`),
# UNIQUE KEY `UNQ_CATALOG_PRODUCT_OPTION_TYPE_TITLE_OPTION_TYPE_ID_STORE_ID` (`option_type_id`,`store_id`),
# Column types:
# `option_type_id` int(10) unsigned not null default '0' comment 'option type id'
# `store_id` smallint(5) unsigned not null default '0' comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_option_type_title` DROP INDEX `IDX_CATALOG_PRODUCT_OPTION_TYPE_TITLE_OPTION_TYPE_ID`;
# ########################################################################
# catalog_product_super_attribute
# ########################################################################
# IDX_CATALOG_PRODUCT_SUPER_ATTRIBUTE_PRODUCT_ID is a left-prefix of UNQ_CATALOG_PRODUCT_SUPER_ATTRIBUTE_PRODUCT_ID_ATTRIBUTE_ID
# Key definitions:
# KEY `IDX_CATALOG_PRODUCT_SUPER_ATTRIBUTE_PRODUCT_ID` (`product_id`),
# UNIQUE KEY `UNQ_CATALOG_PRODUCT_SUPER_ATTRIBUTE_PRODUCT_ID_ATTRIBUTE_ID` (`product_id`,`attribute_id`),
# Column types:
# `product_id` int(10) unsigned not null default '0' comment 'product id'
# `attribute_id` smallint(5) unsigned not null default '0' comment 'attribute id'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_super_attribute` DROP INDEX `IDX_CATALOG_PRODUCT_SUPER_ATTRIBUTE_PRODUCT_ID`;
# ########################################################################
# catalog_product_super_attribute_label
# ########################################################################
# IDX_CAT_PRD_SPR_ATTR_LBL_PRD_SPR_ATTR_ID is a left-prefix of UNQ_CAT_PRD_SPR_ATTR_LBL_PRD_SPR_ATTR_ID_STORE_ID
# Key definitions:
# KEY `IDX_CAT_PRD_SPR_ATTR_LBL_PRD_SPR_ATTR_ID` (`product_super_attribute_id`),
# UNIQUE KEY `UNQ_CAT_PRD_SPR_ATTR_LBL_PRD_SPR_ATTR_ID_STORE_ID` (`product_super_attribute_id`,`store_id`),
# Column types:
# `product_super_attribute_id` int(10) unsigned not null default '0' comment 'product super attribute id'
# `store_id` smallint(5) unsigned not null default '0' comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_super_attribute_label` DROP INDEX `IDX_CAT_PRD_SPR_ATTR_LBL_PRD_SPR_ATTR_ID`;
# ########################################################################
# catalog_product_super_attribute_pricing
# ########################################################################
# IDX_CAT_PRD_SPR_ATTR_PRICING_PRD_SPR_ATTR_ID is a left-prefix of UNQ_CAT_PRD_SPR_ATTR_PRICING_PRD_SPR_ATTR_ID_VAL_IDX_WS_ID
# Key definitions:
# KEY `IDX_CAT_PRD_SPR_ATTR_PRICING_PRD_SPR_ATTR_ID` (`product_super_attribute_id`),
# UNIQUE KEY `UNQ_CAT_PRD_SPR_ATTR_PRICING_PRD_SPR_ATTR_ID_VAL_IDX_WS_ID` (`product_super_attribute_id`,`value_index`,`website_id`),
# Column types:
# `product_super_attribute_id` int(10) unsigned not null default '0' comment 'product super attribute id'
# `value_index` varchar(255) not null comment 'value index'
# `website_id` smallint(5) unsigned not null default '0' comment 'website id'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_super_attribute_pricing` DROP INDEX `IDX_CAT_PRD_SPR_ATTR_PRICING_PRD_SPR_ATTR_ID`;
# ########################################################################
# catalog_product_super_link
# ########################################################################
# IDX_CATALOG_PRODUCT_SUPER_LINK_PRODUCT_ID is a left-prefix of UNQ_CATALOG_PRODUCT_SUPER_LINK_PRODUCT_ID_PARENT_ID
# Key definitions:
# KEY `IDX_CATALOG_PRODUCT_SUPER_LINK_PRODUCT_ID` (`product_id`),
# UNIQUE KEY `UNQ_CATALOG_PRODUCT_SUPER_LINK_PRODUCT_ID_PARENT_ID` (`product_id`,`parent_id`),
# Column types:
# `product_id` int(10) unsigned not null default '0' comment 'product id'
# `parent_id` int(10) unsigned not null default '0' comment 'parent id'
# To remove this duplicate index, execute:
ALTER TABLE `catalog_product_super_link` DROP INDEX `IDX_CATALOG_PRODUCT_SUPER_LINK_PRODUCT_ID`;
# ########################################################################
# catalogindex_eav
# ########################################################################
# FK_CATALOGINDEX_EAV_STORE is a left-prefix of PRIMARY
# Key definitions:
# KEY `FK_CATALOGINDEX_EAV_STORE` (`store_id`),
# PRIMARY KEY (`store_id`,`entity_id`,`attribute_id`,`value`),
# Column types:
# `store_id` smallint(5) unsigned not null default '0'
# `entity_id` int(10) unsigned not null
# `attribute_id` smallint(5) unsigned not null
# `value` int(11) not null default '0'
# To remove this duplicate index, execute:
ALTER TABLE `catalogindex_eav` DROP INDEX `FK_CATALOGINDEX_EAV_STORE`;
# ########################################################################
# catalogindex_price
# ########################################################################
# IDX_RANGE_VALUE is a left-prefix of IDX_FULL
# Key definitions:
# KEY `IDX_RANGE_VALUE` (`entity_id`,`attribute_id`,`customer_group_id`,`value`),
# KEY `IDX_FULL` (`entity_id`,`attribute_id`,`customer_group_id`,`value`,`website_id`),
# Column types:
# `entity_id` int(10) unsigned not null
# `attribute_id` smallint(5) unsigned not null
# `customer_group_id` smallint(3) unsigned not null default '0'
# `value` decimal(12,4) not null default '0.0000'
# `website_id` smallint(5) unsigned not null
# To remove this duplicate index, execute:
ALTER TABLE `catalogindex_price` DROP INDEX `IDX_RANGE_VALUE`;
# FK_CATALOGINDEX_PRICE_ENTITY is a left-prefix of IDX_FULL
# Key definitions:
# KEY `FK_CATALOGINDEX_PRICE_ENTITY` (`entity_id`),
# KEY `IDX_FULL` (`entity_id`,`attribute_id`,`customer_group_id`,`value`,`website_id`),
# Column types:
# `entity_id` int(10) unsigned not null
# `attribute_id` smallint(5) unsigned not null
# `customer_group_id` smallint(3) unsigned not null default '0'
# `value` decimal(12,4) not null default '0.0000'
# `website_id` smallint(5) unsigned not null
# To remove this duplicate index, execute:
ALTER TABLE `catalogindex_price` DROP INDEX `FK_CATALOGINDEX_PRICE_ENTITY`;
# ########################################################################
# cataloginventory_stock_item
# ########################################################################
# IDX_CATALOGINVENTORY_STOCK_ITEM_PRODUCT_ID is a left-prefix of UNQ_CATALOGINVENTORY_STOCK_ITEM_PRODUCT_ID_STOCK_ID
# Key definitions:
# KEY `IDX_CATALOGINVENTORY_STOCK_ITEM_PRODUCT_ID` (`product_id`),
# UNIQUE KEY `UNQ_CATALOGINVENTORY_STOCK_ITEM_PRODUCT_ID_STOCK_ID` (`product_id`,`stock_id`),
# Column types:
# `product_id` int(10) unsigned not null default '0' comment 'product id'
# `stock_id` smallint(5) unsigned not null default '0' comment 'stock id'
# To remove this duplicate index, execute:
ALTER TABLE `cataloginventory_stock_item` DROP INDEX `IDX_CATALOGINVENTORY_STOCK_ITEM_PRODUCT_ID`;
# ########################################################################
# catalogrule_customer_group
# ########################################################################
# IDX_CATALOGRULE_CUSTOMER_GROUP_RULE_ID is a left-prefix of PRIMARY
# Key definitions:
# KEY `IDX_CATALOGRULE_CUSTOMER_GROUP_RULE_ID` (`rule_id`),
# PRIMARY KEY (`rule_id`,`customer_group_id`),
# Column types:
# `rule_id` int(10) unsigned not null comment 'rule id'
# `customer_group_id` smallint(5) unsigned not null comment 'customer group id'
# To remove this duplicate index, execute:
ALTER TABLE `catalogrule_customer_group` DROP INDEX `IDX_CATALOGRULE_CUSTOMER_GROUP_RULE_ID`;
# ########################################################################
# catalogrule_group_website
# ########################################################################
# IDX_CATALOGRULE_GROUP_WEBSITE_RULE_ID is a left-prefix of PRIMARY
# Key definitions:
# KEY `IDX_CATALOGRULE_GROUP_WEBSITE_RULE_ID` (`rule_id`),
# PRIMARY KEY (`rule_id`,`customer_group_id`,`website_id`),
# Column types:
# `rule_id` int(10) unsigned not null default '0' comment 'rule id'
# `customer_group_id` smallint(5) unsigned not null default '0' comment 'customer group id'
# `website_id` smallint(5) unsigned not null default '0' comment 'website id'
# To remove this duplicate index, execute:
ALTER TABLE `catalogrule_group_website` DROP INDEX `IDX_CATALOGRULE_GROUP_WEBSITE_RULE_ID`;
# ########################################################################
# catalogrule_product
# ########################################################################
# IDX_CATALOGRULE_PRODUCT_RULE_ID is a left-prefix of EAA51B56FF092A0DCB795D1CEF812B7B
# Key definitions:
# KEY `IDX_CATALOGRULE_PRODUCT_RULE_ID` (`rule_id`),
# UNIQUE KEY `EAA51B56FF092A0DCB795D1CEF812B7B` (`rule_id`,`from_time`,`to_time`,`website_id`,`customer_group_id`,`product_id`,`sort_order`),
# Column types:
# `rule_id` int(10) unsigned not null default '0' comment 'rule id'
# `from_time` int(10) unsigned not null default '0' comment 'from time'
# `to_time` int(10) unsigned not null default '0' comment 'to time'
# `website_id` smallint(5) unsigned not null comment 'website id'
# `customer_group_id` smallint(5) unsigned not null default '0' comment 'customer group id'
# `product_id` int(10) unsigned not null default '0' comment 'product id'
# `sort_order` int(10) unsigned not null default '0' comment 'sort order'
# To remove this duplicate index, execute:
ALTER TABLE `catalogrule_product` DROP INDEX `IDX_CATALOGRULE_PRODUCT_RULE_ID`;
# ########################################################################
# catalogrule_website
# ########################################################################
# IDX_CATALOGRULE_WEBSITE_RULE_ID is a left-prefix of PRIMARY
# Key definitions:
# KEY `IDX_CATALOGRULE_WEBSITE_RULE_ID` (`rule_id`),
# PRIMARY KEY (`rule_id`,`website_id`),
# Column types:
# `rule_id` int(10) unsigned not null comment 'rule id'
# `website_id` smallint(5) unsigned not null comment 'website id'
# To remove this duplicate index, execute:
ALTER TABLE `catalogrule_website` DROP INDEX `IDX_CATALOGRULE_WEBSITE_RULE_ID`;
# ########################################################################
# catalogsearch_result
# ########################################################################
# IDX_CATALOGSEARCH_RESULT_QUERY_ID is a left-prefix of PRIMARY
# Key definitions:
# KEY `IDX_CATALOGSEARCH_RESULT_QUERY_ID` (`query_id`),
# PRIMARY KEY (`query_id`,`product_id`),
# Column types:
# `query_id` int(10) unsigned not null comment 'query id'
# `product_id` int(10) unsigned not null comment 'product id'
# To remove this duplicate index, execute:
ALTER TABLE `catalogsearch_result` DROP INDEX `IDX_CATALOGSEARCH_RESULT_QUERY_ID`;
# ########################################################################
# core_translate
# ########################################################################
# IDX_CORE_TRANSLATE_STORE_ID is a left-prefix of UNQ_CORE_TRANSLATE_STORE_ID_LOCALE_CRC_STRING_STRING
# Key definitions:
# KEY `IDX_CORE_TRANSLATE_STORE_ID` (`store_id`),
# UNIQUE KEY `UNQ_CORE_TRANSLATE_STORE_ID_LOCALE_CRC_STRING_STRING` (`store_id`,`locale`,`crc_string`,`string`),
# Column types:
# `store_id` smallint(5) unsigned not null default '0' comment 'store id'
# `locale` varchar(20) not null default 'en_us' comment 'locale'
# `crc_string` bigint(20) not null default '1591228201' comment 'translation string crc32 hash'
# `string` varchar(255) not null default 'translate string' comment 'translation string'
# To remove this duplicate index, execute:
ALTER TABLE `core_translate` DROP INDEX `IDX_CORE_TRANSLATE_STORE_ID`;
# ########################################################################
# core_url_rewrite
# ########################################################################
# IDX_CORE_URL_REWRITE_ID_PATH is a left-prefix of UNQ_CORE_URL_REWRITE_ID_PATH_IS_SYSTEM_STORE_ID
# Key definitions:
# KEY `IDX_CORE_URL_REWRITE_ID_PATH` (`id_path`),
# UNIQUE KEY `UNQ_CORE_URL_REWRITE_ID_PATH_IS_SYSTEM_STORE_ID` (`id_path`,`is_system`,`store_id`),
# Column types:
# `id_path` varchar(255) default null comment 'id path'
# `is_system` smallint(5) unsigned default '1' comment 'defines is rewrite system'
# `store_id` smallint(5) unsigned not null default '0' comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `core_url_rewrite` DROP INDEX `IDX_CORE_URL_REWRITE_ID_PATH`;
# ########################################################################
# core_variable_value
# ########################################################################
# IDX_CORE_VARIABLE_VALUE_VARIABLE_ID is a left-prefix of UNQ_CORE_VARIABLE_VALUE_VARIABLE_ID_STORE_ID
# Key definitions:
# KEY `IDX_CORE_VARIABLE_VALUE_VARIABLE_ID` (`variable_id`),
# UNIQUE KEY `UNQ_CORE_VARIABLE_VALUE_VARIABLE_ID_STORE_ID` (`variable_id`,`store_id`),
# Column types:
# `variable_id` int(10) unsigned not null default '0' comment 'variable id'
# `store_id` smallint(5) unsigned not null default '0' comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `core_variable_value` DROP INDEX `IDX_CORE_VARIABLE_VALUE_VARIABLE_ID`;
# ########################################################################
# customer_address_entity_datetime
# ########################################################################
# IDX_CUSTOMER_ADDRESS_ENTITY_DATETIME_ENTITY_ID is a left-prefix of UNQ_CUSTOMER_ADDRESS_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID
# Key definitions:
# KEY `IDX_CUSTOMER_ADDRESS_ENTITY_DATETIME_ENTITY_ID` (`entity_id`),
# UNIQUE KEY `UNQ_CUSTOMER_ADDRESS_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
# Column types:
# `entity_id` int(10) unsigned not null default '0' comment 'entity id'
# `attribute_id` smallint(5) unsigned not null default '0' comment 'attribute id'
# To remove this duplicate index, execute:
ALTER TABLE `customer_address_entity_datetime` DROP INDEX `IDX_CUSTOMER_ADDRESS_ENTITY_DATETIME_ENTITY_ID`;
# ########################################################################
# customer_address_entity_decimal
# ########################################################################
# IDX_CUSTOMER_ADDRESS_ENTITY_DECIMAL_ENTITY_ID is a left-prefix of UNQ_CUSTOMER_ADDRESS_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID
# Key definitions:
# KEY `IDX_CUSTOMER_ADDRESS_ENTITY_DECIMAL_ENTITY_ID` (`entity_id`),
# UNIQUE KEY `UNQ_CUSTOMER_ADDRESS_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
# Column types:
# `entity_id` int(10) unsigned not null default '0' comment 'entity id'
# `attribute_id` smallint(5) unsigned not null default '0' comment 'attribute id'
# To remove this duplicate index, execute:
ALTER TABLE `customer_address_entity_decimal` DROP INDEX `IDX_CUSTOMER_ADDRESS_ENTITY_DECIMAL_ENTITY_ID`;
# ########################################################################
# customer_address_entity_int
# ########################################################################
# IDX_CUSTOMER_ADDRESS_ENTITY_INT_ENTITY_ID is a left-prefix of UNQ_CUSTOMER_ADDRESS_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID
# Key definitions:
# KEY `IDX_CUSTOMER_ADDRESS_ENTITY_INT_ENTITY_ID` (`entity_id`),
# UNIQUE KEY `UNQ_CUSTOMER_ADDRESS_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
# Column types:
# `entity_id` int(10) unsigned not null default '0' comment 'entity id'
# `attribute_id` smallint(5) unsigned not null default '0' comment 'attribute id'
# To remove this duplicate index, execute:
ALTER TABLE `customer_address_entity_int` DROP INDEX `IDX_CUSTOMER_ADDRESS_ENTITY_INT_ENTITY_ID`;
# ########################################################################
# customer_address_entity_text
# ########################################################################
# IDX_CUSTOMER_ADDRESS_ENTITY_TEXT_ENTITY_ID is a left-prefix of UNQ_CUSTOMER_ADDRESS_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID
# Key definitions:
# KEY `IDX_CUSTOMER_ADDRESS_ENTITY_TEXT_ENTITY_ID` (`entity_id`),
# UNIQUE KEY `UNQ_CUSTOMER_ADDRESS_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
# Column types:
# `entity_id` int(10) unsigned not null default '0' comment 'entity id'
# `attribute_id` smallint(5) unsigned not null default '0' comment 'attribute id'
# To remove this duplicate index, execute:
ALTER TABLE `customer_address_entity_text` DROP INDEX `IDX_CUSTOMER_ADDRESS_ENTITY_TEXT_ENTITY_ID`;
# ########################################################################
# customer_address_entity_varchar
# ########################################################################
# IDX_CUSTOMER_ADDRESS_ENTITY_VARCHAR_ENTITY_ID is a left-prefix of UNQ_CUSTOMER_ADDRESS_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID
# Key definitions:
# KEY `IDX_CUSTOMER_ADDRESS_ENTITY_VARCHAR_ENTITY_ID` (`entity_id`),
# UNIQUE KEY `UNQ_CUSTOMER_ADDRESS_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
# Column types:
# `entity_id` int(10) unsigned not null default '0' comment 'entity id'
# `attribute_id` smallint(5) unsigned not null default '0' comment 'attribute id'
# To remove this duplicate index, execute:
ALTER TABLE `customer_address_entity_varchar` DROP INDEX `IDX_CUSTOMER_ADDRESS_ENTITY_VARCHAR_ENTITY_ID`;
# ########################################################################
# customer_entity
# ########################################################################
# IDX_CUSTOMER_ENTITY_EMAIL_WEBSITE_ID is a duplicate of UNQ_CUSTOMER_ENTITY_EMAIL_WEBSITE_ID
# Key definitions:
# KEY `IDX_CUSTOMER_ENTITY_EMAIL_WEBSITE_ID` (`email`,`website_id`),
# UNIQUE KEY `UNQ_CUSTOMER_ENTITY_EMAIL_WEBSITE_ID` (`email`,`website_id`),
# Column types:
# `email` varchar(255) default null comment 'email'
# `website_id` smallint(5) unsigned default null comment 'website id'
# To remove this duplicate index, execute:
ALTER TABLE `customer_entity` DROP INDEX `IDX_CUSTOMER_ENTITY_EMAIL_WEBSITE_ID`;
# ########################################################################
# customer_entity_datetime
# ########################################################################
# IDX_CUSTOMER_ENTITY_DATETIME_ENTITY_ID is a left-prefix of UNQ_CUSTOMER_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID
# Key definitions:
# KEY `IDX_CUSTOMER_ENTITY_DATETIME_ENTITY_ID` (`entity_id`),
# UNIQUE KEY `UNQ_CUSTOMER_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
# Column types:
# `entity_id` int(10) unsigned not null default '0' comment 'entity id'
# `attribute_id` smallint(5) unsigned not null default '0' comment 'attribute id'
# To remove this duplicate index, execute:
ALTER TABLE `customer_entity_datetime` DROP INDEX `IDX_CUSTOMER_ENTITY_DATETIME_ENTITY_ID`;
# ########################################################################
# customer_entity_decimal
# ########################################################################
# IDX_CUSTOMER_ENTITY_DECIMAL_ENTITY_ID is a left-prefix of UNQ_CUSTOMER_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID
# Key definitions:
# KEY `IDX_CUSTOMER_ENTITY_DECIMAL_ENTITY_ID` (`entity_id`),
# UNIQUE KEY `UNQ_CUSTOMER_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
# Column types:
# `entity_id` int(10) unsigned not null default '0' comment 'entity id'
# `attribute_id` smallint(5) unsigned not null default '0' comment 'attribute id'
# To remove this duplicate index, execute:
ALTER TABLE `customer_entity_decimal` DROP INDEX `IDX_CUSTOMER_ENTITY_DECIMAL_ENTITY_ID`;
# ########################################################################
# customer_entity_int
# ########################################################################
# IDX_CUSTOMER_ENTITY_INT_ENTITY_ID is a left-prefix of UNQ_CUSTOMER_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID
# Key definitions:
# KEY `IDX_CUSTOMER_ENTITY_INT_ENTITY_ID` (`entity_id`),
# UNIQUE KEY `UNQ_CUSTOMER_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
# Column types:
# `entity_id` int(10) unsigned not null default '0' comment 'entity id'
# `attribute_id` smallint(5) unsigned not null default '0' comment 'attribute id'
# To remove this duplicate index, execute:
ALTER TABLE `customer_entity_int` DROP INDEX `IDX_CUSTOMER_ENTITY_INT_ENTITY_ID`;
# ########################################################################
# customer_entity_text
# ########################################################################
# IDX_CUSTOMER_ENTITY_TEXT_ENTITY_ID is a left-prefix of UNQ_CUSTOMER_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID
# Key definitions:
# KEY `IDX_CUSTOMER_ENTITY_TEXT_ENTITY_ID` (`entity_id`),
# UNIQUE KEY `UNQ_CUSTOMER_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
# Column types:
# `entity_id` int(10) unsigned not null default '0' comment 'entity id'
# `attribute_id` smallint(5) unsigned not null default '0' comment 'attribute id'
# To remove this duplicate index, execute:
ALTER TABLE `customer_entity_text` DROP INDEX `IDX_CUSTOMER_ENTITY_TEXT_ENTITY_ID`;
# ########################################################################
# customer_entity_varchar
# ########################################################################
# IDX_CUSTOMER_ENTITY_VARCHAR_ENTITY_ID is a left-prefix of UNQ_CUSTOMER_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID
# Key definitions:
# KEY `IDX_CUSTOMER_ENTITY_VARCHAR_ENTITY_ID` (`entity_id`),
# UNIQUE KEY `UNQ_CUSTOMER_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
# Column types:
# `entity_id` int(10) unsigned not null default '0' comment 'entity id'
# `attribute_id` smallint(5) unsigned not null default '0' comment 'attribute id'
# To remove this duplicate index, execute:
ALTER TABLE `customer_entity_varchar` DROP INDEX `IDX_CUSTOMER_ENTITY_VARCHAR_ENTITY_ID`;
# ########################################################################
# downloadable_link
# ########################################################################
# IDX_DOWNLOADABLE_LINK_PRODUCT_ID is a left-prefix of IDX_DOWNLOADABLE_LINK_PRODUCT_ID_SORT_ORDER
# Key definitions:
# KEY `IDX_DOWNLOADABLE_LINK_PRODUCT_ID` (`product_id`),
# KEY `IDX_DOWNLOADABLE_LINK_PRODUCT_ID_SORT_ORDER` (`product_id`,`sort_order`),
# Column types:
# `product_id` int(10) unsigned not null default '0' comment 'product id'
# `sort_order` int(10) unsigned not null default '0' comment 'sort order'
# To remove this duplicate index, execute:
ALTER TABLE `downloadable_link` DROP INDEX `IDX_DOWNLOADABLE_LINK_PRODUCT_ID`;
# ########################################################################
# downloadable_link_title
# ########################################################################
# IDX_DOWNLOADABLE_LINK_TITLE_LINK_ID is a left-prefix of UNQ_DOWNLOADABLE_LINK_TITLE_LINK_ID_STORE_ID
# Key definitions:
# KEY `IDX_DOWNLOADABLE_LINK_TITLE_LINK_ID` (`link_id`),
# UNIQUE KEY `UNQ_DOWNLOADABLE_LINK_TITLE_LINK_ID_STORE_ID` (`link_id`,`store_id`),
# Column types:
# `link_id` int(10) unsigned not null default '0' comment 'link id'
# `store_id` smallint(5) unsigned not null default '0' comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `downloadable_link_title` DROP INDEX `IDX_DOWNLOADABLE_LINK_TITLE_LINK_ID`;
# ########################################################################
# downloadable_sample_title
# ########################################################################
# IDX_DOWNLOADABLE_SAMPLE_TITLE_SAMPLE_ID is a left-prefix of UNQ_DOWNLOADABLE_SAMPLE_TITLE_SAMPLE_ID_STORE_ID
# Key definitions:
# KEY `IDX_DOWNLOADABLE_SAMPLE_TITLE_SAMPLE_ID` (`sample_id`),
# UNIQUE KEY `UNQ_DOWNLOADABLE_SAMPLE_TITLE_SAMPLE_ID_STORE_ID` (`sample_id`,`store_id`),
# Column types:
# `sample_id` int(10) unsigned not null default '0' comment 'sample id'
# `store_id` smallint(5) unsigned not null default '0' comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `downloadable_sample_title` DROP INDEX `IDX_DOWNLOADABLE_SAMPLE_TITLE_SAMPLE_ID`;
# ########################################################################
# eav_attribute
# ########################################################################
# IDX_EAV_ATTRIBUTE_ENTITY_TYPE_ID is a left-prefix of UNQ_EAV_ATTRIBUTE_ENTITY_TYPE_ID_ATTRIBUTE_CODE
# Key definitions:
# KEY `IDX_EAV_ATTRIBUTE_ENTITY_TYPE_ID` (`entity_type_id`),
# UNIQUE KEY `UNQ_EAV_ATTRIBUTE_ENTITY_TYPE_ID_ATTRIBUTE_CODE` (`entity_type_id`,`attribute_code`),
# Column types:
# `entity_type_id` smallint(5) unsigned not null default '0' comment 'entity type id'
# `attribute_code` varchar(255) not null comment 'attribute code'
# To remove this duplicate index, execute:
ALTER TABLE `eav_attribute` DROP INDEX `IDX_EAV_ATTRIBUTE_ENTITY_TYPE_ID`;
# ########################################################################
# eav_attribute_label
# ########################################################################
# IDX_EAV_ATTRIBUTE_LABEL_ATTRIBUTE_ID is a left-prefix of IDX_EAV_ATTRIBUTE_LABEL_ATTRIBUTE_ID_STORE_ID
# Key definitions:
# KEY `IDX_EAV_ATTRIBUTE_LABEL_ATTRIBUTE_ID` (`attribute_id`),
# KEY `IDX_EAV_ATTRIBUTE_LABEL_ATTRIBUTE_ID_STORE_ID` (`attribute_id`,`store_id`),
# Column types:
# `attribute_id` smallint(5) unsigned not null default '0' comment 'attribute id'
# `store_id` smallint(5) unsigned not null default '0' comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `eav_attribute_label` DROP INDEX `IDX_EAV_ATTRIBUTE_LABEL_ATTRIBUTE_ID`;
# ########################################################################
# eav_entity_datetime
# ########################################################################
# IDX_EAV_ENTITY_DATETIME_ENTITY_ID is a left-prefix of UNQ_EAV_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID_STORE_ID
# Key definitions:
# KEY `IDX_EAV_ENTITY_DATETIME_ENTITY_ID` (`entity_id`),
# UNIQUE KEY `UNQ_EAV_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
# Column types:
# `entity_id` int(10) unsigned not null comment 'entity id'
# `attribute_id` smallint(5) unsigned not null comment 'attribute id'
# `store_id` smallint(5) unsigned not null comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `eav_entity_datetime` DROP INDEX `IDX_EAV_ENTITY_DATETIME_ENTITY_ID`;
# IDX_EAV_ENTITY_DATETIME_ENTITY_TYPE_ID is a left-prefix of IDX_EAV_ENTITY_DATETIME_ENTITY_TYPE_ID_VALUE
# Key definitions:
# KEY `IDX_EAV_ENTITY_DATETIME_ENTITY_TYPE_ID` (`entity_type_id`),
# KEY `IDX_EAV_ENTITY_DATETIME_ENTITY_TYPE_ID_VALUE` (`entity_type_id`,`value`),
# Column types:
# `entity_type_id` smallint(5) unsigned not null comment 'entity type id'
# `value` datetime not null default '0000-00-00 00:00:00' comment 'attribute value'
# To remove this duplicate index, execute:
ALTER TABLE `eav_entity_datetime` DROP INDEX `IDX_EAV_ENTITY_DATETIME_ENTITY_TYPE_ID`;
# IDX_EAV_ENTITY_DATETIME_ATTRIBUTE_ID is a left-prefix of IDX_EAV_ENTITY_DATETIME_ATTRIBUTE_ID_VALUE
# Key definitions:
# KEY `IDX_EAV_ENTITY_DATETIME_ATTRIBUTE_ID` (`attribute_id`),
# KEY `IDX_EAV_ENTITY_DATETIME_ATTRIBUTE_ID_VALUE` (`attribute_id`,`value`),
# Column types:
# `attribute_id` smallint(5) unsigned not null comment 'attribute id'
# `value` datetime not null default '0000-00-00 00:00:00' comment 'attribute value'
# To remove this duplicate index, execute:
ALTER TABLE `eav_entity_datetime` DROP INDEX `IDX_EAV_ENTITY_DATETIME_ATTRIBUTE_ID`;
# ########################################################################
# eav_entity_decimal
# ########################################################################
# IDX_EAV_ENTITY_DECIMAL_ENTITY_ID is a left-prefix of UNQ_EAV_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID_STORE_ID
# Key definitions:
# KEY `IDX_EAV_ENTITY_DECIMAL_ENTITY_ID` (`entity_id`),
# UNIQUE KEY `UNQ_EAV_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
# Column types:
# `entity_id` int(10) unsigned not null comment 'entity id'
# `attribute_id` smallint(5) unsigned not null comment 'attribute id'
# `store_id` smallint(5) unsigned not null comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `eav_entity_decimal` DROP INDEX `IDX_EAV_ENTITY_DECIMAL_ENTITY_ID`;
# IDX_EAV_ENTITY_DECIMAL_ENTITY_TYPE_ID is a left-prefix of IDX_EAV_ENTITY_DECIMAL_ENTITY_TYPE_ID_VALUE
# Key definitions:
# KEY `IDX_EAV_ENTITY_DECIMAL_ENTITY_TYPE_ID` (`entity_type_id`),
# KEY `IDX_EAV_ENTITY_DECIMAL_ENTITY_TYPE_ID_VALUE` (`entity_type_id`,`value`),
# Column types:
# `entity_type_id` smallint(5) unsigned not null comment 'entity type id'
# `value` decimal(12,4) not null default '0.0000' comment 'attribute value'
# To remove this duplicate index, execute:
ALTER TABLE `eav_entity_decimal` DROP INDEX `IDX_EAV_ENTITY_DECIMAL_ENTITY_TYPE_ID`;
# IDX_EAV_ENTITY_DECIMAL_ATTRIBUTE_ID is a left-prefix of IDX_EAV_ENTITY_DECIMAL_ATTRIBUTE_ID_VALUE
# Key definitions:
# KEY `IDX_EAV_ENTITY_DECIMAL_ATTRIBUTE_ID` (`attribute_id`),
# KEY `IDX_EAV_ENTITY_DECIMAL_ATTRIBUTE_ID_VALUE` (`attribute_id`,`value`),
# Column types:
# `attribute_id` smallint(5) unsigned not null comment 'attribute id'
# `value` decimal(12,4) not null default '0.0000' comment 'attribute value'
# To remove this duplicate index, execute:
ALTER TABLE `eav_entity_decimal` DROP INDEX `IDX_EAV_ENTITY_DECIMAL_ATTRIBUTE_ID`;
# ########################################################################
# eav_entity_int
# ########################################################################
# IDX_EAV_ENTITY_INT_ENTITY_ID is a left-prefix of UNQ_EAV_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID
# Key definitions:
# KEY `IDX_EAV_ENTITY_INT_ENTITY_ID` (`entity_id`),
# UNIQUE KEY `UNQ_EAV_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
# Column types:
# `entity_id` int(10) unsigned not null comment 'entity id'
# `attribute_id` smallint(5) unsigned not null comment 'attribute id'
# `store_id` smallint(5) unsigned not null comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `eav_entity_int` DROP INDEX `IDX_EAV_ENTITY_INT_ENTITY_ID`;
# IDX_EAV_ENTITY_INT_ENTITY_TYPE_ID is a left-prefix of IDX_EAV_ENTITY_INT_ENTITY_TYPE_ID_VALUE
# Key definitions:
# KEY `IDX_EAV_ENTITY_INT_ENTITY_TYPE_ID` (`entity_type_id`),
# KEY `IDX_EAV_ENTITY_INT_ENTITY_TYPE_ID_VALUE` (`entity_type_id`,`value`),
# Column types:
# `entity_type_id` smallint(5) unsigned not null comment 'entity type id'
# `value` int(11) not null comment 'attribute value'
# To remove this duplicate index, execute:
ALTER TABLE `eav_entity_int` DROP INDEX `IDX_EAV_ENTITY_INT_ENTITY_TYPE_ID`;
# IDX_EAV_ENTITY_INT_ATTRIBUTE_ID is a left-prefix of IDX_EAV_ENTITY_INT_ATTRIBUTE_ID_VALUE
# Key definitions:
# KEY `IDX_EAV_ENTITY_INT_ATTRIBUTE_ID` (`attribute_id`),
# KEY `IDX_EAV_ENTITY_INT_ATTRIBUTE_ID_VALUE` (`attribute_id`,`value`),
# Column types:
# `attribute_id` smallint(5) unsigned not null comment 'attribute id'
# `value` int(11) not null comment 'attribute value'
# To remove this duplicate index, execute:
ALTER TABLE `eav_entity_int` DROP INDEX `IDX_EAV_ENTITY_INT_ATTRIBUTE_ID`;
# ########################################################################
# eav_entity_text
# ########################################################################
# IDX_EAV_ENTITY_TEXT_ENTITY_ID is a left-prefix of UNQ_EAV_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID
# Key definitions:
# KEY `IDX_EAV_ENTITY_TEXT_ENTITY_ID` (`entity_id`),
# UNIQUE KEY `UNQ_EAV_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
# Column types:
# `entity_id` int(10) unsigned not null comment 'entity id'
# `attribute_id` smallint(5) unsigned not null comment 'attribute id'
# `store_id` smallint(5) unsigned not null comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `eav_entity_text` DROP INDEX `IDX_EAV_ENTITY_TEXT_ENTITY_ID`;
# ########################################################################
# eav_entity_varchar
# ########################################################################
# IDX_EAV_ENTITY_VARCHAR_ENTITY_ID is a left-prefix of UNQ_EAV_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID_STORE_ID
# Key definitions:
# KEY `IDX_EAV_ENTITY_VARCHAR_ENTITY_ID` (`entity_id`),
# UNIQUE KEY `UNQ_EAV_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
# Column types:
# `entity_id` int(10) unsigned not null comment 'entity id'
# `attribute_id` smallint(5) unsigned not null comment 'attribute id'
# `store_id` smallint(5) unsigned not null comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `eav_entity_varchar` DROP INDEX `IDX_EAV_ENTITY_VARCHAR_ENTITY_ID`;
# IDX_EAV_ENTITY_VARCHAR_ENTITY_TYPE_ID is a left-prefix of IDX_EAV_ENTITY_VARCHAR_ENTITY_TYPE_ID_VALUE
# Key definitions:
# KEY `IDX_EAV_ENTITY_VARCHAR_ENTITY_TYPE_ID` (`entity_type_id`),
# KEY `IDX_EAV_ENTITY_VARCHAR_ENTITY_TYPE_ID_VALUE` (`entity_type_id`,`value`),
# Column types:
# `entity_type_id` smallint(5) unsigned not null comment 'entity type id'
# `value` varchar(255) not null comment 'attribute value'
# To remove this duplicate index, execute:
ALTER TABLE `eav_entity_varchar` DROP INDEX `IDX_EAV_ENTITY_VARCHAR_ENTITY_TYPE_ID`;
# IDX_EAV_ENTITY_VARCHAR_ATTRIBUTE_ID is a left-prefix of IDX_EAV_ENTITY_VARCHAR_ATTRIBUTE_ID_VALUE
# Key definitions:
# KEY `IDX_EAV_ENTITY_VARCHAR_ATTRIBUTE_ID` (`attribute_id`),
# KEY `IDX_EAV_ENTITY_VARCHAR_ATTRIBUTE_ID_VALUE` (`attribute_id`,`value`),
# Column types:
# `attribute_id` smallint(5) unsigned not null comment 'attribute id'
# `value` varchar(255) not null comment 'attribute value'
# To remove this duplicate index, execute:
ALTER TABLE `eav_entity_varchar` DROP INDEX `IDX_EAV_ENTITY_VARCHAR_ATTRIBUTE_ID`;
# ########################################################################
# eav_form_element
# ########################################################################
# IDX_EAV_FORM_ELEMENT_TYPE_ID is a left-prefix of UNQ_EAV_FORM_ELEMENT_TYPE_ID_ATTRIBUTE_ID
# Key definitions:
# KEY `IDX_EAV_FORM_ELEMENT_TYPE_ID` (`type_id`),
# UNIQUE KEY `UNQ_EAV_FORM_ELEMENT_TYPE_ID_ATTRIBUTE_ID` (`type_id`,`attribute_id`),
# Column types:
# `type_id` smallint(5) unsigned not null default '0' comment 'type id'
# `attribute_id` smallint(5) unsigned not null default '0' comment 'attribute id'
# To remove this duplicate index, execute:
ALTER TABLE `eav_form_element` DROP INDEX `IDX_EAV_FORM_ELEMENT_TYPE_ID`;
# ########################################################################
# eav_form_fieldset
# ########################################################################
# IDX_EAV_FORM_FIELDSET_TYPE_ID is a left-prefix of UNQ_EAV_FORM_FIELDSET_TYPE_ID_CODE
# Key definitions:
# KEY `IDX_EAV_FORM_FIELDSET_TYPE_ID` (`type_id`),
# UNIQUE KEY `UNQ_EAV_FORM_FIELDSET_TYPE_ID_CODE` (`type_id`,`code`),
# Column types:
# `type_id` smallint(5) unsigned not null default '0' comment 'type id'
# `code` varchar(64) not null comment 'code'
# To remove this duplicate index, execute:
ALTER TABLE `eav_form_fieldset` DROP INDEX `IDX_EAV_FORM_FIELDSET_TYPE_ID`;
# ########################################################################
# eav_form_fieldset_label
# ########################################################################
# IDX_EAV_FORM_FIELDSET_LABEL_FIELDSET_ID is a left-prefix of PRIMARY
# Key definitions:
# KEY `IDX_EAV_FORM_FIELDSET_LABEL_FIELDSET_ID` (`fieldset_id`),
# PRIMARY KEY (`fieldset_id`,`store_id`),
# Column types:
# `fieldset_id` smallint(5) unsigned not null default '0' comment 'fieldset id'
# `store_id` smallint(5) unsigned not null default '0' comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `eav_form_fieldset_label` DROP INDEX `IDX_EAV_FORM_FIELDSET_LABEL_FIELDSET_ID`;
# ########################################################################
# newsletter_queue_link
# ########################################################################
# IDX_NEWSLETTER_QUEUE_LINK_QUEUE_ID is a left-prefix of IDX_NEWSLETTER_QUEUE_LINK_QUEUE_ID_LETTER_SENT_AT
# Key definitions:
# KEY `IDX_NEWSLETTER_QUEUE_LINK_QUEUE_ID` (`queue_id`),
# KEY `IDX_NEWSLETTER_QUEUE_LINK_QUEUE_ID_LETTER_SENT_AT` (`queue_id`,`letter_sent_at`),
# Column types:
# `queue_id` int(10) unsigned not null default '0' comment 'queue id'
# `letter_sent_at` timestamp null default null comment 'letter sent at'
# To remove this duplicate index, execute:
ALTER TABLE `newsletter_queue_link` DROP INDEX `IDX_NEWSLETTER_QUEUE_LINK_QUEUE_ID`;
# ########################################################################
# sales_order_tax_item
# ########################################################################
# IDX_SALES_ORDER_TAX_ITEM_TAX_ID is a left-prefix of UNQ_SALES_ORDER_TAX_ITEM_TAX_ID_ITEM_ID
# Key definitions:
# KEY `IDX_SALES_ORDER_TAX_ITEM_TAX_ID` (`tax_id`),
# UNIQUE KEY `UNQ_SALES_ORDER_TAX_ITEM_TAX_ID_ITEM_ID` (`tax_id`,`item_id`),
# Column types:
# `tax_id` int(10) unsigned not null comment 'tax id'
# `item_id` int(10) unsigned not null comment 'item id'
# To remove this duplicate index, execute:
ALTER TABLE `sales_order_tax_item` DROP INDEX `IDX_SALES_ORDER_TAX_ITEM_TAX_ID`;
# ########################################################################
# sales_payment_transaction
# ########################################################################
# IDX_SALES_PAYMENT_TRANSACTION_ORDER_ID is a left-prefix of UNQ_SALES_PAYMENT_TRANSACTION_ORDER_ID_PAYMENT_ID_TXN_ID
# Key definitions:
# KEY `IDX_SALES_PAYMENT_TRANSACTION_ORDER_ID` (`order_id`),
# UNIQUE KEY `UNQ_SALES_PAYMENT_TRANSACTION_ORDER_ID_PAYMENT_ID_TXN_ID` (`order_id`,`payment_id`,`txn_id`),
# Column types:
# `order_id` int(10) unsigned not null comment 'order id'
# `payment_id` int(10) unsigned not null comment 'payment id'
# `txn_id` varchar(100) default null comment 'txn id'
# To remove this duplicate index, execute:
ALTER TABLE `sales_payment_transaction` DROP INDEX `IDX_SALES_PAYMENT_TRANSACTION_ORDER_ID`;
# ########################################################################
# salesrule_coupon_usage
# ########################################################################
# IDX_SALESRULE_COUPON_USAGE_COUPON_ID is a left-prefix of PRIMARY
# Key definitions:
# KEY `IDX_SALESRULE_COUPON_USAGE_COUPON_ID` (`coupon_id`),
# PRIMARY KEY (`coupon_id`,`customer_id`),
# Column types:
# `coupon_id` int(10) unsigned not null comment 'coupon id'
# `customer_id` int(10) unsigned not null comment 'customer id'
# To remove this duplicate index, execute:
ALTER TABLE `salesrule_coupon_usage` DROP INDEX `IDX_SALESRULE_COUPON_USAGE_COUPON_ID`;
# ########################################################################
# salesrule_customer_group
# ########################################################################
# IDX_SALESRULE_CUSTOMER_GROUP_RULE_ID is a left-prefix of PRIMARY
# Key definitions:
# KEY `IDX_SALESRULE_CUSTOMER_GROUP_RULE_ID` (`rule_id`),
# PRIMARY KEY (`rule_id`,`customer_group_id`),
# Column types:
# `rule_id` int(10) unsigned not null comment 'rule id'
# `customer_group_id` smallint(5) unsigned not null comment 'customer group id'
# To remove this duplicate index, execute:
ALTER TABLE `salesrule_customer_group` DROP INDEX `IDX_SALESRULE_CUSTOMER_GROUP_RULE_ID`;
# ########################################################################
# salesrule_label
# ########################################################################
# IDX_SALESRULE_LABEL_RULE_ID is a left-prefix of UNQ_SALESRULE_LABEL_RULE_ID_STORE_ID
# Key definitions:
# KEY `IDX_SALESRULE_LABEL_RULE_ID` (`rule_id`),
# UNIQUE KEY `UNQ_SALESRULE_LABEL_RULE_ID_STORE_ID` (`rule_id`,`store_id`),
# Column types:
# `rule_id` int(10) unsigned not null comment 'rule id'
# `store_id` smallint(5) unsigned not null comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `salesrule_label` DROP INDEX `IDX_SALESRULE_LABEL_RULE_ID`;
# ########################################################################
# salesrule_website
# ########################################################################
# IDX_SALESRULE_WEBSITE_RULE_ID is a left-prefix of PRIMARY
# Key definitions:
# KEY `IDX_SALESRULE_WEBSITE_RULE_ID` (`rule_id`),
# PRIMARY KEY (`rule_id`,`website_id`),
# Column types:
# `rule_id` int(10) unsigned not null comment 'rule id'
# `website_id` smallint(5) unsigned not null comment 'website id'
# To remove this duplicate index, execute:
ALTER TABLE `salesrule_website` DROP INDEX `IDX_SALESRULE_WEBSITE_RULE_ID`;
# ########################################################################
# solrbridge_solrsearch_index_english
# ########################################################################
# IDX_SOLRBRIDGE_SOLRSEARCH_INDEX_ENGLISH_STORE_ID is a left-prefix of PRIMARY
# Key definitions:
# KEY `IDX_SOLRBRIDGE_SOLRSEARCH_INDEX_ENGLISH_STORE_ID` (`store_id`),
# PRIMARY KEY (`store_id`,`value`),
# Column types:
# `store_id` smallint(5) unsigned not null default '0' comment 'store id'
# `value` int(10) unsigned not null default '0' comment 'product id'
# To remove this duplicate index, execute:
ALTER TABLE `solrbridge_solrsearch_index_english` DROP INDEX `IDX_SOLRBRIDGE_SOLRSEARCH_INDEX_ENGLISH_STORE_ID`;
# ########################################################################
# solrbridge_solrsearch_logs
# ########################################################################
# IDX_WEBMODS_SOLRSEARCH_LOGS_LOGS_ID is a duplicate of PRIMARY
# Key definitions:
# KEY `IDX_WEBMODS_SOLRSEARCH_LOGS_LOGS_ID` (`logs_id`),
# PRIMARY KEY (`logs_id`),
# Column types:
# `logs_id` int(10) not null auto_increment
# To remove this duplicate index, execute:
ALTER TABLE `solrbridge_solrsearch_logs` DROP INDEX `IDX_WEBMODS_SOLRSEARCH_LOGS_LOGS_ID`;
# ########################################################################
# tag_relation
# ########################################################################
# IDX_TAG_RELATION_TAG_ID is a left-prefix of UNQ_TAG_RELATION_TAG_ID_CUSTOMER_ID_PRODUCT_ID_STORE_ID
# Key definitions:
# KEY `IDX_TAG_RELATION_TAG_ID` (`tag_id`),
# UNIQUE KEY `UNQ_TAG_RELATION_TAG_ID_CUSTOMER_ID_PRODUCT_ID_STORE_ID` (`tag_id`,`customer_id`,`product_id`,`store_id`),
# Column types:
# `tag_id` int(10) unsigned not null default '0' comment 'tag id'
# `customer_id` int(10) unsigned default null comment 'customer id'
# `product_id` int(10) unsigned not null default '0' comment 'product id'
# `store_id` smallint(5) unsigned not null default '1' comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `tag_relation` DROP INDEX `IDX_TAG_RELATION_TAG_ID`;
# ########################################################################
# tag_summary
# ########################################################################
# IDX_TAG_SUMMARY_TAG_ID is a left-prefix of PRIMARY
# Key definitions:
# KEY `IDX_TAG_SUMMARY_TAG_ID` (`tag_id`),
# PRIMARY KEY (`tag_id`,`store_id`),
# Column types:
# `tag_id` int(10) unsigned not null default '0' comment 'tag id'
# `store_id` smallint(5) unsigned not null default '0' comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `tag_summary` DROP INDEX `IDX_TAG_SUMMARY_TAG_ID`;
# ########################################################################
# tax_calculation
# ########################################################################
# IDX_TAX_CALCULATION_TAX_CALCULATION_RATE_ID is a left-prefix of IDX_TAX_CALC_TAX_CALC_RATE_ID_CSTR_TAX_CLASS_ID_PRD_TAX_CLASS_ID
# Key definitions:
# KEY `IDX_TAX_CALCULATION_TAX_CALCULATION_RATE_ID` (`tax_calculation_rate_id`),
# KEY `IDX_TAX_CALC_TAX_CALC_RATE_ID_CSTR_TAX_CLASS_ID_PRD_TAX_CLASS_ID` (`tax_calculation_rate_id`,`customer_tax_class_id`,`product_tax_class_id`),
# Column types:
# `tax_calculation_rate_id` int(11) not null comment 'tax calculation rate id'
# `customer_tax_class_id` smallint(6) not null comment 'customer tax class id'
# `product_tax_class_id` smallint(6) not null comment 'product tax class id'
# To remove this duplicate index, execute:
ALTER TABLE `tax_calculation` DROP INDEX `IDX_TAX_CALCULATION_TAX_CALCULATION_RATE_ID`;
# ########################################################################
# tax_calculation_rate_title
# ########################################################################
# IDX_TAX_CALCULATION_RATE_TITLE_TAX_CALCULATION_RATE_ID is a left-prefix of IDX_TAX_CALCULATION_RATE_TITLE_TAX_CALCULATION_RATE_ID_STORE_ID
# Key definitions:
# KEY `IDX_TAX_CALCULATION_RATE_TITLE_TAX_CALCULATION_RATE_ID` (`tax_calculation_rate_id`),
# KEY `IDX_TAX_CALCULATION_RATE_TITLE_TAX_CALCULATION_RATE_ID_STORE_ID` (`tax_calculation_rate_id`,`store_id`),
# Column types:
# `tax_calculation_rate_id` int(11) not null comment 'tax calculation rate id'
# `store_id` smallint(5) unsigned not null comment 'store id'
# To remove this duplicate index, execute:
ALTER TABLE `tax_calculation_rate_title` DROP INDEX `IDX_TAX_CALCULATION_RATE_TITLE_TAX_CALCULATION_RATE_ID`;
# ########################################################################
# tax_calculation_rule
# ########################################################################
# Key IDX_TAX_CALC_RULE_PRIORITY_POSITION_TAX_CALC_RULE_ID ends with a prefix of the clustered index
# Key definitions:
# KEY `IDX_TAX_CALC_RULE_PRIORITY_POSITION_TAX_CALC_RULE_ID` (`priority`,`position`,`tax_calculation_rule_id`),
# PRIMARY KEY (`tax_calculation_rule_id`),
# Column types:
# `priority` int(11) not null comment 'priority'
# `position` int(11) not null comment 'position'
# `tax_calculation_rule_id` int(11) not null auto_increment comment 'tax calculation rule id'
# To shorten this duplicate clustered index, execute:
ALTER TABLE `tax_calculation_rule` DROP INDEX `IDX_TAX_CALC_RULE_PRIORITY_POSITION_TAX_CALC_RULE_ID`, ADD INDEX `IDX_TAX_CALC_RULE_PRIORITY_POSITION_TAX_CALC_RULE_ID` (`priority`,`position`);
# ########################################################################
# widget_instance_page_layout
# ########################################################################
# IDX_WIDGET_INSTANCE_PAGE_LAYOUT_LAYOUT_UPDATE_ID is a left-prefix of UNQ_WIDGET_INSTANCE_PAGE_LAYOUT_LAYOUT_UPDATE_ID_PAGE_ID
# Key definitions:
# KEY `IDX_WIDGET_INSTANCE_PAGE_LAYOUT_LAYOUT_UPDATE_ID` (`layout_update_id`),
# UNIQUE KEY `UNQ_WIDGET_INSTANCE_PAGE_LAYOUT_LAYOUT_UPDATE_ID_PAGE_ID` (`layout_update_id`,`page_id`),
# Column types:
# `layout_update_id` int(10) unsigned not null default '0' comment 'layout update id'
# `page_id` int(10) unsigned not null default '0' comment 'page id'
# To remove this duplicate index, execute:
ALTER TABLE `widget_instance_page_layout` DROP INDEX `IDX_WIDGET_INSTANCE_PAGE_LAYOUT_LAYOUT_UPDATE_ID`;
# ########################################################################
# Summary of indexes
# ########################################################################
# Size Duplicate Indexes 438610236
# Total Duplicate Indexes 88
# Total Indexes 1614
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment