<?php

use Phalcon\Mvc\Model\Migration;

class MasterWilayahMigration_182 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            create table master_wilayah (
                id int primary key,
                parent_id int not null,
                level varchar,
                code varchar,
                name varchar,
                active int,
                portal varchar
            )
        ");

        $this->batchInsert('master_wilayah', [
            'id',
            'parent_id',
            'level',
            'code',
            'name',
            'active',
            'portal'
        ]);
    }

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