MySQL Forums
Forum List  »  InnoDB

Re: Deadlock while create new entry
Posted by: Rafal Kedziorski
Date: May 05, 2005 04:22PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Deadlock while create new entry
2053
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.