<?php

use Phalcon\Mvc\Model\Migration;

class MasterJenisPajakMigration_325 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),
                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)
                VALUES ('PBB P2'),
                ('BPHTB'),
                ('Pajak Hotel'),
                ('Pajak Restoran'),
                ('Pajak Hiburan'),
                ('Pajak Parkir'),
                ('Pajak Reklame'),
                ('Pajak Penerangan Jalan Umum'),
                ('Pajak Air Bawah Tanah'),
                ('Pajak Batuan Mineral Bukan Logam'),
                ('Pajak Sarang Burung Walet')
                ON CONFLICT DO NOTHING;
        ");
    }

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