<?php

use Phalcon\Mvc\Model\Migration;

class MasterJenisPajakMigration_329 extends Migration
{
    public function up()
    {
        $this->down(); 
        
        self::$connection->execute('
            CREATE TABLE IF NOT EXISTS "jaga"."master_jenis_pajak"
            (
                id SERIAL PRIMARY KEY,
                jenis_pajak VARCHAR(255),
                tipe_instansi INTEGER,
                created_at timestamp(6) DEFAULT now(),
                updated_at timestamp(6) DEFAULT now(),
                deleted_at timestamp(6)
            )
            WITH (
                OIDS = FALSE
            );
        ');

        self::$connection->execute("
            INSERT INTO jaga.master_jenis_pajak (jenis_pajak, tipe_instansi)
                VALUES 
                ('PKB',1),
                ('BBNKB',1),
                ('PBB KB',1),
                ('PAP',1),
                ('Pajak Rokok',1),
                ('PBB P2',2),
                ('BPHTB',2),
                ('Pajak Hotel',2),
                ('Pajak Restoran',2),
                ('Pajak Hiburan',2),
                ('Pajak Parkir',2),
                ('Pajak Reklame',2),
                ('Pajak Penerangan Jalan Umum',2),
                ('Pajak Air Bawah Tanah',2),
                ('Pajak Batuan Mineral Bukan Logam',2),
                ('Pajak Sarang Burung Walet',2)
                ON CONFLICT DO NOTHING;
        ");
    }

    public function down()
    {
        self::$connection->execute('
            DROP TABLE IF EXISTS "jaga"."master_jenis_pajak";
        ');
    }
}