<?php

use Phalcon\Mvc\Model\Migration;

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

        self::$connection->execute('
            CREATE TABLE "jaga"."ppj_hal1"
            (
                "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),
                "goltarif" character varying(10),
                "daya" numeric,
                "lbr_sorek" numeric,
                "plg_sorek" numeric,
                "pemkwh_sorek" numeric,
                "pal_sorek" numeric,
                "ts_sorek" numeric,
                "ppj_sorek" numeric,
                "lbr_dph21" numeric,
                "pal_dph21" numeric,
                "ts_dph21" numeric,
                "ppj_dph21" numeric,
                "lbr_dph22" numeric,
                "pal_dph22" numeric,
                "ts_dph22" numeric,
                "ppj_dph22" numeric,
                "lbr_dph23" numeric,
                "pal_dph23" numeric,
                "ts_dph23" numeric,
                "ppj_dph23" numeric,
                "lbr_dph24" numeric,
                "pal_dph24" numeric,
                "ts_dph24" numeric,
                "ppj_dph24" numeric,
                "lbr_dph25" numeric,
                "pal_dph25" numeric,
                "ts_dph25" numeric,
                "ppj_dph25" numeric,
                "lbr_taglis" numeric,
                "plg_taglis" numeric,
                "pal_taglis" numeric,
                "ts_taglis" numeric,
                "ppj_taglis" numeric,
            	"created_at" timestamp(6) DEFAULT now(),
            	"updated_at" timestamp(6) DEFAULT now(),
            	"deleted_at" timestamp(6),
                PRIMARY KEY (id)
            )
            WITH (
                OIDS = FALSE
            );
        ');

        self::$connection->execute('
            CREATE TABLE "jaga"."ppj_hal2"
            (
                "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),
                "goltarif" character varying (10),
                "daya" numeric,
                "lbr_taglis" numeric,
                "plg_taglis" numeric,
                "pal_taglis" numeric,
                "ts_taglis" numeric,
                "ppj_taglis" numeric,
                "lbr_res_taglis" numeric,
                "plg_res_taglis" numeric,
                "pal_res_taglis" numeric,
                "ppj_res_taglis" numeric,
                "lbr_res_nontaglis" numeric,
                "plg_res_nontaglis" numeric,
                "pal_res_nontaglis" numeric,
                "ppj_res_nontaglis" numeric,
                "lbr_res_pra" numeric,
                "plg_res_pra" numeric,
                "pal_res_pra" numeric,
                "ppj_res_pra" numeric,
                "lbr_ntl" numeric,
                "plg_ntl" numeric,
                "pal_ntl" numeric,
                "ppj_ntl" numeric,
                "lbr_offl" numeric,
                "plg_offl" numeric,
                "pal_offl" numeric,
                "ppj_offl" numeric,
                "lbr_nota" numeric,
                "plg_nota" numeric,
                "pal_nota" numeric,
                "ppj_nota" numeric,
                "lbr_lpb" numeric,
                "plg_lpb" numeric,
                "pal_lpb" numeric,
                "ppj_lpb" numeric,
                "lbr_tmp_lpb" numeric,
                "plg_tmp_lpb" numeric,
                "pal_tmp_lpb" numeric,
                "ppj_tmp_lpb" numeric,
                "lbr_ujl_lpb" numeric,
                "plg_ujl_lpb" numeric,
                "pal_ujl_lpb" numeric,
                "ppj_ujl_lpb" numeric,
                "ppj_koreksi_tambah" numeric,
                "ppj_koreksi_kurang" numeric,
                "ppj_total" numeric,
            	"created_at" timestamp(6) DEFAULT now(),
            	"updated_at" timestamp(6) DEFAULT now(),
            	"deleted_at" timestamp(6),
                PRIMARY KEY (id)
            )
            WITH (
                OIDS = FALSE
            );
        ');

        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,
            	"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_hal1";
        ');

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

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