<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class TaskInc68045 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute(<<<SQL
            CREATE TABLE log.api (
                id SERIAL NOT NULL,
                id_api INT NOT NULL,
                ds_mensagem TEXT NOT NULL,
                ds_rota VARCHAR,
                fl_erro BOOLEAN DEFAULT true,
                id_proposta INT,
                ds_parametros jsonb,
                CONSTRAINT pk_log_api PRIMARY KEY (id),
                CONSTRAINT fk_log_api_proposta FOREIGN KEY (id_proposta) REFERENCES seguro.propostas (id)
            ) INHERITS (public.campos_default);
SQL
        );
    }

    public function down(): void
    {
        $this->execute(<<<SQL
            DROP TABLE log.api;
SQL
        );
    }
}