<?php

use Phalcon\Mvc\Model\Migration;

class JejakKasusMigration_186 extends Migration
{
    public function up()
    {
        // WARNING: non reversible
        // data will be fed by PHP via upload csv
        self::$connection->execute("
        drop table jejak_kasus;
        create table jejak_kasus (
            id int primary key,
            wilayah_id int not null,
            foto varchar null,
            nama varchar null,
            jenis_kelamin varchar null,
            pendidikan varchar null,
            profesi varchar null,
            institusi varchar null,
            waktu_inkracht int4 null,
            area_korupsi varchar null,
            jenis_tpk varchar null,
            tingkat varchar null,
            nomor varchar null,
            tanggal varchar null,
            pidana varchar null,
            pidana_tambahan varchar null,
            denda varchar null,
            denda_tambahan varchar null,
            uang_pengganti varchar null,
            uang_pengganti_tambahan varchar null,
            uang_pengganti_tambahan2 varchar null,
            biaya_perkara varchar null,
            summary varchar null
        );
        ");
    }

    public function down()
    {
    }
}