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

class PtInfoAnggaranMigration_233 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            ALTER TABLE jaga.pt_info_anggaran ADD COLUMN tahun INT;
            ALTER TABLE jaga.pt_info_anggaran ADD COLUMN kode VARCHAR;
        ");

        $this->batchInsert('pt_info_anggaran', [
            'id',
            'nama',
            'tahun',
            'kode'
        ]);

        self::$connection->execute("SELECT setval('pt_info_anggaran_id_seq', (SELECT MAX(id) FROM jaga.pt_info_anggaran));");
    }
    public function down()
    {
        self::$connection->execute("
            ALTER TABLE jaga.pt_info_anggaran DROP COLUMN kode;
            ALTER TABLE jaga.pt_info_anggaran DROP COLUMN tahun;
        ");
    }
}