<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class Task03763 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute(<<<SQL
INSERT INTO sistema.acao (ds_label, 
                          ds_module, 
                          ds_controller, 
                          ds_action, 
                          ds_param, 
                          id_parent, 
                          ds_image, 
                          ds_descricao, 
                          fl_tipo, 
                          dt_criacao, 
                          id_usuario_criacao, 
                          id) 
     VALUES ('Consultar Zoneamento', 
             'seguro', 
             'consultarzoneamento', 
             'index', 
             '', 
             25, 
             '', 
             'Consulta de zoneamento', 
             'M', 
             '2020-09-24 17:32:05', 
             3379, 
             nextval('sistema.acao_id_seq'::regclass));
SQL
);
    }

    public function down(): void
    {
        $this->execute("delete from sistema.acao where ds_label = 'Consultar Zoneamento' and ds_module = 'seguro';");
    }
}