<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class TaskINC48277 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute(<<<SQL
UPDATE sistema.vistoriadores_status SET id_status = 278 WHERE id_status = 189;
UPDATE sinistro.laudos_finais_funcionarios SET id_funcionario = 1375 WHERE id_funcionario = 1643;
UPDATE sinistro.laudos_finais_funcionarios SET id_funcionario = 923 WHERE id_funcionario = 1583;

DELETE FROM log.log_alteracoes_cadastro_funcionarios WHERE id_funcionario = 1583;
DELETE FROM sistema.vistoriadores_status WHERE id_funcionario = 1583;
DELETE FROM sistema.funcionarios WHERE id = 1583;
DELETE FROM sistema.telefone WHERE id_usuario = 4531;
DELETE FROM sistema.usuarios WHERE id = 4531;
SQL
        );
    }

    public function down(): void
    {
    }
}