Re: Deadlock while create new entry
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
Subject
Views
Written By
Posted
3126
May 04, 2005 10:10AM
Re: Deadlock while create new entry
2049
May 05, 2005 04:22PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.