<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class Task2205201649 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute(<<<SQL
delete from seguro.beneficiarios_arquivos using seguro.beneficiarios b inner join sistema.agencias a on a.ds_cnpj = cpf_cnpj where b.id = id_beneficiario;
delete from seguro.beneficiarios_pendencias using seguro.beneficiarios b inner join sistema.agencias a on a.ds_cnpj = cpf_cnpj where b.id = id_beneficiario;
delete from seguro.beneficiarios using sistema.agencias a where a.ds_cnpj = cpf_cnpj;
SQL
);
    }

    public function down(): void
    {
    }
}