<?php

use Phalcon\Mvc\Model\Migration;

class PerguruanTinggiMigration_338 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            ALTER TABLE jaga.perguruan_tinggi
                ALTER COLUMN status TYPE VARCHAR(50);

            ALTER TABLE jaga.perguruan_tinggi
                ADD COLUMN IF NOT EXISTS kota_kab VARCHAR(100) DEFAULT '';

            ALTER TABLE jaga.perguruan_tinggi
                ADD COLUMN IF NOT EXISTS provinsi VARCHAR(100) DEFAULT '';
        ");
    }

    public function down()
    {
        
    }
}