<?php

use Phalcon\Mvc\Model\Migration;

class KorsupgahIndikatorMigration_187 extends Migration
{
    public function up()
    {
        self::$connection->execute("ALTER TABLE jaga.korsupgah_indikator ADD COLUMN presentase_bobot INT");

        $this->batchInsert('korsupgah_indikator', [
            'id',
            'nama',
            'presentase_bobot'
        ]);

        self::$connection->execute("SELECT setval('korsupgah_indikator_id_seq', (SELECT MAX(id) FROM jaga.korsupgah_indikator));");
    }

    public function down()
    {
        self::$connection->execute("ALTER TABLE jaga.korsupgah_indikator DROP COLUMN presentase_bobot");
    }

}