<?php

use Phalcon\Mvc\Model\Migration;

class AlterTablePancekMigration_385 extends Migration
{
    public function up()
    {
        self::$connection->execute('
            ALTER TABLE jaga.pancek_komponen_indikator ADD COLUMN IF NOT EXISTS bobot integer DEFAULT 0;
            ALTER TABLE jaga.pancek_instansi ADD COLUMN IF NOT EXISTS email char varying (100);
            ALTER TABLE jaga.pancek_instansi ADD COLUMN IF NOT EXISTS status char varying (10);
            ALTER TABLE jaga.pancek_instansi ADD COLUMN IF NOT EXISTS verified_at timestamp(6);
            ALTER TABLE jaga.pancek_instansi ADD COLUMN IF NOT EXISTS verified_by integer;
        ');
    }

    public function down()
    {
        self::$connection->execute('
            ALTER TABLE jaga.pancek_komponen_indikator DROP COLUMN IF EXISTS bobot;
            ALTER TABLE jaga.pancek_instansi DROP COLUMN IF EXISTS email;
            ALTER TABLE jaga.pancek_instansi DROP COLUMN IF EXISTS status;
            ALTER TABLE jaga.pancek_instansi DROP COLUMN IF EXISTS verified_at;
            ALTER TABLE jaga.pancek_instansi DROP COLUMN IF EXISTS verified_by;
        ');
    }
}