<?php

use Phalcon\Mvc\Model\Migration;

class InfoAlokasiBoptnMigration_335 extends Migration
{
    public function up()
    {
        $this->down(); 
        
        self::$connection->execute('
            CREATE TABLE IF NOT EXISTS "jaga"."info_alokasi_boptn"
            (
                id SERIAL PRIMARY KEY,
                kode_output VARCHAR(10),
                nama_output VARCHAR(255),
                created_at timestamp(6) DEFAULT now(),
                updated_at timestamp(6) DEFAULT now(),
                deleted_at timestamp(6)
            )
            WITH (
                OIDS = FALSE
            );
        ');

        self::$connection->execute("
            INSERT INTO jaga.info_alokasi_boptn (id, kode_output, nama_output, created_at)
            VALUES 
                (1, '001', 'Dukungan Operasional PTN', now()),
                (2, '002', 'Layanan Pembelajaran', now()),
                (3, '003', 'Buku Pustaka', now()),
                (4, '004', 'Laporan Kegiatan Mahasiswa', now()),
                (5, '005', 'Alokasi Kode 005', now()),
                (6, '006', 'Operasional Rumah Sakit Pendidikan', now()),
                (7, '007', 'Layanan Pengembangan Sistem Tata Kelola, Kelembagaan, dan SDM', now()),
                (8, '008', 'Sarana dan Prasarana Pembelajaran', now())
            ON CONFLICT DO NOTHING;
        ");
    }

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