<?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 Version20200924021718 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('CREATE SEQUENCE departement_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE region_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE SEQUENCE ville_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE TABLE departement (id INT NOT NULL, region_id INT NOT NULL, code VARCHAR(3) NOT NULL, nom VARCHAR(50) NOT NULL, slug VARCHAR(50) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_C1765B6398260155 ON departement (region_id)');
$this->addSql('CREATE TABLE region (id INT NOT NULL, code INT NOT NULL, nom VARCHAR(255) NOT NULL, slug VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE TABLE ville (id INT NOT NULL, departement_id INT DEFAULT NULL, code_insee VARCHAR(6) NOT NULL, nom_postal VARCHAR(255) NOT NULL, code_postal VARCHAR(6) NOT NULL, libelle_acheminement VARCHAR(255) DEFAULT NULL, ancienne_commune_lieu_dit VARCHAR(255) DEFAULT NULL, latitude DOUBLE PRECISION DEFAULT NULL, longitude DOUBLE PRECISION DEFAULT NULL, code VARCHAR(7) NOT NULL, article VARCHAR(5) DEFAULT NULL, nom VARCHAR(255) NOT NULL, nom_complet VARCHAR(255) NOT NULL, slug VARCHAR(255) NOT NULL, slug_complet VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_43C3D9C3CCF9E01E ON ville (departement_id)');
$this->addSql('ALTER TABLE departement ADD CONSTRAINT FK_C1765B6398260155 FOREIGN KEY (region_id) REFERENCES region (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE ville ADD CONSTRAINT FK_43C3D9C3CCF9E01E FOREIGN KEY (departement_id) REFERENCES departement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE dvf ADD ville_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE dvf ADD CONSTRAINT FK_6D2BA0F3A73F0036 FOREIGN KEY (ville_id) REFERENCES ville (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('CREATE INDEX IDX_6D2BA0F3A73F0036 ON dvf (ville_id)');
}
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 ville DROP CONSTRAINT FK_43C3D9C3CCF9E01E');
$this->addSql('ALTER TABLE departement DROP CONSTRAINT FK_C1765B6398260155');
$this->addSql('ALTER TABLE dvf DROP CONSTRAINT FK_6D2BA0F3A73F0036');
$this->addSql('DROP SEQUENCE departement_id_seq CASCADE');
$this->addSql('DROP SEQUENCE region_id_seq CASCADE');
$this->addSql('DROP SEQUENCE ville_id_seq CASCADE');
$this->addSql('DROP TABLE departement');
$this->addSql('DROP TABLE region');
$this->addSql('DROP TABLE ville');
$this->addSql('DROP INDEX IDX_6D2BA0F3A73F0036');
$this->addSql('ALTER TABLE dvf DROP ville_id');
}
}