<?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 Version20240310202612 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 division (id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', tournament_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', title VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_1017471433D1A3E7 (tournament_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE game (id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE game_score (id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', game_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', player_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', score INT DEFAULT NULL, INDEX IDX_AA4EDEE48FD905 (game_id), INDEX IDX_AA4EDE99E6F5DF (player_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE player (id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', tournament_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', division_id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', title VARCHAR(255) NOT NULL, register_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', INDEX IDX_98197A6533D1A3E7 (tournament_id), INDEX IDX_98197A6541859289 (division_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE playoff_game (id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', tournament_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', game_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', stage INT NOT NULL, INDEX IDX_E058C8A133D1A3E7 (tournament_id), UNIQUE INDEX UNIQ_E058C8A1E48FD905 (game_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE qualifying_game (id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', division_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', game_id BINARY(16) DEFAULT NULL COMMENT \'(DC2Type:uuid)\', INDEX IDX_EA15519D41859289 (division_id), UNIQUE INDEX UNIQ_EA15519DE48FD905 (game_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('CREATE TABLE tournament (id BINARY(16) NOT NULL COMMENT \'(DC2Type:uuid)\', title VARCHAR(255) NOT NULL, created_at DATETIME NOT NULL COMMENT \'(DC2Type:datetime_immutable)\', PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB');
        $this->addSql('ALTER TABLE division ADD CONSTRAINT FK_1017471433D1A3E7 FOREIGN KEY (tournament_id) REFERENCES tournament (id)');
        $this->addSql('ALTER TABLE game_score ADD CONSTRAINT FK_AA4EDEE48FD905 FOREIGN KEY (game_id) REFERENCES game (id)');
        $this->addSql('ALTER TABLE game_score ADD CONSTRAINT FK_AA4EDE99E6F5DF FOREIGN KEY (player_id) REFERENCES player (id)');
        $this->addSql('ALTER TABLE player ADD CONSTRAINT FK_98197A6533D1A3E7 FOREIGN KEY (tournament_id) REFERENCES tournament (id)');
        $this->addSql('ALTER TABLE player ADD CONSTRAINT FK_98197A6541859289 FOREIGN KEY (division_id) REFERENCES division (id)');
        $this->addSql('ALTER TABLE playoff_game ADD CONSTRAINT FK_E058C8A133D1A3E7 FOREIGN KEY (tournament_id) REFERENCES tournament (id)');
        $this->addSql('ALTER TABLE playoff_game ADD CONSTRAINT FK_E058C8A1E48FD905 FOREIGN KEY (game_id) REFERENCES game (id)');
        $this->addSql('ALTER TABLE qualifying_game ADD CONSTRAINT FK_EA15519D41859289 FOREIGN KEY (division_id) REFERENCES division (id)');
        $this->addSql('ALTER TABLE qualifying_game ADD CONSTRAINT FK_EA15519DE48FD905 FOREIGN KEY (game_id) REFERENCES game (id)');
    }

    public function down(Schema $schema): void
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->addSql('ALTER TABLE division DROP FOREIGN KEY FK_1017471433D1A3E7');
        $this->addSql('ALTER TABLE game_score DROP FOREIGN KEY FK_AA4EDEE48FD905');
        $this->addSql('ALTER TABLE game_score DROP FOREIGN KEY FK_AA4EDE99E6F5DF');
        $this->addSql('ALTER TABLE player DROP FOREIGN KEY FK_98197A6533D1A3E7');
        $this->addSql('ALTER TABLE player DROP FOREIGN KEY FK_98197A6541859289');
        $this->addSql('ALTER TABLE playoff_game DROP FOREIGN KEY FK_E058C8A133D1A3E7');
        $this->addSql('ALTER TABLE playoff_game DROP FOREIGN KEY FK_E058C8A1E48FD905');
        $this->addSql('ALTER TABLE qualifying_game DROP FOREIGN KEY FK_EA15519D41859289');
        $this->addSql('ALTER TABLE qualifying_game DROP FOREIGN KEY FK_EA15519DE48FD905');
        $this->addSql('DROP TABLE division');
        $this->addSql('DROP TABLE game');
        $this->addSql('DROP TABLE game_score');
        $this->addSql('DROP TABLE player');
        $this->addSql('DROP TABLE playoff_game');
        $this->addSql('DROP TABLE qualifying_game');
        $this->addSql('DROP TABLE tournament');
    }
}