MySQL (errno: 150 "Foreign key constraint is incorrectly formed")

Viewed 42

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
;
0 Answers
Related