<?php

use Phalcon\Mvc\Model\Migration;

class ScopesInstansiTopikDiskusiBansosMigration_424 extends Migration {
    public function up()
    {
        self::$connection->execute("
            CREATE TABLE IF NOT EXISTS jaga.scopes_instansi_topik
            (
                id serial not null primary key,
                scopes_name character varying (255) not null,
                instansi_id integer not null,
                topik_id integer not null,
                created_at timestamp without time zone not null default now(),
                updated_at timestamp without time zone,
                deleted_at timestamp without time zone
            );

            -- INSERT INTO jaga.scopes_instansi_topik (scopes_name, instansi_id, topik_id) VALUES ('keluhan.pelabuhan.monitoring', (SELECT id FROM jaga.instansi WHERE nama LIKE 'Kementerian Perhubungan'), (SELECT id FROM jaga.topik_diskusi_bansos WHERE deskripsi LIKE 'Pelabuhan - Layanan Kapal'));
            -- INSERT INTO jaga.scopes_instansi_topik (scopes_name, instansi_id, topik_id) VALUES ('keluhan.pelabuhan.monitoring', (SELECT id FROM jaga.instansi WHERE nama LIKE 'Kementerian Perhubungan'), (SELECT id FROM jaga.topik_diskusi_bansos WHERE deskripsi LIKE 'Pelabuhan - Layanan Transportasi Pelabuhan'));
            -- INSERT INTO jaga.scopes_instansi_topik (scopes_name, instansi_id, topik_id) VALUES ('keluhan.pelabuhan.monitoring', (SELECT id FROM jaga.instansi WHERE nama LIKE 'Kementerian Pertanian'), (SELECT id FROM jaga.topik_diskusi_bansos WHERE deskripsi LIKE 'Pelabuhan - Layanan Barang'));
            -- INSERT INTO jaga.scopes_instansi_topik (scopes_name, instansi_id, topik_id) VALUES ('keluhan.pelabuhan.monitoring', (SELECT id FROM jaga.instansi WHERE nama LIKE 'Kementerian Kelautan dan Perikanan'), (SELECT id FROM jaga.topik_diskusi_bansos WHERE deskripsi LIKE 'Pelabuhan - Layanan Barang'));
            -- INSERT INTO jaga.scopes_instansi_topik (scopes_name, instansi_id, topik_id) VALUES ('keluhan.pelabuhan.monitoring', (SELECT id FROM jaga.instansi WHERE nama LIKE 'Kementerian Perdagangan'), (SELECT id FROM jaga.topik_diskusi_bansos WHERE deskripsi LIKE 'Pelabuhan - Layanan Domestik'));
            -- INSERT INTO jaga.scopes_instansi_topik (scopes_name, instansi_id, topik_id) VALUES ('keluhan.pelabuhan.monitoring', (SELECT id FROM jaga.instansi WHERE nama LIKE 'PT Pelabuhan Indonesia (Persero)'), (SELECT id FROM jaga.topik_diskusi_bansos WHERE deskripsi LIKE 'Pelabuhan - Layanan Pintu Keluar/Masuk'));
            -- INSERT INTO jaga.scopes_instansi_topik (scopes_name, instansi_id, topik_id) VALUES ('keluhan.pelabuhan.monitoring', (SELECT id FROM jaga.instansi WHERE nama LIKE 'PT Pelabuhan Indonesia (Persero)'), (SELECT id FROM jaga.topik_diskusi_bansos WHERE deskripsi LIKE 'Pelabuhan - Layanan Pengeluaran Barang'));
            -- INSERT INTO jaga.scopes_instansi_topik (scopes_name, instansi_id, topik_id) VALUES ('keluhan.pelabuhan.monitoring', (SELECT id FROM jaga.instansi WHERE nama LIKE 'Kementerian Ketenagakerjaan'), (SELECT id FROM jaga.topik_diskusi_bansos WHERE deskripsi LIKE 'Pelabuhan - Layanan Tenaga Bongkar Muat'));
        ");
    }

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