<?php

use Phalcon\Mvc\Model\Migration;
class PengembanganPancekMigration_452 extends Migration
{
    public function up()
    {
        $this->down();

        self::$connection->execute("
            ALTER TABLE jaga.pancek_instansi ADD COLUMN IF NOT EXISTS nib CHARACTER VARYING(20);
        ");

        self::$connection->execute('
            CREATE TABLE IF NOT EXISTS "jaga"."pancek_user_verifikator" (
                id bigserial NOT NULL,
                um_id INTEGER NOT NULL,
                start_date date NOT NULL,
                end_date date NOT NULL,
                created_at timestamp(6) DEFAULT now(),
                updated_at timestamp(6) DEFAULT now(),
                deleted_at timestamp(6),
                PRIMARY KEY (id)
            );
        ');
    }

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

        self::$connection->execute("
            ALTER TABLE jaga.pancek_instansi DROP COLUMN IF EXISTS nib;
        ");
    }
}