<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class TaskINC54575 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute(<<<SQL
UPDATE seguro.propostas_coberturas
   SET vl_franquia = 10.00
 WHERE id_proposta in (1003105, 1003121, 1003129, 1003137, 1003235, 1003244, 1003109, 1003327, 1003330, 1003333, 1003338, 1003337, 1003339, 1003343, 1003356, 1003351, 1003370, 1003355, 1003382, 1003362, 1003392, 1003378, 1003401, 1003425, 1003436, 1003442, 1003445, 1003441, 1003438, 1003453, 1003454, 1003477, 1003489, 1003517)
   AND id_cobertura in (3, 12, 23, 34);
SQL
        );
    }

    public function down(): void
    {
        $this->execute(<<<SQL
UPDATE seguro.propostas_coberturas
   SET vl_franquia = null
 WHERE id_proposta in (1003105, 1003121, 1003129, 1003137, 1003235, 1003244, 1003109, 1003327, 1003330, 1003333, 1003338, 1003337, 1003339, 1003343, 1003356, 1003351, 1003370, 1003355, 1003382, 1003362, 1003392, 1003378, 1003401, 1003425, 1003436, 1003442, 1003445, 1003441, 1003438, 1003453, 1003454, 1003477, 1003489, 1003517)
   AND id_cobertura in (3, 12, 23, 34);
SQL
        );
    }
}