<?php

use Phalcon\Mvc\Model\Migration;

class MCP2022Migration_375 extends Migration
{
    public function up() {
        $sql = file_get_contents(__DIR__ . DIRECTORY_SEPARATOR . 'data_dukung.sql');
        self::$connection->execute($sql);
    }

    public function down() {
        self::$connection->execute("
            DELETE FROM korsupgah_area_intervensi WHERE id >= (SELECT (MAX(id)+1)-8 FROM jaga.korsupgah_area_intervensi);
            SELECT setval('jaga.korsupgah_area_intervensi_id_seq', COALESCE((SELECT MAX(id)+1 FROM jaga.korsupgah_area_intervensi), 1), false);

            DELETE FROM korsupgah_indikator WHERE id >= (SELECT (MAX(id)+1)-38 FROM jaga.korsupgah_indikator);
            SELECT setval('jaga.korsupgah_indikator_id_seq', COALESCE((SELECT MAX(id)+1 FROM jaga.korsupgah_indikator), 1), false);

            DELETE FROM korsupgah_sub_indikator WHERE id >= (SELECT (MAX(id)+1)-88 FROM jaga.korsupgah_sub_indikator);
            SELECT setval('jaga.korsupgah_sub_indikator_id_seq', COALESCE((SELECT MAX(id)+1 FROM jaga.korsupgah_sub_indikator), 1), false);
        ");
    }
}