Error 1826 Duplicate foreign key constraint name

        -- -----------------------------------------------------
        -- Table `RedWingsDatabase`.`Control`
        -- -----------------------------------------------------
        CREATE TABLE IF NOT EXISTS `RedWingsDatabase`.`Control` (
          `id` INT NOT NULL,
          `commander_id` INT NULL,
          `aircraft_id` INT NULL,
          `start_date` DATE NULL,
          `end_date` DATE NULL,
          PRIMARY KEY (`id`),
          INDEX `commander_id_idx` (`commander_id` ASC) VISIBLE,
          INDEX `aircraft_id_idx` (`aircraft_id` ASC) VISIBLE,
          CONSTRAINT `commander_id`
            FOREIGN KEY (`commander_id`)
            REFERENCES `RedWingsDatabase`.`Aircraft commander` (`id`)
            ON DELETE NO ACTION
            ON UPDATE NO ACTION,
          CONSTRAINT `aircraft_id`
            FOREIGN KEY (`aircraft_id`)
            REFERENCES `RedWingsDatabase`.`Aircraft` (`id`)
            ON DELETE NO ACTION
            ON UPDATE NO ACTION)
        ENGINE = InnoDB

CONSTRAINT `aircraft_id`
FOREIGN KEY (`aircraft_id`)
REFERENCES `RedWingsDatabase`.`Aircraft` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)

FOREIGN KEY (`aircraft_id`)
REFERENCES `RedWingsDatabase`.`Aircraft` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)