<?php

use Phalcon\Mvc\Model\Migration;

class InstansiTipeMigration_189 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            CREATE TABLE jaga.instansi_tipe (
                id SERIAL PRIMARY KEY,
                nama VARCHAR (225),
                created_at timestamp(6) DEFAULT now(),
                updated_at timestamp(6) DEFAULT now(),
                deleted_at timestamp(6),
                created_by int,
                updated_by int                 
            )");

        $this->batchInsert('instansi_tipe', [
            'id',
            'nama'
        ]);

        self::$connection->execute("SELECT setval('instansi_tipe_id_seq', (SELECT MAX(id) FROM jaga.instansi_tipe));");
    }

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