<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class Task2310111055 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute(<<<SQL
            CREATE TABLE sinistro.laudos_finais_docusign(
                id SERIAL,
                id_laudo_final INTEGER NOT NULL,
                id_envelope VARCHAR,
                ds_status VARCHAR NOT NULL,
                ds_mensagem VARCHAR,
                CONSTRAINT pk_laudos_finais_docusign PRIMARY KEY(id),
                CONSTRAINT fk_laudos_finais_docusign_laudos_finais FOREIGN KEY (id_laudo_final) REFERENCES sinistro.laudos_finais (id)
            ) INHERITS (public.campos_default);

            CREATE INDEX idx_laudos_finais_docusign_laudos_finais ON sinistro.laudos_finais_docusign(id_laudo_final);
SQL
        );
    }

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