<?php

use Phalcon\Mvc\Model\Migration;

class PPJPiutangPemdaMigration_341 extends Migration
{
    public function up()
    {
        $this->down();

        self::$connection->execute('
            CREATE TABLE "jaga"."ppj_piutang_pemda"
            (
                "id" bigserial NOT NULL,
                "thbllap" integer,
                "namaunitpln" character varying (100),
                "kd_kabmendagri" character varying (4),
                "nama_kabmendagri" character varying (100),
                "pemda" character varying (10),
                "namapemda" character varying (100),
                "tagihan_pemda_ini" numeric,
                "setoran_ppj_ini" numeric,
                "tagihan_pemda_kum" numeric,
                "setoran_ppj_kum" numeric,
                "saldo_akhir_404" numeric,
                "tagihan_pemda_ini_pju" numeric,
                "tagihan_pemda_kum_pju" numeric,
                "saldo_404_baru_taglis" numeric,
                "saldo_404_berjalan" numeric,
                "saldo_404_tunggakan" numeric,
                "rpptl_309_kab" numeric,
                "pemkwh_309_kab" numeric,
            	"created_at" timestamp(6) DEFAULT now(),
            	"updated_at" timestamp(6) DEFAULT now(),
            	"deleted_at" timestamp(6),
                PRIMARY KEY (id)
            )
            WITH (
                OIDS = FALSE
            );
        ');
    }

    public function down()
    {

        self::$connection->execute('
            DROP TABLE IF EXISTS "jaga"."ppj_piutang_pemda";
        ');
    }
}