<?php

use Phalcon\Mvc\Model\Migration;

class UpdateSPIKodeMappingMigration_511 extends Migration {
    public function up() {
        self::$connection->execute("
            UPDATE jaga.spi_int_ext_kode_mapping SET dimensi_gratif = 'Pelayanan Publik' WHERE dimensi_gratif_key = 'pelayanan';
            UPDATE jaga.spi_int_ext_kode_mapping SET dimensi_gratif = 'Sosialisasi Gratifikasi' WHERE dimensi_gratif_key = 'sosialisasi';
        ");
    }

    public function down() {
        self::$connection->execute("
            UPDATE jaga.spi_int_ext_kode_mapping SET dimensi_gratif = 'Pelayanan' WHERE dimensi_gratif_key = 'pelayanan';
            UPDATE jaga.spi_int_ext_kode_mapping SET dimensi_gratif = 'Sosialisasi' WHERE dimensi_gratif_key = 'sosialisasi';
        ");
    }
}