<?php
use Phalcon\Mvc\Model\Migration;

class KorwilPadTargetMigration_217 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            CREATE TABLE jaga.korwil_pad_target (
            id serial PRIMARY KEY,
            id_instansi INT,
            tahun VARCHAR,
            nilai DOUBLE PRECISION,
            created_at timestamp(6) DEFAULT now(),
            updated_at timestamp(6) DEFAULT now(),
            deleted_at timestamp(6),
            created_by int,
            updated_by int
        )");
    }
    public function down()
    {
        self::$connection->execute("
            DROP TABLE jaga.korwil_pad_target
        ");
    }
}