<?php

use Phalcon\Mvc\Model\Migration;

class SipdMigration_221 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            ALTER TABLE jaga.sipd_skpd ADD COLUMN urai varchar;
            ALTER TABLE jaga.sipd_skpd ADD COLUMN pejabat text;
            ALTER TABLE jaga.sipd_skpd ADD COLUMN pilihan_bidang text;
            ALTER TABLE jaga.sipd_kegiatan RENAME COLUMN kode_kegiatan TO kode;
            ALTER TABLE jaga.sipd_kegiatan RENAME COLUMN urai_kegiatan TO urai;
            ALTER TABLE jaga.sipd_kegiatan ADD COLUMN id_sipd_program INT;
            ALTER TABLE jaga.sipd_kegiatan ADD COLUMN sumber_dana text;
            ALTER TABLE jaga.sipd_kegiatan ADD COLUMN lokasi text;
            ALTER TABLE jaga.sipd_kegiatan ADD COLUMN prioritas text;

            CREATE TABLE jaga.sipd_indikator (
                id serial primary key,
                id_kegiatan int,
                kode varchar,
                urai varchar,
                jenis varchar,
                tolok_ukur varchar,
                satuan varchar,
                real_p3 decimal,
                pagu_p3 decimal,
                real_p2 decimal,
                pagu_p2 decimal,
                real_p1 decimal,
                pagu_p1 decimal,
                target decimal,
                pagu decimal,
                pagu_p decimal,
                target_n1 decimal,
                pagu_n1 decimal
            );

            CREATE TABLE jaga.sipd_program_capaian (
                id serial primary key,
                id_sipd_program int,
                kode_indikator varchar,
                tolok_ukur varchar,
                satuan varchar,
                real_p3 decimal,
                pagu_p3 decimal,
                real_p2 decimal,
                pagu_p2 decimal,
                real_p1 decimal,
                pagu_p1 decimal,
                target decimal,
                pagu decimal,
                pagu_p decimal,
                target_n1 decimal,
                pagu_n1 decimal
            );
        ");
    }

    public function down()
    {
        // Do Nothing
    }
}