· 7 years ago · Dec 13, 2018, 07:48 PM
1Executing SQL script in server
2ERROR: Error 1826: Duplicate foreign key constraint name 'idPersona'
3SQL Code:
4 -- -----------------------------------------------------
5 -- Table `GlobalCompany`.`Proveedor`
6 -- -----------------------------------------------------
7 CREATE TABLE IF NOT EXISTS `GlobalCompany`.`Proveedor` (
8 `idProveedor` INT NOT NULL AUTO_INCREMENT,
9 `idPersona` INT NOT NULL,
10 `Compañia` VARCHAR(50) NOT NULL,
11 `Estatus` VARCHAR(1) NOT NULL,
12 PRIMARY KEY (`idProveedor`),
13 INDEX `idPersona_idx` (`idPersona` ASC) VISIBLE,
14 CONSTRAINT `idPersona`
15 FOREIGN KEY (`idPersona`)
16 REFERENCES `GlobalCompany`.`Persona` (`idPersona`)
17 ON DELETE NO ACTION
18 ON UPDATE NO ACTION)
19 ENGINE = InnoDB
20
21SQL script execution finished: statements: 10 succeeded, 1 failed
22
23Fetching back view definitions in final form.
24Nothing to fetch