Re: Can't create table with Foreign Keys - errno:150??

[aftab khan]

This will work!

CREATE TABLE Contact_Organisation (
org_ID INT(10) UNSIGNED NOT NULL,
c_type enum('organisation','individual') NOT NULL,
name VARCHAR(100) NULL ,
web VARCHAR(100) NULL ,
PRIMARY KEY (org_ID),
FOREIGN KEY (org_ID,c_type) REFERENCES Contacts (`contact_ID`,`contact_type`)
ON DELETE CASCADE
ON UPDATE CASCADE
)ENGINE = INNODB;