<?php
use Phalcon\Mvc\Model\Migration;

class PerizinanKontakMigration_227 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            CREATE TABLE jaga.perizinan_kontak (
                id SERIAL PRIMARY KEY,
                nama_daerah VARCHAR(255),
                kepala_dinas VARCHAR(255),
                situs VARCHAR(255),
                telp_line1 VARCHAR(255),
                telp_line2 VARCHAR(255),
                fax VARCHAR(255),
                alamat_kantor VARCHAR(255),
                provinsi VARCHAR(255),
                latitude VARCHAR(255),
                longitude VARCHAR(255),
                created_date timestamp(6) DEFAULT now(),
                update_date timestamp(6) DEFAULT now()
            );
        ");
        $this->batchInsert('perizinan_kontak', [
            'nama_daerah',
            'kepala_dinas',
            'situs',
            'telp_line1',
            'telp_line2',
            'fax',
            'alamat_kantor',
            'provinsi',
            'latitude',
            'longitude'
        ]);

        self::$connection->execute("SELECT setval('perizinan_kontak_id_seq', (SELECT MAX(id) FROM jaga.perizinan_kontak));");
    }
    public function down()
    {
        self::$connection->execute("
            DROP TABLE jaga.perizinan_kontak
        ");
    }
}