ALTER TABLE `ps_specific_price` ENGINE=MyISAM;
ALTER IGNORE TABLE `ps_specific_price` ADD UNIQUE KEY `id_product_2` (`id_cart`,`id_product`,`id_shop`,`id_shop_group`,`id_currency`,`id_country`,`id_group`,`id_customer`,`id_product_attribute`,`from_quantity`,`id_specific_price_rule`,`from`,`to`);
Tried to use this, but it gives me an error
Comando SQL:
ALTER IGNORE TABLE `ps_specific_price` ADD UNIQUE KEY `id_product_2` ( `id_cart` , `id_product` , `id_shop` , `id_shop_group` ,`id_currency` , `id_country` , `id_group` , `id_customer` , `id_product_attribute` , `from_quantity` , `id_specific_price_rule` , `from` , `to`) ;
Mensagens do MySQL :
#1062 - Duplicate entry '0-4010-0-0-0-0-2-0-0-1-0-0000-00-00 00:00:00-0000-00-00 00:00:00' for key 'id_product_2'