Executing SQL script in server
ERROR: Error 1215: Cannot add foreign key constraint


CREATE TABLE IF NOT EXISTS `CollegeDB`.`Eleve` (
 `idPersonne` VARCHAR(15) NOT NULL,
 `dateNaissance` DATE NULL,
 `lieuNaissance` VARCHAR(45) NULL,
PRIMARY KEY (`idPersonne`),
INDEX `fk_Eleve_Personne1_idx` (`idPersonne` ASC),
CONSTRAINT `fk_Eleve_Personne1`
FOREIGN KEY (`idPersonne`)
REFERENCES `CollegeDB`.`Personne` (`idPersonne`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB

SQL script execution finished: statements: 10 succeeded, 1 failed

Fetching back view definitions in final form.
Nothing to fetch