<?php

use Phalcon\Mvc\Model\Migration;

class DiskusiBansosMigration_244 extends Migration
{
    public function up()
    {
        self::$connection->execute('
            CREATE TABLE IF NOT EXISTS "jaga"."diskusi_bansos" (
                id SERIAL PRIMARY KEY,
                id_diskusi INTEGER,
                id_instansi INTEGER,
                status INTEGER
            );

            CREATE TABLE IF NOT EXISTS "jaga"."diskusi_bansos_nik" (
                id SERIAL PRIMARY KEY,
                id_diskusi_bansos INTEGER,
                nik VARCHAR(20),
                pkh INTEGER
            );
        ');
    }
}