I'm trying to synchronize my EER model with my DB in MySQL Workbench, and one table fails to synchronize. I also checked that my foreign keys have the same datatype as the column they refer to. Here is the output:
Executing SQL script in server
ERROR: Error 1005: Can't create table 'veiling.#sql-4f8_47' (errno: 150)
ALTER TABLE `veiling`.`boden`
ADD CONSTRAINT `fk_boden_veilingen1`
FOREIGN KEY (`veilingId` )
REFERENCES `veiling`.`veilingen` (`veilingId` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_boden_gebruikers1`
FOREIGN KEY (`gebruikerId` )
REFERENCES `veiling`.`gebruikers` (`gebruikerId` )
ON DELETE NO ACTION
ON UPDATE NO ACTION
, ADD INDEX `fk_boden_veilingen1_idx` (`veilingId` ASC)
, ADD INDEX `fk_boden_gebruikers1_idx` (`gebruikerId` ASC)
, DROP INDEX `fk_boden_gebruikers1_idx`
, DROP INDEX `fk_boden_veilingen1_idx`
SQL script execution finished: statements: 3 succeeded, 1 failed