<?php

declare(strict_types=1);

/*
 * This file is part of the Maestro Project.
 * Copyright (C) Compos Juliot
 */

namespace App\Application\Migrations;

use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;

/**
 * Auto-generated Migration: Please modify to your needs!
 */
final class Version20201214110856 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('ALTER TABLE cmd_transitions ADD CONSTRAINT FK_C4D27510734413DD FOREIGN KEY (cmd_id) REFERENCES command (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE cmd_transitions ADD CONSTRAINT FK_C4D27510AD25E9C4 FOREIGN KEY (transitions_id) REFERENCES workflow_transitions (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE element_type_template_configuration ADD CONSTRAINT FK_F36F6CE87AD55B18 FOREIGN KEY (elementType_id) REFERENCES project_element_type (id)');
        $this->addSql('ALTER TABLE export ADD CONSTRAINT FK_428C1694166D1F9C FOREIGN KEY (project_id) REFERENCES project (id)');
        $this->addSql('ALTER TABLE export ADD CONSTRAINT FK_428C16946B8EDD09 FOREIGN KEY (export_workflow) REFERENCES export_workflow (id)');
        $this->addSql('ALTER TABLE export_media ADD CONSTRAINT FK_5DD22BCA64CDAF82 FOREIGN KEY (export_id) REFERENCES export (id)');
        $this->addSql('ALTER TABLE export_template_configuration ADD deletedAt DATETIME DEFAULT NULL');
        $this->addSql('ALTER TABLE export_template_configuration ADD CONSTRAINT FK_3DAA462A7AD55B18 FOREIGN KEY (elementType_id) REFERENCES project_element_type (id)');
        $this->addSql('ALTER TABLE export_template_configuration ADD CONSTRAINT FK_3DAA462A64CDAF82 FOREIGN KEY (export_id) REFERENCES export (id)');
        $this->addSql('ALTER TABLE export_template_option ADD CONSTRAINT FK_509160D164CDAF82 FOREIGN KEY (export_id) REFERENCES export (id)');
        $this->addSql('ALTER TABLE export_value ADD CONSTRAINT FK_2A89D2F264CDAF82 FOREIGN KEY (export_id) REFERENCES export (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE export_workflow ADD CONSTRAINT FK_6B8EDD0964CDAF82 FOREIGN KEY (export_id) REFERENCES export (id)');
        $this->addSql('ALTER TABLE export_workflow_options ADD CONSTRAINT FK_BB7E51A0E90527D4 FOREIGN KEY (workflowProject_id) REFERENCES export_workflow (id)');
        $this->addSql('ALTER TABLE project_element_type ADD deletedAt DATETIME DEFAULT NULL');
        $this->addSql('ALTER TABLE project_element_type ADD CONSTRAINT FK_E54792B3166D1F9C FOREIGN KEY (project_id) REFERENCES project (id)');
        $this->addSql('ALTER TABLE workflow_places ADD CONSTRAINT FK_DFAAD69673F32DD8 FOREIGN KEY (configuration_id) REFERENCES workflow_configuration (id)');
        $this->addSql('ALTER TABLE workflow_transitions ADD CONSTRAINT FK_C66989BB73F32DD8 FOREIGN KEY (configuration_id) REFERENCES workflow_configuration (id)');
        $this->addSql('ALTER TABLE workflow_transitions ADD CONSTRAINT FK_C66989BB705D7DE1 FOREIGN KEY (startPlace_id) REFERENCES workflow_places (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE workflow_transitions ADD CONSTRAINT FK_C66989BB155770DB FOREIGN KEY (endPlace_id) REFERENCES workflow_places (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE transition_command ADD CONSTRAINT FK_156716228BF1A064 FOREIGN KEY (transition_id) REFERENCES workflow_transitions (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE transition_command ADD CONSTRAINT FK_1567162233E1689A FOREIGN KEY (command_id) REFERENCES command (id) ON DELETE CASCADE');
    }

    public function down(Schema $schema): void
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->addSql('ALTER TABLE cmd_transitions DROP FOREIGN KEY FK_C4D27510734413DD');
        $this->addSql('ALTER TABLE cmd_transitions DROP FOREIGN KEY FK_C4D27510AD25E9C4');
        $this->addSql('ALTER TABLE element_type_template_configuration DROP FOREIGN KEY FK_F36F6CE87AD55B18');
        $this->addSql('ALTER TABLE export DROP FOREIGN KEY FK_428C1694166D1F9C');
        $this->addSql('ALTER TABLE export DROP FOREIGN KEY FK_428C16946B8EDD09');
        $this->addSql('ALTER TABLE export_media DROP FOREIGN KEY FK_5DD22BCA64CDAF82');
        $this->addSql('ALTER TABLE export_template_configuration DROP FOREIGN KEY FK_3DAA462A7AD55B18');
        $this->addSql('ALTER TABLE export_template_configuration DROP FOREIGN KEY FK_3DAA462A64CDAF82');
        $this->addSql('ALTER TABLE export_template_configuration DROP deletedAt');
        $this->addSql('ALTER TABLE export_template_option DROP FOREIGN KEY FK_509160D164CDAF82');
        $this->addSql('ALTER TABLE export_value DROP FOREIGN KEY FK_2A89D2F264CDAF82');
        $this->addSql('ALTER TABLE export_workflow DROP FOREIGN KEY FK_6B8EDD0964CDAF82');
        $this->addSql('ALTER TABLE export_workflow_options DROP FOREIGN KEY FK_BB7E51A0E90527D4');
        $this->addSql('ALTER TABLE project_element_type DROP FOREIGN KEY FK_E54792B3166D1F9C');
        $this->addSql('ALTER TABLE project_element_type DROP deletedAt');
        $this->addSql('ALTER TABLE transition_command DROP FOREIGN KEY FK_156716228BF1A064');
        $this->addSql('ALTER TABLE transition_command DROP FOREIGN KEY FK_1567162233E1689A');
        $this->addSql('ALTER TABLE workflow_places DROP FOREIGN KEY FK_DFAAD69673F32DD8');
        $this->addSql('ALTER TABLE workflow_transitions DROP FOREIGN KEY FK_C66989BB73F32DD8');
        $this->addSql('ALTER TABLE workflow_transitions DROP FOREIGN KEY FK_C66989BB705D7DE1');
        $this->addSql('ALTER TABLE workflow_transitions DROP FOREIGN KEY FK_C66989BB155770DB');
    }
}