<?php

use Phalcon\Mvc\Model\Migration;

class AlterSpiOPDDetailMigration_501 extends Migration {
    public function up()
    {
        self::$connection->execute("
            ALTER TABLE jaga.spi_internal_opd_detail ADD COLUMN IF NOT EXISTS int_501b numeric default 0;
            ALTER TABLE jaga.spi_external_opd_detail ADD COLUMN IF NOT EXISTS ext_405b numeric default 0;
            ALTER TABLE jaga.spi_external_opd_detail ADD COLUMN IF NOT EXISTS ext_407b numeric default 0;
            ALTER TABLE jaga.spi_external_opd_detail ADD COLUMN IF NOT EXISTS ext_407c numeric default 0;
        ");
    }

    public function down()
    {
        self::$connection->execute("
            ALTER TABLE jaga.spi_internal_opd_detail DROP COLUMN IF EXISTS int_501b;
            ALTER TABLE jaga.spi_external_opd_detail DROP COLUMN IF EXISTS ext_405b;
            ALTER TABLE jaga.spi_external_opd_detail DROP COLUMN IF EXISTS ext_407b;
            ALTER TABLE jaga.spi_external_opd_detail DROP COLUMN IF EXISTS ext_407c;
        ");
    }
}