<?php

use Phalcon\Mvc\Model\Migration;

class KemdagriBansosCovid19Migration_245 extends Migration
{
    public function up()
    {
        self::$connection->execute('
            CREATE TABLE IF NOT EXISTS "jaga"."kemdagri_bansos_covid19" (
                id SERIAL PRIMARY KEY,
                kode_provinsi int4,
                kode_kota_kabupaten int4,
                nama_pemda varchar(255),
                pk_keg float8,
                pk_bansos float8,
                pk_btt float8,
                pk_total float8,
                pde_keg float8,
                pde_bansos float8,
                pde_btt float8,
                pde_total float8,
                jps_keg float8,
                jps_bansos float8,
                jps_btt float8,
                jps_total float8,
                total_keg float8,
                total_bansos float8,
                total_btt float8,
                total float8,
                apbd_pdp float8,
                apbd_blj float8,
                persen_blj float8,
                amj date,
                gelombang_pkd varchar(255),
                tahun_gelombang int4,
                pilkada int4
            );


        ');

        $this->batchInsert('kemdagri_bansos_covid19', [
            'id',
            'kode_provinsi',
            'kode_kota_kabupaten',
            'nama_pemda',
            'pk_keg',
            'pk_bansos',
            'pk_btt',
            'pk_total',
            'pde_keg',
            'pde_bansos',
            'pde_btt',
            'pde_total',
            'jps_keg',
            'jps_bansos',
            'jps_btt',
            'jps_total',
            'total_keg',
            'total_bansos',
            'total_btt',
            'total',
            'apbd_pdp',
            'apbd_blj',
            'persen_blj',
            'amj',
            'gelombang_pkd',
            'tahun_gelombang',
            'pilkada'
        ]);

        self::$connection->execute("SELECT setval('kemdagri_bansos_covid19_id_seq', (SELECT MAX(id) FROM jaga.kemdagri_bansos_covid19));");
    }
}