<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class Task2010301937 extends AbstractMigration
{
    public function up(): void
    {
        $table = $this->table('sinistro.vistorias_avisos');
        $rows = [
                    'id_usuario_criacao' => 1979,
                    'dt_criacao'         => '2020-09-10 08:59:05-03',
                    'fl_ativo'           => true,
                    'fl_del'             => false,
                    'id_vistoria'        => 187817,
                    'id_aviso'           => 81481
                ];
        $table->insert($rows)
              ->save();
    }

    public function down(): void
    {
        $delete = $this->getQueryBuilder();
        $delete->delete('sinistro.vistorias_avisos')
               ->where([
                        'id_aviso'    => 81481,
                        'id_vistoria' => 187817
                      ])
               ->execute();
    }
}