<?php

use Phalcon\Mvc\Model\Migration;

class AlterPancekInstansiMigration_392 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            ALTER TABLE jaga.pancek_instansi RENAME COLUMN nomor TO npwp;
            ALTER TABLE jaga.pancek_instansi ADD COLUMN IF NOT EXISTS nomor char varying (100);
        ");
    }

    public function down()
    {
        self::$connection->execute("
            ALTER TABLE jaga.pancek_instansi DROP COLUMN IF EXISTS nomor;
            ALTER TABLE jaga.pancek_instansi RENAME COLUMN npwp TO nomor;
        ");
    }
}