<?php

use Phalcon\Mvc\Model\Migration;

class AlterTableOmspanMigration_519 extends Migration {
    public function up()
    {
        self::$connection->execute("ALTER TABLE jaga.omspan_penyerapan_dana_desa ALTER COLUMN realisasi_tahap_1 type numeric(18,2)");
        self::$connection->execute("ALTER TABLE jaga.omspan_penyerapan_dana_desa ALTER COLUMN realisasi_tahap_2 type numeric(18,2)");
        self::$connection->execute("ALTER TABLE jaga.omspan_penyerapan_dana_desa ALTER COLUMN realisasi_tahap_3 type numeric(18,2)");
    }

    public function down()
    {
        self::$connection->execute("ALTER TABLE jaga.omspan_penyerapan_dana_desa ALTER COLUMN realisasi_tahap_1 type bigint");
        self::$connection->execute("ALTER TABLE jaga.omspan_penyerapan_dana_desa ALTER COLUMN realisasi_tahap_2 type bigint");
        self::$connection->execute("ALTER TABLE jaga.omspan_penyerapan_dana_desa ALTER COLUMN realisasi_tahap_3 type bigint");
    }
}