From phpMyAdmin when click check tables got this one:
Problems with indexes of table cscart_destinations
PRIMARY and INDEX keys should not both be set for column destination_id
Problems with indexes of table cscart_forms
UNIQUE and INDEX keys should not both be set for column name
Problems with indexes of table cscart_memberships
PRIMARY and INDEX keys should not both be set for column membership_id
Problems with indexes of table cscart_pages
PRIMARY and INDEX keys should not both be set for column page_id
Problems with indexes of table cscart_page_descriptions
PRIMARY and INDEX keys should not both be set for column page_id
Problems with indexes of table cscart_product_descriptions
More than one FULLTEXT key was created for column product
More than one FULLTEXT key was created for column short_description
Problems with indexes of table cscart_related_products
UNIQUE and INDEX keys should not both be set for column master_id
Problems with indexes of table cscart_sessions
PRIMARY and INDEX keys should not both be set for column session_id
Problems with indexes of table cscart_settings_descriptions
PRIMARY and INDEX keys should not both be set for column object_id
Problems with indexes of table cscart_shipping_services
PRIMARY and INDEX keys should not both be set for column service_id
Problems with indexes of table cscart_states
More than one INDEX key was created for column country_code
Problems with indexes of table cscart_topic_descriptions
PRIMARY and INDEX keys should not both be set for column topic_id
Please tell me what is that?
Bug or…?
Hi dominos_2004
I think that cs-cart uses these overlapping indexes for improving performance.
phpMyAdmin considers the overlapped indexes inconsistent because they are being paranoid. its not a bug, all are tables are the same.