<?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 Version20230118160009 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 TABLE display_condition (id INT AUTO_INCREMENT NOT NULL, voting_id INT NOT NULL, INDEX IDX_61676F294254ACF8 (voting_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE display_condition_answer (display_condition_id INT NOT NULL, answer_id INT NOT NULL, INDEX IDX_28E1575D606E3BAD (display_condition_id), INDEX IDX_28E1575DAA334807 (answer_id), PRIMARY KEY(display_condition_id, answer_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('CREATE TABLE display_condition_voting (display_condition_id INT NOT NULL, voting_id INT NOT NULL, INDEX IDX_E14C72D606E3BAD (display_condition_id), INDEX IDX_E14C72D4254ACF8 (voting_id), PRIMARY KEY(display_condition_id, voting_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
$this->addSql('ALTER TABLE display_condition ADD CONSTRAINT FK_61676F294254ACF8 FOREIGN KEY (voting_id) REFERENCES voting (id)');
$this->addSql('ALTER TABLE display_condition_answer ADD CONSTRAINT FK_28E1575D606E3BAD FOREIGN KEY (display_condition_id) REFERENCES display_condition (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE display_condition_answer ADD CONSTRAINT FK_28E1575DAA334807 FOREIGN KEY (answer_id) REFERENCES answer (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE display_condition_voting ADD CONSTRAINT FK_E14C72D606E3BAD FOREIGN KEY (display_condition_id) REFERENCES display_condition (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE display_condition_voting ADD CONSTRAINT FK_E14C72D4254ACF8 FOREIGN KEY (voting_id) REFERENCES voting (id) ON DELETE CASCADE');
$this->addSql('ALTER TABLE voting ADD display_condition_id INT DEFAULT NULL');
$this->addSql('ALTER TABLE voting ADD CONSTRAINT FK_FC28DA55606E3BAD FOREIGN KEY (display_condition_id) REFERENCES display_condition (id)');
$this->addSql('CREATE UNIQUE INDEX UNIQ_FC28DA55606E3BAD ON voting (display_condition_id)');
}
public function down(Schema $schema): void
{
// this down() migration is auto-generated, please modify it to your needs
$this->addSql('ALTER TABLE display_condition_answer DROP FOREIGN KEY FK_28E1575D606E3BAD');
$this->addSql('ALTER TABLE display_condition_voting DROP FOREIGN KEY FK_E14C72D606E3BAD');
$this->addSql('ALTER TABLE voting DROP FOREIGN KEY FK_FC28DA55606E3BAD');
$this->addSql('DROP TABLE display_condition');
$this->addSql('DROP TABLE display_condition_answer');
$this->addSql('DROP TABLE display_condition_voting');
$this->addSql('DROP INDEX UNIQ_FC28DA55606E3BAD ON voting');
$this->addSql('ALTER TABLE voting DROP display_condition_id');
}
}