<?php
use Phalcon\Mvc\Model\Migration;

class KorsupgahMigration_212 extends Migration
{
    public function up()
    {
        self::$connection->execute('
            ALTER TABLE jaga.korsupgah_indikator RENAME TO korsupgah_area_intervensi;
            ALTER TABLE jaga.korsupgah_sub_indikator RENAME TO korsupgah_indikator;
            ALTER TABLE jaga.korsupgah_target RENAME TO korsupgah_sub_indikator;
            ALTER TABLE jaga.korsupgah_template_target RENAME TO korsupgah_template_sub_indikator;
            ALTER TABLE jaga.korsupgah_sub_indikator_tipe RENAME TO korsupgah_indikator_tipe;
            ALTER TABLE jaga.korsupgah_indikator RENAME COLUMN id_indikator TO id_area_intervensi;
            ALTER TABLE jaga.korsupgah_sub_indikator RENAME COLUMN id_sub_indikator TO id_indikator;
            ALTER TABLE jaga.korsupgah_template_sub_indikator RENAME COLUMN id_target TO id_sub_indikator;
        ');
    }
    public function down()
    {
        self::$connection->excute('
            ALTER TABLE jaga.korsupgah_indikator RENAME COLUMN id_area_intervensi TO id_indikator;
            ALTER TABLE jaga.korsupgah_sub_indikator RENAME COLUMN id_indikator TO id_sub_indikator;
            ALTER TABLE jaga.korsupgah_template_sub_indikator RENAME COLUMN id_sub_indikator TO id_target;
            ALTER TABLE jaga.korsupgah_indikator_tipe RENAME TO korsupgah_sub_indikator_tipe;
            ALTER TABLE jaga.korsupgah_template_sub_indikator RENAME TO korsupgah_template_target;
            ALTER TABLE jaga.korsupgah_sub_indikator RENAME TO korsupgah_target;
            ALTER TABLE jaga.korsupgah_indikator RENAME TO korsupgah_sub_indikator;
            ALTER TABLE jaga.korsupgah_area_intervensi RENAME TO korsupgah_indikator;
        ');
    }
}