<?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 Version20220214160323 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."ADRESSE" DROP CONSTRAINT "ADRESSE_IDAGENCE_fkey"');
        $this->addSql('ALTER TABLE sav."UTILISATEUR" DROP CONSTRAINT "UTILISATEUR_IDAGENCE_fkey"');
        $this->addSql('ALTER TABLE sav."FACTURE" DROP CONSTRAINT "FACTURE_IDAGENCE_fkey"');
        $this->addSql('ALTER TABLE sav."MAG_COMMANDE" DROP CONSTRAINT "MAG_COMMANDE_IDAGENCE_fkey"');
        $this->addSql('ALTER TABLE sav."MAG_JOUR_EXCLUSION_LIVRAISON" DROP CONSTRAINT "MAG_JOUR_EXCLUSION_LIVRAISON_IDAGENCE_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."FACTURE" DROP CONSTRAINT "FACTURE_IDADRESSE_fkey"');
        $this->addSql('ALTER TABLE sav."INTERVENTION_PAYEUR_EXTERNE" DROP CONSTRAINT "INTERVENTION_PAYEUR_EXTERNE_IDADRESSE_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."EQUIPEMENT" DROP CONSTRAINT "EQUIPEMENT_IDCLIENT_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."COMMUNICATION_CLIENT" DROP CONSTRAINT "COMMUNICATION_CLIENT_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."HISTORIQUE_MODIFICATION" DROP CONSTRAINT "HISTORIQUE_MODIFICATION_IDCLIENT_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."ADRESSE_COMPLEMENT" DROP CONSTRAINT "ADRESSE_COMPLEMENT_IDTYPE_COMPLEMENT_ADRESSE_fkey"');
        $this->addSql('ALTER TABLE sav."AGENCE" DROP CONSTRAINT "AGENCE_IDSITE_fkey"');
        $this->addSql('ALTER TABLE sav."AGENT_PRODUIT_STOCK" DROP CONSTRAINT "AGENT_PRODUIT_STOCK_IDSITE_fkey"');
        $this->addSql('ALTER TABLE sav."FACTURE" DROP CONSTRAINT "FACTURE_IDSITE_fkey"');
        $this->addSql('ALTER TABLE sav."PRODUIT" DROP CONSTRAINT "PRODUIT_IDSITE_fkey"');
        $this->addSql('ALTER TABLE sav."MAG_COMMANDE" DROP CONSTRAINT "MAG_COMMANDE_IDSITE_fkey"');
        $this->addSql('ALTER TABLE sav."MAG_COMMANDE" DROP CONSTRAINT "MAG_COMMANDE_IDSITE_LIVRAISON_fkey"');
        $this->addSql('ALTER TABLE sav."MAG_STOCK_MOUVEMENT" DROP CONSTRAINT "MAG_STOCK_MOUVEMENT_IDSITE_fkey"');
        $this->addSql('ALTER TABLE sav."PLN_PARAMETRES" DROP CONSTRAINT "PLN_PARAMETRES_IDSITE_fkey"');
        $this->addSql('ALTER TABLE sav."POLE_SITE" DROP CONSTRAINT "POLE_SITE_IDSITE_fkey"');
        $this->addSql('ALTER TABLE sav."PRODUIT_FAMILLE" DROP CONSTRAINT "PRODUIT_FAMILLE_IDSITE_fkey"');
        $this->addSql('ALTER TABLE sav."PRODUIT_STOCK_SITE" DROP CONSTRAINT "PRODUIT_STOCK_SITE_IDSITE_fkey"');
        $this->addSql('ALTER TABLE sav."SECTORISATION_VERSION" DROP CONSTRAINT "SECTORISATION_VERSION_IDSITE_fkey"');
        $this->addSql('ALTER TABLE sav."STOCK_STANDARD" DROP CONSTRAINT "STOCK_STANDARD_IDSITE_fkey"');
        $this->addSql('ALTER TABLE sav."TCHAT_GROUPE" DROP CONSTRAINT "TCHAT_GROUPE_IDSITE_fkey"');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_SITE" DROP CONSTRAINT "UTILISATEUR_SITE_IDSITE_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."TCHAT_MESSAGE" DROP CONSTRAINT "TCHAT_GROUPE_IDUTILISATEUR_fkey"');
        $this->addSql('ALTER TABLE sav."AGENT_APPAREIL" DROP CONSTRAINT "AGENT_APPAREIL_IDUTILISATEUR_AGENT_fkey"');
        $this->addSql('ALTER TABLE sav."UTILISATEUR" DROP CONSTRAINT "UTILISATEUR_IDUTILISATEUR_RESPONSABLE_fkey"');
        $this->addSql('ALTER TABLE sav."UTILISATEUR" DROP CONSTRAINT "UTILISATEUR_IDUTILISATEUR_VALIDE_CONGES_fkey"');
        $this->addSql('ALTER TABLE sav."AGENT_GPS" DROP CONSTRAINT "AGENT_GPS_IDUTILISATEUR_AGENT_fkey"');
        $this->addSql('ALTER TABLE sav."AGENT_PRODUIT_STOCK" DROP CONSTRAINT "AGENT_PRODUIT_STOCK_IDUTILISATEUR_fkey"');
        $this->addSql('ALTER TABLE sav."AGENT_QUALIFICATION" DROP CONSTRAINT "AGENT_QUALIFICATION_IDUTILISATEUR_AGENT_fkey"');
        $this->addSql('ALTER TABLE sav."AGENT_SECTEUR" DROP CONSTRAINT "AGENT_SECTEUR_IDUTILISATEUR_AGENT_fkey"');
        $this->addSql('ALTER TABLE sav."AIDE_TECHNIQUE_HISTO" DROP CONSTRAINT "AIDE_TECHNIQUE_HISTO_IDUTILISATEUR_fkey"');
        $this->addSql('ALTER TABLE sav."CONTRAT" DROP CONSTRAINT "CONTRAT_IDAGENT_SOUSCRIPTION_fkey"');
        $this->addSql('ALTER TABLE sav."HISTORIQUE_MODIFICATION" DROP CONSTRAINT "HISTORIQUE_MODIFICATION_IDAGENT_fkey"');
        $this->addSql('ALTER TABLE sav."HISTORIQUE_MODIFICATION" DROP CONSTRAINT "HISTORIQUE_MODIFICATION_IDUTILISATEUR_MODIF_fkey"');
        $this->addSql('ALTER TABLE sav."HISTORIQUE_MODIFICATION" DROP CONSTRAINT "HISTORIQUE_MODIFICATION_IDUTILISATEUR_VALIDE_fkey"');
        $this->addSql('ALTER TABLE sav."PLANNING" DROP CONSTRAINT "PLANNING_IDUTILISATEUR_AGENT_fkey"');
        $this->addSql('ALTER TABLE sav."INTERVENTION_STACK" DROP CONSTRAINT "INTERVENTION_RETOUR_IDAGENT_fkey"');
        $this->addSql('ALTER TABLE sav."MAG_COMMANDE" DROP CONSTRAINT "MAG_COMMANDE_IDUTILISATEUR_fkey"');
        $this->addSql('ALTER TABLE sav."MAG_COMMANDE_HISTO" DROP CONSTRAINT "MAG_COMMANDE_HISTO_IDUTILISATEUR_fkey"');
        $this->addSql('ALTER TABLE sav."MAG_STOCK_MOUVEMENT" DROP CONSTRAINT "MAG_STOCK_MOUVEMENT_IDUTILISATEUR_fkey"');
        $this->addSql('ALTER TABLE sav."PLN_TRANSIT" DROP CONSTRAINT "PLN_TRANSIT_IDUTILISATEUR_fkey"');
        $this->addSql('ALTER TABLE sav."PLANNING_AGENTS_LISTE" DROP CONSTRAINT "PLANNING_AGENTS_LISTE_IDUTILISATEUR_AGENT_fkey"');
        $this->addSql('ALTER TABLE sav."PLANNING_CONFLIT" DROP CONSTRAINT "PLANNING_CONFLIT_IDUTILISATEUR_fkey"');
        $this->addSql('ALTER TABLE sav."PLANNING_HISTORIQUE_MODIFICATION" DROP CONSTRAINT "PLANNING_HISTORIQUE_MODIFICATION_IDAGENT_fkey"');
        $this->addSql('ALTER TABLE sav."PLANNING_HISTORIQUE_MODIFICATION" DROP CONSTRAINT "PLANNING_HISTORIQUE_MODIFICATION_IDUTILISATEUR_fkey"');
        $this->addSql('ALTER TABLE sav."PLN_AGENT_BLOCAGE" DROP CONSTRAINT "PLN_AGENT_BLOCAGE_IDUTILISATEUR_AGENT_fkey"');
        $this->addSql('ALTER TABLE sav."PLN_AGENT_BLOCAGE" DROP CONSTRAINT "PLN_AGENT_BLOCAGE_IDUTILISATEUR_fkey"');
        $this->addSql('ALTER TABLE sav."PLN_DROITS_VISITE" DROP CONSTRAINT "PLN_DROITS_VISITE_IDUTILISATEUR_fkey"');
        $this->addSql('ALTER TABLE sav."PLN_GROUPE_UTILISATEURS" DROP CONSTRAINT "PLN_GROUPE_UTILISATEURS_IDUTILISATEUR_fkey"');
        $this->addSql('ALTER TABLE sav."PLN_TRANSIT_UTILISATEUR" DROP CONSTRAINT "PLN_TRANSIT_UTILISATEUR_IDUTILISATEUR_fkey"');
        $this->addSql('ALTER TABLE sav."PLN_VISITE_EXCLUSION" DROP CONSTRAINT "PLN_VISITE_EXCLUSION_IDUTILISATEUR_fkey"');
        $this->addSql('ALTER TABLE sav."SECTORISATION_VERSION" DROP CONSTRAINT "SECTORISATION_VERSION_IDUTILISATEUR_fkey"');
        $this->addSql('ALTER TABLE sav."TCHAT_GROUPE" DROP CONSTRAINT "TCHAT_GROUPE_IDUTILISATEUR_ADMIN_GROUPE_fkey"');
        $this->addSql('ALTER TABLE sav."TCHAT_GROUPE_UTILISATEUR" DROP CONSTRAINT "TCHAT_GROUPE_UTILISATEUR_IDUTILISATEUR_fkey"');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_ADRESSE" DROP CONSTRAINT "UTILISATEUR_ADRESSE_IDUTILISATEUR_fkey"');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_AFFECTATION" DROP CONSTRAINT "UTILISATEUR_AFFECTATION_IDUTILISATEUR_fkey"');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_AFFECTATION" DROP CONSTRAINT "UTILISATEUR_AFFECTATION_IDUTILISATEUR_PLANNING_fkey"');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_AFFECTATION" DROP CONSTRAINT "UTILISATEUR_AFFECTATION_IDUTILISATEUR_RESPONSABLE_fkey"');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_AFFECTATION" DROP CONSTRAINT "UTILISATEUR_AFFECTATION_IDUTILISATEUR_BINOME_fkey"');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_EMAIL" DROP CONSTRAINT "UTILISATEUR_EMAIL_IDUTILISATEUR_fkey"');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_SITE" DROP CONSTRAINT "UTILISATEUR_SITE_IDUTILISATEUR_fkey"');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_TEL" DROP CONSTRAINT "UTILISATEUR_TEL_IDUTILISATEUR_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."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."AIDE_TECHNIQUE" DROP CONSTRAINT "AIDE_TECHNIQUE_IDAIDE_TECHNIQUE_ETAT_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_CLASSIFICATION" DROP CONSTRAINT "AIDE_TECHNIQUE_CLASSIFICATION_IDAIDE_TECHNIQUE_fkey"');
        $this->addSql('ALTER TABLE sav."AIDE_TECHNIQUE_HISTO" DROP CONSTRAINT "AIDE_TECHNIQUE_HISTO_IDAIDE_TECHNIQUE_fkey"');
        $this->addSql('ALTER TABLE sav."AIDE_TECHNIQUE" DROP CONSTRAINT "AIDE_TECHNIQUE_IDEQUIPEMENT_fkey"');
        $this->addSql('ALTER TABLE sav."COMMUNICATION_CLIENT" DROP CONSTRAINT "COMMUNICATION_CLIENT_IDEQUIPEMENT_fkey"');
        $this->addSql('ALTER TABLE sav."INTERVENTION" DROP CONSTRAINT "INTERVENTION_IDEQUIPEMENT_fkey"');
        $this->addSql('ALTER TABLE sav."CONTRAT" DROP CONSTRAINT "CONTRAT_IDEQUIPEMENT_fkey"');
        $this->addSql('ALTER TABLE sav."FACTURE" DROP CONSTRAINT "FACTURE_IDEQUIPEMENT_fkey"');
        $this->addSql('ALTER TABLE sav."COURRIER_CLIENT" DROP CONSTRAINT "COURRIER_CLIENT_IDEQUIPEMENT_fkey"');
        $this->addSql('ALTER TABLE sav."DEMANDE_DOCUMENTATION" DROP CONSTRAINT "DEMANDE_DOCUMENTATION_IDTYPE_DEMANDEUR_fkey"');
        $this->addSql('ALTER TABLE sav."EQUIPEMENT_COMPLEMENT" DROP CONSTRAINT "EQUIPEMENT_COMPLEMENT_IDEQUIPEMENT_fkey"');
        $this->addSql('ALTER TABLE sav."EQUIPEMENT_GROUPE" DROP CONSTRAINT "EQUIPEMENT_GROUPE_IDEQUIPEMENT_fkey"');
        $this->addSql('ALTER TABLE sav."EQUIPEMENT_MESURE" DROP CONSTRAINT "EQUIPEMENT_MESURE_IDEQUIPEMENT_fkey"');
        $this->addSql('ALTER TABLE sav."EQUIPEMENT_OPTION" DROP CONSTRAINT "EQUIPEMENT_OPTION_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."HISTORIQUE_MODIFICATION" DROP CONSTRAINT "HISTORIQUE_MODIFICATION_IDEQUIPEMENT_fkey"');
        $this->addSql('ALTER TABLE sav."PLANNING" DROP CONSTRAINT "PLANNING_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."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_IDTYPE_DEMANDEUR_fkey"');
        $this->addSql('ALTER TABLE sav."DEMANDE_DOCUMENTATION" DROP CONSTRAINT "DEMANDE_DOCUMENTATION_IDEQUIPEMENT_fkey"');
        $this->addSql('ALTER TABLE sav."AIDE_TECHNIQUE_CLASSIFICATION" DROP CONSTRAINT "AIDE_TECHNIQUE_CLASSIFICATION_IDAIDE_TECHNIQUE_CLASSIFICAT_fkey"');
        $this->addSql('ALTER TABLE sav."ATTACHEMENT_PARAMETRE" DROP CONSTRAINT "ATTACHEMENT_PARAMETRE_IDATTACHEMENT_PARAMETRE_LISTE_fkey"');
        $this->addSql('ALTER TABLE sav."ATTACHEMENT_PROFIL" DROP CONSTRAINT "ATTACHEMENT_PROFIL_IDUTILISATEUR_PROFIL_fkey"');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_AFFECTATION" DROP CONSTRAINT "UTILISATEUR_AFFECTATION_IDUTILISATEUR_PROFIL_fkey"');
        $this->addSql('ALTER TABLE sav."ATTACHEMENT_TYPE_VISITE" DROP CONSTRAINT "ATTACHEMENT_TYPE_VISITE_IDTYPE_VISITE_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_CONFIG_VISITE" DROP CONSTRAINT "PLN_CONFIG_VISITE_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_GROUPES_DROITS_VISITE" DROP CONSTRAINT "PLN_GROUPES_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."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."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."TARIF_OPTION" DROP CONSTRAINT "TARIF_OPTION_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_IDTYPE_CLIENT_fkey"');
        $this->addSql('ALTER TABLE sav."INTERVENTION_PAYEUR_EXTERNE" DROP CONSTRAINT "INTERVENTION_PAYEUR_EXTERNE_IDTYPE_CLIENT_fkey"');
        $this->addSql('ALTER TABLE sav."TVA_EQUIPEMENT" DROP CONSTRAINT "TVA_EQUIPEMENT_IDTYPE_CLIENT_fkey"');
        $this->addSql('ALTER TABLE sav."CLIENT" DROP CONSTRAINT "CLIENT_IDCOMPTE_CLIENT_WEB_fkey"');
        $this->addSql('ALTER TABLE sav."CLIENT_TEL" DROP CONSTRAINT "CLIENT_TEL_IDTYPE_TEL_fkey"');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_TEL" DROP CONSTRAINT "UTILISATEUR_TEL_IDTYPE_TEL_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."COMMUNICATION_CLIENT" DROP CONSTRAINT "COMMUNICATION_CLIENT_IDINTERVENTION_fkey"');
        $this->addSql('ALTER TABLE sav."FACTURE" DROP CONSTRAINT "FACTURE_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."MAG_COMMANDE" DROP CONSTRAINT "MAG_COMMANDE_IDINTERVENTION_fkey"');
        $this->addSql('ALTER TABLE sav."PRIVILEGE" DROP CONSTRAINT "PRIVILEGE_IDINTERVENTION_fkey"');
        $this->addSql('ALTER TABLE sav."CONTRAT" DROP CONSTRAINT "CONTRAT_IDCONTRAT_MOTIF_RESILIATION_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."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."TARIF_OPTION" DROP CONSTRAINT "TARIF_OPTION_IDCONTRAT_TYPE_fkey"');
        $this->addSql('ALTER TABLE sav."INTERVENTION" DROP CONSTRAINT "INTERVENTION_IDFACTURE_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."PAIEMENT" DROP CONSTRAINT "PAIEMENT_IDFACTURE_fkey"');
        $this->addSql('ALTER TABLE sav."CONTRAT_TARIF" DROP CONSTRAINT "CONTRAT_TARIF_IDPUISSANCE_fkey"');
        $this->addSql('ALTER TABLE sav."FACTURE" DROP CONSTRAINT "FACTURE_IDDEVIS_fkey"');
        $this->addSql('ALTER TABLE sav."PAIEMENT" DROP CONSTRAINT "PAIEMENT_IDDEVIS_fkey"');
        $this->addSql('ALTER TABLE sav."EQUIPEMENT" DROP CONSTRAINT "EQUIPEMENT_IDNATURE_GAZ_fkey"');
        $this->addSql('ALTER TABLE sav."EQUIPEMENT" DROP CONSTRAINT "EQUIPEMENT_IDEQUIPEMENT_LOCAL_fkey"');
        $this->addSql('ALTER TABLE sav."EQUIPEMENT" DROP CONSTRAINT "EQUIPEMENT_IDTRANCHE_EQUIPEMENT_fkey"');
        $this->addSql('ALTER TABLE sav."EQUIPEMENT" DROP CONSTRAINT "EQUIPEMENT_IDRACCORDEMENT_fkey"');
        $this->addSql('ALTER TABLE sav."EQUIPEMENT" DROP CONSTRAINT "EQUIPEMENT_IDINSTALLATEUR_fkey"');
        $this->addSql('ALTER TABLE sav."EQUIPEMENT" DROP CONSTRAINT "EQUIPEMENT_IDPROTECTION_SANITAIRE_fkey"');
        $this->addSql('ALTER TABLE sav."EQUIPEMENT" DROP CONSTRAINT "EQUIPEMENT_IDROBINET_REMPLISSAGE_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_OPTION" DROP CONSTRAINT "EQUIPEMENT_OPTION_IDTARIF_OPTION_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."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."MAG_STOCK_MOUVEMENT" DROP CONSTRAINT "MAG_STOCK_MOUVEMENT_IDPRODUIT_fkey"');
        $this->addSql('ALTER TABLE sav."PRODUIT_PHOTO" DROP CONSTRAINT "PRODUIT_PHOTO_IDPRODUIT_fkey"');
        $this->addSql('ALTER TABLE sav."PRODUIT_STOCK_SITE" DROP CONSTRAINT "PRODUIT_STOCK_SITE_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."INTERVENTION" DROP CONSTRAINT "INTERVENTION_IDINTERVENTION_MOTIF_fkey"');
        $this->addSql('ALTER TABLE sav."INTERVENTION" DROP CONSTRAINT "INTERVENTION_IDPLANNING_fkey"');
        $this->addSql('ALTER TABLE sav."INTERVENTION_ANNULATION" DROP CONSTRAINT "INTERVENTION_ANNULATION_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" DROP CONSTRAINT "INTERVENTION_IDTYPE_VALIDATION_ADM_fkey"');
        $this->addSql('ALTER TABLE sav."INTERVENTION" DROP CONSTRAINT "INTERVENTION_IDTYPE_VALIDATION_TECHNIQUE_fkey"');
        $this->addSql('ALTER TABLE sav."INTERVENTION" DROP CONSTRAINT "INTERVENTION_IDTYPE_ENVOI_RAPPORT_fkey"');
        $this->addSql('ALTER TABLE sav."INTERVENTION_ANNULATION" DROP CONSTRAINT "INTERVENTION_ANNULATION_IDINTERVENTION_MOTIF_ABSENCE_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_ANNULATION_fkey"');
        $this->addSql('ALTER TABLE sav."INTERVENTION_ANOMALIE" DROP CONSTRAINT "INTERVENTION_ANOMALIE_IDANOMALIE_fkey"');
        $this->addSql('ALTER TABLE sav."INTERVENTION_PRE_ENCAISSEMENT" DROP CONSTRAINT "INTERVENTION_PRE_ENCAISSEMENT_IDMOYEN_PAIEMENT_fkey"');
        $this->addSql('ALTER TABLE sav."PAIEMENT" DROP CONSTRAINT "PAIEMENT_IDMOYEN_PAIEMENT_fkey"');
        $this->addSql('ALTER TABLE sav."INTERVENTION_RETOUR" DROP CONSTRAINT "INTERVENTION_RETOUR_IDRETOUR_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."MAG_COMMANDE" DROP CONSTRAINT "MAG_COMMANDE_IDMAG_ETAT_COMMANDE_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_STATUT_COMMANDE_fkey"');
        $this->addSql('ALTER TABLE sav."MAG_COMMANDE_HISTO" DROP CONSTRAINT "MAG_COMMANDE_HISTO_IDMAG_STATUT_COMMANDE_fkey"');
        $this->addSql('ALTER TABLE sav."MAG_COMMANDE" DROP CONSTRAINT "MAG_COMMANDE_IDTYPE_CDE_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_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_HORAIRES_PASSAGE_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_IDPLN_TRANSIT_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_IDPLANNING_INITIATIVE_fkey"');
        $this->addSql('ALTER TABLE sav."PLANNING_INITIATIVE_DETAIL" DROP CONSTRAINT "PLANNING_INITIATIVE_DETAIL_IDPLANNING_INITIATIVE_fkey"');
        $this->addSql('ALTER TABLE sav."PLANNING_HISTORIQUE_MODIFICATION" DROP CONSTRAINT "PLANNING_HISTORIQUE_MODIFICATION_IDPLN_INITIATIVE_INTERV_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_GROUPES_DROITS_VISITE" DROP CONSTRAINT "PLN_GROUPES_DROITS_VISITE_IDPLN_GROUPES_fkey"');
        $this->addSql('ALTER TABLE sav."PLN_GROUPE_UTILISATEURS" DROP CONSTRAINT "PLN_GROUPE_UTILISATEURS_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."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."UTILISATEUR" DROP CONSTRAINT "UTILISATEUR_IDPOLE_SITE_fkey"');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_AFFECTATION" DROP CONSTRAINT "UTILISATEUR_AFFECTATION_IDPOLE_SITE_fkey"');
        $this->addSql('ALTER TABLE sav."PRIVILEGE" DROP CONSTRAINT "PRIVILEGE_IDRAISON_REFUS_fkey"');
        $this->addSql('ALTER TABLE sav."PRIVILEGE" DROP CONSTRAINT "PRIVILEGE_STATUT_PRIVILEGE_fkey"');
        $this->addSql('ALTER TABLE sav."PRODUIT" DROP CONSTRAINT "PRODUIT_IDPRODUIT_FAMILLE_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."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."TCHAT_GROUPE" DROP CONSTRAINT "TCHAT_GROUPE_IDTCHAT_GROUPE_TYPE_fkey"');
        $this->addSql('ALTER TABLE sav."TCHAT_MESSAGE" DROP CONSTRAINT "TCHAT_GROUPE_IDTCHAT_GROUPE_fkey"');
        $this->addSql('ALTER TABLE sav."TCHAT_GROUPE_UTILISATEUR" DROP CONSTRAINT "TCHAT_GROUPE_UTILISATEUR_IDTCHAT_GROUPE_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('ALTER TABLE sav."UTILISATEUR" DROP CONSTRAINT "UTILISATEUR_IDTYPE_LOGIN_fkey"');
        $this->addSql('ALTER TABLE sav."UTILISATEUR" DROP CONSTRAINT "UTILISATEUR_IDTYPE_UTILISATEUR_fkey"');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_AFFECTATION" DROP CONSTRAINT "UTILISATEUR_AFFECTATION_IDMOTIF_TEMPS_PARTIEL_fkey"');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_EMAIL" DROP CONSTRAINT "UTILISATEUR_EMAIL_IDTYPE_EMAIL_fkey"');
        $this->addSql('DROP SEQUENCE sav.TCHAT_MESSAGE_ID_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.PRODUIT_FAMILLE_ID_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.SECTEUR_ID_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.ADRESSE_COMPLEMENT_ID_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.ADRESSE_ID_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.AGENT_GPS_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.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.CLIENT_EMAIL_ID_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.CLASSIFICATION_ENERGETIQUE_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_FAMILLE_ID_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.EQUIPEMENT_ID_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.EQUIPEMENT_GROUPE_ID_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.EQUIPEMENT_OPTION_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_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_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_OBSERVATION_ID_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.INTERVENTION_MOTIF_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.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_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.OPTION_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_HISTORIQUE_MODIFICATION_IDPLANNING_HISTORIQUE_MODIFICA CASCADE');
        $this->addSql('DROP SEQUENCE sav.PLANNING_CONFLIT_IDPLN_CONFLIT_seq 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_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_GROUPE_UTILISATEURS_IDPLN_GROUPE_UTILISATEURS_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_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_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.SITE_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.TCHAT_GROUPE_ID_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.TCHAT_GROUPE_TYPE_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_ID_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.TYPE_COMPLEMENT_ADRESSE_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('DROP SEQUENCE sav.UTILISATEUR_ID_seq CASCADE');
        $this->addSql('CREATE SEQUENCE UTILISATEUR_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.UTILISATEUR_FILTRE_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $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_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 client_tel_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 equipement_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 group_right_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE intervention_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE observation_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE "option_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 puissance_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 "right_id_seq" INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE role_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE site_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 tchat_groupe_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE tchat_groupe_type_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE tchat_groupe_utilisateur_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE tchat_message_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_client_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 sav.ATTACHEMENT_PROFIL (id INT NOT NULL, plafond_point INT DEFAULT NULL, coefficient INT DEFAULT NULL, valeur_point INT DEFAULT NULL, annee INT DEFAULT NULL, semestre SMALLINT DEFAULT NULL, idutilisateur_profil VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.POLE_SITE (id INT NOT NULL, libelle VARCHAR(50) NOT NULL, idsite VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.TYPE_EMAIL (id INT NOT NULL, libelle VARCHAR(20) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.TYPE_LOGIN (id INT NOT NULL, libelle VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE "sav"."TYPE_TEL" (id INT NOT NULL, libelle VARCHAR(20) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.TYPE_UTILISATEUR (id INT NOT NULL, libelle VARCHAR(50) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE UTILISATEUR (id INT NOT NULL, role_id INT DEFAULT NULL, nom VARCHAR(255) DEFAULT NULL, prenom VARCHAR(255) DEFAULT NULL, idtype_login VARCHAR(255) NOT NULL, login VARCHAR(255) DEFAULT NULL, password VARCHAR(255) DEFAULT NULL, cle_salage VARCHAR(64) DEFAULT NULL, idtype_utilisateur VARCHAR(255) NOT NULL, url_homepage VARCHAR(255) DEFAULT NULL, idutilisateur_responsable VARCHAR(255) NOT NULL, idutilisateur_valide_conges VARCHAR(255) NOT NULL, idpole_site VARCHAR(255) NOT NULL, date_embauche DATE DEFAULT NULL, idagence VARCHAR(255) NOT NULL, code_client_agi VARCHAR(9) DEFAULT NULL, token_mobilite VARCHAR(48) DEFAULT NULL, rights JSON DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE UNIQUE INDEX UNIQ_901FF15BAA08CB10 ON UTILISATEUR (login)');
        $this->addSql('CREATE INDEX IDX_901FF15BD60322AC ON UTILISATEUR (role_id)');
        $this->addSql('CREATE TABLE utilisateur_site (utilisateur_id INT NOT NULL, site_id INT NOT NULL, PRIMARY KEY(utilisateur_id, site_id))');
        $this->addSql('CREATE INDEX IDX_A0C265DEFB88E14F ON utilisateur_site (utilisateur_id)');
        $this->addSql('CREATE INDEX IDX_A0C265DEF6BD1646 ON utilisateur_site (site_id)');
        $this->addSql('CREATE TABLE sav.UTILISATEUR_ADRESSE (id INT NOT NULL, longitude DOUBLE PRECISION DEFAULT NULL, latitude DOUBLE PRECISION DEFAULT NULL, date_application DATE DEFAULT NULL, actif BOOLEAN DEFAULT NULL, idutilisateur VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.UTILISATEUR_AFFECTATION (id INT NOT NULL, idutilisateur VARCHAR(255) NOT NULL, idutilisateur_profil VARCHAR(255) NOT NULL, idutilisateur_planning VARCHAR(255) NOT NULL, idutilisateur_responsable VARCHAR(255) NOT NULL, debut_effet TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, fin_effet TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, service VARCHAR(4) DEFAULT NULL, est_responsable BOOLEAN DEFAULT \'false\', idpole_site VARCHAR(255) NOT NULL, planifiable BOOLEAN DEFAULT NULL, temps_travail INT DEFAULT NULL, idutilisateur_binome VARCHAR(255) NOT NULL, idmotif_temps_partiel VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.UTILISATEUR_EMAIL (id INT NOT NULL, utilisateur_id INT NOT NULL, email VARCHAR(260) DEFAULT NULL, commentaire VARCHAR(50) DEFAULT NULL, idtype_email VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX IDX_4CA82B6FFB88E14F ON sav.UTILISATEUR_EMAIL (utilisateur_id)');
        $this->addSql('CREATE TABLE sav.UTILISATEUR_FILTRE (id INT NOT NULL, utilisateur_id INT NOT NULL, page VARCHAR(255) DEFAULT NULL, titre VARCHAR(255) DEFAULT NULL, filtre VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX IDX_48348D3FFB88E14F ON sav.UTILISATEUR_FILTRE (utilisateur_id)');
        $this->addSql('CREATE TABLE sav.UTILISATEUR_PROFIL (id INT NOT NULL, libelle VARCHAR(50) NOT NULL, calcul_attachement BOOLEAN DEFAULT \'false\' NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav.UTILISATEUR_TEL (id INT NOT NULL, numero VARCHAR(10) DEFAULT NULL, commentaire VARCHAR(50) DEFAULT NULL, priorite SMALLINT DEFAULT NULL, idutilisateur VARCHAR(255) NOT NULL, idtype_tel VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
        $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 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 group_right (id INT NOT NULL, libelle VARCHAR(255) 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 "right" (id INT NOT NULL, group_right_id INT NOT NULL, libelle VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX IDX_B4CA75145DA7244A ON "right" (group_right_id)');
        $this->addSql('CREATE TABLE role (id INT NOT NULL, libelle VARCHAR(255) NOT NULL, nom VARCHAR(255) DEFAULT NULL, rights JSON DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE site (id INT NOT NULL, type_sav_id INT NOT NULL, libelle VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX IDX_694309E46CA5086B ON site (type_sav_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 tchat_groupe (id INT NOT NULL, last_message_id INT DEFAULT NULL, idtchat_groupe_type VARCHAR(255) NOT NULL, nom VARCHAR(255) DEFAULT NULL, idutilisateur_admin_groupe VARCHAR(255) NOT NULL, idsite VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE UNIQUE INDEX UNIQ_547B7608BA0E79C3 ON tchat_groupe (last_message_id)');
        $this->addSql('CREATE INDEX last_message_id_index ON tchat_groupe (last_message_id)');
        $this->addSql('CREATE TABLE tchat_groupe_type (id INT NOT NULL, libelle VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE tchat_groupe_utilisateur (id INT NOT NULL, idutilisateur VARCHAR(255) NOT NULL, idtchat_groupe VARCHAR(255) NOT NULL, notification BOOLEAN DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE UNIQUE INDEX TCHAT_GROUPE_UTILISATEUR_pkey ON tchat_groupe_utilisateur (idutilisateur, idtchat_groupe)');
        $this->addSql('CREATE TABLE tchat_message (id INT NOT NULL, contenu TEXT NOT NULL, idutilisateur VARCHAR(255) NOT NULL, idtchat_groupe VARCHAR(255) NOT NULL, created_at TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX created_at_index ON tchat_message (created_at)');
        $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 UTILISATEUR ADD CONSTRAINT FK_901FF15BD60322AC FOREIGN KEY (role_id) REFERENCES role (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE utilisateur_site ADD CONSTRAINT FK_A0C265DEFB88E14F FOREIGN KEY (utilisateur_id) REFERENCES UTILISATEUR (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE utilisateur_site ADD CONSTRAINT FK_A0C265DEF6BD1646 FOREIGN KEY (site_id) REFERENCES site (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.UTILISATEUR_EMAIL ADD CONSTRAINT FK_4CA82B6FFB88E14F FOREIGN KEY (utilisateur_id) REFERENCES UTILISATEUR (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav.UTILISATEUR_FILTRE ADD CONSTRAINT FK_48348D3FFB88E14F FOREIGN KEY (utilisateur_id) REFERENCES UTILISATEUR (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $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 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 "right" ADD CONSTRAINT FK_B4CA75145DA7244A FOREIGN KEY (group_right_id) REFERENCES group_right (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE site ADD CONSTRAINT FK_694309E46CA5086B FOREIGN KEY (type_sav_id) REFERENCES type_sav (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE tchat_groupe ADD CONSTRAINT FK_547B7608BA0E79C3 FOREIGN KEY (last_message_id) REFERENCES tchat_message (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."TCHAT_MESSAGE"');
        $this->addSql('DROP TABLE sav."ATTACHEMENT_PERIODE_FROID"');
        $this->addSql('DROP TABLE sav."INTERVENTION_MESSAGE_CO"');
        $this->addSql('DROP TABLE sav."MAG_FERMETURE_MEAUX"');
        $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."AGENCE"');
        $this->addSql('DROP TABLE sav."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."ADRESSE_COMPLEMENT"');
        $this->addSql('DROP TABLE sav."TYPE_COMPLEMENT_ADRESSE"');
        $this->addSql('DROP TABLE sav."SITE"');
        $this->addSql('DROP TABLE sav."APPAREIL"');
        $this->addSql('DROP TABLE sav."AGENT_APPAREIL"');
        $this->addSql('DROP TABLE sav."UTILISATEUR"');
        $this->addSql('DROP TABLE sav."AGENT_GPS"');
        $this->addSql('DROP TABLE sav."AGENT_PRODUIT_STOCK"');
        $this->addSql('DROP TABLE sav."EQUIPEMENT_FAMILLE"');
        $this->addSql('DROP TABLE sav."AGENT_QUALIFICATION"');
        $this->addSql('DROP TABLE sav."AGENT_SECTEUR"');
        $this->addSql('DROP TABLE sav."SECTEUR"');
        $this->addSql('DROP TABLE sav."AIDE_TECHNIQUE_ETAT"');
        $this->addSql('DROP TABLE sav."AIDE_TECHNIQUE"');
        $this->addSql('DROP TABLE sav."EQUIPEMENT"');
        $this->addSql('DROP TABLE sav."TYPE_DEMANDEUR"');
        $this->addSql('DROP TABLE sav."AIDE_TECHNIQUE_CLASSIFICATION_LISTE"');
        $this->addSql('DROP TABLE sav."AIDE_TECHNIQUE_CLASSIFICATION"');
        $this->addSql('DROP TABLE sav."AIDE_TECHNIQUE_HISTO"');
        $this->addSql('DROP TABLE sav."ATTACHEMENT_PARAMETRE_LISTE"');
        $this->addSql('DROP TABLE sav."ATTACHEMENT_PARAMETRE"');
        $this->addSql('DROP TABLE sav."UTILISATEUR_PROFIL"');
        $this->addSql('DROP TABLE sav."ATTACHEMENT_PROFIL"');
        $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."CATEGORIE_PRO"');
        $this->addSql('DROP TABLE sav."TYPE_CLIENT"');
        $this->addSql('DROP TABLE sav."COMPTE_CLIENT_WEB"');
        $this->addSql('DROP TABLE sav."CLIENT_EMAIL"');
        $this->addSql('DROP TABLE sav."CLIENT_TEL"');
        $this->addSql('DROP TABLE sav."TYPE_TEL"');
        $this->addSql('DROP TABLE sav."COMMUNICATION_CLIENT"');
        $this->addSql('DROP TABLE sav."COMMUNICATION_CANAL"');
        $this->addSql('DROP TABLE sav."COMMUNICATION_TYPE"');
        $this->addSql('DROP TABLE sav."INTERVENTION"');
        $this->addSql('DROP TABLE sav."CONTRAT_MOTIF_RESILIATION"');
        $this->addSql('DROP TABLE sav."CONTRAT"');
        $this->addSql('DROP TABLE sav."CONTRAT_TYPE"');
        $this->addSql('DROP TABLE sav."FACTURE"');
        $this->addSql('DROP TABLE sav."CONTRAT_PROPOSITION"');
        $this->addSql('DROP TABLE sav."CONTRAT_RELANCE"');
        $this->addSql('DROP TABLE sav."CONTRAT_TARIF"');
        $this->addSql('DROP TABLE sav."PUISSANCE"');
        $this->addSql('DROP TABLE sav."COURRIER_CLIENT"');
        $this->addSql('DROP TABLE sav."DEMANDE_DOCUMENTATION"');
        $this->addSql('DROP TABLE sav."DEVIS"');
        $this->addSql('DROP TABLE sav."NATURE_GAZ"');
        $this->addSql('DROP TABLE sav."EQUIPEMENT_LOCAL"');
        $this->addSql('DROP TABLE sav."EQUIPEMENT_TRANCHE"');
        $this->addSql('DROP TABLE sav."RACCORDEMENT"');
        $this->addSql('DROP TABLE sav."INSTALLATEUR"');
        $this->addSql('DROP TABLE sav."PROTECTION_SANITAIRE"');
        $this->addSql('DROP TABLE sav."ROBINET_REMPLISSAGE"');
        $this->addSql('DROP TABLE sav."EQUIPEMENT_COMPLEMENT"');
        $this->addSql('DROP TABLE sav."TYPE_COMPLEMENT"');
        $this->addSql('DROP TABLE sav."EQUIPEMENT_GROUPE"');
        $this->addSql('DROP TABLE sav."GROUPE_TYPE"');
        $this->addSql('DROP TABLE sav."EQUIPEMENT_MESURE"');
        $this->addSql('DROP TABLE sav."EQUIPEMENT_OPTION"');
        $this->addSql('DROP TABLE sav."TARIF_OPTION"');
        $this->addSql('DROP TABLE sav."EQUIPEMENT_ZONE"');
        $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."FACTURE_LIGNE"');
        $this->addSql('DROP TABLE sav."PRODUIT"');
        $this->addSql('DROP TABLE sav."FACTURE_RELANCE"');
        $this->addSql('DROP TABLE sav."HISTORIQUE_CLIENT_EQUIPEMENT"');
        $this->addSql('DROP TABLE sav."HISTORIQUE_MODIFICATION"');
        $this->addSql('DROP TABLE sav."INTERVENTION_MOTIF"');
        $this->addSql('DROP TABLE sav."PLANNING"');
        $this->addSql('DROP TABLE sav."INTERVENTION_TYPE_VALIDATION"');
        $this->addSql('DROP TABLE sav."TYPE_ENVOI"');
        $this->addSql('DROP TABLE sav."INTERVENTION_MOTIF_ABSENCE"');
        $this->addSql('DROP TABLE sav."INTERVENTION_ANNULATION"');
        $this->addSql('DROP TABLE sav."INTERVENTION_MOTIF_ABANDON"');
        $this->addSql('DROP TABLE sav."INTERVENTION_MOTIF_ANNULATION"');
        $this->addSql('DROP TABLE sav."ANOMALIE"');
        $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."MOYEN_PAIEMENT"');
        $this->addSql('DROP TABLE sav."INTERVENTION_PRE_ENCAISSEMENT"');
        $this->addSql('DROP TABLE sav."RETOUR"');
        $this->addSql('DROP TABLE sav."INTERVENTION_RETOUR"');
        $this->addSql('DROP TABLE sav."INTERVENTION_STACK"');
        $this->addSql('DROP TABLE sav."MAG_COMMANDE"');
        $this->addSql('DROP TABLE sav."MAG_ETAT_COMMANDE"');
        $this->addSql('DROP TABLE sav."MAG_STATUT_COMMANDE"');
        $this->addSql('DROP TABLE sav."MAG_TYPE_COMMANDE"');
        $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."MAG_STOCK_MOUVEMENT"');
        $this->addSql('DROP TABLE sav."OLD_BLOC_NOTE_CLIENT"');
        $this->addSql('DROP TABLE sav."PAIEMENT"');
        $this->addSql('DROP TABLE sav."MOMENT_PASSAGE"');
        $this->addSql('DROP TABLE sav."PLN_CONTROLE_VOITURE"');
        $this->addSql('DROP TABLE sav."PLN_FORMATION"');
        $this->addSql('DROP TABLE sav."PLANNING_HORAIRES_PASSAGE"');
        $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."PLN_TRANSIT"');
        $this->addSql('DROP TABLE sav."PLANNING_LISTE_AGENTS"');
        $this->addSql('DROP TABLE sav."PLANNING_AGENTS_LISTE"');
        $this->addSql('DROP TABLE sav."PLANNING_CONFLIT"');
        $this->addSql('DROP TABLE sav."PLANNING_ACTION"');
        $this->addSql('DROP TABLE sav."PLANNING_HISTORIQUE_MODIFICATION"');
        $this->addSql('DROP TABLE sav."PLANNING_INITIATIVE"');
        $this->addSql('DROP TABLE sav."PLANNING_INITIATIVE_DETAIL"');
        $this->addSql('DROP TABLE sav."PLN_AGENT_BLOCAGE"');
        $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."PLN_DROITS_VISITE"');
        $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_GROUPE_UTILISATEURS"');
        $this->addSql('DROP TABLE sav."PLN_MOTIF_MALADIE"');
        $this->addSql('DROP TABLE sav."PLN_PARAMETRES"');
        $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."PLN_TRANSIT_UTILISATEUR"');
        $this->addSql('DROP TABLE sav."PLN_VISITE_EXCLUSION"');
        $this->addSql('DROP TABLE sav."POLE_SITE"');
        $this->addSql('DROP TABLE sav."PRIVILEGE"');
        $this->addSql('DROP TABLE sav."PRIVILEGE_RAISON_REFUS"');
        $this->addSql('DROP TABLE sav."PRIVILEGE_STATUT"');
        $this->addSql('DROP TABLE sav."PRODUIT_FAMILLE"');
        $this->addSql('DROP TABLE sav."PRODUIT_TYPE"');
        $this->addSql('DROP TABLE sav."PRODUIT_PHOTO"');
        $this->addSql('DROP TABLE sav."PRODUIT_STOCK_SITE"');
        $this->addSql('DROP TABLE sav."PRODUIT_TARIF"');
        $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."SECTORISATION_VERSION"');
        $this->addSql('DROP TABLE sav."SECTEUR_EQUIPEMENT"');
        $this->addSql('DROP TABLE sav."STOCK_STANDARD"');
        $this->addSql('DROP TABLE sav."STOCK_STANDARD_PRODUIT"');
        $this->addSql('DROP TABLE sav."OPTION"');
        $this->addSql('DROP TABLE sav."TCHAT_GROUPE_TYPE"');
        $this->addSql('DROP TABLE sav."TCHAT_GROUPE"');
        $this->addSql('DROP TABLE sav."TCHAT_GROUPE_UTILISATEUR"');
        $this->addSql('DROP TABLE sav."TAUX_TVA"');
        $this->addSql('DROP TABLE sav."TVA_EQUIPEMENT"');
        $this->addSql('DROP TABLE sav."VISITE_CATEGORIE"');
        $this->addSql('DROP TABLE sav."TYPE_VISITE_APPAREIL"');
        $this->addSql('DROP TABLE sav."TYPE_LOGIN"');
        $this->addSql('DROP TABLE sav."TYPE_UTILISATEUR"');
        $this->addSql('DROP TABLE sav."UTILISATEUR_ADRESSE"');
        $this->addSql('DROP TABLE sav."MOTIF_TEMPS_PARTIEL"');
        $this->addSql('DROP TABLE sav."UTILISATEUR_AFFECTATION"');
        $this->addSql('DROP TABLE sav."UTILISATEUR_EMAIL"');
        $this->addSql('DROP TABLE sav."TYPE_EMAIL"');
        $this->addSql('DROP TABLE sav."UTILISATEUR_SITE"');
        $this->addSql('DROP TABLE sav."UTILISATEUR_TEL"');
    }

    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 utilisateur_site DROP CONSTRAINT FK_A0C265DEFB88E14F');
        $this->addSql('ALTER TABLE sav.UTILISATEUR_EMAIL DROP CONSTRAINT FK_4CA82B6FFB88E14F');
        $this->addSql('ALTER TABLE sav.UTILISATEUR_FILTRE DROP CONSTRAINT FK_48348D3FFB88E14F');
        $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 "right" DROP CONSTRAINT FK_B4CA75145DA7244A');
        $this->addSql('ALTER TABLE UTILISATEUR DROP CONSTRAINT FK_901FF15BD60322AC');
        $this->addSql('ALTER TABLE utilisateur_site DROP CONSTRAINT FK_A0C265DEF6BD1646');
        $this->addSql('ALTER TABLE tchat_groupe DROP CONSTRAINT FK_547B7608BA0E79C3');
        $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('ALTER TABLE site DROP CONSTRAINT FK_694309E46CA5086B');
        $this->addSql('DROP SEQUENCE UTILISATEUR_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE sav.UTILISATEUR_FILTRE_id_seq CASCADE');
        $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_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE client_mail_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE client_tel_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE email_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE equipement_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE famille_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE group_right_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE intervention_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE observation_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE "option_id_seq" CASCADE');
        $this->addSql('DROP SEQUENCE options_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE puissance_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 "right_id_seq" CASCADE');
        $this->addSql('DROP SEQUENCE role_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE site_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE taux_tva_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE tchat_groupe_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE tchat_groupe_type_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE tchat_groupe_utilisateur_id_seq CASCADE');
        $this->addSql('DROP SEQUENCE tchat_message_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_client_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.TCHAT_MESSAGE_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.SECTEUR_ID_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $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.AGENT_GPS_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.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.CLIENT_EMAIL_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_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_FAMILLE_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_GROUPE_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_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_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_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_OBSERVATION_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_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.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_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.OPTION_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_HISTORIQUE_MODIFICATION_IDPLANNING_HISTORIQUE_MODIFICA 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_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_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_GROUPE_UTILISATEURS_IDPLN_GROUPE_UTILISATEURS_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_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_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.SITE_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.TCHAT_GROUPE_ID_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE SEQUENCE sav.TCHAT_GROUPE_TYPE_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_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_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 SEQUENCE sav.UTILISATEUR_ID_seq INCREMENT BY 1 MINVALUE 1 START 1');
        $this->addSql('CREATE TABLE sav."TCHAT_MESSAGE" (id BIGSERIAL NOT NULL, idutilisateur BIGINT DEFAULT NULL, idtchat_groupe BIGINT DEFAULT NULL, contenu TEXT DEFAULT NULL, date_envoi TIMESTAMP(0) WITHOUT TIME ZONE NOT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX IDX_803BE1ADDBDD131C ON sav."TCHAT_MESSAGE" (idutilisateur)');
        $this->addSql('CREATE INDEX IDX_803BE1AD12D40901 ON sav."TCHAT_MESSAGE" (idtchat_groupe)');
        $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."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."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."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."AGENCE" (id BIGSERIAL NOT NULL, idsite BIGINT DEFAULT 0, num SMALLINT DEFAULT 0 NOT NULL, nom VARCHAR(30) DEFAULT NULL, raison_sociale VARCHAR(40) DEFAULT NULL, type_societe VARCHAR(40) DEFAULT NULL, banque VARCHAR(20) DEFAULT NULL, num_tel VARCHAR(10) DEFAULT NULL, code_client_agi VARCHAR(9) DEFAULT NULL, privilege BOOLEAN DEFAULT \'false\', PRIMARY KEY(id))');
        $this->addSql('CREATE UNIQUE INDEX "AGENCE_NUM_AGENCE_key" ON sav."AGENCE" (num)');
        $this->addSql('CREATE UNIQUE INDEX "AGENCE_IDSITE_key" ON sav."AGENCE" (idsite)');
        $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_IDTYPE_LOGEMENT" ON sav."ADRESSE" (idtype_logement)');
        $this->addSql('CREATE INDEX "IDX_ADRESSE_IDCLIENT" ON sav."ADRESSE" (idclient)');
        $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 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_IDCOMPTE_CLIENT_WEB" ON sav."CLIENT" (idcompte_client_web)');
        $this->addSql('CREATE INDEX "IDX_CLIENT_IDSOUSCRIPTEUR" ON sav."CLIENT" (idsouscripteur)');
        $this->addSql('CREATE INDEX "IDX_CLIENT_CODE_EC" ON sav."CLIENT" (code_ec)');
        $this->addSql('CREATE INDEX "IDX_CLIENT_IDCATEGORIE_PRO" ON sav."CLIENT" (idcategorie_pro)');
        $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."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."TYPE_COMPLEMENT_ADRESSE" (id BIGSERIAL NOT NULL, libelle VARCHAR(30) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav."SITE" (id BIGSERIAL NOT NULL, num SMALLINT DEFAULT 0, nom VARCHAR(25) DEFAULT NULL, antenne BOOLEAN DEFAULT \'false\', PRIMARY KEY(id))');
        $this->addSql('CREATE UNIQUE INDEX "SITE_NUM_key" ON sav."SITE" (num)');
        $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."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."UTILISATEUR" (id BIGSERIAL NOT NULL, idtype_login BIGINT DEFAULT NULL, idtype_utilisateur SMALLINT DEFAULT 0, idutilisateur_responsable BIGINT DEFAULT 0, idutilisateur_valide_conges BIGINT DEFAULT 0, idpole_site BIGINT DEFAULT NULL, idagence BIGINT DEFAULT NULL, nom VARCHAR(50) DEFAULT NULL, prenom VARCHAR(50) DEFAULT NULL, login VARCHAR(255) DEFAULT NULL, password VARCHAR(64) DEFAULT NULL, cle_salage VARCHAR(50) DEFAULT NULL, url_homepage VARCHAR(250) DEFAULT NULL, date_embauche TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, code_client_agi VARCHAR(9) DEFAULT NULL, token_mobilite VARCHAR(48) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE UNIQUE INDEX "UTILISATEUR_CODE_CLIENT_AGI_key" ON sav."UTILISATEUR" (code_client_agi)');
        $this->addSql('CREATE INDEX "IDX_UTILISATEUR_IDTYPE_UTILISATEUR" ON sav."UTILISATEUR" (idtype_utilisateur)');
        $this->addSql('CREATE INDEX "IDX_UTILISATEUR_IDUTILISATEUR_VALIDE_CONGES" ON sav."UTILISATEUR" (idutilisateur_valide_conges)');
        $this->addSql('CREATE INDEX "IDX_UTILISATEUR_IDPOLE_SITE" ON sav."UTILISATEUR" (idpole_site)');
        $this->addSql('CREATE INDEX "IDX_UTILISATEUR_IDTYPE_LOGIN" ON sav."UTILISATEUR" (idtype_login)');
        $this->addSql('CREATE INDEX "IDX_UTILISATEUR_IDAGENCE" ON sav."UTILISATEUR" (idagence)');
        $this->addSql('CREATE INDEX "IDX_UTILISATEUR_IDUTILISATEUR_RESPONSABLE" ON sav."UTILISATEUR" (idutilisateur_responsable)');
        $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_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_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 INDEX "IDX_AGENT_PRODUIT_STOCK_IDAGENT" ON sav."AGENT_PRODUIT_STOCK" (idagent)');
        $this->addSql('CREATE TABLE sav."EQUIPEMENT_FAMILLE" (id BIGSERIAL NOT NULL, code SMALLINT DEFAULT 0 NOT NULL, libelle VARCHAR(40) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE UNIQUE INDEX "EQUIPEMENT_FAMILLE_CODE_key" ON sav."EQUIPEMENT_FAMILLE" (code)');
        $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_IDUTILISATEUR_AGENT" ON sav."AGENT_QUALIFICATION" (idutilisateur_agent)');
        $this->addSql('CREATE INDEX "IDX_AGENT_QUALIFICATION_IDEQUIPEMENT_FAMILLE" ON sav."AGENT_QUALIFICATION" (idequipement_famille)');
        $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."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_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_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_TARIF" ON sav."SECTEUR" (idsecteur_tarif)');
        $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."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_IDEQUIPEMENT" ON sav."AIDE_TECHNIQUE" (idequipement)');
        $this->addSql('CREATE INDEX "IDX_AIDE_TECHNIQUE_IDTYPE_DEMANDEUR" ON sav."AIDE_TECHNIQUE" (idtype_demandeur)');
        $this->addSql('CREATE INDEX "IDX_AIDE_TECHNIQUE_IDAIDE_TECHNIQUE_ETAT" ON sav."AIDE_TECHNIQUE" (idaide_technique_etat)');
        $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 VARCHAR(3) 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_IDRACCORDEMENT" ON sav."EQUIPEMENT" (idraccordement)');
        $this->addSql('CREATE INDEX "IDX_EQUIPEMENT_IDPROTECTION_SANITAIRE" ON sav."EQUIPEMENT" (idprotection_sanitaire)');
        $this->addSql('CREATE INDEX "IDX_EQUIPEMENT_IDROBINET_REMPLISSAGE" ON sav."EQUIPEMENT" (idrobinet_remplissage)');
        $this->addSql('CREATE INDEX "IDX_EQUIPEMENT_IDCLIENT" ON sav."EQUIPEMENT" (idclient)');
        $this->addSql('CREATE INDEX "IDX_EQUIPEMENT_IDADRESSE" ON sav."EQUIPEMENT" (idadresse)');
        $this->addSql('CREATE INDEX "IDX_EQUIPEMENT_IDEQUIPEMENT_TYPE" ON sav."EQUIPEMENT" (idequipement_type)');
        $this->addSql('CREATE INDEX "IDX_EQUIPEMENT_TRANCHE_EQUIPEMENT" ON sav."EQUIPEMENT" (idtranche_equipement)');
        $this->addSql('CREATE INDEX "IDX_EQUIPEMENT_IDINSTALLATEUR" ON sav."EQUIPEMENT" (idinstallateur)');
        $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_IDNATURE_GAZ" ON sav."EQUIPEMENT" (idnature_gaz)');
        $this->addSql('CREATE TABLE sav."TYPE_DEMANDEUR" (id BIGSERIAL NOT NULL, libelle VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $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_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_5A3D921D8F110DB ON sav."AIDE_TECHNIQUE_CLASSIFICATION" (idaide_technique_classification_liste)');
        $this->addSql('CREATE INDEX IDX_5A3D921D2B8D6A42 ON sav."AIDE_TECHNIQUE_CLASSIFICATION" (idaide_technique)');
        $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_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 INDEX "IDX_AIDE_TECHNIQUE_HISTO_IDAIDE_TECHNIQUE" ON sav."AIDE_TECHNIQUE_HISTO" (idaide_technique)');
        $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."UTILISATEUR_PROFIL" (id BIGSERIAL NOT NULL, libelle VARCHAR(50) DEFAULT NULL, calcul_attachement BOOLEAN DEFAULT \'false\', PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav."ATTACHEMENT_PROFIL" (id BIGSERIAL NOT NULL, idutilisateur_profil BIGINT DEFAULT NULL, plafond_point INT DEFAULT 0, coefficient INT DEFAULT 0, valeur_point INT DEFAULT 0, annee INT DEFAULT 0, semestre SMALLINT DEFAULT 0, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX "IDX_ATTACHEMENT_PROFIL_IDUTILISATEUR_PROFIL" ON sav."ATTACHEMENT_PROFIL" (idutilisateur_profil)');
        $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 UNIQUE INDEX "EQUIPEMENT_TYPE_TYPE_key" ON sav."EQUIPEMENT_TYPE" (type)');
        $this->addSql('CREATE INDEX "IDX_EQUIPEMENT_TYPE_IDEQUIPEMENT_FAMILLE" ON sav."EQUIPEMENT_TYPE" (idequipement_famille)');
        $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."CATEGORIE_PRO" (id BIGSERIAL NOT NULL, libelle VARCHAR(30) 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."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."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."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."TYPE_TEL" (id BIGSERIAL NOT NULL, libelle VARCHAR(20) DEFAULT NULL, PRIMARY KEY(id))');
        $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_IDEQUIPEMENT" ON sav."COMMUNICATION_CLIENT" (idequipement)');
        $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_IDCOMMUNICATION_CANAL" ON sav."COMMUNICATION_CLIENT" (idcommunication_canal)');
        $this->addSql('CREATE INDEX "IDX_COMMUNICATION_CLIENT_IDINTERVENTION" ON sav."COMMUNICATION_CLIENT" (idintervention)');
        $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."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, idtype_validation_technique SMALLINT DEFAULT 0, idtype_validation_adm SMALLINT 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, commentaire_technique TEXT DEFAULT NULL, validation_adm_par VARCHAR(50) DEFAULT NULL, validation_adm_le TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX "IDX_INTERVENTION_IDTYPE_ENVOI_RAPPORT" ON sav."INTERVENTION" (idtype_envoi_rapport)');
        $this->addSql('CREATE INDEX "IDX_INTERVENTION_IDTYPE_VALIDATION_TECHNIQUE" ON sav."INTERVENTION" (idtype_validation_technique)');
        $this->addSql('CREATE INDEX "IDX_INTERVENTION_IDTYPE_VALIDATION_ADM" ON sav."INTERVENTION" (idtype_validation_adm)');
        $this->addSql('CREATE INDEX "IDX_INTERVENTION_IDINTERVENTION_MOTIF" ON sav."INTERVENTION" (idintervention_motif)');
        $this->addSql('CREATE INDEX "IDX_INTERVENTION_IDFACTURE" ON sav."INTERVENTION" (idfacture)');
        $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_IDEQUIPEMENT" ON sav."INTERVENTION" (idequipement)');
        $this->addSql('CREATE INDEX "IDX_INTERVENTION_IDCONTRAT" ON sav."INTERVENTION" (idcontrat)');
        $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" (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_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_CONTRAT_IDEQUIPEMENT" ON sav."CONTRAT" (idequipement)');
        $this->addSql('CREATE INDEX IDX_A6C24CBA61333331 ON sav."CONTRAT" (idagent_souscription)');
        $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."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_IDADRESSE" ON sav."FACTURE" (idadresse)');
        $this->addSql('CREATE INDEX "IDX_FACTURE_IDCATEGORIE_FACTURE" ON sav."FACTURE" (idcategorie_facture)');
        $this->addSql('CREATE UNIQUE INDEX "FACTURE_NUM_FACTURE_key" ON sav."FACTURE" (num_facture)');
        $this->addSql('CREATE INDEX "IDX_FACTURE_IDFACTURE_TYPE" ON sav."FACTURE" (idfacture_type)');
        $this->addSql('CREATE INDEX "IDX_FACTURE_IDINTERVENTION" ON sav."FACTURE" (idintervention)');
        $this->addSql('CREATE INDEX "IDX_FACTURE_IDEQUIPEMENT" ON sav."FACTURE" (idequipement)');
        $this->addSql('CREATE INDEX "IDX_FACTURE_IDDEVIS" ON sav."FACTURE" (iddevis)');
        $this->addSql('CREATE INDEX "IDX_FACTURE_IDSITE" ON sav."FACTURE" (idsite)');
        $this->addSql('CREATE INDEX "IDX_FACTURE_IDAGENCE" ON sav."FACTURE" (idagence)');
        $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."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_IDEQUIPEMENT_TYPE" ON sav."CONTRAT_TARIF" (idequipement_type)');
        $this->addSql('CREATE INDEX "IDX_CONTRAT_TARIF_IDCONTRAT_TYPE" ON sav."CONTRAT_TARIF" (idcontrat_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."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."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_IDEQUIPEMENT" ON sav."DEMANDE_DOCUMENTATION" (idequipement)');
        $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 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."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."EQUIPEMENT_LOCAL" (id SMALLINT DEFAULT 0 NOT NULL, libelle VARCHAR(30) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav."EQUIPEMENT_TRANCHE" (id VARCHAR(3) DEFAULT \'0\' NOT NULL, age SMALLINT DEFAULT 0, plus_value NUMERIC(6, 2) DEFAULT \'0\', 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."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 INDEX "IDX_INSTALLATEUR_NOM" ON sav."INSTALLATEUR" (nom)');
        $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 TABLE sav."PROTECTION_SANITAIRE" (id BIGSERIAL NOT NULL, libelle VARCHAR(30) 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_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."TYPE_COMPLEMENT" (id BIGSERIAL NOT NULL, libelle VARCHAR(50) 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."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_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_26A4F9FC751DDBC9 ON sav."EQUIPEMENT_MESURE" (idequipement)');
        $this->addSql('CREATE INDEX IDX_26A4F9FC97B76BA2 ON sav."EQUIPEMENT_MESURE" (idintervention)');
        $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('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_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 INDEX "IDX_TARIF_OPTION_IDOPTION" ON sav."TARIF_OPTION" (idoption)');
        $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_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."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."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_IDPRODUIT_FAMILLE" ON sav."PRODUIT" (idproduit_famille)');
        $this->addSql('CREATE INDEX "IDX_PRODUIT_IDSITE" ON sav."PRODUIT" (idsite)');
        $this->addSql('CREATE INDEX "IDX_PRODUIT_IDPRODUIT_TYPE" ON sav."PRODUIT" (idproduit_type)');
        $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."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."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_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_EFFECTUEE" ON sav."HISTORIQUE_MODIFICATION" (effectuee)');
        $this->addSql('CREATE INDEX "IDX_HISTORIQUE_MODIFICATION_IDCLIENT" ON sav."HISTORIQUE_MODIFICATION" (idclient)');
        $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_DD123EC09E6B769E ON sav."HISTORIQUE_MODIFICATION" (idutilisateur_valide)');
        $this->addSql('CREATE TABLE sav."INTERVENTION_MOTIF" (id BIGSERIAL NOT NULL, libelle VARCHAR(30) DEFAULT NULL, PRIMARY KEY(id))');
        $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_IDMOMENT_PASSAGE" ON sav."PLANNING" (idmoment_passage)');
        $this->addSql('CREATE INDEX "IDX_PLANNING_IDPLN_HORAIRES_PASSAGE" ON sav."PLANNING" (idpln_horaires_passage)');
        $this->addSql('CREATE INDEX "IDX_PLANNING_IDPLN_FORMATION" ON sav."PLANNING" (idpln_formation)');
        $this->addSql('CREATE INDEX "IDX_PLANNING_IDTYPE_VISITE" ON sav."PLANNING" (idtype_visite)');
        $this->addSql('CREATE INDEX "IDX_PLANNING_IDPLN_RESERVE" ON sav."PLANNING" (idpln_reserve)');
        $this->addSql('CREATE INDEX "IDX_PLANNING_IDPLN_MALADIE" ON sav."PLANNING" (idpln_maladie)');
        $this->addSql('CREATE INDEX "IDX_PLANNING_IDPLN_ANNULATION" ON sav."PLANNING" (idpln_annulation)');
        $this->addSql('CREATE INDEX "IDX_PLANNING_IDUTILISATEUR_AGENT" ON sav."PLANNING" (idutilisateur_agent)');
        $this->addSql('CREATE INDEX "IDX_PLANNING_IDEQUIPEMENT" ON sav."PLANNING" (idequipement)');
        $this->addSql('CREATE INDEX "IDX_PLANNING_IDPLN_TRANSIT" ON sav."PLANNING" (idpln_transit)');
        $this->addSql('CREATE INDEX "IDX_PLANNING_IDPLN_REUNION" ON sav."PLANNING" (idpln_reunion)');
        $this->addSql('CREATE INDEX "IDX_PLANNING_IDPLN_CONTROLE_VOITURE" ON sav."PLANNING" (idpln_controle_voiture)');
        $this->addSql('CREATE INDEX "IDX_PLANNING_IDPLN_TEST" ON sav."PLANNING" (idpln_test)');
        $this->addSql('CREATE TABLE sav."INTERVENTION_TYPE_VALIDATION" (id SMALLINT DEFAULT 0 NOT NULL, libelle VARCHAR(50) 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."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_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_IDINTERVENTION_MOTIF_ANNULATION" ON sav."INTERVENTION_ANNULATION" (idintervention_motif_annulation)');
        $this->addSql('CREATE INDEX "IDX_INTERVENTION_ANNULATION_IDINTERVENTION_MOTIF_ABSENCE" ON sav."INTERVENTION_ANNULATION" (idintervention_motif_absence)');
        $this->addSql('CREATE INDEX "IDX_INTERVENTION_ANNULATION_IDPLANNING" ON sav."INTERVENTION_ANNULATION" (idplanning)');
        $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_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_ANOMALIE" (idintervention BIGINT NOT NULL, idanomalie SMALLINT NOT NULL, PRIMARY KEY(idintervention, idanomalie))');
        $this->addSql('CREATE INDEX IDX_47D275F1DB8FE991 ON sav."INTERVENTION_ANOMALIE" (idanomalie)');
        $this->addSql('CREATE INDEX IDX_47D275F197B76BA2 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 UNIQUE INDEX "INTERVENTION_PAYEUR_EXTERNE_IDINTERVENTION_key" ON sav."INTERVENTION_PAYEUR_EXTERNE" (idintervention)');
        $this->addSql('CREATE INDEX "IDX_INTERVENTION_PAYEUR_EXTERNE_IDADRESSE" ON sav."INTERVENTION_PAYEUR_EXTERNE" (idadresse)');
        $this->addSql('CREATE INDEX "IDX_INTERVENTION_PAYEUR_EXTERNE_NOM" ON sav."INTERVENTION_PAYEUR_EXTERNE" (nom)');
        $this->addSql('CREATE INDEX "IDX_INTERVENTION_PAYEUR_EXTERNE_IDTYPE_CLIENT" ON sav."INTERVENTION_PAYEUR_EXTERNE" (idtype_client)');
        $this->addSql('CREATE TABLE sav."MOYEN_PAIEMENT" (id BIGSERIAL NOT NULL, libelle_court VARCHAR(3) DEFAULT NULL, libelle_long VARCHAR(30) DEFAULT NULL, mobilite BOOLEAN DEFAULT \'false\', PRIMARY KEY(id))');
        $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_IDINTERVENTION" ON sav."INTERVENTION_PRE_ENCAISSEMENT" (idintervention)');
        $this->addSql('CREATE INDEX "IDX_INTERVENTION_PRE_ENCAISSEMENT_INTERVENTION_PRE_ENCAISSEMENT" ON sav."INTERVENTION_PRE_ENCAISSEMENT" (code_groupe, recupere_le)');
        $this->addSql('CREATE TABLE sav."RETOUR" (id SMALLINT DEFAULT 0 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."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."MAG_COMMANDE" (id BIGINT DEFAULT 0 NOT NULL, idsite BIGINT DEFAULT 0, idequipement BIGINT DEFAULT NULL, idintervention BIGINT DEFAULT NULL, idmag_statut_commande SMALLINT DEFAULT 0 NOT 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, 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_IDTYPE_CDE" ON sav."MAG_COMMANDE" (idtype_cde)');
        $this->addSql('CREATE INDEX "IDX_MAG_COMMANDE_IDINTERVENTION" ON sav."MAG_COMMANDE" (idintervention)');
        $this->addSql('CREATE INDEX "IDX_MAG_COMMANDE_IDUTILISATEUR" ON sav."MAG_COMMANDE" (idutilisateur)');
        $this->addSql('CREATE INDEX "IDX_MAG_COMMANDE_IDMAG_STATUT_COMMANDE" ON sav."MAG_COMMANDE" (idmag_statut_commande)');
        $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_IDSITE" ON sav."MAG_COMMANDE" (idsite)');
        $this->addSql('CREATE INDEX "IDX_MAG_COMMANDE_IDSITE_LIVRAISON" ON sav."MAG_COMMANDE" (idsite_livraison)');
        $this->addSql('CREATE INDEX "IDX_MAG_COMMANDE_IDEQUIPEMENT" ON sav."MAG_COMMANDE" (idequipement)');
        $this->addSql('CREATE TABLE sav."MAG_ETAT_COMMANDE" (id BIGSERIAL NOT NULL, libelle VARCHAR(20) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav."MAG_STATUT_COMMANDE" (id SMALLINT DEFAULT 0 NOT NULL, libelle VARCHAR(30) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav."MAG_TYPE_COMMANDE" (id SMALLINT DEFAULT 0 NOT NULL, libelle VARCHAR(30) DEFAULT NULL, categorie_client VARCHAR(1) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav."MAG_COMMANDE_HISTO" (id BIGSERIAL NOT NULL, idmag_commande BIGINT DEFAULT NULL, idutilisateur BIGINT DEFAULT 0, idmag_statut_commande SMALLINT DEFAULT NULL, idmag_etat_commande BIGINT DEFAULT NULL, date_heure TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, commentaire TEXT DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX "IDX_MAG_COMMANDE_HISTO_IDMAG_COMMANDE" ON sav."MAG_COMMANDE_HISTO" (idmag_commande)');
        $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 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_IDMAG_COMMANDE" ON sav."MAG_LIGNE_COMMANDE" (idmag_commande)');
        $this->addSql('CREATE INDEX "IDX_MAG_LIGNE_COMMANDE_IDPRODUIT" ON sav."MAG_LIGNE_COMMANDE" (idproduit)');
        $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_IDUTILISATEUR" ON sav."MAG_STOCK_MOUVEMENT" (idutilisateur)');
        $this->addSql('CREATE INDEX "IDX_MAG_STOCK_MOUVEMENT_IDSITE" ON sav."MAG_STOCK_MOUVEMENT" (idsite)');
        $this->addSql('CREATE INDEX "IDX_MAG_STOCK_MOUVEMENT_IDPRODUIT" ON sav."MAG_STOCK_MOUVEMENT" (idproduit)');
        $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."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_IDFACTURE" ON sav."PAIEMENT" (idfacture)');
        $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 TABLE sav."MOMENT_PASSAGE" (id SMALLINT DEFAULT 0 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_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_LIEU" ON sav."PLN_CONTROLE_VOITURE" (idpln_voiture_lieu)');
        $this->addSql('CREATE INDEX "IDX_PLN_CONTROLE_VOITURE_IDPLN_VOITURE_ACTION" ON sav."PLN_CONTROLE_VOITURE" (idpln_voiture_action)');
        $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_LIEU" ON sav."PLN_FORMATION" (idpln_formation_lieu)');
        $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_INTITULE" ON sav."PLN_FORMATION" (idpln_formation_intitule)');
        $this->addSql('CREATE TABLE sav."PLANNING_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_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_ORDRE_JOUR" ON sav."PLN_REUNION" (idpln_reunion_ordre_jour)');
        $this->addSql('CREATE INDEX "IDX_PLN_REUNION_IDPLN_REUNION_LIEU" ON sav."PLN_REUNION" (idpln_reunion_lieu)');
        $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_LIEU" ON sav."PLN_TEST" (idpln_test_lieu)');
        $this->addSql('CREATE INDEX "IDX_PLN_TEST_IDPLN_TEST_INTITULE" ON sav."PLN_TEST" (idpln_test_intitule)');
        $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."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_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_IDPLN_LISTE_AGENTS" ON sav."PLANNING_AGENTS_LISTE" (idpln_liste_agents)');
        $this->addSql('CREATE INDEX "IDX_PLANNING_AGENTS_LISTE_IDUTILISATEUR_AGENT" ON sav."PLANNING_AGENTS_LISTE" (idutilisateur_agent)');
        $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 UNIQUE INDEX "PLANNING_CONFLIT_IDPLANNING_key" ON sav."PLANNING_CONFLIT" (idplanning)');
        $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 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_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_MOMENT" ON sav."PLANNING_HISTORIQUE_MODIFICATION" (moment)');
        $this->addSql('CREATE INDEX "IDX_PLANNING_HISTORIQUE_MODIFICATION_IDPLANNING" ON sav."PLANNING_HISTORIQUE_MODIFICATION" (idplanning)');
        $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_IDUTILISATEUR" ON sav."PLANNING_HISTORIQUE_MODIFICATION" (idutilisateur)');
        $this->addSql('CREATE INDEX "IDX_PLANNING_HISTORIQUE_MODIFICATION_IDPLANNING_INITIATIVE" ON sav."PLANNING_HISTORIQUE_MODIFICATION" (idplanning_initiative)');
        $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_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 TABLE sav."PLANNING_INITIATIVE" (idplanning_initiative SERIAL NOT NULL, libelle VARCHAR(30) DEFAULT NULL, desactiver SMALLINT DEFAULT NULL, PRIMARY KEY(idplanning_initiative))');
        $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_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_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 INDEX "IDX_PLN_CONFIG_VISITE_IDPLN_CONFIG_REQ" ON sav."PLN_CONFIG_VISITE" (idpln_config_req)');
        $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 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."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_IDTYPE_VISITE" ON sav."PLN_DROITS_VISITE" (idtype_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_IDUTILISATEUR" ON sav."PLN_DROITS_VISITE" (idutilisateur)');
        $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_IDPLN_GROUPES" ON sav."PLN_GROUPES_DROITS_VISITE" (idpln_groupes)');
        $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_IDTYPE_VISITE" ON sav."PLN_GROUPES_DROITS_VISITE" (idtype_visite)');
        $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_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 INDEX "IDX_PLN_GROUPE_UTILISATEURS_IDPLN_Groupes_Login" ON sav."PLN_GROUPE_UTILISATEURS" (idpln_groupes, idutilisateur)');
        $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."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_Nom_ParamSéquenceNOM_UTILISATEUR" ON sav."PLN_PARAMETRES" (nom_param, séquence, nom_utilisateur, idsite)');
        $this->addSql('CREATE INDEX "IDX_PLN_PARAMETRES_IDSITE" ON sav."PLN_PARAMETRES" (idsite)');
        $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."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_IDTYPE_VISITE" ON sav."PLN_VISITE_EXCLUSION" (idtype_visite)');
        $this->addSql('CREATE INDEX "IDX_PLN_VISITE_EXCLUSION_IDUTILISATEUR" ON sav."PLN_VISITE_EXCLUSION" (idutilisateur)');
        $this->addSql('CREATE TABLE sav."POLE_SITE" (id BIGSERIAL NOT NULL, idsite BIGINT DEFAULT NULL, libelle VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX "IDX_POLE_SITE_IDSITE" ON sav."POLE_SITE" (idsite)');
        $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 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 INDEX "IDX_PRIVILEGE_STATUT_PRIVILEGE" ON sav."PRIVILEGE" (idprivilege_statut)');
        $this->addSql('CREATE UNIQUE INDEX "PRIVILEGE_IDINTERVENTION_key" ON sav."PRIVILEGE" (idintervention)');
        $this->addSql('CREATE TABLE sav."PRIVILEGE_RAISON_REFUS" (id SMALLINT DEFAULT 0 NOT NULL, libelle VARCHAR(80) DEFAULT NULL, PRIMARY KEY(id))');
        $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_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_TYPE" (id BIGSERIAL NOT NULL, libelle VARCHAR(30) DEFAULT NULL, PRIMARY KEY(id))');
        $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_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."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."TYPE_RETOUR" (id INT DEFAULT 0 NOT NULL, libelle VARCHAR(20) 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."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."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."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."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_IDSTOCK_STANDARD" ON sav."STOCK_STANDARD_PRODUIT" (idstock_standard)');
        $this->addSql('CREATE INDEX "IDX_STOCK_STANDARD_PRODUIT_IDPRODUIT" ON sav."STOCK_STANDARD_PRODUIT" (idproduit)');
        $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."TCHAT_GROUPE_TYPE" (id BIGSERIAL NOT NULL, libelle VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav."TCHAT_GROUPE" (id BIGSERIAL NOT NULL, idtchat_groupe_type BIGINT DEFAULT NULL, idsite BIGINT DEFAULT NULL, idutilisateur_admin_groupe BIGINT DEFAULT 0, nom VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX "IDX_TCHAT_GROUPE_IDUTILISATEUR_ADMIN_GROUPE" ON sav."TCHAT_GROUPE" (idutilisateur_admin_groupe)');
        $this->addSql('CREATE INDEX "IDX_TCHAT_GROUPE_IDTCHAT_GROUPE_TYPE" ON sav."TCHAT_GROUPE" (idtchat_groupe_type)');
        $this->addSql('CREATE INDEX "IDX_TCHAT_GROUPE_IDSITE" ON sav."TCHAT_GROUPE" (idsite)');
        $this->addSql('CREATE TABLE sav."TCHAT_GROUPE_UTILISATEUR" (idutilisateur BIGINT DEFAULT 0 NOT NULL, idtchat_groupe BIGINT DEFAULT 0 NOT NULL, PRIMARY KEY(idutilisateur, idtchat_groupe))');
        $this->addSql('CREATE INDEX "IDX_TCHAT_GROUPE_UTILISATEUR_IDUTILISATEUR" ON sav."TCHAT_GROUPE_UTILISATEUR" (idutilisateur)');
        $this->addSql('CREATE INDEX "IDX_TCHAT_GROUPE_UTILISATEUR_IDTCHAT_GROUPE" ON sav."TCHAT_GROUPE_UTILISATEUR" (idtchat_groupe)');
        $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."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_IDTAUX_TVA" ON sav."TVA_EQUIPEMENT" (idtaux_tva)');
        $this->addSql('CREATE INDEX "IDX_TVA_EQUIPEMENT_IDTYPE_CLIENT" ON sav."TVA_EQUIPEMENT" (idtype_client)');
        $this->addSql('CREATE INDEX "IDX_TVA_EQUIPEMENT_IDEQUIPEMENT_FAMILLE" ON sav."TVA_EQUIPEMENT" (idequipement_famille)');
        $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."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."TYPE_LOGIN" (id BIGSERIAL NOT NULL, libelle VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav."TYPE_UTILISATEUR" (id BIGSERIAL NOT NULL, libelle VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav."UTILISATEUR_ADRESSE" (id BIGSERIAL NOT NULL, idutilisateur BIGINT DEFAULT NULL, longitude DOUBLE PRECISION DEFAULT \'0\', latitude DOUBLE PRECISION DEFAULT \'0\', date_application DATE DEFAULT NULL, actif BOOLEAN DEFAULT \'true\', PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX "IDX_UTILISATEUR_ADRESSE_IDUTILISATEUR" ON sav."UTILISATEUR_ADRESSE" (idutilisateur)');
        $this->addSql('CREATE TABLE sav."MOTIF_TEMPS_PARTIEL" (id BIGSERIAL NOT NULL, libelle VARCHAR(30) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav."UTILISATEUR_AFFECTATION" (id BIGSERIAL NOT NULL, idutilisateur BIGINT DEFAULT 0, idutilisateur_profil BIGINT DEFAULT NULL, idutilisateur_planning BIGINT DEFAULT NULL, idutilisateur_responsable BIGINT DEFAULT NULL, idpole_site BIGINT DEFAULT NULL, idmotif_temps_partiel BIGINT DEFAULT NULL, idutilisateur_binome BIGINT DEFAULT NULL, debut_effet TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, fin_effet TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, service VARCHAR(4) DEFAULT NULL, est_responsable BOOLEAN DEFAULT \'false\', planifiable BOOLEAN DEFAULT \'false\', temps_travail INT DEFAULT 0, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX "IDX_UTILISATEUR_AFFECTATION_IDUTILISATEUR_BINOME" ON sav."UTILISATEUR_AFFECTATION" (idutilisateur_binome)');
        $this->addSql('CREATE INDEX "IDX_UTILISATEUR_AFFECTATION_IDPOLE_SITE" ON sav."UTILISATEUR_AFFECTATION" (idpole_site)');
        $this->addSql('CREATE INDEX "IDX_UTILISATEUR_AFFECTATION_IDUTILISATEUR_RESPONSABLE" ON sav."UTILISATEUR_AFFECTATION" (idutilisateur_responsable)');
        $this->addSql('CREATE INDEX "IDX_UTILISATEUR_AFFECTATION_IDUTILISATEUR_PROFIL" ON sav."UTILISATEUR_AFFECTATION" (idutilisateur_profil)');
        $this->addSql('CREATE INDEX "IDX_UTILISATEUR_AFFECTATION_IDMOTIF_TEMPS_PARTIEL" ON sav."UTILISATEUR_AFFECTATION" (idmotif_temps_partiel)');
        $this->addSql('CREATE INDEX "IDX_UTILISATEUR_AFFECTATION_IDUTILISATEUR_PLANNING" ON sav."UTILISATEUR_AFFECTATION" (idutilisateur_planning)');
        $this->addSql('CREATE INDEX "IDX_UTILISATEUR_AFFECTATION_IDUTILISATEUR" ON sav."UTILISATEUR_AFFECTATION" (idutilisateur)');
        $this->addSql('CREATE TABLE sav."UTILISATEUR_EMAIL" (id BIGSERIAL NOT NULL, idutilisateur BIGINT DEFAULT NULL, idtype_email BIGINT DEFAULT NULL, email VARCHAR(260) DEFAULT NULL, commentaire VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX "IDX_UTILISATEUR_EMAIL_IDUTILISATEUR" ON sav."UTILISATEUR_EMAIL" (idutilisateur)');
        $this->addSql('CREATE INDEX "IDX_UTILISATEUR_EMAIL_IDTYPE_EMAIL" ON sav."UTILISATEUR_EMAIL" (idtype_email)');
        $this->addSql('CREATE TABLE sav."TYPE_EMAIL" (id BIGSERIAL NOT NULL, libelle VARCHAR(50) DEFAULT NULL, PRIMARY KEY(id))');
        $this->addSql('CREATE TABLE sav."UTILISATEUR_SITE" (idutilisateur BIGINT DEFAULT 0 NOT NULL, idsite BIGINT DEFAULT 0 NOT NULL, PRIMARY KEY(idutilisateur, idsite))');
        $this->addSql('CREATE INDEX "IDX_UTILISATEUR_SITE_IDUTILISATEUR" ON sav."UTILISATEUR_SITE" (idutilisateur)');
        $this->addSql('CREATE INDEX "IDX_UTILISATEUR_SITE_IDSITE" ON sav."UTILISATEUR_SITE" (idsite)');
        $this->addSql('CREATE TABLE sav."UTILISATEUR_TEL" (id BIGSERIAL NOT NULL, idutilisateur BIGINT DEFAULT NULL, idtype_tel BIGINT DEFAULT 0, numero VARCHAR(10) DEFAULT NULL, commentaire VARCHAR(50) DEFAULT NULL, priorite SMALLINT DEFAULT 0, PRIMARY KEY(id))');
        $this->addSql('CREATE INDEX "IDX_UTILISATEUR_TEL_IDUTILISATEUR" ON sav."UTILISATEUR_TEL" (idutilisateur)');
        $this->addSql('CREATE INDEX "IDX_UTILISATEUR_TEL_IDTYPE_TEL" ON sav."UTILISATEUR_TEL" (idtype_tel)');
        $this->addSql('ALTER TABLE sav."TCHAT_MESSAGE" ADD CONSTRAINT "TCHAT_GROUPE_IDUTILISATEUR_fkey" FOREIGN KEY (idutilisateur) REFERENCES sav."UTILISATEUR" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."TCHAT_MESSAGE" ADD CONSTRAINT "TCHAT_GROUPE_IDTCHAT_GROUPE_fkey" FOREIGN KEY (idtchat_groupe) REFERENCES sav."TCHAT_GROUPE" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."AGENCE" ADD CONSTRAINT "AGENCE_IDSITE_fkey" FOREIGN KEY (idsite) REFERENCES sav."SITE" (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."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_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."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."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."UTILISATEUR" ADD CONSTRAINT "UTILISATEUR_IDAGENCE_fkey" FOREIGN KEY (idagence) REFERENCES sav."AGENCE" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."UTILISATEUR" ADD CONSTRAINT "UTILISATEUR_IDUTILISATEUR_RESPONSABLE_fkey" FOREIGN KEY (idutilisateur_responsable) REFERENCES sav."UTILISATEUR" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."UTILISATEUR" ADD CONSTRAINT "UTILISATEUR_IDUTILISATEUR_VALIDE_CONGES_fkey" FOREIGN KEY (idutilisateur_valide_conges) REFERENCES sav."UTILISATEUR" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."UTILISATEUR" ADD CONSTRAINT "UTILISATEUR_IDPOLE_SITE_fkey" FOREIGN KEY (idpole_site) REFERENCES sav."POLE_SITE" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."UTILISATEUR" ADD CONSTRAINT "UTILISATEUR_IDTYPE_LOGIN_fkey" FOREIGN KEY (idtype_login) REFERENCES sav."TYPE_LOGIN" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."UTILISATEUR" ADD CONSTRAINT "UTILISATEUR_IDTYPE_UTILISATEUR_fkey" FOREIGN KEY (idtype_utilisateur) REFERENCES sav."TYPE_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_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."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_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."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."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."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_TYPE_fkey" FOREIGN KEY (idequipement_type) REFERENCES sav."EQUIPEMENT_TYPE" (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_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_IDTRANCHE_EQUIPEMENT_fkey" FOREIGN KEY (idtranche_equipement) REFERENCES sav."EQUIPEMENT_TRANCHE" (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_IDINSTALLATEUR_fkey" FOREIGN KEY (idinstallateur) REFERENCES sav."INSTALLATEUR" (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_IDROBINET_REMPLISSAGE_fkey" FOREIGN KEY (idrobinet_remplissage) REFERENCES sav."ROBINET_REMPLISSAGE" (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."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."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."ATTACHEMENT_PROFIL" ADD CONSTRAINT "ATTACHEMENT_PROFIL_IDUTILISATEUR_PROFIL_fkey" FOREIGN KEY (idutilisateur_profil) REFERENCES sav."UTILISATEUR_PROFIL" (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."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."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_IDEQUIPEMENT_fkey" FOREIGN KEY (idequipement) REFERENCES sav."EQUIPEMENT" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."INTERVENTION" ADD CONSTRAINT "INTERVENTION_IDTYPE_VALIDATION_ADM_fkey" FOREIGN KEY (idtype_validation_adm) REFERENCES sav."INTERVENTION_TYPE_VALIDATION" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."INTERVENTION" ADD CONSTRAINT "INTERVENTION_IDTYPE_VALIDATION_TECHNIQUE_fkey" FOREIGN KEY (idtype_validation_technique) REFERENCES sav."INTERVENTION_TYPE_VALIDATION" (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_IDTYPE_VISITE_INIT_fkey" FOREIGN KEY (idtype_visite_init) REFERENCES sav."TYPE_VISITE" (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_IDTYPE_ENVOI_RAPPORT_fkey" FOREIGN KEY (idtype_envoi_rapport) REFERENCES sav."TYPE_ENVOI" (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."CONTRAT" ADD CONSTRAINT "CONTRAT_IDAGENT_SOUSCRIPTION_fkey" FOREIGN KEY (idagent_souscription) REFERENCES sav."UTILISATEUR" (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_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."FACTURE" ADD CONSTRAINT "FACTURE_IDDEVIS_fkey" FOREIGN KEY (iddevis) REFERENCES sav."DEVIS" (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_PROPOSITION" ADD CONSTRAINT "CONTRAT_PROPOSITION_IDCONTRAT_fkey" FOREIGN KEY (idcontrat) REFERENCES sav."CONTRAT" (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."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."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."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."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."DEVIS" ADD CONSTRAINT "DEVIS_IDINTERVENTION_fkey" FOREIGN KEY (idintervention) REFERENCES sav."INTERVENTION" (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."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_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."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('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."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."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_LIGNE" ADD CONSTRAINT "FACTURE_LIGNE_IDFACTURE_fkey" FOREIGN KEY (idfacture) REFERENCES sav."FACTURE" (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."FACTURE_RELANCE" ADD CONSTRAINT "FACTURE_RELANCE_IDFACTURE_fkey" FOREIGN KEY (idfacture) REFERENCES sav."FACTURE" (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_IDSOUSCRIPTEUR_fkey" FOREIGN KEY (idsouscripteur) 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_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_IDAGENT_fkey" FOREIGN KEY (idagent) REFERENCES sav."UTILISATEUR" (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."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."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_IDMOMENT_PASSAGE_fkey" FOREIGN KEY (idmoment_passage) REFERENCES sav."MOMENT_PASSAGE" (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."PLANNING_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_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_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."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_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_IDPLANNING_fkey" FOREIGN KEY (idplanning) REFERENCES sav."PLANNING" (idplanning) 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_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_IDMOYEN_PAIEMENT_fkey" FOREIGN KEY (idmoyen_paiement) REFERENCES sav."MOYEN_PAIEMENT" (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."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."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_RETOUR" ADD CONSTRAINT "INTERVENTION_RETOUR_IDINTERVENTION_fkey" FOREIGN KEY (idintervention) REFERENCES sav."INTERVENTION" (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."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_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_IDMAG_STATUT_COMMANDE_fkey" FOREIGN KEY (idmag_statut_commande) REFERENCES sav."MAG_STATUT_COMMANDE" (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_IDTYPE_CDE_fkey" FOREIGN KEY (idtype_cde) REFERENCES sav."MAG_TYPE_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_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_IDMAG_STATUT_COMMANDE_fkey" FOREIGN KEY (idmag_statut_commande) REFERENCES sav."MAG_STATUT_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."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."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."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."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."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_TRANSIT" ADD CONSTRAINT "PLN_TRANSIT_IDUTILISATEUR_fkey" FOREIGN KEY (idutilisateur) REFERENCES sav."UTILISATEUR" (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_IDPLANNING_fkey" FOREIGN KEY (idplanning) REFERENCES sav."PLANNING" (idplanning) 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_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_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_INITIATIVE_fkey" FOREIGN KEY (idplanning_initiative) REFERENCES sav."PLANNING_INITIATIVE" (idplanning_initiative) 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_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_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_MOMENT_fkey" FOREIGN KEY (moment) REFERENCES sav."MOMENT_PASSAGE" (id) 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_INITIATIVE_DETAIL" ADD CONSTRAINT "PLANNING_INITIATIVE_DETAIL_IDPLANNING_INITIATIVE_fkey" FOREIGN KEY (idplanning_initiative) REFERENCES sav."PLANNING_INITIATIVE" (idplanning_initiative) 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_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_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_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_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_PARAMETRES" ADD CONSTRAINT "PLN_PARAMETRES_IDSITE_fkey" FOREIGN KEY (idsite) REFERENCES sav."SITE" (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."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."POLE_SITE" ADD CONSTRAINT "POLE_SITE_IDSITE_fkey" FOREIGN KEY (idsite) REFERENCES sav."SITE" (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_IDRAISON_REFUS_fkey" FOREIGN KEY (idraison_refus) REFERENCES sav."PRIVILEGE_RAISON_REFUS" (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_IDINTERVENTION_fkey" FOREIGN KEY (idintervention) REFERENCES sav."INTERVENTION" (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_PHOTO" ADD CONSTRAINT "PRODUIT_PHOTO_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_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."PRODUIT_TARIF" ADD CONSTRAINT "PRODUIT_TARIF_IDPRODUIT_fkey" FOREIGN KEY (idproduit) REFERENCES sav."PRODUIT" (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."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."STOCK_STANDARD" ADD CONSTRAINT "STOCK_STANDARD_IDSITE_fkey" FOREIGN KEY (idsite) REFERENCES sav."SITE" (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."TCHAT_GROUPE" ADD CONSTRAINT "TCHAT_GROUPE_IDTCHAT_GROUPE_TYPE_fkey" FOREIGN KEY (idtchat_groupe_type) REFERENCES sav."TCHAT_GROUPE_TYPE" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."TCHAT_GROUPE" ADD CONSTRAINT "TCHAT_GROUPE_IDUTILISATEUR_ADMIN_GROUPE_fkey" FOREIGN KEY (idutilisateur_admin_groupe) REFERENCES sav."UTILISATEUR" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."TCHAT_GROUPE" ADD CONSTRAINT "TCHAT_GROUPE_IDSITE_fkey" FOREIGN KEY (idsite) REFERENCES sav."SITE" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."TCHAT_GROUPE_UTILISATEUR" ADD CONSTRAINT "TCHAT_GROUPE_UTILISATEUR_IDTCHAT_GROUPE_fkey" FOREIGN KEY (idtchat_groupe) REFERENCES sav."TCHAT_GROUPE" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."TCHAT_GROUPE_UTILISATEUR" ADD CONSTRAINT "TCHAT_GROUPE_UTILISATEUR_IDUTILISATEUR_fkey" FOREIGN KEY (idutilisateur) REFERENCES sav."UTILISATEUR" (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_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_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."UTILISATEUR_ADRESSE" ADD CONSTRAINT "UTILISATEUR_ADRESSE_IDUTILISATEUR_fkey" FOREIGN KEY (idutilisateur) REFERENCES sav."UTILISATEUR" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_AFFECTATION" ADD CONSTRAINT "UTILISATEUR_AFFECTATION_IDMOTIF_TEMPS_PARTIEL_fkey" FOREIGN KEY (idmotif_temps_partiel) REFERENCES sav."MOTIF_TEMPS_PARTIEL" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_AFFECTATION" ADD CONSTRAINT "UTILISATEUR_AFFECTATION_IDPOLE_SITE_fkey" FOREIGN KEY (idpole_site) REFERENCES sav."POLE_SITE" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_AFFECTATION" ADD CONSTRAINT "UTILISATEUR_AFFECTATION_IDUTILISATEUR_PROFIL_fkey" FOREIGN KEY (idutilisateur_profil) REFERENCES sav."UTILISATEUR_PROFIL" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_AFFECTATION" ADD CONSTRAINT "UTILISATEUR_AFFECTATION_IDUTILISATEUR_fkey" FOREIGN KEY (idutilisateur) REFERENCES sav."UTILISATEUR" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_AFFECTATION" ADD CONSTRAINT "UTILISATEUR_AFFECTATION_IDUTILISATEUR_PLANNING_fkey" FOREIGN KEY (idutilisateur_planning) REFERENCES sav."UTILISATEUR" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_AFFECTATION" ADD CONSTRAINT "UTILISATEUR_AFFECTATION_IDUTILISATEUR_RESPONSABLE_fkey" FOREIGN KEY (idutilisateur_responsable) REFERENCES sav."UTILISATEUR" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_AFFECTATION" ADD CONSTRAINT "UTILISATEUR_AFFECTATION_IDUTILISATEUR_BINOME_fkey" FOREIGN KEY (idutilisateur_binome) REFERENCES sav."UTILISATEUR" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_EMAIL" ADD CONSTRAINT "UTILISATEUR_EMAIL_IDUTILISATEUR_fkey" FOREIGN KEY (idutilisateur) REFERENCES sav."UTILISATEUR" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_EMAIL" ADD CONSTRAINT "UTILISATEUR_EMAIL_IDTYPE_EMAIL_fkey" FOREIGN KEY (idtype_email) REFERENCES sav."TYPE_EMAIL" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_SITE" ADD CONSTRAINT "UTILISATEUR_SITE_IDSITE_fkey" FOREIGN KEY (idsite) REFERENCES sav."SITE" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_SITE" ADD CONSTRAINT "UTILISATEUR_SITE_IDUTILISATEUR_fkey" FOREIGN KEY (idutilisateur) REFERENCES sav."UTILISATEUR" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_TEL" ADD CONSTRAINT "UTILISATEUR_TEL_IDTYPE_TEL_fkey" FOREIGN KEY (idtype_tel) REFERENCES sav."TYPE_TEL" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('ALTER TABLE sav."UTILISATEUR_TEL" ADD CONSTRAINT "UTILISATEUR_TEL_IDUTILISATEUR_fkey" FOREIGN KEY (idutilisateur) REFERENCES sav."UTILISATEUR" (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
        $this->addSql('DROP TABLE sav.ATTACHEMENT_PROFIL');
        $this->addSql('DROP TABLE sav.POLE_SITE');
        $this->addSql('DROP TABLE sav.TYPE_EMAIL');
        $this->addSql('DROP TABLE sav.TYPE_LOGIN');
        $this->addSql('DROP TABLE "sav"."TYPE_TEL"');
        $this->addSql('DROP TABLE sav.TYPE_UTILISATEUR');
        $this->addSql('DROP TABLE UTILISATEUR');
        $this->addSql('DROP TABLE utilisateur_site');
        $this->addSql('DROP TABLE sav.UTILISATEUR_ADRESSE');
        $this->addSql('DROP TABLE sav.UTILISATEUR_AFFECTATION');
        $this->addSql('DROP TABLE sav.UTILISATEUR_EMAIL');
        $this->addSql('DROP TABLE sav.UTILISATEUR_FILTRE');
        $this->addSql('DROP TABLE sav.UTILISATEUR_PROFIL');
        $this->addSql('DROP TABLE sav.UTILISATEUR_TEL');
        $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 email');
        $this->addSql('DROP TABLE equipement');
        $this->addSql('DROP TABLE famille');
        $this->addSql('DROP TABLE group_right');
        $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 "right"');
        $this->addSql('DROP TABLE role');
        $this->addSql('DROP TABLE site');
        $this->addSql('DROP TABLE taux_tva');
        $this->addSql('DROP TABLE tchat_groupe');
        $this->addSql('DROP TABLE tchat_groupe_type');
        $this->addSql('DROP TABLE tchat_groupe_utilisateur');
        $this->addSql('DROP TABLE tchat_message');
        $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');
    }
}