<?php

use Phalcon\Db\Column;
use Phalcon\Db\Index;
use Phalcon\Db\Reference;
use Phalcon\Mvc\Model\Migration;

/**
 * Class RolesMigration_211
 */
class InstansiMigration_158 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            ALTER TABLE jaga.instansi ADD COLUMN show_to_public int default 1;
        ");

        $this->batchInsert('instansi', [
            'id',
            'nama',
            'show_to_public'
        ]);
        self::$connection->execute("SELECT setval('instansi_id_seq', (SELECT MAX(id) FROM jaga.instansi));");
    }

    public function down()
    {
        self::$connection->execute("
            ALTER TABLE jaga.instansi DROP COLUMN show_to_public;
        ");
    }
}