<?php

use Phalcon\Mvc\Model\Migration;

class KorwilAsetTargetMigration_217 extends Migration
{
    public function up()
    {
        self::$connection->execute("
        CREATE TABLE jaga.korwil_aset_target (id serial PRIMARY KEY, id_instansi INT NOT NULL, tahun VARCHAR(255), target TEXT, anggaran DOUBLE PRECISION, jumlah_bidang INT, keterangan TEXT,
        created_at timestamp(6) DEFAULT now(), updated_at timestamp(6) DEFAULT now(), deleted_at timestamp(6))");
    }
    public function down()
    {
        self::$connection->execute("
            DROP TABLE jaga.korwil_aset_target
        ");
    }
}