<?php

use Phalcon\Mvc\Model\Migration;

/**
 * Class RolesMigration_211
 */
class StranasInstansiSatkerMigration_159 extends Migration
{
    public function up()
    {
        self::$connection->execute('
        CREATE TABLE jaga.stranas_instansi_satker (
            id serial PRIMARY KEY,
            nama varchar(255),
            akronim text,
            id_bdg int,
            level int,
            id_provinsi int,
            id_kota_kabupaten int,
            id_lembaga_migrasi int,
            id_provinsi_migrasi int,
            id_kota_kabupaten_migrasi int,
            id_instansi_bkn varchar(255),
            kode_instansi varchar(255),
            created_at timestamp(6) DEFAULT now(),
            updated_at timestamp(6) DEFAULT now(),
            deleted_at timestamp(6),
            created_by int,
            updated_by int
        )');

        $this->batchInsert('stranas_instansi_satker', [
            'id',
            'nama',
            'akronim',
            'id_bdg',
            'level',
            'id_provinsi',
            'id_kota_kabupaten',
            'id_lembaga_migrasi',
            'id_provinsi_migrasi',
            'id_kota_kabupaten_migrasi',
            'id_instansi_bkn',
            'kode_instansi'
        ]);

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

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