<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class Task2311031303 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute(<<<SQL
            DELETE FROM sinistro.avisos_recusas WHERE id_aviso = 132302;
            UPDATE sinistro.avisos SET id_status = 168 WHERE id = 132302;
            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(), 132302, 'Solicitação de cancelamento por parte do corretor', 29, 168);
SQL
);
    }

    public function down(): void
    {
        $this->execute(<<<SQL
            INSERT INTO sinistro.avisos_recusas VALUES (1485, NULL, '2023-09-29 08:15:02-03' , NULL, 't', 'f', 132302, '', 10);
            UPDATE sinistro.avisos SET id_status = 29 WHERE id = 132302;
            DELETE FROM sinistro.avisos_log_mudanca_status WHERE id_aviso = 132302 AND id_usuario_criacao = 2068 AND id_status_antigo = 29 AND id_status_novo = 168;
SQL
);
    }
}