<?php 

use Phalcon\Db\Column;
use Phalcon\Db\Index;
use Phalcon\Db\Reference;
use Phalcon\Mvc\Model\Migration;

/**
 * Class PuskesmasKapitasiMigration_144
 */
class PuskesmasKapitasiMigration_144 extends Migration
{
    /**
     * Define the table structure
     *
     * @return void
     */
    public function morph()
    {
        
    }

    /**
     * Run the migrations
     *
     * @return void
     */
    public function up()
    {
		self::$connection->execute(
			'
				ALTER TABLE jaga.puskesmas_kapitasi DROP COLUMN bulan_angka;

				ALTER TABLE jaga.puskesmas_kapitasi
					ADD COLUMN kapitasi_yang_dibayarkan integer NOT NULL DEFAULT 0;
				update jaga.puskesmas_kapitasi A
				set kapitasi_yang_dibayarkan = (
					select cast(coalesce(replace(replace(total_kapitasi_yang_dibayarkan, \'Rp\', \'\'), \'.\',\'\'),\'0\') as integer)
					from jaga.puskesmas_kapitasi B where B.id = A.id
				);
			'
		);
    }

    /**
     * Reverse the migrations
     *
     * @return void
     */
    public function down()
    {

    }

}