<?php
use Phalcon\Mvc\Model\Migration;

class CreateSurveyIndexMigration_533 extends Migration {
    public function up()
    {
        self::$connection->execute("
            CREATE INDEX IF NOT EXISTS korsupgah_area_intervensi_id_idx ON jaga.korsupgah_area_intervensi (id,nama);
            CREATE INDEX IF NOT EXISTS korsupgah_indikator_id_area_intervensi_idx ON jaga.korsupgah_indikator (id_area_intervensi,id);
            CREATE INDEX IF NOT EXISTS korsupgah_indikator_id_area_intervensi_sub_idx ON jaga.korsupgah_indikator (id_area_intervensi,id,nama);
            CREATE INDEX IF NOT EXISTS korsupgah_sub_indikator_id_indikator_idx ON jaga.korsupgah_sub_indikator (id_indikator,id);
            CREATE INDEX IF NOT EXISTS korsupgah_sub_indikator_id_indikator_sub_idx ON jaga.korsupgah_sub_indikator (id_indikator,id,nama);
            CREATE INDEX IF NOT EXISTS korsupgah_survey_id_idx ON jaga.korsupgah_survey (id,id_instansi);
            CREATE INDEX IF NOT EXISTS korsupgah_answer_id_question_idx ON jaga.korsupgah_answer (id_question,id_survey,status,nilai_verifikasi);
            CREATE INDEX IF NOT EXISTS korsupgah_answer_id_question_sub_idx ON jaga.korsupgah_answer (id_question,id_survey,verified_at,status,nilai_verifikasi);
        ");
}

    public function down()
    {
        self::$connection->execute("
            DROP INDEX IF EXISTS jaga.korsupgah_answer_id_question_idx;
            DROP INDEX IF EXISTS jaga.korsupgah_answer_id_question_sub_idx;
            DROP INDEX IF EXISTS jaga.korsupgah_area_intervensi_id_idx;
            DROP INDEX IF EXISTS jaga.korsupgah_indikator_id_area_intervensi_idx;
            DROP INDEX IF EXISTS jaga.korsupgah_indikator_id_area_intervensi_sub_idx;
            DROP INDEX IF EXISTS jaga.korsupgah_sub_indikator_id_indikator_idx;
            DROP INDEX IF EXISTS jaga.korsupgah_sub_indikator_id_indikator_sub_idx;
            DROP INDEX IF EXISTS jaga.korsupgah_survey_id_idx;
        ");
    }
    
}