<?php

use Phalcon\Mvc\Model\Migration;

class AppConfigWebchatMigration_463 extends Migration {
    public function up()
    {
        $this->down();

        self::$connection->execute("
            ALTER TABLE jaga.app_config ADD COLUMN IF NOT EXISTS is_public boolean DEFAULT false;
            ALTER TABLE jaga.app_config ALTER COLUMN nilai TYPE varchar(255);
            INSERT INTO jaga.app_config (kode, nilai, keterangan, is_public) VALUES ('WEBCHAT_FLAG', '{\"SHOW_WEBCHAT\": true,\"WEBCHAT_TYPE\": \"qontak\",\"WEBCHAT_MOBILE_TYPE\":\"whatsapp\",\"PLATFORM_WEBCHAT\":\"desktop\",\"NO_WA\": \"628119897494\"}', 'Flag pengaturan webchat pada FE', true);
        ");
    }

    public function down()
    {
        self::$connection->execute("
            ALTER TABLE jaga.app_config DROP COLUMN IF EXISTS is_public;
            DELETE FROM jaga.app_config WHERE kode = 'WEBCHAT_FLAG';
        ");
    }
}