<?php

use Phalcon\Mvc\Model\Migration;
class OmspanMasterPemdaMigration_396 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            CREATE TABLE IF NOT EXISTS jaga.omspan_master_pemda
            (
                kd_lokasi character varying(4) NOT NULL primary key,
                kd_prov character varying(2) NOT NULL,
                nm_lokasi character varying(255) NOT NULL
            );
        ");

        self::$connection->execute("update jaga.app_config set nilai = 'true' where kode = 'OMSPAN_PENYERAPAN_2021';");
        self::$connection->execute("update jaga.app_config set nilai = '12' where kode = 'OMSPAN_PENYALURAN_LAST_PERIOD_2021';");
        self::$connection->execute("insert into jaga.app_config (kode, nilai, keterangan) values ('OMSPAN_PENYALURAN_START_PERIOD_2021', '01', 'Periode awal penarikan Penyaluran Dana Desa tahun 2021 melalui Scheduled Task');");
        self::$connection->execute("insert into jaga.app_config (kode, nilai, keterangan) values ('OMSPAN_PENYALURAN_START_PERIOD_2022', '01', 'Periode awal penarikan Penyaluran Dana Desa tahun 2022 melalui Scheduled Task');");

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

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