<?php 

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

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

    /**
     * Run the migrations
     *
     * @return void
     */
    public function up()
    {
		self::$connection->execute(
			'
				CREATE TABLE jaga.omspan_penyerapan_dana_desa
				(
					id serial NOT NULL,
					kode_lokasi character varying(10) NOT NULL,
					kode_desa character varying(10) NOT NULL,
					tahun integer NOT NULL,
					kode_uraian_output character varying(10) NOT NULL,
					volume integer,
					satuan_output character varying(255),
					cara_pengadaan character varying(255),
					realisasi_tahap_1 bigint DEFAULT 0,
					realisasi_tahap_2 bigint DEFAULT 0,
					realisasi_tahap_3 bigint DEFAULT 0,
					persentase_realisasi_tahap_1 integer DEFAULT 0,
					persentase_realisasi_tahap_2 integer DEFAULT 0,
					persentase_realisasi_tahap_3 integer DEFAULT 0,
					keterangan text,
					PRIMARY KEY (id),
					FOREIGN KEY (kode_desa)
						REFERENCES jaga.desa_master_desa ("kode_PUM") MATCH SIMPLE
						ON UPDATE NO ACTION
						ON DELETE NO ACTION,
					FOREIGN KEY (kode_uraian_output)
						REFERENCES jaga.desa_uraian_output_penyerapan (kode) MATCH SIMPLE
						ON UPDATE NO ACTION
						ON DELETE NO ACTION
				);
			'
		);
    }

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

    }

}