<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class Task2105102022 extends AbstractMigration
{
    public function up(): void
    {
        $table = $this->table('sistema.municipios_culturas_regioes');
        $rows = [
                   [
                     'id_usuario_criacao' => 2530
                   , 'dt_criacao'         => 'NOW()'
                   , 'fl_ativo'           => 'TRUE'
                   , 'id_municipio'       => 4753
                   , 'id_regiao'          => 2
                   , 'id_cultura'         => 77
                   ]
        ];
        $table->insert($rows)
              ->save();
    }

    public function down(): void
    {
        $delete = $this->getQueryBuilder();
        $delete->delete('sistema.municipios_culturas_regioes')
               ->where([ 'id_usuario_criacao' => 2530
                       , 'id_municipio'       => 4753
                       , 'id_regiao'          => 2
                       , 'id_cultura'         => 77
                       ])
               ->execute();
    }
}