Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Alter Index IDX_CATALOG_PRODUCT_ENTITY_SKU set as unique Table catalog_product_entity MySQL
 
floor_e
Jr. Member
 
Total Posts:  1
Joined:  2012-06-07
 

Hello, my first post here. I’ve been searching over the internet and I can’t find any answer to this question.

Table catalog_product_entity
Index IDX_CATALOG_PRODUCT_ENTITY_SKU

I’m wandering why the index hasn’t been set as unique. Does it cause any problems?
It seems to me that altering the index to unique is quite obvious. A SKU is always unique. Why not enforce this in the database?

With best regards,

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top