<?php

use Phalcon\Mvc\Model\Migration;

class LaporanGratifikasiMigration_173 extends Migration
{
    public function up()
    {
        self::$connection->execute("
        create table laporan_gratifikasi (
            id serial primary key,
            wilayah_nama varchar,
            provinsi_code varchar,
            jumlah bigint
        )
        ");

        $this->batchInsert('laporan_gratifikasi', [
            'wilayah_nama',
            'provinsi_code',
            'jumlah'
        ]);
    }

    public function down() {
        self::$connection->execute("drop table laporan_gratifikasi");
    }

}