<?php

use Phalcon\Mvc\Model\Migration;

class SekolahPegawaiMigration_445 extends Migration {
    public function up()
    {
        self::$connection->execute("
            CREATE TABLE IF NOT EXISTS jaga.sekolah_pegawai (
                npsn character varying (100) NOT NULL,
                jabatan character varying (100),
                jenis_kelamin character varying (100),
                jenjang_pendidikan character varying (100), 
                mata_pelajaran character varying (100),
                nama character varying (100),
                nuptk character varying (100),
                ptk_id character varying (100),
                sekolah_id character varying (100),
                status_kepegawaian character varying (100)
            );
            ALTER TABLE jaga.sekolah ADD COLUMN IF NOT EXISTS last_update_pegawai timestamp(6);  
            CREATE INDEX IF NOT EXISTS idx_npsn_sekolah_pegawai ON sekolah_pegawai USING btree (npsn);
            INSERT INTO jaga.app_config (kode, nilai, keterangan) VALUES ('SEKOLAH_DAYS_UPDATE', '7', 'Batas waktu detail dan pegawai sekolah perlu di-update');
        ");
    }

    public function down()
    {
        self::$connection->execute("
            DROP TABLE IF EXISTS jaga.sekolah_pegawai;
            ALTER TABLE jaga.sekolah DROP COLUMN IF EXISTS last_update_pegawai;
            DROP INDEX IF EXISTS idx_npsn_sekolah_pegawai;
            DELETE FROM jaga.app_config WHERE kode = 'SEKOLAH_DAYS_UPDATE'; 
        ");
    }
}