<?php

use Phalcon\Mvc\Model\Migration;
class KorsupgahPeriodeMigration_419 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            ALTER TABLE jaga.korsupgah_periode ADD COLUMN korsupgah_verif_started_at timestamp;
            ALTER TABLE jaga.korsupgah_periode ADD COLUMN korsupgah_verif_ended_at timestamp;

            UPDATE jaga.korsupgah_periode kp SET korsupgah_verif_started_at = (SELECT bpkp_kemdagri_verif_started_at FROM jaga.korsupgah_periode WHERE id = kp.id);
            UPDATE jaga.korsupgah_periode kp SET korsupgah_verif_ended_at = (SELECT bpkp_kemdagri_verif_ended_at FROM jaga.korsupgah_periode WHERE id = kp.id);
        ");
    }

    public function down()
    {
        self::$connection->execute("
            ALTER TABLE jaga.korsupgah_periode DROP COLUMN korsupgah_verif_started_at;
            ALTER TABLE jaga.korsupgah_periode DROP COLUMN korsupgah_verif_ended_at;
        ");

    }
}