<?php

use Phalcon\Mvc\Model\Migration;

class ElhkpnKepatuhanPersonMigration_186 extends Migration 
{
    public function up() 
    {
        self::$connection->execute("
        create table elhkpn_kepatuhan_person (
            id serial primary key,
            year int not null,
            wilayah_id int not null,
            level varchar,
            provinsi varchar,
            kabupaten varchar,
            wilayah_join varchar,
            bidang varchar,
            nama varchar,
            tanggal_lapor varchar,
            status_laporan varchar,
            jabatan varchar,
            instansi varchar,
            has_kirim int
        );
        ");
    }

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

}