<?php

declare(strict_types=1);

namespace DoctrineMigrations;

use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;

/**
 * Auto-generated Migration: Please modify to your needs!
 */
final class Version20220218101601 extends AbstractMigration
{
    public function getDescription(): string
    {
        return '';
    }

    public function up(Schema $schema): void
    {
        // this up() migration is auto-generated, please modify it to your needs
        $this->addSql('ALTER TABLE sav.mag_commande DROP CONSTRAINT mag_commande_idtype_cde_fkey');
        $this->addSql('ALTER TABLE sav.produit DROP CONSTRAINT produit_idproduit_famille_fkey');
        $this->addSql('ALTER TABLE sav.secteur DROP CONSTRAINT secteur_idsectorisation_version_fkey');
        $this->addSql('ALTER TABLE sav.stock_standard_produit DROP CONSTRAINT stock_standard_produit_idstock_standard_fkey');
        $this->addSql('ALTER TABLE sav.tarif_option DROP CONSTRAINT tarif_option_idoption_fkey');
        $this->addSql('ALTER TABLE sav.equipement_option DROP CONSTRAINT equipement_option_idtarif_option_fkey');
        $this->addSql('ALTER TABLE sav.intervention DROP CONSTRAINT intervention_idcontrat_fkey');
        $this->addSql('ALTER TABLE sav.contrat_proposition DROP CONSTRAINT contrat_proposition_idcontrat_fkey');
        $this->addSql('ALTER TABLE sav.contrat_relance DROP CONSTRAINT contrat_relance_idcontrat_fkey');
        $this->addSql('ALTER TABLE sav.communication_client DROP CONSTRAINT communication_client_idintervention_fkey');
        $this->addSql('ALTER TABLE sav.courrier_client DROP CONSTRAINT courrier_client_idintervention_fkey');
        $this->addSql('ALTER TABLE sav.devis DROP CONSTRAINT devis_idintervention_fkey');
        $this->addSql('ALTER TABLE sav.equipement_mesure DROP CONSTRAINT equipement_mesure_idintervention_fkey');
        $this->addSql('ALTER TABLE sav.historique_modification DROP CONSTRAINT historique_modification_idintervention_fkey');
        $this->addSql('ALTER TABLE sav.intervention_anomalie DROP CONSTRAINT intervention_anomalie_idintervention_fkey');
        $this->addSql('ALTER TABLE sav.intervention_documents DROP CONSTRAINT intervention_documents_idintervention_fkey');
        $this->addSql('ALTER TABLE sav.intervention_media DROP CONSTRAINT intervention_media_idintervention_fkey');
        $this->addSql('ALTER TABLE sav.intervention_observation DROP CONSTRAINT intervention_observation_idintervention_fkey');
        $this->addSql('ALTER TABLE sav.intervention_payeur_externe DROP CONSTRAINT intervention_payeur_externe_idintervention_fkey');
        $this->addSql('ALTER TABLE sav.intervention_pre_encaissement DROP CONSTRAINT intervention_pre_encaissement_idintervention_fkey');
        $this->addSql('ALTER TABLE sav.intervention_retour DROP CONSTRAINT intervention_retour_idintervention_fkey');
        $this->addSql('ALTER TABLE sav.privilege DROP CONSTRAINT privilege_idintervention_fkey');
        $this->addSql('ALTER TABLE sav.facture DROP CONSTRAINT facture_idintervention_fkey');
        $this->addSql('ALTER TABLE sav.mag_commande DROP CONSTRAINT mag_commande_idintervention_fkey');
        $this->addSql('ALTER TABLE sav.agent_secteur DROP CONSTRAINT agent_secteur_idsecteur_version_fkey');
        $this->addSql('ALTER TABLE sav.secteur_equipement DROP CONSTRAINT secteur_equipement_idsecteur_version_fkey');
        $this->addSql('ALTER TABLE sav.paiement DROP CONSTRAINT paiement_iddevis_fkey');
        $this->addSql('ALTER TABLE sav.facture DROP CONSTRAINT facture_iddevis_fkey');
        $this->addSql('ALTER TABLE sav.contrat DROP CONSTRAINT contrat_idequipement_fkey');
        $this->addSql('ALTER TABLE sav.intervention DROP CONSTRAINT intervention_idequipement_fkey');
        $this->addSql('ALTER TABLE sav.communication_client DROP CONSTRAINT communication_client_idequipement_fkey');
        $this->addSql('ALTER TABLE sav.courrier_client DROP CONSTRAINT courrier_client_idequipement_fkey');
        $this->addSql('ALTER TABLE sav.equipement_mesure DROP CONSTRAINT equipement_mesure_idequipement_fkey');
        $this->addSql('ALTER TABLE sav.historique_modification DROP CONSTRAINT historique_modification_idequipement_fkey');
        $this->addSql('ALTER TABLE sav.planning DROP CONSTRAINT planning_idequipement_fkey');
        $this->addSql('ALTER TABLE sav.planning_conflit DROP CONSTRAINT planning_conflit_idequipement_fkey');
        $this->addSql('ALTER TABLE sav.planning_historique_modification DROP CONSTRAINT planning_historique_modification_idequipement_fkey');
        $this->addSql('ALTER TABLE sav.privilege DROP CONSTRAINT privilege_idequipement_fkey');
        $this->addSql('ALTER TABLE sav.secteur_equipement DROP CONSTRAINT secteur_equipement_idequipement_fkey');
        $this->addSql('ALTER TABLE sav.aide_technique DROP CONSTRAINT aide_technique_idequipement_fkey');
        $this->addSql('ALTER TABLE sav.demande_documentation DROP CONSTRAINT demande_documentation_idtype_demandeur_fkey');
        $this->addSql('ALTER TABLE sav.facture DROP CONSTRAINT facture_idequipement_fkey');
        $this->addSql('ALTER TABLE sav.equipement_complement DROP CONSTRAINT equipement_complement_idequipement_fkey');
        $this->addSql('ALTER TABLE sav.equipement_zone DROP CONSTRAINT equipement_zone_idequipement_fkey');
        $this->addSql('ALTER TABLE sav.historique_client_equipement DROP CONSTRAINT historique_client_equipement_idequipement_fkey');
        $this->addSql('ALTER TABLE sav.mag_commande DROP CONSTRAINT mag_commande_idequipement_fkey');
        $this->addSql('ALTER TABLE sav.old_bloc_note_client DROP CONSTRAINT old_bloc_note_client_idequipement_fkey');
        $this->addSql('ALTER TABLE sav.equipement_groupe DROP CONSTRAINT equipement_groupe_idequipement_fkey');
        $this->addSql('ALTER TABLE sav.equipement_option DROP CONSTRAINT equipement_option_idequipement_fkey');
        $this->addSql('ALTER TABLE sav.intervention DROP CONSTRAINT intervention_idplanning_fkey');
        $this->addSql('ALTER TABLE sav.planning_conflit DROP CONSTRAINT planning_conflit_idplanning_fkey');
        $this->addSql('ALTER TABLE sav.planning_historique_modification DROP CONSTRAINT planning_historique_modification_idplanning_fkey');
        $this->addSql('ALTER TABLE sav.intervention_annulation DROP CONSTRAINT intervention_annulation_idplanning_fkey');
        $this->addSql('ALTER TABLE sav.planning DROP CONSTRAINT planning_idpln_transit_fkey');
        $this->addSql('ALTER TABLE sav.adresse_complement DROP CONSTRAINT adresse_complement_idadresse_fkey');
        $this->addSql('ALTER TABLE sav.equipement DROP CONSTRAINT equipement_idadresse_fkey');
        $this->addSql('ALTER TABLE sav.intervention_payeur_externe DROP CONSTRAINT intervention_payeur_externe_idadresse_fkey');
        $this->addSql('ALTER TABLE sav.facture DROP CONSTRAINT facture_idadresse_fkey');
        $this->addSql('ALTER TABLE sav.aide_technique_histo DROP CONSTRAINT aide_technique_histo_idaide_technique_fkey');
        $this->addSql('ALTER TABLE sav.aide_technique_classification DROP CONSTRAINT aide_technique_classification_idaide_technique_fkey');
        $this->addSql('ALTER TABLE sav.adresse_complement DROP CONSTRAINT adresse_complement_idtype_complement_adresse_fkey');
        $this->addSql('ALTER TABLE sav.communication_client DROP CONSTRAINT communication_client_idclient_fkey');
        $this->addSql('ALTER TABLE sav.equipement DROP CONSTRAINT equipement_idclient_fkey');
        $this->addSql('ALTER TABLE sav.historique_modification DROP CONSTRAINT historique_modification_idclient_fkey');
        $this->addSql('ALTER TABLE sav.adresse DROP CONSTRAINT adresse_idclient_fkey');
        $this->addSql('ALTER TABLE sav.client DROP CONSTRAINT client_idsouscripteur_fkey');
        $this->addSql('ALTER TABLE sav.client_email DROP CONSTRAINT client_email_idclient_fkey');
        $this->addSql('ALTER TABLE sav.client_tel DROP CONSTRAINT client_tel_idclient_fkey');
        $this->addSql('ALTER TABLE sav.historique_client_equipement DROP CONSTRAINT historique_client_equipement_idclient_fkey');
        $this->addSql('ALTER TABLE sav.historique_client_equipement DROP CONSTRAINT historique_client_equipement_idsouscripteur_fkey');
        $this->addSql('ALTER TABLE sav.adresse DROP CONSTRAINT adresse_idtype_adresse_fkey');
        $this->addSql('ALTER TABLE sav.adresse DROP CONSTRAINT adresse_idtype_logement_fkey');
        $this->addSql('ALTER TABLE sav.agent_appareil DROP CONSTRAINT agent_appareil_idappareil_fkey');
        $this->addSql('ALTER TABLE sav.type_visite_appareil DROP CONSTRAINT type_visite_appareil_idappareil_fkey');
        $this->addSql('ALTER TABLE sav.agent_qualification DROP CONSTRAINT agent_qualification_idequipement_famille_fkey');
        $this->addSql('ALTER TABLE sav.equipement_type DROP CONSTRAINT equipement_type_idequipement_famille_fkey');
        $this->addSql('ALTER TABLE sav.tva_equipement DROP CONSTRAINT tva_equipement_idequipement_famille_fkey');
        $this->addSql('ALTER TABLE sav.aide_technique_classification DROP CONSTRAINT aide_technique_classification_idaide_technique_classificat_fkey');
        $this->addSql('ALTER TABLE sav.aide_technique_histo DROP CONSTRAINT aide_technique_histo_idaide_technique_etat_fkey');
        $this->addSql('ALTER TABLE sav.aide_technique DROP CONSTRAINT aide_technique_idaide_technique_etat_fkey');
        $this->addSql('ALTER TABLE sav.aide_technique DROP CONSTRAINT aide_technique_idtype_demandeur_fkey');
        $this->addSql('ALTER TABLE sav.demande_documentation DROP CONSTRAINT demande_documentation_idequipement_fkey');
        $this->addSql('ALTER TABLE sav.attachement_parametre DROP CONSTRAINT attachement_parametre_idattachement_parametre_liste_fkey');
        $this->addSql('ALTER TABLE sav.intervention DROP CONSTRAINT intervention_idtype_visite_init_fkey');
        $this->addSql('ALTER TABLE sav.planning DROP CONSTRAINT planning_idtype_visite_fkey');
        $this->addSql('ALTER TABLE sav.pln_droits_visite DROP CONSTRAINT pln_droits_visite_idtype_visite_fkey');
        $this->addSql('ALTER TABLE sav.pln_visite_exclusion DROP CONSTRAINT pln_visite_exclusion_idtype_visite_fkey');
        $this->addSql('ALTER TABLE sav.attachement_type_visite DROP CONSTRAINT attachement_type_visite_idtype_visite_fkey');
        $this->addSql('ALTER TABLE sav.pln_config_visite DROP CONSTRAINT pln_config_visite_idtype_visite_fkey');
        $this->addSql('ALTER TABLE sav.pln_groupes_droits_visite DROP CONSTRAINT pln_groupes_droits_visite_idtype_visite_fkey');
        $this->addSql('ALTER TABLE sav.type_visite_appareil DROP CONSTRAINT type_visite_appareil_idtype_visite_fkey');
        $this->addSql('ALTER TABLE sav.classification_energetique DROP CONSTRAINT classification_energetique_idclasse_energetique_fkey');
        $this->addSql('ALTER TABLE sav.classification_energetique DROP CONSTRAINT classification_energetique_idclasse_rendement_fkey');
        $this->addSql('ALTER TABLE sav.tarif_option DROP CONSTRAINT tarif_option_idequipement_type_fkey');
        $this->addSql('ALTER TABLE sav.equipement DROP CONSTRAINT equipement_idequipement_type_fkey');
        $this->addSql('ALTER TABLE sav.classification_energetique DROP CONSTRAINT classification_energetique_idequipement_type_fkey');
        $this->addSql('ALTER TABLE sav.contrat_tarif DROP CONSTRAINT contrat_tarif_idequipement_type_fkey');
        $this->addSql('ALTER TABLE sav.client DROP CONSTRAINT client_code_ec_fkey');
        $this->addSql('ALTER TABLE sav.client DROP CONSTRAINT client_idcategorie_pro_fkey');
        $this->addSql('ALTER TABLE sav.client DROP CONSTRAINT client_idcompte_client_web_fkey');
        $this->addSql('ALTER TABLE sav.intervention_payeur_externe DROP CONSTRAINT intervention_payeur_externe_idtype_client_fkey');
        $this->addSql('ALTER TABLE sav.client DROP CONSTRAINT client_idtype_client_fkey');
        $this->addSql('ALTER TABLE sav.tva_equipement DROP CONSTRAINT tva_equipement_idtype_client_fkey');
        $this->addSql('ALTER TABLE sav.contrat DROP CONSTRAINT contrat_idfacture_fkey');
        $this->addSql('ALTER TABLE sav.facture_ligne DROP CONSTRAINT facture_ligne_idfacture_fkey');
        $this->addSql('ALTER TABLE sav.facture_relance DROP CONSTRAINT facture_relance_idfacture_fkey');
        $this->addSql('ALTER TABLE sav.intervention DROP CONSTRAINT intervention_idfacture_fkey');
        $this->addSql('ALTER TABLE sav.paiement DROP CONSTRAINT paiement_idfacture_fkey');
        $this->addSql('ALTER TABLE sav.communication_client DROP CONSTRAINT communication_client_idcommunication_canal_fkey');
        $this->addSql('ALTER TABLE sav.communication_client DROP CONSTRAINT communication_client_idcommunication_type_fkey');
        $this->addSql('ALTER TABLE sav.mag_stock_mouvement DROP CONSTRAINT mag_stock_mouvement_idproduit_fkey');
        $this->addSql('ALTER TABLE sav.produit_stock_site DROP CONSTRAINT produit_stock_site_idproduit_fkey');
        $this->addSql('ALTER TABLE sav.facture_ligne DROP CONSTRAINT facture_ligne_idproduit_fkey');
        $this->addSql('ALTER TABLE sav.mag_ligne_commande DROP CONSTRAINT mag_ligne_commande_idproduit_fkey');
        $this->addSql('ALTER TABLE sav.produit_photo DROP CONSTRAINT produit_photo_idproduit_fkey');
        $this->addSql('ALTER TABLE sav.produit_tarif DROP CONSTRAINT produit_tarif_idproduit_fkey');
        $this->addSql('ALTER TABLE sav.stock_standard_produit DROP CONSTRAINT stock_standard_produit_idproduit_fkey');
        $this->addSql('ALTER TABLE sav.contrat DROP CONSTRAINT contrat_idcontrat_motif_resiliation_fkey');
        $this->addSql('ALTER TABLE sav.tarif_option DROP CONSTRAINT tarif_option_idcontrat_type_fkey');
        $this->addSql('ALTER TABLE sav.contrat DROP CONSTRAINT contrat_idcontrat_type_fkey');
        $this->addSql('ALTER TABLE sav.contrat_proposition DROP CONSTRAINT contrat_proposition_idcontrat_type_fkey');
        $this->addSql('ALTER TABLE sav.contrat_tarif DROP CONSTRAINT contrat_tarif_idcontrat_type_fkey');
        $this->addSql('ALTER TABLE sav.contrat_tarif DROP CONSTRAINT contrat_tarif_idpuissance_fkey');
        $this->addSql('ALTER TABLE sav.equipement_complement DROP CONSTRAINT equipement_complement_idtype_complement_fkey');
        $this->addSql('ALTER TABLE sav.equipement_groupe DROP CONSTRAINT equipement_groupe_idgroupe_type_fkey');
        $this->addSql('ALTER TABLE sav.equipement DROP CONSTRAINT equipement_idequipement_local_fkey');
        $this->addSql('ALTER TABLE sav.equipement DROP CONSTRAINT equipement_idinstallateur_fkey');
        $this->addSql('ALTER TABLE sav.equipement DROP CONSTRAINT equipement_idnature_gaz_fkey');
        $this->addSql('ALTER TABLE sav.equipement DROP CONSTRAINT equipement_idprotection_sanitaire_fkey');
        $this->addSql('ALTER TABLE sav.equipement DROP CONSTRAINT equipement_idraccordement_fkey');
        $this->addSql('ALTER TABLE sav.equipement DROP CONSTRAINT equipement_idrobinet_remplissage_fkey');
        $this->addSql('ALTER TABLE sav.equipement DROP CONSTRAINT equipement_idtranche_equipement_fkey');
        $this->addSql('ALTER TABLE sav.equipement_zone DROP CONSTRAINT equipement_zone_idtype_zone_fkey');
        $this->addSql('ALTER TABLE sav.facture DROP CONSTRAINT facture_idcategorie_facture_fkey');
        $this->addSql('ALTER TABLE sav.facture DROP CONSTRAINT facture_idfacture_type_fkey');
        $this->addSql('ALTER TABLE sav.facture_ligne DROP CONSTRAINT facture_ligne_idproduit_facture_affectation_fkey');
        $this->addSql('ALTER TABLE sav.mag_commande_histo DROP CONSTRAINT mag_commande_histo_idcommande_fkey');
        $this->addSql('ALTER TABLE sav.mag_ligne_commande DROP CONSTRAINT mag_ligne_commande_idmag_commande_fkey');
        $this->addSql('ALTER TABLE sav.planning DROP CONSTRAINT planning_idpln_annulation_fkey');
        $this->addSql('ALTER TABLE sav.intervention_annulation DROP CONSTRAINT intervention_annulation_idintervention_motif_abandon_fkey');
        $this->addSql('ALTER TABLE sav.intervention_annulation DROP CONSTRAINT intervention_annulation_idintervention_motif_absence_fkey');
        $this->addSql('ALTER TABLE sav.intervention_annulation DROP CONSTRAINT intervention_annulation_idintervention_motif_annulation_fkey');
        $this->addSql('ALTER TABLE sav.intervention_anomalie DROP CONSTRAINT intervention_anomalie_idanomalie_fkey');
        $this->addSql('ALTER TABLE sav.intervention DROP CONSTRAINT intervention_idintervention_motif_fkey');
        $this->addSql('ALTER TABLE sav.intervention DROP CONSTRAINT intervention_idtype_envoi_rapport_fkey');
        $this->addSql('ALTER TABLE sav.paiement DROP CONSTRAINT paiement_idmoyen_paiement_fkey');
        $this->addSql('ALTER TABLE sav.intervention_pre_encaissement DROP CONSTRAINT intervention_pre_encaissement_idmoyen_paiement_fkey');
        $this->addSql('ALTER TABLE sav.mag_commande_histo DROP CONSTRAINT mag_commande_histo_idmag_etat_commande_fkey');
        $this->addSql('ALTER TABLE sav.mag_commande DROP CONSTRAINT mag_commande_idmag_etat_commande_fkey');
        $this->addSql('ALTER TABLE sav.intervention_retour DROP CONSTRAINT intervention_retour_idretour_fkey');
        $this->addSql('ALTER TABLE sav.planning_agents_liste DROP CONSTRAINT planning_agents_liste_idpln_liste_agents_fkey');
        $this->addSql('ALTER TABLE sav.planning_historique_modification DROP CONSTRAINT planning_historique_modification_code_action_fkey');
        $this->addSql('ALTER TABLE sav.planning_historique_modification DROP CONSTRAINT planning_historique_modification_idpln_initiative_interv_fkey');
        $this->addSql('ALTER TABLE sav.planning DROP CONSTRAINT planning_idpln_controle_voiture_fkey');
        $this->addSql('ALTER TABLE sav.planning DROP CONSTRAINT planning_idpln_formation_fkey');
        $this->addSql('ALTER TABLE sav.planning DROP CONSTRAINT planning_idpln_maladie_fkey');
        $this->addSql('ALTER TABLE sav.planning DROP CONSTRAINT planning_idpln_reserve_fkey');
        $this->addSql('ALTER TABLE sav.planning DROP CONSTRAINT planning_idpln_reunion_fkey');
        $this->addSql('ALTER TABLE sav.planning DROP CONSTRAINT planning_idpln_test_fkey');
        $this->addSql('ALTER TABLE sav.planning DROP CONSTRAINT planning_idmoment_passage_fkey');
        $this->addSql('ALTER TABLE sav.planning_historique_modification DROP CONSTRAINT planning_historique_modification_moment_fkey');
        $this->addSql('ALTER TABLE sav.planning DROP CONSTRAINT planning_idpln_horaires_passage_fkey');
        $this->addSql('ALTER TABLE sav.planning_historique_modification DROP CONSTRAINT planning_historique_modification_idplanning_initiative_fkey');
        $this->addSql('ALTER TABLE sav.planning_initiative_detail DROP CONSTRAINT planning_initiative_detail_idplanning_initiative_fkey');
        $this->addSql('ALTER TABLE sav.pln_config_rub DROP CONSTRAINT pln_config_rub_idpln_config_req_fkey');
        $this->addSql('ALTER TABLE sav.pln_config_visite DROP CONSTRAINT pln_config_visite_idpln_config_req_fkey');
        $this->addSql('ALTER TABLE sav.pln_controle_voiture DROP CONSTRAINT pln_controle_voiture_idpln_voiture_action_fkey');
        $this->addSql('ALTER TABLE sav.pln_controle_voiture DROP CONSTRAINT pln_controle_voiture_idpln_voiture_lieu_fkey');
        $this->addSql('ALTER TABLE sav.pln_formation DROP CONSTRAINT pln_formation_idpln_formation_intitule_fkey');
        $this->addSql('ALTER TABLE sav.pln_formation DROP CONSTRAINT pln_formation_idpln_formation_lieu_fkey');
        $this->addSql('ALTER TABLE sav.pln_formation DROP CONSTRAINT pln_formation_idpln_formation_organisme_fkey');
        $this->addSql('ALTER TABLE sav.pln_groupe_utilisateurs DROP CONSTRAINT pln_groupe_utilisateurs_idpln_groupes_fkey');
        $this->addSql('ALTER TABLE sav.pln_groupes_droits_visite DROP CONSTRAINT pln_groupes_droits_visite_idpln_groupes_fkey');
        $this->addSql('ALTER TABLE sav.pln_transit_groupe DROP CONSTRAINT pln_transit_groupe_idpln_groupes_fkey');
        $this->addSql('ALTER TABLE sav.pln_maladie DROP CONSTRAINT pln_maladie_idpln_motif_maladie_fkey');
        $this->addSql('ALTER TABLE sav.privilege DROP CONSTRAINT privilege_idraison_refus_fkey');
        $this->addSql('ALTER TABLE sav.pln_reserve DROP CONSTRAINT pln_reserve_idpln_motif_reserve_fkey');
        $this->addSql('ALTER TABLE sav.pln_reunion DROP CONSTRAINT pln_reunion_idpln_reunion_lieu_fkey');
        $this->addSql('ALTER TABLE sav.pln_reunion DROP CONSTRAINT pln_reunion_idpln_reunion_ordre_jour_fkey');
        $this->addSql('ALTER TABLE sav.pln_test DROP CONSTRAINT pln_test_idpln_test_intitule_fkey');
        $this->addSql('ALTER TABLE sav.pln_test DROP CONSTRAINT pln_test_idpln_test_lieu_fkey');
        $this->addSql('ALTER TABLE sav.privilege DROP CONSTRAINT privilege_statut_privilege_fkey');
        $this->addSql('ALTER TABLE sav.produit DROP CONSTRAINT produit_idproduit_type_fkey');
        $this->addSql('ALTER TABLE sav.retour DROP CONSTRAINT retour_idtype_retour_fkey');
        $this->addSql('ALTER TABLE sav.secteur DROP CONSTRAINT secteur_idsecteur_activite_fkey');
        $this->addSql('ALTER TABLE sav.secteur DROP CONSTRAINT secteur_idsecteur_tarif_fkey');
        $this->addSql('ALTER TABLE sav.secteur DROP CONSTRAINT secteur_idsecteur_taux_retour_fkey');
        $this->addSql('ALTER TABLE sav.tva_equipement DROP CONSTRAINT tva_equipement_idtaux_tva_fkey');
        $this->addSql('ALTER TABLE sav.type_visite DROP CONSTRAINT type_visite_idcategorie_visite_fkey');
        $this->addSql('DROP SEQUENCE sav.adresse_complement_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.adresse_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.privilege_raison_refus_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.agent_gps_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.retour_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.aide_technique_classification_liste_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.aide_technique_histo_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.appareil_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.attachement_parametre_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.attachement_parametre_liste_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.attachement_periode_froid_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.mag_type_commande_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.moment_passage_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.attachement_type_visite_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.categorie_facture_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.categorie_pro_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.classification_energetique_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.client_email_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.client_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.client_tel_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.communication_canal_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.communication_client_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.communication_type_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.compte_client_web_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.contrat_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.contrat_motif_resiliation_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.contrat_proposition_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.contrat_relance_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.contrat_tarif_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.contrat_type_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.courrier_client_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.demande_documentation_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.devis_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.equipement_option_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.equipement_famille_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.equipement_groupe_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.equipement_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.equipement_tranche_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.equipement_type_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.facture_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.facture_ligne_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.facture_relance_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.facture_type_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.formation_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.groupe_type_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.historique_client_equipement_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.historique_modification_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.installateur_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.intervention_annulation_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.intervention_documents_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.intervention_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.intervention_media_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.intervention_message_co_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.intervention_motif_abandon_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.intervention_motif_absence_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.intervention_motif_annulation_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.intervention_motif_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.intervention_observation_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.intervention_payeur_externe_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.intervention_pre_encaissement_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.intervention_stack_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.intervention_type_validation_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.mag_commande_histo_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.mag_etat_commande_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.mag_fermeture_meaux_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.mag_jour_exclusion_livraison_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.mag_ligne_commande_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.mag_statut_commande_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.option_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.mag_stock_mouvement_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.moyen_paiement_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.nature_gaz_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.observation_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.old_bloc_note_client_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.paiement_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.planning_agents_liste_idplanning_agents_liste_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.planning_conflit_idpln_conflit_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.planning_historique_modification_idplanning_historique_modifica CASCADE');
        $this->addSql('DROP SEQUENCE sav.planning_horaires_passage_idpln_horaires_passage_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.planning_initiative_detail_idpln_initiative_interv_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.planning_initiative_idplanning_initiative_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.planning_liste_agents_idpln_liste_agents_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_agent_blocage_idpln_agent_blocage_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_banque_image_idpln_banque_image_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_config_req_idpln_config_req_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_config_rub_idpln_config_rub_visite_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_config_visite_idpln_config_visite_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_controle_voiture_idpln_controle_voiture_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_droits_visite_idpln_droits_visite_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_formation_idpln_formation_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_formation_lieu_idpln_formation_lieu_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_formation_organisme_idpln_formation_organisme_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_groupe_utilisateurs_idpln_groupe_utilisateurs_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_groupes_droits_visite_idpln_groupes_droits_visite_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_groupes_idpln_groupes_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_jours_ouvres_idpln_jours_ouvres_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_maladie_idpln_maladie_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_motif_maladie_idpln_motif_maladie_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_motif_reserve_idpln_motif_reserve_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_parametres_idpln_parametres_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_reserve_idpln_reserve_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_reunion_idpln_reunion_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_reunion_lieu_idpln_reunion_lieu_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_reunion_ordre_jour_idpln_reunion_ordre_jour_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_test_idpln_test_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_test_intitule_idpln_test_intitule_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_test_lieu_idpln_test_lieu_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_transit_groupe_idpln_transit_groupe_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_transit_idpln_transit_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_transit_utilisateur_idpln_droits_transit_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_visite_exclusion_idpln_visite_exclusion_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_voiture_action_idpln_voiture_action_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.pln_voiture_lieu_idpln_voiture_lieu_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.privilege_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.produit_facture_affectation_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.produit_famille_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.produit_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.produit_photo_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.produit_tarif_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.produit_type_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.protection_sanitaire_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.puissance_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.raccordement_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.robinet_remplissage_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.secteur_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.secteur_activite_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.secteur_tarif_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.secteur_taux_retour_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.sectorisation_version_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.stock_standard_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.stock_standard_produit_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.tarif_option_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.type_adresse_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.type_client_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.type_complement_adresse_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.type_complement_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.type_demandeur_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.type_envoi_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.type_logement_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.type_visite_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.type_zone_id_seq CASCADE');
        $this->addSql('CREATE SEQUENCE agent_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE category_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE category_pro_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE client_mail_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.droit_portail_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE email_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE famille_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.groupe_droit_portail_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE options_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE regle_attachement_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE regle_attachement_profil_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE taux_tva_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE type_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE type_agent_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE type_intervention_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE type_sav_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE TABLE agent (id INT NOT NULL, type_agent_id INT NOT NULL, responsable_id INT DEFAULT NULL, code_agent VARCHAR(10) NOT NULL, nom_agent VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX IDX_268B9C9DF9EB56F7 ON agent (type_agent_id)');
        $this->addSql('CREATE INDEX IDX_268B9C9D53C59D72 ON agent (responsable_id)');
        $this->addSql('CREATE TABLE category (id INT NOT NULL, libelle VARCHAR(255) NOT NULL, age INT NOT NULL, plus_value DOUBLE PRECISION NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE category_pro (id INT NOT NULL, libelle VARCHAR(255) NOT NULL, position INT NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE client (id INT NOT NULL, type_id INT NOT NULL, nom VARCHAR(255) NOT NULL, prenom VARCHAR(255) DEFAULT NULL, adresse VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX IDX_C7440455C54C8C93 ON client (type_id)');
        $this->addSql('CREATE TABLE client_mail (id INT NOT NULL, client_id INT NOT NULL, email VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX IDX_80BA6F2A19EB6921 ON client_mail (client_id)');
        $this->addSql('CREATE TABLE client_tel (id INT NOT NULL, client_id INT NOT NULL, numero VARCHAR(10) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX IDX_D79338AB19EB6921 ON client_tel (client_id)');
        $this->addSql('CREATE TABLE sav.droit_portail (id INT NOT NULL, idgroupe_droit_portail INT NOT NULL, libelle VARCHAR(50) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX IDX_49B67F44AB90823C ON sav.droit_portail (idgroupe_droit_portail)');
        $this->addSql('CREATE TABLE email (id INT NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE equipement (id INT NOT NULL, client_id INT NOT NULL, identifiant_equipement VARCHAR(14) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX IDX_B8B4C6F319EB6921 ON equipement (client_id)');
        $this->addSql('CREATE TABLE famille (id INT NOT NULL, libelle VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.groupe_droit_portail (id INT NOT NULL, libelle VARCHAR(100) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE intervention (id INT NOT NULL, agent_id INT DEFAULT NULL, equipement_id INT NOT NULL, type_intervention_id INT NOT NULL, date_int DATE DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX IDX_D11814AB3414710B ON intervention (agent_id)');
        $this->addSql('CREATE INDEX IDX_D11814AB806F0F5C ON intervention (equipement_id)');
        $this->addSql('CREATE INDEX IDX_D11814AB799AAC17 ON intervention (type_intervention_id)');
        $this->addSql('CREATE TABLE observation (id INT NOT NULL, libelle VARCHAR(255) NOT NULL, position INT NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE "option" (id INT NOT NULL, designation VARCHAR(255) NOT NULL, libelle VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE options (id INT NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE puissance (id INT NOT NULL, libelle INT NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE regle_attachement (id INT NOT NULL, libelle VARCHAR(255) NOT NULL, valeur DOUBLE PRECISION NOT NULL, position INT NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE regle_attachement_profil (id INT NOT NULL, profil VARCHAR(255) NOT NULL, plafond INT NOT NULL, coefficient DOUBLE PRECISION NOT NULL, position INT NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE taux_tva (id INT NOT NULL, taux DOUBLE PRECISION NOT NULL, libelle VARCHAR(255) NOT NULL, etat VARCHAR(10) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE type (id INT NOT NULL, famille_produit_id INT NOT NULL, modele VARCHAR(255) NOT NULL, libelle VARCHAR(255) NOT NULL, controle_du_co BOOLEAN NOT NULL, date_debut DATE DEFAULT NULL, date_fin DATE DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX IDX_8CDE5729FBC0E351 ON type (famille_produit_id)');
        $this->addSql('CREATE TABLE type_agent (id INT NOT NULL, libelle VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE type_client (id INT NOT NULL, libelle VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE type_intervention (id INT NOT NULL, libelle VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE type_sav (id INT NOT NULL, libelle VARCHAR(15) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('ALTER TABLE agent ADD CONSTRAINT FK_268B9C9DF9EB56F7 FOREIGN KEY (type_agent_id) REFERENCES type_agent (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE agent ADD CONSTRAINT FK_268B9C9D53C59D72 FOREIGN KEY (responsable_id) REFERENCES agent (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE client ADD CONSTRAINT FK_C7440455C54C8C93 FOREIGN KEY (type_id) REFERENCES type_client (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE client_mail ADD CONSTRAINT FK_80BA6F2A19EB6921 FOREIGN KEY (client_id) REFERENCES client (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE client_tel ADD CONSTRAINT FK_D79338AB19EB6921 FOREIGN KEY (client_id) REFERENCES client (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.droit_portail ADD CONSTRAINT FK_49B67F44AB90823C FOREIGN KEY (idgroupe_droit_portail) REFERENCES sav.groupe_droit_portail (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE equipement ADD CONSTRAINT FK_B8B4C6F319EB6921 FOREIGN KEY (client_id) REFERENCES client (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE intervention ADD CONSTRAINT FK_D11814AB3414710B FOREIGN KEY (agent_id) REFERENCES agent (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE intervention ADD CONSTRAINT FK_D11814AB806F0F5C FOREIGN KEY (equipement_id) REFERENCES equipement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE intervention ADD CONSTRAINT FK_D11814AB799AAC17 FOREIGN KEY (type_intervention_id) REFERENCES type_intervention (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE type ADD CONSTRAINT FK_8CDE5729FBC0E351 FOREIGN KEY (famille_produit_id) REFERENCES famille (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('DROP TABLE sav.mag_type_commande');
        $this->addSql('DROP TABLE sav.mag_stock_mouvement');
        $this->addSql('DROP TABLE sav.attachement_periode_froid');
        $this->addSql('DROP TABLE sav.produit_famille');
        $this->addSql('DROP TABLE sav.produit_stock_site');
        $this->addSql('DROP TABLE sav.sectorisation_version');
        $this->addSql('DROP TABLE sav.stock_standard');
        $this->addSql('DROP TABLE sav.option');
        $this->addSql('DROP TABLE sav.tarif_option');
        $this->addSql('DROP TABLE sav.intervention_message_co');
        $this->addSql('DROP TABLE sav.contrat');
        $this->addSql('DROP TABLE sav.intervention_type_validation');
        $this->addSql('DROP TABLE sav.mag_fermeture_meaux');
        $this->addSql('DROP TABLE sav.mag_statut_commande');
        $this->addSql('DROP TABLE sav.observation');
        $this->addSql('DROP TABLE sav.parametre');
        $this->addSql('DROP TABLE sav.pln_banque_image');
        $this->addSql('DROP TABLE sav.pln_jours_ouvres');
        $this->addSql('DROP TABLE sav.facture_ligne');
        $this->addSql('DROP TABLE sav.facture_relance');
        $this->addSql('DROP TABLE sav.intervention');
        $this->addSql('DROP TABLE sav.mag_commande_histo');
        $this->addSql('DROP TABLE sav.mag_jour_exclusion_livraison');
        $this->addSql('DROP TABLE sav.mag_ligne_commande');
        $this->addSql('DROP TABLE sav.paiement');
        $this->addSql('DROP TABLE sav.produit_photo');
        $this->addSql('DROP TABLE sav.produit_tarif');
        $this->addSql('DROP TABLE sav.secteur');
        $this->addSql('DROP TABLE sav.stock_standard_produit');
        $this->addSql('DROP TABLE sav.adresse_complement');
        $this->addSql('DROP TABLE sav.agent_appareil');
        $this->addSql('DROP TABLE sav.agent_gps');
        $this->addSql('DROP TABLE sav.agent_qualification');
        $this->addSql('DROP TABLE sav.agent_secteur');
        $this->addSql('DROP TABLE sav.aide_technique_histo');
        $this->addSql('DROP TABLE sav.communication_client');
        $this->addSql('DROP TABLE sav.contrat_proposition');
        $this->addSql('DROP TABLE sav.contrat_relance');
        $this->addSql('DROP TABLE sav.courrier_client');
        $this->addSql('DROP TABLE sav.devis');
        $this->addSql('DROP TABLE sav.equipement');
        $this->addSql('DROP TABLE sav.equipement_mesure');
        $this->addSql('DROP TABLE sav.historique_modification');
        $this->addSql('DROP TABLE sav.intervention_anomalie');
        $this->addSql('DROP TABLE sav.intervention_documents');
        $this->addSql('DROP TABLE sav.intervention_media');
        $this->addSql('DROP TABLE sav.intervention_observation');
        $this->addSql('DROP TABLE sav.intervention_payeur_externe');
        $this->addSql('DROP TABLE sav.intervention_pre_encaissement');
        $this->addSql('DROP TABLE sav.intervention_retour');
        $this->addSql('DROP TABLE sav.intervention_stack');
        $this->addSql('DROP TABLE sav.planning');
        $this->addSql('DROP TABLE sav.planning_agents_liste');
        $this->addSql('DROP TABLE sav.planning_conflit');
        $this->addSql('DROP TABLE sav.planning_historique_modification');
        $this->addSql('DROP TABLE sav.pln_agent_blocage');
        $this->addSql('DROP TABLE sav.pln_droits_visite');
        $this->addSql('DROP TABLE sav.pln_groupe_utilisateurs');
        $this->addSql('DROP TABLE sav.pln_transit');
        $this->addSql('DROP TABLE sav.pln_transit_utilisateur');
        $this->addSql('DROP TABLE sav.pln_visite_exclusion');
        $this->addSql('DROP TABLE sav.privilege');
        $this->addSql('DROP TABLE sav.secteur_equipement');
        $this->addSql('DROP TABLE sav.agent_produit_stock');
        $this->addSql('DROP TABLE sav.adresse');
        $this->addSql('DROP TABLE sav.aide_technique');
        $this->addSql('DROP TABLE sav.type_complement_adresse');
        $this->addSql('DROP TABLE sav.client');
        $this->addSql('DROP TABLE sav.type_adresse');
        $this->addSql('DROP TABLE sav.type_logement');
        $this->addSql('DROP TABLE sav.appareil');
        $this->addSql('DROP TABLE sav.demande_documentation');
        $this->addSql('DROP TABLE sav.equipement_famille');
        $this->addSql('DROP TABLE sav.aide_technique_classification_liste');
        $this->addSql('DROP TABLE sav.aide_technique_etat');
        $this->addSql('DROP TABLE sav.type_demandeur');
        $this->addSql('DROP TABLE sav.attachement_parametre_liste');
        $this->addSql('DROP TABLE sav.attachement_parametre');
        $this->addSql('DROP TABLE sav.type_visite');
        $this->addSql('DROP TABLE sav.attachement_type_visite');
        $this->addSql('DROP TABLE sav.classe_energetique');
        $this->addSql('DROP TABLE sav.classification_energetique');
        $this->addSql('DROP TABLE sav.classe_rendement');
        $this->addSql('DROP TABLE sav.equipement_type');
        $this->addSql('DROP TABLE sav.etat_civil');
        $this->addSql('DROP TABLE sav.client_email');
        $this->addSql('DROP TABLE sav.categorie_pro');
        $this->addSql('DROP TABLE sav.compte_client_web');
        $this->addSql('DROP TABLE sav.type_client');
        $this->addSql('DROP TABLE sav.client_tel');
        $this->addSql('DROP TABLE sav.facture');
        $this->addSql('DROP TABLE sav.communication_canal');
        $this->addSql('DROP TABLE sav.communication_type');
        $this->addSql('DROP TABLE sav.produit');
        $this->addSql('DROP TABLE sav.contrat_motif_resiliation');
        $this->addSql('DROP TABLE sav.contrat_type');
        $this->addSql('DROP TABLE sav.equipement_complement');
        $this->addSql('DROP TABLE sav.contrat_tarif');
        $this->addSql('DROP TABLE sav.puissance');
        $this->addSql('DROP TABLE sav.equipement_zone');
        $this->addSql('DROP TABLE sav.type_complement');
        $this->addSql('DROP TABLE sav.groupe_type');
        $this->addSql('DROP TABLE sav.equipement_local');
        $this->addSql('DROP TABLE sav.installateur');
        $this->addSql('DROP TABLE sav.nature_gaz');
        $this->addSql('DROP TABLE sav.protection_sanitaire');
        $this->addSql('DROP TABLE sav.raccordement');
        $this->addSql('DROP TABLE sav.robinet_remplissage');
        $this->addSql('DROP TABLE sav.equipement_tranche');
        $this->addSql('DROP TABLE sav.historique_client_equipement');
        $this->addSql('DROP TABLE sav.type_zone');
        $this->addSql('DROP TABLE sav.categorie_facture');
        $this->addSql('DROP TABLE sav.facture_type');
        $this->addSql('DROP TABLE sav.produit_facture_affectation');
        $this->addSql('DROP TABLE sav.mag_commande');
        $this->addSql('DROP TABLE sav.intervention_annulation');
        $this->addSql('DROP TABLE sav.intervention_motif_abandon');
        $this->addSql('DROP TABLE sav.intervention_motif_absence');
        $this->addSql('DROP TABLE sav.intervention_motif_annulation');
        $this->addSql('DROP TABLE sav.anomalie');
        $this->addSql('DROP TABLE sav.intervention_motif');
        $this->addSql('DROP TABLE sav.type_envoi');
        $this->addSql('DROP TABLE sav.old_bloc_note_client');
        $this->addSql('DROP TABLE sav.moyen_paiement');
        $this->addSql('DROP TABLE sav.mag_etat_commande');
        $this->addSql('DROP TABLE sav.aide_technique_classification');
        $this->addSql('DROP TABLE sav.retour');
        $this->addSql('DROP TABLE sav.planning_liste_agents');
        $this->addSql('DROP TABLE sav.planning_action');
        $this->addSql('DROP TABLE sav.planning_initiative_detail');
        $this->addSql('DROP TABLE sav.pln_controle_voiture');
        $this->addSql('DROP TABLE sav.pln_formation');
        $this->addSql('DROP TABLE sav.pln_maladie');
        $this->addSql('DROP TABLE sav.pln_reserve');
        $this->addSql('DROP TABLE sav.pln_reunion');
        $this->addSql('DROP TABLE sav.pln_test');
        $this->addSql('DROP TABLE sav.moment_passage');
        $this->addSql('DROP TABLE sav.pln_horaires_passage');
        $this->addSql('DROP TABLE sav.pln_initiative_type');
        $this->addSql('DROP TABLE sav.pln_parametres');
        $this->addSql('DROP TABLE sav.pln_config_req');
        $this->addSql('DROP TABLE sav.pln_config_rub');
        $this->addSql('DROP TABLE sav.pln_config_visite');
        $this->addSql('DROP TABLE sav.pln_voiture_action');
        $this->addSql('DROP TABLE sav.pln_voiture_lieu');
        $this->addSql('DROP TABLE sav.formation');
        $this->addSql('DROP TABLE sav.pln_formation_lieu');
        $this->addSql('DROP TABLE sav.pln_formation_organisme');
        $this->addSql('DROP TABLE sav.pln_groupes');
        $this->addSql('DROP TABLE sav.pln_groupes_droits_visite');
        $this->addSql('DROP TABLE sav.pln_motif_maladie');
        $this->addSql('DROP TABLE sav.privilege_raison_refus');
        $this->addSql('DROP TABLE sav.pln_motif_reserve');
        $this->addSql('DROP TABLE sav.pln_reunion_lieu');
        $this->addSql('DROP TABLE sav.pln_reunion_ordre_jour');
        $this->addSql('DROP TABLE sav.pln_test_intitule');
        $this->addSql('DROP TABLE sav.pln_test_lieu');
        $this->addSql('DROP TABLE sav.pln_transit_groupe');
        $this->addSql('DROP TABLE sav.privilege_statut');
        $this->addSql('DROP TABLE sav.produit_type');
        $this->addSql('DROP TABLE sav.type_retour');
        $this->addSql('DROP TABLE sav.secteur_activite');
        $this->addSql('DROP TABLE sav.secteur_tarif');
        $this->addSql('DROP TABLE sav.secteur_taux_retour');
        $this->addSql('DROP TABLE sav.tva_equipement');
        $this->addSql('DROP TABLE sav.taux_tva');
        $this->addSql('DROP TABLE sav.type_visite_appareil');
        $this->addSql('DROP TABLE sav.visite_categorie');
        $this->addSql('DROP TABLE sav.equipement_groupe');
        $this->addSql('DROP TABLE sav.equipement_option');
        $this->addSql('DROP INDEX agence_idsite_key');
        $this->addSql('DROP INDEX agence_num_agence_key');
        $this->addSql('ALTER TABLE sav.agence ALTER id TYPE INT');
        $this->addSql('ALTER TABLE sav.agence ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.agence ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.agence ALTER idsite TYPE INT');
        $this->addSql('ALTER TABLE sav.agence ALTER idsite DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.agence ALTER idsite SET NOT NULL');
        $this->addSql('ALTER TABLE sav.agence ALTER num DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.agence ALTER privilege DROP DEFAULT');
        $this->addSql('CREATE INDEX IDX_955222D6BA8CF844 ON sav.agence (idsite)');
        $this->addSql('ALTER TABLE sav.attachement_profil ALTER id TYPE INT');
        $this->addSql('ALTER TABLE sav.attachement_profil ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.attachement_profil ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.attachement_profil ALTER idutilisateur_profil TYPE INT');
        $this->addSql('ALTER TABLE sav.attachement_profil ALTER idutilisateur_profil DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.attachement_profil ALTER idutilisateur_profil SET NOT NULL');
        $this->addSql('ALTER TABLE sav.attachement_profil ALTER plafond_point DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.attachement_profil ALTER coefficient DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.attachement_profil ALTER valeur_point DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.attachement_profil ALTER annee DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.attachement_profil ALTER semestre DROP DEFAULT');
        $this->addSql('ALTER INDEX sav.idx_attachement_profil_idutilisateur_profil RENAME TO IDX_162ABF41BAE956EB');
        $this->addSql('ALTER TABLE sav.motif_temps_partiel ALTER id TYPE INT');
        $this->addSql('ALTER TABLE sav.motif_temps_partiel ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.motif_temps_partiel ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.motif_temps_partiel ALTER libelle SET NOT NULL');
        $this->addSql('ALTER TABLE sav.pole_site ALTER id TYPE INT');
        $this->addSql('ALTER TABLE sav.pole_site ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.pole_site ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.pole_site ALTER idsite TYPE INT');
        $this->addSql('ALTER TABLE sav.pole_site ALTER idsite DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.pole_site ALTER libelle SET NOT NULL');
        $this->addSql('ALTER INDEX sav.idx_pole_site_idsite RENAME TO IDX_E3BD9A24BA8CF844');
        $this->addSql('DROP INDEX site_num_key');
        $this->addSql('ALTER TABLE sav.site ALTER id TYPE INT');
        $this->addSql('ALTER TABLE sav.site ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.site ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.site ALTER num DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.site ALTER antenne DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.tchat_groupe ALTER id TYPE INT');
        $this->addSql('ALTER TABLE sav.tchat_groupe ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.tchat_groupe ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.tchat_groupe ALTER idtchat_groupe_type TYPE INT');
        $this->addSql('ALTER TABLE sav.tchat_groupe ALTER idtchat_groupe_type DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.tchat_groupe ALTER idtchat_groupe_type SET NOT NULL');
        $this->addSql('ALTER TABLE sav.tchat_groupe ALTER idsite TYPE INT');
        $this->addSql('ALTER TABLE sav.tchat_groupe ALTER idsite DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.tchat_groupe ALTER idutilisateur_admin_groupe TYPE INT');
        $this->addSql('ALTER TABLE sav.tchat_groupe ALTER idutilisateur_admin_groupe DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.tchat_groupe ALTER nom TYPE VARCHAR(255)');
        $this->addSql('ALTER INDEX sav.idx_tchat_groupe_idtchat_groupe_type RENAME TO IDX_954BDD6463E7AC37');
        $this->addSql('ALTER INDEX sav.idx_tchat_groupe_idutilisateur_admin_groupe RENAME TO IDX_954BDD64352B2E5E');
        $this->addSql('ALTER INDEX sav.idx_tchat_groupe_idsite RENAME TO IDX_954BDD64BA8CF844');
        $this->addSql('ALTER TABLE sav.tchat_groupe_type ALTER id TYPE INT');
        $this->addSql('ALTER TABLE sav.tchat_groupe_type ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.tchat_groupe_type ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.tchat_groupe_type ALTER libelle SET NOT NULL');
        $this->addSql('ALTER TABLE sav.tchat_groupe_type ALTER libelle TYPE VARCHAR(255)');
        $this->addSql('ALTER TABLE sav.tchat_groupe_utilisateur ALTER idutilisateur TYPE INT');
        $this->addSql('ALTER TABLE sav.tchat_groupe_utilisateur ALTER idutilisateur DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.tchat_groupe_utilisateur ALTER idtchat_groupe TYPE INT');
        $this->addSql('ALTER TABLE sav.tchat_groupe_utilisateur ALTER idtchat_groupe DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.tchat_groupe_utilisateur ALTER notification DROP DEFAULT');
        $this->addSql('ALTER INDEX sav.idx_tchat_groupe_utilisateur_idutilisateur RENAME TO IDX_4A66D8A0DBDD131C');
        $this->addSql('ALTER INDEX sav.idx_tchat_groupe_utilisateur_idtchat_groupe RENAME TO IDX_4A66D8A012D40901');
        $this->addSql('ALTER TABLE sav.tchat_message ALTER id TYPE INT');
        $this->addSql('ALTER TABLE sav.tchat_message ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.tchat_message ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.tchat_message ALTER idutilisateur TYPE INT');
        $this->addSql('ALTER TABLE sav.tchat_message ALTER idutilisateur DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.tchat_message ALTER idtchat_groupe TYPE INT');
        $this->addSql('ALTER TABLE sav.tchat_message ALTER idtchat_groupe DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.tchat_message ALTER contenu SET NOT NULL');
        $this->addSql('ALTER INDEX sav.idx_tchat_message_idutilisateur RENAME TO IDX_B09A7731DBDD131C');
        $this->addSql('ALTER INDEX sav.idx_tchat_message_idtchat_groupe RENAME TO IDX_B09A773112D40901');
        $this->addSql('ALTER TABLE sav.type_email ALTER id TYPE INT');
        $this->addSql('ALTER TABLE sav.type_email ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.type_email ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.type_email ALTER libelle SET NOT NULL');
        $this->addSql('ALTER TABLE sav.type_email ALTER libelle TYPE VARCHAR(20)');
        $this->addSql('ALTER TABLE sav.type_login ALTER id TYPE INT');
        $this->addSql('ALTER TABLE sav.type_login ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.type_login ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.type_tel ALTER id TYPE INT');
        $this->addSql('ALTER TABLE sav.type_tel ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.type_tel ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.type_tel ALTER libelle SET NOT NULL');
        $this->addSql('ALTER TABLE sav.type_utilisateur ALTER id TYPE INT');
        $this->addSql('ALTER TABLE sav.type_utilisateur ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.type_utilisateur ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.type_utilisateur ALTER libelle SET NOT NULL');
        $this->addSql('ALTER TABLE sav.utilisateur DROP CONSTRAINT utilisateur_role');
        $this->addSql('DROP INDEX fki_utilisateur_role');
        $this->addSql('DROP INDEX utilisateur_code_client_agi_key');
        $this->addSql('ALTER TABLE sav.utilisateur DROP role_id');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER id TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idtype_login TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idtype_login DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idtype_login SET NOT NULL');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idtype_utilisateur TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idtype_utilisateur DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idtype_utilisateur SET NOT NULL');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idutilisateur_responsable TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idutilisateur_responsable DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idutilisateur_valide_conges TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idutilisateur_valide_conges DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idpole_site TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idpole_site DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idagence TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idagence DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER nom TYPE VARCHAR(255)');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER prenom TYPE VARCHAR(255)');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER password TYPE VARCHAR(255)');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER cle_salage TYPE VARCHAR(64)');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER url_homepage TYPE VARCHAR(255)');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER date_embauche TYPE DATE');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER date_embauche DROP DEFAULT');
        $this->addSql('CREATE UNIQUE INDEX UNIQ_4CAAA48DAA08CB10 ON sav.utilisateur (login)');
        $this->addSql('ALTER INDEX sav.idx_utilisateur_idtype_login RENAME TO IDX_4CAAA48D69AD51DD');
        $this->addSql('ALTER INDEX sav.idx_utilisateur_idtype_utilisateur RENAME TO IDX_4CAAA48DC2809046');
        $this->addSql('ALTER INDEX sav.idx_utilisateur_idutilisateur_responsable RENAME TO IDX_4CAAA48DE546653');
        $this->addSql('ALTER INDEX sav.idx_utilisateur_idutilisateur_valide_conges RENAME TO IDX_4CAAA48D4BE50ACF');
        $this->addSql('ALTER INDEX sav.idx_utilisateur_idpole_site RENAME TO IDX_4CAAA48D8711FA03');
        $this->addSql('ALTER INDEX sav.idx_utilisateur_idagence RENAME TO IDX_4CAAA48D7C3705');
        $this->addSql('ALTER TABLE sav.utilisateur_adresse ALTER id TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur_adresse ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_adresse ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_adresse ALTER idutilisateur TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur_adresse ALTER idutilisateur DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_adresse ALTER idutilisateur SET NOT NULL');
        $this->addSql('ALTER TABLE sav.utilisateur_adresse ALTER longitude DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_adresse ALTER latitude DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_adresse ALTER actif DROP DEFAULT');
        $this->addSql('ALTER INDEX sav.idx_utilisateur_adresse_idutilisateur RENAME TO IDX_E94909DDDBDD131C');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER id TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idutilisateur TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idutilisateur DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idutilisateur SET NOT NULL');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idutilisateur_profil TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idutilisateur_profil DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idutilisateur_planning TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idutilisateur_planning DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idutilisateur_responsable TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idutilisateur_responsable DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idpole_site TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idpole_site DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idmotif_temps_partiel TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idmotif_temps_partiel DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idutilisateur_binome TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idutilisateur_binome DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER planifiable DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER temps_travail DROP DEFAULT');
        $this->addSql('ALTER INDEX sav.idx_utilisateur_affectation_idutilisateur RENAME TO IDX_93701EE2DBDD131C');
        $this->addSql('ALTER INDEX sav.idx_utilisateur_affectation_idutilisateur_profil RENAME TO IDX_93701EE2BAE956EB');
        $this->addSql('ALTER INDEX sav.idx_utilisateur_affectation_idutilisateur_planning RENAME TO IDX_93701EE2F074F352');
        $this->addSql('ALTER INDEX sav.idx_utilisateur_affectation_idutilisateur_responsable RENAME TO IDX_93701EE2E546653');
        $this->addSql('ALTER INDEX sav.idx_utilisateur_affectation_idpole_site RENAME TO IDX_93701EE28711FA03');
        $this->addSql('ALTER INDEX sav.idx_utilisateur_affectation_idutilisateur_binome RENAME TO IDX_93701EE2491A72A2');
        $this->addSql('ALTER INDEX sav.idx_utilisateur_affectation_idmotif_temps_partiel RENAME TO IDX_93701EE2E7B859F3');
        $this->addSql('ALTER TABLE sav.utilisateur_email ALTER id TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur_email ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_email ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_email ALTER idutilisateur TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur_email ALTER idutilisateur DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_email ALTER idutilisateur SET NOT NULL');
        $this->addSql('ALTER TABLE sav.utilisateur_email ALTER idtype_email TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur_email ALTER idtype_email DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_email ALTER idtype_email SET NOT NULL');
        $this->addSql('ALTER INDEX sav.idx_utilisateur_email_idutilisateur RENAME TO IDX_1175237DDBDD131C');
        $this->addSql('ALTER INDEX sav.idx_utilisateur_email_idtype_email RENAME TO IDX_1175237D2437E6B9');
        $this->addSql('ALTER TABLE sav.utilisateur_filtre ALTER id TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur_filtre ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_filtre ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_filtre ALTER idutilisateur TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur_filtre ALTER idutilisateur DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_filtre ALTER idutilisateur SET NOT NULL');
        $this->addSql('ALTER TABLE sav.utilisateur_filtre ALTER page TYPE VARCHAR(255)');
        $this->addSql('ALTER TABLE sav.utilisateur_profil ALTER id TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur_profil ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_profil ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_profil ALTER libelle SET NOT NULL');
        $this->addSql('ALTER TABLE sav.utilisateur_profil ALTER calcul_attachement SET NOT NULL');
        $this->addSql('ALTER TABLE sav.utilisateur_role ALTER id TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur_role ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_site ALTER idutilisateur TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur_site ALTER idutilisateur DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_site ALTER idsite TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur_site ALTER idsite DROP DEFAULT');
        $this->addSql('ALTER INDEX sav.idx_utilisateur_site_idutilisateur RENAME TO IDX_373A5B31DBDD131C');
        $this->addSql('ALTER INDEX sav.idx_utilisateur_site_idsite RENAME TO IDX_373A5B31BA8CF844');
        $this->addSql('ALTER TABLE sav.utilisateur_tel ALTER id TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur_tel ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_tel ALTER id DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_tel ALTER idutilisateur TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur_tel ALTER idutilisateur DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_tel ALTER idutilisateur SET NOT NULL');
        $this->addSql('ALTER TABLE sav.utilisateur_tel ALTER idtype_tel TYPE INT');
        $this->addSql('ALTER TABLE sav.utilisateur_tel ALTER idtype_tel DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_tel ALTER idtype_tel SET NOT NULL');
        $this->addSql('ALTER TABLE sav.utilisateur_tel ALTER priorite DROP DEFAULT');
        $this->addSql('ALTER INDEX sav.idx_utilisateur_tel_idutilisateur RENAME TO IDX_579C7077DBDD131C');
        $this->addSql('ALTER INDEX sav.idx_utilisateur_tel_idtype_tel RENAME TO IDX_579C707758F505E3');
    }

    public function down(Schema $schema): void
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->addSql('CREATE SCHEMA public');
        $this->addSql('ALTER TABLE agent DROP CONSTRAINT FK_268B9C9D53C59D72');
        $this->addSql('ALTER TABLE intervention DROP CONSTRAINT FK_D11814AB3414710B');
        $this->addSql('ALTER TABLE client_mail DROP CONSTRAINT FK_80BA6F2A19EB6921');
        $this->addSql('ALTER TABLE client_tel DROP CONSTRAINT FK_D79338AB19EB6921');
        $this->addSql('ALTER TABLE equipement DROP CONSTRAINT FK_B8B4C6F319EB6921');
        $this->addSql('ALTER TABLE intervention DROP CONSTRAINT FK_D11814AB806F0F5C');
        $this->addSql('ALTER TABLE type DROP CONSTRAINT FK_8CDE5729FBC0E351');
        $this->addSql('ALTER TABLE sav.droit_portail DROP CONSTRAINT FK_49B67F44AB90823C');
        $this->addSql('ALTER TABLE agent DROP CONSTRAINT FK_268B9C9DF9EB56F7');
        $this->addSql('ALTER TABLE client DROP CONSTRAINT FK_C7440455C54C8C93');
        $this->addSql('ALTER TABLE intervention DROP CONSTRAINT FK_D11814AB799AAC17');
        $this->addSql('DROP SEQUENCE agent_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE category_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE category_pro_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE client_mail_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.droit_portail_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE email_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE famille_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.groupe_droit_portail_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE options_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE regle_attachement_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE regle_attachement_profil_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE taux_tva_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE type_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE type_agent_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE type_intervention_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE type_sav_id_seq CASCADE');
        $this->addSql('CREATE SEQUENCE sav.adresse_complement_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.adresse_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.privilege_raison_refus_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.agent_gps_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.retour_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.aide_technique_classification_liste_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.aide_technique_histo_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.appareil_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.attachement_parametre_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.attachement_parametre_liste_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.attachement_periode_froid_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.mag_type_commande_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.moment_passage_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.attachement_type_visite_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.categorie_facture_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.categorie_pro_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.classification_energetique_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.client_email_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.client_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.client_tel_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.communication_canal_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.communication_client_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.communication_type_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.compte_client_web_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.contrat_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.contrat_motif_resiliation_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.contrat_proposition_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.contrat_relance_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.contrat_tarif_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.contrat_type_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.courrier_client_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.demande_documentation_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.devis_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.equipement_option_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.equipement_famille_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.equipement_groupe_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.equipement_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.equipement_tranche_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.equipement_type_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.facture_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.facture_ligne_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.facture_relance_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.facture_type_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.formation_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.groupe_type_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.historique_client_equipement_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.historique_modification_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.installateur_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.intervention_annulation_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.intervention_documents_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.intervention_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.intervention_media_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.intervention_message_co_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.intervention_motif_abandon_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.intervention_motif_absence_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.intervention_motif_annulation_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.intervention_motif_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.intervention_observation_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.intervention_payeur_externe_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.intervention_pre_encaissement_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.intervention_stack_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.intervention_type_validation_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.mag_commande_histo_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.mag_etat_commande_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.mag_fermeture_meaux_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.mag_jour_exclusion_livraison_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.mag_ligne_commande_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.mag_statut_commande_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.option_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.mag_stock_mouvement_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.moyen_paiement_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.nature_gaz_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.observation_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.old_bloc_note_client_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.paiement_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.planning_agents_liste_idplanning_agents_liste_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.planning_conflit_idpln_conflit_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.planning_historique_modification_idplanning_historique_modifica INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.planning_horaires_passage_idpln_horaires_passage_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.planning_initiative_detail_idpln_initiative_interv_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.planning_initiative_idplanning_initiative_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.planning_liste_agents_idpln_liste_agents_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_agent_blocage_idpln_agent_blocage_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_banque_image_idpln_banque_image_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_config_req_idpln_config_req_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_config_rub_idpln_config_rub_visite_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_config_visite_idpln_config_visite_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_controle_voiture_idpln_controle_voiture_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_droits_visite_idpln_droits_visite_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_formation_idpln_formation_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_formation_lieu_idpln_formation_lieu_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_formation_organisme_idpln_formation_organisme_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_groupe_utilisateurs_idpln_groupe_utilisateurs_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_groupes_droits_visite_idpln_groupes_droits_visite_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_groupes_idpln_groupes_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_jours_ouvres_idpln_jours_ouvres_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_maladie_idpln_maladie_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_motif_maladie_idpln_motif_maladie_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_motif_reserve_idpln_motif_reserve_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_parametres_idpln_parametres_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_reserve_idpln_reserve_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_reunion_idpln_reunion_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_reunion_lieu_idpln_reunion_lieu_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_reunion_ordre_jour_idpln_reunion_ordre_jour_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_test_idpln_test_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_test_intitule_idpln_test_intitule_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_test_lieu_idpln_test_lieu_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_transit_groupe_idpln_transit_groupe_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_transit_idpln_transit_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_transit_utilisateur_idpln_droits_transit_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_visite_exclusion_idpln_visite_exclusion_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_voiture_action_idpln_voiture_action_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.pln_voiture_lieu_idpln_voiture_lieu_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.privilege_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.produit_facture_affectation_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.produit_famille_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.produit_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.produit_photo_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.produit_tarif_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.produit_type_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.protection_sanitaire_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.puissance_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.raccordement_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.robinet_remplissage_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.secteur_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.secteur_activite_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.secteur_tarif_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.secteur_taux_retour_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.sectorisation_version_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.stock_standard_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.stock_standard_produit_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.tarif_option_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.type_adresse_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.type_client_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.type_complement_adresse_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.type_complement_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.type_demandeur_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.type_envoi_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.type_logement_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.type_visite_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.type_zone_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE TABLE sav.mag_type_commande (id BIGSERIAL NOT NULL, libelle VARCHAR(30) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.mag_stock_mouvement (id BIGSERIAL NOT NULL, idsite BIGINT DEFAULT 0, idproduit BIGINT DEFAULT NULL, idutilisateur BIGINT DEFAULT NULL, type_source VARCHAR(15) DEFAULT NULL, code_produit VARCHAR(15) DEFAULT NULL, source SMALLINT DEFAULT NULL, type_destination VARCHAR(15) DEFAULT NULL, destination SMALLINT DEFAULT NULL, quantite SMALLINT DEFAULT NULL, date_mouvement TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, motif_mouvement VARCHAR(2) DEFAULT NULL, commentaire VARCHAR(200) DEFAULT NULL, stock_modifie VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_mag_stock_mouvement_idproduit ON sav.mag_stock_mouvement (idproduit)');
        $this->addSql('CREATE INDEX idx_mag_stock_mouvement_idsite ON sav.mag_stock_mouvement (idsite)');
        $this->addSql('CREATE INDEX idx_mag_stock_mouvement_idutilisateur ON sav.mag_stock_mouvement (idutilisateur)');
        $this->addSql('CREATE TABLE sav.attachement_periode_froid (id BIGSERIAL NOT NULL, annee INT DEFAULT 0, semestre SMALLINT DEFAULT 0, mois SMALLINT DEFAULT 0, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.produit_famille (id BIGSERIAL NOT NULL, idsite BIGINT DEFAULT 0, code_famille_agi VARCHAR(4) DEFAULT \'0\' NOT NULL, commandable BOOLEAN DEFAULT \'false\', PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_produit_famille_idsite ON sav.produit_famille (idsite)');
        $this->addSql('CREATE INDEX idx_produit_famille_code_famille_agiidsite ON sav.produit_famille (code_famille_agi, idsite)');
        $this->addSql('CREATE TABLE sav.produit_stock_site (idsite BIGINT NOT NULL, idproduit BIGINT NOT NULL, proposition_technicien BOOLEAN DEFAULT \'false\', stock_mini SMALLINT DEFAULT 0, stock_reel INT DEFAULT 0, stock_theorique INT DEFAULT 0, gere_en_stock BOOLEAN DEFAULT \'false\', stock_reappro INT DEFAULT 0, emplacement VARCHAR(50) DEFAULT NULL, PRIMARY KEY(idsite, idproduit))');
        $this->addSql('CREATE INDEX idx_produit_stock_site_idsite ON sav.produit_stock_site (idsite)');
        $this->addSql('CREATE INDEX idx_produit_stock_site_idproduit ON sav.produit_stock_site (idproduit)');
        $this->addSql('CREATE TABLE sav.sectorisation_version (id BIGSERIAL NOT NULL, idsite BIGINT DEFAULT 0, idutilisateur BIGINT DEFAULT 0, date_debut DATE DEFAULT NULL, date_fin DATE DEFAULT NULL, date_modification TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, commentaire TEXT DEFAULT NULL, en_prod BOOLEAN DEFAULT \'false\', PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_sectorisation_version_idutilisateur ON sav.sectorisation_version (idutilisateur)');
        $this->addSql('CREATE INDEX idx_sectorisation_version_idsite ON sav.sectorisation_version (idsite)');
        $this->addSql('CREATE TABLE sav.stock_standard (id BIGSERIAL NOT NULL, idsite BIGINT DEFAULT 0, libelle VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_stock_standard_idsite ON sav.stock_standard (idsite)');
        $this->addSql('CREATE TABLE sav.option (id BIGSERIAL NOT NULL, libelle_court VARCHAR(30) DEFAULT NULL, libelle_long VARCHAR(100) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.tarif_option (id BIGSERIAL NOT NULL, idoption BIGINT DEFAULT NULL, idequipement_type BIGINT DEFAULT 0, idcontrat_type BIGINT DEFAULT NULL, tarif_ht NUMERIC(24, 6) DEFAULT \'0\', debut_application DATE DEFAULT NULL, fin_application DATE DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_tarif_option_idoption ON sav.tarif_option (idoption)');
        $this->addSql('CREATE INDEX idx_tarif_option_idcontrat_type ON sav.tarif_option (idcontrat_type)');
        $this->addSql('CREATE INDEX idx_tarif_option_idequipement_type ON sav.tarif_option (idequipement_type)');
        $this->addSql('CREATE TABLE sav.intervention_message_co (id BIGSERIAL NOT NULL, valeur_min INT DEFAULT 0, valeur_max INT DEFAULT 0, message VARCHAR(256) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.contrat (id BIGSERIAL NOT NULL, idequipement BIGINT DEFAULT 0, idcontrat_type BIGINT DEFAULT 0, idagent_souscription INT DEFAULT 0, idfacture BIGINT DEFAULT NULL, idcontrat_motif_resiliation BIGINT DEFAULT NULL, idclient BIGINT DEFAULT 0, edition BOOLEAN DEFAULT \'false\', coefficient NUMERIC(5, 2) DEFAULT \'0\', montant_ht NUMERIC(9, 2) DEFAULT \'0\', date_souscription TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, date_debut_contrat TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, date_fin_contrat TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, date_avis_echeance TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, date_paiement TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, date_resiliation DATE DEFAULT NULL, commentaire TEXT DEFAULT NULL, groupe INT DEFAULT 0, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_contrat_idfacture ON sav.contrat (idfacture)');
        $this->addSql('CREATE INDEX idx_contrat_idequipement ON sav.contrat (idequipement)');
        $this->addSql('CREATE INDEX idx_contrat_idcontrat_type ON sav.contrat (idcontrat_type)');
        $this->addSql('CREATE INDEX idx_contrat_idcontrat_motif_resiliation ON sav.contrat (idcontrat_motif_resiliation)');
        $this->addSql('CREATE INDEX idx_contrat_idclient ON sav.contrat (idclient)');
        $this->addSql('CREATE INDEX IDX_A07F668661333331 ON sav.contrat (idagent_souscription)');
        $this->addSql('CREATE TABLE sav.intervention_type_validation (id BIGSERIAL NOT NULL, libelle VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.mag_fermeture_meaux (id BIGSERIAL NOT NULL, date TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE UNIQUE INDEX mag_fermeture_meaux_date_key ON sav.mag_fermeture_meaux (date)');
        $this->addSql('CREATE TABLE sav.mag_statut_commande (id BIGSERIAL NOT NULL, libelle VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.observation (id BIGSERIAL NOT NULL, texte TEXT DEFAULT NULL, rang_tri SMALLINT DEFAULT 0, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.parametre (id BIGINT DEFAULT 0 NOT NULL, libelle VARCHAR(80) DEFAULT NULL, sequence BIGINT DEFAULT NULL, nom_utilisateur VARCHAR(50) DEFAULT NULL, valeur_alphanum VARCHAR(200) DEFAULT NULL, valeur_num NUMERIC(24, 6) DEFAULT NULL, note VARCHAR(200) DEFAULT NULL, regroupe_param VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.pln_banque_image (idpln_banque_image SERIAL NOT NULL, image BYTEA DEFAULT NULL, typeimage SMALLINT DEFAULT NULL, PRIMARY KEY(idpln_banque_image))');
        $this->addSql('CREATE TABLE sav.pln_jours_ouvres (idpln_jours_ouvres BIGSERIAL NOT NULL, date_jour TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, jour_ouvre SMALLINT DEFAULT NULL, PRIMARY KEY(idpln_jours_ouvres))');
        $this->addSql('CREATE TABLE sav.facture_ligne (id BIGSERIAL NOT NULL, idfacture BIGINT DEFAULT NULL, idproduit BIGINT DEFAULT NULL, idproduit_facture_affectation BIGINT DEFAULT NULL, code_article VARCHAR(15) DEFAULT NULL, designation VARCHAR(30) DEFAULT NULL, quantite SMALLINT DEFAULT NULL, pu_ht NUMERIC(24, 6) DEFAULT \'0\', taux_tva NUMERIC(24, 6) DEFAULT \'0\', remise INT DEFAULT 0, pu_ttc NUMERIC(24, 6) DEFAULT NULL, prix_total_ttc NUMERIC(24, 6) DEFAULT NULL, devise VARCHAR(1) DEFAULT NULL, motif_servcie VARCHAR(200) DEFAULT NULL, produit_conserve_client BOOLEAN DEFAULT \'false\', PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_facture_ligne_idproduit_facture_affectation ON sav.facture_ligne (idproduit_facture_affectation)');
        $this->addSql('CREATE INDEX idx_facture_ligne_idproduit ON sav.facture_ligne (idproduit)');
        $this->addSql('CREATE INDEX idx_facture_ligne_idfacture ON sav.facture_ligne (idfacture)');
        $this->addSql('CREATE TABLE sav.facture_relance (id BIGSERIAL NOT NULL, idfacture BIGINT DEFAULT NULL, date_relance TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_facture_relance_idfacture ON sav.facture_relance (idfacture)');
        $this->addSql('CREATE TABLE sav.intervention (id SERIAL NOT NULL, idplanning BIGINT NOT NULL, idequipement BIGINT DEFAULT NULL, idintervention_motif BIGINT DEFAULT 0, idtype_envoi_rapport BIGINT DEFAULT NULL, idcontrat BIGINT DEFAULT 0, idfacture BIGINT DEFAULT NULL, idtype_visite_init BIGINT DEFAULT 0, avis_passage BOOLEAN DEFAULT NULL, avis_passage_mail BOOLEAN DEFAULT \'false\', memo VARCHAR(200) DEFAULT NULL, temps SMALLINT DEFAULT NULL, bon_commande VARCHAR(8) DEFAULT NULL, horaire_a_controler BOOLEAN DEFAULT NULL, mesure_co SMALLINT DEFAULT NULL, observations TEXT DEFAULT NULL, attestation_entretien_signee BOOLEAN DEFAULT NULL, cgv_acceptees BOOLEAN DEFAULT NULL, commentaire_client TEXT DEFAULT NULL, motif_modif_code_int VARCHAR(200) DEFAULT NULL, cli_refus_signature BOOLEAN DEFAULT \'false\', commentaire_refus_signature VARCHAR(200) DEFAULT NULL, fiche_papier_liee INT DEFAULT NULL, encaissement_effectue SMALLINT DEFAULT NULL, idfiche_navette DOUBLE PRECISION DEFAULT \'0\', validation_technique_par VARCHAR(50) DEFAULT NULL, validation_technique_le TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, idtype_validation_technique SMALLINT DEFAULT 0, commentaire_technique TEXT DEFAULT NULL, validation_adm_par VARCHAR(50) DEFAULT NULL, validation_adm_le TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, idtype_validation_adm SMALLINT DEFAULT 0, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_intervention_idcontrat ON sav.intervention (idcontrat)');
        $this->addSql('CREATE INDEX idx_intervention_idtype_envoi_rapport ON sav.intervention (idtype_envoi_rapport)');
        $this->addSql('CREATE INDEX idx_intervention_idfacture ON sav.intervention (idfacture)');
        $this->addSql('CREATE INDEX idx_intervention_idequipement ON sav.intervention (idequipement)');
        $this->addSql('CREATE UNIQUE INDEX intervention_idplanning_key ON sav.intervention (idplanning)');
        $this->addSql('CREATE INDEX idx_intervention_idtype_visite_init ON sav.intervention (idtype_visite_init)');
        $this->addSql('CREATE INDEX idx_intervention_idtype_validation_adm ON sav.intervention (idtype_validation_adm)');
        $this->addSql('CREATE INDEX idx_intervention_idtype_validation_technique ON sav.intervention (idtype_validation_technique)');
        $this->addSql('CREATE INDEX idx_intervention_idintervention_motif ON sav.intervention (idintervention_motif)');
        $this->addSql('CREATE TABLE sav.mag_commande_histo (id BIGSERIAL NOT NULL, idmag_commande BIGINT DEFAULT NULL, idutilisateur BIGINT DEFAULT 0, idmag_etat_commande BIGINT DEFAULT NULL, date_heure TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, commentaire TEXT DEFAULT NULL, idmag_statut_commande SMALLINT DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_mag_commande_histo_idmag_statut_commande ON sav.mag_commande_histo (idmag_statut_commande)');
        $this->addSql('CREATE INDEX idx_mag_commande_histo_idutilisateur ON sav.mag_commande_histo (idutilisateur)');
        $this->addSql('CREATE INDEX idx_mag_commande_histo_idmag_etat_commande ON sav.mag_commande_histo (idmag_etat_commande)');
        $this->addSql('CREATE INDEX idx_mag_commande_histo_idmag_commande ON sav.mag_commande_histo (idmag_commande)');
        $this->addSql('CREATE TABLE sav.mag_jour_exclusion_livraison (id BIGSERIAL NOT NULL, idagence BIGINT DEFAULT NULL, jour_exclu SMALLINT DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_mag_jour_exclusion_livraison_idagence ON sav.mag_jour_exclusion_livraison (idagence)');
        $this->addSql('CREATE TABLE sav.mag_ligne_commande (id BIGSERIAL NOT NULL, idmag_commande BIGINT DEFAULT 0 NOT NULL, idproduit BIGINT DEFAULT NULL, code_produit VARCHAR(15) NOT NULL, designation VARCHAR(30) NOT NULL, qte_commandee BIGINT DEFAULT 0 NOT NULL, qte_livree BIGINT DEFAULT NULL, prix_ht NUMERIC(24, 6) DEFAULT \'0\' NOT NULL, anomalie SMALLINT DEFAULT 0, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_mag_ligne_commande_idproduit ON sav.mag_ligne_commande (idproduit)');
        $this->addSql('CREATE INDEX idx_mag_ligne_commande_idmag_commande ON sav.mag_ligne_commande (idmag_commande)');
        $this->addSql('CREATE TABLE sav.paiement (id BIGSERIAL NOT NULL, iddevis BIGINT DEFAULT NULL, idfacture BIGINT DEFAULT NULL, idmoyen_paiement BIGINT DEFAULT 0, montant_ttc NUMERIC(24, 6) DEFAULT \'0\', acompte BOOLEAN DEFAULT \'false\', date TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, date_previsionnelle DATE DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_paiement_iddevis ON sav.paiement (iddevis)');
        $this->addSql('CREATE INDEX idx_paiement_idmoyen_paiement ON sav.paiement (idmoyen_paiement)');
        $this->addSql('CREATE INDEX idx_paiement_idfacture ON sav.paiement (idfacture)');
        $this->addSql('CREATE TABLE sav.produit_photo (id BIGSERIAL NOT NULL, idproduit BIGINT DEFAULT NULL, photo BYTEA DEFAULT NULL, photo_principale BOOLEAN DEFAULT \'false\', PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_produit_photo_idproduit ON sav.produit_photo (idproduit)');
        $this->addSql('CREATE TABLE sav.produit_tarif (id BIGSERIAL NOT NULL, idproduit BIGINT DEFAULT 0, prix_ht NUMERIC(24, 6) DEFAULT \'0\', date_debut DATE DEFAULT NULL, date_fin DATE DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_produit_tarif_idproduit ON sav.produit_tarif (idproduit)');
        $this->addSql('CREATE TABLE sav.secteur (id BIGSERIAL NOT NULL, idsectorisation_version BIGINT DEFAULT 0, idsecteur_tarif BIGINT DEFAULT NULL, idsecteur_taux_retour BIGINT DEFAULT NULL, idsecteur_activite BIGINT DEFAULT NULL, idsecteur INT DEFAULT 0, nom VARCHAR(50) DEFAULT NULL, coordonnees JSON DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_secteur_idsecteur_version ON sav.secteur (idsecteur, idsectorisation_version)');
        $this->addSql('CREATE INDEX idx_secteur_idsecteur_activite ON sav.secteur (idsecteur_activite)');
        $this->addSql('CREATE INDEX idx_secteur_idsecteur_taux_retour ON sav.secteur (idsecteur_taux_retour)');
        $this->addSql('CREATE INDEX idx_secteur_idsectorisation_version ON sav.secteur (idsectorisation_version)');
        $this->addSql('CREATE INDEX idx_secteur_idsecteur_tarif ON sav.secteur (idsecteur_tarif)');
        $this->addSql('CREATE TABLE sav.stock_standard_produit (id BIGSERIAL NOT NULL, idstock_standard BIGINT DEFAULT NULL, idproduit BIGINT DEFAULT NULL, stock_theorique INT DEFAULT 0, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_stock_standard_produit_idproduit ON sav.stock_standard_produit (idproduit)');
        $this->addSql('CREATE INDEX idx_stock_standard_produit_idstock_standard ON sav.stock_standard_produit (idstock_standard)');
        $this->addSql('CREATE TABLE sav.adresse_complement (id BIGSERIAL NOT NULL, idadresse BIGINT DEFAULT NULL, idtype_complement_adresse BIGINT DEFAULT 0, valeur VARCHAR(50) DEFAULT NULL, commentaire_valeur TEXT DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_adresse_complement_idtype_complement_adresse ON sav.adresse_complement (idtype_complement_adresse)');
        $this->addSql('CREATE INDEX idx_adresse_complement_idadresse ON sav.adresse_complement (idadresse)');
        $this->addSql('CREATE TABLE sav.agent_appareil (idappareil INT DEFAULT 0 NOT NULL, idutilisateur_agent BIGINT DEFAULT 0 NOT NULL, date_delivrance DATE DEFAULT NULL, date_limite_renouvellement DATE DEFAULT NULL, reference VARCHAR(50) DEFAULT NULL, PRIMARY KEY(idappareil, idutilisateur_agent))');
        $this->addSql('CREATE INDEX idx_agent_appareil_idutilisateur_agent ON sav.agent_appareil (idutilisateur_agent)');
        $this->addSql('CREATE INDEX idx_agent_appareil_idappareil ON sav.agent_appareil (idappareil)');
        $this->addSql('CREATE TABLE sav.agent_gps (id BIGSERIAL NOT NULL, idutilisateur_agent BIGINT DEFAULT 0, date_heure TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, latitude DOUBLE PRECISION DEFAULT \'0\', longitude DOUBLE PRECISION DEFAULT \'0\', radius INT DEFAULT 0, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_agent_gps_idutilisateur_agent ON sav.agent_gps (idutilisateur_agent)');
        $this->addSql('CREATE TABLE sav.agent_qualification (idutilisateur_agent BIGINT DEFAULT 0 NOT NULL, idequipement_famille BIGINT DEFAULT 0 NOT NULL, PRIMARY KEY(idutilisateur_agent, idequipement_famille))');
        $this->addSql('CREATE INDEX idx_agent_qualification_idequipement_famille ON sav.agent_qualification (idequipement_famille)');
        $this->addSql('CREATE INDEX idx_agent_qualification_idutilisateur_agent ON sav.agent_qualification (idutilisateur_agent)');
        $this->addSql('CREATE TABLE sav.agent_secteur (idsecteur_version BIGINT NOT NULL, idutilisateur_agent BIGINT DEFAULT 0 NOT NULL, rang_tri SMALLINT DEFAULT 0, PRIMARY KEY(idsecteur_version, idutilisateur_agent))');
        $this->addSql('CREATE INDEX idx_agent_secteur_idutilisateur_agent ON sav.agent_secteur (idutilisateur_agent)');
        $this->addSql('CREATE INDEX idx_agent_secteur_idsecteur_version ON sav.agent_secteur (idsecteur_version)');
        $this->addSql('CREATE TABLE sav.aide_technique_histo (id BIGSERIAL NOT NULL, idaide_technique DOUBLE PRECISION DEFAULT \'0\', idutilisateur BIGINT DEFAULT 0, idaide_technique_etat DOUBLE PRECISION DEFAULT NULL, date_heure TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, commentaire TEXT DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_aide_technique_histo_idaide_technique ON sav.aide_technique_histo (idaide_technique)');
        $this->addSql('CREATE INDEX idx_aide_technique_histo_idutilisateur ON sav.aide_technique_histo (idutilisateur)');
        $this->addSql('CREATE INDEX idx_aide_technique_histo_idaide_technique_etat ON sav.aide_technique_histo (idaide_technique_etat)');
        $this->addSql('CREATE TABLE sav.communication_client (id BIGSERIAL NOT NULL, idclient BIGINT DEFAULT 0, idequipement BIGINT DEFAULT 0, idintervention BIGINT DEFAULT 0, idcommunication_canal BIGINT DEFAULT 0, idcommunication_type BIGINT DEFAULT 0, date_heure_envoi TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, date_heure_lecture TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, id_campagne VARCHAR(20) DEFAULT NULL, destination TEXT DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_communication_client_idclient ON sav.communication_client (idclient)');
        $this->addSql('CREATE INDEX idx_communication_client_idcommunication_type ON sav.communication_client (idcommunication_type)');
        $this->addSql('CREATE INDEX idx_communication_client_idintervention ON sav.communication_client (idintervention)');
        $this->addSql('CREATE INDEX idx_communication_client_idcommunication_canal ON sav.communication_client (idcommunication_canal)');
        $this->addSql('CREATE INDEX idx_communication_client_idequipement ON sav.communication_client (idequipement)');
        $this->addSql('CREATE TABLE sav.contrat_proposition (id BIGSERIAL NOT NULL, idcontrat BIGINT DEFAULT NULL, idcontrat_type BIGINT DEFAULT 0, montant_ht NUMERIC(9, 2) DEFAULT \'0\', PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_contrat_proposition_idcontrat_type ON sav.contrat_proposition (idcontrat_type)');
        $this->addSql('CREATE INDEX idx_contrat_proposition_idcontrat ON sav.contrat_proposition (idcontrat)');
        $this->addSql('CREATE TABLE sav.contrat_relance (id BIGSERIAL NOT NULL, idcontrat BIGINT DEFAULT 0, date TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_contrat_relance_idcontrat ON sav.contrat_relance (idcontrat)');
        $this->addSql('CREATE TABLE sav.courrier_client (id BIGSERIAL NOT NULL, idequipement BIGINT DEFAULT NULL, idintervention BIGINT DEFAULT 0, anomalie INT DEFAULT NULL, agt_groupe SMALLINT DEFAULT NULL, souscripteur VARCHAR(4) DEFAULT NULL, utilisateur VARCHAR(4) DEFAULT NULL, installateur VARCHAR(4) DEFAULT NULL, paragraphes VARCHAR(4) DEFAULT NULL, status SMALLINT DEFAULT NULL, date_envoi TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, num_courrier SMALLINT DEFAULT NULL, commentaire VARCHAR(160) DEFAULT NULL, prev_envoi TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, prev_courrier SMALLINT DEFAULT NULL, index_courrier_client BYTEA DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_courrier_client_index_courrier_client ON sav.courrier_client (index_courrier_client)');
        $this->addSql('CREATE INDEX idx_courrier_client_idchaudiere ON sav.courrier_client (idequipement)');
        $this->addSql('CREATE INDEX idx_courrier_client_idintervention ON sav.courrier_client (idintervention)');
        $this->addSql('CREATE TABLE sav.devis (id BIGSERIAL NOT NULL, idintervention BIGINT DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_devis_idplanning ON sav.devis (idintervention)');
        $this->addSql('CREATE TABLE sav.equipement (id BIGSERIAL NOT NULL, idclient BIGINT DEFAULT 0, idequipement_type BIGINT DEFAULT 0, idnature_gaz BIGINT DEFAULT NULL, idtranche_equipement BIGINT DEFAULT NULL, idadresse BIGINT DEFAULT NULL, idequipement_local SMALLINT DEFAULT NULL, idraccordement BIGINT DEFAULT NULL, idinstallateur BIGINT DEFAULT NULL, idprotection_sanitaire BIGINT DEFAULT NULL, idrobinet_remplissage BIGINT DEFAULT NULL, num_serie_principal VARCHAR(14) DEFAULT NULL, num_serie_secondaire VARCHAR(14) DEFAULT NULL, puissance INT DEFAULT 0, logement_plus_2_ans BOOLEAN DEFAULT NULL, vmc BOOLEAN DEFAULT \'false\', date_premier_allumage TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, actif BOOLEAN DEFAULT \'true\', salarie_frisquet BOOLEAN DEFAULT \'false\', num_famille SMALLINT DEFAULT 0, lieu_si_autre VARCHAR(30) DEFAULT NULL, idsecteur BIGINT DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_equipement_idequipement_type ON sav.equipement (idequipement_type)');
        $this->addSql('CREATE INDEX idx_equipement_idinstallateur ON sav.equipement (idinstallateur)');
        $this->addSql('CREATE INDEX idx_equipement_idadresse ON sav.equipement (idadresse)');
        $this->addSql('CREATE INDEX idx_equipement_idraccordement ON sav.equipement (idraccordement)');
        $this->addSql('CREATE INDEX idx_equipement_idprotection_sanitaire ON sav.equipement (idprotection_sanitaire)');
        $this->addSql('CREATE INDEX idx_equipement_idclient ON sav.equipement (idclient)');
        $this->addSql('CREATE INDEX idx_equipement_tranche_equipement ON sav.equipement (idtranche_equipement)');
        $this->addSql('CREATE INDEX idx_equipement_idnature_gaz ON sav.equipement (idnature_gaz)');
        $this->addSql('CREATE INDEX idx_equipement_idequipement_local ON sav.equipement (idequipement_local)');
        $this->addSql('CREATE INDEX idx_equipement_idsecteur ON sav.equipement (idsecteur)');
        $this->addSql('CREATE INDEX idx_equipement_idrobinet_remplissage ON sav.equipement (idrobinet_remplissage)');
        $this->addSql('CREATE TABLE sav.equipement_mesure (idequipement BIGINT DEFAULT 0 NOT NULL, idintervention BIGINT DEFAULT 0 NOT NULL, date TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, temp_ecs BIGINT DEFAULT NULL, temp_efs BIGINT DEFAULT NULL, delta_temp BIGINT DEFAULT NULL, debit_ecs BIGINT DEFAULT NULL, pression_gaz_statique BIGINT DEFAULT NULL, pression_gaz_dynamique BIGINT DEFAULT NULL, pression_injection BIGINT DEFAULT NULL, debit_gaz BIGINT DEFAULT NULL, PRIMARY KEY(idequipement, idintervention))');
        $this->addSql('CREATE INDEX IDX_39AC9B68751DDBC9 ON sav.equipement_mesure (idequipement)');
        $this->addSql('CREATE INDEX IDX_39AC9B6897B76BA2 ON sav.equipement_mesure (idintervention)');
        $this->addSql('CREATE TABLE sav.historique_modification (id BIGSERIAL NOT NULL, idequipement BIGINT DEFAULT NULL, idintervention BIGINT DEFAULT NULL, idclient BIGINT DEFAULT 0, idagent BIGINT DEFAULT 0, idutilisateur_modif BIGINT DEFAULT 0, idutilisateur_valide BIGINT DEFAULT NULL, nom_table VARCHAR(50) DEFAULT NULL, nom_champ VARCHAR(50) DEFAULT NULL, origine VARCHAR(20) DEFAULT NULL, date_heure TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, avant VARCHAR(500) DEFAULT NULL, apres VARCHAR(500) DEFAULT NULL, effectuee BOOLEAN DEFAULT \'false\', date_heure_valide TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_historique_modification_idequipement ON sav.historique_modification (idequipement)');
        $this->addSql('CREATE INDEX idx_historique_modification_idagent ON sav.historique_modification (idagent)');
        $this->addSql('CREATE INDEX idx_historique_modification_effectuee ON sav.historique_modification (effectuee)');
        $this->addSql('CREATE INDEX idx_historique_modification_idutilisateur_modif ON sav.historique_modification (idutilisateur_modif)');
        $this->addSql('CREATE INDEX idx_historique_modification_idintervention ON sav.historique_modification (idintervention)');
        $this->addSql('CREATE INDEX idx_historique_modification_idclient ON sav.historique_modification (idclient)');
        $this->addSql('CREATE INDEX IDX_D8273D139E6B769E ON sav.historique_modification (idutilisateur_valide)');
        $this->addSql('CREATE TABLE sav.intervention_anomalie (idintervention BIGINT NOT NULL, idanomalie SMALLINT NOT NULL, PRIMARY KEY(idintervention, idanomalie))');
        $this->addSql('CREATE INDEX IDX_736E3B16DB8FE991 ON sav.intervention_anomalie (idanomalie)');
        $this->addSql('CREATE INDEX IDX_736E3B1697B76BA2 ON sav.intervention_anomalie (idintervention)');
        $this->addSql('CREATE TABLE sav.intervention_documents (id BIGSERIAL NOT NULL, idintervention BIGINT DEFAULT 0, nom VARCHAR(100) DEFAULT NULL, exclusif_courrier BOOLEAN DEFAULT \'false\', PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_intervention_documents_idintervention ON sav.intervention_documents (idintervention)');
        $this->addSql('CREATE TABLE sav.intervention_media (id BIGSERIAL NOT NULL, idintervention BIGINT DEFAULT 0, media BYTEA DEFAULT NULL, commentaire TEXT DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_intervention_media_idintervention ON sav.intervention_media (idintervention)');
        $this->addSql('CREATE TABLE sav.intervention_observation (id BIGSERIAL NOT NULL, idintervention BIGINT DEFAULT 0, texte_observation TEXT DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_intervention_observation_idintervention ON sav.intervention_observation (idintervention)');
        $this->addSql('CREATE TABLE sav.intervention_payeur_externe (id BIGSERIAL NOT NULL, idtype_client BIGINT DEFAULT NULL, idadresse BIGINT DEFAULT 0, idintervention BIGINT DEFAULT NULL, nom VARCHAR(25) DEFAULT NULL, num_tel VARCHAR(10) DEFAULT NULL, email VARCHAR(260) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_intervention_payeur_externe_nom ON sav.intervention_payeur_externe (nom)');
        $this->addSql('CREATE UNIQUE INDEX intervention_payeur_externe_idintervention_key ON sav.intervention_payeur_externe (idintervention)');
        $this->addSql('CREATE INDEX idx_intervention_payeur_externe_idtype_client ON sav.intervention_payeur_externe (idtype_client)');
        $this->addSql('CREATE INDEX idx_intervention_payeur_externe_idadresse ON sav.intervention_payeur_externe (idadresse)');
        $this->addSql('CREATE TABLE sav.intervention_pre_encaissement (id BIGSERIAL NOT NULL, idintervention BIGINT DEFAULT NULL, idmoyen_paiement BIGINT DEFAULT 0, montant_ttc NUMERIC(24, 6) DEFAULT NULL, recupere_par VARCHAR(50) DEFAULT NULL, recupere_le TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, code_groupe SMALLINT DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_intervention_pre_encaissement_idmoyen_paiement ON sav.intervention_pre_encaissement (idmoyen_paiement)');
        $this->addSql('CREATE INDEX idx_intervention_pre_encaissement_intervention_pre_encaissement ON sav.intervention_pre_encaissement (code_groupe, recupere_le)');
        $this->addSql('CREATE INDEX idx_intervention_pre_encaissement_idintervention ON sav.intervention_pre_encaissement (idintervention)');
        $this->addSql('CREATE TABLE sav.intervention_retour (idretour SMALLINT NOT NULL, idintervention BIGINT NOT NULL, PRIMARY KEY(idretour, idintervention))');
        $this->addSql('CREATE INDEX idx_intervention_retour_idretour ON sav.intervention_retour (idretour)');
        $this->addSql('CREATE INDEX idx_intervention_retour_idintervention ON sav.intervention_retour (idintervention)');
        $this->addSql('CREATE TABLE sav.intervention_stack (id BIGSERIAL NOT NULL, idagent BIGINT DEFAULT NULL, checksum VARCHAR(128) DEFAULT NULL, date_heure TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, route VARCHAR(128) DEFAULT NULL, content BYTEA DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_intervention_stack_idagent ON sav.intervention_stack (idagent)');
        $this->addSql('CREATE TABLE sav.planning (idplanning BIGINT DEFAULT 0 NOT NULL, idtype_visite BIGINT DEFAULT 0, idutilisateur_agent BIGINT DEFAULT 0, idequipement BIGINT DEFAULT 0, idmoment_passage SMALLINT DEFAULT NULL, idpln_formation BIGINT DEFAULT NULL, idpln_controle_voiture BIGINT DEFAULT NULL, idpln_maladie BIGINT DEFAULT NULL, idpln_reunion BIGINT DEFAULT NULL, idpln_annulation BIGINT DEFAULT NULL, idpln_test BIGINT DEFAULT NULL, idpln_transit BIGINT DEFAULT NULL, idpln_horaires_passage INT DEFAULT NULL, idpln_reserve BIGINT DEFAULT NULL, date_intervention TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, heure_debut_reelle TIME(0) WITHOUT TIME ZONE DEFAULT NULL, heure_fin_reelle TIME(0) WITHOUT TIME ZONE DEFAULT NULL, duree INT DEFAULT NULL, ordre_affichage SMALLINT DEFAULT NULL, typeduree SMALLINT DEFAULT NULL, horaire_specifie BOOLEAN DEFAULT NULL, heure_debut_specifiee VARCHAR(4) DEFAULT NULL, heure_fin_specifiee VARCHAR(4) DEFAULT NULL, statut_intervention SMALLINT DEFAULT NULL, distribution BOOLEAN DEFAULT \'false\', idsite_livraison BIGINT DEFAULT NULL, code_regroup INT DEFAULT 0, PRIMARY KEY(idplanning))');
        $this->addSql('CREATE INDEX idx_planning_idpln_annulation ON sav.planning (idpln_annulation)');
        $this->addSql('CREATE INDEX idx_planning_idpln_reserve ON sav.planning (idpln_reserve)');
        $this->addSql('CREATE INDEX idx_planning_idpln_formation ON sav.planning (idpln_formation)');
        $this->addSql('CREATE INDEX idx_planning_idpln_maladie ON sav.planning (idpln_maladie)');
        $this->addSql('CREATE INDEX idx_planning_idpln_transit ON sav.planning (idpln_transit)');
        $this->addSql('CREATE INDEX idx_planning_idutilisateur_agent ON sav.planning (idutilisateur_agent)');
        $this->addSql('CREATE INDEX idx_planning_idpln_reunion ON sav.planning (idpln_reunion)');
        $this->addSql('CREATE INDEX idx_planning_idtype_visite ON sav.planning (idtype_visite)');
        $this->addSql('CREATE INDEX idx_planning_idpln_test ON sav.planning (idpln_test)');
        $this->addSql('CREATE INDEX idx_planning_idequipement ON sav.planning (idequipement)');
        $this->addSql('CREATE INDEX idx_planning_idpln_horaires_passage ON sav.planning (idpln_horaires_passage)');
        $this->addSql('CREATE INDEX idx_planning_idpln_controle_voiture ON sav.planning (idpln_controle_voiture)');
        $this->addSql('CREATE INDEX idx_planning_idmoment_passage ON sav.planning (idmoment_passage)');
        $this->addSql('CREATE TABLE sav.planning_agents_liste (idplanning_agents_liste SERIAL NOT NULL, idpln_liste_agents INT DEFAULT NULL, idutilisateur_agent BIGINT DEFAULT 0, PRIMARY KEY(idplanning_agents_liste))');
        $this->addSql('CREATE INDEX idx_planning_agents_liste_idutilisateur_agent ON sav.planning_agents_liste (idutilisateur_agent)');
        $this->addSql('CREATE INDEX idx_planning_agents_liste_idpln_liste_agents ON sav.planning_agents_liste (idpln_liste_agents)');
        $this->addSql('CREATE TABLE sav.planning_conflit (idpln_conflit SERIAL NOT NULL, idequipement BIGINT DEFAULT NULL, idutilisateur BIGINT DEFAULT NULL, idplanning BIGINT DEFAULT NULL, date_intervention DATE DEFAULT NULL, code_agent INT DEFAULT NULL, moment SMALLINT DEFAULT NULL, observations TEXT DEFAULT NULL, date_creation TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, PRIMARY KEY(idpln_conflit))');
        $this->addSql('CREATE INDEX idx_planning_conflit_idequipement ON sav.planning_conflit (idequipement)');
        $this->addSql('CREATE INDEX idx_planning_conflit_idutilisateur ON sav.planning_conflit (idutilisateur)');
        $this->addSql('CREATE UNIQUE INDEX planning_conflit_idplanning_key ON sav.planning_conflit (idplanning)');
        $this->addSql('CREATE TABLE sav.planning_historique_modification (idplanning_historique_modification SERIAL NOT NULL, idequipement BIGINT DEFAULT NULL, idplanning BIGINT DEFAULT 0, idagent BIGINT DEFAULT NULL, code_action SMALLINT DEFAULT NULL, moment SMALLINT DEFAULT NULL, idpln_initiative_interv INT DEFAULT NULL, idplanning_initiative INT DEFAULT 0, idutilisateur BIGINT DEFAULT 0, idtype_visite BIGINT DEFAULT NULL, date_intervention TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, memo_intervention VARCHAR(200) DEFAULT NULL, avis_passage VARCHAR(1) DEFAULT NULL, avis_passage_mail SMALLINT DEFAULT 0, date_action TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, PRIMARY KEY(idplanning_historique_modification))');
        $this->addSql('CREATE INDEX idx_planning_historique_modification_idtype_visite ON sav.planning_historique_modification (idtype_visite)');
        $this->addSql('CREATE INDEX idx_planning_historique_modification_code_action ON sav.planning_historique_modification (code_action)');
        $this->addSql('CREATE INDEX idx_planning_historique_modification_idutilisateur ON sav.planning_historique_modification (idutilisateur)');
        $this->addSql('CREATE INDEX idx_planning_historique_modification_moment ON sav.planning_historique_modification (moment)');
        $this->addSql('CREATE INDEX idx_planning_historique_modification_idpln_initiative_interv ON sav.planning_historique_modification (idpln_initiative_interv)');
        $this->addSql('CREATE INDEX idx_planning_historique_modification_idagent ON sav.planning_historique_modification (idagent)');
        $this->addSql('CREATE INDEX idx_planning_historique_modification_idequipement ON sav.planning_historique_modification (idequipement)');
        $this->addSql('CREATE INDEX idx_planning_historique_modification_idplanning ON sav.planning_historique_modification (idplanning)');
        $this->addSql('CREATE INDEX idx_planning_historique_modification_idplanning_initiative ON sav.planning_historique_modification (idplanning_initiative)');
        $this->addSql('CREATE TABLE sav.pln_agent_blocage (idpln_agent_blocage SERIAL NOT NULL, idutilisateur_agent BIGINT DEFAULT NULL, idutilisateur BIGINT DEFAULT NULL, date_blocage TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, modif_pln SMALLINT DEFAULT 0, date_bloquee DATE DEFAULT NULL, PRIMARY KEY(idpln_agent_blocage))');
        $this->addSql('CREATE UNIQUE INDEX pln_agent_blocage_idutilisateur_agent_key ON sav.pln_agent_blocage (idutilisateur_agent)');
        $this->addSql('CREATE INDEX idx_pln_agent_blocage_idutilisateur ON sav.pln_agent_blocage (idutilisateur)');
        $this->addSql('CREATE TABLE sav.pln_droits_visite (idpln_droits_visite SERIAL NOT NULL, idutilisateur BIGINT DEFAULT 0, idtype_visite BIGINT DEFAULT NULL, droit BIGINT DEFAULT NULL, PRIMARY KEY(idpln_droits_visite))');
        $this->addSql('CREATE INDEX idx_pln_droits_visite_idutilisateuridtype_visite ON sav.pln_droits_visite (idutilisateur, idtype_visite)');
        $this->addSql('CREATE INDEX idx_pln_droits_visite_idtype_visite ON sav.pln_droits_visite (idtype_visite)');
        $this->addSql('CREATE INDEX idx_pln_droits_visite_idutilisateur ON sav.pln_droits_visite (idutilisateur)');
        $this->addSql('CREATE TABLE sav.pln_groupe_utilisateurs (idpln_groupe_utilisateurs SERIAL NOT NULL, idpln_groupes INT DEFAULT 0, idutilisateur BIGINT DEFAULT 0, PRIMARY KEY(idpln_groupe_utilisateurs))');
        $this->addSql('CREATE INDEX idx_pln_groupe_utilisateurs_idpln_groupes_login ON sav.pln_groupe_utilisateurs (idpln_groupes, idutilisateur)');
        $this->addSql('CREATE INDEX idx_pln_groupe_utilisateurs_idutilisateur ON sav.pln_groupe_utilisateurs (idutilisateur)');
        $this->addSql('CREATE INDEX idx_pln_groupe_utilisateurs_idpln_groupes ON sav.pln_groupe_utilisateurs (idpln_groupes)');
        $this->addSql('CREATE TABLE sav.pln_transit (idpln_transit BIGSERIAL NOT NULL, idutilisateur BIGINT DEFAULT 0, dateheuretransit TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, lockuser SMALLINT DEFAULT NULL, login_lock VARCHAR(255) DEFAULT NULL, PRIMARY KEY(idpln_transit))');
        $this->addSql('CREATE INDEX idx_pln_transit_idutilisateur ON sav.pln_transit (idutilisateur)');
        $this->addSql('CREATE TABLE sav.pln_transit_utilisateur (idpln_droits_transit SERIAL NOT NULL, idutilisateur BIGINT DEFAULT 0, transit_actif SMALLINT DEFAULT NULL, superviseur SMALLINT DEFAULT NULL, PRIMARY KEY(idpln_droits_transit))');
        $this->addSql('CREATE INDEX idx_pln_transit_utilisateur_idutilisateur ON sav.pln_transit_utilisateur (idutilisateur)');
        $this->addSql('CREATE TABLE sav.pln_visite_exclusion (idpln_visite_exclusion SERIAL NOT NULL, idtype_visite BIGINT DEFAULT NULL, idutilisateur BIGINT DEFAULT NULL, commentaire TEXT DEFAULT NULL, PRIMARY KEY(idpln_visite_exclusion))');
        $this->addSql('CREATE INDEX idx_pln_visite_exclusion_idutilisateur ON sav.pln_visite_exclusion (idutilisateur)');
        $this->addSql('CREATE INDEX idx_pln_visite_exclusion_idtype_visite ON sav.pln_visite_exclusion (idtype_visite)');
        $this->addSql('CREATE TABLE sav.privilege (id BIGSERIAL NOT NULL, idequipement BIGINT DEFAULT 0 NOT NULL, idprivilege_statut INT DEFAULT NULL, idraison_refus SMALLINT DEFAULT NULL, idintervention BIGINT DEFAULT 0, date_candidat TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT CURRENT_TIMESTAMP, date_proposition TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, commentaire VARCHAR(200) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE UNIQUE INDEX privilege_idintervention_key ON sav.privilege (idintervention)');
        $this->addSql('CREATE INDEX idx_privilege_statut_privilege ON sav.privilege (idprivilege_statut)');
        $this->addSql('CREATE INDEX idx_privilege_idraison_refus ON sav.privilege (idraison_refus)');
        $this->addSql('CREATE UNIQUE INDEX privilege_idequipement_key ON sav.privilege (idequipement)');
        $this->addSql('CREATE TABLE sav.secteur_equipement (idsecteur_version BIGINT NOT NULL, idequipement BIGINT NOT NULL, PRIMARY KEY(idsecteur_version, idequipement))');
        $this->addSql('CREATE INDEX idx_secteur_equipement_idsecteur_version ON sav.secteur_equipement (idsecteur_version)');
        $this->addSql('CREATE INDEX idx_secteur_equipement_idequipement ON sav.secteur_equipement (idequipement)');
        $this->addSql('CREATE TABLE sav.agent_produit_stock (idagent BIGINT DEFAULT 0 NOT NULL, idproduit BIGINT NOT NULL, idsite BIGINT DEFAULT NULL, idutilisateur BIGINT DEFAULT NULL, stock_reel INT DEFAULT 0, stock_theorique INT DEFAULT 0, PRIMARY KEY(idagent, idproduit))');
        $this->addSql('CREATE INDEX idx_agent_produit_stock_idutilisateur ON sav.agent_produit_stock (idutilisateur)');
        $this->addSql('CREATE INDEX idx_agent_produit_stock_idagent ON sav.agent_produit_stock (idagent)');
        $this->addSql('CREATE INDEX idx_agent_produit_stock_idsite ON sav.agent_produit_stock (idsite)');
        $this->addSql('CREATE INDEX idx_agent_produit_stock_idproduit ON sav.agent_produit_stock (idproduit)');
        $this->addSql('CREATE TABLE sav.adresse (id BIGSERIAL NOT NULL, idclient BIGINT DEFAULT NULL, idagence BIGINT DEFAULT NULL, idtype_adresse BIGINT DEFAULT NULL, idtype_logement BIGINT DEFAULT NULL, actif BOOLEAN DEFAULT \'true\', commentaire_tech TEXT DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_adresse_idagence ON sav.adresse (idagence)');
        $this->addSql('CREATE INDEX idx_adresse_idtype_adresse ON sav.adresse (idtype_adresse)');
        $this->addSql('CREATE INDEX idx_adresse_idtype_logement ON sav.adresse (idtype_logement)');
        $this->addSql('CREATE INDEX idx_adresse_idclient ON sav.adresse (idclient)');
        $this->addSql('CREATE TABLE sav.aide_technique (id DOUBLE PRECISION DEFAULT \'0\' NOT NULL, idequipement BIGINT DEFAULT NULL, idtype_demandeur BIGINT DEFAULT NULL, idaide_technique_etat DOUBLE PRECISION DEFAULT NULL, num_famille VARCHAR(50) DEFAULT NULL, provenance VARCHAR(20) DEFAULT NULL, telephone VARCHAR(14) DEFAULT NULL, objet VARCHAR(400) DEFAULT NULL, idutilisateur_modif BIGINT DEFAULT 0, idutilisateur_reservation BIGINT DEFAULT NULL, moyen_resolution VARCHAR(1) DEFAULT NULL, motif VARCHAR(1) DEFAULT NULL, envoi_doc VARCHAR(1) DEFAULT NULL, email_doc VARCHAR(260) DEFAULT NULL, adresse_doc VARCHAR(250) DEFAULT NULL, urgence BOOLEAN DEFAULT \'false\', pole SMALLINT DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_aide_technique_idaide_technique_etat ON sav.aide_technique (idaide_technique_etat)');
        $this->addSql('CREATE INDEX idx_aide_technique_idequipement ON sav.aide_technique (idequipement)');
        $this->addSql('CREATE INDEX idx_aide_technique_idtype_demandeur ON sav.aide_technique (idtype_demandeur)');
        $this->addSql('CREATE TABLE sav.type_complement_adresse (id BIGSERIAL NOT NULL, libelle VARCHAR(30) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.client (id BIGSERIAL NOT NULL, idsouscripteur BIGINT DEFAULT 0, code_ec SMALLINT DEFAULT 0, idtype_client BIGINT DEFAULT NULL, idcategorie_pro BIGINT DEFAULT NULL, idcompte_client_web BIGINT DEFAULT NULL, nom VARCHAR(25) DEFAULT NULL, prenom VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_client_idtype_client ON sav.client (idtype_client)');
        $this->addSql('CREATE INDEX idx_client_idcategorie_pro ON sav.client (idcategorie_pro)');
        $this->addSql('CREATE INDEX idx_client_code_ec ON sav.client (code_ec)');
        $this->addSql('CREATE INDEX idx_client_idsouscripteur ON sav.client (idsouscripteur)');
        $this->addSql('CREATE INDEX idx_client_idcompte_client_web ON sav.client (idcompte_client_web)');
        $this->addSql('CREATE TABLE sav.type_adresse (id BIGSERIAL NOT NULL, libelle VARCHAR(30) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.type_logement (id BIGSERIAL NOT NULL, libelle VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.appareil (id SERIAL NOT NULL, libelle_court VARCHAR(20) DEFAULT NULL, libelle_long VARCHAR(50) DEFAULT NULL, commentaire TEXT DEFAULT NULL, marque VARCHAR(32) DEFAULT NULL, modele VARCHAR(50) DEFAULT NULL, metrologique BOOLEAN DEFAULT \'false\', actif BOOLEAN DEFAULT \'true\', PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.demande_documentation (id BIGSERIAL NOT NULL, idtype_demandeur BIGINT DEFAULT 0, idequipement BIGINT DEFAULT 0, code_agi VARCHAR(9) DEFAULT NULL, canal_envoi VARCHAR(50) DEFAULT NULL, ref_doc VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_demande_documentation_code_agi ON sav.demande_documentation (code_agi)');
        $this->addSql('CREATE INDEX idx_demande_documentation_idtype_demandeur ON sav.demande_documentation (idtype_demandeur)');
        $this->addSql('CREATE INDEX idx_demande_documentation_idequipement ON sav.demande_documentation (idequipement)');
        $this->addSql('CREATE TABLE sav.equipement_famille (id BIGSERIAL NOT NULL, code SMALLINT DEFAULT 0 NOT NULL, libelle VARCHAR(60) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE UNIQUE INDEX equipement_famille_code_key ON sav.equipement_famille (code)');
        $this->addSql('CREATE TABLE sav.aide_technique_classification_liste (id BIGSERIAL NOT NULL, libelle_classification VARCHAR(200) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.aide_technique_etat (id DOUBLE PRECISION DEFAULT \'0\' NOT NULL, libelle_etat VARCHAR(20) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.type_demandeur (id BIGSERIAL NOT NULL, libelle VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.attachement_parametre_liste (id BIGSERIAL NOT NULL, libelle VARCHAR(100) DEFAULT NULL, type_calcul VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.attachement_parametre (id BIGSERIAL NOT NULL, idattachement_parametre_liste BIGINT DEFAULT NULL, annee INT DEFAULT 0, semestre SMALLINT DEFAULT 0, valeur INT DEFAULT 0, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_attachement_parametre_idattachement_parametre_liste ON sav.attachement_parametre (idattachement_parametre_liste)');
        $this->addSql('CREATE TABLE sav.type_visite (id BIGSERIAL NOT NULL, idcategorie_visite VARCHAR(1) NOT NULL, code VARCHAR(12) NOT NULL, code_court VARCHAR(3) DEFAULT NULL, libelle VARCHAR(30) DEFAULT NULL, libelle_fact VARCHAR(23) DEFAULT NULL, duree SMALLINT DEFAULT NULL, rang_tri SMALLINT DEFAULT NULL, couleur INT DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE UNIQUE INDEX type_visite_code_visite_key ON sav.type_visite (code)');
        $this->addSql('CREATE INDEX idx_type_visite_idcategorie_visite ON sav.type_visite (idcategorie_visite)');
        $this->addSql('CREATE TABLE sav.attachement_type_visite (id BIGSERIAL NOT NULL, idtype_visite BIGINT DEFAULT 0, annee INT DEFAULT 0, mois SMALLINT DEFAULT 0, ponderation SMALLINT DEFAULT 0, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_attachement_type_visite_idtype_visite ON sav.attachement_type_visite (idtype_visite)');
        $this->addSql('CREATE TABLE sav.classe_energetique (id SMALLINT DEFAULT 0 NOT NULL, libelle VARCHAR(15) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.classification_energetique (id BIGSERIAL NOT NULL, idequipement_type BIGINT DEFAULT 0, idclasse_rendement SMALLINT DEFAULT NULL, idclasse_energetique SMALLINT DEFAULT 0, debut_fabrication TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, fin_fabrication TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, rendement NUMERIC(24, 6) DEFAULT NULL, nox SMALLINT DEFAULT NULL, evacuation_etanche SMALLINT DEFAULT NULL, ballon_integre SMALLINT DEFAULT NULL, debut_classe_energetique DATE DEFAULT NULL, fin_classe_energetique DATE DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_classification_energetique_idclasse_energetique ON sav.classification_energetique (idclasse_energetique)');
        $this->addSql('CREATE INDEX idx_classification_energetique_idequipement_type ON sav.classification_energetique (idequipement_type)');
        $this->addSql('CREATE INDEX idx_classification_energetique_idclasse_rendement ON sav.classification_energetique (idclasse_rendement)');
        $this->addSql('CREATE TABLE sav.classe_rendement (id SMALLINT DEFAULT 0 NOT NULL, libelle VARCHAR(30) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.equipement_type (id BIGSERIAL NOT NULL, idequipement_famille BIGINT DEFAULT NULL, type VARCHAR(8) DEFAULT NULL, libelle VARCHAR(50) DEFAULT NULL, ctrl_co BOOLEAN DEFAULT \'false\', debut_famille DATE DEFAULT NULL, fin_famille DATE DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_equipement_type_idequipement_famille ON sav.equipement_type (idequipement_famille)');
        $this->addSql('CREATE UNIQUE INDEX equipement_type_type_key ON sav.equipement_type (type)');
        $this->addSql('CREATE TABLE sav.etat_civil (id SMALLINT DEFAULT 0 NOT NULL, libelle VARCHAR(15) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.client_email (id BIGSERIAL NOT NULL, idclient BIGINT DEFAULT NULL, email VARCHAR(260) DEFAULT NULL, commentaire_email VARCHAR(50) DEFAULT NULL, actif BOOLEAN DEFAULT \'true\', PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_client_email_idclient ON sav.client_email (idclient)');
        $this->addSql('CREATE TABLE sav.categorie_pro (id BIGSERIAL NOT NULL, libelle VARCHAR(30) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.compte_client_web (id BIGSERIAL NOT NULL, login_web VARCHAR(64) DEFAULT NULL, password VARCHAR(64) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.type_client (id BIGSERIAL NOT NULL, libelle VARCHAR(30) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.client_tel (id BIGSERIAL NOT NULL, idclient BIGINT DEFAULT NULL, idtype_tel BIGINT DEFAULT 0, num_tel VARCHAR(10) DEFAULT NULL, commentaire_tel VARCHAR(50) DEFAULT NULL, priorite SMALLINT DEFAULT 0, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_client_tel_idtype_tel ON sav.client_tel (idtype_tel)');
        $this->addSql('CREATE INDEX idx_client_tel_idclient ON sav.client_tel (idclient)');
        $this->addSql('CREATE TABLE sav.facture (id BIGSERIAL NOT NULL, idequipement BIGINT DEFAULT NULL, idagence BIGINT DEFAULT NULL, idadresse BIGINT DEFAULT NULL, idfacture_type BIGINT DEFAULT NULL, idcategorie_facture BIGINT DEFAULT NULL, iddevis BIGINT DEFAULT NULL, idsite BIGINT DEFAULT 0, idintervention BIGINT DEFAULT NULL, num_facture VARCHAR(11) DEFAULT \'0\' NOT NULL, num_facture_oracle INT DEFAULT 0, num_facture_reference INT DEFAULT NULL, montant_ht NUMERIC(24, 6) DEFAULT \'0\', montant_ttc NUMERIC(24, 6) DEFAULT NULL, date_facture TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, date_relance TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, devise VARCHAR(1) DEFAULT NULL, num_acompte SMALLINT DEFAULT 0, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_facture_idsite ON sav.facture (idsite)');
        $this->addSql('CREATE INDEX idx_facture_idfacture_type ON sav.facture (idfacture_type)');
        $this->addSql('CREATE INDEX idx_facture_iddevis ON sav.facture (iddevis)');
        $this->addSql('CREATE INDEX idx_facture_idintervention ON sav.facture (idintervention)');
        $this->addSql('CREATE INDEX idx_facture_idadresse ON sav.facture (idadresse)');
        $this->addSql('CREATE INDEX idx_facture_idcategorie_facture ON sav.facture (idcategorie_facture)');
        $this->addSql('CREATE INDEX idx_facture_idagence ON sav.facture (idagence)');
        $this->addSql('CREATE INDEX idx_facture_idequipement ON sav.facture (idequipement)');
        $this->addSql('CREATE UNIQUE INDEX facture_num_facture_key ON sav.facture (num_facture)');
        $this->addSql('CREATE TABLE sav.communication_canal (id BIGSERIAL NOT NULL, libelle VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.communication_type (id BIGSERIAL NOT NULL, libelle VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.produit (id BIGSERIAL NOT NULL, idproduit_famille BIGINT DEFAULT NULL, idproduit_type BIGINT DEFAULT 0, idsite BIGINT DEFAULT 0, code VARCHAR(15) NOT NULL, designation VARCHAR(30) NOT NULL, gtin VARCHAR(48) DEFAULT NULL, gu_etendue SMALLINT DEFAULT 0, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_produit_idsite ON sav.produit (idsite)');
        $this->addSql('CREATE INDEX idx_produit_idproduit_famille ON sav.produit (idproduit_famille)');
        $this->addSql('CREATE INDEX idx_produit_idproduit_type ON sav.produit (idproduit_type)');
        $this->addSql('CREATE TABLE sav.contrat_motif_resiliation (id BIGSERIAL NOT NULL, libelle VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.contrat_type (id BIGSERIAL NOT NULL, libelle_court VARCHAR(8) NOT NULL, libelle_long VARCHAR(60) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE UNIQUE INDEX contrat_type_libelle_court_key ON sav.contrat_type (libelle_court)');
        $this->addSql('CREATE TABLE sav.equipement_complement (idequipement BIGINT DEFAULT 0 NOT NULL, idtype_complement BIGINT DEFAULT 0 NOT NULL, present BOOLEAN DEFAULT \'false\', marque VARCHAR(30) DEFAULT NULL, num_serie_frisquet VARCHAR(30) DEFAULT NULL, PRIMARY KEY(idequipement, idtype_complement))');
        $this->addSql('CREATE INDEX idx_equipement_complement_idtype_equipement ON sav.equipement_complement (idtype_complement)');
        $this->addSql('CREATE INDEX idx_equipement_complement_idequipement ON sav.equipement_complement (idequipement)');
        $this->addSql('CREATE TABLE sav.contrat_tarif (id BIGSERIAL NOT NULL, idcontrat_type BIGINT DEFAULT 0, idequipement_type BIGINT DEFAULT NULL, idpuissance INT DEFAULT NULL, tarif_contrat_ht NUMERIC(24, 6) DEFAULT \'0\', date_debut DATE DEFAULT NULL, date_fin DATE DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_contrat_tarif_puissance ON sav.contrat_tarif (idpuissance)');
        $this->addSql('CREATE INDEX idx_contrat_tarif_idcontrat_type ON sav.contrat_tarif (idcontrat_type)');
        $this->addSql('CREATE INDEX idx_contrat_tarif_idequipement_type ON sav.contrat_tarif (idequipement_type)');
        $this->addSql('CREATE TABLE sav.puissance (id BIGSERIAL NOT NULL, libelle INT DEFAULT 0 NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.equipement_zone (idequipement BIGINT DEFAULT 0 NOT NULL, idtype_zone BIGINT DEFAULT 0 NOT NULL, numero SMALLINT DEFAULT NULL, PRIMARY KEY(idequipement, idtype_zone))');
        $this->addSql('CREATE INDEX idx_equipement_zone_idtype_zone ON sav.equipement_zone (idtype_zone)');
        $this->addSql('CREATE INDEX idx_equipement_zone_idequipement ON sav.equipement_zone (idequipement)');
        $this->addSql('CREATE TABLE sav.type_complement (id BIGSERIAL NOT NULL, libelle VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.groupe_type (id BIGSERIAL NOT NULL, libelle VARCHAR(50) DEFAULT NULL, commentaire_dev TEXT DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.equipement_local (id SMALLINT DEFAULT 0 NOT NULL, libelle VARCHAR(30) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.installateur (id BIGSERIAL NOT NULL, code_agi VARCHAR(9) DEFAULT NULL, nom VARCHAR(30) DEFAULT NULL, adresse1 VARCHAR(35) DEFAULT \'0\', adresse2 VARCHAR(35) DEFAULT NULL, code_postal VARCHAR(5) DEFAULT NULL, ville VARCHAR(50) DEFAULT NULL, tel1 VARCHAR(14) DEFAULT NULL, tel2 VARCHAR(14) DEFAULT NULL, email VARCHAR(260) DEFAULT NULL, gere_sav BOOLEAN DEFAULT \'false\', PRIMARY KEY(id))');
        $this->addSql('CREATE UNIQUE INDEX installateur_code_agi_key ON sav.installateur (code_agi)');
        $this->addSql('CREATE INDEX idx_installateur_adresse1 ON sav.installateur (adresse1)');
        $this->addSql('CREATE INDEX idx_installateur_nom ON sav.installateur (nom)');
        $this->addSql('CREATE TABLE sav.nature_gaz (id BIGSERIAL NOT NULL, libelle_court VARCHAR(5) DEFAULT NULL, libelle_long VARCHAR(30) DEFAULT NULL, affichage_tablette BOOLEAN DEFAULT \'false\', PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.protection_sanitaire (id BIGSERIAL NOT NULL, libelle VARCHAR(30) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.raccordement (id BIGSERIAL NOT NULL, libelle VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.robinet_remplissage (id BIGSERIAL NOT NULL, libelle VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.equipement_tranche (id BIGSERIAL NOT NULL, age SMALLINT DEFAULT 0, plus_value NUMERIC(6, 2) DEFAULT \'0\', PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.historique_client_equipement (id BIGSERIAL NOT NULL, idclient BIGINT DEFAULT 0, idsouscripteur BIGINT DEFAULT 0, idequipement BIGINT DEFAULT 0, date_debut DATE DEFAULT NULL, date_fin DATE DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_historique_client_equipement_idsouscripteur ON sav.historique_client_equipement (idsouscripteur)');
        $this->addSql('CREATE INDEX idx_historique_client_equipement_idequipement ON sav.historique_client_equipement (idequipement)');
        $this->addSql('CREATE INDEX idx_historique_client_equipement_idclient ON sav.historique_client_equipement (idclient)');
        $this->addSql('CREATE TABLE sav.type_zone (id BIGSERIAL NOT NULL, libelle VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.categorie_facture (id BIGSERIAL NOT NULL, libelle_court VARCHAR(2) DEFAULT NULL, libelle_long VARCHAR(30) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.facture_type (id BIGSERIAL NOT NULL, libelle_court VARCHAR(2) DEFAULT NULL, libelle_long VARCHAR(30) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.produit_facture_affectation (id BIGSERIAL NOT NULL, libelle_court VARCHAR(3) DEFAULT NULL, libelle_long VARCHAR(25) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.mag_commande (id BIGINT DEFAULT 0 NOT NULL, idsite BIGINT DEFAULT 0, idequipement BIGINT DEFAULT NULL, idintervention BIGINT DEFAULT NULL, idmag_etat_commande BIGINT DEFAULT NULL, idtype_cde SMALLINT DEFAULT 0 NOT NULL, idsite_livraison BIGINT DEFAULT 0 NOT NULL, idutilisateur BIGINT DEFAULT 0, idagence BIGINT DEFAULT NULL, code_client_agi VARCHAR(9) NOT NULL, date TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, idmag_statut_commande SMALLINT DEFAULT 0 NOT NULL, commentaires_agi VARCHAR(200) DEFAULT NULL, commentaires_sav VARCHAR(200) DEFAULT NULL, num_cde_agi VARCHAR(8) DEFAULT NULL, info_bl VARCHAR(35) DEFAULT NULL, montant_ttc NUMERIC(24, 6) DEFAULT NULL, interne BOOLEAN DEFAULT \'false\', PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_mag_commande_idutilisateur ON sav.mag_commande (idutilisateur)');
        $this->addSql('CREATE INDEX idx_mag_commande_idtype_cde ON sav.mag_commande (idtype_cde)');
        $this->addSql('CREATE INDEX idx_mag_commande_idmag_statut_commande ON sav.mag_commande (idmag_statut_commande)');
        $this->addSql('CREATE INDEX idx_mag_commande_idequipement ON sav.mag_commande (idequipement)');
        $this->addSql('CREATE INDEX idx_mag_commande_idsite_livraison ON sav.mag_commande (idsite_livraison)');
        $this->addSql('CREATE INDEX idx_mag_commande_idmag_etat_commande ON sav.mag_commande (idmag_etat_commande)');
        $this->addSql('CREATE INDEX idx_mag_commande_idagence ON sav.mag_commande (idagence)');
        $this->addSql('CREATE INDEX idx_mag_commande_idintervention ON sav.mag_commande (idintervention)');
        $this->addSql('CREATE INDEX idx_mag_commande_idsite ON sav.mag_commande (idsite)');
        $this->addSql('CREATE TABLE sav.intervention_annulation (id SERIAL NOT NULL, idplanning BIGINT DEFAULT 0, idintervention_motif_annulation BIGINT DEFAULT NULL, idintervention_motif_absence INT DEFAULT NULL, idintervention_motif_abandon BIGINT DEFAULT NULL, autre_motif_absence TEXT DEFAULT NULL, observations TEXT DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_intervention_annulation_idplanning ON sav.intervention_annulation (idplanning)');
        $this->addSql('CREATE INDEX idx_intervention_annulation_idintervention_motif_absence ON sav.intervention_annulation (idintervention_motif_absence)');
        $this->addSql('CREATE INDEX idx_intervention_annulation_idintervention_motif_annulation ON sav.intervention_annulation (idintervention_motif_annulation)');
        $this->addSql('CREATE INDEX idx_intervention_annulation_idintervention_motif_abandon ON sav.intervention_annulation (idintervention_motif_abandon)');
        $this->addSql('CREATE TABLE sav.intervention_motif_abandon (id BIGSERIAL NOT NULL, libelle_court VARCHAR(20) DEFAULT NULL, libelle_long VARCHAR(50) DEFAULT NULL, actif BOOLEAN DEFAULT \'true\', PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.intervention_motif_absence (id SERIAL NOT NULL, libelle_court VARCHAR(20) DEFAULT NULL, libelle_long VARCHAR(50) DEFAULT NULL, actif BOOLEAN DEFAULT \'true\', PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.intervention_motif_annulation (id BIGSERIAL NOT NULL, libelle VARCHAR(30) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.anomalie (id SMALLINT DEFAULT 0 NOT NULL, libelle VARCHAR(60) DEFAULT NULL, classe SMALLINT DEFAULT NULL, annotation VARCHAR(70) DEFAULT NULL, flg_contrat VARCHAR(1) DEFAULT NULL, courrier_souscripteur VARCHAR(4) DEFAULT NULL, courrier_utilisateur VARCHAR(4) DEFAULT NULL, courrier_installateur VARCHAR(4) DEFAULT NULL, hierarchie SMALLINT DEFAULT NULL, paragraphe VARCHAR(1) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.intervention_motif (id BIGSERIAL NOT NULL, libelle VARCHAR(30) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.type_envoi (id BIGSERIAL NOT NULL, libelle VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.old_bloc_note_client (id BIGSERIAL NOT NULL, idequipement BIGINT DEFAULT 0 NOT NULL, texte VARCHAR(2000) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE UNIQUE INDEX old_bloc_note_client_idequipement_key ON sav.old_bloc_note_client (idequipement)');
        $this->addSql('CREATE TABLE sav.moyen_paiement (id BIGSERIAL NOT NULL, libelle_court VARCHAR(3) DEFAULT NULL, libelle_long VARCHAR(30) DEFAULT NULL, affichage_tablette BOOLEAN DEFAULT \'false\', PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.mag_etat_commande (id BIGSERIAL NOT NULL, libelle VARCHAR(60) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.aide_technique_classification (idaide_technique DOUBLE PRECISION DEFAULT \'0\' NOT NULL, idaide_technique_classification_liste BIGINT DEFAULT 0 NOT NULL, PRIMARY KEY(idaide_technique, idaide_technique_classification_liste))');
        $this->addSql('CREATE INDEX IDX_546D11A18F110DB ON sav.aide_technique_classification (idaide_technique_classification_liste)');
        $this->addSql('CREATE INDEX IDX_546D11A12B8D6A42 ON sav.aide_technique_classification (idaide_technique)');
        $this->addSql('CREATE TABLE sav.retour (id BIGSERIAL NOT NULL, idtype_retour INT DEFAULT NULL, libelle VARCHAR(40) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_retour_idtype_retour ON sav.retour (idtype_retour)');
        $this->addSql('CREATE TABLE sav.planning_liste_agents (idpln_liste_agents SERIAL NOT NULL, libelle VARCHAR(50) DEFAULT NULL, nbagents INT DEFAULT NULL, desactiver VARCHAR(50) DEFAULT NULL, login VARCHAR(255) DEFAULT NULL, PRIMARY KEY(idpln_liste_agents))');
        $this->addSql('CREATE TABLE sav.planning_action (code_action SMALLINT DEFAULT 0 NOT NULL, libelle_code_action VARCHAR(40) DEFAULT NULL, PRIMARY KEY(code_action))');
        $this->addSql('CREATE TABLE sav.planning_initiative_detail (idpln_initiative_interv SERIAL NOT NULL, idplanning_initiative INT DEFAULT 0, nom VARCHAR(30) DEFAULT NULL, prenom VARCHAR(30) DEFAULT NULL, societe VARCHAR(30) DEFAULT NULL, desactiver SMALLINT DEFAULT NULL, PRIMARY KEY(idpln_initiative_interv))');
        $this->addSql('CREATE INDEX idx_planning_initiative_detail_idplanning_initiative ON sav.planning_initiative_detail (idplanning_initiative)');
        $this->addSql('CREATE TABLE sav.pln_controle_voiture (idpln_controle_voiture BIGSERIAL NOT NULL, idpln_voiture_lieu INT DEFAULT NULL, idpln_voiture_action INT DEFAULT NULL, PRIMARY KEY(idpln_controle_voiture))');
        $this->addSql('CREATE INDEX idx_pln_controle_voiture_idpln_voiture_action ON sav.pln_controle_voiture (idpln_voiture_action)');
        $this->addSql('CREATE INDEX idx_pln_controle_voiture_idpln_voiture_lieu ON sav.pln_controle_voiture (idpln_voiture_lieu)');
        $this->addSql('CREATE TABLE sav.pln_formation (idpln_formation BIGSERIAL NOT NULL, idpln_formation_intitule INT DEFAULT NULL, idpln_formation_lieu INT DEFAULT NULL, idpln_formation_organisme INT DEFAULT NULL, est_formateur SMALLINT DEFAULT NULL, PRIMARY KEY(idpln_formation))');
        $this->addSql('CREATE INDEX idx_pln_formation_idpln_formation_organisme ON sav.pln_formation (idpln_formation_organisme)');
        $this->addSql('CREATE INDEX idx_pln_formation_idpln_formation_lieu ON sav.pln_formation (idpln_formation_lieu)');
        $this->addSql('CREATE INDEX idx_pln_formation_idpln_formation_intitule ON sav.pln_formation (idpln_formation_intitule)');
        $this->addSql('CREATE TABLE sav.pln_maladie (idpln_maladie BIGSERIAL NOT NULL, idpln_motif_maladie INT DEFAULT 0, duree INT DEFAULT NULL, autre_motif VARCHAR(200) DEFAULT NULL, PRIMARY KEY(idpln_maladie))');
        $this->addSql('CREATE INDEX idx_pln_maladie_idpln_motif_maladie ON sav.pln_maladie (idpln_motif_maladie)');
        $this->addSql('CREATE TABLE sav.pln_reserve (idpln_reserve BIGSERIAL NOT NULL, idpln_motif_reserve INT DEFAULT 0, autre_motif VARCHAR(200) DEFAULT NULL, PRIMARY KEY(idpln_reserve))');
        $this->addSql('CREATE INDEX idx_pln_reserve_idpln_motif_reserve ON sav.pln_reserve (idpln_motif_reserve)');
        $this->addSql('CREATE TABLE sav.pln_reunion (idpln_reunion BIGSERIAL NOT NULL, idpln_reunion_lieu INT DEFAULT NULL, idpln_reunion_ordre_jour INT DEFAULT NULL, PRIMARY KEY(idpln_reunion))');
        $this->addSql('CREATE INDEX idx_pln_reunion_idpln_reunion_lieu ON sav.pln_reunion (idpln_reunion_lieu)');
        $this->addSql('CREATE INDEX idx_pln_reunion_idpln_reunion_ordre_jour ON sav.pln_reunion (idpln_reunion_ordre_jour)');
        $this->addSql('CREATE TABLE sav.pln_test (idpln_test BIGSERIAL NOT NULL, idpln_test_lieu INT DEFAULT NULL, idpln_test_intitule INT DEFAULT NULL, PRIMARY KEY(idpln_test))');
        $this->addSql('CREATE INDEX idx_pln_test_idpln_test_intitule ON sav.pln_test (idpln_test_intitule)');
        $this->addSql('CREATE INDEX idx_pln_test_idpln_test_lieu ON sav.pln_test (idpln_test_lieu)');
        $this->addSql('CREATE TABLE sav.moment_passage (id BIGSERIAL NOT NULL, libelle VARCHAR(8) DEFAULT NULL, libelle_pln VARCHAR(2) DEFAULT NULL, libelle_client VARCHAR(40) DEFAULT NULL, rang_tri SMALLINT DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.pln_horaires_passage (idpln_horaires_passage SERIAL NOT NULL, heuredebut VARCHAR(4) DEFAULT NULL, heurefin VARCHAR(4) DEFAULT NULL, momentjournee SMALLINT DEFAULT NULL, inactive SMALLINT DEFAULT NULL, PRIMARY KEY(idpln_horaires_passage))');
        $this->addSql('CREATE TABLE sav.pln_initiative_type (idplanning_initiative SERIAL NOT NULL, libelle VARCHAR(30) DEFAULT NULL, desactiver SMALLINT DEFAULT NULL, PRIMARY KEY(idplanning_initiative))');
        $this->addSql('CREATE TABLE sav.pln_parametres (idpln_parametres BIGSERIAL NOT NULL, idsite BIGINT DEFAULT 0, idparametre BIGINT DEFAULT 0 NOT NULL, nom_param VARCHAR(80) DEFAULT NULL, "séquence" BIGINT DEFAULT NULL, nom_utilisateur VARCHAR(50) DEFAULT NULL, valeur_alphanum VARCHAR(200) DEFAULT NULL, valeur_num NUMERIC(24, 6) DEFAULT NULL, "créer_le" TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, "créer_par" VARCHAR(50) DEFAULT NULL, maj_le TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, maj_par VARCHAR(50) DEFAULT NULL, note VARCHAR(200) DEFAULT NULL, regroupe_param VARCHAR(50) DEFAULT NULL, PRIMARY KEY(idpln_parametres))');
        $this->addSql('CREATE INDEX idx_pln_parametres_idsite ON sav.pln_parametres (idsite)');
        $this->addSql('CREATE INDEX "idx_pln_parametres_nom_paramséquencenom_utilisateur" ON sav.pln_parametres (nom_param, séquence, nom_utilisateur, idsite)');
        $this->addSql('CREATE TABLE sav.pln_config_req (idpln_config_req SERIAL NOT NULL, nom_requete VARCHAR(50) DEFAULT NULL, PRIMARY KEY(idpln_config_req))');
        $this->addSql('CREATE TABLE sav.pln_config_rub (idpln_config_rub_visite SERIAL NOT NULL, idpln_config_req INT DEFAULT NULL, code_rubrique VARCHAR(50) DEFAULT NULL, nomrubrique VARCHAR(50) DEFAULT NULL, libelle_rubrique VARCHAR(50) DEFAULT NULL, req_associee VARCHAR(50) DEFAULT NULL, nomrubriqueprio VARCHAR(50) DEFAULT NULL, PRIMARY KEY(idpln_config_rub_visite))');
        $this->addSql('CREATE INDEX idx_pln_config_rub_idpln_config_req ON sav.pln_config_rub (idpln_config_req)');
        $this->addSql('CREATE TABLE sav.pln_config_visite (idpln_config_visite SERIAL NOT NULL, idtype_visite BIGINT DEFAULT NULL, idpln_config_req INT DEFAULT NULL, temps_visite BIGINT DEFAULT NULL, poids_stats INT DEFAULT NULL, bc_largeur INT DEFAULT NULL, bc_contenu TEXT DEFAULT NULL, bd_largeur INT DEFAULT NULL, bd_contenu TEXT DEFAULT NULL, bd_visible SMALLINT DEFAULT NULL, info_contenu TEXT DEFAULT NULL, bulle TEXT DEFAULT NULL, bg_contenu TEXT DEFAULT NULL, x_split_g INT DEFAULT NULL, x_split_d INT DEFAULT NULL, bg_visible SMALLINT DEFAULT NULL, nb_tech SMALLINT DEFAULT NULL, gereretat SMALLINT DEFAULT NULL, gererpictos SMALLINT DEFAULT NULL, typeduree SMALLINT DEFAULT NULL, bd_gere_etat SMALLINT DEFAULT NULL, type_inactif_admin SMALLINT DEFAULT NULL, type_inactif SMALLINT DEFAULT NULL, bg_largeur INT DEFAULT NULL, PRIMARY KEY(idpln_config_visite))');
        $this->addSql('CREATE UNIQUE INDEX pln_config_visite_idtype_visite_key ON sav.pln_config_visite (idtype_visite)');
        $this->addSql('CREATE INDEX idx_pln_config_visite_type_inactif ON sav.pln_config_visite (type_inactif)');
        $this->addSql('CREATE INDEX idx_pln_config_visite_idpln_config_req ON sav.pln_config_visite (idpln_config_req)');
        $this->addSql('CREATE TABLE sav.pln_voiture_action (idpln_voiture_action SERIAL NOT NULL, lib_court VARCHAR(20) DEFAULT NULL, lib_long VARCHAR(50) DEFAULT NULL, desactiver SMALLINT DEFAULT NULL, PRIMARY KEY(idpln_voiture_action))');
        $this->addSql('CREATE TABLE sav.pln_voiture_lieu (idpln_voiture_lieu SERIAL NOT NULL, lib_court VARCHAR(20) DEFAULT NULL, lib_long VARCHAR(50) DEFAULT NULL, desactiver SMALLINT DEFAULT NULL, PRIMARY KEY(idpln_voiture_lieu))');
        $this->addSql('CREATE TABLE sav.formation (id SERIAL NOT NULL, libelle_court VARCHAR(20) DEFAULT NULL, libelle_long VARCHAR(80) DEFAULT NULL, actif BOOLEAN DEFAULT \'true\', PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.pln_formation_lieu (idpln_formation_lieu SERIAL NOT NULL, lib_court VARCHAR(20) DEFAULT NULL, lib_long VARCHAR(50) DEFAULT NULL, desactiver SMALLINT DEFAULT NULL, PRIMARY KEY(idpln_formation_lieu))');
        $this->addSql('CREATE TABLE sav.pln_formation_organisme (idpln_formation_organisme SERIAL NOT NULL, lib_court VARCHAR(20) DEFAULT NULL, lib_long VARCHAR(50) DEFAULT NULL, desactiver SMALLINT DEFAULT NULL, PRIMARY KEY(idpln_formation_organisme))');
        $this->addSql('CREATE TABLE sav.pln_groupes (idpln_groupes SERIAL NOT NULL, nom_groupe VARCHAR(50) DEFAULT NULL, libgroupe VARCHAR(50) DEFAULT NULL, PRIMARY KEY(idpln_groupes))');
        $this->addSql('CREATE TABLE sav.pln_groupes_droits_visite (idpln_groupes_droits_visite SERIAL NOT NULL, idtype_visite BIGINT DEFAULT NULL, idpln_groupes INT DEFAULT 0, droit BIGINT DEFAULT NULL, PRIMARY KEY(idpln_groupes_droits_visite))');
        $this->addSql('CREATE INDEX idx_pln_groupes_droits_visite_idtype_visite ON sav.pln_groupes_droits_visite (idtype_visite)');
        $this->addSql('CREATE INDEX idx_pln_groupes_droits_visite_code_visite_groupes ON sav.pln_groupes_droits_visite (idtype_visite, idpln_groupes)');
        $this->addSql('CREATE INDEX idx_pln_groupes_droits_visite_idpln_groupes ON sav.pln_groupes_droits_visite (idpln_groupes)');
        $this->addSql('CREATE TABLE sav.pln_motif_maladie (idpln_motif_maladie SERIAL NOT NULL, lib_court VARCHAR(20) DEFAULT NULL, lib_long VARCHAR(50) DEFAULT NULL, desactiver SMALLINT DEFAULT NULL, PRIMARY KEY(idpln_motif_maladie))');
        $this->addSql('CREATE TABLE sav.privilege_raison_refus (id BIGSERIAL NOT NULL, libelle VARCHAR(80) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.pln_motif_reserve (idpln_motif_reserve SERIAL NOT NULL, lib_court VARCHAR(20) DEFAULT NULL, lib_long VARCHAR(50) DEFAULT NULL, desactiver SMALLINT DEFAULT NULL, PRIMARY KEY(idpln_motif_reserve))');
        $this->addSql('CREATE TABLE sav.pln_reunion_lieu (idpln_reunion_lieu SERIAL NOT NULL, lib_court VARCHAR(20) DEFAULT NULL, lib_long VARCHAR(50) DEFAULT NULL, desactiver SMALLINT DEFAULT NULL, PRIMARY KEY(idpln_reunion_lieu))');
        $this->addSql('CREATE TABLE sav.pln_reunion_ordre_jour (idpln_reunion_ordre_jour SERIAL NOT NULL, lib_court VARCHAR(20) DEFAULT NULL, lib_long VARCHAR(120) DEFAULT NULL, desactiver SMALLINT DEFAULT NULL, PRIMARY KEY(idpln_reunion_ordre_jour))');
        $this->addSql('CREATE TABLE sav.pln_test_intitule (idpln_test_intitule SERIAL NOT NULL, lib_court VARCHAR(20) DEFAULT NULL, lib_long VARCHAR(80) DEFAULT NULL, desactiver SMALLINT DEFAULT NULL, PRIMARY KEY(idpln_test_intitule))');
        $this->addSql('CREATE TABLE sav.pln_test_lieu (idpln_test_lieu SERIAL NOT NULL, lib_court VARCHAR(20) DEFAULT NULL, lib_long VARCHAR(50) DEFAULT NULL, desactiver SMALLINT DEFAULT NULL, PRIMARY KEY(idpln_test_lieu))');
        $this->addSql('CREATE TABLE sav.pln_transit_groupe (idpln_transit_groupe BIGSERIAL NOT NULL, idpln_groupes INT DEFAULT NULL, transit_actif SMALLINT DEFAULT NULL, PRIMARY KEY(idpln_transit_groupe))');
        $this->addSql('CREATE INDEX idx_pln_transit_groupe_idpln_groupes ON sav.pln_transit_groupe (idpln_groupes)');
        $this->addSql('CREATE TABLE sav.privilege_statut (id INT DEFAULT 0 NOT NULL, libelle VARCHAR(200) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.produit_type (id BIGSERIAL NOT NULL, libelle VARCHAR(30) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.type_retour (id INT DEFAULT 0 NOT NULL, libelle VARCHAR(40) DEFAULT \'0\', PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.secteur_activite (id BIGSERIAL NOT NULL, objectif INT DEFAULT 0, libelle VARCHAR(30) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.secteur_tarif (id BIGSERIAL NOT NULL, libelle VARCHAR(20) DEFAULT NULL, tarif_ht_deplacement NUMERIC(24, 6) DEFAULT \'0\', PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.secteur_taux_retour (id BIGSERIAL NOT NULL, taux_retour INT DEFAULT 0, libelle VARCHAR(30) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.tva_equipement (idequipement_famille BIGINT DEFAULT 0 NOT NULL, idtype_client BIGINT DEFAULT 0 NOT NULL, logement_plus_2_ans BOOLEAN DEFAULT \'false\' NOT NULL, idtaux_tva SMALLINT DEFAULT 0, PRIMARY KEY(idequipement_famille, idtype_client, logement_plus_2_ans))');
        $this->addSql('CREATE INDEX idx_tva_equipement_idequipement_famille ON sav.tva_equipement (idequipement_famille)');
        $this->addSql('CREATE INDEX idx_tva_equipement_idtype_client ON sav.tva_equipement (idtype_client)');
        $this->addSql('CREATE INDEX idx_tva_equipement_idtaux_tva ON sav.tva_equipement (idtaux_tva)');
        $this->addSql('CREATE TABLE sav.taux_tva (id SMALLINT DEFAULT 0 NOT NULL, taux NUMERIC(24, 6) DEFAULT NULL, libelle VARCHAR(20) DEFAULT NULL, actif BOOLEAN DEFAULT \'true\', PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.type_visite_appareil (idtype_visite BIGINT DEFAULT 0 NOT NULL, idappareil INT NOT NULL, PRIMARY KEY(idtype_visite, idappareil))');
        $this->addSql('CREATE INDEX idx_type_visite_appareil_idtype_visite ON sav.type_visite_appareil (idtype_visite)');
        $this->addSql('CREATE INDEX idx_type_visite_appareil_idappareil ON sav.type_visite_appareil (idappareil)');
        $this->addSql('CREATE TABLE sav.visite_categorie (id VARCHAR(1) DEFAULT \'0\' NOT NULL, libelle VARCHAR(30) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.equipement_groupe (id BIGSERIAL NOT NULL, idequipement BIGINT DEFAULT 0, idgroupe_type BIGINT DEFAULT NULL, idgroupe INT DEFAULT 0, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_equipement_groupe_idgroupe ON sav.equipement_groupe (idgroupe)');
        $this->addSql('CREATE INDEX idx_equipement_groupe_idgroupe_type ON sav.equipement_groupe (idgroupe_type)');
        $this->addSql('CREATE INDEX idx_equipement_groupe_idequipement ON sav.equipement_groupe (idequipement)');
        $this->addSql('CREATE TABLE sav.equipement_option (id BIGSERIAL NOT NULL, idequipement BIGINT DEFAULT NULL, idtarif_option BIGINT DEFAULT 0, idc_sous_contrat BOOLEAN DEFAULT \'false\', opt_date TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, opt_contrat TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, prix_ht NUMERIC(24, 6) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX idx_equipement_option_idtarif_option ON sav.equipement_option (idtarif_option)');
        $this->addSql('CREATE INDEX idx_equipement_option_idequipement ON sav.equipement_option (idequipement)');
        $this->addSql('ALTER TABLE sav.mag_stock_mouvement ADD CONSTRAINT mag_stock_mouvement_idproduit_fkey FOREIGN KEY (idproduit) REFERENCES sav.produit (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.mag_stock_mouvement ADD CONSTRAINT mag_stock_mouvement_idsite_fkey FOREIGN KEY (idsite) REFERENCES sav.site (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.mag_stock_mouvement ADD CONSTRAINT mag_stock_mouvement_idutilisateur_fkey FOREIGN KEY (idutilisateur) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.produit_famille ADD CONSTRAINT produit_famille_idsite_fkey FOREIGN KEY (idsite) REFERENCES sav.site (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.produit_stock_site ADD CONSTRAINT produit_stock_site_idproduit_fkey FOREIGN KEY (idproduit) REFERENCES sav.produit (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.produit_stock_site ADD CONSTRAINT produit_stock_site_idsite_fkey FOREIGN KEY (idsite) REFERENCES sav.site (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.sectorisation_version ADD CONSTRAINT sectorisation_version_idsite_fkey FOREIGN KEY (idsite) REFERENCES sav.site (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.sectorisation_version ADD CONSTRAINT sectorisation_version_idutilisateur_fkey FOREIGN KEY (idutilisateur) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.stock_standard ADD CONSTRAINT stock_standard_idsite_fkey FOREIGN KEY (idsite) REFERENCES sav.site (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.tarif_option ADD CONSTRAINT tarif_option_idcontrat_type_fkey FOREIGN KEY (idcontrat_type) REFERENCES sav.contrat_type (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.tarif_option ADD CONSTRAINT tarif_option_idequipement_type_fkey FOREIGN KEY (idequipement_type) REFERENCES sav.equipement_type (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.tarif_option ADD CONSTRAINT tarif_option_idoption_fkey FOREIGN KEY (idoption) REFERENCES sav.option (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.contrat ADD CONSTRAINT contrat_idagent_souscription_fkey FOREIGN KEY (idagent_souscription) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.contrat ADD CONSTRAINT contrat_idcontrat_motif_resiliation_fkey FOREIGN KEY (idcontrat_motif_resiliation) REFERENCES sav.contrat_motif_resiliation (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.contrat ADD CONSTRAINT contrat_idcontrat_type_fkey FOREIGN KEY (idcontrat_type) REFERENCES sav.contrat_type (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.contrat ADD CONSTRAINT contrat_idequipement_fkey FOREIGN KEY (idequipement) REFERENCES sav.equipement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.contrat ADD CONSTRAINT contrat_idfacture_fkey FOREIGN KEY (idfacture) REFERENCES sav.facture (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.facture_ligne ADD CONSTRAINT facture_ligne_idfacture_fkey FOREIGN KEY (idfacture) REFERENCES sav.facture (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.facture_ligne ADD CONSTRAINT facture_ligne_idproduit_facture_affectation_fkey FOREIGN KEY (idproduit_facture_affectation) REFERENCES sav.produit_facture_affectation (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.facture_ligne ADD CONSTRAINT facture_ligne_idproduit_fkey FOREIGN KEY (idproduit) REFERENCES sav.produit (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.facture_relance ADD CONSTRAINT facture_relance_idfacture_fkey FOREIGN KEY (idfacture) REFERENCES sav.facture (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention ADD CONSTRAINT intervention_idcontrat_fkey FOREIGN KEY (idcontrat) REFERENCES sav.contrat (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention ADD CONSTRAINT intervention_idequipement_fkey FOREIGN KEY (idequipement) REFERENCES sav.equipement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention ADD CONSTRAINT intervention_idfacture_fkey FOREIGN KEY (idfacture) REFERENCES sav.facture (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention ADD CONSTRAINT intervention_idintervention_motif_fkey FOREIGN KEY (idintervention_motif) REFERENCES sav.intervention_motif (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention ADD CONSTRAINT intervention_idplanning_fkey FOREIGN KEY (idplanning) REFERENCES sav.planning (idplanning) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention ADD CONSTRAINT intervention_idtype_envoi_rapport_fkey FOREIGN KEY (idtype_envoi_rapport) REFERENCES sav.type_envoi (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention ADD CONSTRAINT intervention_idtype_visite_init_fkey FOREIGN KEY (idtype_visite_init) REFERENCES sav.type_visite (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.mag_commande_histo ADD CONSTRAINT mag_commande_histo_idcommande_fkey FOREIGN KEY (idmag_commande) REFERENCES sav.mag_commande (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.mag_commande_histo ADD CONSTRAINT mag_commande_histo_idmag_etat_commande_fkey FOREIGN KEY (idmag_etat_commande) REFERENCES sav.mag_etat_commande (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.mag_commande_histo ADD CONSTRAINT mag_commande_histo_idutilisateur_fkey FOREIGN KEY (idutilisateur) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.mag_jour_exclusion_livraison ADD CONSTRAINT mag_jour_exclusion_livraison_idagence_fkey FOREIGN KEY (idagence) REFERENCES sav.agence (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.mag_ligne_commande ADD CONSTRAINT mag_ligne_commande_idmag_commande_fkey FOREIGN KEY (idmag_commande) REFERENCES sav.mag_commande (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.mag_ligne_commande ADD CONSTRAINT mag_ligne_commande_idproduit_fkey FOREIGN KEY (idproduit) REFERENCES sav.produit (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.paiement ADD CONSTRAINT paiement_iddevis_fkey FOREIGN KEY (iddevis) REFERENCES sav.devis (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.paiement ADD CONSTRAINT paiement_idfacture_fkey FOREIGN KEY (idfacture) REFERENCES sav.facture (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.paiement ADD CONSTRAINT paiement_idmoyen_paiement_fkey FOREIGN KEY (idmoyen_paiement) REFERENCES sav.moyen_paiement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.produit_photo ADD CONSTRAINT produit_photo_idproduit_fkey FOREIGN KEY (idproduit) REFERENCES sav.produit (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.produit_tarif ADD CONSTRAINT produit_tarif_idproduit_fkey FOREIGN KEY (idproduit) REFERENCES sav.produit (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.secteur ADD CONSTRAINT secteur_idsecteur_activite_fkey FOREIGN KEY (idsecteur_activite) REFERENCES sav.secteur_activite (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.secteur ADD CONSTRAINT secteur_idsecteur_tarif_fkey FOREIGN KEY (idsecteur_tarif) REFERENCES sav.secteur_tarif (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.secteur ADD CONSTRAINT secteur_idsecteur_taux_retour_fkey FOREIGN KEY (idsecteur_taux_retour) REFERENCES sav.secteur_taux_retour (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.secteur ADD CONSTRAINT secteur_idsectorisation_version_fkey FOREIGN KEY (idsectorisation_version) REFERENCES sav.sectorisation_version (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.stock_standard_produit ADD CONSTRAINT stock_standard_produit_idproduit_fkey FOREIGN KEY (idproduit) REFERENCES sav.produit (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.stock_standard_produit ADD CONSTRAINT stock_standard_produit_idstock_standard_fkey FOREIGN KEY (idstock_standard) REFERENCES sav.stock_standard (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.adresse_complement ADD CONSTRAINT adresse_complement_idadresse_fkey FOREIGN KEY (idadresse) REFERENCES sav.adresse (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.adresse_complement ADD CONSTRAINT adresse_complement_idtype_complement_adresse_fkey FOREIGN KEY (idtype_complement_adresse) REFERENCES sav.type_complement_adresse (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.agent_appareil ADD CONSTRAINT agent_appareil_idappareil_fkey FOREIGN KEY (idappareil) REFERENCES sav.appareil (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.agent_appareil ADD CONSTRAINT agent_appareil_idutilisateur_agent_fkey FOREIGN KEY (idutilisateur_agent) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.agent_gps ADD CONSTRAINT agent_gps_idutilisateur_agent_fkey FOREIGN KEY (idutilisateur_agent) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.agent_qualification ADD CONSTRAINT agent_qualification_idequipement_famille_fkey FOREIGN KEY (idequipement_famille) REFERENCES sav.equipement_famille (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.agent_qualification ADD CONSTRAINT agent_qualification_idutilisateur_agent_fkey FOREIGN KEY (idutilisateur_agent) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.agent_secteur ADD CONSTRAINT agent_secteur_idsecteur_version_fkey FOREIGN KEY (idsecteur_version) REFERENCES sav.secteur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.agent_secteur ADD CONSTRAINT agent_secteur_idutilisateur_agent_fkey FOREIGN KEY (idutilisateur_agent) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.aide_technique_histo ADD CONSTRAINT aide_technique_histo_idaide_technique_etat_fkey FOREIGN KEY (idaide_technique_etat) REFERENCES sav.aide_technique_etat (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.aide_technique_histo ADD CONSTRAINT aide_technique_histo_idaide_technique_fkey FOREIGN KEY (idaide_technique) REFERENCES sav.aide_technique (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.aide_technique_histo ADD CONSTRAINT aide_technique_histo_idutilisateur_fkey FOREIGN KEY (idutilisateur) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.communication_client ADD CONSTRAINT communication_client_idclient_fkey FOREIGN KEY (idclient) REFERENCES sav.client (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.communication_client ADD CONSTRAINT communication_client_idcommunication_canal_fkey FOREIGN KEY (idcommunication_canal) REFERENCES sav.communication_canal (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.communication_client ADD CONSTRAINT communication_client_idcommunication_type_fkey FOREIGN KEY (idcommunication_type) REFERENCES sav.communication_type (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.communication_client ADD CONSTRAINT communication_client_idequipement_fkey FOREIGN KEY (idequipement) REFERENCES sav.equipement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.communication_client ADD CONSTRAINT communication_client_idintervention_fkey FOREIGN KEY (idintervention) REFERENCES sav.intervention (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.contrat_proposition ADD CONSTRAINT contrat_proposition_idcontrat_fkey FOREIGN KEY (idcontrat) REFERENCES sav.contrat (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.contrat_proposition ADD CONSTRAINT contrat_proposition_idcontrat_type_fkey FOREIGN KEY (idcontrat_type) REFERENCES sav.contrat_type (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.contrat_relance ADD CONSTRAINT contrat_relance_idcontrat_fkey FOREIGN KEY (idcontrat) REFERENCES sav.contrat (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.courrier_client ADD CONSTRAINT courrier_client_idequipement_fkey FOREIGN KEY (idequipement) REFERENCES sav.equipement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.courrier_client ADD CONSTRAINT courrier_client_idintervention_fkey FOREIGN KEY (idintervention) REFERENCES sav.intervention (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.devis ADD CONSTRAINT devis_idintervention_fkey FOREIGN KEY (idintervention) REFERENCES sav.intervention (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.equipement ADD CONSTRAINT equipement_idadresse_fkey FOREIGN KEY (idadresse) REFERENCES sav.adresse (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.equipement ADD CONSTRAINT equipement_idclient_fkey FOREIGN KEY (idclient) REFERENCES sav.client (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.equipement ADD CONSTRAINT equipement_idequipement_local_fkey FOREIGN KEY (idequipement_local) REFERENCES sav.equipement_local (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.equipement ADD CONSTRAINT equipement_idequipement_type_fkey FOREIGN KEY (idequipement_type) REFERENCES sav.equipement_type (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.equipement ADD CONSTRAINT equipement_idinstallateur_fkey FOREIGN KEY (idinstallateur) REFERENCES sav.installateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.equipement ADD CONSTRAINT equipement_idnature_gaz_fkey FOREIGN KEY (idnature_gaz) REFERENCES sav.nature_gaz (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.equipement ADD CONSTRAINT equipement_idprotection_sanitaire_fkey FOREIGN KEY (idprotection_sanitaire) REFERENCES sav.protection_sanitaire (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.equipement ADD CONSTRAINT equipement_idraccordement_fkey FOREIGN KEY (idraccordement) REFERENCES sav.raccordement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.equipement ADD CONSTRAINT equipement_idrobinet_remplissage_fkey FOREIGN KEY (idrobinet_remplissage) REFERENCES sav.robinet_remplissage (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.equipement ADD CONSTRAINT equipement_idtranche_equipement_fkey FOREIGN KEY (idtranche_equipement) REFERENCES sav.equipement_tranche (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.equipement_mesure ADD CONSTRAINT equipement_mesure_idequipement_fkey FOREIGN KEY (idequipement) REFERENCES sav.equipement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.equipement_mesure ADD CONSTRAINT equipement_mesure_idintervention_fkey FOREIGN KEY (idintervention) REFERENCES sav.intervention (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.historique_modification ADD CONSTRAINT historique_modification_idagent_fkey FOREIGN KEY (idagent) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.historique_modification ADD CONSTRAINT historique_modification_idclient_fkey FOREIGN KEY (idclient) REFERENCES sav.client (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.historique_modification ADD CONSTRAINT historique_modification_idequipement_fkey FOREIGN KEY (idequipement) REFERENCES sav.equipement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.historique_modification ADD CONSTRAINT historique_modification_idintervention_fkey FOREIGN KEY (idintervention) REFERENCES sav.intervention (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.historique_modification ADD CONSTRAINT historique_modification_idutilisateur_modif_fkey FOREIGN KEY (idutilisateur_modif) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.historique_modification ADD CONSTRAINT historique_modification_idutilisateur_valide_fkey FOREIGN KEY (idutilisateur_valide) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention_anomalie ADD CONSTRAINT intervention_anomalie_idanomalie_fkey FOREIGN KEY (idanomalie) REFERENCES sav.anomalie (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention_anomalie ADD CONSTRAINT intervention_anomalie_idintervention_fkey FOREIGN KEY (idintervention) REFERENCES sav.intervention (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention_documents ADD CONSTRAINT intervention_documents_idintervention_fkey FOREIGN KEY (idintervention) REFERENCES sav.intervention (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention_media ADD CONSTRAINT intervention_media_idintervention_fkey FOREIGN KEY (idintervention) REFERENCES sav.intervention (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention_observation ADD CONSTRAINT intervention_observation_idintervention_fkey FOREIGN KEY (idintervention) REFERENCES sav.intervention (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention_payeur_externe ADD CONSTRAINT intervention_payeur_externe_idadresse_fkey FOREIGN KEY (idadresse) REFERENCES sav.adresse (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention_payeur_externe ADD CONSTRAINT intervention_payeur_externe_idintervention_fkey FOREIGN KEY (idintervention) REFERENCES sav.intervention (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention_payeur_externe ADD CONSTRAINT intervention_payeur_externe_idtype_client_fkey FOREIGN KEY (idtype_client) REFERENCES sav.type_client (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention_pre_encaissement ADD CONSTRAINT intervention_pre_encaissement_idintervention_fkey FOREIGN KEY (idintervention) REFERENCES sav.intervention (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention_pre_encaissement ADD CONSTRAINT intervention_pre_encaissement_idmoyen_paiement_fkey FOREIGN KEY (idmoyen_paiement) REFERENCES sav.moyen_paiement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention_retour ADD CONSTRAINT intervention_retour_idintervention_fkey FOREIGN KEY (idintervention) REFERENCES sav.intervention (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention_retour ADD CONSTRAINT intervention_retour_idretour_fkey FOREIGN KEY (idretour) REFERENCES sav.retour (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention_stack ADD CONSTRAINT intervention_retour_idagent_fkey FOREIGN KEY (idagent) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning ADD CONSTRAINT planning_idequipement_fkey FOREIGN KEY (idequipement) REFERENCES sav.equipement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning ADD CONSTRAINT planning_idpln_annulation_fkey FOREIGN KEY (idpln_annulation) REFERENCES sav.intervention_annulation (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning ADD CONSTRAINT planning_idpln_controle_voiture_fkey FOREIGN KEY (idpln_controle_voiture) REFERENCES sav.pln_controle_voiture (idpln_controle_voiture) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning ADD CONSTRAINT planning_idpln_formation_fkey FOREIGN KEY (idpln_formation) REFERENCES sav.pln_formation (idpln_formation) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning ADD CONSTRAINT planning_idpln_horaires_passage_fkey FOREIGN KEY (idpln_horaires_passage) REFERENCES sav.pln_horaires_passage (idpln_horaires_passage) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning ADD CONSTRAINT planning_idpln_maladie_fkey FOREIGN KEY (idpln_maladie) REFERENCES sav.pln_maladie (idpln_maladie) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning ADD CONSTRAINT planning_idpln_reserve_fkey FOREIGN KEY (idpln_reserve) REFERENCES sav.pln_reserve (idpln_reserve) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning ADD CONSTRAINT planning_idpln_reunion_fkey FOREIGN KEY (idpln_reunion) REFERENCES sav.pln_reunion (idpln_reunion) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning ADD CONSTRAINT planning_idpln_test_fkey FOREIGN KEY (idpln_test) REFERENCES sav.pln_test (idpln_test) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning ADD CONSTRAINT planning_idpln_transit_fkey FOREIGN KEY (idpln_transit) REFERENCES sav.pln_transit (idpln_transit) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning ADD CONSTRAINT planning_idtype_visite_fkey FOREIGN KEY (idtype_visite) REFERENCES sav.type_visite (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning ADD CONSTRAINT planning_idutilisateur_agent_fkey FOREIGN KEY (idutilisateur_agent) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning ADD CONSTRAINT planning_idmoment_passage_fkey FOREIGN KEY (idmoment_passage) REFERENCES sav.moment_passage (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning_agents_liste ADD CONSTRAINT planning_agents_liste_idpln_liste_agents_fkey FOREIGN KEY (idpln_liste_agents) REFERENCES sav.planning_liste_agents (idpln_liste_agents) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning_agents_liste ADD CONSTRAINT planning_agents_liste_idutilisateur_agent_fkey FOREIGN KEY (idutilisateur_agent) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning_conflit ADD CONSTRAINT planning_conflit_idequipement_fkey FOREIGN KEY (idequipement) REFERENCES sav.equipement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning_conflit ADD CONSTRAINT planning_conflit_idplanning_fkey FOREIGN KEY (idplanning) REFERENCES sav.planning (idplanning) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning_conflit ADD CONSTRAINT planning_conflit_idutilisateur_fkey FOREIGN KEY (idutilisateur) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning_historique_modification ADD CONSTRAINT planning_historique_modification_code_action_fkey FOREIGN KEY (code_action) REFERENCES sav.planning_action (code_action) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning_historique_modification ADD CONSTRAINT planning_historique_modification_idagent_fkey FOREIGN KEY (idagent) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning_historique_modification ADD CONSTRAINT planning_historique_modification_idequipement_fkey FOREIGN KEY (idequipement) REFERENCES sav.equipement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning_historique_modification ADD CONSTRAINT planning_historique_modification_idplanning_fkey FOREIGN KEY (idplanning) REFERENCES sav.planning (idplanning) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning_historique_modification ADD CONSTRAINT planning_historique_modification_idplanning_initiative_fkey FOREIGN KEY (idplanning_initiative) REFERENCES sav.pln_initiative_type (idplanning_initiative) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning_historique_modification ADD CONSTRAINT planning_historique_modification_idpln_initiative_interv_fkey FOREIGN KEY (idpln_initiative_interv) REFERENCES sav.planning_initiative_detail (idpln_initiative_interv) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning_historique_modification ADD CONSTRAINT planning_historique_modification_idutilisateur_fkey FOREIGN KEY (idutilisateur) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning_historique_modification ADD CONSTRAINT planning_historique_modification_moment_fkey FOREIGN KEY (moment) REFERENCES sav.moment_passage (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_agent_blocage ADD CONSTRAINT pln_agent_blocage_idutilisateur_agent_fkey FOREIGN KEY (idutilisateur_agent) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_agent_blocage ADD CONSTRAINT pln_agent_blocage_idutilisateur_fkey FOREIGN KEY (idutilisateur) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_droits_visite ADD CONSTRAINT pln_droits_visite_idtype_visite_fkey FOREIGN KEY (idtype_visite) REFERENCES sav.type_visite (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_droits_visite ADD CONSTRAINT pln_droits_visite_idutilisateur_fkey FOREIGN KEY (idutilisateur) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_groupe_utilisateurs ADD CONSTRAINT pln_groupe_utilisateurs_idpln_groupes_fkey FOREIGN KEY (idpln_groupes) REFERENCES sav.pln_groupes (idpln_groupes) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_groupe_utilisateurs ADD CONSTRAINT pln_groupe_utilisateurs_idutilisateur_fkey FOREIGN KEY (idutilisateur) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_transit ADD CONSTRAINT pln_transit_idutilisateur_fkey FOREIGN KEY (idutilisateur) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_transit_utilisateur ADD CONSTRAINT pln_transit_utilisateur_idutilisateur_fkey FOREIGN KEY (idutilisateur) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_visite_exclusion ADD CONSTRAINT pln_visite_exclusion_idtype_visite_fkey FOREIGN KEY (idtype_visite) REFERENCES sav.type_visite (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_visite_exclusion ADD CONSTRAINT pln_visite_exclusion_idutilisateur_fkey FOREIGN KEY (idutilisateur) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.privilege ADD CONSTRAINT privilege_idequipement_fkey FOREIGN KEY (idequipement) REFERENCES sav.equipement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.privilege ADD CONSTRAINT privilege_idintervention_fkey FOREIGN KEY (idintervention) REFERENCES sav.intervention (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.privilege ADD CONSTRAINT privilege_statut_privilege_fkey FOREIGN KEY (idprivilege_statut) REFERENCES sav.privilege_statut (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.privilege ADD CONSTRAINT privilege_idraison_refus_fkey FOREIGN KEY (idraison_refus) REFERENCES sav.privilege_raison_refus (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.secteur_equipement ADD CONSTRAINT secteur_equipement_idequipement_fkey FOREIGN KEY (idequipement) REFERENCES sav.equipement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.secteur_equipement ADD CONSTRAINT secteur_equipement_idsecteur_version_fkey FOREIGN KEY (idsecteur_version) REFERENCES sav.secteur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.agent_produit_stock ADD CONSTRAINT agent_produit_stock_idsite_fkey FOREIGN KEY (idsite) REFERENCES sav.site (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.agent_produit_stock ADD CONSTRAINT agent_produit_stock_idutilisateur_fkey FOREIGN KEY (idutilisateur) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.adresse ADD CONSTRAINT adresse_idagence_fkey FOREIGN KEY (idagence) REFERENCES sav.agence (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.adresse ADD CONSTRAINT adresse_idclient_fkey FOREIGN KEY (idclient) REFERENCES sav.client (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.adresse ADD CONSTRAINT adresse_idtype_adresse_fkey FOREIGN KEY (idtype_adresse) REFERENCES sav.type_adresse (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.adresse ADD CONSTRAINT adresse_idtype_logement_fkey FOREIGN KEY (idtype_logement) REFERENCES sav.type_logement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.aide_technique ADD CONSTRAINT aide_technique_idaide_technique_etat_fkey FOREIGN KEY (idaide_technique_etat) REFERENCES sav.aide_technique_etat (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.aide_technique ADD CONSTRAINT aide_technique_idequipement_fkey FOREIGN KEY (idequipement) REFERENCES sav.equipement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.aide_technique ADD CONSTRAINT aide_technique_idtype_demandeur_fkey FOREIGN KEY (idtype_demandeur) REFERENCES sav.type_demandeur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.client ADD CONSTRAINT client_code_ec_fkey FOREIGN KEY (code_ec) REFERENCES sav.etat_civil (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.client ADD CONSTRAINT client_idcategorie_pro_fkey FOREIGN KEY (idcategorie_pro) REFERENCES sav.categorie_pro (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.client ADD CONSTRAINT client_idcompte_client_web_fkey FOREIGN KEY (idcompte_client_web) REFERENCES sav.compte_client_web (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.client ADD CONSTRAINT client_idsouscripteur_fkey FOREIGN KEY (idsouscripteur) REFERENCES sav.client (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.client ADD CONSTRAINT client_idtype_client_fkey FOREIGN KEY (idtype_client) REFERENCES sav.type_client (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.demande_documentation ADD CONSTRAINT demande_documentation_idequipement_fkey FOREIGN KEY (idequipement) REFERENCES sav.type_demandeur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.demande_documentation ADD CONSTRAINT demande_documentation_idtype_demandeur_fkey FOREIGN KEY (idtype_demandeur) REFERENCES sav.equipement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.attachement_parametre ADD CONSTRAINT attachement_parametre_idattachement_parametre_liste_fkey FOREIGN KEY (idattachement_parametre_liste) REFERENCES sav.attachement_parametre_liste (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.type_visite ADD CONSTRAINT type_visite_idcategorie_visite_fkey FOREIGN KEY (idcategorie_visite) REFERENCES sav.visite_categorie (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.attachement_type_visite ADD CONSTRAINT attachement_type_visite_idtype_visite_fkey FOREIGN KEY (idtype_visite) REFERENCES sav.type_visite (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.classification_energetique ADD CONSTRAINT classification_energetique_idclasse_energetique_fkey FOREIGN KEY (idclasse_energetique) REFERENCES sav.classe_energetique (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.classification_energetique ADD CONSTRAINT classification_energetique_idclasse_rendement_fkey FOREIGN KEY (idclasse_rendement) REFERENCES sav.classe_rendement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.classification_energetique ADD CONSTRAINT classification_energetique_idequipement_type_fkey FOREIGN KEY (idequipement_type) REFERENCES sav.equipement_type (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.equipement_type ADD CONSTRAINT equipement_type_idequipement_famille_fkey FOREIGN KEY (idequipement_famille) REFERENCES sav.equipement_famille (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.client_email ADD CONSTRAINT client_email_idclient_fkey FOREIGN KEY (idclient) REFERENCES sav.client (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.client_tel ADD CONSTRAINT client_tel_idclient_fkey FOREIGN KEY (idclient) REFERENCES sav.client (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.client_tel ADD CONSTRAINT client_tel_idtype_tel_fkey FOREIGN KEY (idtype_tel) REFERENCES sav.type_tel (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.facture ADD CONSTRAINT facture_idadresse_fkey FOREIGN KEY (idadresse) REFERENCES sav.adresse (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.facture ADD CONSTRAINT facture_idagence_fkey FOREIGN KEY (idagence) REFERENCES sav.agence (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.facture ADD CONSTRAINT facture_idcategorie_facture_fkey FOREIGN KEY (idcategorie_facture) REFERENCES sav.categorie_facture (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.facture ADD CONSTRAINT facture_iddevis_fkey FOREIGN KEY (iddevis) REFERENCES sav.devis (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.facture ADD CONSTRAINT facture_idequipement_fkey FOREIGN KEY (idequipement) REFERENCES sav.equipement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.facture ADD CONSTRAINT facture_idfacture_type_fkey FOREIGN KEY (idfacture_type) REFERENCES sav.facture_type (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.facture ADD CONSTRAINT facture_idintervention_fkey FOREIGN KEY (idintervention) REFERENCES sav.intervention (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.facture ADD CONSTRAINT facture_idsite_fkey FOREIGN KEY (idsite) REFERENCES sav.site (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.produit ADD CONSTRAINT produit_idproduit_famille_fkey FOREIGN KEY (idproduit_famille) REFERENCES sav.produit_famille (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.produit ADD CONSTRAINT produit_idproduit_type_fkey FOREIGN KEY (idproduit_type) REFERENCES sav.produit_type (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.produit ADD CONSTRAINT produit_idsite_fkey FOREIGN KEY (idsite) REFERENCES sav.site (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.equipement_complement ADD CONSTRAINT equipement_complement_idequipement_fkey FOREIGN KEY (idequipement) REFERENCES sav.equipement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.equipement_complement ADD CONSTRAINT equipement_complement_idtype_complement_fkey FOREIGN KEY (idtype_complement) REFERENCES sav.type_complement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.contrat_tarif ADD CONSTRAINT contrat_tarif_idcontrat_type_fkey FOREIGN KEY (idcontrat_type) REFERENCES sav.contrat_type (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.contrat_tarif ADD CONSTRAINT contrat_tarif_idequipement_type_fkey FOREIGN KEY (idequipement_type) REFERENCES sav.equipement_type (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.contrat_tarif ADD CONSTRAINT contrat_tarif_idpuissance_fkey FOREIGN KEY (idpuissance) REFERENCES sav.puissance (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.equipement_zone ADD CONSTRAINT equipement_zone_idequipement_fkey FOREIGN KEY (idequipement) REFERENCES sav.equipement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.equipement_zone ADD CONSTRAINT equipement_zone_idtype_zone_fkey FOREIGN KEY (idtype_zone) REFERENCES sav.type_zone (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.historique_client_equipement ADD CONSTRAINT historique_client_equipement_idclient_fkey FOREIGN KEY (idclient) REFERENCES sav.client (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.historique_client_equipement ADD CONSTRAINT historique_client_equipement_idequipement_fkey FOREIGN KEY (idequipement) REFERENCES sav.equipement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.historique_client_equipement ADD CONSTRAINT historique_client_equipement_idsouscripteur_fkey FOREIGN KEY (idsouscripteur) REFERENCES sav.client (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.mag_commande ADD CONSTRAINT mag_commande_idagence_fkey FOREIGN KEY (idagence) REFERENCES sav.agence (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.mag_commande ADD CONSTRAINT mag_commande_idequipement_fkey FOREIGN KEY (idequipement) REFERENCES sav.equipement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.mag_commande ADD CONSTRAINT mag_commande_idintervention_fkey FOREIGN KEY (idintervention) REFERENCES sav.intervention (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.mag_commande ADD CONSTRAINT mag_commande_idmag_etat_commande_fkey FOREIGN KEY (idmag_etat_commande) REFERENCES sav.mag_etat_commande (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.mag_commande ADD CONSTRAINT mag_commande_idsite_fkey FOREIGN KEY (idsite) REFERENCES sav.site (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.mag_commande ADD CONSTRAINT mag_commande_idsite_livraison_fkey FOREIGN KEY (idsite_livraison) REFERENCES sav.site (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.mag_commande ADD CONSTRAINT mag_commande_idutilisateur_fkey FOREIGN KEY (idutilisateur) REFERENCES sav.utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.mag_commande ADD CONSTRAINT mag_commande_idtype_cde_fkey FOREIGN KEY (idtype_cde) REFERENCES sav.mag_type_commande (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention_annulation ADD CONSTRAINT intervention_annulation_idintervention_motif_abandon_fkey FOREIGN KEY (idintervention_motif_abandon) REFERENCES sav.intervention_motif_abandon (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention_annulation ADD CONSTRAINT intervention_annulation_idintervention_motif_absence_fkey FOREIGN KEY (idintervention_motif_absence) REFERENCES sav.intervention_motif_absence (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention_annulation ADD CONSTRAINT intervention_annulation_idintervention_motif_annulation_fkey FOREIGN KEY (idintervention_motif_annulation) REFERENCES sav.intervention_motif_annulation (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.intervention_annulation ADD CONSTRAINT intervention_annulation_idplanning_fkey FOREIGN KEY (idplanning) REFERENCES sav.planning (idplanning) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.old_bloc_note_client ADD CONSTRAINT old_bloc_note_client_idequipement_fkey FOREIGN KEY (idequipement) REFERENCES sav.equipement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.aide_technique_classification ADD CONSTRAINT aide_technique_classification_idaide_technique_classificat_fkey FOREIGN KEY (idaide_technique_classification_liste) REFERENCES sav.aide_technique_classification_liste (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.aide_technique_classification ADD CONSTRAINT aide_technique_classification_idaide_technique_fkey FOREIGN KEY (idaide_technique) REFERENCES sav.aide_technique (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.retour ADD CONSTRAINT retour_idtype_retour_fkey FOREIGN KEY (idtype_retour) REFERENCES sav.type_retour (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.planning_initiative_detail ADD CONSTRAINT planning_initiative_detail_idplanning_initiative_fkey FOREIGN KEY (idplanning_initiative) REFERENCES sav.pln_initiative_type (idplanning_initiative) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_controle_voiture ADD CONSTRAINT pln_controle_voiture_idpln_voiture_action_fkey FOREIGN KEY (idpln_voiture_action) REFERENCES sav.pln_voiture_action (idpln_voiture_action) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_controle_voiture ADD CONSTRAINT pln_controle_voiture_idpln_voiture_lieu_fkey FOREIGN KEY (idpln_voiture_lieu) REFERENCES sav.pln_voiture_lieu (idpln_voiture_lieu) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_formation ADD CONSTRAINT pln_formation_idpln_formation_intitule_fkey FOREIGN KEY (idpln_formation_intitule) REFERENCES sav.formation (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_formation ADD CONSTRAINT pln_formation_idpln_formation_lieu_fkey FOREIGN KEY (idpln_formation_lieu) REFERENCES sav.pln_formation_lieu (idpln_formation_lieu) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_formation ADD CONSTRAINT pln_formation_idpln_formation_organisme_fkey FOREIGN KEY (idpln_formation_organisme) REFERENCES sav.pln_formation_organisme (idpln_formation_organisme) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_maladie ADD CONSTRAINT pln_maladie_idpln_motif_maladie_fkey FOREIGN KEY (idpln_motif_maladie) REFERENCES sav.pln_motif_maladie (idpln_motif_maladie) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_reserve ADD CONSTRAINT pln_reserve_idpln_motif_reserve_fkey FOREIGN KEY (idpln_motif_reserve) REFERENCES sav.pln_motif_reserve (idpln_motif_reserve) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_reunion ADD CONSTRAINT pln_reunion_idpln_reunion_lieu_fkey FOREIGN KEY (idpln_reunion_lieu) REFERENCES sav.pln_reunion_lieu (idpln_reunion_lieu) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_reunion ADD CONSTRAINT pln_reunion_idpln_reunion_ordre_jour_fkey FOREIGN KEY (idpln_reunion_ordre_jour) REFERENCES sav.pln_reunion_ordre_jour (idpln_reunion_ordre_jour) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_test ADD CONSTRAINT pln_test_idpln_test_intitule_fkey FOREIGN KEY (idpln_test_intitule) REFERENCES sav.pln_test_intitule (idpln_test_intitule) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_test ADD CONSTRAINT pln_test_idpln_test_lieu_fkey FOREIGN KEY (idpln_test_lieu) REFERENCES sav.pln_test_lieu (idpln_test_lieu) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_parametres ADD CONSTRAINT pln_parametres_idsite_fkey FOREIGN KEY (idsite) REFERENCES sav.site (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_config_rub ADD CONSTRAINT pln_config_rub_idpln_config_req_fkey FOREIGN KEY (idpln_config_req) REFERENCES sav.pln_config_req (idpln_config_req) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_config_visite ADD CONSTRAINT pln_config_visite_idpln_config_req_fkey FOREIGN KEY (idpln_config_req) REFERENCES sav.pln_config_req (idpln_config_req) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_config_visite ADD CONSTRAINT pln_config_visite_idtype_visite_fkey FOREIGN KEY (idtype_visite) REFERENCES sav.type_visite (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_groupes_droits_visite ADD CONSTRAINT pln_groupes_droits_visite_idpln_groupes_fkey FOREIGN KEY (idpln_groupes) REFERENCES sav.pln_groupes (idpln_groupes) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_groupes_droits_visite ADD CONSTRAINT pln_groupes_droits_visite_idtype_visite_fkey FOREIGN KEY (idtype_visite) REFERENCES sav.type_visite (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.pln_transit_groupe ADD CONSTRAINT pln_transit_groupe_idpln_groupes_fkey FOREIGN KEY (idpln_groupes) REFERENCES sav.pln_groupes (idpln_groupes) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.tva_equipement ADD CONSTRAINT tva_equipement_idequipement_famille_fkey FOREIGN KEY (idequipement_famille) REFERENCES sav.equipement_famille (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.tva_equipement ADD CONSTRAINT tva_equipement_idtaux_tva_fkey FOREIGN KEY (idtaux_tva) REFERENCES sav.taux_tva (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.tva_equipement ADD CONSTRAINT tva_equipement_idtype_client_fkey FOREIGN KEY (idtype_client) REFERENCES sav.type_client (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.type_visite_appareil ADD CONSTRAINT type_visite_appareil_idappareil_fkey FOREIGN KEY (idappareil) REFERENCES sav.appareil (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.type_visite_appareil ADD CONSTRAINT type_visite_appareil_idtype_visite_fkey FOREIGN KEY (idtype_visite) REFERENCES sav.type_visite (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.equipement_groupe ADD CONSTRAINT equipement_groupe_idequipement_fkey FOREIGN KEY (idequipement) REFERENCES sav.equipement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.equipement_groupe ADD CONSTRAINT equipement_groupe_idgroupe_type_fkey FOREIGN KEY (idgroupe_type) REFERENCES sav.groupe_type (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.equipement_option ADD CONSTRAINT equipement_option_idequipement_fkey FOREIGN KEY (idequipement) REFERENCES sav.equipement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.equipement_option ADD CONSTRAINT equipement_option_idtarif_option_fkey FOREIGN KEY (idtarif_option) REFERENCES sav.tarif_option (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('DROP TABLE agent');
        $this->addSql('DROP TABLE category');
        $this->addSql('DROP TABLE category_pro');
        $this->addSql('DROP TABLE client');
        $this->addSql('DROP TABLE client_mail');
        $this->addSql('DROP TABLE client_tel');
        $this->addSql('DROP TABLE sav.droit_portail');
        $this->addSql('DROP TABLE email');
        $this->addSql('DROP TABLE equipement');
        $this->addSql('DROP TABLE famille');
        $this->addSql('DROP TABLE sav.groupe_droit_portail');
        $this->addSql('DROP TABLE intervention');
        $this->addSql('DROP TABLE observation');
        $this->addSql('DROP TABLE "option"');
        $this->addSql('DROP TABLE options');
        $this->addSql('DROP TABLE puissance');
        $this->addSql('DROP TABLE regle_attachement');
        $this->addSql('DROP TABLE regle_attachement_profil');
        $this->addSql('DROP TABLE taux_tva');
        $this->addSql('DROP TABLE type');
        $this->addSql('DROP TABLE type_agent');
        $this->addSql('DROP TABLE type_client');
        $this->addSql('DROP TABLE type_intervention');
        $this->addSql('DROP TABLE type_sav');
        $this->addSql('ALTER TABLE sav.pole_site ALTER id TYPE BIGINT');
        $this->addSql('CREATE SEQUENCE sav.pole_site_id_seq');
        $this->addSql('SELECT setval(\'sav.pole_site_id_seq\', (SELECT MAX(id) FROM sav.pole_site))');
        $this->addSql('ALTER TABLE sav.pole_site ALTER id SET DEFAULT nextval(\'sav.pole_site_id_seq\')');
        $this->addSql('ALTER TABLE sav.pole_site ALTER idsite TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.pole_site ALTER idsite DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.pole_site ALTER libelle DROP NOT NULL');
        $this->addSql('ALTER INDEX sav.idx_e3bd9a24ba8cf844 RENAME TO idx_pole_site_idsite');
        $this->addSql('ALTER TABLE sav.tchat_groupe ALTER id TYPE BIGINT');
        $this->addSql('CREATE SEQUENCE sav.tchat_groupe_id_seq');
        $this->addSql('SELECT setval(\'sav.tchat_groupe_id_seq\', (SELECT MAX(id) FROM sav.tchat_groupe))');
        $this->addSql('ALTER TABLE sav.tchat_groupe ALTER id SET DEFAULT nextval(\'sav.tchat_groupe_id_seq\')');
        $this->addSql('ALTER TABLE sav.tchat_groupe ALTER idtchat_groupe_type TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.tchat_groupe ALTER idtchat_groupe_type DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.tchat_groupe ALTER idtchat_groupe_type DROP NOT NULL');
        $this->addSql('ALTER TABLE sav.tchat_groupe ALTER idutilisateur_admin_groupe TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.tchat_groupe ALTER idutilisateur_admin_groupe SET DEFAULT 0');
        $this->addSql('ALTER TABLE sav.tchat_groupe ALTER idsite TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.tchat_groupe ALTER idsite DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.tchat_groupe ALTER nom TYPE VARCHAR(50)');
        $this->addSql('ALTER INDEX sav.idx_954bdd64ba8cf844 RENAME TO idx_tchat_groupe_idsite');
        $this->addSql('ALTER INDEX sav.idx_954bdd64352b2e5e RENAME TO idx_tchat_groupe_idutilisateur_admin_groupe');
        $this->addSql('ALTER INDEX sav.idx_954bdd6463e7ac37 RENAME TO idx_tchat_groupe_idtchat_groupe_type');
        $this->addSql('DROP INDEX tchat_groupe_utilisateur_pkey');
        $this->addSql('ALTER TABLE sav.tchat_groupe_utilisateur ALTER idutilisateur TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.tchat_groupe_utilisateur ALTER idutilisateur SET DEFAULT 0');
        $this->addSql('ALTER TABLE sav.tchat_groupe_utilisateur ALTER idtchat_groupe TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.tchat_groupe_utilisateur ALTER idtchat_groupe SET DEFAULT 0');
        $this->addSql('ALTER TABLE sav.tchat_groupe_utilisateur ALTER notification SET DEFAULT \'true\'');
        $this->addSql('ALTER TABLE sav.tchat_groupe_utilisateur ADD PRIMARY KEY (idutilisateur, idtchat_groupe)');
        $this->addSql('ALTER INDEX sav.idx_4a66d8a0dbdd131c RENAME TO idx_tchat_groupe_utilisateur_idutilisateur');
        $this->addSql('ALTER INDEX sav.idx_4a66d8a012d40901 RENAME TO idx_tchat_groupe_utilisateur_idtchat_groupe');
        $this->addSql('ALTER TABLE sav.tchat_message ALTER id TYPE BIGINT');
        $this->addSql('CREATE SEQUENCE sav.tchat_message_id_seq');
        $this->addSql('SELECT setval(\'sav.tchat_message_id_seq\', (SELECT MAX(id) FROM sav.tchat_message))');
        $this->addSql('ALTER TABLE sav.tchat_message ALTER id SET DEFAULT nextval(\'sav.tchat_message_id_seq\')');
        $this->addSql('ALTER TABLE sav.tchat_message ALTER idutilisateur TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.tchat_message ALTER idutilisateur DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.tchat_message ALTER idtchat_groupe TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.tchat_message ALTER idtchat_groupe DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.tchat_message ALTER contenu DROP NOT NULL');
        $this->addSql('ALTER INDEX sav.idx_b09a7731dbdd131c RENAME TO idx_tchat_message_idutilisateur');
        $this->addSql('ALTER INDEX sav.idx_b09a773112d40901 RENAME TO idx_tchat_message_idtchat_groupe');
        $this->addSql('DROP INDEX UNIQ_4CAAA48DAA08CB10');
        $this->addSql('ALTER TABLE sav.utilisateur ADD role_id INT DEFAULT NULL');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER id TYPE BIGINT');
        $this->addSql('CREATE SEQUENCE sav.utilisateur_id_seq');
        $this->addSql('SELECT setval(\'sav.utilisateur_id_seq\', (SELECT MAX(id) FROM sav.utilisateur))');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER id SET DEFAULT nextval(\'sav.utilisateur_id_seq\')');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idtype_login TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idtype_login DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idtype_login DROP NOT NULL');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idtype_utilisateur TYPE SMALLINT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idtype_utilisateur SET DEFAULT 0');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idtype_utilisateur DROP NOT NULL');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idutilisateur_responsable TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idutilisateur_responsable DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idutilisateur_valide_conges TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idutilisateur_valide_conges DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idpole_site TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idpole_site DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idagence TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER idagence DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER nom TYPE VARCHAR(50)');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER prenom TYPE VARCHAR(50)');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER password TYPE VARCHAR(64)');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER cle_salage TYPE VARCHAR(50)');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER url_homepage TYPE VARCHAR(250)');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER date_embauche TYPE TIMESTAMP(0) WITHOUT TIME ZONE');
        $this->addSql('ALTER TABLE sav.utilisateur ALTER date_embauche DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur ADD CONSTRAINT utilisateur_role FOREIGN KEY (role_id) REFERENCES sav.utilisateur_role (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('CREATE INDEX fki_utilisateur_role ON sav.utilisateur (role_id)');
        $this->addSql('CREATE UNIQUE INDEX utilisateur_code_client_agi_key ON sav.utilisateur (code_client_agi)');
        $this->addSql('ALTER INDEX sav.idx_4caaa48d4be50acf RENAME TO idx_utilisateur_idutilisateur_valide_conges');
        $this->addSql('ALTER INDEX sav.idx_4caaa48d8711fa03 RENAME TO idx_utilisateur_idpole_site');
        $this->addSql('ALTER INDEX sav.idx_4caaa48de546653 RENAME TO idx_utilisateur_idutilisateur_responsable');
        $this->addSql('ALTER INDEX sav.idx_4caaa48d7c3705 RENAME TO idx_utilisateur_idagence');
        $this->addSql('ALTER INDEX sav.idx_4caaa48d69ad51dd RENAME TO idx_utilisateur_idtype_login');
        $this->addSql('ALTER INDEX sav.idx_4caaa48dc2809046 RENAME TO idx_utilisateur_idtype_utilisateur');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER id TYPE BIGINT');
        $this->addSql('CREATE SEQUENCE sav.utilisateur_affectation_id_seq');
        $this->addSql('SELECT setval(\'sav.utilisateur_affectation_id_seq\', (SELECT MAX(id) FROM sav.utilisateur_affectation))');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER id SET DEFAULT nextval(\'sav.utilisateur_affectation_id_seq\')');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idutilisateur TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idutilisateur SET DEFAULT 0');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idutilisateur DROP NOT NULL');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idutilisateur_profil TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idutilisateur_profil DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idutilisateur_planning TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idutilisateur_planning DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idutilisateur_responsable TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idutilisateur_responsable DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idpole_site TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idpole_site DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idutilisateur_binome TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idutilisateur_binome DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idmotif_temps_partiel TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER idmotif_temps_partiel DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER planifiable SET DEFAULT \'false\'');
        $this->addSql('ALTER TABLE sav.utilisateur_affectation ALTER temps_travail SET DEFAULT 0');
        $this->addSql('ALTER INDEX sav.idx_93701ee28711fa03 RENAME TO idx_utilisateur_affectation_idpole_site');
        $this->addSql('ALTER INDEX sav.idx_93701ee2dbdd131c RENAME TO idx_utilisateur_affectation_idutilisateur');
        $this->addSql('ALTER INDEX sav.idx_93701ee2491a72a2 RENAME TO idx_utilisateur_affectation_idutilisateur_binome');
        $this->addSql('ALTER INDEX sav.idx_93701ee2bae956eb RENAME TO idx_utilisateur_affectation_idutilisateur_profil');
        $this->addSql('ALTER INDEX sav.idx_93701ee2e7b859f3 RENAME TO idx_utilisateur_affectation_idmotif_temps_partiel');
        $this->addSql('ALTER INDEX sav.idx_93701ee2e546653 RENAME TO idx_utilisateur_affectation_idutilisateur_responsable');
        $this->addSql('ALTER INDEX sav.idx_93701ee2f074f352 RENAME TO idx_utilisateur_affectation_idutilisateur_planning');
        $this->addSql('ALTER TABLE sav.utilisateur_adresse ALTER id TYPE BIGINT');
        $this->addSql('CREATE SEQUENCE sav.utilisateur_adresse_id_seq');
        $this->addSql('SELECT setval(\'sav.utilisateur_adresse_id_seq\', (SELECT MAX(id) FROM sav.utilisateur_adresse))');
        $this->addSql('ALTER TABLE sav.utilisateur_adresse ALTER id SET DEFAULT nextval(\'sav.utilisateur_adresse_id_seq\')');
        $this->addSql('ALTER TABLE sav.utilisateur_adresse ALTER idutilisateur TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.utilisateur_adresse ALTER idutilisateur DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_adresse ALTER idutilisateur DROP NOT NULL');
        $this->addSql('ALTER TABLE sav.utilisateur_adresse ALTER longitude SET DEFAULT \'0\'');
        $this->addSql('ALTER TABLE sav.utilisateur_adresse ALTER latitude SET DEFAULT \'0\'');
        $this->addSql('ALTER TABLE sav.utilisateur_adresse ALTER actif SET DEFAULT \'true\'');
        $this->addSql('ALTER INDEX sav.idx_e94909dddbdd131c RENAME TO idx_utilisateur_adresse_idutilisateur');
        $this->addSql('ALTER TABLE sav.utilisateur_email ALTER id TYPE BIGINT');
        $this->addSql('CREATE SEQUENCE sav.utilisateur_email_id_seq');
        $this->addSql('SELECT setval(\'sav.utilisateur_email_id_seq\', (SELECT MAX(id) FROM sav.utilisateur_email))');
        $this->addSql('ALTER TABLE sav.utilisateur_email ALTER id SET DEFAULT nextval(\'sav.utilisateur_email_id_seq\')');
        $this->addSql('ALTER TABLE sav.utilisateur_email ALTER idutilisateur TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.utilisateur_email ALTER idutilisateur DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_email ALTER idutilisateur DROP NOT NULL');
        $this->addSql('ALTER TABLE sav.utilisateur_email ALTER idtype_email TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.utilisateur_email ALTER idtype_email DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_email ALTER idtype_email DROP NOT NULL');
        $this->addSql('ALTER INDEX sav.idx_1175237d2437e6b9 RENAME TO idx_utilisateur_email_idtype_email');
        $this->addSql('ALTER INDEX sav.idx_1175237ddbdd131c RENAME TO idx_utilisateur_email_idutilisateur');
        $this->addSql('ALTER TABLE sav.utilisateur_filtre ALTER id TYPE BIGINT');
        $this->addSql('CREATE SEQUENCE sav.utilisateur_filtre_id_seq');
        $this->addSql('SELECT setval(\'sav.utilisateur_filtre_id_seq\', (SELECT MAX(id) FROM sav.utilisateur_filtre))');
        $this->addSql('ALTER TABLE sav.utilisateur_filtre ALTER id SET DEFAULT nextval(\'sav.utilisateur_filtre_id_seq\')');
        $this->addSql('ALTER TABLE sav.utilisateur_filtre ALTER idutilisateur TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.utilisateur_filtre ALTER idutilisateur DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_filtre ALTER idutilisateur DROP NOT NULL');
        $this->addSql('ALTER TABLE sav.utilisateur_filtre ALTER page TYPE VARCHAR(100)');
        $this->addSql('ALTER TABLE sav.site ALTER id TYPE BIGINT');
        $this->addSql('CREATE SEQUENCE sav.site_id_seq');
        $this->addSql('SELECT setval(\'sav.site_id_seq\', (SELECT MAX(id) FROM sav.site))');
        $this->addSql('ALTER TABLE sav.site ALTER id SET DEFAULT nextval(\'sav.site_id_seq\')');
        $this->addSql('ALTER TABLE sav.site ALTER num SET DEFAULT 0');
        $this->addSql('ALTER TABLE sav.site ALTER antenne SET DEFAULT \'false\'');
        $this->addSql('CREATE UNIQUE INDEX site_num_key ON sav.site (num)');
        $this->addSql('DROP INDEX IDX_955222D6BA8CF844');
        $this->addSql('ALTER TABLE sav.agence ALTER id TYPE BIGINT');
        $this->addSql('CREATE SEQUENCE sav.agence_id_seq');
        $this->addSql('SELECT setval(\'sav.agence_id_seq\', (SELECT MAX(id) FROM sav.agence))');
        $this->addSql('ALTER TABLE sav.agence ALTER id SET DEFAULT nextval(\'sav.agence_id_seq\')');
        $this->addSql('ALTER TABLE sav.agence ALTER idsite TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.agence ALTER idsite SET DEFAULT 0');
        $this->addSql('ALTER TABLE sav.agence ALTER idsite DROP NOT NULL');
        $this->addSql('ALTER TABLE sav.agence ALTER num SET DEFAULT 0');
        $this->addSql('ALTER TABLE sav.agence ALTER privilege SET DEFAULT \'false\'');
        $this->addSql('CREATE UNIQUE INDEX agence_idsite_key ON sav.agence (idsite)');
        $this->addSql('CREATE UNIQUE INDEX agence_num_agence_key ON sav.agence (num)');
        $this->addSql('ALTER TABLE sav.utilisateur_tel ALTER id TYPE BIGINT');
        $this->addSql('CREATE SEQUENCE sav.utilisateur_tel_id_seq');
        $this->addSql('SELECT setval(\'sav.utilisateur_tel_id_seq\', (SELECT MAX(id) FROM sav.utilisateur_tel))');
        $this->addSql('ALTER TABLE sav.utilisateur_tel ALTER id SET DEFAULT nextval(\'sav.utilisateur_tel_id_seq\')');
        $this->addSql('ALTER TABLE sav.utilisateur_tel ALTER idutilisateur TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.utilisateur_tel ALTER idutilisateur DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.utilisateur_tel ALTER idutilisateur DROP NOT NULL');
        $this->addSql('ALTER TABLE sav.utilisateur_tel ALTER idtype_tel TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.utilisateur_tel ALTER idtype_tel SET DEFAULT 0');
        $this->addSql('ALTER TABLE sav.utilisateur_tel ALTER idtype_tel DROP NOT NULL');
        $this->addSql('ALTER TABLE sav.utilisateur_tel ALTER priorite SET DEFAULT 0');
        $this->addSql('ALTER INDEX sav.idx_579c7077dbdd131c RENAME TO idx_utilisateur_tel_idutilisateur');
        $this->addSql('ALTER INDEX sav.idx_579c707758f505e3 RENAME TO idx_utilisateur_tel_idtype_tel');
        $this->addSql('ALTER TABLE sav.utilisateur_profil ALTER id TYPE BIGINT');
        $this->addSql('CREATE SEQUENCE sav.utilisateur_profil_id_seq');
        $this->addSql('SELECT setval(\'sav.utilisateur_profil_id_seq\', (SELECT MAX(id) FROM sav.utilisateur_profil))');
        $this->addSql('ALTER TABLE sav.utilisateur_profil ALTER id SET DEFAULT nextval(\'sav.utilisateur_profil_id_seq\')');
        $this->addSql('ALTER TABLE sav.utilisateur_profil ALTER libelle DROP NOT NULL');
        $this->addSql('ALTER TABLE sav.utilisateur_profil ALTER calcul_attachement DROP NOT NULL');
        $this->addSql('ALTER TABLE sav.attachement_profil ALTER id TYPE BIGINT');
        $this->addSql('CREATE SEQUENCE sav.attachement_profil_id_seq');
        $this->addSql('SELECT setval(\'sav.attachement_profil_id_seq\', (SELECT MAX(id) FROM sav.attachement_profil))');
        $this->addSql('ALTER TABLE sav.attachement_profil ALTER id SET DEFAULT nextval(\'sav.attachement_profil_id_seq\')');
        $this->addSql('ALTER TABLE sav.attachement_profil ALTER idutilisateur_profil TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.attachement_profil ALTER idutilisateur_profil DROP DEFAULT');
        $this->addSql('ALTER TABLE sav.attachement_profil ALTER idutilisateur_profil DROP NOT NULL');
        $this->addSql('ALTER TABLE sav.attachement_profil ALTER plafond_point SET DEFAULT 0');
        $this->addSql('ALTER TABLE sav.attachement_profil ALTER coefficient SET DEFAULT 0');
        $this->addSql('ALTER TABLE sav.attachement_profil ALTER valeur_point SET DEFAULT 0');
        $this->addSql('ALTER TABLE sav.attachement_profil ALTER annee SET DEFAULT 0');
        $this->addSql('ALTER TABLE sav.attachement_profil ALTER semestre SET DEFAULT 0');
        $this->addSql('ALTER INDEX sav.idx_162abf41bae956eb RENAME TO idx_attachement_profil_idutilisateur_profil');
        $this->addSql('ALTER TABLE sav.type_tel ALTER id TYPE BIGINT');
        $this->addSql('CREATE SEQUENCE sav.type_tel_id_seq');
        $this->addSql('SELECT setval(\'sav.type_tel_id_seq\', (SELECT MAX(id) FROM sav.type_tel))');
        $this->addSql('ALTER TABLE sav.type_tel ALTER id SET DEFAULT nextval(\'sav.type_tel_id_seq\')');
        $this->addSql('ALTER TABLE sav.type_tel ALTER libelle DROP NOT NULL');
        $this->addSql('ALTER TABLE sav.tchat_groupe_type ALTER id TYPE BIGINT');
        $this->addSql('CREATE SEQUENCE sav.tchat_groupe_type_id_seq');
        $this->addSql('SELECT setval(\'sav.tchat_groupe_type_id_seq\', (SELECT MAX(id) FROM sav.tchat_groupe_type))');
        $this->addSql('ALTER TABLE sav.tchat_groupe_type ALTER id SET DEFAULT nextval(\'sav.tchat_groupe_type_id_seq\')');
        $this->addSql('ALTER TABLE sav.tchat_groupe_type ALTER libelle DROP NOT NULL');
        $this->addSql('ALTER TABLE sav.tchat_groupe_type ALTER libelle TYPE VARCHAR(50)');
        $this->addSql('ALTER TABLE sav.utilisateur_site ALTER idutilisateur TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.utilisateur_site ALTER idutilisateur SET DEFAULT 0');
        $this->addSql('ALTER TABLE sav.utilisateur_site ALTER idsite TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.utilisateur_site ALTER idsite SET DEFAULT 0');
        $this->addSql('ALTER INDEX sav.idx_373a5b31dbdd131c RENAME TO idx_utilisateur_site_idutilisateur');
        $this->addSql('ALTER INDEX sav.idx_373a5b31ba8cf844 RENAME TO idx_utilisateur_site_idsite');
        $this->addSql('ALTER TABLE sav.motif_temps_partiel ALTER id TYPE BIGINT');
        $this->addSql('CREATE SEQUENCE sav.motif_temps_partiel_id_seq');
        $this->addSql('SELECT setval(\'sav.motif_temps_partiel_id_seq\', (SELECT MAX(id) FROM sav.motif_temps_partiel))');
        $this->addSql('ALTER TABLE sav.motif_temps_partiel ALTER id SET DEFAULT nextval(\'sav.motif_temps_partiel_id_seq\')');
        $this->addSql('ALTER TABLE sav.motif_temps_partiel ALTER libelle DROP NOT NULL');
        $this->addSql('ALTER TABLE sav.type_email ALTER id TYPE BIGINT');
        $this->addSql('CREATE SEQUENCE sav.type_email_id_seq');
        $this->addSql('SELECT setval(\'sav.type_email_id_seq\', (SELECT MAX(id) FROM sav.type_email))');
        $this->addSql('ALTER TABLE sav.type_email ALTER id SET DEFAULT nextval(\'sav.type_email_id_seq\')');
        $this->addSql('ALTER TABLE sav.type_email ALTER libelle DROP NOT NULL');
        $this->addSql('ALTER TABLE sav.type_email ALTER libelle TYPE VARCHAR(50)');
        $this->addSql('ALTER TABLE sav.type_login ALTER id TYPE BIGINT');
        $this->addSql('CREATE SEQUENCE sav.type_login_id_seq');
        $this->addSql('SELECT setval(\'sav.type_login_id_seq\', (SELECT MAX(id) FROM sav.type_login))');
        $this->addSql('ALTER TABLE sav.type_login ALTER id SET DEFAULT nextval(\'sav.type_login_id_seq\')');
        $this->addSql('ALTER TABLE sav.type_utilisateur ALTER id TYPE BIGINT');
        $this->addSql('CREATE SEQUENCE sav.type_utilisateur_id_seq');
        $this->addSql('SELECT setval(\'sav.type_utilisateur_id_seq\', (SELECT MAX(id) FROM sav.type_utilisateur))');
        $this->addSql('ALTER TABLE sav.type_utilisateur ALTER id SET DEFAULT nextval(\'sav.type_utilisateur_id_seq\')');
        $this->addSql('ALTER TABLE sav.type_utilisateur ALTER libelle DROP NOT NULL');
        $this->addSql('ALTER TABLE sav.utilisateur_role ALTER id TYPE BIGINT');
        $this->addSql('ALTER TABLE sav.utilisateur_role ALTER id DROP DEFAULT');
    }
}