<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class TaskSR61151 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute(<<<SQL
CREATE TABLE sinistro.aviso_email_segurado (
    id SERIAL,
    id_aviso INT NOT NULL,
    ds_email_segurado email NOT NULL,
    CONSTRAINT pk_aviso_email_segurado PRIMARY KEY (id),
    CONSTRAINT fk_aviso_email_segurado_avisos FOREIGN KEY (id_aviso) REFERENCES sinistro.avisos (id)
) INHERITS (public.campos_default);
SQL
        );
    }

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