<?php

use Phalcon\Mvc\Model\Migration;

class KorwilAsetProgressMigration_217 extends Migration
{
    public function up()
    {
        self::$connection->execute("
        CREATE TABLE jaga.korwil_aset_progress (id serial PRIMARY KEY, id_aset_target INT NOT NULL, sertifikasi VARCHAR(255), belum_sertifikasi VARCHAR(255), keterangan TEXT, status INT,
        sertifikasi_verifikasi VARCHAR(255), belum_sertifikasi_verifikasi VARCHAR(255), keterangan_verifikasi TEXT, created_at timestamp(6) DEFAULT now(), updated_at timestamp(6) DEFAULT now(),
        deleted_at timestamp(6), submitted_by int, verified_by int
        )");
    }
    public function down()
    {
        self::$connection->execute("
            DROP TABLE jaga.korwil_aset_progress
        ");
    }
}