<?php

declare(strict_types=1);

namespace App\Application\Migrations;

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

/**
 * Auto-generated Migration: Please modify to your needs!
 */
final class Version20220613085327 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 export_media DROP FOREIGN KEY FK_5DD22BCA4BBC2705');
        $this->addSql('ALTER TABLE export_value DROP FOREIGN KEY FK_2A89D2F24BBC2705');
        $this->addSql('ALTER TABLE versionexport_groupproject DROP FOREIGN KEY FK_8AD2C7DD26F7B6EA');
        $this->addSql('CREATE TABLE page_duplicate (id INT AUTO_INCREMENT NOT NULL, page_id INT NOT NULL, version_id INT DEFAULT NULL, id_products LONGTEXT DEFAULT NULL, name LONGTEXT DEFAULT NULL, folio INT NOT NULL, current_place LONGTEXT DEFAULT NULL, updatedAt DATETIME DEFAULT NULL, createdAt DATETIME DEFAULT NULL, deletedAt DATETIME DEFAULT NULL, INDEX IDX_29A93ED4C4663E4 (page_id), INDEX IDX_29A93ED44BBC2705 (version_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE version_export (id INT AUTO_INCREMENT NOT NULL, export_id INT NOT NULL, name VARCHAR(255) NOT NULL, archived TINYINT(1) NOT NULL, id_user INT NOT NULL, id_owner_group INT DEFAULT NULL, created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, INDEX IDX_32E13ECF64CDAF82 (export_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('ALTER TABLE page_duplicate ADD CONSTRAINT FK_29A93ED4C4663E4 FOREIGN KEY (page_id) REFERENCES page (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE page_duplicate ADD CONSTRAINT FK_29A93ED44BBC2705 FOREIGN KEY (version_id) REFERENCES version_export (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE version_export ADD CONSTRAINT FK_32E13ECF64CDAF82 FOREIGN KEY (export_id) REFERENCES export (id)');
        $this->addSql('DROP TABLE VersionExport');
        $this->addSql('ALTER TABLE export_media ADD pageDuplicate_id INT DEFAULT NULL');
        $this->addSql('ALTER TABLE export_media ADD CONSTRAINT FK_5DD22BCAED22C3FE FOREIGN KEY (pageDuplicate_id) REFERENCES page_duplicate (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE export_media ADD CONSTRAINT FK_5DD22BCA4BBC2705 FOREIGN KEY (version_id) REFERENCES version_export (id) ON DELETE CASCADE');
        $this->addSql('CREATE INDEX IDX_5DD22BCAED22C3FE ON export_media (pageDuplicate_id)');
        $this->addSql('ALTER TABLE export_template_option ADD pageDuplicate_id INT DEFAULT NULL');
        $this->addSql('ALTER TABLE export_template_option ADD CONSTRAINT FK_509160D1ED22C3FE FOREIGN KEY (pageDuplicate_id) REFERENCES page_duplicate (id) ON DELETE CASCADE');
        $this->addSql('CREATE INDEX IDX_509160D1ED22C3FE ON export_template_option (pageDuplicate_id)');
        $this->addSql('ALTER TABLE export_value DROP FOREIGN KEY FK_2A89D2F264CDAF82');
        $this->addSql('DROP INDEX IDX_2A89D2F264CDAF82 ON export_value');
        $this->addSql('ALTER TABLE export_value ADD pageDuplicate_id INT DEFAULT NULL, CHANGE export_id export_value INT DEFAULT NULL');
        $this->addSql('ALTER TABLE export_value ADD CONSTRAINT FK_2A89D2F22A89D2F2 FOREIGN KEY (export_value) REFERENCES export (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE export_value ADD CONSTRAINT FK_2A89D2F2ED22C3FE FOREIGN KEY (pageDuplicate_id) REFERENCES page_duplicate (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE export_value ADD CONSTRAINT FK_2A89D2F24BBC2705 FOREIGN KEY (version_id) REFERENCES version_export (id) ON DELETE CASCADE');
        $this->addSql('CREATE INDEX IDX_2A89D2F22A89D2F2 ON export_value (export_value)');
        $this->addSql('CREATE INDEX IDX_2A89D2F2ED22C3FE ON export_value (pageDuplicate_id)');
        $this->addSql('ALTER TABLE generation_file_data ADD page_duplicate_id INT DEFAULT NULL');
        $this->addSql('ALTER TABLE generation_file_data ADD CONSTRAINT FK_E6E5436620E58C4 FOREIGN KEY (page_duplicate_id) REFERENCES page_duplicate (id) ON DELETE CASCADE');
        $this->addSql('CREATE INDEX IDX_E6E5436620E58C4 ON generation_file_data (page_duplicate_id)');
        $this->addSql('ALTER TABLE project ADD id_user INT NOT NULL, ADD id_owner_group INT DEFAULT NULL');
        $this->addSql('ALTER TABLE versionexport_groupproject ADD CONSTRAINT FK_8AD2C7DD26F7B6EA FOREIGN KEY (versionexport_id) REFERENCES version_export (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 export_media DROP FOREIGN KEY FK_5DD22BCAED22C3FE');
        $this->addSql('ALTER TABLE export_template_option DROP FOREIGN KEY FK_509160D1ED22C3FE');
        $this->addSql('ALTER TABLE export_value DROP FOREIGN KEY FK_2A89D2F2ED22C3FE');
        $this->addSql('ALTER TABLE generation_file_data DROP FOREIGN KEY FK_E6E5436620E58C4');
        $this->addSql('ALTER TABLE export_media DROP FOREIGN KEY FK_5DD22BCA4BBC2705');
        $this->addSql('ALTER TABLE export_value DROP FOREIGN KEY FK_2A89D2F24BBC2705');
        $this->addSql('ALTER TABLE page_duplicate DROP FOREIGN KEY FK_29A93ED44BBC2705');
        $this->addSql('ALTER TABLE versionexport_groupproject DROP FOREIGN KEY FK_8AD2C7DD26F7B6EA');
        $this->addSql('CREATE TABLE VersionExport (id INT AUTO_INCREMENT NOT NULL, export_id INT NOT NULL, name VARCHAR(255) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, deletedAt DATETIME DEFAULT NULL, archived TINYINT(1) NOT NULL, INDEX IDX_7BBA60CE64CDAF82 (export_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE `utf8_unicode_ci` ENGINE = InnoDB COMMENT = \'\' ');
        $this->addSql('ALTER TABLE VersionExport ADD CONSTRAINT FK_7BBA60CE64CDAF82 FOREIGN KEY (export_id) REFERENCES export (id) ON UPDATE NO ACTION ON DELETE NO ACTION');
        $this->addSql('DROP TABLE page_duplicate');
        $this->addSql('DROP TABLE version_export');
        $this->addSql('ALTER TABLE export_media DROP FOREIGN KEY FK_5DD22BCA4BBC2705');
        $this->addSql('DROP INDEX IDX_5DD22BCAED22C3FE ON export_media');
        $this->addSql('ALTER TABLE export_media DROP pageDuplicate_id');
        $this->addSql('ALTER TABLE export_media ADD CONSTRAINT FK_5DD22BCA4BBC2705 FOREIGN KEY (version_id) REFERENCES VersionExport (id) ON UPDATE NO ACTION ON DELETE CASCADE');
        $this->addSql('DROP INDEX IDX_509160D1ED22C3FE ON export_template_option');
        $this->addSql('ALTER TABLE export_template_option DROP pageDuplicate_id');
        $this->addSql('ALTER TABLE export_value DROP FOREIGN KEY FK_2A89D2F22A89D2F2');
        $this->addSql('ALTER TABLE export_value DROP FOREIGN KEY FK_2A89D2F24BBC2705');
        $this->addSql('DROP INDEX IDX_2A89D2F22A89D2F2 ON export_value');
        $this->addSql('DROP INDEX IDX_2A89D2F2ED22C3FE ON export_value');
        $this->addSql('ALTER TABLE export_value ADD export_id INT DEFAULT NULL, DROP export_value, DROP pageDuplicate_id');
        $this->addSql('ALTER TABLE export_value ADD CONSTRAINT FK_2A89D2F264CDAF82 FOREIGN KEY (export_id) REFERENCES export (id) ON UPDATE NO ACTION ON DELETE CASCADE');
        $this->addSql('ALTER TABLE export_value ADD CONSTRAINT FK_2A89D2F24BBC2705 FOREIGN KEY (version_id) REFERENCES VersionExport (id) ON UPDATE NO ACTION ON DELETE CASCADE');
        $this->addSql('CREATE INDEX IDX_2A89D2F264CDAF82 ON export_value (export_id)');
        $this->addSql('DROP INDEX IDX_E6E5436620E58C4 ON generation_file_data');
        $this->addSql('ALTER TABLE generation_file_data DROP page_duplicate_id');
        $this->addSql('ALTER TABLE project DROP id_user, DROP id_owner_group');
        $this->addSql('ALTER TABLE versionexport_groupproject DROP FOREIGN KEY FK_8AD2C7DD26F7B6EA');
        $this->addSql('ALTER TABLE versionexport_groupproject ADD CONSTRAINT FK_8AD2C7DD26F7B6EA FOREIGN KEY (versionexport_id) REFERENCES VersionExport (id) ON UPDATE NO ACTION ON DELETE CASCADE');
    }
}