<?php

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

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

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

    }
}