<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class Task2304051711 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute(<<<SQL
UPDATE sistema.vistoriadores_status SET id_usuario_criacao = 2068 WHERE id_usuario_criacao = 3379;
DELETE from sistema.roles_acao where id_acao = 2015;
DELETE from sistema.usuarios_acao where id_acao = 2015;

insert into sistema.usuarios_acao 
     select 2068 as id_usuario_criacao, 
            null as id_usuario_alteracao, 
            now() as dt_criacao, 
            null as dt_alteracao, 
            true as fl_ativo, 
            false as fl_del, 
            su.id as id_usuario, 
            2015 as id_acao, 
            true fl_permitido 
       from sistema.funcionarios sf 
            inner join sistema.usuarios su on su.id = sf.id_usuario 
      where sf.id_empresa = 20
        and sf.fl_ativo is true
        and su.fl_ativo is true;
SQL
);
    }

    public function down(): void
    {
    }
}