<?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 Version20220228092223 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 common_file (id INT AUTO_INCREMENT NOT NULL, file_type_id INT NOT NULL, id_dam INT DEFAULT NULL, file_name VARCHAR(255) NOT NULL, original_name VARCHAR(255) NOT NULL, file LONGBLOB DEFAULT NULL, created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, INDEX IDX_3C072E819E2A35A8 (file_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE commonfile_template (commonfile_id INT NOT NULL, template_id INT NOT NULL, INDEX IDX_2A82084B11CE0D7A (commonfile_id), INDEX IDX_2A82084B5DA0FB8 (template_id), PRIMARY KEY(commonfile_id, template_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE dedicated_file (id INT AUTO_INCREMENT NOT NULL, template_id INT DEFAULT NULL, file_type_id INT NOT NULL, file_name VARCHAR(255) NOT NULL, original_name VARCHAR(255) NOT NULL, file LONGBLOB DEFAULT NULL, created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, archived_at DATETIME DEFAULT NULL, INDEX IDX_537AC5945DA0FB8 (template_id), INDEX IDX_537AC5949E2A35A8 (file_type_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE file_type (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, extension VARCHAR(255) NOT NULL, created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE input (id INT AUTO_INCREMENT NOT NULL, variable_id INT NOT NULL, name VARCHAR(255) NOT NULL, variable_name VARCHAR(255) NOT NULL, created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, INDEX IDX_D82832D7F3037E8E (variable_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE template (id INT AUTO_INCREMENT NOT NULL, twig_id INT NOT NULL, name VARCHAR(255) NOT NULL, regenerated_at DATETIME NOT NULL, nb_page INT NOT NULL, nb_element INT NOT NULL, suffix VARCHAR(255) DEFAULT NULL, font_path VARCHAR(255) DEFAULT NULL, created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, UNIQUE INDEX UNIQ_97601F835E237E06 (name), INDEX IDX_97601F8338BFD09B (twig_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE template_media (id INT AUTO_INCREMENT NOT NULL, template_id INT NOT NULL, name VARCHAR(255) NOT NULL, marker VARCHAR(255) NOT NULL, width DOUBLE PRECISION NOT NULL, height DOUBLE PRECISION NOT NULL, optional TINYINT(1) NOT NULL, adjustment_option INT NOT NULL, position INT NOT NULL, created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, INDEX IDX_59FA72C35DA0FB8 (template_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE template_option (id INT AUTO_INCREMENT NOT NULL, template_id INT NOT NULL, name VARCHAR(255) NOT NULL, twig_var VARCHAR(255) NOT NULL, type VARCHAR(255) NOT NULL, list_value VARCHAR(255) DEFAULT NULL, created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, INDEX IDX_516E09425DA0FB8 (template_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE twig (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(255) NOT NULL, export_type INT NOT NULL, content MEDIUMTEXT NOT NULL, created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, UNIQUE INDEX UNIQ_F34EB2175E237E06 (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE variable (id INT AUTO_INCREMENT NOT NULL, twig_id INT NOT NULL, name VARCHAR(255) NOT NULL, twig_var VARCHAR(255) NOT NULL, for_element TINYINT(1) NOT NULL, created_at DATETIME DEFAULT NULL, updated_at DATETIME DEFAULT NULL, deleted_at DATETIME DEFAULT NULL, INDEX IDX_CC4D878D38BFD09B (twig_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('ALTER TABLE common_file ADD CONSTRAINT FK_3C072E819E2A35A8 FOREIGN KEY (file_type_id) REFERENCES file_type (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE commonfile_template ADD CONSTRAINT FK_2A82084B11CE0D7A FOREIGN KEY (commonfile_id) REFERENCES common_file (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE commonfile_template ADD CONSTRAINT FK_2A82084B5DA0FB8 FOREIGN KEY (template_id) REFERENCES template (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE dedicated_file ADD CONSTRAINT FK_537AC5945DA0FB8 FOREIGN KEY (template_id) REFERENCES template (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE dedicated_file ADD CONSTRAINT FK_537AC5949E2A35A8 FOREIGN KEY (file_type_id) REFERENCES file_type (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE input ADD CONSTRAINT FK_D82832D7F3037E8E FOREIGN KEY (variable_id) REFERENCES variable (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE template ADD CONSTRAINT FK_97601F8338BFD09B FOREIGN KEY (twig_id) REFERENCES twig (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE template_media ADD CONSTRAINT FK_59FA72C35DA0FB8 FOREIGN KEY (template_id) REFERENCES template (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE template_option ADD CONSTRAINT FK_516E09425DA0FB8 FOREIGN KEY (template_id) REFERENCES template (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE variable ADD CONSTRAINT FK_CC4D878D38BFD09B FOREIGN KEY (twig_id) REFERENCES twig (id) ON DELETE CASCADE');
        $this->addSql('ALTER TABLE page_options CHANGE template template_id INT DEFAULT NULL');
    }

    public function down(Schema $schema): void
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->addSql('ALTER TABLE commonfile_template DROP FOREIGN KEY FK_2A82084B11CE0D7A');
        $this->addSql('ALTER TABLE common_file DROP FOREIGN KEY FK_3C072E819E2A35A8');
        $this->addSql('ALTER TABLE dedicated_file DROP FOREIGN KEY FK_537AC5949E2A35A8');
        $this->addSql('ALTER TABLE commonfile_template DROP FOREIGN KEY FK_2A82084B5DA0FB8');
        $this->addSql('ALTER TABLE dedicated_file DROP FOREIGN KEY FK_537AC5945DA0FB8');
        $this->addSql('ALTER TABLE template_media DROP FOREIGN KEY FK_59FA72C35DA0FB8');
        $this->addSql('ALTER TABLE template_option DROP FOREIGN KEY FK_516E09425DA0FB8');
        $this->addSql('ALTER TABLE template DROP FOREIGN KEY FK_97601F8338BFD09B');
        $this->addSql('ALTER TABLE variable DROP FOREIGN KEY FK_CC4D878D38BFD09B');
        $this->addSql('ALTER TABLE input DROP FOREIGN KEY FK_D82832D7F3037E8E');
        $this->addSql('DROP TABLE common_file');
        $this->addSql('DROP TABLE commonfile_template');
        $this->addSql('DROP TABLE dedicated_file');
        $this->addSql('DROP TABLE file_type');
        $this->addSql('DROP TABLE input');
        $this->addSql('DROP TABLE template');
        $this->addSql('DROP TABLE template_media');
        $this->addSql('DROP TABLE template_option');
        $this->addSql('DROP TABLE twig');
        $this->addSql('DROP TABLE variable');
        $this->addSql('ALTER TABLE page_options CHANGE template_id template INT DEFAULT NULL');
    }
}