<?php

use Phalcon\Mvc\Model\Migration;

class DiskusiBansosMigration_263 extends Migration
{
    public function up()
    {
        self::$connection->execute('
            ALTER TABLE "jaga"."diskusi_bansos"
                ADD IF NOT EXISTS id_instansi_origin INTEGER;

            UPDATE "jaga"."diskusi_bansos" a
            SET id_instansi_origin = b.id_instansi 
            FROM "jaga"."diskusi_bansos" b
            WHERE a.id = b.id;
        ');
    }
}