   effectif_placettes_fertiles,
   total_steriles,
   total_fertiles
- FROM v1_compat.t_apresence;
+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;

-- ALTER TABLE v1_florepatri.t_apresence ADD COLUMN diffusable boolean;
-- ALTER TABLE v1_florepatri.t_apresence ALTER COLUMN diffusable SET DEFAULT true;

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 (
  indexzp,
  id_secteur,
  id_protocole,
  id_lot,
  id_organisme,
  dateobs,
  date_insert,
  date_update,
  validation,
  topo_valid,
  erreur_signalee,
  supprime,
  cd_nom,
  saisie_initiale,
  insee,
  taxon_saisi,
  the_geom_local,
  geom_point_3857,
  geom_mixte_3857,
  srid_dessin,
  the_geom_3857,
  id_rezo_ecrins
) 
SELECT 
  indexzp,
  id_secteur,
  id_protocole,
  id_lot,
  id_organisme,
  dateobs,
  date_insert,
  date_update,
  validation,
  topo_valid,
  erreur_signalee,
  supprime,
  cd_nom,
  saisie_initiale,
  insee,
  taxon_saisi,
  the_geom_local,
  geom_point_3857,
  geom_mixte_3857,
  srid_dessin,
  the_geom_3857,
  id_rezo_ecrins 
FROM v1_compat.t_zprospection;

INSERT INTO v1_florepatri.t_apresence (
  indexap,
  codepheno,
  indexzp,
  altitude_saisie,
  surfaceap,
  frequenceap,
  date_insert,
  date_update,
  topo_valid,
  supprime,
  erreur_signalee,
  diffusable,
  altitude_sig,
  altitude_retenue,
  insee,
  id_frequence_methodo_new ,
  nb_transects_frequence,
  nb_points_frequence,
  nb_contacts_frequence ,
  id_comptage_methodo,
  nb_placettes_comptage,
  surface_placette_comptage,
  remarques,
  the_geom_local,
  the_geom_3857,
  longueur_pas,
  effectif_placettes_steriles,
  effectif_placettes_fertiles,
  total_steriles,
  total_fertiles
)
SELECT 
  indexap,
  codepheno,
