<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class Task2310241401 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute(<<<SQL
            UPDATE sinistro.avisos SET id_status = 168 WHERE id = 132998;
            INSERT INTO sinistro.avisos_log_mudanca_status (id_usuario_criacao, dt_criacao, id_aviso, ds_motivo, id_status_antigo, id_status_novo)
                VALUES (2068, now(), 132998, 'Solicitação de cancelamento por parte do corretor', 28, 168);
SQL
);
    }

    public function down(): void
    {
        $this->execute(<<<SQL
            UPDATE sinistro.avisos SET id_status = 28 WHERE id = 132998;
            DELETE FROM sinistro.avisos_log_mudanca_status WHERE id_aviso = 132998 AND id_usuario_alteracao = 2068 AND id_status_antigo = 28 AND id_status_novo = 168;
SQL
);
    }
}