<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class TaskSR56660 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute(<<<SQL
ALTER TABLE sistema.aviso_tela_inicial DROP COLUMN fl_link;
ALTER TABLE sistema.aviso_tela_inicial ADD COLUMN ds_url VARCHAR(300);
ALTER TABLE sistema.aviso_tela_inicial ADD COLUMN fl_habilitar_confirmacao_leitura BOOL DEFAULT false NOT NULL;
SQL
        );
    }

    public function down(): void
    {
        $this->execute(<<<SQL
ALTER TABLE sistema.aviso_tela_inicial DROP COLUMN ds_url;
ALTER TABLE sistema.aviso_tela_inicial DROP COLUMN fl_habilitar_confirmacao_leitura;
ALTER TABLE sistema.aviso_tela_inicial ADD COLUMN fl_link BOOL DEFAULT false NOT NULL;
SQL
        );
    }
}