What is wrong with this Query?
Posted: Fri Jun 18, 2010 9:04 am
What is wrong with my query below? I keep getting an error but I dont really understand why...
[Err] 1005 - Can't create table 'mediarecall_jobs.fruits' (errno: 150)
Any help would be appreciated!
Code: Select all
CREATE TABLE fruits
(
apples BIGINT NOT NULL,
bananas BIGINT NOT NULL,
oranges VARCHAR(255) NOT NULL,
PRIMARY KEY (apples, bananas, oranges),
KEY fruits_oranges(oranges),
CONSTRAINT fruits_apples FOREIGN KEY (apples) REFERENCES produce (apples) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT fruits_bananas FOREIGN KEY (bananas) REFERENCES produce (bananas) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;Any help would be appreciated!