MySQL Workbench - Synchronize EER model with DB - Erno 150 Can't create table

488 Views Asked by At

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
0

There are 0 best solutions below