<?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 Version20200925132859 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 pmc_id_seq INCREMENT BY 1 MINVALUE 1 START 1');
$this->addSql('CREATE TABLE pmc (id INT NOT NULL, dvfs_id INT NOT NULL, type VARCHAR(30) NOT NULL, prix DOUBLE PRECISION DEFAULT NULL, year VARCHAR(4) NOT NULL, discr VARCHAR(255) NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_AF58944AC916C8E9 ON pmc (dvfs_id)');
$this->addSql('CREATE TABLE pmc_departement (id INT NOT NULL, departement_id INT NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_BD8FBF5BCCF9E01E ON pmc_departement (departement_id)');
$this->addSql('CREATE TABLE pmc_ville (id INT NOT NULL, ville_id INT NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_9F23A095A73F0036 ON pmc_ville (ville_id)');
$this->addSql('CREATE TABLE pmc_voie (id INT NOT NULL, voie_id INT NOT NULL, PRIMARY KEY(id))');
$this->addSql('CREATE INDEX IDX_93087056EAAC89CF ON pmc_voie (voie_id)');
$this->addSql('ALTER TABLE pmc ADD CONSTRAINT FK_AF58944AC916C8E9 FOREIGN KEY (dvfs_id) REFERENCES dvf (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE pmc_departement ADD CONSTRAINT FK_BD8FBF5BCCF9E01E FOREIGN KEY (departement_id) REFERENCES departement (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE pmc_departement ADD CONSTRAINT FK_BD8FBF5BBF396750 FOREIGN KEY (id) REFERENCES pmc (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE pmc_ville ADD CONSTRAINT FK_9F23A095A73F0036 FOREIGN KEY (ville_id) REFERENCES ville (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE pmc_ville ADD CONSTRAINT FK_9F23A095BF396750 FOREIGN KEY (id) REFERENCES pmc (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE pmc_voie ADD CONSTRAINT FK_93087056EAAC89CF FOREIGN KEY (voie_id) REFERENCES voie (id) NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE pmc_voie ADD CONSTRAINT FK_93087056BF396750 FOREIGN KEY (id) REFERENCES pmc (id) ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE');
$this->addSql('ALTER TABLE dvf DROP CONSTRAINT fk_6d2ba0f3a73f0036');
$this->addSql('DROP INDEX idx_6d2ba0f3a73f0036');
$this->addSql('ALTER TABLE dvf DROP 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 pmc_departement DROP CONSTRAINT FK_BD8FBF5BBF396750');
$this->addSql('ALTER TABLE pmc_ville DROP CONSTRAINT FK_9F23A095BF396750');
$this->addSql('ALTER TABLE pmc_voie DROP CONSTRAINT FK_93087056BF396750');
$this->addSql('DROP SEQUENCE pmc_id_seq CASCADE');
$this->addSql('DROP TABLE pmc');
$this->addSql('DROP TABLE pmc_departement');
$this->addSql('DROP TABLE pmc_ville');
$this->addSql('DROP TABLE pmc_voie');
$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)');
}
}