<?php

use Phalcon\Mvc\Model\Migration;

class SPIDC2022Migration_431 extends Migration {
    public function up()
    {
        self::$connection->execute("
            INSERT INTO jaga.produk (id_index, nama, icon, is_active, sort_order, is_show) VALUES ('19', 'SPI Data Challenge 2022', 'http://a.a.com', 't', '19', '1');
            SELECT setval(pg_get_serial_sequence('produk', 'id_index'), coalesce(max(id_index),0) + 1, false) FROM jaga.produk;
            INSERT INTO jaga.kategori_diskusi (title, produk_id) VALUES ('SPI Data Challenge 2022', '19');
        ");
    }

    public function down()
    {
        self::$connection->execute("
            DELETE FROM jaga.kategori_diskusi WHERE produk_id = 19;
            SELECT setval(pg_get_serial_sequence('kategori_diskusi', 'id'), coalesce(max(id),0) + 1, false) FROM jaga.kategori_diskusi;
            DELETE FROM jaga.produk WHERE id_index = 19;
            SELECT setval(pg_get_serial_sequence('produk', 'id_index'), coalesce(max(id_index),0) + 1, false) FROM jaga.produk;
        ");
    }
}