Stu\Migrations\Pgsql\Version20241215133617_Direction_Nullable

Complexity

Total Complexity

3

Size/Duplication

Total Lines	21
Duplicated Lines	0 %

Importance

Changes	1
Bugs	1	Features	0

<?php
final class Version20241215133617_Direction_Nullable extends AbstractMigration
{
    public function getDescription(): string
    {
        return '';
    }

    public function up(Schema $schema): void
    {
        $this->addSql('ALTER TABLE stu_flight_sig ALTER from_direction DROP NOT NULL');
        $this->addSql('ALTER TABLE stu_flight_sig ALTER to_direction DROP NOT NULL');
        $this->addSql('UPDATE stu_flight_sig SET from_direction = null WHERE from_direction = 0');
        $this->addSql('UPDATE stu_flight_sig SET to_direction = null WHERE to_direction = 0');
    }

    public function down(Schema $schema): void
    {
        $this->addSql('UPDATE stu_flight_sig SET from_direction = 0 WHERE from_direction IS null');
        $this->addSql('UPDATE stu_flight_sig SET to_direction = 0 WHERE to_direction IS null');
        $this->addSql('ALTER TABLE stu_flight_sig ALTER from_direction SET NOT NULL');
        $this->addSql('ALTER TABLE stu_flight_sig ALTER to_direction SET NOT NULL');
    }