<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class Task2211211752 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute(<<<SQL
        INSERT INTO produto.aceitacao_variedade_transgenica (id_usuario_criacao, id_produto, id_estado)
            VALUES 
                (2068, 1376, 1),
                (2068, 1376, 2),
                (2068, 1376, 3),
                (2068, 1376, 4),
                (2068, 1376, 5),
                (2068, 1376, 6),
                (2068, 1376, 7),
                (2068, 1376, 9),
                (2068, 1376, 10),
                (2068, 1376, 11),
                (2068, 1376, 12),
                (2068, 1376, 14),
                (2068, 1376, 15),
                (2068, 1376, 17),
                (2068, 1376, 18),
                (2068, 1376, 20),
                (2068, 1376, 22),
                (2068, 1376, 23),
                (2068, 1376, 26),
                (2068, 1376, 27),

                (2068, 1396, 1),
                (2068, 1396, 2),
                (2068, 1396, 4),
                (2068, 1396, 3),
                (2068, 1396, 5),
                (2068, 1396, 6),
                (2068, 1396, 7),
                (2068, 1396, 9),
                (2068, 1396, 10),
                (2068, 1396, 12),
                (2068, 1396, 11),
                (2068, 1396, 14),
                (2068, 1396, 15),
                (2068, 1396, 17),
                (2068, 1396, 18),
                (2068, 1396, 20),
                (2068, 1396, 22),
                (2068, 1396, 23),
                (2068, 1396, 26),
                (2068, 1396, 27),

                (2068, 1397, 1),
                (2068, 1397, 2),
                (2068, 1397, 4),
                (2068, 1397, 3),
                (2068, 1397, 5),
                (2068, 1397, 6),
                (2068, 1397, 7),
                (2068, 1397, 9),
                (2068, 1397, 10),
                (2068, 1397, 12),
                (2068, 1397, 11),
                (2068, 1397, 14),
                (2068, 1397, 15),
                (2068, 1397, 17),
                (2068, 1397, 18),
                (2068, 1397, 20),
                (2068, 1397, 22),
                (2068, 1397, 23),
                (2068, 1397, 26),
                (2068, 1397, 27),

                (2068, 1390, 1),
                (2068, 1390, 2),
                (2068, 1390, 4),
                (2068, 1390, 3),
                (2068, 1390, 5),
                (2068, 1390, 6),
                (2068, 1390, 7),
                (2068, 1390, 9),
                (2068, 1390, 10),
                (2068, 1390, 12),
                (2068, 1390, 11),
                (2068, 1390, 14),
                (2068, 1390, 15),
                (2068, 1390, 17),
                (2068, 1390, 18),
                (2068, 1390, 20),
                (2068, 1390, 22),
                (2068, 1390, 23),
                (2068, 1390, 26),
                (2068, 1390, 27);

                INSERT INTO sistema.versao_zoneamento (id_usuario_criacao, dt_criacao, fl_ativo, id_safra, fl_importado_zoneamento, fl_exportado_tablet) 
                    VALUES (2068, now(), 'f', 25, 't', 'f');
SQL
        );
    }

    public function down(): void
    {
        $this->execute(<<<SQL
            DELETE FROM produto.aceitacao_variedade_transgenica WHERE id_usuario_criacao = 2068 AND id_produto = 1376 AND id_estado IN (1, 2, 3, 4, 5, 6, 7, 9, 10, 11, 12, 14, 15, 17, 18, 20, 22, 23, 26, 27);
            DELETE FROM produto.aceitacao_variedade_transgenica WHERE id_usuario_criacao = 2068 AND id_produto = 1396 AND id_estado IN (1, 2, 4, 3, 5, 6, 7, 9, 10, 12, 11, 14, 15, 17, 18, 20, 22, 23, 26, 27);
            DELETE FROM produto.aceitacao_variedade_transgenica WHERE id_usuario_criacao = 2068 AND id_produto = 1397 AND id_estado IN (1, 2, 4, 3, 5, 6, 7, 9, 10, 12, 11, 14, 15, 17, 18, 20, 22, 23, 26, 27);
            DELETE FROM produto.aceitacao_variedade_transgenica WHERE id_usuario_criacao = 2068 AND id_produto = 1390 AND id_estado IN (1, 2, 4, 3, 5, 6, 7, 9, 10, 12, 11, 14, 15, 17, 18, 20, 22, 23, 26, 27);
             
SQL
        );
    }
}