<?php

use Phalcon\Mvc\Model\Migration;

class MasterKementerianMigration_183 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            create table master_kementerian (
                id serial primary key,
                parent_id int not null,
                code varchar,
                name varchar,
                portal varchar
            );
        ");

        $this->batchInsert('master_kementerian', [
            'id',
            'parent_id',
            'code',
            'name',
            'portal'
        ]);
    }

    public function down()
    {
        self::$connection->execute("
            drop table master_kementerian;
        ");
    }
}