<?php 

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

class AddJenjangPendidikanMigration_306 extends Migration
{
    /**
     * Run the migrations
     *
     * @return void
     */
    public function up()
    {
        self::$connection->execute("
            ALTER TABLE jaga.jenjang ADD COLUMN src VARCHAR (50) DEFAULT 'sekolah';
            ALTER TABLE jaga.jenjang ALTER COLUMN nama_jenjang TYPE VARCHAR (20);
            INSERT INTO jaga.jenjang (nama_jenjang, sort_order, src) VALUES ('Universitas', 7, 'perguruan_tinggi');
        ");
    }

    /**
     * Reverse the migrations
     *
     * @return void
     */
    public function down()
    {
        self::$connection->execute("
            DELETE FROM jaga.jenjang WHERE nama_jenjang = 'Universitas';
            ALTER TABLE jaga.jenjang DROP COLUMN src;
            SELECT setval(pg_get_serial_sequence('jenjang', 'id'), coalesce(max(id),0) + 1, false) FROM jaga.jenjang;
        ");
    }

}