<?php

use Phalcon\Mvc\Model\Migration;

class MeilisearchRecordMigration_389 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            CREATE INDEX IF NOT EXISTS idx_sekolah_no_urut_internal ON sekolah USING btree (no_urut_internal);
        ");

        self::$connection->execute("
            CREATE TABLE jaga.meilisearch_record
            (
                id bigserial NOT NULL,
                model_name character varying(100) not null,
            	last_id bigint,
            	last_update_at timestamp(6),
            	
                PRIMARY KEY (id)
            )
            WITH (
                OIDS = FALSE
            );
        ");

        self::$connection->execute("
            CREATE TABLE jaga.meilisearch_popular_search
            (
                id bigserial NOT NULL,
                search_query character varying(255) not null,
            	search_date date,
            	search_count int,
            	
                PRIMARY KEY (id)
            )
            WITH (
                OIDS = FALSE
            );
        ");

        self::$connection->execute("
            INSERT INTO jaga.meilisearch_record (model_name, last_id) VALUES('DashboardRankumanJendelaPencegahan', 0);
            INSERT INTO jaga.meilisearch_record (model_name, last_id) VALUES('DashboardKoordinasiWilayah', 0);
            INSERT INTO jaga.meilisearch_record (model_name, last_id) VALUES('DashboardELHKPN', 0);
            INSERT INTO jaga.meilisearch_record (model_name, last_id) VALUES('DashboardGratifikasi', 0);
            INSERT INTO jaga.meilisearch_record (model_name, last_id) VALUES('DashboardSPI', 0);
            INSERT INTO jaga.meilisearch_record (model_name, last_id) VALUES('DashboardStranasPK', 0);
            
            INSERT INTO jaga.meilisearch_record (model_name, last_id) VALUES('DashboardCovid19', 0);
            INSERT INTO jaga.meilisearch_record (model_name, last_id) VALUES('DashboardPendidikan', 0);
            INSERT INTO jaga.meilisearch_record (model_name, last_id) VALUES('DashboardSekolah', 0);
            INSERT INTO jaga.meilisearch_record (model_name, last_id) VALUES('Sekolah', 0);
            INSERT INTO jaga.meilisearch_record (model_name, last_id) VALUES('DashboardPerguruanTinggi', 0);
            INSERT INTO jaga.meilisearch_record (model_name, last_id) VALUES('PerguruanTinggi', 0);
            
            INSERT INTO jaga.meilisearch_record (model_name, last_id) VALUES('DashboardDesa', 0);
            INSERT INTO jaga.meilisearch_record (model_name, last_id) VALUES('OmspanMasterDesa', 0);
            
            INSERT INTO jaga.meilisearch_record (model_name, last_id) VALUES('DashboardFaskes', 0);
            
            INSERT INTO jaga.meilisearch_record (model_name, last_id) VALUES('DashboardPerizinan', 0);
            INSERT INTO jaga.meilisearch_record (model_name, last_id) VALUES('PerizinanKontak', 0);
            
            INSERT INTO jaga.meilisearch_record (model_name, last_id) VALUES('DashboardPPJ', 0);
            
            INSERT INTO jaga.meilisearch_record (model_name, last_id) VALUES('DashboardBerita', 0);
            INSERT INTO jaga.meilisearch_record (model_name, last_id) VALUES('Diskusi', 0);
        ");
    }

    public function down()
    {
        self::$connection->execute("
            DROP INDEX IF EXISTS idx_sekolah_no_urut_internal;
        ");

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

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