<?php

use Phalcon\Mvc\Model\Migration;

class BosRekapitulasiNasionalKomponenMigration_175 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            CREATE TABLE bos_rekapitulasi_nasional_komponen (
                id serial primary key,
                id_bos_komponen int,
                jenjang varchar,
                tahun int,
                triwulan1 bigint,
                triwulan2 bigint,
                triwulan3 bigint,
                triwulan4 bigint
            )
        ");

        $this->batchInsert('bos_rekapitulasi_nasional_komponen', [
            'id_bos_komponen',
            'jenjang',
            'tahun',
            'triwulan1',
            'triwulan2',
            'triwulan3',
            'triwulan4'
        ]);
    }

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