<?php
use Phalcon\Mvc\Model\Migration;

class AlterTableAssetSertifikasiNewMigration_524 extends Migration {
    public function up()
    {
        self::$connection->execute("
            ALTER TABLE jaga.aset_sertifikasi
            ADD COLUMN IF NOT EXISTS target numeric(18,2),
            ADD COLUMN IF NOT EXISTS anggaran numeric(18,2),
            ADD COLUMN IF NOT EXISTS jumlah_k1 integer,
            ADD COLUMN IF NOT EXISTS jumlah_k2 integer,
            ADD COLUMN IF NOT EXISTS jumlah_k3 integer,
            ADD COLUMN IF NOT EXISTS jumlah_k4 integer, 
            ADD COLUMN IF NOT EXISTS attachment_uuid text
        ");
    }

    public function down()
    {
        self::$connection->execute("
            ALTER TABLE jaga.aset_sertifikasi 
            DROP COLUMN IF EXISTS target,
            DROP COLUMN IF EXISTS anggaran,
            DROP COLUMN IF EXISTS jumlah_k1,
            DROP COLUMN IF EXISTS jumlah_k2,
            DROP COLUMN IF EXISTS jumlah_k3,
            DROP COLUMN IF EXISTS jumlah_k4,
            DROP COLUMN IF EXISTS attachment_uuid
        ");
    }

}