An error occurred while loading the file. Please try again.
-
Guillaume Perréal authored755db0a5
<?php/* * Base de Données des Observatoires en Hydrologie * Copyright (C) 2012-2019 IRSTEA * Copyright (C) 2020-2021 INRAE * * This program is free software: you can redistribute it and/or modify it under * the terms of the GNU Affero General Public License as published by the * Free Software Foundation, either version 3 of the License, or (at your option) * any later version. * * This program is distributed in the hope that it will be useful, but WITHOUT * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or * FITNESS FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License * for more details. * * You should have received a copy of the GNU Affero General Public License * along with this program. If not, see <https://www.gnu.org/licenses/>. */namespace Irstea\Bdoh\Migrations;use Doctrine\DBAL\Migrations\AbstractMigration;use Doctrine\DBAL\Schema\Schema;/** * @SuppressWarnings(PHPMD.UnusedFormalParameter) * @SuppressWarnings(PHPMD.ShortMethodName) */class Version20161214090416 extends AbstractMigration{ /** * @param Schema $schema */ public function up(Schema $schema) { $this->addSql('CREATE SEQUENCE observatoire_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE doi_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE partenaire_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE siteexperimental_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE station_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE chronique_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE tauxremplissage_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE commune_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE typeparametre_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE unite_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE mesure_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE pointjaugeage_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE pointcontrole_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE echantillonnage_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE transformation_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE bareme_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE baremejeubareme_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE jeubareme_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE plage_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE qualite_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE jeuqualite_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE qualitejeuqualite_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE bassin_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE courseau_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE pasechantillonnage_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE optionechantillonnageSortie_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 utilisateur_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE besoin_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE categorie_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE typetravaux_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE objectifrecherche_id_seq INCREMENT BY 1 MINVALUE 1 START 1'); $this->addSql('CREATE SEQUENCE historique_id_seq INCREMENT BY 1 MINVALUE 1 START 1');7172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140
$this->addSql('CREATE TABLE observatoire (id INT NOT NULL, jeu_id INT DEFAULT NULL, nom VARCHAR(255) NOT NULL, slug VARCHAR(255) NOT NULL, conditionsUtilisation VARCHAR(255) DEFAULT NULL, description TEXT DEFAULT NULL, descriptionEn TEXT DEFAULT NULL, lien VARCHAR(255) DEFAULT NULL, couleurPrimaire VARCHAR(255) DEFAULT NULL, couleurSecondaire VARCHAR(255) DEFAULT NULL, pathPhotoPrincipale VARCHAR(255) DEFAULT NULL, pathPhotoSecondaire VARCHAR(255) DEFAULT NULL, pathLogo VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX UNIQ_90B54B326C6E55B5 ON observatoire (nom)');
$this->addSql('CREATE UNIQUE INDEX UNIQ_90B54B32989D9B62 ON observatoire (slug)');
$this->addSql('CREATE INDEX IDX_90B54B328C9E392E ON observatoire (jeu_id)');
$this->addSql('CREATE TABLE observatoires_partenaires_scientifiques (observatoire_id INT NOT NULL, partenaire_id INT NOT NULL, PRIMARY KEY(observatoire_id, partenaire_id))');
$this->addSql('CREATE INDEX IDX_5C80B31D61ED1B0D ON observatoires_partenaires_scientifiques (observatoire_id)');
$this->addSql('CREATE INDEX IDX_5C80B31D98DE13AC ON observatoires_partenaires_scientifiques (partenaire_id)');
$this->addSql('CREATE TABLE observatoires_partenaires_institutionnels (observatoire_id INT NOT NULL, partenaire_id INT NOT NULL, PRIMARY KEY(observatoire_id, partenaire_id))');
$this->addSql('CREATE INDEX IDX_DDFC381E61ED1B0D ON observatoires_partenaires_institutionnels (observatoire_id)');
$this->addSql('CREATE INDEX IDX_DDFC381E98DE13AC ON observatoires_partenaires_institutionnels (partenaire_id)');
$this->addSql('CREATE TABLE doi (id INT NOT NULL, observatoire_id INT DEFAULT NULL, identifiant VARCHAR(255) NOT NULL, description VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_5ED9529A61ED1B0D ON doi (observatoire_id)');
$this->addSql('CREATE TABLE partenaire (id INT NOT NULL, nom VARCHAR(255) NOT NULL, lien VARCHAR(255) DEFAULT NULL, pathLogo VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX UNIQ_7DA2A0A36C6E55B5 ON partenaire (nom)');
$this->addSql('CREATE TABLE siteexperimental (id INT NOT NULL, observatoire_id INT DEFAULT NULL, nom VARCHAR(255) NOT NULL, slug VARCHAR(255) NOT NULL, description TEXT DEFAULT NULL, descriptionEn TEXT DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX UNIQ_70E54E326C6E55B5 ON siteexperimental (nom)');
$this->addSql('CREATE UNIQUE INDEX UNIQ_70E54E32989D9B62 ON siteexperimental (slug)');
$this->addSql('CREATE INDEX IDX_70E54E3261ED1B0D ON siteexperimental (observatoire_id)');
$this->addSql('CREATE TABLE station (id INT NOT NULL, commune_id INT DEFAULT NULL, nom VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, altitude DOUBLE PRECISION DEFAULT NULL, estActive BOOLEAN NOT NULL, codeAlternatif VARCHAR(255) DEFAULT NULL, commentaire VARCHAR(4000) DEFAULT NULL, point geometry DEFAULT NULL, latitude DOUBLE PRECISION DEFAULT NULL, longitude DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX UNIQ_5084C12D6C6E55B5 ON station (nom)');
$this->addSql('CREATE UNIQUE INDEX UNIQ_5084C12D77153098 ON station (code)');
$this->addSql('CREATE INDEX IDX_5084C12D131A4F72 ON station (commune_id)');
$this->addSql('COMMENT ON COLUMN station.point IS \'(DC2type:geometry)\'');
$this->addSql('CREATE TABLE stations_sites (station_id INT NOT NULL, site_id INT NOT NULL, PRIMARY KEY(station_id, site_id))');
$this->addSql('CREATE INDEX IDX_F1C706F121BDB235 ON stations_sites (station_id)');
$this->addSql('CREATE INDEX IDX_F1C706F1F6BD1646 ON stations_sites (site_id)');
$this->addSql('CREATE TABLE chronique (id INT NOT NULL, unite_id INT DEFAULT NULL, producteur_id INT DEFAULT NULL, parametre_id INT DEFAULT NULL, station_id INT DEFAULT NULL, echantillonnage_id INT DEFAULT NULL, code VARCHAR(255) NOT NULL, libelle VARCHAR(255) NOT NULL, libelleEn VARCHAR(255) DEFAULT NULL, genealogie VARCHAR(4000) DEFAULT NULL, estVisible BOOLEAN NOT NULL, minimumValide DOUBLE PRECISION DEFAULT NULL, maximumValide DOUBLE PRECISION DEFAULT NULL, dateDebutmesures TIMESTAMP(3) WITHOUT TIME ZONE DEFAULT NULL, dateFinmesures TIMESTAMP(3) WITHOUT TIME ZONE DEFAULT NULL, nbmesures INT DEFAULT NULL, echantillonageSet BOOLEAN DEFAULT NULL, allowValueLimits BOOLEAN DEFAULT NULL, dtype VARCHAR(255) NOT NULL, directionmesure VARCHAR(255) DEFAULT NULL, uniteCumul_id INT DEFAULT NULL, facteurMultiplicatif DOUBLE PRECISION DEFAULT NULL, miseAJour DATE DEFAULT NULL, premiereEntree_id INT DEFAULT NULL, secondeEntree_id INT DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_DAC28749EC4A74AB ON chronique (unite_id)');
$this->addSql('CREATE INDEX IDX_DAC28749AB9BB300 ON chronique (producteur_id)');
$this->addSql('CREATE INDEX IDX_DAC287496358FF62 ON chronique (parametre_id)');
$this->addSql('CREATE INDEX IDX_DAC2874921BDB235 ON chronique (station_id)');
$this->addSql('CREATE INDEX IDX_DAC28749C573B65 ON chronique (echantillonnage_id)');
$this->addSql('CREATE INDEX IDX_DAC28749DFE96297 ON chronique (uniteCumul_id)');
$this->addSql('CREATE INDEX IDX_DAC28749DC970D1B ON chronique (premiereEntree_id)');
$this->addSql('CREATE INDEX IDX_DAC287496FB0C8CA ON chronique (secondeEntree_id)');
$this->addSql('COMMENT ON COLUMN chronique.dateDebutmesures IS \'(DC2type:datetimems)\'');
$this->addSql('COMMENT ON COLUMN chronique.dateFinmesures IS \'(DC2type:datetimems)\'');
$this->addSql('CREATE TABLE echantillonnageSortieLicite_chronique (chronique_id INT NOT NULL, echantillonnage_id INT NOT NULL, PRIMARY KEY(chronique_id, echantillonnage_id))');
$this->addSql('CREATE INDEX IDX_C02D212B93054D ON echantillonnageSortieLicite_chronique (chronique_id)');
$this->addSql('CREATE INDEX IDX_C02D212BC573B65 ON echantillonnageSortieLicite_chronique (echantillonnage_id)');
$this->addSql('CREATE TABLE optionechantillonnageSortie_chronique (chronique_id INT NOT NULL, optionechantillonnageSortie_id INT NOT NULL, PRIMARY KEY(chronique_id, optionechantillonnageSortie_id))');
$this->addSql('CREATE INDEX IDX_C5BB869D93054D ON optionechantillonnageSortie_chronique (chronique_id)');
$this->addSql('CREATE INDEX IDX_C5BB869DA40BAC33 ON optionechantillonnageSortie_chronique (optionechantillonnageSortie_id)');
$this->addSql('CREATE TABLE tauxremplissage (id INT NOT NULL, chronique_id INT DEFAULT NULL, debut TIMESTAMP(3) WITHOUT TIME ZONE NOT NULL, fin TIMESTAMP(3) WITHOUT TIME ZONE NOT NULL, taux DOUBLE PRECISION NOT NULL, poids DOUBLE PRECISION NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_AB7DAC0893054D ON tauxremplissage (chronique_id)');
$this->addSql('COMMENT ON COLUMN tauxremplissage.debut IS \'(DC2type:datetimems)\'');
$this->addSql('COMMENT ON COLUMN tauxremplissage.fin IS \'(DC2type:datetimems)\'');
$this->addSql('CREATE TABLE commune (id INT NOT NULL, nom VARCHAR(255) NOT NULL, codePostal VARCHAR(5) DEFAULT NULL, codeInsee VARCHAR(5) DEFAULT NULL, latitude DOUBLE PRECISION DEFAULT NULL, longitude DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE typeparametre (id INT NOT NULL, nom VARCHAR(255) NOT NULL, nomEn VARCHAR(255) NOT NULL, code VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX UNIQ_7E773B8B6C6E55B5 ON typeparametre (nom)');
$this->addSql('CREATE UNIQUE INDEX UNIQ_7E773B8BE46E7608 ON typeparametre (nomEn)');
$this->addSql('CREATE TABLE parametres_unites (parametre_id INT NOT NULL, unite_id INT NOT NULL, PRIMARY KEY(parametre_id, unite_id))');
$this->addSql('CREATE INDEX IDX_9818AAAF6358FF62 ON parametres_unites (parametre_id)');
$this->addSql('CREATE INDEX IDX_9818AAAFEC4A74AB ON parametres_unites (unite_id)');
$this->addSql('CREATE TABLE unite (id INT NOT NULL, libelle VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX UNIQ_DCA5EE1CA4D60759 ON unite (libelle)');
$this->addSql('CREATE TABLE mesure (id BIGINT NOT NULL, qualite_id INT DEFAULT NULL, chronique_id INT DEFAULT NULL, date TIMESTAMP(3) WITHOUT TIME ZONE NOT NULL, valeur DOUBLE PRECISION DEFAULT NULL, minimum DOUBLE PRECISION DEFAULT NULL, maximum DOUBLE PRECISION DEFAULT NULL, estCalculee BOOLEAN NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_58B76B46A6338570 ON mesure (qualite_id)');
$this->addSql('CREATE INDEX IDX_58B76B4693054D ON mesure (chronique_id)');
$this->addSql('CREATE UNIQUE INDEX idx_mesure_chronique_date ON mesure (chronique_id, date)');
$this->addSql('COMMENT ON COLUMN mesure.date IS \'(DC2type:datetimems)\'');
$this->addSql('CREATE TABLE pointjaugeage (id INT NOT NULL, bareme_id INT DEFAULT NULL, date TIMESTAMP(3) WITHOUT TIME ZONE NOT NULL, valeurparametreEntree DOUBLE PRECISION NOT NULL, valeurparametreSortie DOUBLE PRECISION NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_A228ECE75F49EAAD ON pointjaugeage (bareme_id)');
$this->addSql('COMMENT ON COLUMN pointjaugeage.date IS \'(DC2type:datetimems)\'');
$this->addSql('CREATE TABLE pointcontrole (id INT NOT NULL, chronique_id INT DEFAULT NULL, qualite_id INT DEFAULT NULL, date TIMESTAMP(3) WITHOUT TIME ZONE NOT NULL, valeur DOUBLE PRECISION DEFAULT NULL, minimum DOUBLE PRECISION DEFAULT NULL, maximum DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_87AD087C93054D ON pointcontrole (chronique_id)');
$this->addSql('CREATE INDEX IDX_87AD087CA6338570 ON pointcontrole (qualite_id)');
$this->addSql('COMMENT ON COLUMN pointcontrole.date IS \'(DC2type:datetimems)\'');
$this->addSql('CREATE TABLE echantillonnage (id INT NOT NULL, code VARCHAR(255) DEFAULT NULL, nom VARCHAR(255) NOT NULL, nomEn VARCHAR(255) DEFAULT NULL, ordreSortie INT DEFAULT NULL, hasDirection BOOLEAN DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX UNIQ_A5AE44C277153098 ON echantillonnage (code)');
141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210
$this->addSql('CREATE UNIQUE INDEX UNIQ_A5AE44C26C6E55B5 ON echantillonnage (nom)');
$this->addSql('CREATE UNIQUE INDEX UNIQ_A5AE44C2E46E7608 ON echantillonnage (nomEn)');
$this->addSql('CREATE UNIQUE INDEX UNIQ_A5AE44C2E632D4D7 ON echantillonnage (ordreSortie)');
$this->addSql('CREATE TABLE transformation (id INT NOT NULL, entree_id INT DEFAULT NULL, jeubaremeActuel_id INT DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX UNIQ_3FD6625D683E0182 ON transformation (jeubaremeActuel_id)');
$this->addSql('CREATE INDEX IDX_3FD6625DAF7BD910 ON transformation (entree_id)');
$this->addSql('CREATE TABLE bareme (id INT NOT NULL, observatoire_id INT DEFAULT NULL, nom VARCHAR(255) NOT NULL, commentaire VARCHAR(4000) DEFAULT NULL, valeurs _float8 NOT NULL, dateCreation DATE NOT NULL, uniteEntree_id INT DEFAULT NULL, uniteSortie_id INT DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_35A1B5D84C2F85C0 ON bareme (uniteEntree_id)');
$this->addSql('CREATE INDEX IDX_35A1B5D82F268583 ON bareme (uniteSortie_id)');
$this->addSql('CREATE INDEX IDX_35A1B5D861ED1B0D ON bareme (observatoire_id)');
$this->addSql('COMMENT ON COLUMN bareme.valeurs IS \'(DC2type:bareme)\'');
$this->addSql('CREATE TABLE baremejeubareme (id INT NOT NULL, bareme_id INT DEFAULT NULL, debutValidite DATE DEFAULT NULL, finValidite DATE DEFAULT NULL, jeubareme_id INT DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_8B2FAD395F49EAAD ON baremejeubareme (bareme_id)');
$this->addSql('CREATE INDEX IDX_8B2FAD39B3E24A00 ON baremejeubareme (jeubareme_id)');
$this->addSql('CREATE TABLE jeubareme (id INT NOT NULL, transformation_id INT DEFAULT NULL, dateCreation TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL, delaiPropagation DOUBLE PRECISION DEFAULT NULL, valueLimittransformationtype VARCHAR(255) DEFAULT NULL, valueLimitPlaceholder DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_F8DD81F14FD34D2 ON jeubareme (transformation_id)');
$this->addSql('CREATE TABLE plage (id INT NOT NULL, qualite_id INT DEFAULT NULL, chronique_id INT DEFAULT NULL, debut TIMESTAMP(3) WITHOUT TIME ZONE NOT NULL, fin TIMESTAMP(3) WITHOUT TIME ZONE NOT NULL, valeur DOUBLE PRECISION DEFAULT NULL, minimum DOUBLE PRECISION DEFAULT NULL, maximum DOUBLE PRECISION DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_D1B0B9CDA6338570 ON plage (qualite_id)');
$this->addSql('CREATE INDEX IDX_D1B0B9CD93054D ON plage (chronique_id)');
$this->addSql('COMMENT ON COLUMN plage.debut IS \'(DC2type:datetimems)\'');
$this->addSql('COMMENT ON COLUMN plage.fin IS \'(DC2type:datetimems)\'');
$this->addSql('CREATE TABLE qualite (id INT NOT NULL, jeu_id INT DEFAULT NULL, code VARCHAR(255) NOT NULL, libelle VARCHAR(255) DEFAULT NULL, libelleEn VARCHAR(255) DEFAULT NULL, ordre INT DEFAULT NULL, type VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_A70E6EC38C9E392E ON qualite (jeu_id)');
$this->addSql('CREATE TABLE jeuqualite (id INT NOT NULL, nom VARCHAR(255) NOT NULL, estAffectable BOOLEAN NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX UNIQ_A23415BD6C6E55B5 ON jeuqualite (nom)');
$this->addSql('CREATE TABLE qualitejeuqualite (id INT NOT NULL, traduction_id INT DEFAULT NULL, jeu_id INT DEFAULT NULL, qualite_id INT DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_329B05FB7E0955EF ON qualitejeuqualite (traduction_id)');
$this->addSql('CREATE INDEX IDX_329B05FB8C9E392E ON qualitejeuqualite (jeu_id)');
$this->addSql('CREATE INDEX IDX_329B05FBA6338570 ON qualitejeuqualite (qualite_id)');
$this->addSql('CREATE TABLE bassin (id INT NOT NULL, observatoire_id INT DEFAULT NULL, nom VARCHAR(255) NOT NULL, aire DOUBLE PRECISION DEFAULT NULL, perimetre geometry DEFAULT NULL, stationExutoire_id INT DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX UNIQ_660811F36C6E55B5 ON bassin (nom)');
$this->addSql('CREATE INDEX IDX_660811F361ED1B0D ON bassin (observatoire_id)');
$this->addSql('CREATE INDEX IDX_660811F3166BAF05 ON bassin (stationExutoire_id)');
$this->addSql('COMMENT ON COLUMN bassin.perimetre IS \'(DC2type:geometry)\'');
$this->addSql('CREATE TABLE courseau (id INT NOT NULL, nom VARCHAR(255) NOT NULL, codeHydro VARCHAR(255) DEFAULT NULL, classification INT DEFAULT NULL, trace geometry DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('COMMENT ON COLUMN courseau.trace IS \'(DC2type:geometry)\'');
$this->addSql('CREATE TABLE courseau_observatoires (courseau_id INT NOT NULL, observatoire_id INT NOT NULL, PRIMARY KEY(courseau_id, observatoire_id))');
$this->addSql('CREATE INDEX IDX_C05B50632164871 ON courseau_observatoires (courseau_id)');
$this->addSql('CREATE INDEX IDX_C05B50661ED1B0D ON courseau_observatoires (observatoire_id)');
$this->addSql('CREATE TABLE pasechantillonnage (id INT NOT NULL, unite VARCHAR(255) NOT NULL, valeur INT NOT NULL, approxSecondes INT DEFAULT NULL, libelle VARCHAR(255) DEFAULT NULL, libelleEn VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX uniqueUnitValuePair ON pasechantillonnage (unite, valeur)');
$this->addSql('CREATE TABLE optionechantillonnageSortie (id INT NOT NULL, echantillonnageEntree_id INT DEFAULT NULL, pasechantillonnage_id INT DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_6BD7A0C6B6FF6A7E ON optionechantillonnageSortie (echantillonnageEntree_id)');
$this->addSql('CREATE INDEX IDX_6BD7A0C6CE381F92 ON optionechantillonnageSortie (pasechantillonnage_id)');
$this->addSql('CREATE UNIQUE INDEX uniqueSamplingoption ON optionechantillonnageSortie (echantillonnageEntree_id, pasechantillonnage_id)');
$this->addSql('CREATE TABLE role (id INT NOT NULL, observatoire_id INT DEFAULT NULL, utilisateur_id INT DEFAULT NULL, site_id INT DEFAULT NULL, chronique_id INT DEFAULT NULL, valeur VARCHAR(255) DEFAULT NULL, dtype VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_F75B255461ED1B0D ON role (observatoire_id)');
$this->addSql('CREATE INDEX IDX_F75B2554FB88E14F ON role (utilisateur_id)');
$this->addSql('CREATE INDEX IDX_F75B2554F6BD1646 ON role (site_id)');
$this->addSql('CREATE INDEX IDX_F75B255493054D ON role (chronique_id)');
$this->addSql('CREATE TABLE utilisateur (id INT NOT NULL, categorie_id INT DEFAULT NULL, email VARCHAR(255) NOT NULL, login VARCHAR(255) DEFAULT NULL, password VARCHAR(255) NOT NULL, salt VARCHAR(255) NOT NULL, prenom VARCHAR(255) DEFAULT NULL, nom VARCHAR(255) DEFAULT NULL, organisme VARCHAR(255) DEFAULT NULL, telephone VARCHAR(255) DEFAULT NULL, adresse VARCHAR(255) DEFAULT NULL, finAcces DATE DEFAULT NULL, derniereConnection DATE DEFAULT NULL, confirmationToken VARCHAR(255) DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_9B80EC64BCF5E72D ON utilisateur (categorie_id)');
$this->addSql('CREATE TABLE besoin (id INT NOT NULL, utilisateur_id INT DEFAULT NULL, objectif_id INT DEFAULT NULL, type_id INT DEFAULT NULL, observatoire_id INT DEFAULT NULL, duree VARCHAR(255) DEFAULT NULL, details VARCHAR(1023) DEFAULT NULL, traite BOOLEAN DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_86B4ED27FB88E14F ON besoin (utilisateur_id)');
$this->addSql('CREATE INDEX IDX_86B4ED27157D1AD4 ON besoin (objectif_id)');
$this->addSql('CREATE INDEX IDX_86B4ED27C54C8C93 ON besoin (type_id)');
$this->addSql('CREATE INDEX IDX_86B4ED2761ED1B0D ON besoin (observatoire_id)');
$this->addSql('CREATE TABLE besoins_parametres (besoin_id INT NOT NULL, parametre_id INT NOT NULL, PRIMARY KEY(besoin_id, parametre_id))');
$this->addSql('CREATE INDEX IDX_75A89B03FE6EED44 ON besoins_parametres (besoin_id)');
$this->addSql('CREATE INDEX IDX_75A89B036358FF62 ON besoins_parametres (parametre_id)');
$this->addSql('CREATE TABLE besoins_stations (besoin_id INT NOT NULL, station_id INT NOT NULL, PRIMARY KEY(besoin_id, station_id))');
$this->addSql('CREATE INDEX IDX_59777037FE6EED44 ON besoins_stations (besoin_id)');
$this->addSql('CREATE INDEX IDX_5977703721BDB235 ON besoins_stations (station_id)');
$this->addSql('CREATE TABLE categorie (id INT NOT NULL, libelle VARCHAR(255) NOT NULL, libelleEn VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX UNIQ_CB8C5497A4D60759 ON categorie (libelle)');
$this->addSql('CREATE UNIQUE INDEX UNIQ_CB8C549793C03288 ON categorie (libelleEn)');
$this->addSql('CREATE TABLE typetravaux (id INT NOT NULL, libelle VARCHAR(255) NOT NULL, libelleEn VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX UNIQ_FFE1C96BA4D60759 ON typetravaux (libelle)');
$this->addSql('CREATE UNIQUE INDEX UNIQ_FFE1C96B93C03288 ON typetravaux (libelleEn)');
$this->addSql('CREATE TABLE objectifrecherche (id INT NOT NULL, libelle VARCHAR(255) NOT NULL, libelleEn VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280
$this->addSql('CREATE UNIQUE INDEX UNIQ_724F8B13A4D60759 ON objectifrecherche (libelle)');
$this->addSql('CREATE UNIQUE INDEX UNIQ_724F8B1393C03288 ON objectifrecherche (libelleEn)');
$this->addSql('CREATE TABLE historique (id INT NOT NULL, auteur_id INT DEFAULT NULL, observatoire_id INT DEFAULT NULL, utilisateur_id INT DEFAULT NULL, bareme_id INT DEFAULT NULL, commune_id INT DEFAULT NULL, unite_id INT DEFAULT NULL, station_id INT DEFAULT NULL, chronique_id INT DEFAULT NULL, doi_id INT DEFAULT NULL, partenaire_id INT DEFAULT NULL, date DATE DEFAULT NULL, description TEXT NOT NULL, lien VARCHAR(255) DEFAULT NULL, dtype VARCHAR(255) NOT NULL, action VARCHAR(255) DEFAULT NULL, observatoireCible_id INT DEFAULT NULL, typeparametre_id INT DEFAULT NULL, siteexperimental_id INT DEFAULT NULL, debut TIMESTAMP(3) WITHOUT TIME ZONE DEFAULT NULL, fin TIMESTAMP(3) WITHOUT TIME ZONE DEFAULT NULL, nombremesures INT DEFAULT NULL, formatExport VARCHAR(255) DEFAULT NULL, formatImport VARCHAR(255) DEFAULT NULL, fuseau VARCHAR(255) DEFAULT NULL, name VARCHAR(255) DEFAULT NULL, inputUnit VARCHAR(255) DEFAULT NULL, outputUnit VARCHAR(255) DEFAULT NULL, minAbscissa DOUBLE PRECISION DEFAULT NULL, maxAbscissa DOUBLE PRECISION DEFAULT NULL, nValues INT DEFAULT NULL, dateCreation DATE DEFAULT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_A2E2D63C60BB6FE6 ON historique (auteur_id)');
$this->addSql('CREATE INDEX IDX_A2E2D63C61ED1B0D ON historique (observatoire_id)');
$this->addSql('CREATE INDEX IDX_A2E2D63CFB88E14F ON historique (utilisateur_id)');
$this->addSql('CREATE INDEX IDX_A2E2D63C5F49EAAD ON historique (bareme_id)');
$this->addSql('CREATE INDEX IDX_A2E2D63C131A4F72 ON historique (commune_id)');
$this->addSql('CREATE INDEX IDX_A2E2D63C5001BC01 ON historique (observatoireCible_id)');
$this->addSql('CREATE INDEX IDX_A2E2D63C6ECD41F5 ON historique (typeparametre_id)');
$this->addSql('CREATE INDEX IDX_A2E2D63CEC4A74AB ON historique (unite_id)');
$this->addSql('CREATE INDEX IDX_A2E2D63C21BDB235 ON historique (station_id)');
$this->addSql('CREATE INDEX IDX_A2E2D63CD9B0F6D6 ON historique (siteExperimental_id)');
$this->addSql('CREATE INDEX IDX_A2E2D63C93054D ON historique (chronique_id)');
$this->addSql('CREATE INDEX IDX_A2E2D63CE6EBA8D8 ON historique (doi_id)');
$this->addSql('CREATE INDEX IDX_A2E2D63C98DE13AC ON historique (partenaire_id)');
$this->addSql('COMMENT ON COLUMN historique.debut IS \'(DC2type:datetimems)\'');
$this->addSql('COMMENT ON COLUMN historique.fin IS \'(DC2type:datetimems)\'');
$this->addSql('ALTER TABLE observatoire ADD CONSTRAINT FK_90B54B328C9E392E FOREIGN KEY (jeu_id) REFERENCES jeuqualite (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE observatoires_partenaires_scientifiques ADD CONSTRAINT FK_5C80B31D61ED1B0D FOREIGN KEY (observatoire_id) REFERENCES observatoire (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE observatoires_partenaires_scientifiques ADD CONSTRAINT FK_5C80B31D98DE13AC FOREIGN KEY (partenaire_id) REFERENCES partenaire (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE observatoires_partenaires_institutionnels ADD CONSTRAINT FK_DDFC381E61ED1B0D FOREIGN KEY (observatoire_id) REFERENCES observatoire (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE observatoires_partenaires_institutionnels ADD CONSTRAINT FK_DDFC381E98DE13AC FOREIGN KEY (partenaire_id) REFERENCES partenaire (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE doi ADD CONSTRAINT FK_5ED9529A61ED1B0D FOREIGN KEY (observatoire_id) REFERENCES observatoire (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE siteexperimental ADD CONSTRAINT FK_70E54E3261ED1B0D FOREIGN KEY (observatoire_id) REFERENCES observatoire (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE station ADD CONSTRAINT FK_5084C12D131A4F72 FOREIGN KEY (commune_id) REFERENCES commune (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE stations_sites ADD CONSTRAINT FK_F1C706F121BDB235 FOREIGN KEY (station_id) REFERENCES station (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE stations_sites ADD CONSTRAINT FK_F1C706F1F6BD1646 FOREIGN KEY (site_id) REFERENCES siteexperimental (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE chronique ADD CONSTRAINT FK_DAC28749EC4A74AB FOREIGN KEY (unite_id) REFERENCES unite (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE chronique ADD CONSTRAINT FK_DAC28749AB9BB300 FOREIGN KEY (producteur_id) REFERENCES partenaire (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE chronique ADD CONSTRAINT FK_DAC287496358FF62 FOREIGN KEY (parametre_id) REFERENCES typeparametre (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE chronique ADD CONSTRAINT FK_DAC2874921BDB235 FOREIGN KEY (station_id) REFERENCES station (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE chronique ADD CONSTRAINT FK_DAC28749C573B65 FOREIGN KEY (echantillonnage_id) REFERENCES echantillonnage (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE chronique ADD CONSTRAINT FK_DAC28749DFE96297 FOREIGN KEY (uniteCumul_id) REFERENCES unite (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE chronique ADD CONSTRAINT FK_DAC28749DC970D1B FOREIGN KEY (premiereEntree_id) REFERENCES transformation (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE chronique ADD CONSTRAINT FK_DAC287496FB0C8CA FOREIGN KEY (secondeEntree_id) REFERENCES transformation (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE echantillonnageSortieLicite_chronique ADD CONSTRAINT FK_C02D212B93054D FOREIGN KEY (chronique_id) REFERENCES chronique (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE echantillonnageSortieLicite_chronique ADD CONSTRAINT FK_C02D212BC573B65 FOREIGN KEY (echantillonnage_id) REFERENCES echantillonnage (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE optionechantillonnageSortie_chronique ADD CONSTRAINT FK_C5BB869D93054D FOREIGN KEY (chronique_id) REFERENCES chronique (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE optionechantillonnageSortie_chronique ADD CONSTRAINT FK_C5BB869DA40BAC33 FOREIGN KEY (optionechantillonnageSortie_id) REFERENCES optionechantillonnageSortie (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE tauxremplissage ADD CONSTRAINT FK_AB7DAC0893054D FOREIGN KEY (chronique_id) REFERENCES chronique (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE parametres_unites ADD CONSTRAINT FK_9818AAAF6358FF62 FOREIGN KEY (parametre_id) REFERENCES typeparametre (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE parametres_unites ADD CONSTRAINT FK_9818AAAFEC4A74AB FOREIGN KEY (unite_id) REFERENCES unite (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE mesure ADD CONSTRAINT FK_58B76B46A6338570 FOREIGN KEY (qualite_id) REFERENCES qualite (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE mesure ADD CONSTRAINT FK_58B76B4693054D FOREIGN KEY (chronique_id) REFERENCES chronique (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE pointjaugeage ADD CONSTRAINT FK_A228ECE75F49EAAD FOREIGN KEY (bareme_id) REFERENCES bareme (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE pointcontrole ADD CONSTRAINT FK_87AD087C93054D FOREIGN KEY (chronique_id) REFERENCES chronique (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE pointcontrole ADD CONSTRAINT FK_87AD087CA6338570 FOREIGN KEY (qualite_id) REFERENCES qualite (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE transformation ADD CONSTRAINT FK_3FD6625D683E0182 FOREIGN KEY (jeubaremeActuel_id) REFERENCES jeubareme (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE transformation ADD CONSTRAINT FK_3FD6625DAF7BD910 FOREIGN KEY (entree_id) REFERENCES chronique (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE bareme ADD CONSTRAINT FK_35A1B5D84C2F85C0 FOREIGN KEY (uniteEntree_id) REFERENCES unite (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE bareme ADD CONSTRAINT FK_35A1B5D82F268583 FOREIGN KEY (uniteSortie_id) REFERENCES unite (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE bareme ADD CONSTRAINT FK_35A1B5D861ED1B0D FOREIGN KEY (observatoire_id) REFERENCES observatoire (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE baremejeubareme ADD CONSTRAINT FK_8B2FAD395F49EAAD FOREIGN KEY (bareme_id) REFERENCES bareme (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE baremejeubareme ADD CONSTRAINT FK_8B2FAD39B3E24A00 FOREIGN KEY (jeubareme_id) REFERENCES jeubareme (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE jeubareme ADD CONSTRAINT FK_F8DD81F14FD34D2 FOREIGN KEY (transformation_id) REFERENCES transformation (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE plage ADD CONSTRAINT FK_D1B0B9CDA6338570 FOREIGN KEY (qualite_id) REFERENCES qualite (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE plage ADD CONSTRAINT FK_D1B0B9CD93054D FOREIGN KEY (chronique_id) REFERENCES chronique (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE qualite ADD CONSTRAINT FK_A70E6EC38C9E392E FOREIGN KEY (jeu_id) REFERENCES jeuqualite (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE qualitejeuqualite ADD CONSTRAINT FK_329B05FB7E0955EF FOREIGN KEY (traduction_id) REFERENCES qualite (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE qualitejeuqualite ADD CONSTRAINT FK_329B05FB8C9E392E FOREIGN KEY (jeu_id) REFERENCES jeuqualite (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE qualitejeuqualite ADD CONSTRAINT FK_329B05FBA6338570 FOREIGN KEY (qualite_id) REFERENCES qualite (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE bassin ADD CONSTRAINT FK_660811F361ED1B0D FOREIGN KEY (observatoire_id) REFERENCES observatoire (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE bassin ADD CONSTRAINT FK_660811F3166BAF05 FOREIGN KEY (stationExutoire_id) REFERENCES station (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE courseau_observatoires ADD CONSTRAINT FK_C05B50632164871 FOREIGN KEY (courseau_id) REFERENCES courseau (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE courseau_observatoires ADD CONSTRAINT FK_C05B50661ED1B0D FOREIGN KEY (observatoire_id) REFERENCES observatoire (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE optionechantillonnageSortie ADD CONSTRAINT FK_6BD7A0C6B6FF6A7E FOREIGN KEY (echantillonnageEntree_id) REFERENCES echantillonnage (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE optionechantillonnageSortie ADD CONSTRAINT FK_6BD7A0C6CE381F92 FOREIGN KEY (pasechantillonnage_id) REFERENCES pasechantillonnage (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE role ADD CONSTRAINT FK_F75B255461ED1B0D FOREIGN KEY (observatoire_id) REFERENCES observatoire (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE role ADD CONSTRAINT FK_F75B2554FB88E14F FOREIGN KEY (utilisateur_id) REFERENCES utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350
$this->addSql('ALTER TABLE role ADD CONSTRAINT FK_F75B2554F6BD1646 FOREIGN KEY (site_id) REFERENCES siteexperimental (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE role ADD CONSTRAINT FK_F75B255493054D FOREIGN KEY (chronique_id) REFERENCES chronique (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE utilisateur ADD CONSTRAINT FK_9B80EC64BCF5E72D FOREIGN KEY (categorie_id) REFERENCES categorie (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE besoin ADD CONSTRAINT FK_86B4ED27FB88E14F FOREIGN KEY (utilisateur_id) REFERENCES utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE besoin ADD CONSTRAINT FK_86B4ED27157D1AD4 FOREIGN KEY (objectif_id) REFERENCES objectifrecherche (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE besoin ADD CONSTRAINT FK_86B4ED27C54C8C93 FOREIGN KEY (type_id) REFERENCES typetravaux (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE besoin ADD CONSTRAINT FK_86B4ED2761ED1B0D FOREIGN KEY (observatoire_id) REFERENCES observatoire (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE besoins_parametres ADD CONSTRAINT FK_75A89B03FE6EED44 FOREIGN KEY (besoin_id) REFERENCES besoin (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE besoins_parametres ADD CONSTRAINT FK_75A89B036358FF62 FOREIGN KEY (parametre_id) REFERENCES typeparametre (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE besoins_stations ADD CONSTRAINT FK_59777037FE6EED44 FOREIGN KEY (besoin_id) REFERENCES besoin (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE besoins_stations ADD CONSTRAINT FK_5977703721BDB235 FOREIGN KEY (station_id) REFERENCES station (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE historique ADD CONSTRAINT FK_A2E2D63C60BB6FE6 FOREIGN KEY (auteur_id) REFERENCES utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE historique ADD CONSTRAINT FK_A2E2D63C61ED1B0D FOREIGN KEY (observatoire_id) REFERENCES observatoire (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE historique ADD CONSTRAINT FK_A2E2D63CFB88E14F FOREIGN KEY (utilisateur_id) REFERENCES utilisateur (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE historique ADD CONSTRAINT FK_A2E2D63C5F49EAAD FOREIGN KEY (bareme_id) REFERENCES bareme (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE historique ADD CONSTRAINT FK_A2E2D63C131A4F72 FOREIGN KEY (commune_id) REFERENCES commune (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE historique ADD CONSTRAINT FK_A2E2D63C5001BC01 FOREIGN KEY (observatoireCible_id) REFERENCES observatoire (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE historique ADD CONSTRAINT FK_A2E2D63C6ECD41F5 FOREIGN KEY (typeparametre_id) REFERENCES typeparametre (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE historique ADD CONSTRAINT FK_A2E2D63CEC4A74AB FOREIGN KEY (unite_id) REFERENCES unite (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE historique ADD CONSTRAINT FK_A2E2D63C21BDB235 FOREIGN KEY (station_id) REFERENCES station (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE historique ADD CONSTRAINT FK_A2E2D63CD9B0F6D6 FOREIGN KEY (siteExperimental_id) REFERENCES siteexperimental (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE historique ADD CONSTRAINT FK_A2E2D63C93054D FOREIGN KEY (chronique_id) REFERENCES chronique (id) ON DELETE SET NULL NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE historique ADD CONSTRAINT FK_A2E2D63CE6EBA8D8 FOREIGN KEY (doi_id) REFERENCES doi (id) ON DELETE SET NULL NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE historique ADD CONSTRAINT FK_A2E2D63C98DE13AC FOREIGN KEY (partenaire_id) REFERENCES partenaire (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
}
/**
* @param Schema $schema
*/
public function down(Schema $schema)
{
$this->addSql('ALTER TABLE observatoires_partenaires_scientifiques DROP CONSTRAINT FK_5C80B31D61ED1B0D');
$this->addSql('ALTER TABLE observatoires_partenaires_institutionnels DROP CONSTRAINT FK_DDFC381E61ED1B0D');
$this->addSql('ALTER TABLE doi DROP CONSTRAINT FK_5ED9529A61ED1B0D');
$this->addSql('ALTER TABLE siteexperimental DROP CONSTRAINT FK_70E54E3261ED1B0D');
$this->addSql('ALTER TABLE bareme DROP CONSTRAINT FK_35A1B5D861ED1B0D');
$this->addSql('ALTER TABLE bassin DROP CONSTRAINT FK_660811F361ED1B0D');
$this->addSql('ALTER TABLE courseau_observatoires DROP CONSTRAINT FK_C05B50661ED1B0D');
$this->addSql('ALTER TABLE role DROP CONSTRAINT FK_F75B255461ED1B0D');
$this->addSql('ALTER TABLE besoin DROP CONSTRAINT FK_86B4ED2761ED1B0D');
$this->addSql('ALTER TABLE historique DROP CONSTRAINT FK_A2E2D63C61ED1B0D');
$this->addSql('ALTER TABLE historique DROP CONSTRAINT FK_A2E2D63C5001BC01');
$this->addSql('ALTER TABLE historique DROP CONSTRAINT FK_A2E2D63CE6EBA8D8');
$this->addSql('ALTER TABLE observatoires_partenaires_scientifiques DROP CONSTRAINT FK_5C80B31D98DE13AC');
$this->addSql('ALTER TABLE observatoires_partenaires_institutionnels DROP CONSTRAINT FK_DDFC381E98DE13AC');
$this->addSql('ALTER TABLE chronique DROP CONSTRAINT FK_DAC28749AB9BB300');
$this->addSql('ALTER TABLE historique DROP CONSTRAINT FK_A2E2D63C98DE13AC');
$this->addSql('ALTER TABLE stations_sites DROP CONSTRAINT FK_F1C706F1F6BD1646');
$this->addSql('ALTER TABLE role DROP CONSTRAINT FK_F75B2554F6BD1646');
$this->addSql('ALTER TABLE historique DROP CONSTRAINT FK_A2E2D63CD9B0F6D6');
$this->addSql('ALTER TABLE stations_sites DROP CONSTRAINT FK_F1C706F121BDB235');
$this->addSql('ALTER TABLE chronique DROP CONSTRAINT FK_DAC2874921BDB235');
$this->addSql('ALTER TABLE bassin DROP CONSTRAINT FK_660811F3166BAF05');
$this->addSql('ALTER TABLE besoins_stations DROP CONSTRAINT FK_5977703721BDB235');
$this->addSql('ALTER TABLE historique DROP CONSTRAINT FK_A2E2D63C21BDB235');
$this->addSql('ALTER TABLE echantillonnageSortieLicite_chronique DROP CONSTRAINT FK_C02D212B93054D');
$this->addSql('ALTER TABLE optionechantillonnageSortie_chronique DROP CONSTRAINT FK_C5BB869D93054D');
$this->addSql('ALTER TABLE tauxremplissage DROP CONSTRAINT FK_AB7DAC0893054D');
$this->addSql('ALTER TABLE mesure DROP CONSTRAINT FK_58B76B4693054D');
$this->addSql('ALTER TABLE pointcontrole DROP CONSTRAINT FK_87AD087C93054D');
$this->addSql('ALTER TABLE transformation DROP CONSTRAINT FK_3FD6625DAF7BD910');
$this->addSql('ALTER TABLE plage DROP CONSTRAINT FK_D1B0B9CD93054D');
$this->addSql('ALTER TABLE role DROP CONSTRAINT FK_F75B255493054D');
$this->addSql('ALTER TABLE historique DROP CONSTRAINT FK_A2E2D63C93054D');
$this->addSql('ALTER TABLE station DROP CONSTRAINT FK_5084C12D131A4F72');
$this->addSql('ALTER TABLE historique DROP CONSTRAINT FK_A2E2D63C131A4F72');
$this->addSql('ALTER TABLE chronique DROP CONSTRAINT FK_DAC287496358FF62');
$this->addSql('ALTER TABLE parametres_unites DROP CONSTRAINT FK_9818AAAF6358FF62');
$this->addSql('ALTER TABLE besoins_parametres DROP CONSTRAINT FK_75A89B036358FF62');
$this->addSql('ALTER TABLE historique DROP CONSTRAINT FK_A2E2D63C6ECD41F5');
351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420
$this->addSql('ALTER TABLE chronique DROP CONSTRAINT FK_DAC28749EC4A74AB');
$this->addSql('ALTER TABLE chronique DROP CONSTRAINT FK_DAC28749DFE96297');
$this->addSql('ALTER TABLE parametres_unites DROP CONSTRAINT FK_9818AAAFEC4A74AB');
$this->addSql('ALTER TABLE bareme DROP CONSTRAINT FK_35A1B5D84C2F85C0');
$this->addSql('ALTER TABLE bareme DROP CONSTRAINT FK_35A1B5D82F268583');
$this->addSql('ALTER TABLE historique DROP CONSTRAINT FK_A2E2D63CEC4A74AB');
$this->addSql('ALTER TABLE chronique DROP CONSTRAINT FK_DAC28749C573B65');
$this->addSql('ALTER TABLE echantillonnageSortieLicite_chronique DROP CONSTRAINT FK_C02D212BC573B65');
$this->addSql('ALTER TABLE optionechantillonnageSortie DROP CONSTRAINT FK_6BD7A0C6B6FF6A7E');
$this->addSql('ALTER TABLE chronique DROP CONSTRAINT FK_DAC28749DC970D1B');
$this->addSql('ALTER TABLE chronique DROP CONSTRAINT FK_DAC287496FB0C8CA');
$this->addSql('ALTER TABLE jeubareme DROP CONSTRAINT FK_F8DD81F14FD34D2');
$this->addSql('ALTER TABLE pointjaugeage DROP CONSTRAINT FK_A228ECE75F49EAAD');
$this->addSql('ALTER TABLE baremejeubareme DROP CONSTRAINT FK_8B2FAD395F49EAAD');
$this->addSql('ALTER TABLE historique DROP CONSTRAINT FK_A2E2D63C5F49EAAD');
$this->addSql('ALTER TABLE transformation DROP CONSTRAINT FK_3FD6625D683E0182');
$this->addSql('ALTER TABLE baremejeubareme DROP CONSTRAINT FK_8B2FAD39B3E24A00');
$this->addSql('ALTER TABLE mesure DROP CONSTRAINT FK_58B76B46A6338570');
$this->addSql('ALTER TABLE pointcontrole DROP CONSTRAINT FK_87AD087CA6338570');
$this->addSql('ALTER TABLE plage DROP CONSTRAINT FK_D1B0B9CDA6338570');
$this->addSql('ALTER TABLE qualitejeuqualite DROP CONSTRAINT FK_329B05FB7E0955EF');
$this->addSql('ALTER TABLE qualitejeuqualite DROP CONSTRAINT FK_329B05FBA6338570');
$this->addSql('ALTER TABLE observatoire DROP CONSTRAINT FK_90B54B328C9E392E');
$this->addSql('ALTER TABLE qualite DROP CONSTRAINT FK_A70E6EC38C9E392E');
$this->addSql('ALTER TABLE qualitejeuqualite DROP CONSTRAINT FK_329B05FB8C9E392E');
$this->addSql('ALTER TABLE courseau_observatoires DROP CONSTRAINT FK_C05B50632164871');
$this->addSql('ALTER TABLE optionechantillonnageSortie DROP CONSTRAINT FK_6BD7A0C6CE381F92');
$this->addSql('ALTER TABLE optionechantillonnageSortie_chronique DROP CONSTRAINT FK_C5BB869DA40BAC33');
$this->addSql('ALTER TABLE role DROP CONSTRAINT FK_F75B2554FB88E14F');
$this->addSql('ALTER TABLE besoin DROP CONSTRAINT FK_86B4ED27FB88E14F');
$this->addSql('ALTER TABLE historique DROP CONSTRAINT FK_A2E2D63C60BB6FE6');
$this->addSql('ALTER TABLE historique DROP CONSTRAINT FK_A2E2D63CFB88E14F');
$this->addSql('ALTER TABLE besoins_parametres DROP CONSTRAINT FK_75A89B03FE6EED44');
$this->addSql('ALTER TABLE besoins_stations DROP CONSTRAINT FK_59777037FE6EED44');
$this->addSql('ALTER TABLE utilisateur DROP CONSTRAINT FK_9B80EC64BCF5E72D');
$this->addSql('ALTER TABLE besoin DROP CONSTRAINT FK_86B4ED27C54C8C93');
$this->addSql('ALTER TABLE besoin DROP CONSTRAINT FK_86B4ED27157D1AD4');
$this->addSql('DROP SEQUENCE observatoire_id_seq CASCADE');
$this->addSql('DROP SEQUENCE doi_id_seq CASCADE');
$this->addSql('DROP SEQUENCE partenaire_id_seq CASCADE');
$this->addSql('DROP SEQUENCE siteexperimental_id_seq CASCADE');
$this->addSql('DROP SEQUENCE station_id_seq CASCADE');
$this->addSql('DROP SEQUENCE chronique_id_seq CASCADE');
$this->addSql('DROP SEQUENCE tauxremplissage_id_seq CASCADE');
$this->addSql('DROP SEQUENCE commune_id_seq CASCADE');
$this->addSql('DROP SEQUENCE typeparametre_id_seq CASCADE');
$this->addSql('DROP SEQUENCE unite_id_seq CASCADE');
$this->addSql('DROP SEQUENCE mesure_id_seq CASCADE');
$this->addSql('DROP SEQUENCE pointjaugeage_id_seq CASCADE');
$this->addSql('DROP SEQUENCE pointcontrole_id_seq CASCADE');
$this->addSql('DROP SEQUENCE echantillonnage_id_seq CASCADE');
$this->addSql('DROP SEQUENCE transformation_id_seq CASCADE');
$this->addSql('DROP SEQUENCE bareme_id_seq CASCADE');
$this->addSql('DROP SEQUENCE baremejeubareme_id_seq CASCADE');
$this->addSql('DROP SEQUENCE jeubareme_id_seq CASCADE');
$this->addSql('DROP SEQUENCE plage_id_seq CASCADE');
$this->addSql('DROP SEQUENCE qualite_id_seq CASCADE');
$this->addSql('DROP SEQUENCE jeuqualite_id_seq CASCADE');
$this->addSql('DROP SEQUENCE qualitejeuqualite_id_seq CASCADE');
$this->addSql('DROP SEQUENCE bassin_id_seq CASCADE');
$this->addSql('DROP SEQUENCE courseau_id_seq CASCADE');
$this->addSql('DROP SEQUENCE pasechantillonnage_id_seq CASCADE');
$this->addSql('DROP SEQUENCE optionechantillonnageSortie_id_seq CASCADE');
$this->addSql('DROP SEQUENCE role_id_seq CASCADE');
$this->addSql('DROP SEQUENCE utilisateur_id_seq CASCADE');
$this->addSql('DROP SEQUENCE besoin_id_seq CASCADE');
$this->addSql('DROP SEQUENCE categorie_id_seq CASCADE');
$this->addSql('DROP SEQUENCE typetravaux_id_seq CASCADE');
$this->addSql('DROP SEQUENCE objectifrecherche_id_seq CASCADE');
$this->addSql('DROP SEQUENCE historique_id_seq CASCADE');
421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465
$this->addSql('DROP TABLE observatoire');
$this->addSql('DROP TABLE observatoires_partenaires_scientifiques');
$this->addSql('DROP TABLE observatoires_partenaires_institutionnels');
$this->addSql('DROP TABLE doi');
$this->addSql('DROP TABLE partenaire');
$this->addSql('DROP TABLE siteexperimental');
$this->addSql('DROP TABLE station');
$this->addSql('DROP TABLE stations_sites');
$this->addSql('DROP TABLE chronique');
$this->addSql('DROP TABLE echantillonnageSortieLicite_chronique');
$this->addSql('DROP TABLE optionechantillonnageSortie_chronique');
$this->addSql('DROP TABLE tauxremplissage');
$this->addSql('DROP TABLE commune');
$this->addSql('DROP TABLE typeparametre');
$this->addSql('DROP TABLE parametres_unites');
$this->addSql('DROP TABLE unite');
$this->addSql('DROP TABLE mesure');
$this->addSql('DROP TABLE pointjaugeage');
$this->addSql('DROP TABLE pointcontrole');
$this->addSql('DROP TABLE echantillonnage');
$this->addSql('DROP TABLE transformation');
$this->addSql('DROP TABLE bareme');
$this->addSql('DROP TABLE baremejeubareme');
$this->addSql('DROP TABLE jeubareme');
$this->addSql('DROP TABLE plage');
$this->addSql('DROP TABLE qualite');
$this->addSql('DROP TABLE jeuqualite');
$this->addSql('DROP TABLE qualitejeuqualite');
$this->addSql('DROP TABLE bassin');
$this->addSql('DROP TABLE courseau');
$this->addSql('DROP TABLE courseau_observatoires');
$this->addSql('DROP TABLE pasechantillonnage');
$this->addSql('DROP TABLE optionechantillonnageSortie');
$this->addSql('DROP TABLE role');
$this->addSql('DROP TABLE utilisateur');
$this->addSql('DROP TABLE besoin');
$this->addSql('DROP TABLE besoins_parametres');
$this->addSql('DROP TABLE besoins_stations');
$this->addSql('DROP TABLE categorie');
$this->addSql('DROP TABLE typetravaux');
$this->addSql('DROP TABLE objectifrecherche');
$this->addSql('DROP TABLE historique');
}
}