<?php

use Phalcon\Mvc\Model\Migration;

class SingkatanKlMigration_316 extends Migration
{
    public function up()
    {
        $this->down(); 
        
        self::$connection->execute('
            CREATE TABLE "jaga"."str_abbr"
            (
                id serial PRIMARY KEY,
                id_instansi int,
                singkatan varchar(255) not null,
                created_by int,
                created_at timestamp default now(),
                updated_by int,
                updated_at timestamp default null,
                deleted_by int,
                deleted_at timestamp default null,
                CONSTRAINT fk_str_instansi
                    FOREIGN KEY(id_instansi) 
                    REFERENCES jaga.instansi(id)
            )
        ');
    }

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