<?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 Version20220207145933 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 cdf (id INT AUTO_INCREMENT NOT NULL, id_export INT DEFAULT NULL, nb_page INT NOT NULL, updatedAt DATETIME DEFAULT NULL, createdAt DATETIME DEFAULT NULL, deletedAt DATETIME DEFAULT NULL, UNIQUE INDEX UNIQ_1090C6A564BBA379 (id_export), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE generation_file (id INT AUTO_INCREMENT NOT NULL, file LONGBLOB DEFAULT NULL, generationFileData_id INT NOT NULL, UNIQUE INDEX UNIQ_E06E2BA98619743B (generationFileData_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE generation_file_data (id INT AUTO_INCREMENT NOT NULL, page_options_id VARCHAR(255) NOT NULL, name VARCHAR(255) NOT NULL, type VARCHAR(255) NOT NULL, extension VARCHAR(255) NOT NULL, updatedAt DATETIME DEFAULT NULL, createdAt DATETIME DEFAULT NULL, deletedAt DATETIME DEFAULT NULL, archived_at DATETIME DEFAULT NULL, INDEX IDX_E6E54366313B346F (page_options_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE page (id INT AUTO_INCREMENT NOT NULL, cdf INT NOT NULL, page_option VARCHAR(255) NOT NULL, id_products 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_140AB6201090C6A5 (cdf), INDEX IDX_140AB6203550F6AE (page_option), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE page_options (id VARCHAR(255) NOT NULL, nb_products VARCHAR(255) NOT NULL, nb_pages VARCHAR(255) NOT NULL, template INT DEFAULT NULL, name VARCHAR(255) NOT NULL, updatedAt DATETIME DEFAULT NULL, createdAt DATETIME DEFAULT NULL, deletedAt DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('ALTER TABLE cdf ADD CONSTRAINT FK_1090C6A564BBA379 FOREIGN KEY (id_export) REFERENCES export (id)');
        $this->addSql('ALTER TABLE generation_file ADD CONSTRAINT FK_E06E2BA98619743B FOREIGN KEY (generationFileData_id) REFERENCES generation_file_data (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE generation_file_data ADD CONSTRAINT FK_E6E54366313B346F FOREIGN KEY (page_options_id) REFERENCES page_options (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE page ADD CONSTRAINT FK_140AB6201090C6A5 FOREIGN KEY (cdf) REFERENCES cdf (id)');
        $this->addSql('ALTER TABLE page ADD CONSTRAINT FK_140AB6203550F6AE FOREIGN KEY (page_option) REFERENCES page_options (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE export ADD cdf_id INT DEFAULT NULL');
        $this->addSql('ALTER TABLE export ADD CONSTRAINT FK_428C1694D45DB927 FOREIGN KEY (cdf_id) REFERENCES cdf (id)');
        $this->addSql('CREATE UNIQUE INDEX UNIQ_428C1694D45DB927 ON export (cdf_id)');
    }

    public function down(Schema $schema): void
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->addSql('ALTER TABLE export DROP FOREIGN KEY FK_428C1694D45DB927');
        $this->addSql('ALTER TABLE page DROP FOREIGN KEY FK_140AB6201090C6A5');
        $this->addSql('ALTER TABLE generation_file DROP FOREIGN KEY FK_E06E2BA98619743B');
        $this->addSql('ALTER TABLE generation_file_data DROP FOREIGN KEY FK_E6E54366313B346F');
        $this->addSql('ALTER TABLE page DROP FOREIGN KEY FK_140AB6203550F6AE');
        $this->addSql('DROP TABLE cdf');
        $this->addSql('DROP TABLE generation_file');
        $this->addSql('DROP TABLE generation_file_data');
        $this->addSql('DROP TABLE page');
        $this->addSql('DROP TABLE page_options');
        $this->addSql('DROP INDEX UNIQ_428C1694D45DB927 ON export');
        $this->addSql('ALTER TABLE export DROP cdf_id');
    }
}