<?php

use Phalcon\Mvc\Model\Migration;

class SPIInternalEksternalMigration_381 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN int_integritas TO int_suap;
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN int_anggaran TO int_tradingininfluence;
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN int_pbj TO int_pengelolaanpbj;
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN int_sdm TO int_penyalahgunaanfasilitaskantor;
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN int_trading TO int_nepotismepengelolaansdm;
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN int_antikorupsi TO int_jualbelijabatan;
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN int_transparansi TO int_penyalahgunaanperdin;
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN ext_transparansi TO ext_suap;
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN ext_pencegahan TO ext_pungutanliar;
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN ext_pegawai TO exp_keberadaanpungutanliar;
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN esp_integritas TO exp_kualitastransparansilayanan;
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN esp_transparansi TO exp_kualitaspengelolaanpbj;
        ");

        $sql = file_get_contents(__DIR__ . DIRECTORY_SEPARATOR . 'data_spi_internal_eksternal.sql');
        self::$connection->execute($sql);
    }

    public function down()
    {
        self::$connection->execute("
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN int_suap TO int_integritas;
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN int_tradingininfluence TO int_anggaran;
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN int_pengelolaanpbj TO int_pbj;
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN int_penyalahgunaanfasilitaskantor TO int_sdm;
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN int_nepotismepengelolaansdm TO int_trading;
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN int_jualbelijabatan TO int_antikorupsi;
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN int_penyalahgunaanperdin TO int_transparansi;
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN ext_suap TO ext_transparansi;
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN ext_pungutanliar TO ext_pencegahan;
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN exp_keberadaanpungutanliar TO ext_pegawai;
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN exp_kualitastransparansilayanan TO esp_integritas;
            ALTER TABLE jaga.spi_internal_eksternal RENAME COLUMN exp_kualitaspengelolaanpbj TO esp_transparansi;
        ");
    }
}