<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class Task2011032037 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute("SELECT seguro.ativa_proposta_status(464338,8)");
        $builder = $this->getQueryBuilder();
        $builder->update('seguro.propostas')
                ->set('nr_apolice', '1000111135866')
                ->where(['id' => '464338'])
                ->execute();
    }

    public function down(): void
    {
        $this->execute("SELECT seguro.ativa_proposta_status(464338,62)");
        $builder = $this->getQueryBuilder();
        $builder->update('seguro.propostas')
                ->set('nr_apolice', NULL)
                ->where(['id' => '464338'])
                ->execute();
    }
}