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

class CreateInstansiSearchCountsMigration_570 extends Migration {
    public function up()
    {
        self::$connection->execute('
            CREATE TABLE IF NOT EXISTS "jaga"."instansi_search_counts" (
                id SERIAL PRIMARY KEY,
                id_instansi INTEGER,
                id_provinsi INTEGER,
                id_kota_kabupaten INTEGER,
                counter INTEGER NOT NULL,
                created_at TIMESTAMP(6) DEFAULT now(),
                updated_at TIMESTAMP(6),
                deleted_at TIMESTAMP(6),

                FOREIGN KEY (id_instansi) REFERENCES instansi(id) ON DELETE CASCADE
            );
        ');
    }

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