I’m new with SQL. I’ve done my diagram with MySQL Workbench and i have exported it on SQL.
My goal is to move to localhost to create the database and then to load my csv files.

I’m encountering this error for the 5 last remaning tables that i need to do and i don’t know why. I tried ChatGPT and it doesn’t help me. I checked everything so i have missed something (obviously) can somebody help me? please thanks you.

CREATE TABLE IF NOT EXISTS `mydb`.`SOURCE_IMPRIMEE_has_COLLECTIVITE` (
  `SOURCE_IMPRIMEE_idSource_IMPRIMEE` INT NOT NULL,
  `COLLECTIVITE_idCollectivité` INT NOT NULL,
  PRIMARY KEY (`SOURCE_IMPRIMEE_idSource_IMPRIMEE`, `COLLECTIVITE_idCollectivité`),
  INDEX `fk_SOURCE_IMPRIMEE_has_COLLECTIVITE_COLLECTIVITE1_idx` (`COLLECTIVITE_idCollectivité` ASC),
  INDEX `fk_SOURCE_IMPRIMEE_has_COLLECTIVITE_SOURCE_IMPRIMEE1_idx` (`SOURCE_IMPRIMEE_idSource_IMPRIMEE` ASC),
  CONSTRAINT `fk_SOURCE_IMPRIMEE_has_COLLECTIVITE_SOURCE_IMPRIMEE1`
    FOREIGN KEY (`SOURCE_IMPRIMEE_idSource_IMPRIMEE`)
    REFERENCES `mydb`.`SOURCE_IMPRIMEE` (`idSource_IMPRIMEE`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_SOURCE_IMPRIMEE_has_COLLECTIVITE_COLLECTIVITE1`
    FOREIGN KEY (`COLLECTIVITE_idCollectivité`)
    REFERENCES `mydb`.`COLLECTIVITE` (`idCollectivité`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
) ENGINE = InnoDB;

CREATE TABLE IF NOT EXISTS `mydb`.`SOURCE_IMPRIMEE` (
  `idSource_IMPRIMEE` INT NOT NULL AUTO_INCREMENT,
  `idDepot` INT NULL,
  `Ville` VARCHAR(45) NULL,
  `Source_Manuscrite` VARCHAR(45) NULL,
  `ID_Collectivite` VARCHAR(45) NULL,
  `Titre_ou_Titre_forge_sous_titre` VARCHAR(45) NOT NULL,
  `Type` VARCHAR(45) NULL,
  `Expression_texte_original_traduction_ed_abregee` VARCHAR(45) NULL,
  `ID_Depot` VARCHAR(45) NULL,
  `ID_Cote` VARCHAR(45) NULL,
  `Description_bibliographique` VARCHAR(45) NULL,
  `Annee_edition` VARCHAR(45) NULL,
  `Description_physique` VARCHAR(45) NULL,
  `Format_reel_pliage` VARCHAR(45) NULL,
  `Format_apparent_cm_x_cm` VARCHAR(45) NULL,
  `Pagination_totale_ou_extrait` VARCHAR(45) NULL,
  `Volumaison` VARCHAR(45) NULL,
  `Lieu_edition` VARCHAR(45) NULL,
  `Editeur` VARCHAR(45) NULL,
  `Imprimeur` VARCHAR(45) NULL,
  `Lien_hypertexte_vers_notice_source` VARCHAR(45) NULL,
  `Transcription_optionnel_nom_pdf` VARCHAR(45) NULL,
  `Effectif_simplifie` VARCHAR(45) NULL,
  `Commentaires` VARCHAR(45) NULL,
  PRIMARY KEY (`idSource_IMPRIMEE`),
  INDEX `fk_SOURCE_IMPRIMEE_DEPOT1_idx` (`idDepot` ASC),
  CONSTRAINT `fk_SOURCE_IMPRIMEE_DEPOT1`
    FOREIGN KEY (`idDepot`)
    REFERENCES `mydb`.`DEPOT` (`idDEPOT`)
    ON DELETE RESTRICT
    ON UPDATE CASCADE
) ENGINE = InnoDB;

CREATE TABLE IF NOT EXISTS `mydb`.`COLLECTIVITE` (
  `idCollectivité` INT NOT NULL AUTO_INCREMENT,
  `Type` INT NULL,
  `Musicale_ON` VARCHAR(45) NULL,
  `Label_Dénomination_période` VARCHAR(45) NULL,
  `IDRef` VARCHAR(45) NULL,
  `Période_activité` VARCHAR(45) NULL,
  `Date_reconnaissance` VARCHAR(45) NULL,
  `Devise_traduc_source` VARCHAR(45) NULL,
  `PDF_attaché_cachet` VARCHAR(45) NULL,
  `Commentaires` VARCHAR(45) NULL,
  PRIMARY KEY (`idCollectivité`)
) ENGINE = InnoDB;

I don’t think i need to put the other 4 since it will most likely be the same issue.
Thanks for reading me and helping, i wish you a great day.

I tried to make my SQL file work with locahost.