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

class KorsupgahAreaIntervensiMigration_213 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            ALTER SEQUENCE jaga.korsupgah_indikator_id_seq RENAME TO korsupgah_area_intervensi_id_seq;
            ALTER SEQUENCE jaga.korsupgah_sub_indikator_id_seq RENAME TO korsupgah_indikator_id_seq;
            ALTER SEQUENCE jaga.korsupgah_target_id_seq RENAME TO korsupgah_sub_indikator_id_seq;
            ALTER TABLE jaga.korsupgah_area_intervensi ADD COLUMN kategori_area_intervensi INT;
        ");
    }
    public function down()
    {
        self::$connection->execute("
            ALTER SEQUENCE jaga.korsupgah_sub_indikator_id_seq RENAME TO korsupgah_target_id_seq;
            ALTER SEQUENCE jaga.korsupgah_indikator_id_seq RENAME TO korsupgah_sub_indikator_id_seq;
            ALTER SEQUENCE jaga.korsupgah_area_intervensi_id_seq RENAME TO korsupgah_indikator_id_seq;
            ALTER TABLE jaga.korsupgah_area_intervensi DROP COLUMN kategori_area_intervensi;
        ");
    }
}