<?php

class InsertSigInstansiMigration_481 extends \Phalcon\Mvc\Model\Migration {
    public function up()
    {
        self::$connection->execute("
            INSERT INTO jaga.sig_instansi (id_instansi_gol, id_instansi_jaga, nama_instansi_gol) VALUES (1531, NULL, 'PT Mandiri Utama Finance');
            INSERT INTO jaga.sig_instansi (id_instansi_gol, id_instansi_jaga, nama_instansi_gol) VALUES (1532, NULL, 'Komite Nasional Ekonomi dan Keuangan Syariah');
            UPDATE jaga.sig_instansi SET id_instansi_jaga = 20029 WHERE id_instansi_gol = 1132;
        ");
    }

    public function down()
    {
        self::$connection->execute("
            DELETE FROM jaga.sig_instansi WHERE id_instansi_gol = 1531;
            DELETE FROM jaga.sig_instansi WHERE id_instansi_gol = 1532;
            UPDATE jaga.sig_instansi SET id_instansi_jaga = NULL WHERE id_instansi_gol = 1132;
        ");
    }
}