· 7 years ago · Feb 26, 2019, 04:34 PM
1CREATE TABLE IF NOT EXISTS `cupcake`.`Invoice` ( `Quantity` INT NOT NULL, `TotalPrice` INT NULL, `Id` INT NOT NULL AUTO_INCREMENT, `Admin` TINYINT NULL, `Username` VARCHAR(45) NULL, PRIMARY KEY (`Id`), INDEX `Admin_idx` (`Admin` ASC) VISIBLE, INDEX `Username_idx` (`Username` ASC) VISIBLE, CONSTRAINT `Admin` FOREIGN KEY (`Admin`) REFERENCES `cupcake`.`Admin` (`Admin`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `Username` FOREIGN KEY (`Username`) REFERENCES `cupcake`.`users` (`Username`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB
2
3Error Code: 1826. Duplicate foreign key constraint name 'Username' 0.000 sec