<?php

use Phalcon\Mvc\Model\Migration;

class InfoAlokasiBoptnMigration_338 extends Migration
{
    public function up()
    {
        $this->down(); 

        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', 'Layanan Pengembangan Sistem Tata Kelola, Kelembagaan, dan SDM', now()),
                (6, '006', 'Operasional Rumah Sakit Pendidikan', now()),
                (7, '007', 'Sarana dan Prasarana Pembelajaran', now())
            ON CONFLICT DO NOTHING;
        ");
    }

    public function down()
    {
        self::$connection->execute('
            DELETE FROM jaga.info_alokasi_boptn;
        ');
    }
}