<?php

use Phalcon\Mvc\Model\Migration;

class DataSatuanBosBopMigration_436 extends Migration {
    public function up()
    {
        self::$connection->execute("
            CREATE TABLE IF NOT EXISTS jaga.data_satuan_bos_bop (
                id BIGSERIAL PRIMARY KEY,
                provinsi VARCHAR (100) NOT NULL,
                kab_kota VARCHAR (100) NOT NULL,
                jenjang VARCHAR (50) NOT NULL,
                tipe VARCHAR (10) NOT NULL,
                tahun INT4 NOT NULL,
                satuan INT8
            );
        ");

        $sql = file_get_contents(__DIR__ . DIRECTORY_SEPARATOR . 'data_satuan_bos_2023.sql');
        self::$connection->execute($sql);
    }

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