<?php

use Phalcon\Mvc\Model\Migration;

class AsetPenertibanMigration_325 extends Migration
{
    public function up()
    {
        $this->down(); 
        
        self::$connection->execute('
            CREATE TABLE IF NOT EXISTS "jaga"."aset_penertiban"
            (
                id SERIAL PRIMARY KEY,
                instansi_id INTEGER,
                tahun INTEGER,
                periode VARCHAR(255),
                uraian VARCHAR(255),
                unit_tanahbangunan INTEGER,
                luas_tanahbangunan DOUBLE PRECISION,
                nilai_tanahbangunan NUMERIC(18,2),
                unit_kendaraan INTEGER,
                nilai_kendaraan NUMERIC(18,2),
                nilai_total NUMERIC(18,2),
                created_at timestamp(6) DEFAULT now(),
                updated_at timestamp(6) DEFAULT now(),
                deleted_at timestamp(6)
            )
            WITH (
                OIDS = FALSE
            );
        ');
    }

    public function down()
    {
        self::$connection->execute('
            DROP TABLE IF EXISTS "jaga"."aset_penertiban";
        ');
    }
}