 ALTER TABLE partenaires_naturalistes.bernard_frin ADD CONSTRAINT enforce_srid_the_geom_2154 CHECK (public.st_srid(the_geom_2154) = 2154);
 ALTER TABLE partenaires_naturalistes.bernard_frin ADD CONSTRAINT enforce_srid_the_geom_3857 CHECK (public.st_srid(the_geom_3857) = 3857);
 ALTER TABLE partenaires_naturalistes.bernard_frin ADD CONSTRAINT enforce_srid_the_geom_point CHECK (public.st_srid(the_geom_point) = 3857);
-ALTER TABLE partenaires_naturalistes.bernard_frin ADD CONSTRAINT frin_cle_check CHECK (cle < 5);
+ALTER TABLE partenaires_naturalistes.bernard_frin ADD CONSTRAINT bernard_frin_cle_check CHECK (cle < 5);
 
 ALTER TABLE partenaires_naturalistes.christophe_perrier ADD CONSTRAINT fk_christophe_perrier_bib_organismes FOREIGN KEY (id_organisme)
     REFERENCES utilisateurs.bib_organismes (id_organisme) MATCH SIMPLE ON UPDATE CASCADE ON DELETE NO ACTION;

ALTER TABLE v1_imports.importedobs ADD CONSTRAINT importedobs_id_protocole_fkey FOREIGN KEY (id_protocole)
    REFERENCES hist_archives.bib_protocoles (codeprotocole) MATCH SIMPLE ON UPDATE CASCADE ON DELETE NO ACTION;
ALTER TABLE v1_imports.importedobs ADD CONSTRAINT importedobs_id_source_fkey FOREIGN KEY (id_source)
      REFERENCES gn_synthese.t_sources (id_source) MATCH SIMPLE ON UPDATE CASCADE ON DELETE NO ACTION;
ALTER TABLE v1_imports.importedobs ADD CONSTRAINT enforce_dims_the_geom_2154 CHECK (public.st_ndims(the_geom_2154) = 2);
ALTER TABLE v1_imports.importedobs ADD CONSTRAINT enforce_dims_the_geom_3857 CHECK (public.st_ndims(the_geom_3857) = 2);
ALTER TABLE v1_imports.importedobs ADD CONSTRAINT enforce_dims_the_geom_point CHECK (public.st_ndims(the_geom_point) = 2);

    REFERENCES gn_synthese.t_sources (id_source) MATCH SIMPLE ON UPDATE CASCADE ON DELETE NO ACTION;
ALTER TABLE partenaires_experts.abc ADD CONSTRAINT fk_abc_bib_organismes FOREIGN KEY (id_organisme)
    REFERENCES utilisateurs.bib_organismes (id_organisme) MATCH SIMPLE ON UPDATE CASCADE ON DELETE NO ACTION;
ALTER TABLE partenaires_experts.abc ADD CONSTRAINT abc_id_critere_synthese_fkey FOREIGN KEY (id_critere_synthese)
    REFERENCES hist_archives.bib_criteres_synthese_gn1 (id_critere_synthese) MATCH SIMPLE ON UPDATE CASCADE ON DELETE NO ACTION;
ALTER TABLE partenaires_experts.abc ADD CONSTRAINT enforce_dims_the_geom_2154 CHECK (public.st_ndims(the_geom_2154) = 2);
ALTER TABLE partenaires_experts.abc ADD CONSTRAINT enforce_dims_the_geom_3857 CHECK (public.st_ndims(the_geom_3857) = 2);
ALTER TABLE partenaires_experts.abc ADD CONSTRAINT enforce_dims_the_geom_point CHECK (public.st_ndims(the_geom_point) = 2);
