<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class TaskINC46208 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute(<<<SQL
UPDATE sistema.usuarios
   SET dt_expiracao_senha = now()
 WHERE id in(470, 1494, 2081);

UPDATE sistema.usuarios su
   SET dt_expiracao_senha = now()
  FROM sistema.prepostos sp
       INNER JOIN sistema.corretores sc ON sc.id = sp.id_corretor
 WHERE su.id = sp.id_usuario
   AND sp.id_corretor = 147
   AND su.fl_ativo is true;
SQL
);
    }

    public function down(): void
    {
    }
}