<?php

use Phalcon\Mvc\Model\Migration;

class DiskusiBansosMigration_252 extends Migration
{
    public function up()
    {
        self::$connection->execute('
            ALTER TABLE "jaga"."diskusi_bansos" 
                ADD IF NOT EXISTS id_topik INTEGER,
                ADD IF NOT EXISTS created_at timestamp(6) NOT NULL DEFAULT now(),
                ADD IF NOT EXISTS updated_at timestamp(6) NOT NULL DEFAULT now(),
                ADD IF NOT EXISTS deleted_at timestamp(6);

            ALTER TABLE "jaga"."diskusi_bansos_nik" 
                ADD IF NOT EXISTS created_at timestamp(6) NOT NULL DEFAULT now(),
                ADD IF NOT EXISTS updated_at timestamp(6) NOT NULL DEFAULT now(),
                ADD IF NOT EXISTS deleted_at timestamp(6);

            ALTER TABLE "jaga"."kemdagri_bansos_covid19" 
                ADD IF NOT EXISTS created_at timestamp(6) NOT NULL DEFAULT now(),
                ADD IF NOT EXISTS updated_at timestamp(6) NOT NULL DEFAULT now(),
                ADD IF NOT EXISTS deleted_at timestamp(6);

            ALTER TABLE "jaga"."diskusi_bansos_history" 
                ADD IF NOT EXISTS updated_at timestamp(6) NOT NULL DEFAULT now(),
                ADD IF NOT EXISTS deleted_at timestamp(6);
        ');
    }
}