<?php

use Phalcon\Mvc\Model\Migration;

/**
 * Class RolesMigration_211
 */
class InstansiMigration_167 extends Migration
{
    /**
     * Run the migrations
     *
     * @return void
     */
    public function up()
    {
        self::$connection->execute('
            ALTER TABLE jaga.instansi ADD COLUMN id_provinsi INT;
            ALTER TABLE jaga.instansi ADD COLUMN id_kota_kabupaten INT;
            ALTER TABLE jaga.instansi ADD COLUMN sumber INT;
        ');
    }

    /**
     * Reverse the migrations
     *
     * @return void
     */
    public function down()
    {
        self::$connection->execute('
            ALTER TABLE jaga.instansi DROP COLUMN id_provinsi;
            ALTER TABLE jaga.instansi DROP COLUMN id_kota_kabupaten;
            ALTER TABLE jaga.instansi DROP COLUMN sumber;
        ');
    }
}