<?php

use Phalcon\Mvc\Model\Migration;

class ElhkpnKepatuhanMigration_186 extends Migration 
{
    public function up() 
    {
        self::$connection->execute("
        create table elhkpn_kepatuhan (
            id serial primary key,
            year int not null,
            wilayah_id int not null,
            parent_wilayah_id int not null,
            level varchar not null,
            provinsi varchar,
            kabupaten varchar,
            wilayah_join varchar,
            bidang varchar,
            cnt bigint,
            cnt_kirim bigint
        );
        ");
    }

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

}