Database

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.