<?php

use Phalcon\Mvc\Model\Migration;

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

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

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

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

    }

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

        self::$connection->execute('
            DROP TABLE IF EXISTS "jaga"."gratifikasi_laporan_nasional";
        ');

        self::$connection->execute('
            DROP TABLE IF EXISTS "jaga"."gratifikasi_laporan_instansi";
        ');
    }
}