<?php

use Phalcon\Mvc\Model\Migration;

class MartDataKorsupgahAllMigration_275 extends Migration
{
    public function up()
    {
        self::$connection->execute('
            CREATE TABLE IF NOT EXISTS "jaga"."mart_data_korsupgah_all" (
                "tahun" varchar(4) COLLATE "pg_catalog"."default",
                "area" varchar(100) COLLATE "pg_catalog"."default",
                "WILAYAH PROVINSI" varchar(255) COLLATE "pg_catalog"."default",
                "KAB / KOTA" varchar(255) COLLATE "pg_catalog"."default",
                "PEMERINTAH DAERAH" varchar(255) COLLATE "pg_catalog"."default",
                "indikator" varchar(255) COLLATE "pg_catalog"."default",
                "bobot" int4,
                "progres_verif" int8,
                "bobot * progres_verif" numeric,
                "Bobot Area" varchar(4) COLLATE "pg_catalog"."default",
                "status_tahapan" varchar(11) COLLATE "pg_catalog"."default",
                "pic_instansi" text COLLATE "pg_catalog"."default",
                "progres" varchar(6) COLLATE "pg_catalog"."default",
                "tanggal_verif" timestamp(6),
                "status_verfikasi" varchar(7) COLLATE "pg_catalog"."default",
                "satgas" text COLLATE "pg_catalog"."default",
                "urut" int4,
                "Tanggal Penarikan" varchar(19) COLLATE "pg_catalog"."default"
            );
        ');
    }
}