<?php

use Phalcon\Db\Column;
use Phalcon\Db\Index;
use Phalcon\Mvc\Model\Migration;

class ProdukMigration_246 extends Migration
{

    public function up()
    {
        self::$connection->execute("
            INSERT INTO jaga.produk (nama, icon, is_active, sort_order, is_show)
                VALUES ('Bantuan Sosial Covid-19', 'http://a.a.com', TRUE, 9, 1) ON CONFLICT DO NOTHING;

            INSERT INTO jaga.kategori_diskusi (produk_id, title)
                SELECT id_index, 'Lain-Lain'
                FROM jaga.produk
                WHERE nama = 'Bantuan Sosial Covid-19' ON CONFLICT DO NOTHING;
        ");
    }

    /**
     * Reverse the migrations
     *
     * @return void
     */
    public function down()
    {
    }
}