 -- ALTER TABLE v1_florepatri.t_apresence ADD COLUMN diffusable boolean;
 -- ALTER TABLE v1_florepatri.t_apresence ALTER COLUMN diffusable SET DEFAULT true;
 
+ALTER TABLE v1_florepatri.t_zprospection DISABLE TRIGGER tri_insert_zp;
+ALTER TABLE v1_florepatri.t_zprospection DISABLE TRIGGER tri_update_synthese_zp;
+ALTER TABLE v1_florepatri.t_zprospection DISABLE TRIGGER tri_update_zp;
+ALTER TABLE v1_florepatri.t_apresence DISABLE TRIGGER tri_delete_synthese_ap;
+ALTER TABLE v1_florepatri.t_apresence DISABLE TRIGGER tri_insert_ap;
+ALTER TABLE v1_florepatri.t_apresence DISABLE TRIGGER tri_insert_synthese_ap;
+ALTER TABLE v1_florepatri.t_apresence DISABLE TRIGGER tri_update_ap;
+ALTER TABLE v1_florepatri.t_apresence DISABLE TRIGGER tri_update_synthese_ap;
+ALTER TABLE v1_florepatri.cor_zp_obs DISABLE TRIGGER tri_insert_synthese_cor_zp_obs;
+
 INSERT INTO v1_florepatri.bib_comptages_methodo SELECT * FROM v1_compat.bib_comptages_methodo;
 INSERT INTO v1_florepatri.bib_frequences_methodo_new SELECT * FROM v1_compat.bib_frequences_methodo_new;
 INSERT INTO v1_florepatri.bib_pentes SELECT * FROM v1_compat.bib_pentes;

INSERT INTO v1_florepatri.bib_rezo_ecrins SELECT * FROM v1_compat.bib_rezo_ecrins;
INSERT INTO v1_florepatri.bib_statuts SELECT * FROM v1_compat.bib_statuts;
INSERT INTO v1_florepatri.bib_taxons_fp SELECT * FROM v1_compat.bib_taxons_fp;
INSERT INTO v1_florepatri.t_zprospection SELECT * FROM v1_compat.t_zprospection;
INSERT INTO v1_florepatri.t_apresence
SELECT 
  indexap,
  codepheno,

  effectif_placettes_fertiles,
  total_steriles,
  total_fertiles
FROM v1_compat.t_apresence;
INSERT INTO v1_florepatri.cor_zp_obs SELECT * FROM v1_compat.cor_zp_obs;
INSERT INTO v1_florepatri.cor_taxon_statut SELECT * FROM v1_compat.cor_taxon_statut;
INSERT INTO v1_florepatri.cor_ap_physionomie SELECT * FROM v1_compat.cor_ap_physionomie;
