migrations/Version20211006165251.php line 1

<?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 Version20211006165251 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('DROP INDEX IDX_category_id ON category');
        $this->addSql('ALTER TABLE question ADD quiz_round SMALLINT DEFAULT NULL');
        $this->addSql('ALTER TABLE quiz ADD quiz_round SMALLINT DEFAULT NULL');
        $this->addSql('DROP INDEX index_answer_status ON student_quiz_question');
        $this->addSql('DROP INDEX index_category_id ON student_quiz_question');
        $this->addSql('DROP INDEX index_combined ON student_quiz_question');
        $this->addSql('DROP INDEX index_id ON student_quiz_question');
        $this->addSql('DROP INDEX index_question_id ON student_quiz_question');
        $this->addSql('DROP INDEX index_question_no ON student_quiz_question');
        $this->addSql('DROP INDEX index_quiz_id ON student_quiz_question');
        $this->addSql('DROP INDEX index_student_id ON student_quiz_question');
    }

    public function down(Schema $schema): void
    {
        // this down() migration is auto-generated, please modify it to your needs
        $this->addSql('CREATE INDEX IDX_category_id ON category (id)');
        $this->addSql('ALTER TABLE question DROP quiz_round');
        $this->addSql('ALTER TABLE quiz DROP quiz_round');
        $this->addSql('CREATE INDEX index_answer_status ON student_quiz_question (answer_status)');
        $this->addSql('CREATE INDEX index_category_id ON student_quiz_question (category_id)');
        $this->addSql('CREATE INDEX index_combined ON student_quiz_question (quiz_id, question_id, category_id)');
        $this->addSql('CREATE INDEX index_id ON student_quiz_question (id)');
        $this->addSql('CREATE INDEX index_question_id ON student_quiz_question (question_id)');
        $this->addSql('CREATE INDEX index_question_no ON student_quiz_question (question_no)');
        $this->addSql('CREATE INDEX index_quiz_id ON student_quiz_question (quiz_id)');
        $this->addSql('CREATE INDEX index_student_id ON student_quiz_question (student_id)');
    }
}