<?php

use Phalcon\Mvc\Model\Migration;

class AlterElhkpnKepatuhanPersonMigration_451 extends Migration {
    // public function up()
    // {
    //     self::$connection->execute("
    //         ALTER TABLE jaga.elhkpn_kepatuhan_person ADD COLUMN IF NOT EXISTS total_harta_tidak_bergerak character varying(100);
    //         ALTER TABLE jaga.elhkpn_kepatuhan_person ADD COLUMN IF NOT EXISTS total_alat_transportasi character varying(100);
    //         ALTER TABLE jaga.elhkpn_kepatuhan_person ADD COLUMN IF NOT EXISTS total_harta_bergerak_lain character varying(100);
    //         ALTER TABLE jaga.elhkpn_kepatuhan_person ADD COLUMN IF NOT EXISTS total_surat_berharga character varying(100);
    //         ALTER TABLE jaga.elhkpn_kepatuhan_person ADD COLUMN IF NOT EXISTS total_kas character varying(100);
    //         ALTER TABLE jaga.elhkpn_kepatuhan_person ADD COLUMN IF NOT EXISTS total_harta_lainnya character varying(100);
    //         ALTER TABLE jaga.elhkpn_kepatuhan_person ADD COLUMN IF NOT EXISTS total_hutang character varying(100);
    //     ");
    // }

    public function down()
    {
        self::$connection->execute("
            ALTER TABLE jaga.elhkpn_kepatuhan_person DROP COLUMN IF EXISTS total_harta_tidak_bergerak;
            ALTER TABLE jaga.elhkpn_kepatuhan_person DROP COLUMN IF EXISTS total_alat_transportasi;
            ALTER TABLE jaga.elhkpn_kepatuhan_person DROP COLUMN IF EXISTS total_harta_bergerak_lain;
            ALTER TABLE jaga.elhkpn_kepatuhan_person DROP COLUMN IF EXISTS total_surat_berharga;
            ALTER TABLE jaga.elhkpn_kepatuhan_person DROP COLUMN IF EXISTS total_kas;
            ALTER TABLE jaga.elhkpn_kepatuhan_person DROP COLUMN IF EXISTS total_harta_lainnya;
            ALTER TABLE jaga.elhkpn_kepatuhan_person DROP COLUMN IF EXISTS total_hutang;
        ");
    }
}