<?php
declare(strict_types=1);

use Phinx\Migration\AbstractMigration;

final class Task2310311240v2 extends AbstractMigration
{
    public function up(): void
    {
        $this->execute(<<<SQL
            CREATE MATERIALIZED VIEW seguro.proposta_area_item_segurado AS
                SELECT 
                    sum(vl_area) AS area_total_proposta,
                    id_proposta
                FROM
                    seguro.itens_segurados 
                GROUP BY
                    id_proposta
                ORDER BY id_proposta;
SQL
);
    }

    public function down(): void
    {
        $this->execute(<<<SQL
            DROP MATERIALIZED VIEW seguro.proposta_area_item_segurado;
SQL
);
    }
}