<?php

use Phalcon\Mvc\Model\Migration;

class AlterKorsupgahAnswerAddColumnsMigration_508 extends Migration {
    public function up() {
        self::$connection->execute("
            ALTER TABLE jaga.korsupgah_answer
                ADD COLUMN IF NOT EXISTS nilai_verifikasi_qa integer,
                ADD COLUMN IF NOT EXISTS keterangan_verifikasi_qa text,
                ADD COLUMN IF NOT EXISTS qa_verified_by integer,
                ADD COLUMN IF NOT EXISTS qa_verified_at timestamp(6) without time zone,
                ADD COLUMN IF NOT EXISTS nilai_verifikasi_pic integer,
                ADD COLUMN IF NOT EXISTS keterangan_verifikasi_pic text,
                ADD COLUMN IF NOT EXISTS pic_verified_by integer,
                ADD COLUMN IF NOT EXISTS pic_verified_at timestamp(6) without time zone;
        ");
    }

    public function down() {
        self::$connection->execute("
            ALTER TABLE jaga.korsupgah_answer
                DROP COLUMN IF EXISTS nilai_verifikasi_qa,
                DROP COLUMN IF EXISTS keterangan_verifikasi_qa,
                DROP COLUMN IF EXISTS qa_verified_by,
                DROP COLUMN IF EXISTS qa_verified_at,
                DROP COLUMN IF EXISTS nilai_verifikasi_pic,
                DROP COLUMN IF EXISTS keterangan_verifikasi_pic,
                DROP COLUMN IF EXISTS pic_verified_by,
                DROP COLUMN IF EXISTS pic_verified_at;
        ");
    }
}