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

class CreateSpiInstansiPtnFilesMigration_547 extends Migration {
    public function up()
    {
        self::$connection->execute('
            CREATE TABLE IF NOT EXISTS "jaga"."spi_instansi_ptn_files" (
                id SERIAL PRIMARY KEY,
                tahun VARCHAR(4),
                instansi_id INTEGER,
                ptn_id INTEGER,
                filename VARCHAR(250)
            );
        ');
    }

    public function down()
    {
        self::$connection->execute("
            DROP TABLE IF EXISTS jaga.spi_instansi_ptn_files;
        ");
    }
    
}