Re: Deadlock while create new entry

[Rafal Kedziorski]

This is the table definition:

CREATE TABLE `media_file_2_shopping_cart` (
`media_file_2_shopping_cart_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
`media_file_id` BIGINT UNSIGNED NOT NULL,
`shopping_cart_id` BIGINT UNSIGNED NOT NULL,
`amount` SMALLINT UNSIGNED NOT NULL,
`creation_date` DATETIME NOT NULL,
`last_change_date` DATETIME,
#
PRIMARY KEY (`media_file_2_shopping_cart_id`),
INDEX (`media_file_id`),
INDEX (`shopping_cart_id`),
FOREIGN KEY (`media_file_id`)
REFERENCES `media_file` (`media_file_id`),
FOREIGN KEY (`shopping_cart_id`)
REFERENCES `shopping_cart` (`shopping_cart_id`)
) TYPE=InnoDB;


Regards,
Rafal