<?php

use Phalcon\Mvc\Model\Migration;

class PtOutputAnggaranMigration_195 extends Migration
{
    public function up()
    {
        self::$connection->execute("
        CREATE TABLE jaga.pt_output_anggaran(
            id serial PRIMARY KEY,
            id_pt INT NOT NULL,
            id_info_anggaran INT NOT NULL,
            anggaran_boptn VARCHAR(255),
            anggaran_pnbp VARCHAR(255),
            realisasi_pnbp VARCHAR(255),
            created_at timestamp(6) DEFAULT now(),
            updated_at timestamp(6) DEFAULT now(),
            deleted_at timestamp(6)
            )
        ");

        $this->batchInsert('pt_output_anggaran', [
            'id_pt',
            'id_info_anggaran',
            'anggaran_boptn',
            'anggaran_pnbp'
        ]);

        self::$connection->execute("SELECT setval('pt_output_anggaran_id_seq', (SELECT MAX(id) FROM jaga.pt_output_anggaran));");
    }

    public function down()
    {
        self::$connection->execute("
        DROP TABLE jaga.pt_output_anggaran");
    }
}