<?php

class UnitKerjaBimaMigration_489 extends \Phalcon\Mvc\Model\Migration {
    public function up()
    {
        self::$connection->execute("
            UPDATE jaga.spi_int_ext_unit_kerja_kl
	            SET id_unit_kerja = (SELECT id FROM jaga.instansi WHERE nama = 'Badan Kebijakan Fiskal Kementerian Keuangan') WHERE id_unit_kerja = 20316;
	
            UPDATE jaga.spi_internal_opd_detail
            	SET id_unit_kerja = (SELECT id FROM jaga.instansi WHERE nama = 'Badan Kebijakan Fiskal Kementerian Keuangan') WHERE id_unit_kerja = 20316;
            	
            UPDATE jaga.spi_external_opd_detail
            	SET id_unit_kerja = (SELECT id FROM jaga.instansi WHERE nama = 'Badan Kebijakan Fiskal Kementerian Keuangan') WHERE id_unit_kerja = 20316;
        ");
    }

    public function down()
    {
    }
}