#1022 - 不能写; 表中的重复键

嗨,我在mysql phpMyAdmin中创建表时出现1022错误.错误发生在最后一个表"usercoment"上:

解决方案编辑:好的,我已经有一个命名的Constraint键IdMovie,所以我重命名,它工作正常.感谢你们.

以下是表格:

CREATE TABLE IF NOT EXISTS `WhichMovie`.`UserComent` (
  `IDComent` INT NOT NULL,
  `IDUser` INT NOT NULL,
  `IDMovie` INT NOT NULL,
  `date` TIMESTAMP NOT NULL,
  PRIMARY KEY (`IDComent`, `IDUser`, `IDMovie`, `date`),
  INDEX `idUser_idx` (`IDUser` ASC),
  INDEX `idMovie_idx` (`IDMovie` ASC),
  CONSTRAINT `IdComent`
    FOREIGN KEY (`IDComent`)
    REFERENCES `WhichMovie`.`Coment` (`idComent`)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT `IiUser`
    FOREIGN KEY (`IDUser`)
    REFERENCES `WhichMovie`.`User` (`idUser`)
    ON DELETE CASCADE
    ON UPDATE CASCADE,
  CONSTRAINT `IdMovie`
    FOREIGN KEY (`IDMovie`)
    REFERENCES `WhichMovie`.`Movie` (`idMovie`)
    ON DELETE CASCADE
    ON UPDATE CASCADE)
ENGINE = InnoDB;

-- -----------------------------------------------------
-- Table `WhichMovie`.`Movie`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `WhichMovie`.`Movie` (
  `idMovie` INT NOT NULL AUTO_INCREMENT,
  `Ttle` VARCHAR(45) NULL,
  `Year` INT NULL,
  `Country` VARCHAR(45) NULL,
  `Poster` BLOB NULL,
  `Rating` DECIMAL NULL,
  PRIMARY KEY (`idMovie`))
ENGINE = InnoDB;

-- -----------------------------------------------------
-- Table `WhichMovie`.`User`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `WhichMovie`.`User` (
  `idUser` INT NOT NULL AUTO_INCREMENT,
  `Username` VARCHAR(45) NOT NULL,
  `Email` VARCHAR(45) NOT NULL,
  `Country` VARCHAR(45) NULL,
  `Pass` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`idUser`, `Username`, `Email`),
  UNIQUE INDEX `idUser_UNIQUE` (`idUser` ASC),
  UNIQUE INDEX `Email_UNIQUE` (`Email` ASC),
  UNIQUE INDEX `Username_UNIQUE` (`Username` ASC))
ENGINE = InnoDB;

-- -----------------------------------------------------
-- Table `WhichMovie`.`Coment`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `WhichMovie`.`Coment` (
  `idComent` INT NOT NULL AUTO_INCREMENT,
  `NameComent` VARCHAR(45) NULL,
  PRIMARY KEY (`idComent`),
  UNIQUE INDEX `idComent_UNIQUE` (`idComent` ASC))
ENGINE = InnoDB;

谁能看到它？