--
-- PostgreSQL database dump
--

-- Dumped from database version 10.22 (Ubuntu 10.22-0ubuntu0.18.04.1)
-- Dumped by pg_dump version 10.22 (Ubuntu 10.22-0ubuntu0.18.04.1)

-- SET statement_timeout = 0;
-- SET lock_timeout = 0;
-- SET idle_in_transaction_session_timeout = 0;
-- SET client_encoding = 'UTF8';
-- SET standard_conforming_strings = on;
-- SELECT pg_catalog.set_config('search_path', '', false);
-- SET check_function_bodies = false;
-- SET xmloption = content;
-- SET client_min_messages = warning;
-- SET row_security = off;

--
-- Data for Name: autorite_competente; Type: TABLE DATA; Schema: openads; Owner: postgres
--

INSERT INTO autorite_competente (autorite_competente, code, libelle, description, autorite_competente_sitadel) VALUES (1, 'COM', 'Commune', 'C''est l''autorité compétente par défaut sur un dossier d''instruction', 1);
INSERT INTO autorite_competente (autorite_competente, code, libelle, description, autorite_competente_sitadel) VALUES (2, 'ETAT', 'État', '', 2);
INSERT INTO autorite_competente (autorite_competente, code, libelle, description, autorite_competente_sitadel) VALUES (3, 'ETATMAIRE', 'Commune pour état', '', 2);


--
-- Data for Name: cerfa; Type: TABLE DATA; Schema: openads; Owner: postgres
--

INSERT INTO cerfa (cerfa, libelle, code, om_validite_debut, om_validite_fin, am_lotiss, am_autre_div, am_camping, am_caravane, am_carav_duree, am_statio, am_statio_cont, am_affou_exhau, am_affou_exhau_sup, am_affou_prof, am_exhau_haut, am_coupe_abat, am_prot_plu, am_prot_muni, am_mobil_voyage, am_aire_voyage, am_rememb_afu, am_parc_resid_loi, am_sport_moto, am_sport_attrac, am_sport_golf, am_mob_art, am_modif_voie_esp, am_plant_voie_esp, am_chem_ouv_esp, am_agri_peche, am_crea_voie, am_modif_voie_exist, am_crea_esp_sauv, am_crea_esp_class, am_projet_desc, am_terr_surf, am_tranche_desc, am_lot_max_nb, am_lot_max_shon, am_lot_cstr_cos, am_lot_cstr_plan, am_lot_cstr_vente, am_lot_fin_diff, am_lot_consign, am_lot_gar_achev, am_lot_vente_ant, am_empl_nb, am_tente_nb, am_carav_nb, am_mobil_nb, am_pers_nb, am_empl_hll_nb, am_hll_shon, am_periode_exploit, am_exist_agrand, am_exist_date, am_exist_num, am_exist_nb_avant, am_exist_nb_apres, am_coupe_bois, am_coupe_parc, am_coupe_align, am_coupe_ess, am_coupe_age, am_coupe_dens, am_coupe_qual, am_coupe_trait, am_coupe_autr, co_archi_recours, co_cstr_nouv, co_cstr_exist, co_cloture, co_elec_tension, co_div_terr, co_projet_desc, co_anx_pisc, co_anx_gara, co_anx_veran, co_anx_abri, co_anx_autr, co_anx_autr_desc, co_tot_log_nb, co_tot_ind_nb, co_tot_coll_nb, co_mais_piece_nb, co_mais_niv_nb, co_fin_lls_nb, co_fin_aa_nb, co_fin_ptz_nb, co_fin_autr_nb, co_fin_autr_desc, co_mais_contrat_ind, co_uti_pers, co_uti_vente, co_uti_loc, co_uti_princ, co_uti_secon, co_resid_agees, co_resid_etud, co_resid_tourism, co_resid_hot_soc, co_resid_soc, co_resid_hand, co_resid_autr, co_resid_autr_desc, co_foyer_chamb_nb, co_log_1p_nb, co_log_2p_nb, co_log_3p_nb, co_log_4p_nb, co_log_5p_nb, co_log_6p_nb, co_bat_niv_nb, co_trx_exten, co_trx_surelev, co_trx_nivsup, co_demont_periode, co_sp_transport, co_sp_enseign, co_sp_act_soc, co_sp_ouvr_spe, co_sp_sante, co_sp_culture, co_statio_avt_nb, co_statio_apr_nb, co_statio_adr, co_statio_place_nb, co_statio_tot_surf, co_statio_tot_shob, co_statio_comm_cin_surf, tab_surface, dm_constr_dates, dm_total, dm_partiel, dm_projet_desc, dm_tot_log_nb, tax_surf_tot, tax_surf, tax_surf_suppr_mod, tab_tax_su_princ, tab_tax_su_heber, tab_tax_su_secon, tab_tax_su_tot, tax_ext_pret, tax_ext_desc, tax_surf_tax_exist_cons, tax_log_exist_nb, tax_trx_presc_ppr, tax_monu_hist, tax_comm_nb, tab_tax_su_non_habit_surf, tab_tax_am, vsd_surf_planch_smd, vsd_unit_fonc_sup, vsd_unit_fonc_constr_sup, vsd_val_terr, vsd_const_sxist_non_dem_surf, vsd_rescr_fisc, pld_val_terr, pld_const_exist_dem, pld_const_exist_dem_surf, code_cnil, terr_juri_titul, terr_juri_lot, terr_juri_zac, terr_juri_afu, terr_juri_pup, terr_juri_oin, terr_juri_desc, terr_div_surf_etab, terr_div_surf_av_div, doc_date, doc_tot_trav, doc_tranche_trav, doc_tranche_trav_desc, doc_surf, doc_nb_log, doc_nb_log_indiv, doc_nb_log_coll, doc_nb_log_lls, doc_nb_log_aa, doc_nb_log_ptz, doc_nb_log_autre, daact_date, daact_date_chgmt_dest, daact_tot_trav, daact_tranche_trav, daact_tranche_trav_desc, daact_surf, daact_nb_log, daact_nb_log_indiv, daact_nb_log_coll, daact_nb_log_lls, daact_nb_log_aa, daact_nb_log_ptz, daact_nb_log_autre, am_div_mun, co_perf_energ, architecte, co_statio_avt_shob, co_statio_apr_shob, co_statio_avt_surf, co_statio_apr_surf, co_trx_amgt, co_modif_aspect, co_modif_struct, co_ouvr_elec, co_ouvr_infra, co_trx_imm, co_cstr_shob, am_voyage_deb, am_voyage_fin, am_modif_amgt, am_lot_max_shob, mod_desc, tr_total, tr_partiel, tr_desc, avap_co_elt_pro, avap_nouv_haut_surf, avap_co_clot, avap_aut_coup_aba_arb, avap_ouv_infra, avap_aut_inst_mob, avap_aut_plant, avap_aut_auv_elec, tax_dest_loc_tr, ope_proj_desc, tax_surf_tot_cstr, tax_surf_loc_stat, tax_log_ap_trvx_nb, tax_am_statio_ext_cr, tax_sup_bass_pisc_cr, tax_empl_ten_carav_mobil_nb_cr, tax_empl_hll_nb_cr, tax_eol_haut_nb_cr, tax_pann_volt_sup_cr, tax_surf_loc_arch, tax_surf_pisc_arch, tax_am_statio_ext_arch, tab_tax_su_parc_statio_expl_comm, tax_empl_ten_carav_mobil_nb_arch, tax_empl_hll_nb_arch, tax_eol_haut_nb_arch, ope_proj_div_co, ope_proj_div_contr, tax_desc, erp_cstr_neuve, erp_trvx_acc, erp_extension, erp_rehab, erp_trvx_am, erp_vol_nouv_exist, tab_erp_eff, erp_class_cat, erp_class_type, tax_surf_abr_jard_pig_colom, tax_su_non_habit_abr_jard_pig_colom, dia_imm_non_bati, dia_imm_bati_terr_propr, dia_imm_bati_terr_autr, dia_imm_bati_terr_autr_desc, dia_bat_copro, dia_bat_copro_desc, dia_lot_numero, dia_lot_bat, dia_lot_etage, dia_lot_quote_part, dia_us_hab, dia_us_pro, dia_us_mixte, dia_us_comm, dia_us_agr, dia_us_autre, dia_us_autre_prec, dia_occ_prop, dia_occ_loc, dia_occ_sans_occ, dia_occ_autre, dia_occ_autre_prec, dia_mod_cess_prix_vente, dia_mod_cess_prix_vente_mob, dia_mod_cess_prix_vente_cheptel, dia_mod_cess_prix_vente_recol, dia_mod_cess_prix_vente_autre, dia_mod_cess_commi, dia_mod_cess_commi_ttc, dia_mod_cess_commi_ht, dia_acquereur_nom_prenom, dia_acquereur_adr_num_voie, dia_acquereur_adr_ext, dia_acquereur_adr_type_voie, dia_acquereur_adr_nom_voie, dia_acquereur_adr_lieu_dit_bp, dia_acquereur_adr_cp, dia_acquereur_adr_localite, dia_observation, tab_surface2, dia_occ_sol_su_terre, dia_occ_sol_su_pres, dia_occ_sol_su_verger, dia_occ_sol_su_vigne, dia_occ_sol_su_bois, dia_occ_sol_su_lande, dia_occ_sol_su_carriere, dia_occ_sol_su_eau_cadastree, dia_occ_sol_su_jardin, dia_occ_sol_su_terr_batir, dia_occ_sol_su_terr_agr, dia_occ_sol_su_sol, dia_bati_vend_tot, dia_bati_vend_tot_txt, dia_su_co_sol, dia_su_util_hab, dia_nb_niv, dia_nb_appart, dia_nb_autre_loc, dia_vente_lot_volume, dia_vente_lot_volume_txt, dia_lot_nat_su, dia_lot_bat_achv_plus_10, dia_lot_bat_achv_moins_10, dia_lot_regl_copro_publ_hypo_plus_10, dia_lot_regl_copro_publ_hypo_moins_10, dia_indivi_quote_part, dia_design_societe, dia_design_droit, dia_droit_soc_nat, dia_droit_soc_nb, dia_droit_soc_num_part, dia_droit_reel_perso_grevant_bien_oui, dia_droit_reel_perso_grevant_bien_non, dia_droit_reel_perso_nat, dia_droit_reel_perso_viag, dia_mod_cess_adr, dia_mod_cess_sign_act_auth, dia_mod_cess_terme, dia_mod_cess_terme_prec, dia_mod_cess_bene_acquereur, dia_mod_cess_bene_vendeur, dia_mod_cess_paie_nat, dia_mod_cess_design_contr_alien, dia_mod_cess_eval_contr, dia_mod_cess_rente_viag, dia_mod_cess_mnt_an, dia_mod_cess_mnt_compt, dia_mod_cess_bene_rente, dia_mod_cess_droit_usa_hab, dia_mod_cess_droit_usa_hab_prec, dia_mod_cess_eval_usa_usufruit, dia_mod_cess_vente_nue_prop, dia_mod_cess_vente_nue_prop_prec, dia_mod_cess_echange, dia_mod_cess_design_bien_recus_ech, dia_mod_cess_mnt_soulte, dia_mod_cess_prop_contre_echan, dia_mod_cess_apport_societe, dia_mod_cess_bene, dia_mod_cess_esti_bien, dia_mod_cess_cess_terr_loc_co, dia_mod_cess_esti_terr, dia_mod_cess_esti_loc, dia_mod_cess_esti_imm_loca, dia_mod_cess_adju_vol, dia_mod_cess_adju_obl, dia_mod_cess_adju_fin_indivi, dia_mod_cess_adju_date_lieu, dia_mod_cess_mnt_mise_prix, dia_prop_titu_prix_indique, dia_prop_recherche_acqu_prix_indique, dia_acquereur_prof, dia_indic_compl_ope, dia_vente_adju, am_terr_res_demon, am_air_terr_res_mob, ctx_objet_recours, ctx_moyen_souleve, ctx_moyen_retenu_juge, ctx_reference_sagace, ctx_nature_travaux_infra_om_html, ctx_synthese_nti, ctx_article_non_resp_om_html, ctx_synthese_anr, ctx_reference_parquet, ctx_element_taxation, ctx_infraction, ctx_regularisable, ctx_reference_courrier, ctx_date_audience, ctx_date_ajournement, exo_facul_1, exo_facul_2, exo_facul_3, exo_facul_4, exo_facul_5, exo_facul_6, exo_facul_7, exo_facul_8, exo_facul_9, exo_ta_1, exo_ta_2, exo_ta_3, exo_ta_4, exo_ta_5, exo_ta_6, exo_ta_7, exo_ta_8, exo_ta_9, exo_rap_1, exo_rap_2, exo_rap_3, exo_rap_4, exo_rap_5, exo_rap_6, exo_rap_7, exo_rap_8, mtn_exo_ta_part_commu, mtn_exo_ta_part_depart, mtn_exo_ta_part_reg, mtn_exo_rap, dpc_type, dpc_desc_actv_ex, dpc_desc_ca, dpc_desc_aut_prec, dpc_desig_comm_arti, dpc_desig_loc_hab, dpc_desig_loc_ann, dpc_desig_loc_ann_prec, dpc_bail_comm_date, dpc_bail_comm_loyer, dpc_actv_acqu, dpc_nb_sala_di, dpc_nb_sala_dd, dpc_nb_sala_tc, dpc_nb_sala_tp, dpc_moda_cess_vente_am, dpc_moda_cess_adj, dpc_moda_cess_prix, dpc_moda_cess_adj_date, dpc_moda_cess_adj_prec, dpc_moda_cess_paie_comp, dpc_moda_cess_paie_terme, dpc_moda_cess_paie_terme_prec, dpc_moda_cess_paie_nat, dpc_moda_cess_paie_nat_desig_alien, dpc_moda_cess_paie_nat_desig_alien_prec, dpc_moda_cess_paie_nat_eval, dpc_moda_cess_paie_nat_eval_prec, dpc_moda_cess_paie_aut, dpc_moda_cess_paie_aut_prec, dpc_ss_signe_demande_acqu, dpc_ss_signe_recher_trouv_acqu, dpc_notif_adr_prop, dpc_notif_adr_manda, dpc_obs, co_peri_site_patri_remar, co_abo_monu_hist, co_inst_ouvr_trav_act_code_envir, co_trav_auto_env, co_derog_esp_prot, ctx_reference_dsj, co_piscine, co_fin_lls, co_fin_aa, co_fin_ptz, co_fin_autr, dia_ss_date, dia_ss_lieu, enga_decla_lieu, enga_decla_date, co_archi_attest_honneur, co_bat_niv_dessous_nb, co_install_classe, co_derog_innov, co_avis_abf, tax_surf_tot_demo, tax_surf_tax_demo, tax_terrassement_arch, tax_adresse_future_numero, tax_adresse_future_voie, tax_adresse_future_lieudit, tax_adresse_future_localite, tax_adresse_future_cp, tax_adresse_future_bp, tax_adresse_future_cedex, tax_adresse_future_pays, tax_adresse_future_division, co_bat_projete, co_bat_existant, co_bat_nature, terr_juri_titul_date, co_autre_desc, co_trx_autre, co_autre, erp_modif_facades, erp_trvx_adap, erp_trvx_adap_numero, erp_trvx_adap_valid, erp_prod_dangereux, co_trav_supp_dessus, co_trav_supp_dessous, tax_su_habit_abr_jard_pig_colom, enga_decla_donnees_nomi_comm) VALUES (7, 'cerfa de test n°6', '123456', '2013-01-01', '2017-05-01', true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 13409, true, true, true, true, true, true, true, true, 1340903, 1340903, 1340903, 1340903, true, true, true, true, true, true, true, 1340903, 13409, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 1340903, true, true, true, true, true, true, true, true, true, true, true, true, 1382403, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 1340905, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, false, false, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false);
INSERT INTO cerfa (cerfa, libelle, code, om_validite_debut, om_validite_fin, am_lotiss, am_autre_div, am_camping, am_caravane, am_carav_duree, am_statio, am_statio_cont, am_affou_exhau, am_affou_exhau_sup, am_affou_prof, am_exhau_haut, am_coupe_abat, am_prot_plu, am_prot_muni, am_mobil_voyage, am_aire_voyage, am_rememb_afu, am_parc_resid_loi, am_sport_moto, am_sport_attrac, am_sport_golf, am_mob_art, am_modif_voie_esp, am_plant_voie_esp, am_chem_ouv_esp, am_agri_peche, am_crea_voie, am_modif_voie_exist, am_crea_esp_sauv, am_crea_esp_class, am_projet_desc, am_terr_surf, am_tranche_desc, am_lot_max_nb, am_lot_max_shon, am_lot_cstr_cos, am_lot_cstr_plan, am_lot_cstr_vente, am_lot_fin_diff, am_lot_consign, am_lot_gar_achev, am_lot_vente_ant, am_empl_nb, am_tente_nb, am_carav_nb, am_mobil_nb, am_pers_nb, am_empl_hll_nb, am_hll_shon, am_periode_exploit, am_exist_agrand, am_exist_date, am_exist_num, am_exist_nb_avant, am_exist_nb_apres, am_coupe_bois, am_coupe_parc, am_coupe_align, am_coupe_ess, am_coupe_age, am_coupe_dens, am_coupe_qual, am_coupe_trait, am_coupe_autr, co_archi_recours, co_cstr_nouv, co_cstr_exist, co_cloture, co_elec_tension, co_div_terr, co_projet_desc, co_anx_pisc, co_anx_gara, co_anx_veran, co_anx_abri, co_anx_autr, co_anx_autr_desc, co_tot_log_nb, co_tot_ind_nb, co_tot_coll_nb, co_mais_piece_nb, co_mais_niv_nb, co_fin_lls_nb, co_fin_aa_nb, co_fin_ptz_nb, co_fin_autr_nb, co_fin_autr_desc, co_mais_contrat_ind, co_uti_pers, co_uti_vente, co_uti_loc, co_uti_princ, co_uti_secon, co_resid_agees, co_resid_etud, co_resid_tourism, co_resid_hot_soc, co_resid_soc, co_resid_hand, co_resid_autr, co_resid_autr_desc, co_foyer_chamb_nb, co_log_1p_nb, co_log_2p_nb, co_log_3p_nb, co_log_4p_nb, co_log_5p_nb, co_log_6p_nb, co_bat_niv_nb, co_trx_exten, co_trx_surelev, co_trx_nivsup, co_demont_periode, co_sp_transport, co_sp_enseign, co_sp_act_soc, co_sp_ouvr_spe, co_sp_sante, co_sp_culture, co_statio_avt_nb, co_statio_apr_nb, co_statio_adr, co_statio_place_nb, co_statio_tot_surf, co_statio_tot_shob, co_statio_comm_cin_surf, tab_surface, dm_constr_dates, dm_total, dm_partiel, dm_projet_desc, dm_tot_log_nb, tax_surf_tot, tax_surf, tax_surf_suppr_mod, tab_tax_su_princ, tab_tax_su_heber, tab_tax_su_secon, tab_tax_su_tot, tax_ext_pret, tax_ext_desc, tax_surf_tax_exist_cons, tax_log_exist_nb, tax_trx_presc_ppr, tax_monu_hist, tax_comm_nb, tab_tax_su_non_habit_surf, tab_tax_am, vsd_surf_planch_smd, vsd_unit_fonc_sup, vsd_unit_fonc_constr_sup, vsd_val_terr, vsd_const_sxist_non_dem_surf, vsd_rescr_fisc, pld_val_terr, pld_const_exist_dem, pld_const_exist_dem_surf, code_cnil, terr_juri_titul, terr_juri_lot, terr_juri_zac, terr_juri_afu, terr_juri_pup, terr_juri_oin, terr_juri_desc, terr_div_surf_etab, terr_div_surf_av_div, doc_date, doc_tot_trav, doc_tranche_trav, doc_tranche_trav_desc, doc_surf, doc_nb_log, doc_nb_log_indiv, doc_nb_log_coll, doc_nb_log_lls, doc_nb_log_aa, doc_nb_log_ptz, doc_nb_log_autre, daact_date, daact_date_chgmt_dest, daact_tot_trav, daact_tranche_trav, daact_tranche_trav_desc, daact_surf, daact_nb_log, daact_nb_log_indiv, daact_nb_log_coll, daact_nb_log_lls, daact_nb_log_aa, daact_nb_log_ptz, daact_nb_log_autre, am_div_mun, co_perf_energ, architecte, co_statio_avt_shob, co_statio_apr_shob, co_statio_avt_surf, co_statio_apr_surf, co_trx_amgt, co_modif_aspect, co_modif_struct, co_ouvr_elec, co_ouvr_infra, co_trx_imm, co_cstr_shob, am_voyage_deb, am_voyage_fin, am_modif_amgt, am_lot_max_shob, mod_desc, tr_total, tr_partiel, tr_desc, avap_co_elt_pro, avap_nouv_haut_surf, avap_co_clot, avap_aut_coup_aba_arb, avap_ouv_infra, avap_aut_inst_mob, avap_aut_plant, avap_aut_auv_elec, tax_dest_loc_tr, ope_proj_desc, tax_surf_tot_cstr, tax_surf_loc_stat, tax_log_ap_trvx_nb, tax_am_statio_ext_cr, tax_sup_bass_pisc_cr, tax_empl_ten_carav_mobil_nb_cr, tax_empl_hll_nb_cr, tax_eol_haut_nb_cr, tax_pann_volt_sup_cr, tax_surf_loc_arch, tax_surf_pisc_arch, tax_am_statio_ext_arch, tab_tax_su_parc_statio_expl_comm, tax_empl_ten_carav_mobil_nb_arch, tax_empl_hll_nb_arch, tax_eol_haut_nb_arch, ope_proj_div_co, ope_proj_div_contr, tax_desc, erp_cstr_neuve, erp_trvx_acc, erp_extension, erp_rehab, erp_trvx_am, erp_vol_nouv_exist, tab_erp_eff, erp_class_cat, erp_class_type, tax_surf_abr_jard_pig_colom, tax_su_non_habit_abr_jard_pig_colom, dia_imm_non_bati, dia_imm_bati_terr_propr, dia_imm_bati_terr_autr, dia_imm_bati_terr_autr_desc, dia_bat_copro, dia_bat_copro_desc, dia_lot_numero, dia_lot_bat, dia_lot_etage, dia_lot_quote_part, dia_us_hab, dia_us_pro, dia_us_mixte, dia_us_comm, dia_us_agr, dia_us_autre, dia_us_autre_prec, dia_occ_prop, dia_occ_loc, dia_occ_sans_occ, dia_occ_autre, dia_occ_autre_prec, dia_mod_cess_prix_vente, dia_mod_cess_prix_vente_mob, dia_mod_cess_prix_vente_cheptel, dia_mod_cess_prix_vente_recol, dia_mod_cess_prix_vente_autre, dia_mod_cess_commi, dia_mod_cess_commi_ttc, dia_mod_cess_commi_ht, dia_acquereur_nom_prenom, dia_acquereur_adr_num_voie, dia_acquereur_adr_ext, dia_acquereur_adr_type_voie, dia_acquereur_adr_nom_voie, dia_acquereur_adr_lieu_dit_bp, dia_acquereur_adr_cp, dia_acquereur_adr_localite, dia_observation, tab_surface2, dia_occ_sol_su_terre, dia_occ_sol_su_pres, dia_occ_sol_su_verger, dia_occ_sol_su_vigne, dia_occ_sol_su_bois, dia_occ_sol_su_lande, dia_occ_sol_su_carriere, dia_occ_sol_su_eau_cadastree, dia_occ_sol_su_jardin, dia_occ_sol_su_terr_batir, dia_occ_sol_su_terr_agr, dia_occ_sol_su_sol, dia_bati_vend_tot, dia_bati_vend_tot_txt, dia_su_co_sol, dia_su_util_hab, dia_nb_niv, dia_nb_appart, dia_nb_autre_loc, dia_vente_lot_volume, dia_vente_lot_volume_txt, dia_lot_nat_su, dia_lot_bat_achv_plus_10, dia_lot_bat_achv_moins_10, dia_lot_regl_copro_publ_hypo_plus_10, dia_lot_regl_copro_publ_hypo_moins_10, dia_indivi_quote_part, dia_design_societe, dia_design_droit, dia_droit_soc_nat, dia_droit_soc_nb, dia_droit_soc_num_part, dia_droit_reel_perso_grevant_bien_oui, dia_droit_reel_perso_grevant_bien_non, dia_droit_reel_perso_nat, dia_droit_reel_perso_viag, dia_mod_cess_adr, dia_mod_cess_sign_act_auth, dia_mod_cess_terme, dia_mod_cess_terme_prec, dia_mod_cess_bene_acquereur, dia_mod_cess_bene_vendeur, dia_mod_cess_paie_nat, dia_mod_cess_design_contr_alien, dia_mod_cess_eval_contr, dia_mod_cess_rente_viag, dia_mod_cess_mnt_an, dia_mod_cess_mnt_compt, dia_mod_cess_bene_rente, dia_mod_cess_droit_usa_hab, dia_mod_cess_droit_usa_hab_prec, dia_mod_cess_eval_usa_usufruit, dia_mod_cess_vente_nue_prop, dia_mod_cess_vente_nue_prop_prec, dia_mod_cess_echange, dia_mod_cess_design_bien_recus_ech, dia_mod_cess_mnt_soulte, dia_mod_cess_prop_contre_echan, dia_mod_cess_apport_societe, dia_mod_cess_bene, dia_mod_cess_esti_bien, dia_mod_cess_cess_terr_loc_co, dia_mod_cess_esti_terr, dia_mod_cess_esti_loc, dia_mod_cess_esti_imm_loca, dia_mod_cess_adju_vol, dia_mod_cess_adju_obl, dia_mod_cess_adju_fin_indivi, dia_mod_cess_adju_date_lieu, dia_mod_cess_mnt_mise_prix, dia_prop_titu_prix_indique, dia_prop_recherche_acqu_prix_indique, dia_acquereur_prof, dia_indic_compl_ope, dia_vente_adju, am_terr_res_demon, am_air_terr_res_mob, ctx_objet_recours, ctx_moyen_souleve, ctx_moyen_retenu_juge, ctx_reference_sagace, ctx_nature_travaux_infra_om_html, ctx_synthese_nti, ctx_article_non_resp_om_html, ctx_synthese_anr, ctx_reference_parquet, ctx_element_taxation, ctx_infraction, ctx_regularisable, ctx_reference_courrier, ctx_date_audience, ctx_date_ajournement, exo_facul_1, exo_facul_2, exo_facul_3, exo_facul_4, exo_facul_5, exo_facul_6, exo_facul_7, exo_facul_8, exo_facul_9, exo_ta_1, exo_ta_2, exo_ta_3, exo_ta_4, exo_ta_5, exo_ta_6, exo_ta_7, exo_ta_8, exo_ta_9, exo_rap_1, exo_rap_2, exo_rap_3, exo_rap_4, exo_rap_5, exo_rap_6, exo_rap_7, exo_rap_8, mtn_exo_ta_part_commu, mtn_exo_ta_part_depart, mtn_exo_ta_part_reg, mtn_exo_rap, dpc_type, dpc_desc_actv_ex, dpc_desc_ca, dpc_desc_aut_prec, dpc_desig_comm_arti, dpc_desig_loc_hab, dpc_desig_loc_ann, dpc_desig_loc_ann_prec, dpc_bail_comm_date, dpc_bail_comm_loyer, dpc_actv_acqu, dpc_nb_sala_di, dpc_nb_sala_dd, dpc_nb_sala_tc, dpc_nb_sala_tp, dpc_moda_cess_vente_am, dpc_moda_cess_adj, dpc_moda_cess_prix, dpc_moda_cess_adj_date, dpc_moda_cess_adj_prec, dpc_moda_cess_paie_comp, dpc_moda_cess_paie_terme, dpc_moda_cess_paie_terme_prec, dpc_moda_cess_paie_nat, dpc_moda_cess_paie_nat_desig_alien, dpc_moda_cess_paie_nat_desig_alien_prec, dpc_moda_cess_paie_nat_eval, dpc_moda_cess_paie_nat_eval_prec, dpc_moda_cess_paie_aut, dpc_moda_cess_paie_aut_prec, dpc_ss_signe_demande_acqu, dpc_ss_signe_recher_trouv_acqu, dpc_notif_adr_prop, dpc_notif_adr_manda, dpc_obs, co_peri_site_patri_remar, co_abo_monu_hist, co_inst_ouvr_trav_act_code_envir, co_trav_auto_env, co_derog_esp_prot, ctx_reference_dsj, co_piscine, co_fin_lls, co_fin_aa, co_fin_ptz, co_fin_autr, dia_ss_date, dia_ss_lieu, enga_decla_lieu, enga_decla_date, co_archi_attest_honneur, co_bat_niv_dessous_nb, co_install_classe, co_derog_innov, co_avis_abf, tax_surf_tot_demo, tax_surf_tax_demo, tax_terrassement_arch, tax_adresse_future_numero, tax_adresse_future_voie, tax_adresse_future_lieudit, tax_adresse_future_localite, tax_adresse_future_cp, tax_adresse_future_bp, tax_adresse_future_cedex, tax_adresse_future_pays, tax_adresse_future_division, co_bat_projete, co_bat_existant, co_bat_nature, terr_juri_titul_date, co_autre_desc, co_trx_autre, co_autre, erp_modif_facades, erp_trvx_adap, erp_trvx_adap_numero, erp_trvx_adap_valid, erp_prod_dangereux, co_trav_supp_dessus, co_trav_supp_dessous, tax_su_habit_abr_jard_pig_colom, enga_decla_donnees_nomi_comm) VALUES (1, 'cerfa de test n°1', '123456', '2013-02-01', '2014-12-31', true, true, true, false, false, true, true, true, true, true, true, false, false, false, false, false, false, true, true, true, true, false, false, false, true, true, true, true, true, true, true, true, true, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, true, true, true, true, true, true, false, false, false, false, false, false, false, 13409, true, true, true, true, true, false, false, false, NULL, NULL, NULL, NULL, false, false, false, false, false, false, false, NULL, NULL, false, false, false, false, false, false, false, false, false, false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, true, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, NULL, false, false, false, false, false, false, false, false, false, false, false, false, NULL, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, NULL, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false);
INSERT INTO cerfa (cerfa, libelle, code, om_validite_debut, om_validite_fin, am_lotiss, am_autre_div, am_camping, am_caravane, am_carav_duree, am_statio, am_statio_cont, am_affou_exhau, am_affou_exhau_sup, am_affou_prof, am_exhau_haut, am_coupe_abat, am_prot_plu, am_prot_muni, am_mobil_voyage, am_aire_voyage, am_rememb_afu, am_parc_resid_loi, am_sport_moto, am_sport_attrac, am_sport_golf, am_mob_art, am_modif_voie_esp, am_plant_voie_esp, am_chem_ouv_esp, am_agri_peche, am_crea_voie, am_modif_voie_exist, am_crea_esp_sauv, am_crea_esp_class, am_projet_desc, am_terr_surf, am_tranche_desc, am_lot_max_nb, am_lot_max_shon, am_lot_cstr_cos, am_lot_cstr_plan, am_lot_cstr_vente, am_lot_fin_diff, am_lot_consign, am_lot_gar_achev, am_lot_vente_ant, am_empl_nb, am_tente_nb, am_carav_nb, am_mobil_nb, am_pers_nb, am_empl_hll_nb, am_hll_shon, am_periode_exploit, am_exist_agrand, am_exist_date, am_exist_num, am_exist_nb_avant, am_exist_nb_apres, am_coupe_bois, am_coupe_parc, am_coupe_align, am_coupe_ess, am_coupe_age, am_coupe_dens, am_coupe_qual, am_coupe_trait, am_coupe_autr, co_archi_recours, co_cstr_nouv, co_cstr_exist, co_cloture, co_elec_tension, co_div_terr, co_projet_desc, co_anx_pisc, co_anx_gara, co_anx_veran, co_anx_abri, co_anx_autr, co_anx_autr_desc, co_tot_log_nb, co_tot_ind_nb, co_tot_coll_nb, co_mais_piece_nb, co_mais_niv_nb, co_fin_lls_nb, co_fin_aa_nb, co_fin_ptz_nb, co_fin_autr_nb, co_fin_autr_desc, co_mais_contrat_ind, co_uti_pers, co_uti_vente, co_uti_loc, co_uti_princ, co_uti_secon, co_resid_agees, co_resid_etud, co_resid_tourism, co_resid_hot_soc, co_resid_soc, co_resid_hand, co_resid_autr, co_resid_autr_desc, co_foyer_chamb_nb, co_log_1p_nb, co_log_2p_nb, co_log_3p_nb, co_log_4p_nb, co_log_5p_nb, co_log_6p_nb, co_bat_niv_nb, co_trx_exten, co_trx_surelev, co_trx_nivsup, co_demont_periode, co_sp_transport, co_sp_enseign, co_sp_act_soc, co_sp_ouvr_spe, co_sp_sante, co_sp_culture, co_statio_avt_nb, co_statio_apr_nb, co_statio_adr, co_statio_place_nb, co_statio_tot_surf, co_statio_tot_shob, co_statio_comm_cin_surf, tab_surface, dm_constr_dates, dm_total, dm_partiel, dm_projet_desc, dm_tot_log_nb, tax_surf_tot, tax_surf, tax_surf_suppr_mod, tab_tax_su_princ, tab_tax_su_heber, tab_tax_su_secon, tab_tax_su_tot, tax_ext_pret, tax_ext_desc, tax_surf_tax_exist_cons, tax_log_exist_nb, tax_trx_presc_ppr, tax_monu_hist, tax_comm_nb, tab_tax_su_non_habit_surf, tab_tax_am, vsd_surf_planch_smd, vsd_unit_fonc_sup, vsd_unit_fonc_constr_sup, vsd_val_terr, vsd_const_sxist_non_dem_surf, vsd_rescr_fisc, pld_val_terr, pld_const_exist_dem, pld_const_exist_dem_surf, code_cnil, terr_juri_titul, terr_juri_lot, terr_juri_zac, terr_juri_afu, terr_juri_pup, terr_juri_oin, terr_juri_desc, terr_div_surf_etab, terr_div_surf_av_div, doc_date, doc_tot_trav, doc_tranche_trav, doc_tranche_trav_desc, doc_surf, doc_nb_log, doc_nb_log_indiv, doc_nb_log_coll, doc_nb_log_lls, doc_nb_log_aa, doc_nb_log_ptz, doc_nb_log_autre, daact_date, daact_date_chgmt_dest, daact_tot_trav, daact_tranche_trav, daact_tranche_trav_desc, daact_surf, daact_nb_log, daact_nb_log_indiv, daact_nb_log_coll, daact_nb_log_lls, daact_nb_log_aa, daact_nb_log_ptz, daact_nb_log_autre, am_div_mun, co_perf_energ, architecte, co_statio_avt_shob, co_statio_apr_shob, co_statio_avt_surf, co_statio_apr_surf, co_trx_amgt, co_modif_aspect, co_modif_struct, co_ouvr_elec, co_ouvr_infra, co_trx_imm, co_cstr_shob, am_voyage_deb, am_voyage_fin, am_modif_amgt, am_lot_max_shob, mod_desc, tr_total, tr_partiel, tr_desc, avap_co_elt_pro, avap_nouv_haut_surf, avap_co_clot, avap_aut_coup_aba_arb, avap_ouv_infra, avap_aut_inst_mob, avap_aut_plant, avap_aut_auv_elec, tax_dest_loc_tr, ope_proj_desc, tax_surf_tot_cstr, tax_surf_loc_stat, tax_log_ap_trvx_nb, tax_am_statio_ext_cr, tax_sup_bass_pisc_cr, tax_empl_ten_carav_mobil_nb_cr, tax_empl_hll_nb_cr, tax_eol_haut_nb_cr, tax_pann_volt_sup_cr, tax_surf_loc_arch, tax_surf_pisc_arch, tax_am_statio_ext_arch, tab_tax_su_parc_statio_expl_comm, tax_empl_ten_carav_mobil_nb_arch, tax_empl_hll_nb_arch, tax_eol_haut_nb_arch, ope_proj_div_co, ope_proj_div_contr, tax_desc, erp_cstr_neuve, erp_trvx_acc, erp_extension, erp_rehab, erp_trvx_am, erp_vol_nouv_exist, tab_erp_eff, erp_class_cat, erp_class_type, tax_surf_abr_jard_pig_colom, tax_su_non_habit_abr_jard_pig_colom, dia_imm_non_bati, dia_imm_bati_terr_propr, dia_imm_bati_terr_autr, dia_imm_bati_terr_autr_desc, dia_bat_copro, dia_bat_copro_desc, dia_lot_numero, dia_lot_bat, dia_lot_etage, dia_lot_quote_part, dia_us_hab, dia_us_pro, dia_us_mixte, dia_us_comm, dia_us_agr, dia_us_autre, dia_us_autre_prec, dia_occ_prop, dia_occ_loc, dia_occ_sans_occ, dia_occ_autre, dia_occ_autre_prec, dia_mod_cess_prix_vente, dia_mod_cess_prix_vente_mob, dia_mod_cess_prix_vente_cheptel, dia_mod_cess_prix_vente_recol, dia_mod_cess_prix_vente_autre, dia_mod_cess_commi, dia_mod_cess_commi_ttc, dia_mod_cess_commi_ht, dia_acquereur_nom_prenom, dia_acquereur_adr_num_voie, dia_acquereur_adr_ext, dia_acquereur_adr_type_voie, dia_acquereur_adr_nom_voie, dia_acquereur_adr_lieu_dit_bp, dia_acquereur_adr_cp, dia_acquereur_adr_localite, dia_observation, tab_surface2, dia_occ_sol_su_terre, dia_occ_sol_su_pres, dia_occ_sol_su_verger, dia_occ_sol_su_vigne, dia_occ_sol_su_bois, dia_occ_sol_su_lande, dia_occ_sol_su_carriere, dia_occ_sol_su_eau_cadastree, dia_occ_sol_su_jardin, dia_occ_sol_su_terr_batir, dia_occ_sol_su_terr_agr, dia_occ_sol_su_sol, dia_bati_vend_tot, dia_bati_vend_tot_txt, dia_su_co_sol, dia_su_util_hab, dia_nb_niv, dia_nb_appart, dia_nb_autre_loc, dia_vente_lot_volume, dia_vente_lot_volume_txt, dia_lot_nat_su, dia_lot_bat_achv_plus_10, dia_lot_bat_achv_moins_10, dia_lot_regl_copro_publ_hypo_plus_10, dia_lot_regl_copro_publ_hypo_moins_10, dia_indivi_quote_part, dia_design_societe, dia_design_droit, dia_droit_soc_nat, dia_droit_soc_nb, dia_droit_soc_num_part, dia_droit_reel_perso_grevant_bien_oui, dia_droit_reel_perso_grevant_bien_non, dia_droit_reel_perso_nat, dia_droit_reel_perso_viag, dia_mod_cess_adr, dia_mod_cess_sign_act_auth, dia_mod_cess_terme, dia_mod_cess_terme_prec, dia_mod_cess_bene_acquereur, dia_mod_cess_bene_vendeur, dia_mod_cess_paie_nat, dia_mod_cess_design_contr_alien, dia_mod_cess_eval_contr, dia_mod_cess_rente_viag, dia_mod_cess_mnt_an, dia_mod_cess_mnt_compt, dia_mod_cess_bene_rente, dia_mod_cess_droit_usa_hab, dia_mod_cess_droit_usa_hab_prec, dia_mod_cess_eval_usa_usufruit, dia_mod_cess_vente_nue_prop, dia_mod_cess_vente_nue_prop_prec, dia_mod_cess_echange, dia_mod_cess_design_bien_recus_ech, dia_mod_cess_mnt_soulte, dia_mod_cess_prop_contre_echan, dia_mod_cess_apport_societe, dia_mod_cess_bene, dia_mod_cess_esti_bien, dia_mod_cess_cess_terr_loc_co, dia_mod_cess_esti_terr, dia_mod_cess_esti_loc, dia_mod_cess_esti_imm_loca, dia_mod_cess_adju_vol, dia_mod_cess_adju_obl, dia_mod_cess_adju_fin_indivi, dia_mod_cess_adju_date_lieu, dia_mod_cess_mnt_mise_prix, dia_prop_titu_prix_indique, dia_prop_recherche_acqu_prix_indique, dia_acquereur_prof, dia_indic_compl_ope, dia_vente_adju, am_terr_res_demon, am_air_terr_res_mob, ctx_objet_recours, ctx_moyen_souleve, ctx_moyen_retenu_juge, ctx_reference_sagace, ctx_nature_travaux_infra_om_html, ctx_synthese_nti, ctx_article_non_resp_om_html, ctx_synthese_anr, ctx_reference_parquet, ctx_element_taxation, ctx_infraction, ctx_regularisable, ctx_reference_courrier, ctx_date_audience, ctx_date_ajournement, exo_facul_1, exo_facul_2, exo_facul_3, exo_facul_4, exo_facul_5, exo_facul_6, exo_facul_7, exo_facul_8, exo_facul_9, exo_ta_1, exo_ta_2, exo_ta_3, exo_ta_4, exo_ta_5, exo_ta_6, exo_ta_7, exo_ta_8, exo_ta_9, exo_rap_1, exo_rap_2, exo_rap_3, exo_rap_4, exo_rap_5, exo_rap_6, exo_rap_7, exo_rap_8, mtn_exo_ta_part_commu, mtn_exo_ta_part_depart, mtn_exo_ta_part_reg, mtn_exo_rap, dpc_type, dpc_desc_actv_ex, dpc_desc_ca, dpc_desc_aut_prec, dpc_desig_comm_arti, dpc_desig_loc_hab, dpc_desig_loc_ann, dpc_desig_loc_ann_prec, dpc_bail_comm_date, dpc_bail_comm_loyer, dpc_actv_acqu, dpc_nb_sala_di, dpc_nb_sala_dd, dpc_nb_sala_tc, dpc_nb_sala_tp, dpc_moda_cess_vente_am, dpc_moda_cess_adj, dpc_moda_cess_prix, dpc_moda_cess_adj_date, dpc_moda_cess_adj_prec, dpc_moda_cess_paie_comp, dpc_moda_cess_paie_terme, dpc_moda_cess_paie_terme_prec, dpc_moda_cess_paie_nat, dpc_moda_cess_paie_nat_desig_alien, dpc_moda_cess_paie_nat_desig_alien_prec, dpc_moda_cess_paie_nat_eval, dpc_moda_cess_paie_nat_eval_prec, dpc_moda_cess_paie_aut, dpc_moda_cess_paie_aut_prec, dpc_ss_signe_demande_acqu, dpc_ss_signe_recher_trouv_acqu, dpc_notif_adr_prop, dpc_notif_adr_manda, dpc_obs, co_peri_site_patri_remar, co_abo_monu_hist, co_inst_ouvr_trav_act_code_envir, co_trav_auto_env, co_derog_esp_prot, ctx_reference_dsj, co_piscine, co_fin_lls, co_fin_aa, co_fin_ptz, co_fin_autr, dia_ss_date, dia_ss_lieu, enga_decla_lieu, enga_decla_date, co_archi_attest_honneur, co_bat_niv_dessous_nb, co_install_classe, co_derog_innov, co_avis_abf, tax_surf_tot_demo, tax_surf_tax_demo, tax_terrassement_arch, tax_adresse_future_numero, tax_adresse_future_voie, tax_adresse_future_lieudit, tax_adresse_future_localite, tax_adresse_future_cp, tax_adresse_future_bp, tax_adresse_future_cedex, tax_adresse_future_pays, tax_adresse_future_division, co_bat_projete, co_bat_existant, co_bat_nature, terr_juri_titul_date, co_autre_desc, co_trx_autre, co_autre, erp_modif_facades, erp_trvx_adap, erp_trvx_adap_numero, erp_trvx_adap_valid, erp_prod_dangereux, co_trav_supp_dessus, co_trav_supp_dessous, tax_su_habit_abr_jard_pig_colom, enga_decla_donnees_nomi_comm) VALUES (3, 'cerfa de test n°2', '123456', '2013-02-01', '2016-02-02', true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 13409, true, true, true, true, true, true, true, true, 1340903, 1340903, 1340903, 1340903, true, true, true, true, true, true, true, 1340903, 13409, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 1340903, true, true, true, true, true, true, true, true, true, true, true, true, 1382403, true, true, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, NULL, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false);
INSERT INTO cerfa (cerfa, libelle, code, om_validite_debut, om_validite_fin, am_lotiss, am_autre_div, am_camping, am_caravane, am_carav_duree, am_statio, am_statio_cont, am_affou_exhau, am_affou_exhau_sup, am_affou_prof, am_exhau_haut, am_coupe_abat, am_prot_plu, am_prot_muni, am_mobil_voyage, am_aire_voyage, am_rememb_afu, am_parc_resid_loi, am_sport_moto, am_sport_attrac, am_sport_golf, am_mob_art, am_modif_voie_esp, am_plant_voie_esp, am_chem_ouv_esp, am_agri_peche, am_crea_voie, am_modif_voie_exist, am_crea_esp_sauv, am_crea_esp_class, am_projet_desc, am_terr_surf, am_tranche_desc, am_lot_max_nb, am_lot_max_shon, am_lot_cstr_cos, am_lot_cstr_plan, am_lot_cstr_vente, am_lot_fin_diff, am_lot_consign, am_lot_gar_achev, am_lot_vente_ant, am_empl_nb, am_tente_nb, am_carav_nb, am_mobil_nb, am_pers_nb, am_empl_hll_nb, am_hll_shon, am_periode_exploit, am_exist_agrand, am_exist_date, am_exist_num, am_exist_nb_avant, am_exist_nb_apres, am_coupe_bois, am_coupe_parc, am_coupe_align, am_coupe_ess, am_coupe_age, am_coupe_dens, am_coupe_qual, am_coupe_trait, am_coupe_autr, co_archi_recours, co_cstr_nouv, co_cstr_exist, co_cloture, co_elec_tension, co_div_terr, co_projet_desc, co_anx_pisc, co_anx_gara, co_anx_veran, co_anx_abri, co_anx_autr, co_anx_autr_desc, co_tot_log_nb, co_tot_ind_nb, co_tot_coll_nb, co_mais_piece_nb, co_mais_niv_nb, co_fin_lls_nb, co_fin_aa_nb, co_fin_ptz_nb, co_fin_autr_nb, co_fin_autr_desc, co_mais_contrat_ind, co_uti_pers, co_uti_vente, co_uti_loc, co_uti_princ, co_uti_secon, co_resid_agees, co_resid_etud, co_resid_tourism, co_resid_hot_soc, co_resid_soc, co_resid_hand, co_resid_autr, co_resid_autr_desc, co_foyer_chamb_nb, co_log_1p_nb, co_log_2p_nb, co_log_3p_nb, co_log_4p_nb, co_log_5p_nb, co_log_6p_nb, co_bat_niv_nb, co_trx_exten, co_trx_surelev, co_trx_nivsup, co_demont_periode, co_sp_transport, co_sp_enseign, co_sp_act_soc, co_sp_ouvr_spe, co_sp_sante, co_sp_culture, co_statio_avt_nb, co_statio_apr_nb, co_statio_adr, co_statio_place_nb, co_statio_tot_surf, co_statio_tot_shob, co_statio_comm_cin_surf, tab_surface, dm_constr_dates, dm_total, dm_partiel, dm_projet_desc, dm_tot_log_nb, tax_surf_tot, tax_surf, tax_surf_suppr_mod, tab_tax_su_princ, tab_tax_su_heber, tab_tax_su_secon, tab_tax_su_tot, tax_ext_pret, tax_ext_desc, tax_surf_tax_exist_cons, tax_log_exist_nb, tax_trx_presc_ppr, tax_monu_hist, tax_comm_nb, tab_tax_su_non_habit_surf, tab_tax_am, vsd_surf_planch_smd, vsd_unit_fonc_sup, vsd_unit_fonc_constr_sup, vsd_val_terr, vsd_const_sxist_non_dem_surf, vsd_rescr_fisc, pld_val_terr, pld_const_exist_dem, pld_const_exist_dem_surf, code_cnil, terr_juri_titul, terr_juri_lot, terr_juri_zac, terr_juri_afu, terr_juri_pup, terr_juri_oin, terr_juri_desc, terr_div_surf_etab, terr_div_surf_av_div, doc_date, doc_tot_trav, doc_tranche_trav, doc_tranche_trav_desc, doc_surf, doc_nb_log, doc_nb_log_indiv, doc_nb_log_coll, doc_nb_log_lls, doc_nb_log_aa, doc_nb_log_ptz, doc_nb_log_autre, daact_date, daact_date_chgmt_dest, daact_tot_trav, daact_tranche_trav, daact_tranche_trav_desc, daact_surf, daact_nb_log, daact_nb_log_indiv, daact_nb_log_coll, daact_nb_log_lls, daact_nb_log_aa, daact_nb_log_ptz, daact_nb_log_autre, am_div_mun, co_perf_energ, architecte, co_statio_avt_shob, co_statio_apr_shob, co_statio_avt_surf, co_statio_apr_surf, co_trx_amgt, co_modif_aspect, co_modif_struct, co_ouvr_elec, co_ouvr_infra, co_trx_imm, co_cstr_shob, am_voyage_deb, am_voyage_fin, am_modif_amgt, am_lot_max_shob, mod_desc, tr_total, tr_partiel, tr_desc, avap_co_elt_pro, avap_nouv_haut_surf, avap_co_clot, avap_aut_coup_aba_arb, avap_ouv_infra, avap_aut_inst_mob, avap_aut_plant, avap_aut_auv_elec, tax_dest_loc_tr, ope_proj_desc, tax_surf_tot_cstr, tax_surf_loc_stat, tax_log_ap_trvx_nb, tax_am_statio_ext_cr, tax_sup_bass_pisc_cr, tax_empl_ten_carav_mobil_nb_cr, tax_empl_hll_nb_cr, tax_eol_haut_nb_cr, tax_pann_volt_sup_cr, tax_surf_loc_arch, tax_surf_pisc_arch, tax_am_statio_ext_arch, tab_tax_su_parc_statio_expl_comm, tax_empl_ten_carav_mobil_nb_arch, tax_empl_hll_nb_arch, tax_eol_haut_nb_arch, ope_proj_div_co, ope_proj_div_contr, tax_desc, erp_cstr_neuve, erp_trvx_acc, erp_extension, erp_rehab, erp_trvx_am, erp_vol_nouv_exist, tab_erp_eff, erp_class_cat, erp_class_type, tax_surf_abr_jard_pig_colom, tax_su_non_habit_abr_jard_pig_colom, dia_imm_non_bati, dia_imm_bati_terr_propr, dia_imm_bati_terr_autr, dia_imm_bati_terr_autr_desc, dia_bat_copro, dia_bat_copro_desc, dia_lot_numero, dia_lot_bat, dia_lot_etage, dia_lot_quote_part, dia_us_hab, dia_us_pro, dia_us_mixte, dia_us_comm, dia_us_agr, dia_us_autre, dia_us_autre_prec, dia_occ_prop, dia_occ_loc, dia_occ_sans_occ, dia_occ_autre, dia_occ_autre_prec, dia_mod_cess_prix_vente, dia_mod_cess_prix_vente_mob, dia_mod_cess_prix_vente_cheptel, dia_mod_cess_prix_vente_recol, dia_mod_cess_prix_vente_autre, dia_mod_cess_commi, dia_mod_cess_commi_ttc, dia_mod_cess_commi_ht, dia_acquereur_nom_prenom, dia_acquereur_adr_num_voie, dia_acquereur_adr_ext, dia_acquereur_adr_type_voie, dia_acquereur_adr_nom_voie, dia_acquereur_adr_lieu_dit_bp, dia_acquereur_adr_cp, dia_acquereur_adr_localite, dia_observation, tab_surface2, dia_occ_sol_su_terre, dia_occ_sol_su_pres, dia_occ_sol_su_verger, dia_occ_sol_su_vigne, dia_occ_sol_su_bois, dia_occ_sol_su_lande, dia_occ_sol_su_carriere, dia_occ_sol_su_eau_cadastree, dia_occ_sol_su_jardin, dia_occ_sol_su_terr_batir, dia_occ_sol_su_terr_agr, dia_occ_sol_su_sol, dia_bati_vend_tot, dia_bati_vend_tot_txt, dia_su_co_sol, dia_su_util_hab, dia_nb_niv, dia_nb_appart, dia_nb_autre_loc, dia_vente_lot_volume, dia_vente_lot_volume_txt, dia_lot_nat_su, dia_lot_bat_achv_plus_10, dia_lot_bat_achv_moins_10, dia_lot_regl_copro_publ_hypo_plus_10, dia_lot_regl_copro_publ_hypo_moins_10, dia_indivi_quote_part, dia_design_societe, dia_design_droit, dia_droit_soc_nat, dia_droit_soc_nb, dia_droit_soc_num_part, dia_droit_reel_perso_grevant_bien_oui, dia_droit_reel_perso_grevant_bien_non, dia_droit_reel_perso_nat, dia_droit_reel_perso_viag, dia_mod_cess_adr, dia_mod_cess_sign_act_auth, dia_mod_cess_terme, dia_mod_cess_terme_prec, dia_mod_cess_bene_acquereur, dia_mod_cess_bene_vendeur, dia_mod_cess_paie_nat, dia_mod_cess_design_contr_alien, dia_mod_cess_eval_contr, dia_mod_cess_rente_viag, dia_mod_cess_mnt_an, dia_mod_cess_mnt_compt, dia_mod_cess_bene_rente, dia_mod_cess_droit_usa_hab, dia_mod_cess_droit_usa_hab_prec, dia_mod_cess_eval_usa_usufruit, dia_mod_cess_vente_nue_prop, dia_mod_cess_vente_nue_prop_prec, dia_mod_cess_echange, dia_mod_cess_design_bien_recus_ech, dia_mod_cess_mnt_soulte, dia_mod_cess_prop_contre_echan, dia_mod_cess_apport_societe, dia_mod_cess_bene, dia_mod_cess_esti_bien, dia_mod_cess_cess_terr_loc_co, dia_mod_cess_esti_terr, dia_mod_cess_esti_loc, dia_mod_cess_esti_imm_loca, dia_mod_cess_adju_vol, dia_mod_cess_adju_obl, dia_mod_cess_adju_fin_indivi, dia_mod_cess_adju_date_lieu, dia_mod_cess_mnt_mise_prix, dia_prop_titu_prix_indique, dia_prop_recherche_acqu_prix_indique, dia_acquereur_prof, dia_indic_compl_ope, dia_vente_adju, am_terr_res_demon, am_air_terr_res_mob, ctx_objet_recours, ctx_moyen_souleve, ctx_moyen_retenu_juge, ctx_reference_sagace, ctx_nature_travaux_infra_om_html, ctx_synthese_nti, ctx_article_non_resp_om_html, ctx_synthese_anr, ctx_reference_parquet, ctx_element_taxation, ctx_infraction, ctx_regularisable, ctx_reference_courrier, ctx_date_audience, ctx_date_ajournement, exo_facul_1, exo_facul_2, exo_facul_3, exo_facul_4, exo_facul_5, exo_facul_6, exo_facul_7, exo_facul_8, exo_facul_9, exo_ta_1, exo_ta_2, exo_ta_3, exo_ta_4, exo_ta_5, exo_ta_6, exo_ta_7, exo_ta_8, exo_ta_9, exo_rap_1, exo_rap_2, exo_rap_3, exo_rap_4, exo_rap_5, exo_rap_6, exo_rap_7, exo_rap_8, mtn_exo_ta_part_commu, mtn_exo_ta_part_depart, mtn_exo_ta_part_reg, mtn_exo_rap, dpc_type, dpc_desc_actv_ex, dpc_desc_ca, dpc_desc_aut_prec, dpc_desig_comm_arti, dpc_desig_loc_hab, dpc_desig_loc_ann, dpc_desig_loc_ann_prec, dpc_bail_comm_date, dpc_bail_comm_loyer, dpc_actv_acqu, dpc_nb_sala_di, dpc_nb_sala_dd, dpc_nb_sala_tc, dpc_nb_sala_tp, dpc_moda_cess_vente_am, dpc_moda_cess_adj, dpc_moda_cess_prix, dpc_moda_cess_adj_date, dpc_moda_cess_adj_prec, dpc_moda_cess_paie_comp, dpc_moda_cess_paie_terme, dpc_moda_cess_paie_terme_prec, dpc_moda_cess_paie_nat, dpc_moda_cess_paie_nat_desig_alien, dpc_moda_cess_paie_nat_desig_alien_prec, dpc_moda_cess_paie_nat_eval, dpc_moda_cess_paie_nat_eval_prec, dpc_moda_cess_paie_aut, dpc_moda_cess_paie_aut_prec, dpc_ss_signe_demande_acqu, dpc_ss_signe_recher_trouv_acqu, dpc_notif_adr_prop, dpc_notif_adr_manda, dpc_obs, co_peri_site_patri_remar, co_abo_monu_hist, co_inst_ouvr_trav_act_code_envir, co_trav_auto_env, co_derog_esp_prot, ctx_reference_dsj, co_piscine, co_fin_lls, co_fin_aa, co_fin_ptz, co_fin_autr, dia_ss_date, dia_ss_lieu, enga_decla_lieu, enga_decla_date, co_archi_attest_honneur, co_bat_niv_dessous_nb, co_install_classe, co_derog_innov, co_avis_abf, tax_surf_tot_demo, tax_surf_tax_demo, tax_terrassement_arch, tax_adresse_future_numero, tax_adresse_future_voie, tax_adresse_future_lieudit, tax_adresse_future_localite, tax_adresse_future_cp, tax_adresse_future_bp, tax_adresse_future_cedex, tax_adresse_future_pays, tax_adresse_future_division, co_bat_projete, co_bat_existant, co_bat_nature, terr_juri_titul_date, co_autre_desc, co_trx_autre, co_autre, erp_modif_facades, erp_trvx_adap, erp_trvx_adap_numero, erp_trvx_adap_valid, erp_prod_dangereux, co_trav_supp_dessus, co_trav_supp_dessous, tax_su_habit_abr_jard_pig_colom, enga_decla_donnees_nomi_comm) VALUES (4, 'cerfa de test n°3', '123456', '2013-02-01', '2016-06-01', true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 13409, true, true, true, true, true, true, true, true, 1340903, 1340903, 1340903, 1340903, true, true, true, true, true, true, true, 1340903, 13409, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 1340903, true, true, true, true, true, true, true, true, true, true, true, true, 1382403, true, true, true, true, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, NULL, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false);
INSERT INTO cerfa (cerfa, libelle, code, om_validite_debut, om_validite_fin, am_lotiss, am_autre_div, am_camping, am_caravane, am_carav_duree, am_statio, am_statio_cont, am_affou_exhau, am_affou_exhau_sup, am_affou_prof, am_exhau_haut, am_coupe_abat, am_prot_plu, am_prot_muni, am_mobil_voyage, am_aire_voyage, am_rememb_afu, am_parc_resid_loi, am_sport_moto, am_sport_attrac, am_sport_golf, am_mob_art, am_modif_voie_esp, am_plant_voie_esp, am_chem_ouv_esp, am_agri_peche, am_crea_voie, am_modif_voie_exist, am_crea_esp_sauv, am_crea_esp_class, am_projet_desc, am_terr_surf, am_tranche_desc, am_lot_max_nb, am_lot_max_shon, am_lot_cstr_cos, am_lot_cstr_plan, am_lot_cstr_vente, am_lot_fin_diff, am_lot_consign, am_lot_gar_achev, am_lot_vente_ant, am_empl_nb, am_tente_nb, am_carav_nb, am_mobil_nb, am_pers_nb, am_empl_hll_nb, am_hll_shon, am_periode_exploit, am_exist_agrand, am_exist_date, am_exist_num, am_exist_nb_avant, am_exist_nb_apres, am_coupe_bois, am_coupe_parc, am_coupe_align, am_coupe_ess, am_coupe_age, am_coupe_dens, am_coupe_qual, am_coupe_trait, am_coupe_autr, co_archi_recours, co_cstr_nouv, co_cstr_exist, co_cloture, co_elec_tension, co_div_terr, co_projet_desc, co_anx_pisc, co_anx_gara, co_anx_veran, co_anx_abri, co_anx_autr, co_anx_autr_desc, co_tot_log_nb, co_tot_ind_nb, co_tot_coll_nb, co_mais_piece_nb, co_mais_niv_nb, co_fin_lls_nb, co_fin_aa_nb, co_fin_ptz_nb, co_fin_autr_nb, co_fin_autr_desc, co_mais_contrat_ind, co_uti_pers, co_uti_vente, co_uti_loc, co_uti_princ, co_uti_secon, co_resid_agees, co_resid_etud, co_resid_tourism, co_resid_hot_soc, co_resid_soc, co_resid_hand, co_resid_autr, co_resid_autr_desc, co_foyer_chamb_nb, co_log_1p_nb, co_log_2p_nb, co_log_3p_nb, co_log_4p_nb, co_log_5p_nb, co_log_6p_nb, co_bat_niv_nb, co_trx_exten, co_trx_surelev, co_trx_nivsup, co_demont_periode, co_sp_transport, co_sp_enseign, co_sp_act_soc, co_sp_ouvr_spe, co_sp_sante, co_sp_culture, co_statio_avt_nb, co_statio_apr_nb, co_statio_adr, co_statio_place_nb, co_statio_tot_surf, co_statio_tot_shob, co_statio_comm_cin_surf, tab_surface, dm_constr_dates, dm_total, dm_partiel, dm_projet_desc, dm_tot_log_nb, tax_surf_tot, tax_surf, tax_surf_suppr_mod, tab_tax_su_princ, tab_tax_su_heber, tab_tax_su_secon, tab_tax_su_tot, tax_ext_pret, tax_ext_desc, tax_surf_tax_exist_cons, tax_log_exist_nb, tax_trx_presc_ppr, tax_monu_hist, tax_comm_nb, tab_tax_su_non_habit_surf, tab_tax_am, vsd_surf_planch_smd, vsd_unit_fonc_sup, vsd_unit_fonc_constr_sup, vsd_val_terr, vsd_const_sxist_non_dem_surf, vsd_rescr_fisc, pld_val_terr, pld_const_exist_dem, pld_const_exist_dem_surf, code_cnil, terr_juri_titul, terr_juri_lot, terr_juri_zac, terr_juri_afu, terr_juri_pup, terr_juri_oin, terr_juri_desc, terr_div_surf_etab, terr_div_surf_av_div, doc_date, doc_tot_trav, doc_tranche_trav, doc_tranche_trav_desc, doc_surf, doc_nb_log, doc_nb_log_indiv, doc_nb_log_coll, doc_nb_log_lls, doc_nb_log_aa, doc_nb_log_ptz, doc_nb_log_autre, daact_date, daact_date_chgmt_dest, daact_tot_trav, daact_tranche_trav, daact_tranche_trav_desc, daact_surf, daact_nb_log, daact_nb_log_indiv, daact_nb_log_coll, daact_nb_log_lls, daact_nb_log_aa, daact_nb_log_ptz, daact_nb_log_autre, am_div_mun, co_perf_energ, architecte, co_statio_avt_shob, co_statio_apr_shob, co_statio_avt_surf, co_statio_apr_surf, co_trx_amgt, co_modif_aspect, co_modif_struct, co_ouvr_elec, co_ouvr_infra, co_trx_imm, co_cstr_shob, am_voyage_deb, am_voyage_fin, am_modif_amgt, am_lot_max_shob, mod_desc, tr_total, tr_partiel, tr_desc, avap_co_elt_pro, avap_nouv_haut_surf, avap_co_clot, avap_aut_coup_aba_arb, avap_ouv_infra, avap_aut_inst_mob, avap_aut_plant, avap_aut_auv_elec, tax_dest_loc_tr, ope_proj_desc, tax_surf_tot_cstr, tax_surf_loc_stat, tax_log_ap_trvx_nb, tax_am_statio_ext_cr, tax_sup_bass_pisc_cr, tax_empl_ten_carav_mobil_nb_cr, tax_empl_hll_nb_cr, tax_eol_haut_nb_cr, tax_pann_volt_sup_cr, tax_surf_loc_arch, tax_surf_pisc_arch, tax_am_statio_ext_arch, tab_tax_su_parc_statio_expl_comm, tax_empl_ten_carav_mobil_nb_arch, tax_empl_hll_nb_arch, tax_eol_haut_nb_arch, ope_proj_div_co, ope_proj_div_contr, tax_desc, erp_cstr_neuve, erp_trvx_acc, erp_extension, erp_rehab, erp_trvx_am, erp_vol_nouv_exist, tab_erp_eff, erp_class_cat, erp_class_type, tax_surf_abr_jard_pig_colom, tax_su_non_habit_abr_jard_pig_colom, dia_imm_non_bati, dia_imm_bati_terr_propr, dia_imm_bati_terr_autr, dia_imm_bati_terr_autr_desc, dia_bat_copro, dia_bat_copro_desc, dia_lot_numero, dia_lot_bat, dia_lot_etage, dia_lot_quote_part, dia_us_hab, dia_us_pro, dia_us_mixte, dia_us_comm, dia_us_agr, dia_us_autre, dia_us_autre_prec, dia_occ_prop, dia_occ_loc, dia_occ_sans_occ, dia_occ_autre, dia_occ_autre_prec, dia_mod_cess_prix_vente, dia_mod_cess_prix_vente_mob, dia_mod_cess_prix_vente_cheptel, dia_mod_cess_prix_vente_recol, dia_mod_cess_prix_vente_autre, dia_mod_cess_commi, dia_mod_cess_commi_ttc, dia_mod_cess_commi_ht, dia_acquereur_nom_prenom, dia_acquereur_adr_num_voie, dia_acquereur_adr_ext, dia_acquereur_adr_type_voie, dia_acquereur_adr_nom_voie, dia_acquereur_adr_lieu_dit_bp, dia_acquereur_adr_cp, dia_acquereur_adr_localite, dia_observation, tab_surface2, dia_occ_sol_su_terre, dia_occ_sol_su_pres, dia_occ_sol_su_verger, dia_occ_sol_su_vigne, dia_occ_sol_su_bois, dia_occ_sol_su_lande, dia_occ_sol_su_carriere, dia_occ_sol_su_eau_cadastree, dia_occ_sol_su_jardin, dia_occ_sol_su_terr_batir, dia_occ_sol_su_terr_agr, dia_occ_sol_su_sol, dia_bati_vend_tot, dia_bati_vend_tot_txt, dia_su_co_sol, dia_su_util_hab, dia_nb_niv, dia_nb_appart, dia_nb_autre_loc, dia_vente_lot_volume, dia_vente_lot_volume_txt, dia_lot_nat_su, dia_lot_bat_achv_plus_10, dia_lot_bat_achv_moins_10, dia_lot_regl_copro_publ_hypo_plus_10, dia_lot_regl_copro_publ_hypo_moins_10, dia_indivi_quote_part, dia_design_societe, dia_design_droit, dia_droit_soc_nat, dia_droit_soc_nb, dia_droit_soc_num_part, dia_droit_reel_perso_grevant_bien_oui, dia_droit_reel_perso_grevant_bien_non, dia_droit_reel_perso_nat, dia_droit_reel_perso_viag, dia_mod_cess_adr, dia_mod_cess_sign_act_auth, dia_mod_cess_terme, dia_mod_cess_terme_prec, dia_mod_cess_bene_acquereur, dia_mod_cess_bene_vendeur, dia_mod_cess_paie_nat, dia_mod_cess_design_contr_alien, dia_mod_cess_eval_contr, dia_mod_cess_rente_viag, dia_mod_cess_mnt_an, dia_mod_cess_mnt_compt, dia_mod_cess_bene_rente, dia_mod_cess_droit_usa_hab, dia_mod_cess_droit_usa_hab_prec, dia_mod_cess_eval_usa_usufruit, dia_mod_cess_vente_nue_prop, dia_mod_cess_vente_nue_prop_prec, dia_mod_cess_echange, dia_mod_cess_design_bien_recus_ech, dia_mod_cess_mnt_soulte, dia_mod_cess_prop_contre_echan, dia_mod_cess_apport_societe, dia_mod_cess_bene, dia_mod_cess_esti_bien, dia_mod_cess_cess_terr_loc_co, dia_mod_cess_esti_terr, dia_mod_cess_esti_loc, dia_mod_cess_esti_imm_loca, dia_mod_cess_adju_vol, dia_mod_cess_adju_obl, dia_mod_cess_adju_fin_indivi, dia_mod_cess_adju_date_lieu, dia_mod_cess_mnt_mise_prix, dia_prop_titu_prix_indique, dia_prop_recherche_acqu_prix_indique, dia_acquereur_prof, dia_indic_compl_ope, dia_vente_adju, am_terr_res_demon, am_air_terr_res_mob, ctx_objet_recours, ctx_moyen_souleve, ctx_moyen_retenu_juge, ctx_reference_sagace, ctx_nature_travaux_infra_om_html, ctx_synthese_nti, ctx_article_non_resp_om_html, ctx_synthese_anr, ctx_reference_parquet, ctx_element_taxation, ctx_infraction, ctx_regularisable, ctx_reference_courrier, ctx_date_audience, ctx_date_ajournement, exo_facul_1, exo_facul_2, exo_facul_3, exo_facul_4, exo_facul_5, exo_facul_6, exo_facul_7, exo_facul_8, exo_facul_9, exo_ta_1, exo_ta_2, exo_ta_3, exo_ta_4, exo_ta_5, exo_ta_6, exo_ta_7, exo_ta_8, exo_ta_9, exo_rap_1, exo_rap_2, exo_rap_3, exo_rap_4, exo_rap_5, exo_rap_6, exo_rap_7, exo_rap_8, mtn_exo_ta_part_commu, mtn_exo_ta_part_depart, mtn_exo_ta_part_reg, mtn_exo_rap, dpc_type, dpc_desc_actv_ex, dpc_desc_ca, dpc_desc_aut_prec, dpc_desig_comm_arti, dpc_desig_loc_hab, dpc_desig_loc_ann, dpc_desig_loc_ann_prec, dpc_bail_comm_date, dpc_bail_comm_loyer, dpc_actv_acqu, dpc_nb_sala_di, dpc_nb_sala_dd, dpc_nb_sala_tc, dpc_nb_sala_tp, dpc_moda_cess_vente_am, dpc_moda_cess_adj, dpc_moda_cess_prix, dpc_moda_cess_adj_date, dpc_moda_cess_adj_prec, dpc_moda_cess_paie_comp, dpc_moda_cess_paie_terme, dpc_moda_cess_paie_terme_prec, dpc_moda_cess_paie_nat, dpc_moda_cess_paie_nat_desig_alien, dpc_moda_cess_paie_nat_desig_alien_prec, dpc_moda_cess_paie_nat_eval, dpc_moda_cess_paie_nat_eval_prec, dpc_moda_cess_paie_aut, dpc_moda_cess_paie_aut_prec, dpc_ss_signe_demande_acqu, dpc_ss_signe_recher_trouv_acqu, dpc_notif_adr_prop, dpc_notif_adr_manda, dpc_obs, co_peri_site_patri_remar, co_abo_monu_hist, co_inst_ouvr_trav_act_code_envir, co_trav_auto_env, co_derog_esp_prot, ctx_reference_dsj, co_piscine, co_fin_lls, co_fin_aa, co_fin_ptz, co_fin_autr, dia_ss_date, dia_ss_lieu, enga_decla_lieu, enga_decla_date, co_archi_attest_honneur, co_bat_niv_dessous_nb, co_install_classe, co_derog_innov, co_avis_abf, tax_surf_tot_demo, tax_surf_tax_demo, tax_terrassement_arch, tax_adresse_future_numero, tax_adresse_future_voie, tax_adresse_future_lieudit, tax_adresse_future_localite, tax_adresse_future_cp, tax_adresse_future_bp, tax_adresse_future_cedex, tax_adresse_future_pays, tax_adresse_future_division, co_bat_projete, co_bat_existant, co_bat_nature, terr_juri_titul_date, co_autre_desc, co_trx_autre, co_autre, erp_modif_facades, erp_trvx_adap, erp_trvx_adap_numero, erp_trvx_adap_valid, erp_prod_dangereux, co_trav_supp_dessus, co_trav_supp_dessous, tax_su_habit_abr_jard_pig_colom, enga_decla_donnees_nomi_comm) VALUES (5, 'cerfa de test n°4', '123456', '2013-01-01', '2016-11-01', true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 13409, true, true, true, true, true, true, true, true, 1340903, 1340903, 1340903, 1340903, true, true, true, true, true, true, true, 1340903, 13409, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 1340903, true, true, true, true, true, true, true, true, true, true, true, true, 1382403, true, true, true, true, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, 1340905, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false);
INSERT INTO cerfa (cerfa, libelle, code, om_validite_debut, om_validite_fin, am_lotiss, am_autre_div, am_camping, am_caravane, am_carav_duree, am_statio, am_statio_cont, am_affou_exhau, am_affou_exhau_sup, am_affou_prof, am_exhau_haut, am_coupe_abat, am_prot_plu, am_prot_muni, am_mobil_voyage, am_aire_voyage, am_rememb_afu, am_parc_resid_loi, am_sport_moto, am_sport_attrac, am_sport_golf, am_mob_art, am_modif_voie_esp, am_plant_voie_esp, am_chem_ouv_esp, am_agri_peche, am_crea_voie, am_modif_voie_exist, am_crea_esp_sauv, am_crea_esp_class, am_projet_desc, am_terr_surf, am_tranche_desc, am_lot_max_nb, am_lot_max_shon, am_lot_cstr_cos, am_lot_cstr_plan, am_lot_cstr_vente, am_lot_fin_diff, am_lot_consign, am_lot_gar_achev, am_lot_vente_ant, am_empl_nb, am_tente_nb, am_carav_nb, am_mobil_nb, am_pers_nb, am_empl_hll_nb, am_hll_shon, am_periode_exploit, am_exist_agrand, am_exist_date, am_exist_num, am_exist_nb_avant, am_exist_nb_apres, am_coupe_bois, am_coupe_parc, am_coupe_align, am_coupe_ess, am_coupe_age, am_coupe_dens, am_coupe_qual, am_coupe_trait, am_coupe_autr, co_archi_recours, co_cstr_nouv, co_cstr_exist, co_cloture, co_elec_tension, co_div_terr, co_projet_desc, co_anx_pisc, co_anx_gara, co_anx_veran, co_anx_abri, co_anx_autr, co_anx_autr_desc, co_tot_log_nb, co_tot_ind_nb, co_tot_coll_nb, co_mais_piece_nb, co_mais_niv_nb, co_fin_lls_nb, co_fin_aa_nb, co_fin_ptz_nb, co_fin_autr_nb, co_fin_autr_desc, co_mais_contrat_ind, co_uti_pers, co_uti_vente, co_uti_loc, co_uti_princ, co_uti_secon, co_resid_agees, co_resid_etud, co_resid_tourism, co_resid_hot_soc, co_resid_soc, co_resid_hand, co_resid_autr, co_resid_autr_desc, co_foyer_chamb_nb, co_log_1p_nb, co_log_2p_nb, co_log_3p_nb, co_log_4p_nb, co_log_5p_nb, co_log_6p_nb, co_bat_niv_nb, co_trx_exten, co_trx_surelev, co_trx_nivsup, co_demont_periode, co_sp_transport, co_sp_enseign, co_sp_act_soc, co_sp_ouvr_spe, co_sp_sante, co_sp_culture, co_statio_avt_nb, co_statio_apr_nb, co_statio_adr, co_statio_place_nb, co_statio_tot_surf, co_statio_tot_shob, co_statio_comm_cin_surf, tab_surface, dm_constr_dates, dm_total, dm_partiel, dm_projet_desc, dm_tot_log_nb, tax_surf_tot, tax_surf, tax_surf_suppr_mod, tab_tax_su_princ, tab_tax_su_heber, tab_tax_su_secon, tab_tax_su_tot, tax_ext_pret, tax_ext_desc, tax_surf_tax_exist_cons, tax_log_exist_nb, tax_trx_presc_ppr, tax_monu_hist, tax_comm_nb, tab_tax_su_non_habit_surf, tab_tax_am, vsd_surf_planch_smd, vsd_unit_fonc_sup, vsd_unit_fonc_constr_sup, vsd_val_terr, vsd_const_sxist_non_dem_surf, vsd_rescr_fisc, pld_val_terr, pld_const_exist_dem, pld_const_exist_dem_surf, code_cnil, terr_juri_titul, terr_juri_lot, terr_juri_zac, terr_juri_afu, terr_juri_pup, terr_juri_oin, terr_juri_desc, terr_div_surf_etab, terr_div_surf_av_div, doc_date, doc_tot_trav, doc_tranche_trav, doc_tranche_trav_desc, doc_surf, doc_nb_log, doc_nb_log_indiv, doc_nb_log_coll, doc_nb_log_lls, doc_nb_log_aa, doc_nb_log_ptz, doc_nb_log_autre, daact_date, daact_date_chgmt_dest, daact_tot_trav, daact_tranche_trav, daact_tranche_trav_desc, daact_surf, daact_nb_log, daact_nb_log_indiv, daact_nb_log_coll, daact_nb_log_lls, daact_nb_log_aa, daact_nb_log_ptz, daact_nb_log_autre, am_div_mun, co_perf_energ, architecte, co_statio_avt_shob, co_statio_apr_shob, co_statio_avt_surf, co_statio_apr_surf, co_trx_amgt, co_modif_aspect, co_modif_struct, co_ouvr_elec, co_ouvr_infra, co_trx_imm, co_cstr_shob, am_voyage_deb, am_voyage_fin, am_modif_amgt, am_lot_max_shob, mod_desc, tr_total, tr_partiel, tr_desc, avap_co_elt_pro, avap_nouv_haut_surf, avap_co_clot, avap_aut_coup_aba_arb, avap_ouv_infra, avap_aut_inst_mob, avap_aut_plant, avap_aut_auv_elec, tax_dest_loc_tr, ope_proj_desc, tax_surf_tot_cstr, tax_surf_loc_stat, tax_log_ap_trvx_nb, tax_am_statio_ext_cr, tax_sup_bass_pisc_cr, tax_empl_ten_carav_mobil_nb_cr, tax_empl_hll_nb_cr, tax_eol_haut_nb_cr, tax_pann_volt_sup_cr, tax_surf_loc_arch, tax_surf_pisc_arch, tax_am_statio_ext_arch, tab_tax_su_parc_statio_expl_comm, tax_empl_ten_carav_mobil_nb_arch, tax_empl_hll_nb_arch, tax_eol_haut_nb_arch, ope_proj_div_co, ope_proj_div_contr, tax_desc, erp_cstr_neuve, erp_trvx_acc, erp_extension, erp_rehab, erp_trvx_am, erp_vol_nouv_exist, tab_erp_eff, erp_class_cat, erp_class_type, tax_surf_abr_jard_pig_colom, tax_su_non_habit_abr_jard_pig_colom, dia_imm_non_bati, dia_imm_bati_terr_propr, dia_imm_bati_terr_autr, dia_imm_bati_terr_autr_desc, dia_bat_copro, dia_bat_copro_desc, dia_lot_numero, dia_lot_bat, dia_lot_etage, dia_lot_quote_part, dia_us_hab, dia_us_pro, dia_us_mixte, dia_us_comm, dia_us_agr, dia_us_autre, dia_us_autre_prec, dia_occ_prop, dia_occ_loc, dia_occ_sans_occ, dia_occ_autre, dia_occ_autre_prec, dia_mod_cess_prix_vente, dia_mod_cess_prix_vente_mob, dia_mod_cess_prix_vente_cheptel, dia_mod_cess_prix_vente_recol, dia_mod_cess_prix_vente_autre, dia_mod_cess_commi, dia_mod_cess_commi_ttc, dia_mod_cess_commi_ht, dia_acquereur_nom_prenom, dia_acquereur_adr_num_voie, dia_acquereur_adr_ext, dia_acquereur_adr_type_voie, dia_acquereur_adr_nom_voie, dia_acquereur_adr_lieu_dit_bp, dia_acquereur_adr_cp, dia_acquereur_adr_localite, dia_observation, tab_surface2, dia_occ_sol_su_terre, dia_occ_sol_su_pres, dia_occ_sol_su_verger, dia_occ_sol_su_vigne, dia_occ_sol_su_bois, dia_occ_sol_su_lande, dia_occ_sol_su_carriere, dia_occ_sol_su_eau_cadastree, dia_occ_sol_su_jardin, dia_occ_sol_su_terr_batir, dia_occ_sol_su_terr_agr, dia_occ_sol_su_sol, dia_bati_vend_tot, dia_bati_vend_tot_txt, dia_su_co_sol, dia_su_util_hab, dia_nb_niv, dia_nb_appart, dia_nb_autre_loc, dia_vente_lot_volume, dia_vente_lot_volume_txt, dia_lot_nat_su, dia_lot_bat_achv_plus_10, dia_lot_bat_achv_moins_10, dia_lot_regl_copro_publ_hypo_plus_10, dia_lot_regl_copro_publ_hypo_moins_10, dia_indivi_quote_part, dia_design_societe, dia_design_droit, dia_droit_soc_nat, dia_droit_soc_nb, dia_droit_soc_num_part, dia_droit_reel_perso_grevant_bien_oui, dia_droit_reel_perso_grevant_bien_non, dia_droit_reel_perso_nat, dia_droit_reel_perso_viag, dia_mod_cess_adr, dia_mod_cess_sign_act_auth, dia_mod_cess_terme, dia_mod_cess_terme_prec, dia_mod_cess_bene_acquereur, dia_mod_cess_bene_vendeur, dia_mod_cess_paie_nat, dia_mod_cess_design_contr_alien, dia_mod_cess_eval_contr, dia_mod_cess_rente_viag, dia_mod_cess_mnt_an, dia_mod_cess_mnt_compt, dia_mod_cess_bene_rente, dia_mod_cess_droit_usa_hab, dia_mod_cess_droit_usa_hab_prec, dia_mod_cess_eval_usa_usufruit, dia_mod_cess_vente_nue_prop, dia_mod_cess_vente_nue_prop_prec, dia_mod_cess_echange, dia_mod_cess_design_bien_recus_ech, dia_mod_cess_mnt_soulte, dia_mod_cess_prop_contre_echan, dia_mod_cess_apport_societe, dia_mod_cess_bene, dia_mod_cess_esti_bien, dia_mod_cess_cess_terr_loc_co, dia_mod_cess_esti_terr, dia_mod_cess_esti_loc, dia_mod_cess_esti_imm_loca, dia_mod_cess_adju_vol, dia_mod_cess_adju_obl, dia_mod_cess_adju_fin_indivi, dia_mod_cess_adju_date_lieu, dia_mod_cess_mnt_mise_prix, dia_prop_titu_prix_indique, dia_prop_recherche_acqu_prix_indique, dia_acquereur_prof, dia_indic_compl_ope, dia_vente_adju, am_terr_res_demon, am_air_terr_res_mob, ctx_objet_recours, ctx_moyen_souleve, ctx_moyen_retenu_juge, ctx_reference_sagace, ctx_nature_travaux_infra_om_html, ctx_synthese_nti, ctx_article_non_resp_om_html, ctx_synthese_anr, ctx_reference_parquet, ctx_element_taxation, ctx_infraction, ctx_regularisable, ctx_reference_courrier, ctx_date_audience, ctx_date_ajournement, exo_facul_1, exo_facul_2, exo_facul_3, exo_facul_4, exo_facul_5, exo_facul_6, exo_facul_7, exo_facul_8, exo_facul_9, exo_ta_1, exo_ta_2, exo_ta_3, exo_ta_4, exo_ta_5, exo_ta_6, exo_ta_7, exo_ta_8, exo_ta_9, exo_rap_1, exo_rap_2, exo_rap_3, exo_rap_4, exo_rap_5, exo_rap_6, exo_rap_7, exo_rap_8, mtn_exo_ta_part_commu, mtn_exo_ta_part_depart, mtn_exo_ta_part_reg, mtn_exo_rap, dpc_type, dpc_desc_actv_ex, dpc_desc_ca, dpc_desc_aut_prec, dpc_desig_comm_arti, dpc_desig_loc_hab, dpc_desig_loc_ann, dpc_desig_loc_ann_prec, dpc_bail_comm_date, dpc_bail_comm_loyer, dpc_actv_acqu, dpc_nb_sala_di, dpc_nb_sala_dd, dpc_nb_sala_tc, dpc_nb_sala_tp, dpc_moda_cess_vente_am, dpc_moda_cess_adj, dpc_moda_cess_prix, dpc_moda_cess_adj_date, dpc_moda_cess_adj_prec, dpc_moda_cess_paie_comp, dpc_moda_cess_paie_terme, dpc_moda_cess_paie_terme_prec, dpc_moda_cess_paie_nat, dpc_moda_cess_paie_nat_desig_alien, dpc_moda_cess_paie_nat_desig_alien_prec, dpc_moda_cess_paie_nat_eval, dpc_moda_cess_paie_nat_eval_prec, dpc_moda_cess_paie_aut, dpc_moda_cess_paie_aut_prec, dpc_ss_signe_demande_acqu, dpc_ss_signe_recher_trouv_acqu, dpc_notif_adr_prop, dpc_notif_adr_manda, dpc_obs, co_peri_site_patri_remar, co_abo_monu_hist, co_inst_ouvr_trav_act_code_envir, co_trav_auto_env, co_derog_esp_prot, ctx_reference_dsj, co_piscine, co_fin_lls, co_fin_aa, co_fin_ptz, co_fin_autr, dia_ss_date, dia_ss_lieu, enga_decla_lieu, enga_decla_date, co_archi_attest_honneur, co_bat_niv_dessous_nb, co_install_classe, co_derog_innov, co_avis_abf, tax_surf_tot_demo, tax_surf_tax_demo, tax_terrassement_arch, tax_adresse_future_numero, tax_adresse_future_voie, tax_adresse_future_lieudit, tax_adresse_future_localite, tax_adresse_future_cp, tax_adresse_future_bp, tax_adresse_future_cedex, tax_adresse_future_pays, tax_adresse_future_division, co_bat_projete, co_bat_existant, co_bat_nature, terr_juri_titul_date, co_autre_desc, co_trx_autre, co_autre, erp_modif_facades, erp_trvx_adap, erp_trvx_adap_numero, erp_trvx_adap_valid, erp_prod_dangereux, co_trav_supp_dessus, co_trav_supp_dessous, tax_su_habit_abr_jard_pig_colom, enga_decla_donnees_nomi_comm) VALUES (6, 'cerfa de test n°5', '123456', '2013-01-01', '2017-02-02', true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 13409, true, true, true, true, true, true, true, true, 1340903, 1340903, 1340903, 1340903, true, true, true, true, true, true, true, 1340903, 13409, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 1340903, true, true, true, true, true, true, true, true, true, true, true, true, 1382403, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 1340905, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false);
INSERT INTO cerfa (cerfa, libelle, code, om_validite_debut, om_validite_fin, am_lotiss, am_autre_div, am_camping, am_caravane, am_carav_duree, am_statio, am_statio_cont, am_affou_exhau, am_affou_exhau_sup, am_affou_prof, am_exhau_haut, am_coupe_abat, am_prot_plu, am_prot_muni, am_mobil_voyage, am_aire_voyage, am_rememb_afu, am_parc_resid_loi, am_sport_moto, am_sport_attrac, am_sport_golf, am_mob_art, am_modif_voie_esp, am_plant_voie_esp, am_chem_ouv_esp, am_agri_peche, am_crea_voie, am_modif_voie_exist, am_crea_esp_sauv, am_crea_esp_class, am_projet_desc, am_terr_surf, am_tranche_desc, am_lot_max_nb, am_lot_max_shon, am_lot_cstr_cos, am_lot_cstr_plan, am_lot_cstr_vente, am_lot_fin_diff, am_lot_consign, am_lot_gar_achev, am_lot_vente_ant, am_empl_nb, am_tente_nb, am_carav_nb, am_mobil_nb, am_pers_nb, am_empl_hll_nb, am_hll_shon, am_periode_exploit, am_exist_agrand, am_exist_date, am_exist_num, am_exist_nb_avant, am_exist_nb_apres, am_coupe_bois, am_coupe_parc, am_coupe_align, am_coupe_ess, am_coupe_age, am_coupe_dens, am_coupe_qual, am_coupe_trait, am_coupe_autr, co_archi_recours, co_cstr_nouv, co_cstr_exist, co_cloture, co_elec_tension, co_div_terr, co_projet_desc, co_anx_pisc, co_anx_gara, co_anx_veran, co_anx_abri, co_anx_autr, co_anx_autr_desc, co_tot_log_nb, co_tot_ind_nb, co_tot_coll_nb, co_mais_piece_nb, co_mais_niv_nb, co_fin_lls_nb, co_fin_aa_nb, co_fin_ptz_nb, co_fin_autr_nb, co_fin_autr_desc, co_mais_contrat_ind, co_uti_pers, co_uti_vente, co_uti_loc, co_uti_princ, co_uti_secon, co_resid_agees, co_resid_etud, co_resid_tourism, co_resid_hot_soc, co_resid_soc, co_resid_hand, co_resid_autr, co_resid_autr_desc, co_foyer_chamb_nb, co_log_1p_nb, co_log_2p_nb, co_log_3p_nb, co_log_4p_nb, co_log_5p_nb, co_log_6p_nb, co_bat_niv_nb, co_trx_exten, co_trx_surelev, co_trx_nivsup, co_demont_periode, co_sp_transport, co_sp_enseign, co_sp_act_soc, co_sp_ouvr_spe, co_sp_sante, co_sp_culture, co_statio_avt_nb, co_statio_apr_nb, co_statio_adr, co_statio_place_nb, co_statio_tot_surf, co_statio_tot_shob, co_statio_comm_cin_surf, tab_surface, dm_constr_dates, dm_total, dm_partiel, dm_projet_desc, dm_tot_log_nb, tax_surf_tot, tax_surf, tax_surf_suppr_mod, tab_tax_su_princ, tab_tax_su_heber, tab_tax_su_secon, tab_tax_su_tot, tax_ext_pret, tax_ext_desc, tax_surf_tax_exist_cons, tax_log_exist_nb, tax_trx_presc_ppr, tax_monu_hist, tax_comm_nb, tab_tax_su_non_habit_surf, tab_tax_am, vsd_surf_planch_smd, vsd_unit_fonc_sup, vsd_unit_fonc_constr_sup, vsd_val_terr, vsd_const_sxist_non_dem_surf, vsd_rescr_fisc, pld_val_terr, pld_const_exist_dem, pld_const_exist_dem_surf, code_cnil, terr_juri_titul, terr_juri_lot, terr_juri_zac, terr_juri_afu, terr_juri_pup, terr_juri_oin, terr_juri_desc, terr_div_surf_etab, terr_div_surf_av_div, doc_date, doc_tot_trav, doc_tranche_trav, doc_tranche_trav_desc, doc_surf, doc_nb_log, doc_nb_log_indiv, doc_nb_log_coll, doc_nb_log_lls, doc_nb_log_aa, doc_nb_log_ptz, doc_nb_log_autre, daact_date, daact_date_chgmt_dest, daact_tot_trav, daact_tranche_trav, daact_tranche_trav_desc, daact_surf, daact_nb_log, daact_nb_log_indiv, daact_nb_log_coll, daact_nb_log_lls, daact_nb_log_aa, daact_nb_log_ptz, daact_nb_log_autre, am_div_mun, co_perf_energ, architecte, co_statio_avt_shob, co_statio_apr_shob, co_statio_avt_surf, co_statio_apr_surf, co_trx_amgt, co_modif_aspect, co_modif_struct, co_ouvr_elec, co_ouvr_infra, co_trx_imm, co_cstr_shob, am_voyage_deb, am_voyage_fin, am_modif_amgt, am_lot_max_shob, mod_desc, tr_total, tr_partiel, tr_desc, avap_co_elt_pro, avap_nouv_haut_surf, avap_co_clot, avap_aut_coup_aba_arb, avap_ouv_infra, avap_aut_inst_mob, avap_aut_plant, avap_aut_auv_elec, tax_dest_loc_tr, ope_proj_desc, tax_surf_tot_cstr, tax_surf_loc_stat, tax_log_ap_trvx_nb, tax_am_statio_ext_cr, tax_sup_bass_pisc_cr, tax_empl_ten_carav_mobil_nb_cr, tax_empl_hll_nb_cr, tax_eol_haut_nb_cr, tax_pann_volt_sup_cr, tax_surf_loc_arch, tax_surf_pisc_arch, tax_am_statio_ext_arch, tab_tax_su_parc_statio_expl_comm, tax_empl_ten_carav_mobil_nb_arch, tax_empl_hll_nb_arch, tax_eol_haut_nb_arch, ope_proj_div_co, ope_proj_div_contr, tax_desc, erp_cstr_neuve, erp_trvx_acc, erp_extension, erp_rehab, erp_trvx_am, erp_vol_nouv_exist, tab_erp_eff, erp_class_cat, erp_class_type, tax_surf_abr_jard_pig_colom, tax_su_non_habit_abr_jard_pig_colom, dia_imm_non_bati, dia_imm_bati_terr_propr, dia_imm_bati_terr_autr, dia_imm_bati_terr_autr_desc, dia_bat_copro, dia_bat_copro_desc, dia_lot_numero, dia_lot_bat, dia_lot_etage, dia_lot_quote_part, dia_us_hab, dia_us_pro, dia_us_mixte, dia_us_comm, dia_us_agr, dia_us_autre, dia_us_autre_prec, dia_occ_prop, dia_occ_loc, dia_occ_sans_occ, dia_occ_autre, dia_occ_autre_prec, dia_mod_cess_prix_vente, dia_mod_cess_prix_vente_mob, dia_mod_cess_prix_vente_cheptel, dia_mod_cess_prix_vente_recol, dia_mod_cess_prix_vente_autre, dia_mod_cess_commi, dia_mod_cess_commi_ttc, dia_mod_cess_commi_ht, dia_acquereur_nom_prenom, dia_acquereur_adr_num_voie, dia_acquereur_adr_ext, dia_acquereur_adr_type_voie, dia_acquereur_adr_nom_voie, dia_acquereur_adr_lieu_dit_bp, dia_acquereur_adr_cp, dia_acquereur_adr_localite, dia_observation, tab_surface2, dia_occ_sol_su_terre, dia_occ_sol_su_pres, dia_occ_sol_su_verger, dia_occ_sol_su_vigne, dia_occ_sol_su_bois, dia_occ_sol_su_lande, dia_occ_sol_su_carriere, dia_occ_sol_su_eau_cadastree, dia_occ_sol_su_jardin, dia_occ_sol_su_terr_batir, dia_occ_sol_su_terr_agr, dia_occ_sol_su_sol, dia_bati_vend_tot, dia_bati_vend_tot_txt, dia_su_co_sol, dia_su_util_hab, dia_nb_niv, dia_nb_appart, dia_nb_autre_loc, dia_vente_lot_volume, dia_vente_lot_volume_txt, dia_lot_nat_su, dia_lot_bat_achv_plus_10, dia_lot_bat_achv_moins_10, dia_lot_regl_copro_publ_hypo_plus_10, dia_lot_regl_copro_publ_hypo_moins_10, dia_indivi_quote_part, dia_design_societe, dia_design_droit, dia_droit_soc_nat, dia_droit_soc_nb, dia_droit_soc_num_part, dia_droit_reel_perso_grevant_bien_oui, dia_droit_reel_perso_grevant_bien_non, dia_droit_reel_perso_nat, dia_droit_reel_perso_viag, dia_mod_cess_adr, dia_mod_cess_sign_act_auth, dia_mod_cess_terme, dia_mod_cess_terme_prec, dia_mod_cess_bene_acquereur, dia_mod_cess_bene_vendeur, dia_mod_cess_paie_nat, dia_mod_cess_design_contr_alien, dia_mod_cess_eval_contr, dia_mod_cess_rente_viag, dia_mod_cess_mnt_an, dia_mod_cess_mnt_compt, dia_mod_cess_bene_rente, dia_mod_cess_droit_usa_hab, dia_mod_cess_droit_usa_hab_prec, dia_mod_cess_eval_usa_usufruit, dia_mod_cess_vente_nue_prop, dia_mod_cess_vente_nue_prop_prec, dia_mod_cess_echange, dia_mod_cess_design_bien_recus_ech, dia_mod_cess_mnt_soulte, dia_mod_cess_prop_contre_echan, dia_mod_cess_apport_societe, dia_mod_cess_bene, dia_mod_cess_esti_bien, dia_mod_cess_cess_terr_loc_co, dia_mod_cess_esti_terr, dia_mod_cess_esti_loc, dia_mod_cess_esti_imm_loca, dia_mod_cess_adju_vol, dia_mod_cess_adju_obl, dia_mod_cess_adju_fin_indivi, dia_mod_cess_adju_date_lieu, dia_mod_cess_mnt_mise_prix, dia_prop_titu_prix_indique, dia_prop_recherche_acqu_prix_indique, dia_acquereur_prof, dia_indic_compl_ope, dia_vente_adju, am_terr_res_demon, am_air_terr_res_mob, ctx_objet_recours, ctx_moyen_souleve, ctx_moyen_retenu_juge, ctx_reference_sagace, ctx_nature_travaux_infra_om_html, ctx_synthese_nti, ctx_article_non_resp_om_html, ctx_synthese_anr, ctx_reference_parquet, ctx_element_taxation, ctx_infraction, ctx_regularisable, ctx_reference_courrier, ctx_date_audience, ctx_date_ajournement, exo_facul_1, exo_facul_2, exo_facul_3, exo_facul_4, exo_facul_5, exo_facul_6, exo_facul_7, exo_facul_8, exo_facul_9, exo_ta_1, exo_ta_2, exo_ta_3, exo_ta_4, exo_ta_5, exo_ta_6, exo_ta_7, exo_ta_8, exo_ta_9, exo_rap_1, exo_rap_2, exo_rap_3, exo_rap_4, exo_rap_5, exo_rap_6, exo_rap_7, exo_rap_8, mtn_exo_ta_part_commu, mtn_exo_ta_part_depart, mtn_exo_ta_part_reg, mtn_exo_rap, dpc_type, dpc_desc_actv_ex, dpc_desc_ca, dpc_desc_aut_prec, dpc_desig_comm_arti, dpc_desig_loc_hab, dpc_desig_loc_ann, dpc_desig_loc_ann_prec, dpc_bail_comm_date, dpc_bail_comm_loyer, dpc_actv_acqu, dpc_nb_sala_di, dpc_nb_sala_dd, dpc_nb_sala_tc, dpc_nb_sala_tp, dpc_moda_cess_vente_am, dpc_moda_cess_adj, dpc_moda_cess_prix, dpc_moda_cess_adj_date, dpc_moda_cess_adj_prec, dpc_moda_cess_paie_comp, dpc_moda_cess_paie_terme, dpc_moda_cess_paie_terme_prec, dpc_moda_cess_paie_nat, dpc_moda_cess_paie_nat_desig_alien, dpc_moda_cess_paie_nat_desig_alien_prec, dpc_moda_cess_paie_nat_eval, dpc_moda_cess_paie_nat_eval_prec, dpc_moda_cess_paie_aut, dpc_moda_cess_paie_aut_prec, dpc_ss_signe_demande_acqu, dpc_ss_signe_recher_trouv_acqu, dpc_notif_adr_prop, dpc_notif_adr_manda, dpc_obs, co_peri_site_patri_remar, co_abo_monu_hist, co_inst_ouvr_trav_act_code_envir, co_trav_auto_env, co_derog_esp_prot, ctx_reference_dsj, co_piscine, co_fin_lls, co_fin_aa, co_fin_ptz, co_fin_autr, dia_ss_date, dia_ss_lieu, enga_decla_lieu, enga_decla_date, co_archi_attest_honneur, co_bat_niv_dessous_nb, co_install_classe, co_derog_innov, co_avis_abf, tax_surf_tot_demo, tax_surf_tax_demo, tax_terrassement_arch, tax_adresse_future_numero, tax_adresse_future_voie, tax_adresse_future_lieudit, tax_adresse_future_localite, tax_adresse_future_cp, tax_adresse_future_bp, tax_adresse_future_cedex, tax_adresse_future_pays, tax_adresse_future_division, co_bat_projete, co_bat_existant, co_bat_nature, terr_juri_titul_date, co_autre_desc, co_trx_autre, co_autre, erp_modif_facades, erp_trvx_adap, erp_trvx_adap_numero, erp_trvx_adap_valid, erp_prod_dangereux, co_trav_supp_dessus, co_trav_supp_dessous, tax_su_habit_abr_jard_pig_colom, enga_decla_donnees_nomi_comm) VALUES (8, 'cerfa de test n°7', '123456', '2013-01-01', '2017-06-01', true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 13409, true, true, true, true, true, true, true, true, 1340903, 1340903, 1340903, 1340903, true, true, true, true, true, true, true, 1340903, 13409, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 1340903, true, true, true, true, true, true, true, true, true, true, true, true, 1382403, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 1340905, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, false, false, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false);
INSERT INTO cerfa (cerfa, libelle, code, om_validite_debut, om_validite_fin, am_lotiss, am_autre_div, am_camping, am_caravane, am_carav_duree, am_statio, am_statio_cont, am_affou_exhau, am_affou_exhau_sup, am_affou_prof, am_exhau_haut, am_coupe_abat, am_prot_plu, am_prot_muni, am_mobil_voyage, am_aire_voyage, am_rememb_afu, am_parc_resid_loi, am_sport_moto, am_sport_attrac, am_sport_golf, am_mob_art, am_modif_voie_esp, am_plant_voie_esp, am_chem_ouv_esp, am_agri_peche, am_crea_voie, am_modif_voie_exist, am_crea_esp_sauv, am_crea_esp_class, am_projet_desc, am_terr_surf, am_tranche_desc, am_lot_max_nb, am_lot_max_shon, am_lot_cstr_cos, am_lot_cstr_plan, am_lot_cstr_vente, am_lot_fin_diff, am_lot_consign, am_lot_gar_achev, am_lot_vente_ant, am_empl_nb, am_tente_nb, am_carav_nb, am_mobil_nb, am_pers_nb, am_empl_hll_nb, am_hll_shon, am_periode_exploit, am_exist_agrand, am_exist_date, am_exist_num, am_exist_nb_avant, am_exist_nb_apres, am_coupe_bois, am_coupe_parc, am_coupe_align, am_coupe_ess, am_coupe_age, am_coupe_dens, am_coupe_qual, am_coupe_trait, am_coupe_autr, co_archi_recours, co_cstr_nouv, co_cstr_exist, co_cloture, co_elec_tension, co_div_terr, co_projet_desc, co_anx_pisc, co_anx_gara, co_anx_veran, co_anx_abri, co_anx_autr, co_anx_autr_desc, co_tot_log_nb, co_tot_ind_nb, co_tot_coll_nb, co_mais_piece_nb, co_mais_niv_nb, co_fin_lls_nb, co_fin_aa_nb, co_fin_ptz_nb, co_fin_autr_nb, co_fin_autr_desc, co_mais_contrat_ind, co_uti_pers, co_uti_vente, co_uti_loc, co_uti_princ, co_uti_secon, co_resid_agees, co_resid_etud, co_resid_tourism, co_resid_hot_soc, co_resid_soc, co_resid_hand, co_resid_autr, co_resid_autr_desc, co_foyer_chamb_nb, co_log_1p_nb, co_log_2p_nb, co_log_3p_nb, co_log_4p_nb, co_log_5p_nb, co_log_6p_nb, co_bat_niv_nb, co_trx_exten, co_trx_surelev, co_trx_nivsup, co_demont_periode, co_sp_transport, co_sp_enseign, co_sp_act_soc, co_sp_ouvr_spe, co_sp_sante, co_sp_culture, co_statio_avt_nb, co_statio_apr_nb, co_statio_adr, co_statio_place_nb, co_statio_tot_surf, co_statio_tot_shob, co_statio_comm_cin_surf, tab_surface, dm_constr_dates, dm_total, dm_partiel, dm_projet_desc, dm_tot_log_nb, tax_surf_tot, tax_surf, tax_surf_suppr_mod, tab_tax_su_princ, tab_tax_su_heber, tab_tax_su_secon, tab_tax_su_tot, tax_ext_pret, tax_ext_desc, tax_surf_tax_exist_cons, tax_log_exist_nb, tax_trx_presc_ppr, tax_monu_hist, tax_comm_nb, tab_tax_su_non_habit_surf, tab_tax_am, vsd_surf_planch_smd, vsd_unit_fonc_sup, vsd_unit_fonc_constr_sup, vsd_val_terr, vsd_const_sxist_non_dem_surf, vsd_rescr_fisc, pld_val_terr, pld_const_exist_dem, pld_const_exist_dem_surf, code_cnil, terr_juri_titul, terr_juri_lot, terr_juri_zac, terr_juri_afu, terr_juri_pup, terr_juri_oin, terr_juri_desc, terr_div_surf_etab, terr_div_surf_av_div, doc_date, doc_tot_trav, doc_tranche_trav, doc_tranche_trav_desc, doc_surf, doc_nb_log, doc_nb_log_indiv, doc_nb_log_coll, doc_nb_log_lls, doc_nb_log_aa, doc_nb_log_ptz, doc_nb_log_autre, daact_date, daact_date_chgmt_dest, daact_tot_trav, daact_tranche_trav, daact_tranche_trav_desc, daact_surf, daact_nb_log, daact_nb_log_indiv, daact_nb_log_coll, daact_nb_log_lls, daact_nb_log_aa, daact_nb_log_ptz, daact_nb_log_autre, am_div_mun, co_perf_energ, architecte, co_statio_avt_shob, co_statio_apr_shob, co_statio_avt_surf, co_statio_apr_surf, co_trx_amgt, co_modif_aspect, co_modif_struct, co_ouvr_elec, co_ouvr_infra, co_trx_imm, co_cstr_shob, am_voyage_deb, am_voyage_fin, am_modif_amgt, am_lot_max_shob, mod_desc, tr_total, tr_partiel, tr_desc, avap_co_elt_pro, avap_nouv_haut_surf, avap_co_clot, avap_aut_coup_aba_arb, avap_ouv_infra, avap_aut_inst_mob, avap_aut_plant, avap_aut_auv_elec, tax_dest_loc_tr, ope_proj_desc, tax_surf_tot_cstr, tax_surf_loc_stat, tax_log_ap_trvx_nb, tax_am_statio_ext_cr, tax_sup_bass_pisc_cr, tax_empl_ten_carav_mobil_nb_cr, tax_empl_hll_nb_cr, tax_eol_haut_nb_cr, tax_pann_volt_sup_cr, tax_surf_loc_arch, tax_surf_pisc_arch, tax_am_statio_ext_arch, tab_tax_su_parc_statio_expl_comm, tax_empl_ten_carav_mobil_nb_arch, tax_empl_hll_nb_arch, tax_eol_haut_nb_arch, ope_proj_div_co, ope_proj_div_contr, tax_desc, erp_cstr_neuve, erp_trvx_acc, erp_extension, erp_rehab, erp_trvx_am, erp_vol_nouv_exist, tab_erp_eff, erp_class_cat, erp_class_type, tax_surf_abr_jard_pig_colom, tax_su_non_habit_abr_jard_pig_colom, dia_imm_non_bati, dia_imm_bati_terr_propr, dia_imm_bati_terr_autr, dia_imm_bati_terr_autr_desc, dia_bat_copro, dia_bat_copro_desc, dia_lot_numero, dia_lot_bat, dia_lot_etage, dia_lot_quote_part, dia_us_hab, dia_us_pro, dia_us_mixte, dia_us_comm, dia_us_agr, dia_us_autre, dia_us_autre_prec, dia_occ_prop, dia_occ_loc, dia_occ_sans_occ, dia_occ_autre, dia_occ_autre_prec, dia_mod_cess_prix_vente, dia_mod_cess_prix_vente_mob, dia_mod_cess_prix_vente_cheptel, dia_mod_cess_prix_vente_recol, dia_mod_cess_prix_vente_autre, dia_mod_cess_commi, dia_mod_cess_commi_ttc, dia_mod_cess_commi_ht, dia_acquereur_nom_prenom, dia_acquereur_adr_num_voie, dia_acquereur_adr_ext, dia_acquereur_adr_type_voie, dia_acquereur_adr_nom_voie, dia_acquereur_adr_lieu_dit_bp, dia_acquereur_adr_cp, dia_acquereur_adr_localite, dia_observation, tab_surface2, dia_occ_sol_su_terre, dia_occ_sol_su_pres, dia_occ_sol_su_verger, dia_occ_sol_su_vigne, dia_occ_sol_su_bois, dia_occ_sol_su_lande, dia_occ_sol_su_carriere, dia_occ_sol_su_eau_cadastree, dia_occ_sol_su_jardin, dia_occ_sol_su_terr_batir, dia_occ_sol_su_terr_agr, dia_occ_sol_su_sol, dia_bati_vend_tot, dia_bati_vend_tot_txt, dia_su_co_sol, dia_su_util_hab, dia_nb_niv, dia_nb_appart, dia_nb_autre_loc, dia_vente_lot_volume, dia_vente_lot_volume_txt, dia_lot_nat_su, dia_lot_bat_achv_plus_10, dia_lot_bat_achv_moins_10, dia_lot_regl_copro_publ_hypo_plus_10, dia_lot_regl_copro_publ_hypo_moins_10, dia_indivi_quote_part, dia_design_societe, dia_design_droit, dia_droit_soc_nat, dia_droit_soc_nb, dia_droit_soc_num_part, dia_droit_reel_perso_grevant_bien_oui, dia_droit_reel_perso_grevant_bien_non, dia_droit_reel_perso_nat, dia_droit_reel_perso_viag, dia_mod_cess_adr, dia_mod_cess_sign_act_auth, dia_mod_cess_terme, dia_mod_cess_terme_prec, dia_mod_cess_bene_acquereur, dia_mod_cess_bene_vendeur, dia_mod_cess_paie_nat, dia_mod_cess_design_contr_alien, dia_mod_cess_eval_contr, dia_mod_cess_rente_viag, dia_mod_cess_mnt_an, dia_mod_cess_mnt_compt, dia_mod_cess_bene_rente, dia_mod_cess_droit_usa_hab, dia_mod_cess_droit_usa_hab_prec, dia_mod_cess_eval_usa_usufruit, dia_mod_cess_vente_nue_prop, dia_mod_cess_vente_nue_prop_prec, dia_mod_cess_echange, dia_mod_cess_design_bien_recus_ech, dia_mod_cess_mnt_soulte, dia_mod_cess_prop_contre_echan, dia_mod_cess_apport_societe, dia_mod_cess_bene, dia_mod_cess_esti_bien, dia_mod_cess_cess_terr_loc_co, dia_mod_cess_esti_terr, dia_mod_cess_esti_loc, dia_mod_cess_esti_imm_loca, dia_mod_cess_adju_vol, dia_mod_cess_adju_obl, dia_mod_cess_adju_fin_indivi, dia_mod_cess_adju_date_lieu, dia_mod_cess_mnt_mise_prix, dia_prop_titu_prix_indique, dia_prop_recherche_acqu_prix_indique, dia_acquereur_prof, dia_indic_compl_ope, dia_vente_adju, am_terr_res_demon, am_air_terr_res_mob, ctx_objet_recours, ctx_moyen_souleve, ctx_moyen_retenu_juge, ctx_reference_sagace, ctx_nature_travaux_infra_om_html, ctx_synthese_nti, ctx_article_non_resp_om_html, ctx_synthese_anr, ctx_reference_parquet, ctx_element_taxation, ctx_infraction, ctx_regularisable, ctx_reference_courrier, ctx_date_audience, ctx_date_ajournement, exo_facul_1, exo_facul_2, exo_facul_3, exo_facul_4, exo_facul_5, exo_facul_6, exo_facul_7, exo_facul_8, exo_facul_9, exo_ta_1, exo_ta_2, exo_ta_3, exo_ta_4, exo_ta_5, exo_ta_6, exo_ta_7, exo_ta_8, exo_ta_9, exo_rap_1, exo_rap_2, exo_rap_3, exo_rap_4, exo_rap_5, exo_rap_6, exo_rap_7, exo_rap_8, mtn_exo_ta_part_commu, mtn_exo_ta_part_depart, mtn_exo_ta_part_reg, mtn_exo_rap, dpc_type, dpc_desc_actv_ex, dpc_desc_ca, dpc_desc_aut_prec, dpc_desig_comm_arti, dpc_desig_loc_hab, dpc_desig_loc_ann, dpc_desig_loc_ann_prec, dpc_bail_comm_date, dpc_bail_comm_loyer, dpc_actv_acqu, dpc_nb_sala_di, dpc_nb_sala_dd, dpc_nb_sala_tc, dpc_nb_sala_tp, dpc_moda_cess_vente_am, dpc_moda_cess_adj, dpc_moda_cess_prix, dpc_moda_cess_adj_date, dpc_moda_cess_adj_prec, dpc_moda_cess_paie_comp, dpc_moda_cess_paie_terme, dpc_moda_cess_paie_terme_prec, dpc_moda_cess_paie_nat, dpc_moda_cess_paie_nat_desig_alien, dpc_moda_cess_paie_nat_desig_alien_prec, dpc_moda_cess_paie_nat_eval, dpc_moda_cess_paie_nat_eval_prec, dpc_moda_cess_paie_aut, dpc_moda_cess_paie_aut_prec, dpc_ss_signe_demande_acqu, dpc_ss_signe_recher_trouv_acqu, dpc_notif_adr_prop, dpc_notif_adr_manda, dpc_obs, co_peri_site_patri_remar, co_abo_monu_hist, co_inst_ouvr_trav_act_code_envir, co_trav_auto_env, co_derog_esp_prot, ctx_reference_dsj, co_piscine, co_fin_lls, co_fin_aa, co_fin_ptz, co_fin_autr, dia_ss_date, dia_ss_lieu, enga_decla_lieu, enga_decla_date, co_archi_attest_honneur, co_bat_niv_dessous_nb, co_install_classe, co_derog_innov, co_avis_abf, tax_surf_tot_demo, tax_surf_tax_demo, tax_terrassement_arch, tax_adresse_future_numero, tax_adresse_future_voie, tax_adresse_future_lieudit, tax_adresse_future_localite, tax_adresse_future_cp, tax_adresse_future_bp, tax_adresse_future_cedex, tax_adresse_future_pays, tax_adresse_future_division, co_bat_projete, co_bat_existant, co_bat_nature, terr_juri_titul_date, co_autre_desc, co_trx_autre, co_autre, erp_modif_facades, erp_trvx_adap, erp_trvx_adap_numero, erp_trvx_adap_valid, erp_prod_dangereux, co_trav_supp_dessus, co_trav_supp_dessous, tax_su_habit_abr_jard_pig_colom, enga_decla_donnees_nomi_comm) VALUES (9, 'cerfa de test n°8', '123456', '2013-01-01', '2018-11-27', true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 13409, true, true, true, true, true, true, true, true, 1340903, 1340903, 1340903, 1340903, true, true, true, true, true, true, true, 1340903, 13409, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 1340903, true, true, true, true, true, true, true, true, true, true, true, true, 1382403, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 1340905, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false);
INSERT INTO cerfa (cerfa, libelle, code, om_validite_debut, om_validite_fin, am_lotiss, am_autre_div, am_camping, am_caravane, am_carav_duree, am_statio, am_statio_cont, am_affou_exhau, am_affou_exhau_sup, am_affou_prof, am_exhau_haut, am_coupe_abat, am_prot_plu, am_prot_muni, am_mobil_voyage, am_aire_voyage, am_rememb_afu, am_parc_resid_loi, am_sport_moto, am_sport_attrac, am_sport_golf, am_mob_art, am_modif_voie_esp, am_plant_voie_esp, am_chem_ouv_esp, am_agri_peche, am_crea_voie, am_modif_voie_exist, am_crea_esp_sauv, am_crea_esp_class, am_projet_desc, am_terr_surf, am_tranche_desc, am_lot_max_nb, am_lot_max_shon, am_lot_cstr_cos, am_lot_cstr_plan, am_lot_cstr_vente, am_lot_fin_diff, am_lot_consign, am_lot_gar_achev, am_lot_vente_ant, am_empl_nb, am_tente_nb, am_carav_nb, am_mobil_nb, am_pers_nb, am_empl_hll_nb, am_hll_shon, am_periode_exploit, am_exist_agrand, am_exist_date, am_exist_num, am_exist_nb_avant, am_exist_nb_apres, am_coupe_bois, am_coupe_parc, am_coupe_align, am_coupe_ess, am_coupe_age, am_coupe_dens, am_coupe_qual, am_coupe_trait, am_coupe_autr, co_archi_recours, co_cstr_nouv, co_cstr_exist, co_cloture, co_elec_tension, co_div_terr, co_projet_desc, co_anx_pisc, co_anx_gara, co_anx_veran, co_anx_abri, co_anx_autr, co_anx_autr_desc, co_tot_log_nb, co_tot_ind_nb, co_tot_coll_nb, co_mais_piece_nb, co_mais_niv_nb, co_fin_lls_nb, co_fin_aa_nb, co_fin_ptz_nb, co_fin_autr_nb, co_fin_autr_desc, co_mais_contrat_ind, co_uti_pers, co_uti_vente, co_uti_loc, co_uti_princ, co_uti_secon, co_resid_agees, co_resid_etud, co_resid_tourism, co_resid_hot_soc, co_resid_soc, co_resid_hand, co_resid_autr, co_resid_autr_desc, co_foyer_chamb_nb, co_log_1p_nb, co_log_2p_nb, co_log_3p_nb, co_log_4p_nb, co_log_5p_nb, co_log_6p_nb, co_bat_niv_nb, co_trx_exten, co_trx_surelev, co_trx_nivsup, co_demont_periode, co_sp_transport, co_sp_enseign, co_sp_act_soc, co_sp_ouvr_spe, co_sp_sante, co_sp_culture, co_statio_avt_nb, co_statio_apr_nb, co_statio_adr, co_statio_place_nb, co_statio_tot_surf, co_statio_tot_shob, co_statio_comm_cin_surf, tab_surface, dm_constr_dates, dm_total, dm_partiel, dm_projet_desc, dm_tot_log_nb, tax_surf_tot, tax_surf, tax_surf_suppr_mod, tab_tax_su_princ, tab_tax_su_heber, tab_tax_su_secon, tab_tax_su_tot, tax_ext_pret, tax_ext_desc, tax_surf_tax_exist_cons, tax_log_exist_nb, tax_trx_presc_ppr, tax_monu_hist, tax_comm_nb, tab_tax_su_non_habit_surf, tab_tax_am, vsd_surf_planch_smd, vsd_unit_fonc_sup, vsd_unit_fonc_constr_sup, vsd_val_terr, vsd_const_sxist_non_dem_surf, vsd_rescr_fisc, pld_val_terr, pld_const_exist_dem, pld_const_exist_dem_surf, code_cnil, terr_juri_titul, terr_juri_lot, terr_juri_zac, terr_juri_afu, terr_juri_pup, terr_juri_oin, terr_juri_desc, terr_div_surf_etab, terr_div_surf_av_div, doc_date, doc_tot_trav, doc_tranche_trav, doc_tranche_trav_desc, doc_surf, doc_nb_log, doc_nb_log_indiv, doc_nb_log_coll, doc_nb_log_lls, doc_nb_log_aa, doc_nb_log_ptz, doc_nb_log_autre, daact_date, daact_date_chgmt_dest, daact_tot_trav, daact_tranche_trav, daact_tranche_trav_desc, daact_surf, daact_nb_log, daact_nb_log_indiv, daact_nb_log_coll, daact_nb_log_lls, daact_nb_log_aa, daact_nb_log_ptz, daact_nb_log_autre, am_div_mun, co_perf_energ, architecte, co_statio_avt_shob, co_statio_apr_shob, co_statio_avt_surf, co_statio_apr_surf, co_trx_amgt, co_modif_aspect, co_modif_struct, co_ouvr_elec, co_ouvr_infra, co_trx_imm, co_cstr_shob, am_voyage_deb, am_voyage_fin, am_modif_amgt, am_lot_max_shob, mod_desc, tr_total, tr_partiel, tr_desc, avap_co_elt_pro, avap_nouv_haut_surf, avap_co_clot, avap_aut_coup_aba_arb, avap_ouv_infra, avap_aut_inst_mob, avap_aut_plant, avap_aut_auv_elec, tax_dest_loc_tr, ope_proj_desc, tax_surf_tot_cstr, tax_surf_loc_stat, tax_log_ap_trvx_nb, tax_am_statio_ext_cr, tax_sup_bass_pisc_cr, tax_empl_ten_carav_mobil_nb_cr, tax_empl_hll_nb_cr, tax_eol_haut_nb_cr, tax_pann_volt_sup_cr, tax_surf_loc_arch, tax_surf_pisc_arch, tax_am_statio_ext_arch, tab_tax_su_parc_statio_expl_comm, tax_empl_ten_carav_mobil_nb_arch, tax_empl_hll_nb_arch, tax_eol_haut_nb_arch, ope_proj_div_co, ope_proj_div_contr, tax_desc, erp_cstr_neuve, erp_trvx_acc, erp_extension, erp_rehab, erp_trvx_am, erp_vol_nouv_exist, tab_erp_eff, erp_class_cat, erp_class_type, tax_surf_abr_jard_pig_colom, tax_su_non_habit_abr_jard_pig_colom, dia_imm_non_bati, dia_imm_bati_terr_propr, dia_imm_bati_terr_autr, dia_imm_bati_terr_autr_desc, dia_bat_copro, dia_bat_copro_desc, dia_lot_numero, dia_lot_bat, dia_lot_etage, dia_lot_quote_part, dia_us_hab, dia_us_pro, dia_us_mixte, dia_us_comm, dia_us_agr, dia_us_autre, dia_us_autre_prec, dia_occ_prop, dia_occ_loc, dia_occ_sans_occ, dia_occ_autre, dia_occ_autre_prec, dia_mod_cess_prix_vente, dia_mod_cess_prix_vente_mob, dia_mod_cess_prix_vente_cheptel, dia_mod_cess_prix_vente_recol, dia_mod_cess_prix_vente_autre, dia_mod_cess_commi, dia_mod_cess_commi_ttc, dia_mod_cess_commi_ht, dia_acquereur_nom_prenom, dia_acquereur_adr_num_voie, dia_acquereur_adr_ext, dia_acquereur_adr_type_voie, dia_acquereur_adr_nom_voie, dia_acquereur_adr_lieu_dit_bp, dia_acquereur_adr_cp, dia_acquereur_adr_localite, dia_observation, tab_surface2, dia_occ_sol_su_terre, dia_occ_sol_su_pres, dia_occ_sol_su_verger, dia_occ_sol_su_vigne, dia_occ_sol_su_bois, dia_occ_sol_su_lande, dia_occ_sol_su_carriere, dia_occ_sol_su_eau_cadastree, dia_occ_sol_su_jardin, dia_occ_sol_su_terr_batir, dia_occ_sol_su_terr_agr, dia_occ_sol_su_sol, dia_bati_vend_tot, dia_bati_vend_tot_txt, dia_su_co_sol, dia_su_util_hab, dia_nb_niv, dia_nb_appart, dia_nb_autre_loc, dia_vente_lot_volume, dia_vente_lot_volume_txt, dia_lot_nat_su, dia_lot_bat_achv_plus_10, dia_lot_bat_achv_moins_10, dia_lot_regl_copro_publ_hypo_plus_10, dia_lot_regl_copro_publ_hypo_moins_10, dia_indivi_quote_part, dia_design_societe, dia_design_droit, dia_droit_soc_nat, dia_droit_soc_nb, dia_droit_soc_num_part, dia_droit_reel_perso_grevant_bien_oui, dia_droit_reel_perso_grevant_bien_non, dia_droit_reel_perso_nat, dia_droit_reel_perso_viag, dia_mod_cess_adr, dia_mod_cess_sign_act_auth, dia_mod_cess_terme, dia_mod_cess_terme_prec, dia_mod_cess_bene_acquereur, dia_mod_cess_bene_vendeur, dia_mod_cess_paie_nat, dia_mod_cess_design_contr_alien, dia_mod_cess_eval_contr, dia_mod_cess_rente_viag, dia_mod_cess_mnt_an, dia_mod_cess_mnt_compt, dia_mod_cess_bene_rente, dia_mod_cess_droit_usa_hab, dia_mod_cess_droit_usa_hab_prec, dia_mod_cess_eval_usa_usufruit, dia_mod_cess_vente_nue_prop, dia_mod_cess_vente_nue_prop_prec, dia_mod_cess_echange, dia_mod_cess_design_bien_recus_ech, dia_mod_cess_mnt_soulte, dia_mod_cess_prop_contre_echan, dia_mod_cess_apport_societe, dia_mod_cess_bene, dia_mod_cess_esti_bien, dia_mod_cess_cess_terr_loc_co, dia_mod_cess_esti_terr, dia_mod_cess_esti_loc, dia_mod_cess_esti_imm_loca, dia_mod_cess_adju_vol, dia_mod_cess_adju_obl, dia_mod_cess_adju_fin_indivi, dia_mod_cess_adju_date_lieu, dia_mod_cess_mnt_mise_prix, dia_prop_titu_prix_indique, dia_prop_recherche_acqu_prix_indique, dia_acquereur_prof, dia_indic_compl_ope, dia_vente_adju, am_terr_res_demon, am_air_terr_res_mob, ctx_objet_recours, ctx_moyen_souleve, ctx_moyen_retenu_juge, ctx_reference_sagace, ctx_nature_travaux_infra_om_html, ctx_synthese_nti, ctx_article_non_resp_om_html, ctx_synthese_anr, ctx_reference_parquet, ctx_element_taxation, ctx_infraction, ctx_regularisable, ctx_reference_courrier, ctx_date_audience, ctx_date_ajournement, exo_facul_1, exo_facul_2, exo_facul_3, exo_facul_4, exo_facul_5, exo_facul_6, exo_facul_7, exo_facul_8, exo_facul_9, exo_ta_1, exo_ta_2, exo_ta_3, exo_ta_4, exo_ta_5, exo_ta_6, exo_ta_7, exo_ta_8, exo_ta_9, exo_rap_1, exo_rap_2, exo_rap_3, exo_rap_4, exo_rap_5, exo_rap_6, exo_rap_7, exo_rap_8, mtn_exo_ta_part_commu, mtn_exo_ta_part_depart, mtn_exo_ta_part_reg, mtn_exo_rap, dpc_type, dpc_desc_actv_ex, dpc_desc_ca, dpc_desc_aut_prec, dpc_desig_comm_arti, dpc_desig_loc_hab, dpc_desig_loc_ann, dpc_desig_loc_ann_prec, dpc_bail_comm_date, dpc_bail_comm_loyer, dpc_actv_acqu, dpc_nb_sala_di, dpc_nb_sala_dd, dpc_nb_sala_tc, dpc_nb_sala_tp, dpc_moda_cess_vente_am, dpc_moda_cess_adj, dpc_moda_cess_prix, dpc_moda_cess_adj_date, dpc_moda_cess_adj_prec, dpc_moda_cess_paie_comp, dpc_moda_cess_paie_terme, dpc_moda_cess_paie_terme_prec, dpc_moda_cess_paie_nat, dpc_moda_cess_paie_nat_desig_alien, dpc_moda_cess_paie_nat_desig_alien_prec, dpc_moda_cess_paie_nat_eval, dpc_moda_cess_paie_nat_eval_prec, dpc_moda_cess_paie_aut, dpc_moda_cess_paie_aut_prec, dpc_ss_signe_demande_acqu, dpc_ss_signe_recher_trouv_acqu, dpc_notif_adr_prop, dpc_notif_adr_manda, dpc_obs, co_peri_site_patri_remar, co_abo_monu_hist, co_inst_ouvr_trav_act_code_envir, co_trav_auto_env, co_derog_esp_prot, ctx_reference_dsj, co_piscine, co_fin_lls, co_fin_aa, co_fin_ptz, co_fin_autr, dia_ss_date, dia_ss_lieu, enga_decla_lieu, enga_decla_date, co_archi_attest_honneur, co_bat_niv_dessous_nb, co_install_classe, co_derog_innov, co_avis_abf, tax_surf_tot_demo, tax_surf_tax_demo, tax_terrassement_arch, tax_adresse_future_numero, tax_adresse_future_voie, tax_adresse_future_lieudit, tax_adresse_future_localite, tax_adresse_future_cp, tax_adresse_future_bp, tax_adresse_future_cedex, tax_adresse_future_pays, tax_adresse_future_division, co_bat_projete, co_bat_existant, co_bat_nature, terr_juri_titul_date, co_autre_desc, co_trx_autre, co_autre, erp_modif_facades, erp_trvx_adap, erp_trvx_adap_numero, erp_trvx_adap_valid, erp_prod_dangereux, co_trav_supp_dessus, co_trav_supp_dessous, tax_su_habit_abr_jard_pig_colom, enga_decla_donnees_nomi_comm) VALUES (2, 'cerfa de test lot n°1', '123456', '2013-02-01', '2099-12-31', false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, 13409, false, false, false, false, false, false, false, false, NULL, NULL, NULL, NULL, false, false, false, false, false, false, false, NULL, NULL, false, false, false, false, false, false, false, false, false, false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, NULL, false, false, false, false, false, false, false, false, false, false, false, false, NULL, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, NULL, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false);
INSERT INTO cerfa (cerfa, libelle, code, om_validite_debut, om_validite_fin, am_lotiss, am_autre_div, am_camping, am_caravane, am_carav_duree, am_statio, am_statio_cont, am_affou_exhau, am_affou_exhau_sup, am_affou_prof, am_exhau_haut, am_coupe_abat, am_prot_plu, am_prot_muni, am_mobil_voyage, am_aire_voyage, am_rememb_afu, am_parc_resid_loi, am_sport_moto, am_sport_attrac, am_sport_golf, am_mob_art, am_modif_voie_esp, am_plant_voie_esp, am_chem_ouv_esp, am_agri_peche, am_crea_voie, am_modif_voie_exist, am_crea_esp_sauv, am_crea_esp_class, am_projet_desc, am_terr_surf, am_tranche_desc, am_lot_max_nb, am_lot_max_shon, am_lot_cstr_cos, am_lot_cstr_plan, am_lot_cstr_vente, am_lot_fin_diff, am_lot_consign, am_lot_gar_achev, am_lot_vente_ant, am_empl_nb, am_tente_nb, am_carav_nb, am_mobil_nb, am_pers_nb, am_empl_hll_nb, am_hll_shon, am_periode_exploit, am_exist_agrand, am_exist_date, am_exist_num, am_exist_nb_avant, am_exist_nb_apres, am_coupe_bois, am_coupe_parc, am_coupe_align, am_coupe_ess, am_coupe_age, am_coupe_dens, am_coupe_qual, am_coupe_trait, am_coupe_autr, co_archi_recours, co_cstr_nouv, co_cstr_exist, co_cloture, co_elec_tension, co_div_terr, co_projet_desc, co_anx_pisc, co_anx_gara, co_anx_veran, co_anx_abri, co_anx_autr, co_anx_autr_desc, co_tot_log_nb, co_tot_ind_nb, co_tot_coll_nb, co_mais_piece_nb, co_mais_niv_nb, co_fin_lls_nb, co_fin_aa_nb, co_fin_ptz_nb, co_fin_autr_nb, co_fin_autr_desc, co_mais_contrat_ind, co_uti_pers, co_uti_vente, co_uti_loc, co_uti_princ, co_uti_secon, co_resid_agees, co_resid_etud, co_resid_tourism, co_resid_hot_soc, co_resid_soc, co_resid_hand, co_resid_autr, co_resid_autr_desc, co_foyer_chamb_nb, co_log_1p_nb, co_log_2p_nb, co_log_3p_nb, co_log_4p_nb, co_log_5p_nb, co_log_6p_nb, co_bat_niv_nb, co_trx_exten, co_trx_surelev, co_trx_nivsup, co_demont_periode, co_sp_transport, co_sp_enseign, co_sp_act_soc, co_sp_ouvr_spe, co_sp_sante, co_sp_culture, co_statio_avt_nb, co_statio_apr_nb, co_statio_adr, co_statio_place_nb, co_statio_tot_surf, co_statio_tot_shob, co_statio_comm_cin_surf, tab_surface, dm_constr_dates, dm_total, dm_partiel, dm_projet_desc, dm_tot_log_nb, tax_surf_tot, tax_surf, tax_surf_suppr_mod, tab_tax_su_princ, tab_tax_su_heber, tab_tax_su_secon, tab_tax_su_tot, tax_ext_pret, tax_ext_desc, tax_surf_tax_exist_cons, tax_log_exist_nb, tax_trx_presc_ppr, tax_monu_hist, tax_comm_nb, tab_tax_su_non_habit_surf, tab_tax_am, vsd_surf_planch_smd, vsd_unit_fonc_sup, vsd_unit_fonc_constr_sup, vsd_val_terr, vsd_const_sxist_non_dem_surf, vsd_rescr_fisc, pld_val_terr, pld_const_exist_dem, pld_const_exist_dem_surf, code_cnil, terr_juri_titul, terr_juri_lot, terr_juri_zac, terr_juri_afu, terr_juri_pup, terr_juri_oin, terr_juri_desc, terr_div_surf_etab, terr_div_surf_av_div, doc_date, doc_tot_trav, doc_tranche_trav, doc_tranche_trav_desc, doc_surf, doc_nb_log, doc_nb_log_indiv, doc_nb_log_coll, doc_nb_log_lls, doc_nb_log_aa, doc_nb_log_ptz, doc_nb_log_autre, daact_date, daact_date_chgmt_dest, daact_tot_trav, daact_tranche_trav, daact_tranche_trav_desc, daact_surf, daact_nb_log, daact_nb_log_indiv, daact_nb_log_coll, daact_nb_log_lls, daact_nb_log_aa, daact_nb_log_ptz, daact_nb_log_autre, am_div_mun, co_perf_energ, architecte, co_statio_avt_shob, co_statio_apr_shob, co_statio_avt_surf, co_statio_apr_surf, co_trx_amgt, co_modif_aspect, co_modif_struct, co_ouvr_elec, co_ouvr_infra, co_trx_imm, co_cstr_shob, am_voyage_deb, am_voyage_fin, am_modif_amgt, am_lot_max_shob, mod_desc, tr_total, tr_partiel, tr_desc, avap_co_elt_pro, avap_nouv_haut_surf, avap_co_clot, avap_aut_coup_aba_arb, avap_ouv_infra, avap_aut_inst_mob, avap_aut_plant, avap_aut_auv_elec, tax_dest_loc_tr, ope_proj_desc, tax_surf_tot_cstr, tax_surf_loc_stat, tax_log_ap_trvx_nb, tax_am_statio_ext_cr, tax_sup_bass_pisc_cr, tax_empl_ten_carav_mobil_nb_cr, tax_empl_hll_nb_cr, tax_eol_haut_nb_cr, tax_pann_volt_sup_cr, tax_surf_loc_arch, tax_surf_pisc_arch, tax_am_statio_ext_arch, tab_tax_su_parc_statio_expl_comm, tax_empl_ten_carav_mobil_nb_arch, tax_empl_hll_nb_arch, tax_eol_haut_nb_arch, ope_proj_div_co, ope_proj_div_contr, tax_desc, erp_cstr_neuve, erp_trvx_acc, erp_extension, erp_rehab, erp_trvx_am, erp_vol_nouv_exist, tab_erp_eff, erp_class_cat, erp_class_type, tax_surf_abr_jard_pig_colom, tax_su_non_habit_abr_jard_pig_colom, dia_imm_non_bati, dia_imm_bati_terr_propr, dia_imm_bati_terr_autr, dia_imm_bati_terr_autr_desc, dia_bat_copro, dia_bat_copro_desc, dia_lot_numero, dia_lot_bat, dia_lot_etage, dia_lot_quote_part, dia_us_hab, dia_us_pro, dia_us_mixte, dia_us_comm, dia_us_agr, dia_us_autre, dia_us_autre_prec, dia_occ_prop, dia_occ_loc, dia_occ_sans_occ, dia_occ_autre, dia_occ_autre_prec, dia_mod_cess_prix_vente, dia_mod_cess_prix_vente_mob, dia_mod_cess_prix_vente_cheptel, dia_mod_cess_prix_vente_recol, dia_mod_cess_prix_vente_autre, dia_mod_cess_commi, dia_mod_cess_commi_ttc, dia_mod_cess_commi_ht, dia_acquereur_nom_prenom, dia_acquereur_adr_num_voie, dia_acquereur_adr_ext, dia_acquereur_adr_type_voie, dia_acquereur_adr_nom_voie, dia_acquereur_adr_lieu_dit_bp, dia_acquereur_adr_cp, dia_acquereur_adr_localite, dia_observation, tab_surface2, dia_occ_sol_su_terre, dia_occ_sol_su_pres, dia_occ_sol_su_verger, dia_occ_sol_su_vigne, dia_occ_sol_su_bois, dia_occ_sol_su_lande, dia_occ_sol_su_carriere, dia_occ_sol_su_eau_cadastree, dia_occ_sol_su_jardin, dia_occ_sol_su_terr_batir, dia_occ_sol_su_terr_agr, dia_occ_sol_su_sol, dia_bati_vend_tot, dia_bati_vend_tot_txt, dia_su_co_sol, dia_su_util_hab, dia_nb_niv, dia_nb_appart, dia_nb_autre_loc, dia_vente_lot_volume, dia_vente_lot_volume_txt, dia_lot_nat_su, dia_lot_bat_achv_plus_10, dia_lot_bat_achv_moins_10, dia_lot_regl_copro_publ_hypo_plus_10, dia_lot_regl_copro_publ_hypo_moins_10, dia_indivi_quote_part, dia_design_societe, dia_design_droit, dia_droit_soc_nat, dia_droit_soc_nb, dia_droit_soc_num_part, dia_droit_reel_perso_grevant_bien_oui, dia_droit_reel_perso_grevant_bien_non, dia_droit_reel_perso_nat, dia_droit_reel_perso_viag, dia_mod_cess_adr, dia_mod_cess_sign_act_auth, dia_mod_cess_terme, dia_mod_cess_terme_prec, dia_mod_cess_bene_acquereur, dia_mod_cess_bene_vendeur, dia_mod_cess_paie_nat, dia_mod_cess_design_contr_alien, dia_mod_cess_eval_contr, dia_mod_cess_rente_viag, dia_mod_cess_mnt_an, dia_mod_cess_mnt_compt, dia_mod_cess_bene_rente, dia_mod_cess_droit_usa_hab, dia_mod_cess_droit_usa_hab_prec, dia_mod_cess_eval_usa_usufruit, dia_mod_cess_vente_nue_prop, dia_mod_cess_vente_nue_prop_prec, dia_mod_cess_echange, dia_mod_cess_design_bien_recus_ech, dia_mod_cess_mnt_soulte, dia_mod_cess_prop_contre_echan, dia_mod_cess_apport_societe, dia_mod_cess_bene, dia_mod_cess_esti_bien, dia_mod_cess_cess_terr_loc_co, dia_mod_cess_esti_terr, dia_mod_cess_esti_loc, dia_mod_cess_esti_imm_loca, dia_mod_cess_adju_vol, dia_mod_cess_adju_obl, dia_mod_cess_adju_fin_indivi, dia_mod_cess_adju_date_lieu, dia_mod_cess_mnt_mise_prix, dia_prop_titu_prix_indique, dia_prop_recherche_acqu_prix_indique, dia_acquereur_prof, dia_indic_compl_ope, dia_vente_adju, am_terr_res_demon, am_air_terr_res_mob, ctx_objet_recours, ctx_moyen_souleve, ctx_moyen_retenu_juge, ctx_reference_sagace, ctx_nature_travaux_infra_om_html, ctx_synthese_nti, ctx_article_non_resp_om_html, ctx_synthese_anr, ctx_reference_parquet, ctx_element_taxation, ctx_infraction, ctx_regularisable, ctx_reference_courrier, ctx_date_audience, ctx_date_ajournement, exo_facul_1, exo_facul_2, exo_facul_3, exo_facul_4, exo_facul_5, exo_facul_6, exo_facul_7, exo_facul_8, exo_facul_9, exo_ta_1, exo_ta_2, exo_ta_3, exo_ta_4, exo_ta_5, exo_ta_6, exo_ta_7, exo_ta_8, exo_ta_9, exo_rap_1, exo_rap_2, exo_rap_3, exo_rap_4, exo_rap_5, exo_rap_6, exo_rap_7, exo_rap_8, mtn_exo_ta_part_commu, mtn_exo_ta_part_depart, mtn_exo_ta_part_reg, mtn_exo_rap, dpc_type, dpc_desc_actv_ex, dpc_desc_ca, dpc_desc_aut_prec, dpc_desig_comm_arti, dpc_desig_loc_hab, dpc_desig_loc_ann, dpc_desig_loc_ann_prec, dpc_bail_comm_date, dpc_bail_comm_loyer, dpc_actv_acqu, dpc_nb_sala_di, dpc_nb_sala_dd, dpc_nb_sala_tc, dpc_nb_sala_tp, dpc_moda_cess_vente_am, dpc_moda_cess_adj, dpc_moda_cess_prix, dpc_moda_cess_adj_date, dpc_moda_cess_adj_prec, dpc_moda_cess_paie_comp, dpc_moda_cess_paie_terme, dpc_moda_cess_paie_terme_prec, dpc_moda_cess_paie_nat, dpc_moda_cess_paie_nat_desig_alien, dpc_moda_cess_paie_nat_desig_alien_prec, dpc_moda_cess_paie_nat_eval, dpc_moda_cess_paie_nat_eval_prec, dpc_moda_cess_paie_aut, dpc_moda_cess_paie_aut_prec, dpc_ss_signe_demande_acqu, dpc_ss_signe_recher_trouv_acqu, dpc_notif_adr_prop, dpc_notif_adr_manda, dpc_obs, co_peri_site_patri_remar, co_abo_monu_hist, co_inst_ouvr_trav_act_code_envir, co_trav_auto_env, co_derog_esp_prot, ctx_reference_dsj, co_piscine, co_fin_lls, co_fin_aa, co_fin_ptz, co_fin_autr, dia_ss_date, dia_ss_lieu, enga_decla_lieu, enga_decla_date, co_archi_attest_honneur, co_bat_niv_dessous_nb, co_install_classe, co_derog_innov, co_avis_abf, tax_surf_tot_demo, tax_surf_tax_demo, tax_terrassement_arch, tax_adresse_future_numero, tax_adresse_future_voie, tax_adresse_future_lieudit, tax_adresse_future_localite, tax_adresse_future_cp, tax_adresse_future_bp, tax_adresse_future_cedex, tax_adresse_future_pays, tax_adresse_future_division, co_bat_projete, co_bat_existant, co_bat_nature, terr_juri_titul_date, co_autre_desc, co_trx_autre, co_autre, erp_modif_facades, erp_trvx_adap, erp_trvx_adap_numero, erp_trvx_adap_valid, erp_prod_dangereux, co_trav_supp_dessus, co_trav_supp_dessous, tax_su_habit_abr_jard_pig_colom, enga_decla_donnees_nomi_comm) VALUES (11, 'cerfa de test n°10', '123456', '2013-01-01', '2033-12-31', true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 13409, true, true, true, true, true, true, true, true, 1340903, 1340903, 1340903, 1340903, true, true, true, true, true, true, true, 1340907, 13409, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 1340903, true, true, true, true, true, true, true, true, true, true, true, true, 1382403, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 1340905, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true);
INSERT INTO cerfa (cerfa, libelle, code, om_validite_debut, om_validite_fin, am_lotiss, am_autre_div, am_camping, am_caravane, am_carav_duree, am_statio, am_statio_cont, am_affou_exhau, am_affou_exhau_sup, am_affou_prof, am_exhau_haut, am_coupe_abat, am_prot_plu, am_prot_muni, am_mobil_voyage, am_aire_voyage, am_rememb_afu, am_parc_resid_loi, am_sport_moto, am_sport_attrac, am_sport_golf, am_mob_art, am_modif_voie_esp, am_plant_voie_esp, am_chem_ouv_esp, am_agri_peche, am_crea_voie, am_modif_voie_exist, am_crea_esp_sauv, am_crea_esp_class, am_projet_desc, am_terr_surf, am_tranche_desc, am_lot_max_nb, am_lot_max_shon, am_lot_cstr_cos, am_lot_cstr_plan, am_lot_cstr_vente, am_lot_fin_diff, am_lot_consign, am_lot_gar_achev, am_lot_vente_ant, am_empl_nb, am_tente_nb, am_carav_nb, am_mobil_nb, am_pers_nb, am_empl_hll_nb, am_hll_shon, am_periode_exploit, am_exist_agrand, am_exist_date, am_exist_num, am_exist_nb_avant, am_exist_nb_apres, am_coupe_bois, am_coupe_parc, am_coupe_align, am_coupe_ess, am_coupe_age, am_coupe_dens, am_coupe_qual, am_coupe_trait, am_coupe_autr, co_archi_recours, co_cstr_nouv, co_cstr_exist, co_cloture, co_elec_tension, co_div_terr, co_projet_desc, co_anx_pisc, co_anx_gara, co_anx_veran, co_anx_abri, co_anx_autr, co_anx_autr_desc, co_tot_log_nb, co_tot_ind_nb, co_tot_coll_nb, co_mais_piece_nb, co_mais_niv_nb, co_fin_lls_nb, co_fin_aa_nb, co_fin_ptz_nb, co_fin_autr_nb, co_fin_autr_desc, co_mais_contrat_ind, co_uti_pers, co_uti_vente, co_uti_loc, co_uti_princ, co_uti_secon, co_resid_agees, co_resid_etud, co_resid_tourism, co_resid_hot_soc, co_resid_soc, co_resid_hand, co_resid_autr, co_resid_autr_desc, co_foyer_chamb_nb, co_log_1p_nb, co_log_2p_nb, co_log_3p_nb, co_log_4p_nb, co_log_5p_nb, co_log_6p_nb, co_bat_niv_nb, co_trx_exten, co_trx_surelev, co_trx_nivsup, co_demont_periode, co_sp_transport, co_sp_enseign, co_sp_act_soc, co_sp_ouvr_spe, co_sp_sante, co_sp_culture, co_statio_avt_nb, co_statio_apr_nb, co_statio_adr, co_statio_place_nb, co_statio_tot_surf, co_statio_tot_shob, co_statio_comm_cin_surf, tab_surface, dm_constr_dates, dm_total, dm_partiel, dm_projet_desc, dm_tot_log_nb, tax_surf_tot, tax_surf, tax_surf_suppr_mod, tab_tax_su_princ, tab_tax_su_heber, tab_tax_su_secon, tab_tax_su_tot, tax_ext_pret, tax_ext_desc, tax_surf_tax_exist_cons, tax_log_exist_nb, tax_trx_presc_ppr, tax_monu_hist, tax_comm_nb, tab_tax_su_non_habit_surf, tab_tax_am, vsd_surf_planch_smd, vsd_unit_fonc_sup, vsd_unit_fonc_constr_sup, vsd_val_terr, vsd_const_sxist_non_dem_surf, vsd_rescr_fisc, pld_val_terr, pld_const_exist_dem, pld_const_exist_dem_surf, code_cnil, terr_juri_titul, terr_juri_lot, terr_juri_zac, terr_juri_afu, terr_juri_pup, terr_juri_oin, terr_juri_desc, terr_div_surf_etab, terr_div_surf_av_div, doc_date, doc_tot_trav, doc_tranche_trav, doc_tranche_trav_desc, doc_surf, doc_nb_log, doc_nb_log_indiv, doc_nb_log_coll, doc_nb_log_lls, doc_nb_log_aa, doc_nb_log_ptz, doc_nb_log_autre, daact_date, daact_date_chgmt_dest, daact_tot_trav, daact_tranche_trav, daact_tranche_trav_desc, daact_surf, daact_nb_log, daact_nb_log_indiv, daact_nb_log_coll, daact_nb_log_lls, daact_nb_log_aa, daact_nb_log_ptz, daact_nb_log_autre, am_div_mun, co_perf_energ, architecte, co_statio_avt_shob, co_statio_apr_shob, co_statio_avt_surf, co_statio_apr_surf, co_trx_amgt, co_modif_aspect, co_modif_struct, co_ouvr_elec, co_ouvr_infra, co_trx_imm, co_cstr_shob, am_voyage_deb, am_voyage_fin, am_modif_amgt, am_lot_max_shob, mod_desc, tr_total, tr_partiel, tr_desc, avap_co_elt_pro, avap_nouv_haut_surf, avap_co_clot, avap_aut_coup_aba_arb, avap_ouv_infra, avap_aut_inst_mob, avap_aut_plant, avap_aut_auv_elec, tax_dest_loc_tr, ope_proj_desc, tax_surf_tot_cstr, tax_surf_loc_stat, tax_log_ap_trvx_nb, tax_am_statio_ext_cr, tax_sup_bass_pisc_cr, tax_empl_ten_carav_mobil_nb_cr, tax_empl_hll_nb_cr, tax_eol_haut_nb_cr, tax_pann_volt_sup_cr, tax_surf_loc_arch, tax_surf_pisc_arch, tax_am_statio_ext_arch, tab_tax_su_parc_statio_expl_comm, tax_empl_ten_carav_mobil_nb_arch, tax_empl_hll_nb_arch, tax_eol_haut_nb_arch, ope_proj_div_co, ope_proj_div_contr, tax_desc, erp_cstr_neuve, erp_trvx_acc, erp_extension, erp_rehab, erp_trvx_am, erp_vol_nouv_exist, tab_erp_eff, erp_class_cat, erp_class_type, tax_surf_abr_jard_pig_colom, tax_su_non_habit_abr_jard_pig_colom, dia_imm_non_bati, dia_imm_bati_terr_propr, dia_imm_bati_terr_autr, dia_imm_bati_terr_autr_desc, dia_bat_copro, dia_bat_copro_desc, dia_lot_numero, dia_lot_bat, dia_lot_etage, dia_lot_quote_part, dia_us_hab, dia_us_pro, dia_us_mixte, dia_us_comm, dia_us_agr, dia_us_autre, dia_us_autre_prec, dia_occ_prop, dia_occ_loc, dia_occ_sans_occ, dia_occ_autre, dia_occ_autre_prec, dia_mod_cess_prix_vente, dia_mod_cess_prix_vente_mob, dia_mod_cess_prix_vente_cheptel, dia_mod_cess_prix_vente_recol, dia_mod_cess_prix_vente_autre, dia_mod_cess_commi, dia_mod_cess_commi_ttc, dia_mod_cess_commi_ht, dia_acquereur_nom_prenom, dia_acquereur_adr_num_voie, dia_acquereur_adr_ext, dia_acquereur_adr_type_voie, dia_acquereur_adr_nom_voie, dia_acquereur_adr_lieu_dit_bp, dia_acquereur_adr_cp, dia_acquereur_adr_localite, dia_observation, tab_surface2, dia_occ_sol_su_terre, dia_occ_sol_su_pres, dia_occ_sol_su_verger, dia_occ_sol_su_vigne, dia_occ_sol_su_bois, dia_occ_sol_su_lande, dia_occ_sol_su_carriere, dia_occ_sol_su_eau_cadastree, dia_occ_sol_su_jardin, dia_occ_sol_su_terr_batir, dia_occ_sol_su_terr_agr, dia_occ_sol_su_sol, dia_bati_vend_tot, dia_bati_vend_tot_txt, dia_su_co_sol, dia_su_util_hab, dia_nb_niv, dia_nb_appart, dia_nb_autre_loc, dia_vente_lot_volume, dia_vente_lot_volume_txt, dia_lot_nat_su, dia_lot_bat_achv_plus_10, dia_lot_bat_achv_moins_10, dia_lot_regl_copro_publ_hypo_plus_10, dia_lot_regl_copro_publ_hypo_moins_10, dia_indivi_quote_part, dia_design_societe, dia_design_droit, dia_droit_soc_nat, dia_droit_soc_nb, dia_droit_soc_num_part, dia_droit_reel_perso_grevant_bien_oui, dia_droit_reel_perso_grevant_bien_non, dia_droit_reel_perso_nat, dia_droit_reel_perso_viag, dia_mod_cess_adr, dia_mod_cess_sign_act_auth, dia_mod_cess_terme, dia_mod_cess_terme_prec, dia_mod_cess_bene_acquereur, dia_mod_cess_bene_vendeur, dia_mod_cess_paie_nat, dia_mod_cess_design_contr_alien, dia_mod_cess_eval_contr, dia_mod_cess_rente_viag, dia_mod_cess_mnt_an, dia_mod_cess_mnt_compt, dia_mod_cess_bene_rente, dia_mod_cess_droit_usa_hab, dia_mod_cess_droit_usa_hab_prec, dia_mod_cess_eval_usa_usufruit, dia_mod_cess_vente_nue_prop, dia_mod_cess_vente_nue_prop_prec, dia_mod_cess_echange, dia_mod_cess_design_bien_recus_ech, dia_mod_cess_mnt_soulte, dia_mod_cess_prop_contre_echan, dia_mod_cess_apport_societe, dia_mod_cess_bene, dia_mod_cess_esti_bien, dia_mod_cess_cess_terr_loc_co, dia_mod_cess_esti_terr, dia_mod_cess_esti_loc, dia_mod_cess_esti_imm_loca, dia_mod_cess_adju_vol, dia_mod_cess_adju_obl, dia_mod_cess_adju_fin_indivi, dia_mod_cess_adju_date_lieu, dia_mod_cess_mnt_mise_prix, dia_prop_titu_prix_indique, dia_prop_recherche_acqu_prix_indique, dia_acquereur_prof, dia_indic_compl_ope, dia_vente_adju, am_terr_res_demon, am_air_terr_res_mob, ctx_objet_recours, ctx_moyen_souleve, ctx_moyen_retenu_juge, ctx_reference_sagace, ctx_nature_travaux_infra_om_html, ctx_synthese_nti, ctx_article_non_resp_om_html, ctx_synthese_anr, ctx_reference_parquet, ctx_element_taxation, ctx_infraction, ctx_regularisable, ctx_reference_courrier, ctx_date_audience, ctx_date_ajournement, exo_facul_1, exo_facul_2, exo_facul_3, exo_facul_4, exo_facul_5, exo_facul_6, exo_facul_7, exo_facul_8, exo_facul_9, exo_ta_1, exo_ta_2, exo_ta_3, exo_ta_4, exo_ta_5, exo_ta_6, exo_ta_7, exo_ta_8, exo_ta_9, exo_rap_1, exo_rap_2, exo_rap_3, exo_rap_4, exo_rap_5, exo_rap_6, exo_rap_7, exo_rap_8, mtn_exo_ta_part_commu, mtn_exo_ta_part_depart, mtn_exo_ta_part_reg, mtn_exo_rap, dpc_type, dpc_desc_actv_ex, dpc_desc_ca, dpc_desc_aut_prec, dpc_desig_comm_arti, dpc_desig_loc_hab, dpc_desig_loc_ann, dpc_desig_loc_ann_prec, dpc_bail_comm_date, dpc_bail_comm_loyer, dpc_actv_acqu, dpc_nb_sala_di, dpc_nb_sala_dd, dpc_nb_sala_tc, dpc_nb_sala_tp, dpc_moda_cess_vente_am, dpc_moda_cess_adj, dpc_moda_cess_prix, dpc_moda_cess_adj_date, dpc_moda_cess_adj_prec, dpc_moda_cess_paie_comp, dpc_moda_cess_paie_terme, dpc_moda_cess_paie_terme_prec, dpc_moda_cess_paie_nat, dpc_moda_cess_paie_nat_desig_alien, dpc_moda_cess_paie_nat_desig_alien_prec, dpc_moda_cess_paie_nat_eval, dpc_moda_cess_paie_nat_eval_prec, dpc_moda_cess_paie_aut, dpc_moda_cess_paie_aut_prec, dpc_ss_signe_demande_acqu, dpc_ss_signe_recher_trouv_acqu, dpc_notif_adr_prop, dpc_notif_adr_manda, dpc_obs, co_peri_site_patri_remar, co_abo_monu_hist, co_inst_ouvr_trav_act_code_envir, co_trav_auto_env, co_derog_esp_prot, ctx_reference_dsj, co_piscine, co_fin_lls, co_fin_aa, co_fin_ptz, co_fin_autr, dia_ss_date, dia_ss_lieu, enga_decla_lieu, enga_decla_date, co_archi_attest_honneur, co_bat_niv_dessous_nb, co_install_classe, co_derog_innov, co_avis_abf, tax_surf_tot_demo, tax_surf_tax_demo, tax_terrassement_arch, tax_adresse_future_numero, tax_adresse_future_voie, tax_adresse_future_lieudit, tax_adresse_future_localite, tax_adresse_future_cp, tax_adresse_future_bp, tax_adresse_future_cedex, tax_adresse_future_pays, tax_adresse_future_division, co_bat_projete, co_bat_existant, co_bat_nature, terr_juri_titul_date, co_autre_desc, co_trx_autre, co_autre, erp_modif_facades, erp_trvx_adap, erp_trvx_adap_numero, erp_trvx_adap_valid, erp_prod_dangereux, co_trav_supp_dessus, co_trav_supp_dessous, tax_su_habit_abr_jard_pig_colom, enga_decla_donnees_nomi_comm) VALUES (10, 'cerfa de test n°9', '123456', '2013-01-01', '2020-07-06', true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 13409, true, true, true, true, true, true, true, true, 1340903, 1340903, 1340903, 1340903, true, true, true, true, true, true, true, 1340903, 13409, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 1340903, true, true, true, true, true, true, true, true, true, true, true, true, 1382403, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, 1340905, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, true, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false, false);


--
-- Data for Name: genre; Type: TABLE DATA; Schema: openads; Owner: postgres
--

INSERT INTO genre (genre, code, libelle, description) VALUES (1, 'URBA', 'Pôle Urbanisme', 'Responsabilité de la DDU');
INSERT INTO genre (genre, code, libelle, description) VALUES (2, 'ERP', 'Pôle ERP', 'Responsabilité de la DGUP');


--
-- Data for Name: groupe; Type: TABLE DATA; Schema: openads; Owner: postgres
--

INSERT INTO groupe (groupe, code, libelle, description, genre) VALUES (1, 'ADS', 'Autorisation ADS', '', 1);
INSERT INTO groupe (groupe, code, libelle, description, genre) VALUES (2, 'CTX', 'Contentieux', '', 1);
INSERT INTO groupe (groupe, code, libelle, description, genre) VALUES (3, 'CU', 'Changement d''usage', '', 1);
INSERT INTO groupe (groupe, code, libelle, description, genre) VALUES (4, 'RU', 'Renseignement d''urbanisme', '', 1);
INSERT INTO groupe (groupe, code, libelle, description, genre) VALUES (5, 'ERP', 'ERP', '', 2);


--
-- Data for Name: dossier_autorisation_type; Type: TABLE DATA; Schema: openads; Owner: postgres
--

INSERT INTO dossier_autorisation_type (dossier_autorisation_type, code, libelle, description, confidentiel, groupe, affichage_form, cacher_da) VALUES (1, 'PC', 'Permis de construire', '', false, 1, 'ADS', false);
INSERT INTO dossier_autorisation_type (dossier_autorisation_type, code, libelle, description, confidentiel, groupe, affichage_form, cacher_da) VALUES (2, 'PD', 'Permis de démolir', '', false, 1, 'ADS', false);
INSERT INTO dossier_autorisation_type (dossier_autorisation_type, code, libelle, description, confidentiel, groupe, affichage_form, cacher_da) VALUES (3, 'PA', 'Permis d''aménager', '', false, 1, 'ADS', false);
INSERT INTO dossier_autorisation_type (dossier_autorisation_type, code, libelle, description, confidentiel, groupe, affichage_form, cacher_da) VALUES (4, 'DP', 'Déclaration préalable', '', false, 1, 'ADS', false);
INSERT INTO dossier_autorisation_type (dossier_autorisation_type, code, libelle, description, confidentiel, groupe, affichage_form, cacher_da) VALUES (5, 'CU', 'Certificat d''urbanisme', '', false, 1, 'ADS', false);
INSERT INTO dossier_autorisation_type (dossier_autorisation_type, code, libelle, description, confidentiel, groupe, affichage_form, cacher_da) VALUES (6, 'AZ', 'Demande d''autorisation spéciale de travaux dans le périmètre d''une AVAP', 'Demande d''autorisation spéciale de travaux compris dans le périmètre d''une aire de mise en valeur de l''architecture et du patrimoine (AVAP)', false, 1, 'ADS', false);
INSERT INTO dossier_autorisation_type (dossier_autorisation_type, code, libelle, description, confidentiel, groupe, affichage_form, cacher_da) VALUES (7, 'AT', 'Demande d''autorisation de construire, d''aménager ou de modifier un ERP', 'Demande d''autorisation de construire, d''aménager ou de modifier un établissement recevant du public (ERP)', false, 5, 'ADS', false);
INSERT INTO dossier_autorisation_type (dossier_autorisation_type, code, libelle, description, confidentiel, groupe, affichage_form, cacher_da) VALUES (8, 'RE', 'Recours', '', false, 2, 'CTX RE', true);
INSERT INTO dossier_autorisation_type (dossier_autorisation_type, code, libelle, description, confidentiel, groupe, affichage_form, cacher_da) VALUES (9, 'IN', 'Infraction', '', true, 2, 'CTX IN', true);
INSERT INTO dossier_autorisation_type (dossier_autorisation_type, code, libelle, description, confidentiel, groupe, affichage_form, cacher_da) VALUES (10, 'FC', 'Fonds de commerce', '', false, 1, 'DPC', false);


--
-- Data for Name: dossier_autorisation_type_detaille; Type: TABLE DATA; Schema: openads; Owner: postgres
--

INSERT INTO dossier_autorisation_type_detaille (dossier_autorisation_type_detaille, code, libelle, description, dossier_autorisation_type, cerfa, cerfa_lot, duree_validite_parametrage, dossier_platau, couleur) VALUES (1, 'PCI', 'Permis de construire pour une maison individuelle et / ou ses annexes', '', 1, 11, 2, 0, false, NULL);
INSERT INTO dossier_autorisation_type_detaille (dossier_autorisation_type_detaille, code, libelle, description, dossier_autorisation_type, cerfa, cerfa_lot, duree_validite_parametrage, dossier_platau, couleur) VALUES (2, 'PCA', 'Permis de construire comprenant ou non des démolitions', '', 1, 11, 2, 0, false, NULL);
INSERT INTO dossier_autorisation_type_detaille (dossier_autorisation_type_detaille, code, libelle, description, dossier_autorisation_type, cerfa, cerfa_lot, duree_validite_parametrage, dossier_platau, couleur) VALUES (3, 'PD', 'Permis de démolir', '', 2, 11, 2, 0, false, NULL);
INSERT INTO dossier_autorisation_type_detaille (dossier_autorisation_type_detaille, code, libelle, description, dossier_autorisation_type, cerfa, cerfa_lot, duree_validite_parametrage, dossier_platau, couleur) VALUES (4, 'PA', 'Permis d''aménager comprenant ou non des constructions et/ou des démolitions', '', 3, 11, 2, 0, false, NULL);
INSERT INTO dossier_autorisation_type_detaille (dossier_autorisation_type_detaille, code, libelle, description, dossier_autorisation_type, cerfa, cerfa_lot, duree_validite_parametrage, dossier_platau, couleur) VALUES (5, 'DP', 'Déclaration préalable', '', 4, 11, 2, 0, false, NULL);
INSERT INTO dossier_autorisation_type_detaille (dossier_autorisation_type_detaille, code, libelle, description, dossier_autorisation_type, cerfa, cerfa_lot, duree_validite_parametrage, dossier_platau, couleur) VALUES (6, 'CU', 'Certificat d''urbanisme', '', 5, 11, 2, 0, false, NULL);
INSERT INTO dossier_autorisation_type_detaille (dossier_autorisation_type_detaille, code, libelle, description, dossier_autorisation_type, cerfa, cerfa_lot, duree_validite_parametrage, dossier_platau, couleur) VALUES (7, 'AZ', 'Demande d''autorisation spéciale de travaux dans le périmètre d''une AVAP', 'Demande d''autorisation spéciale de travaux compris dans le périmètre d''une aire de mise en valeur de l''architecture et du patrimoine (AVAP)', 6, 11, 2, 0, false, NULL);
INSERT INTO dossier_autorisation_type_detaille (dossier_autorisation_type_detaille, code, libelle, description, dossier_autorisation_type, cerfa, cerfa_lot, duree_validite_parametrage, dossier_platau, couleur) VALUES (8, 'AT', 'Demande d''autorisation de construire, d''aménager ou de modifier un ERP', 'Demande d''autorisation de construire, d''aménager ou de modifier un établissement recevant du public (ERP)', 7, 11, 2, 0, false, NULL);
INSERT INTO dossier_autorisation_type_detaille (dossier_autorisation_type_detaille, code, libelle, description, dossier_autorisation_type, cerfa, cerfa_lot, duree_validite_parametrage, dossier_platau, couleur) VALUES (9, 'DPS', 'DECLARATION PREALABLE SIMPLE', '', 4, 11, 2, 0, false, NULL);
INSERT INTO dossier_autorisation_type_detaille (dossier_autorisation_type_detaille, code, libelle, description, dossier_autorisation_type, cerfa, cerfa_lot, duree_validite_parametrage, dossier_platau, couleur) VALUES (10, 'REG', 'Recours gracieux', '', 8, 11, NULL, 0, false, NULL);
INSERT INTO dossier_autorisation_type_detaille (dossier_autorisation_type_detaille, code, libelle, description, dossier_autorisation_type, cerfa, cerfa_lot, duree_validite_parametrage, dossier_platau, couleur) VALUES (11, 'REC', 'Recours contentieux', '', 8, 11, NULL, 0, false, NULL);
INSERT INTO dossier_autorisation_type_detaille (dossier_autorisation_type_detaille, code, libelle, description, dossier_autorisation_type, cerfa, cerfa_lot, duree_validite_parametrage, dossier_platau, couleur) VALUES (12, 'IN', 'Infraction', '', 9, 11, NULL, 0, false, NULL);
INSERT INTO dossier_autorisation_type_detaille (dossier_autorisation_type_detaille, code, libelle, description, dossier_autorisation_type, cerfa, cerfa_lot, duree_validite_parametrage, dossier_platau, couleur) VALUES (13, 'FC', 'Fonds de commerce', '', 10, 11, 2, 2, false, NULL);


--
-- Data for Name: dossier_instruction_type; Type: TABLE DATA; Schema: openads; Owner: postgres
--

INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (1, 'P', 'Initial', '', 1, true, 'DEPOT', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (6, 'P', 'Initial', '', 2, true, 'DEPOT', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (11, 'P', 'Initial', '', 3, true, 'DEPOT', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (26, 'P', 'Initial', '', 6, true, 'DEPOT', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (3, 'T', 'Transfert', '', 1, true, 'TRANSFERT', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (8, 'T', 'Transfert', '', 2, true, 'TRANSFERT', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (13, 'T', 'Transfert', '', 3, true, 'TRANSFERT', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (18, 'T', 'Transfert', '', 4, true, 'TRANSFERT', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (23, 'T', 'Transfert', '', 5, true, 'TRANSFERT', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (28, 'T', 'Transfert', '', 6, true, 'TRANSFERT', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (33, 'T', 'Transfert', '', 7, true, 'TRANSFERT', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (38, 'T', 'Transfert', '', 8, true, 'TRANSFERT', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (2, 'M', 'Modificatif', '', 1, true, 'MODIFICATIF', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (7, 'M', 'Modificatif', '', 2, true, 'MODIFICATIF', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (12, 'M', 'Modificatif', '', 3, true, 'MODIFICATIF', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (17, 'M', 'Modificatif', '', 4, true, 'MODIFICATIF', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (22, 'M', 'Modificatif', '', 5, true, 'MODIFICATIF', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (27, 'M', 'Modificatif', '', 6, true, 'MODIFICATIF', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (32, 'M', 'Modificatif', '', 7, true, 'MODIFICATIF', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (37, 'M', 'Modificatif', '', 8, true, 'MODIFICATIF', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (4, 'DAACT', 'Achèvement et conformité', '', 1, true, 'SUIVI', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (5, 'DOC', 'Ouverture de chantier', '', 1, true, 'SUIVI', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (9, 'DAACT', 'Achèvement et conformité', '', 2, true, 'SUIVI', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (10, 'DOC', 'Ouverture de chantier', '', 2, true, 'SUIVI', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (14, 'DAACT', 'Achèvement et conformité', '', 3, true, 'SUIVI', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (15, 'DOC', 'Ouverture de chantier', '', 3, true, 'SUIVI', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (19, 'DAACT', 'Achèvement et conformité', '', 4, true, 'SUIVI', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (20, 'DOC', 'Ouverture de chantier', '', 4, true, 'SUIVI', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (24, 'DAACT', 'Achèvement et conformité', '', 5, true, 'SUIVI', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (25, 'DOC', 'Ouverture de chantier', '', 5, true, 'SUIVI', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (29, 'DAACT', 'Achèvement et conformité', '', 6, true, 'SUIVI', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (30, 'DOC', 'Ouverture de chantier', '', 6, true, 'SUIVI', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (34, 'DAACT', 'Achèvement et conformité', '', 7, true, 'SUIVI', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (35, 'DOC', 'Ouverture de chantier', '', 7, true, 'SUIVI', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (39, 'DAACT', 'Achèvement et conformité', '', 8, true, 'SUIVI', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (40, 'DOC', 'Ouverture de chantier', '', 8, true, 'SUIVI', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (42, 'T', 'Transfert', '', 9, true, 'TRANSFERT', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (43, 'M', 'Modificatif', '', 9, true, 'MODIFICATIF', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (44, 'DAACT', 'Achèvement et conformité', '', 9, true, 'SUIVI', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (45, 'DOC', 'Ouverture de chantier', '', 9, true, 'SUIVI', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (21, 'P', 'Initiale', '', 5, true, 'DEPOT', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (31, 'P', 'Initiale', '', 7, true, 'DEPOT', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (36, 'P', 'Initiale', '', 8, true, 'DEPOT', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (41, 'P', 'Initiale', '', 9, true, 'DEPOT', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (16, 'P', 'Initial', '', 4, false, 'DEPOT', true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (46, 'P', 'Initial', '', 10, false, NULL, true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (47, 'P', 'Initial', '', 11, false, NULL, true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (48, 'P', 'Initiale', '', 12, false, NULL, true, true, true, true, true, true, true, true, true, false);
INSERT INTO dossier_instruction_type (dossier_instruction_type, code, libelle, description, dossier_autorisation_type_detaille, suffixe, mouvement_sitadel, maj_da_localisation, maj_da_lot, maj_da_demandeur, maj_da_etat, maj_da_date_init, maj_da_date_validite, maj_da_date_doc, maj_da_date_daact, maj_da_dt, sous_dossier) VALUES (49, 'P', 'Initial', '', 13, true, 'DEPOT', true, true, true, true, true, true, true, true, true, false);


--
-- Data for Name: lien_om_profil_groupe; Type: TABLE DATA; Schema: openads; Owner: postgres
--

INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (1, 3, 1, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (2, 3, 2, true, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (3, 3, 3, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (4, 3, 4, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (5, 3, 5, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (6, 14, 1, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (7, 14, 2, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (8, 14, 3, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (9, 14, 4, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (10, 14, 5, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (11, 18, 1, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (12, 18, 3, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (13, 18, 4, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (14, 18, 5, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (15, 17, 1, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (16, 17, 3, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (17, 17, 4, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (18, 17, 5, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (19, 7, 1, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (20, 7, 3, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (21, 7, 4, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (22, 7, 5, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (23, 11, 1, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (24, 11, 2, true, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (25, 11, 3, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (26, 11, 4, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (27, 11, 5, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (28, 12, 1, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (29, 12, 2, true, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (30, 12, 3, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (31, 12, 4, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (32, 12, 5, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (33, 6, 1, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (34, 6, 3, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (35, 6, 4, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (36, 6, 5, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (37, 5, 1, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (38, 5, 3, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (39, 5, 4, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (40, 5, 5, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (41, 15, 1, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (42, 15, 3, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (43, 15, 4, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (44, 15, 5, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (45, 4, 1, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (46, 4, 3, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (47, 4, 4, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (48, 4, 5, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (49, 8, 1, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (50, 8, 2, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (51, 8, 3, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (52, 8, 4, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (53, 8, 5, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (54, 10, 1, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (55, 10, 3, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (56, 10, 4, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (57, 10, 5, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (58, 9, 1, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (59, 9, 3, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (60, 9, 4, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (61, 9, 5, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (62, 20, 1, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (63, 20, 2, true, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (64, 20, 3, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (65, 20, 4, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (66, 20, 5, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (67, 21, 1, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (68, 21, 2, true, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (69, 21, 3, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (70, 21, 4, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (71, 21, 5, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (72, 22, 1, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (73, 22, 2, true, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (74, 22, 3, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (75, 22, 4, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (76, 22, 5, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (77, 23, 1, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (78, 23, 2, true, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (79, 23, 3, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (80, 23, 4, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (81, 23, 5, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (82, 24, 1, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (83, 24, 2, true, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (84, 24, 3, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (85, 24, 4, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (86, 24, 5, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (87, 25, 1, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (88, 25, 2, true, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (89, 25, 3, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (90, 25, 4, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (91, 25, 5, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (92, 26, 1, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (93, 26, 2, true, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (94, 26, 3, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (95, 26, 4, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (96, 26, 5, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (97, 27, 1, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (98, 27, 2, true, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (99, 27, 3, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (100, 27, 4, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (101, 27, 5, false, false);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (102, 19, 1, true, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (103, 19, 2, true, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (104, 19, 3, true, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (105, 19, 4, true, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (106, 19, 5, true, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (107, 13, 1, true, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (108, 13, 3, true, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (109, 13, 4, true, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (110, 13, 5, true, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (111, 16, 1, true, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (112, 16, 3, true, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (113, 16, 4, true, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (114, 16, 5, true, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (115, 28, 1, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (116, 28, 3, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (117, 28, 4, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (118, 28, 5, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (119, 29, 1, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (120, 29, 3, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (121, 29, 4, false, true);
INSERT INTO lien_om_profil_groupe (lien_om_profil_groupe, om_profil, groupe, confidentiel, enregistrement_demande) VALUES (122, 29, 5, false, true);


--
-- Data for Name: lien_om_utilisateur_groupe; Type: TABLE DATA; Schema: openads; Owner: postgres
--



--
-- Data for Name: lien_type_di_type_di; Type: TABLE DATA; Schema: openads; Owner: postgres
--



--
-- Name: autorite_competente_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
--

SELECT pg_catalog.setval('autorite_competente_seq', 4, false);


--
-- Name: cerfa_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
--

SELECT pg_catalog.setval('cerfa_seq', 12, false);


--
-- Name: dossier_autorisation_type_detaille_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
--

SELECT pg_catalog.setval('dossier_autorisation_type_detaille_seq', 14, false);


--
-- Name: dossier_autorisation_type_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
--

SELECT pg_catalog.setval('dossier_autorisation_type_seq', 11, false);


--
-- Name: dossier_instruction_type_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
--

SELECT pg_catalog.setval('dossier_instruction_type_seq', 50, false);


--
-- Name: genre_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
--

SELECT pg_catalog.setval('genre_seq', 3, false);


--
-- Name: groupe_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
--

SELECT pg_catalog.setval('groupe_seq', 6, false);


--
-- Name: lien_om_profil_groupe_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
--

SELECT pg_catalog.setval('lien_om_profil_groupe_seq', 123, false);


--
-- Name: lien_om_utilisateur_groupe_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
--

SELECT pg_catalog.setval('lien_om_utilisateur_groupe_seq', 1, false);


--
-- Name: lien_type_di_type_di_seq; Type: SEQUENCE SET; Schema: openads; Owner: postgres
--

SELECT pg_catalog.setval('lien_type_di_type_di_seq', 1, false);


--
-- PostgreSQL database dump complete
--

