<?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 Version20250220023522 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 administrator_user CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE email email VARCHAR(180) NOT NULL, CHANGE roles roles JSON NOT NULL COMMENT \'(DC2Type:json)\', CHANGE password password VARCHAR(255) NOT NULL, CHANGE first_name first_name VARCHAR(255) NOT NULL, CHANGE last_name last_name VARCHAR(255) NOT NULL, CHANGE status status VARCHAR(255) NOT NULL, ADD PRIMARY KEY (id)');
        $this->addSql('CREATE UNIQUE INDEX UNIQ_419BAA4E7927C74 ON administrator_user (email)');
        $this->addSql('ALTER TABLE page CHANGE id id INT AUTO_INCREMENT NOT NULL, CHANGE url url VARCHAR(180) NOT NULL, CHANGE title title VARCHAR(255) NOT NULL, CHANGE text text LONGTEXT NOT NULL, CHANGE enabled enabled TINYINT(1) NOT NULL, CHANGE meta_should_index meta_should_index TINYINT(1) NOT NULL, CHANGE meta_title meta_title VARCHAR(255) NOT NULL, CHANGE meta_description meta_description TEXT NOT NULL, ADD PRIMARY KEY (id)');
        $this->addSql('CREATE UNIQUE INDEX UNIQ_140AB620F47645AE ON page (url)');
        $this->addSql('ALTER TABLE messenger_messages CHANGE id id BIGINT AUTO_INCREMENT NOT NULL, CHANGE body body LONGTEXT NOT NULL, CHANGE headers headers LONGTEXT NOT NULL, CHANGE queue_name queue_name VARCHAR(190) NOT NULL, CHANGE created_at created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', CHANGE available_at available_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', CHANGE delivered_at delivered_at DATETIME DEFAULT NULL COMMENT \'(DC2Type:datetime_immutable)\', ADD PRIMARY KEY (id)');
        $this->addSql('CREATE INDEX IDX_75EA56E0FB7336F0 ON messenger_messages (queue_name)');
        $this->addSql('CREATE INDEX IDX_75EA56E0E3BD61CE ON messenger_messages (available_at)');
        $this->addSql('CREATE INDEX IDX_75EA56E016BA31DB ON messenger_messages (delivered_at)');
    }

    public function down(Schema $schema): void
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->addSql('ALTER TABLE messenger_messages MODIFY id BIGINT NOT NULL');
        $this->addSql('DROP INDEX `primary` ON messenger_messages');
        $this->addSql('DROP INDEX IDX_75EA56E0FB7336F0 ON messenger_messages');
        $this->addSql('DROP INDEX IDX_75EA56E0E3BD61CE ON messenger_messages');
        $this->addSql('DROP INDEX IDX_75EA56E016BA31DB ON messenger_messages');
        $this->addSql('ALTER TABLE messenger_messages CHANGE id id BIGINT DEFAULT NULL, CHANGE body body LONGTEXT DEFAULT NULL, CHANGE headers headers LONGTEXT DEFAULT NULL, CHANGE queue_name queue_name VARCHAR(190) DEFAULT NULL, CHANGE created_at created_at DATETIME DEFAULT NULL, CHANGE available_at available_at DATETIME DEFAULT NULL, CHANGE delivered_at delivered_at DATETIME DEFAULT NULL');
        $this->addSql('ALTER TABLE page MODIFY id INT NOT NULL');
        $this->addSql('DROP INDEX UNIQ_140AB620F47645AE ON page');
        $this->addSql('DROP INDEX `primary` ON page');
        $this->addSql('ALTER TABLE page CHANGE id id INT DEFAULT NULL, CHANGE url url VARCHAR(180) DEFAULT NULL, CHANGE title title VARCHAR(255) DEFAULT NULL, CHANGE text text LONGTEXT DEFAULT NULL, CHANGE enabled enabled TINYINT(1) DEFAULT NULL, CHANGE meta_should_index meta_should_index TINYINT(1) DEFAULT NULL, CHANGE meta_title meta_title VARCHAR(255) DEFAULT NULL, CHANGE meta_description meta_description TEXT DEFAULT NULL');
        $this->addSql('ALTER TABLE administrator_user MODIFY id INT NOT NULL');
        $this->addSql('DROP INDEX UNIQ_419BAA4E7927C74 ON administrator_user');
        $this->addSql('DROP INDEX `primary` ON administrator_user');
        $this->addSql('ALTER TABLE administrator_user CHANGE id id INT DEFAULT NULL, CHANGE email email VARCHAR(180) DEFAULT NULL, CHANGE first_name first_name VARCHAR(255) DEFAULT NULL, CHANGE last_name last_name VARCHAR(255) DEFAULT NULL, CHANGE roles roles LONGTEXT DEFAULT NULL, CHANGE password password VARCHAR(255) DEFAULT NULL, CHANGE status status VARCHAR(255) DEFAULT NULL');
    }
}