<?php

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

/**
 * Class UmUserMigration_152
 */
class OmspanMasterDesaMigration_153 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_master_desa(
                    id SERIAL PRIMARY KEY,
                    kode_pemda VARCHAR(10),
                    kode_lokasi VARCHAR(10),
                    kode_area VARCHAR(10),
                    nama_area VARCHAR(100),
                    kode_provinsi VARCHAR(10),
                    nama_provinsi VARCHAR(100),
                    nama_pemda VARCHAR(100),
                    kode_kecamatan VARCHAR(10),
                    nama_kecamatan VARCHAR(100),
                    kode_desa VARCHAR(15),
                    nama_desa VARCHAR(100)
                );
            '
        );

        $this->batchInsert('omspan_master_desa', [
            'kode_pemda',
            'kode_lokasi',
            'kode_area',
            'nama_area',
            'kode_provinsi',
            'nama_provinsi',
            'nama_pemda',
            'kode_kecamatan',
            'nama_kecamatan',
            'kode_desa',
            'nama_desa'
        ]);
    }

    /**
     * Reverse the migrations
     *
     * @return void
     */
    public function down()
    {
        self::$connection->execute('DROP TABLE jaga.omspan_master_desa;');
    }

}