Galera estou com o seguinte erro:
Executing SQL script in server
ERROR: Error 1215: Cannot add foreign key constraint
SQL Code:
CREATE TABLE IF NOT EXISTS `biquin`.`Endereco` ( `idEndereco` INT NOT NULL AUTO_INCREMENT, `numero` VARCHAR(10) NOT NULL DEFAULT 'S/N', `complemento` VARCHAR(45) NULL DEFAULT 'null', `Logradouro_idLogradouro` INT NOT NULL, `Email_idEmail` INT NOT NULL, `Site_idSite` INT NOT NULL, PRIMARY KEY (`idEndereco`), UNIQUE INDEX `idEndereco_UNIQUE` (`idEndereco` ASC), INDEX `fk_Endereco_Logradouro1_idx` (`Logradouro_idLogradouro` ASC), INDEX `fk_Endereco_Email1_idx` (`Email_idEmail` ASC), INDEX `fk_Endereco_Site1_idx` (`Site_idSite` ASC), CONSTRAINT `fk_Endereco_Logradouro1` FOREIGN KEY (`Logradouro_idLogradouro`) REFERENCES `biquin`.`Logradouro` (`idLogradouro`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_Endereco_Email1` FOREIGN KEY (`Email_idEmail`) REFERENCES `biquin`.`Email` (`idEmail`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_Endereco_Site1` FOREIGN KEY (`Site_idSite`) REFERENCES `biquin`.`Site` (`idSite`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB
SQL script execution finished: statements: 20 succeeded, 1 failed
Fetching back view definitions in final form.
Nothing to fetch
Quem puder dar uma força ae, agradeço muito.
valeu