<?php

use Phalcon\Mvc\Model\Migration;

class JenjangMigration_340  extends Migration
{
    public function up()
    {
        $this->down();

        self::$connection->execute("
            ALTER TABLE jaga.jenjang ADD COLUMN IF NOT EXISTS id_instansi_tipe integer;
        ");

        self::$connection->execute("
            UPDATE jaga.jenjang SET id_instansi_tipe = 1 WHERE id IN (3,4);
            UPDATE jaga.jenjang SET id_instansi_tipe = 2 WHERE id IN (1,2);
        ");
    }

    public function down()
    {
        self::$connection->execute("
            ALTER TABLE jaga.jenjang DROP COLUMN IF EXISTS id_instansi_tipe;
        ");
    }
}