<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class Task2011181638 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute("ALTER TABLE 
                        seguro.propostas_croquis_talhoes
                        ADD COLUMN ds_item_segurado VARCHAR(100)
                    ");

        $this->execute("INSERT INTO sistema.acao (
                        ds_label, 
                        ds_module, 
                        ds_controller, 
                        ds_action, 
                        ds_param, 
                        id_parent, 
                        ds_image, 
                        ds_descricao, 
                        fl_tipo, 
                        id
                    ) VALUES (
                        'Importar Croqui KML', 
                        'seguro', 
                        'croqui', 
                        'importar', 
                        '', 
                        730, 
                        '', 
                        'Importar Croqui KML', 
                        'A', 
                        nextval('sistema.acao_id_seq'::regclass)
                    )
        ");

    }

    public function down(): void
    {
        $this->execute("ALTER TABLE
                        seguro.propostas_croquis_talhoes
                        DROP COLUMN ds_item_segurado
                    ");

        $this->execute("DELETE FROM sistema.acao
                        WHERE ds_label = 'Importar Croqui KML'
                        AND ds_module = 'seguro'
                        AND ds_controller = 'croqui'
                    ");

    }
}