<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class TaskSr46287 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute(<<<SQL

            INSERT INTO sistema.roles_acao (id_usuario_criacao, dt_criacao, id_role, id_acao) VALUES (2068, now(), 28, 1856);
            INSERT INTO sistema.roles_acao (id_usuario_criacao, dt_criacao, id_role, id_acao) VALUES (2068, now(), 25, 1856);
            INSERT INTO sistema.roles_acao (id_usuario_criacao, dt_criacao, id_role, id_acao) VALUES (2068, now(), 24, 1856);
            INSERT INTO sistema.roles_acao (id_usuario_criacao, dt_criacao, id_role, id_acao) VALUES (2068, now(), 6, 1856);

            INSERT INTO sistema.roles_acao (id_usuario_criacao, dt_criacao, id_role, id_acao) VALUES (2068, now(), 28, 757);
            INSERT INTO sistema.roles_acao (id_usuario_criacao, dt_criacao, id_role, id_acao) VALUES (2068, now(), 25, 757);
            INSERT INTO sistema.roles_acao (id_usuario_criacao, dt_criacao, id_role, id_acao) VALUES (2068, now(), 24, 757);
            INSERT INTO sistema.roles_acao (id_usuario_criacao, dt_criacao, id_role, id_acao) VALUES (2068, now(), 6, 757);

SQL
        );
    }

    public function down(): void
    {
        $this->execute(<<<SQL
            DELETE FROM sistema.roles_acao WHERE id_usuario_criacao = 2068 AND id_role = 6 AND id_acao = 757;
            DELETE FROM sistema.roles_acao WHERE id_usuario_criacao = 2068 AND id_role = 24 AND id_acao = 757;
            DELETE FROM sistema.roles_acao WHERE id_usuario_criacao = 2068 AND id_role = 25 AND id_acao = 757;
            DELETE FROM sistema.roles_acao WHERE id_usuario_criacao = 2068 AND id_role = 28 AND id_acao = 757;

            DELETE FROM sistema.roles_acao WHERE id_usuario_criacao = 2068 AND id_role = 6 AND id_acao = 1856;
            DELETE FROM sistema.roles_acao WHERE id_usuario_criacao = 2068 AND id_role = 24 AND id_acao = 1856;
            DELETE FROM sistema.roles_acao WHERE id_usuario_criacao = 2068 AND id_role = 25 AND id_acao = 1856;
            DELETE FROM sistema.roles_acao WHERE id_usuario_criacao = 2068 AND id_role = 28 AND id_acao = 1856;
SQL
        );
    }
}