When I try to generate a database using Forward Engineer I get an error like this.
Executing SQL script in server
ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE, INDEX
fk_Personal_Human1_idx
(Human_idMan
ASC) VISIBLE, CONSTRA' at line 12
SQL Code:
-- -----------------------------------------------------
-- Table `mydb`.`Personal`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Personal` (
`idPersonal` INT NOT NULL,
`Experience` INT NULL,
`Department_idDepartment` INT NOT NULL,
`Date_of_accept` DATE NOT NULL,
`Date_of_release` DATE NULL,
`Human_idMan` INT NOT NULL,
PRIMARY KEY (`idPersonal`),
INDEX `fk_Personal_Department1_idx` (`Department_idDepartment` ASC) VISIBLE,
INDEX `fk_Personal_Human1_idx` (`Human_idMan` ASC) VISIBLE,
CONSTRAINT `fk_Personal_Department1`
FOREIGN KEY (`Department_idDepartment`)
REFERENCES `mydb`.`Department` (`idDepartment`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_Personal_Human1`
FOREIGN KEY (`Human_idMan`)
REFERENCES `mydb`.`Human` (`idMan`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
SQL script execution finished: statements: 7 succeeded, 1 failed
Fetching back view definitions in final form. Nothing to fetch
See Question&Answers more detail:os