migrations/Version20240606000000.php line 1

<?php

declare(strict_types=1);

namespace DoctrineMigrations;

use Doctrine\DBAL\Schema\Schema;
use Doctrine\Migrations\AbstractMigration;

final class Version20240606000000 extends AbstractMigration
{
    public function getDescription(): string
    {
        return 'Add licence admission processing scores (continuous average, preselection, motivation, final, oral corrected, ranking).';
    }

    public function up(Schema $schema): void
    {
        $this->addSql('ALTER TABLE submission ADD licence_continuous_average DOUBLE PRECISION DEFAULT NULL, ADD licence_preselection_score DOUBLE PRECISION DEFAULT NULL, ADD licence_motivation_score DOUBLE PRECISION DEFAULT NULL, ADD licence_final_score DOUBLE PRECISION DEFAULT NULL, ADD licence_oral_corrected_score DOUBLE PRECISION DEFAULT NULL, ADD licence_ranking_score DOUBLE PRECISION DEFAULT NULL');
    }

    public function down(Schema $schema): void
    {
        $this->addSql('ALTER TABLE submission DROP licence_continuous_average, DROP licence_preselection_score, DROP licence_motivation_score, DROP licence_final_score, DROP licence_oral_corrected_score, DROP licence_ranking_score');
    }
}