<?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 Version20220930103121 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('DROP SEQUENCE IF EXISTS amenagement_interieur_en_semaine_id_seq CASCADE');
$this->addSql('DROP SEQUENCE IF EXISTS assainissement_actif_id_seq CASCADE');
$this->addSql('DROP SEQUENCE IF EXISTS assainissement_passif_id_seq CASCADE');
$this->addSql('DROP SEQUENCE IF EXISTS avancement_projet_id_seq CASCADE');
$this->addSql('DROP SEQUENCE IF EXISTS batiment_assainissement_actif_id_seq CASCADE');
$this->addSql('DROP SEQUENCE IF EXISTS batiment_assainissement_passif_id_seq CASCADE');
$this->addSql('DROP SEQUENCE IF EXISTS degats_eaux_pieces_batiment_id_seq CASCADE');
$this->addSql('DROP SEQUENCE IF EXISTS disposer_deshumidificateurs_pieces_batiment_id_seq CASCADE');
$this->addSql('DROP SEQUENCE IF EXISTS disposer_humidificateurs_pieces_batiment_id_seq CASCADE');
$this->addSql('DROP SEQUENCE IF EXISTS equipement_piece_batiment_id_seq CASCADE');
$this->addSql('DROP SEQUENCE IF EXISTS fos_user_group_id_seq CASCADE');
$this->addSql('DROP SEQUENCE IF EXISTS infiltration_eau_pieces_batiment_id_seq CASCADE');
$this->addSql('DROP SEQUENCE IF EXISTS piece_humide_id_seq CASCADE');
$this->addSql('DROP SEQUENCE IF EXISTS produit_id_seq CASCADE');
$this->addSql('DROP SEQUENCE IF EXISTS revetement_pose_en_semaine_id_seq CASCADE');
$this->addSql('DROP SEQUENCE IF EXISTS revetement_semaine_id_seq CASCADE');
$this->addSql('DROP SEQUENCE IF EXISTS semaine_prelevement_id_seq CASCADE');
$this->addSql('DROP SEQUENCE IF EXISTS traces_humidites_pieces_batiment_id_seq CASCADE');
$this->addSql('DROP SEQUENCE IF EXISTS traitement_exces_humidite_pieces_batiment_id_seq CASCADE');
$this->addSql('DROP SEQUENCE IF EXISTS travaux_effectues_en_semaine_id_seq CASCADE');
$this->addSql('DROP SEQUENCE IF EXISTS travaux_semaine_id_seq CASCADE');
$this->addSql('DROP SEQUENCE IF EXISTS typologie_batiment_id_seq CASCADE');
$this->addSql('DROP SEQUENCE IF EXISTS zone_homegene_id_seq CASCADE');
$this->addSql('DROP TABLE fos_user_group');
$this->addSql('ALTER TABLE adresse ALTER adresse_numero_rue TYPE text');
$this->addSql('ALTER TABLE adresse ALTER numero_parcelle TYPE text');
$this->addSql('ALTER TABLE adresse ALTER numero_egid TYPE text');
$this->addSql('ALTER TABLE adresse ALTER longitude TYPE text');
$this->addSql('ALTER TABLE adresse ALTER latitude TYPE text');
$this->addSql('ALTER TABLE adresse ALTER coordonnee_x TYPE text');
$this->addSql('ALTER TABLE adresse ALTER coordonnee_y TYPE text');
$this->addSql('ALTER TABLE adresse ALTER the_geom TYPE geometry');
$this->addSql('ALTER TABLE adresse ALTER lieu TYPE text');
$this->addSql('ALTER TABLE adresse ALTER lv_95_abscisse TYPE text');
$this->addSql('ALTER TABLE adresse ALTER lv_95_ordonnee TYPE text');
$this->addSql('ALTER TABLE adresse ALTER reference_coordonnees TYPE text');
$this->addSql('ALTER TABLE adresse ALTER remarque TYPE text');
$this->addSql('COMMENT ON COLUMN adresse.adresse_numero_rue IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN adresse.numero_parcelle IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN adresse.numero_egid IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN adresse.longitude IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN adresse.latitude IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN adresse.coordonnee_x IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN adresse.coordonnee_y IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN adresse.lieu IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN adresse.lv_95_abscisse IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN adresse.lv_95_ordonnee IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN adresse.reference_coordonnees IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN adresse.remarque IS \'(DC2Type:crypt)\'');
$this->addSql('ALTER TABLE batiment ALTER nom_batiment TYPE text');
$this->addSql('ALTER TABLE batiment ALTER details_autre_type_batiment TYPE text');
$this->addSql('ALTER TABLE batiment ALTER remarque TYPE text');
$this->addSql('ALTER TABLE batiment ALTER code TYPE text');
$this->addSql('ALTER TABLE batiment ALTER code_unique TYPE text');
$this->addSql('ALTER TABLE batiment ALTER typologie_precision_autre TYPE text');
$this->addSql('ALTER TABLE batiment ALTER numero_batiment TYPE text');
$this->addSql('ALTER TABLE batiment ALTER type_batiment_source TYPE text');
$this->addSql('COMMENT ON COLUMN batiment.nom_batiment IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN batiment.details_autre_type_batiment IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN batiment.remarque IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN batiment.code IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN batiment.code_unique IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN batiment.typologie_precision_autre IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN batiment.numero_batiment IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN batiment.type_batiment_source IS \'(DC2Type:crypt)\'');
$this->addSql('ALTER TABLE etablissement ALTER code TYPE text');
$this->addSql('ALTER TABLE etablissement ALTER nom TYPE text');
$this->addSql('ALTER TABLE etablissement ALTER coordonnee_x TYPE text');
$this->addSql('ALTER TABLE etablissement ALTER coordonnee_y TYPE text');
$this->addSql('ALTER TABLE etablissement ALTER type_etablissement_autre TYPE text');
$this->addSql('ALTER TABLE etablissement ALTER code_origine_source TYPE text');
$this->addSql('ALTER TABLE etablissement ALTER type_etablissement_source TYPE text');
$this->addSql('ALTER TABLE etablissement ALTER code_unique TYPE text');
$this->addSql('COMMENT ON COLUMN etablissement.code IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN etablissement.nom IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN etablissement.coordonnee_x IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN etablissement.coordonnee_y IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN etablissement.type_etablissement_autre IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN etablissement.code_origine_source IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN etablissement.type_etablissement_source IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN etablissement.code_unique IS \'(DC2Type:crypt)\'');
$this->addSql('ALTER TABLE fos_user_user DROP locked');
$this->addSql('ALTER TABLE fos_user_user DROP expired');
$this->addSql('ALTER TABLE fos_user_user DROP expires_at');
$this->addSql('ALTER TABLE fos_user_user DROP credentials_expired');
$this->addSql('ALTER TABLE fos_user_user DROP credentials_expire_at');
$this->addSql('ALTER TABLE fos_user_user DROP date_of_birth');
$this->addSql('ALTER TABLE fos_user_user DROP firstname');
$this->addSql('ALTER TABLE fos_user_user DROP lastname');
$this->addSql('ALTER TABLE fos_user_user DROP website');
$this->addSql('ALTER TABLE fos_user_user DROP biography');
$this->addSql('ALTER TABLE fos_user_user DROP gender');
$this->addSql('ALTER TABLE fos_user_user DROP locale');
$this->addSql('ALTER TABLE fos_user_user DROP timezone');
$this->addSql('ALTER TABLE fos_user_user DROP phone');
$this->addSql('ALTER TABLE fos_user_user DROP facebook_uid');
$this->addSql('ALTER TABLE fos_user_user DROP facebook_name');
$this->addSql('ALTER TABLE fos_user_user DROP facebook_data');
$this->addSql('ALTER TABLE fos_user_user DROP twitter_uid');
$this->addSql('ALTER TABLE fos_user_user DROP twitter_name');
$this->addSql('ALTER TABLE fos_user_user DROP twitter_data');
$this->addSql('ALTER TABLE fos_user_user DROP gplus_uid');
$this->addSql('ALTER TABLE fos_user_user DROP gplus_name');
$this->addSql('ALTER TABLE fos_user_user DROP gplus_data');
$this->addSql('ALTER TABLE fos_user_user DROP token');
$this->addSql('ALTER TABLE fos_user_user DROP two_step_code');
$this->addSql('ALTER TABLE fos_user_user ALTER username TYPE VARCHAR(300)');
$this->addSql('ALTER TABLE fos_user_user ALTER username_canonical TYPE VARCHAR(300)');
$this->addSql('ALTER TABLE fos_user_user ALTER email TYPE VARCHAR(300)');
$this->addSql('ALTER TABLE fos_user_user ALTER email_canonical TYPE VARCHAR(300)');
$this->addSql('ALTER TABLE fos_user_user ALTER salt DROP NOT NULL');
$this->addSql('ALTER TABLE fos_user_user ALTER confirmation_token TYPE VARCHAR(300)');
$this->addSql('CREATE UNIQUE INDEX UNIQ_C560D761C05FB297 ON fos_user_user (confirmation_token)');
$this->addSql('ALTER TABLE import ALTER batiments_impactes TYPE TEXT');
$this->addSql('ALTER TABLE import ALTER etablissements_impactes TYPE TEXT');
$this->addSql('ALTER TABLE import ALTER mesures_impactees TYPE TEXT');
$this->addSql('ALTER TABLE import ALTER points_mesures_impactes TYPE TEXT');
$this->addSql('ALTER TABLE import ALTER valeurs_mesures_impactees TYPE TEXT');
$this->addSql('COMMENT ON COLUMN import.batiments_impactes IS NULL');
$this->addSql('COMMENT ON COLUMN import.etablissements_impactes IS NULL');
$this->addSql('COMMENT ON COLUMN import.mesures_impactees IS NULL');
$this->addSql('COMMENT ON COLUMN import.points_mesures_impactes IS NULL');
$this->addSql('COMMENT ON COLUMN import.valeurs_mesures_impactees IS NULL');
$this->addSql('ALTER TABLE participant ALTER nom TYPE text');
$this->addSql('ALTER TABLE participant ALTER prenom TYPE text');
$this->addSql('ALTER TABLE participant ALTER email TYPE text');
$this->addSql('ALTER TABLE participant ALTER telephone_fixe TYPE text');
$this->addSql('ALTER TABLE participant ALTER telephone_portable TYPE text');
$this->addSql('ALTER TABLE participant ALTER adresse_numero_rue TYPE text');
$this->addSql('COMMENT ON COLUMN participant.nom IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN participant.prenom IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN participant.email IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN participant.telephone_fixe IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN participant.telephone_portable IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN participant.adresse_numero_rue IS \'(DC2Type:crypt)\'');
$this->addSql('ALTER TABLE piece_mesure ALTER code TYPE text');
$this->addSql('ALTER TABLE piece_mesure ALTER titre TYPE text');
$this->addSql('ALTER TABLE piece_mesure ALTER type_piece_autre_precision TYPE text');
$this->addSql('ALTER TABLE piece_mesure ALTER type_piece_source TYPE text');
$this->addSql('COMMENT ON COLUMN piece_mesure.code IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN piece_mesure.titre IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN piece_mesure.type_piece_autre_precision IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN piece_mesure.type_piece_source IS \'(DC2Type:crypt)\'');
$this->addSql('ALTER TABLE type_batiment ALTER code TYPE text');
$this->addSql('ALTER TABLE type_batiment ALTER titre TYPE text');
$this->addSql('ALTER TABLE type_batiment ALTER description TYPE text');
$this->addSql('COMMENT ON COLUMN type_batiment.code IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN type_batiment.titre IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN type_batiment.description IS \'(DC2Type:crypt)\'');
$this->addSql('ALTER TABLE type_piece ALTER code TYPE text');
$this->addSql('ALTER TABLE type_piece ALTER titre TYPE text');
$this->addSql('ALTER TABLE type_piece ALTER description TYPE text');
$this->addSql('COMMENT ON COLUMN type_piece.code IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN type_piece.titre IS \'(DC2Type:crypt)\'');
$this->addSql('COMMENT ON COLUMN type_piece.description IS \'(DC2Type:crypt)\'');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('CREATE SCHEMA topology');
$this->addSql('CREATE SCHEMA tiger');
$this->addSql('CREATE SCHEMA tiger_data');
$this->addSql('CREATE SCHEMA public');
$this->addSql('CREATE SEQUENCE amenagement_interieur_en_semaine_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE assainissement_actif_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE assainissement_passif_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE avancement_projet_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE batiment_assainissement_actif_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE batiment_assainissement_passif_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE degats_eaux_pieces_batiment_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE disposer_deshumidificateurs_pieces_batiment_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE disposer_humidificateurs_pieces_batiment_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE equipement_piece_batiment_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE fos_user_group_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE infiltration_eau_pieces_batiment_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE piece_humide_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE produit_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE revetement_pose_en_semaine_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE revetement_semaine_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE semaine_prelevement_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE traces_humidites_pieces_batiment_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE traitement_exces_humidite_pieces_batiment_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE travaux_effectues_en_semaine_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE travaux_semaine_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE typologie_batiment_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE zone_homegene_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE TABLE fos_user_group (id INT NOT NULL, name VARCHAR(255) NOT NULL, roles TEXT NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE UNIQUE INDEX uniq_583d1f3e5e237e06 ON fos_user_group (name)');
$this->addSql('COMMENT ON COLUMN fos_user_group.roles IS \'(DC2Type:array)\'');
$this->addSql('ALTER TABLE type_batiment ALTER code TYPE TEXT');
$this->addSql('ALTER TABLE type_batiment ALTER titre TYPE TEXT');
$this->addSql('ALTER TABLE type_batiment ALTER description TYPE TEXT');
$this->addSql('COMMENT ON COLUMN type_batiment.code IS NULL');
$this->addSql('COMMENT ON COLUMN type_batiment.titre IS NULL');
$this->addSql('COMMENT ON COLUMN type_batiment.description IS NULL');
$this->addSql('ALTER TABLE batiment ALTER code TYPE TEXT');
$this->addSql('ALTER TABLE batiment ALTER nom_batiment TYPE TEXT');
$this->addSql('ALTER TABLE batiment ALTER code_unique TYPE TEXT');
$this->addSql('ALTER TABLE batiment ALTER numero_batiment TYPE TEXT');
$this->addSql('ALTER TABLE batiment ALTER remarque TYPE TEXT');
$this->addSql('ALTER TABLE batiment ALTER typologie_precision_autre TYPE TEXT');
$this->addSql('ALTER TABLE batiment ALTER type_batiment_source TYPE TEXT');
$this->addSql('ALTER TABLE batiment ALTER details_autre_type_batiment TYPE TEXT');
$this->addSql('COMMENT ON COLUMN batiment.code IS NULL');
$this->addSql('COMMENT ON COLUMN batiment.nom_batiment IS NULL');
$this->addSql('COMMENT ON COLUMN batiment.code_unique IS NULL');
$this->addSql('COMMENT ON COLUMN batiment.numero_batiment IS NULL');
$this->addSql('COMMENT ON COLUMN batiment.remarque IS NULL');
$this->addSql('COMMENT ON COLUMN batiment.typologie_precision_autre IS NULL');
$this->addSql('COMMENT ON COLUMN batiment.type_batiment_source IS NULL');
$this->addSql('COMMENT ON COLUMN batiment.details_autre_type_batiment IS NULL');
$this->addSql('DROP INDEX UNIQ_C560D761C05FB297');
$this->addSql('ALTER TABLE fos_user_user ADD locked BOOLEAN NOT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD expired BOOLEAN NOT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD expires_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD credentials_expired BOOLEAN NOT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD credentials_expire_at TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD date_of_birth TIMESTAMP(0) WITHOUT TIME ZONE DEFAULT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD firstname VARCHAR(300) NOT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD lastname VARCHAR(300) NOT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD website VARCHAR(64) DEFAULT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD biography VARCHAR(1000) DEFAULT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD gender VARCHAR(1) DEFAULT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD locale VARCHAR(8) DEFAULT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD timezone VARCHAR(64) DEFAULT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD phone VARCHAR(64) DEFAULT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD facebook_uid VARCHAR(255) DEFAULT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD facebook_name VARCHAR(255) DEFAULT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD facebook_data TEXT DEFAULT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD twitter_uid VARCHAR(255) DEFAULT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD twitter_name VARCHAR(255) DEFAULT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD twitter_data TEXT DEFAULT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD gplus_uid VARCHAR(255) DEFAULT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD gplus_name VARCHAR(255) DEFAULT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD gplus_data TEXT DEFAULT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD token VARCHAR(255) DEFAULT NULL');
$this->addSql('ALTER TABLE fos_user_user ADD two_step_code VARCHAR(255) DEFAULT NULL');
$this->addSql('ALTER TABLE fos_user_user ALTER username TYPE VARCHAR(255)');
$this->addSql('ALTER TABLE fos_user_user ALTER username_canonical TYPE VARCHAR(255)');
$this->addSql('ALTER TABLE fos_user_user ALTER email TYPE VARCHAR(255)');
$this->addSql('ALTER TABLE fos_user_user ALTER email_canonical TYPE VARCHAR(255)');
$this->addSql('ALTER TABLE fos_user_user ALTER salt SET NOT NULL');
$this->addSql('ALTER TABLE fos_user_user ALTER confirmation_token TYPE VARCHAR(255)');
$this->addSql('COMMENT ON COLUMN fos_user_user.facebook_data IS \'(DC2Type:json)\'');
$this->addSql('COMMENT ON COLUMN fos_user_user.twitter_data IS \'(DC2Type:json)\'');
$this->addSql('COMMENT ON COLUMN fos_user_user.gplus_data IS \'(DC2Type:json)\'');
$this->addSql('ALTER TABLE import ALTER batiments_impactes TYPE TEXT');
$this->addSql('ALTER TABLE import ALTER etablissements_impactes TYPE TEXT');
$this->addSql('ALTER TABLE import ALTER mesures_impactees TYPE TEXT');
$this->addSql('ALTER TABLE import ALTER points_mesures_impactes TYPE TEXT');
$this->addSql('ALTER TABLE import ALTER valeurs_mesures_impactees TYPE TEXT');
$this->addSql('COMMENT ON COLUMN import.batiments_impactes IS \'(DC2Type:json)\'');
$this->addSql('COMMENT ON COLUMN import.etablissements_impactes IS \'(DC2Type:json)\'');
$this->addSql('COMMENT ON COLUMN import.mesures_impactees IS \'(DC2Type:json)\'');
$this->addSql('COMMENT ON COLUMN import.points_mesures_impactes IS \'(DC2Type:json)\'');
$this->addSql('COMMENT ON COLUMN import.valeurs_mesures_impactees IS \'(DC2Type:json)\'');
$this->addSql('ALTER TABLE type_piece ALTER code TYPE TEXT');
$this->addSql('ALTER TABLE type_piece ALTER titre TYPE TEXT');
$this->addSql('ALTER TABLE type_piece ALTER description TYPE TEXT');
$this->addSql('COMMENT ON COLUMN type_piece.code IS NULL');
$this->addSql('COMMENT ON COLUMN type_piece.titre IS NULL');
$this->addSql('COMMENT ON COLUMN type_piece.description IS NULL');
$this->addSql('ALTER TABLE participant ALTER nom TYPE TEXT');
$this->addSql('ALTER TABLE participant ALTER prenom TYPE TEXT');
$this->addSql('ALTER TABLE participant ALTER email TYPE TEXT');
$this->addSql('ALTER TABLE participant ALTER telephone_fixe TYPE TEXT');
$this->addSql('ALTER TABLE participant ALTER telephone_portable TYPE TEXT');
$this->addSql('ALTER TABLE participant ALTER adresse_numero_rue TYPE TEXT');
$this->addSql('COMMENT ON COLUMN participant.nom IS NULL');
$this->addSql('COMMENT ON COLUMN participant.prenom IS NULL');
$this->addSql('COMMENT ON COLUMN participant.email IS NULL');
$this->addSql('COMMENT ON COLUMN participant.telephone_fixe IS NULL');
$this->addSql('COMMENT ON COLUMN participant.telephone_portable IS NULL');
$this->addSql('COMMENT ON COLUMN participant.adresse_numero_rue IS NULL');
$this->addSql('ALTER TABLE adresse ALTER adresse_numero_rue TYPE TEXT');
$this->addSql('ALTER TABLE adresse ALTER numero_parcelle TYPE TEXT');
$this->addSql('ALTER TABLE adresse ALTER lieu TYPE TEXT');
$this->addSql('ALTER TABLE adresse ALTER numero_egid TYPE TEXT');
$this->addSql('ALTER TABLE adresse ALTER longitude TYPE TEXT');
$this->addSql('ALTER TABLE adresse ALTER latitude TYPE TEXT');
$this->addSql('ALTER TABLE adresse ALTER coordonnee_x TYPE TEXT');
$this->addSql('ALTER TABLE adresse ALTER coordonnee_y TYPE TEXT');
$this->addSql('ALTER TABLE adresse ALTER the_geom TYPE TEXT');
$this->addSql('ALTER TABLE adresse ALTER lv_95_abscisse TYPE TEXT');
$this->addSql('ALTER TABLE adresse ALTER lv_95_ordonnee TYPE TEXT');
$this->addSql('ALTER TABLE adresse ALTER reference_coordonnees TYPE TEXT');
$this->addSql('ALTER TABLE adresse ALTER remarque TYPE TEXT');
$this->addSql('COMMENT ON COLUMN adresse.adresse_numero_rue IS NULL');
$this->addSql('COMMENT ON COLUMN adresse.numero_parcelle IS NULL');
$this->addSql('COMMENT ON COLUMN adresse.lieu IS NULL');
$this->addSql('COMMENT ON COLUMN adresse.numero_egid IS NULL');
$this->addSql('COMMENT ON COLUMN adresse.longitude IS NULL');
$this->addSql('COMMENT ON COLUMN adresse.latitude IS NULL');
$this->addSql('COMMENT ON COLUMN adresse.coordonnee_x IS NULL');
$this->addSql('COMMENT ON COLUMN adresse.coordonnee_y IS NULL');
$this->addSql('COMMENT ON COLUMN adresse.lv_95_abscisse IS NULL');
$this->addSql('COMMENT ON COLUMN adresse.lv_95_ordonnee IS NULL');
$this->addSql('COMMENT ON COLUMN adresse.reference_coordonnees IS NULL');
$this->addSql('COMMENT ON COLUMN adresse.remarque IS NULL');
$this->addSql('ALTER TABLE piece_mesure ALTER code TYPE TEXT');
$this->addSql('ALTER TABLE piece_mesure ALTER titre TYPE TEXT');
$this->addSql('ALTER TABLE piece_mesure ALTER type_piece_autre_precision TYPE TEXT');
$this->addSql('ALTER TABLE piece_mesure ALTER type_piece_source TYPE TEXT');
$this->addSql('COMMENT ON COLUMN piece_mesure.code IS NULL');
$this->addSql('COMMENT ON COLUMN piece_mesure.titre IS NULL');
$this->addSql('COMMENT ON COLUMN piece_mesure.type_piece_autre_precision IS NULL');
$this->addSql('COMMENT ON COLUMN piece_mesure.type_piece_source IS NULL');
$this->addSql('ALTER TABLE etablissement ALTER code TYPE TEXT');
$this->addSql('ALTER TABLE etablissement ALTER nom TYPE TEXT');
$this->addSql('ALTER TABLE etablissement ALTER type_etablissement_autre TYPE TEXT');
$this->addSql('ALTER TABLE etablissement ALTER coordonnee_x TYPE TEXT');
$this->addSql('ALTER TABLE etablissement ALTER coordonnee_y TYPE TEXT');
$this->addSql('ALTER TABLE etablissement ALTER code_origine_source TYPE TEXT');
$this->addSql('ALTER TABLE etablissement ALTER type_etablissement_source TYPE TEXT');
$this->addSql('ALTER TABLE etablissement ALTER code_unique TYPE TEXT');
$this->addSql('COMMENT ON COLUMN etablissement.code IS NULL');
$this->addSql('COMMENT ON COLUMN etablissement.nom IS NULL');
$this->addSql('COMMENT ON COLUMN etablissement.type_etablissement_autre IS NULL');
$this->addSql('COMMENT ON COLUMN etablissement.coordonnee_x IS NULL');
$this->addSql('COMMENT ON COLUMN etablissement.coordonnee_y IS NULL');
$this->addSql('COMMENT ON COLUMN etablissement.code_origine_source IS NULL');
$this->addSql('COMMENT ON COLUMN etablissement.type_etablissement_source IS NULL');
$this->addSql('COMMENT ON COLUMN etablissement.code_unique IS NULL');
}
}