<?php

use Phalcon\Mvc\Model\Migration;

class LitbangMigration_271 extends Migration
{
    public function up()
    {
        self::$connection->execute('
            CREATE TABLE IF NOT EXISTS "jaga"."litbang_kajian_sektor" (
                id SERIAL PRIMARY KEY,
                nama VARCHAR(100),
                created_at timestamp(6) with time zone,
                updated_at timestamp(6) with time zone,
                deleted_at timestamp(6) with time zone
            );

            CREATE TABLE IF NOT EXISTS "jaga"."litbang_kajian_jenis" (
                id SERIAL PRIMARY KEY,
                nama VARCHAR(100),
                created_at timestamp(6) with time zone,
                updated_at timestamp(6) with time zone,
                deleted_at timestamp(6) with time zone
            );

            CREATE TABLE IF NOT EXISTS "jaga"."litbang_kajian" (
                id SERIAL PRIMARY KEY,
                sektor_id INTEGER NOT NULL,
                jenis_id INTEGER NOT NULL,
                kode VARCHAR(10) NOT NULL,
                judul TEXT NOT NULL,
                tahun INTEGER NOT NULL,
                deskripsi TEXT NOT NULL,
				potensi_penyelamatan_keuangan TEXT,
                daftar_pustaka TEXT,
                created_at timestamp(6) with time zone,
                updated_at timestamp(6) with time zone,
                deleted_at timestamp(6) with time zone
            );

            CREATE TABLE IF NOT EXISTS "jaga"."litbang_kajian_klpd" (
                id SERIAL PRIMARY KEY,
                kajian_id INTEGER NOT NULL,
                instansi_id INTEGER NOT NULL,
                created_at timestamp(6) with time zone,
                updated_at timestamp(6) with time zone,
                deleted_at timestamp(6) with time zone
            );

            CREATE TABLE IF NOT EXISTS "jaga"."litbang_kajian_klpd_rekomendasi" (
                id SERIAL PRIMARY KEY,
                kajian_klpd_id INTEGER NOT NULL,
                konten TEXT NOT NULL,
                potensi_penyelamatan_keuangan_negara TEXT,
                created_at timestamp(6) with time zone,
                updated_at timestamp(6) with time zone,
                deleted_at timestamp(6) with time zone
            );
        ');
    }

    public function down()
    {
        self::$connection->execute('
            DROP TABLE IF EXISTS "jaga"."litbang_kajian_klpd_rekomendasi";
            DROP TABLE IF EXISTS "jaga"."litbang_kajian_klpd";
            DROP TABLE IF EXISTS "jaga"."litbang_kajian";
            DROP TABLE IF EXISTS "jaga"."litbang_kajian_sektor";
            DROP TABLE IF EXISTS "jaga"."litbang_kajian_jenis";
        ');
    }
}