<?php
use Phalcon\Mvc\Model\Migration;

class AlterAssetAndTaxAndCreateTypeOfTaxesTableMigration_524 extends Migration {
    public function up()
    {
        self::$connection->execute("
            ALTER TABLE jaga.aset_penertiban
            ADD COLUMN IF NOT EXISTS unit_tanah_bangunan integer,
            ADD COLUMN IF NOT EXISTS luas_tanah_bangunan text,
            ADD COLUMN IF NOT EXISTS nilai_tanah_bangunan numeric(18,2)
        ");

        self::$connection->execute('
            CREATE TABLE IF NOT EXISTS "jaga"."pajak_tunggakan_detail" (
                id SERIAL PRIMARY KEY,
                pajak_tunggakan_id INTEGER,
                id_mata_pajak INTEGER,
                jenis_pajak TEXT,
                tunggakan NUMERIC(18,2),
                tipe_instansi INTEGER,
                created_at TIMESTAMP(6) DEFAULT NOW(),
                updated_at TIMESTAMP(6),
                deleted_at TIMESTAMP(6),
                FOREIGN KEY (pajak_tunggakan_id) REFERENCES pajak_tunggakan(id) 
            );
        ');

        self::$connection->execute('
        CREATE TABLE IF NOT EXISTS "jaga"."pajak_penagihan_detail" (
            id SERIAL PRIMARY KEY,
            pajak_penagihan_id INTEGER,
            id_mata_pajak INTEGER,
            jenis_pajak TEXT,
            penagihan NUMERIC(18,2),
            tipe_instansi INTEGER,
            created_at TIMESTAMP(6) DEFAULT NOW(),
            updated_at TIMESTAMP(6),
            deleted_at TIMESTAMP(6),
            FOREIGN KEY (pajak_penagihan_id) REFERENCES pajak_penagihan(id) 
        );
    ');

}

    public function down()
    {
        self::$connection->execute("
            ALTER TABLE jaga.aset_penertiban 
            DROP COLUMN IF EXISTS unit_tanah_bangunan,
            DROP COLUMN IF EXISTS luas_tanah_bangunan,
            DROP COLUMN IF EXISTS nilai_tanah_bangunan
        ");

        self::$connection->execute("
            ALTER TABLE jaga.pajak_tunggakan
            DROP COLUMN IF EXISTS id_mata_pajak,
            DROP COLUMN IF EXISTS tunggakan,
            DROP COLUMN IF EXISTS tipe_instansi,
            DROP COLUMN IF EXISTS jenis_pajak
        ");

           self::$connection->execute("
            ALTER TABLE jaga.pajak_penagihan 
            DROP COLUMN IF EXISTS id_mata_pajak,
            DROP COLUMN IF EXISTS tunggakan,
            DROP COLUMN IF EXISTS tipe_instansi,
            DROP COLUMN IF EXISTS jenis_pajak
        ");

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

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

}