<?php

use Phalcon\Mvc\Model\Migration;

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

        self::$connection->execute("
            ALTER TABLE jaga.omspan_dana_desa_pagu ADD COLUMN IF NOT EXISTS created_at timestamp(6) without time zone;
            ALTER TABLE jaga.omspan_dana_desa_pagu ADD COLUMN IF NOT EXISTS updated_at timestamp(6) without time zone;
            ALTER TABLE jaga.omspan_dana_desa_penyaluran ADD COLUMN IF NOT EXISTS created_at timestamp(6) without time zone;
            ALTER TABLE jaga.omspan_dana_desa_penyaluran ADD COLUMN IF NOT EXISTS updated_at timestamp(6) without time zone;
            ALTER TABLE jaga.omspan_penyerapan_dana_desa ADD COLUMN IF NOT EXISTS created_at timestamp(6) without time zone;
            ALTER TABLE jaga.omspan_penyerapan_dana_desa ADD COLUMN IF NOT EXISTS updated_at timestamp(6) without time zone;
        ");
    }

    public function down()
    {
        self::$connection->execute("
            ALTER TABLE jaga.omspan_dana_desa_pagu DROP COLUMN IF EXISTS created_at;
            ALTER TABLE jaga.omspan_dana_desa_pagu DROP COLUMN IF EXISTS updated_at;
            ALTER TABLE jaga.omspan_dana_desa_penyaluran DROP COLUMN IF EXISTS created_at;
            ALTER TABLE jaga.omspan_dana_desa_penyaluran DROP COLUMN IF EXISTS updated_at;
            ALTER TABLE jaga.omspan_penyerapan_dana_desa DROP COLUMN IF EXISTS created_at;
            ALTER TABLE jaga.omspan_penyerapan_dana_desa DROP COLUMN IF EXISTS updated_at;
        ");
    }
}