Why am I getting (errno: 150 "Foreign key constraint is incorrectly formed")?
CREATE TABLE `company_pmc` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL COLLATE 'latin1_swedish_ci',
`pmcid` INT(11) NOT NULL,
PRIMARY KEY (`id`) USING BTREE
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
;
CREATE TABLE `company_properties` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL COLLATE 'latin1_swedish_ci',
`pmcid` INT(11) NOT NULL,
`pid` INT(11) NOT NULL,
PRIMARY KEY (`id`) USING BTREE,
CONSTRAINT `FK_company_properties_company_pmc` FOREIGN KEY (`pmcid`) REFERENCES `company_pmc` (`pmcid`) ON UPDATE CASCADE ON DELETE CASCADE
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
;