<?php

use Phalcon\Mvc\Model\Migration;

class AlterMcpAssetTablesMigration_504 extends Migration {
    public function up() {
        $query = "
            ALTER TABLE jaga.aset_sertifikasi_new
                DROP COLUMN IF EXISTS jumlah_sertifikat_diproses,
                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;
            ALTER TABLE jaga.aset_penertiban_sarpras_new
                ADD COLUMN IF NOT EXISTS created_by integer,
                ADD COLUMN IF NOT EXISTS created_at timestamp(6) without time zone DEFAULT now(),
                ADD COLUMN IF NOT EXISTS updated_by integer,
                ADD COLUMN IF NOT EXISTS updated_at timestamp(6) without time zone NULL,
                ADD COLUMN IF NOT EXISTS deleted_by integer,
                ADD COLUMN IF NOT EXISTS deleted_at timestamp(6) without time zone NULL;
        ";
        self::$connection->execute($query);
    }

    public function down() {
        $query = "
        ALTER TABLE jaga.aset_sertifikasi_new
            ADD COLUMN IF NOT EXISTS jumlah_sertifikat_diproses integer NULL,
            DROP COLUMN IF EXISTS jumlah_k1,
            DROP COLUMN IF EXISTS jumlah_k2,
            DROP COLUMN IF EXISTS jumlah_k3,
            DROP COLUMN IF EXISTS jumlah_k4;
        ALTER TABLE jaga.aset_penertiban_sarpras_new
            DROP COLUMN IF EXISTS created_by,
            DROP COLUMN IF EXISTS created_at,
            DROP COLUMN IF EXISTS updated_by,
            DROP COLUMN IF EXISTS updated_at,
            DROP COLUMN IF EXISTS deleted_by,
            DROP COLUMN IF EXISTS deleted_at;
        ";
        self::$connection->execute($query);
    }
}