<?php

use Phalcon\Mvc\Model\Migration;
class KemendesMigration_410 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            CREATE TABLE IF NOT EXISTS jaga.kemendes_idm_provinsi
            (
                id serial NOT NULL primary key,
                id_prov character varying(2) NOT NULL,
                nama character varying(255) NOT NULL,
                ranking integer,
                total_desa integer,
                tahun integer,
                status_current_year character varying(255),
                status_last_year character varying(255),
                created_at timestamp(6) DEFAULT now(),
                updated_at timestamp(6),
                deleted_at timestamp(6)
            );
            CREATE TABLE IF NOT EXISTS jaga.kemendes_idm_kabupaten
            (
                id serial NOT NULL primary key,
                id_prov character varying(2) NOT NULL,
                nama_prov character varying(255),
                id_kab character varying(4) NOT NULL,
                nama character varying(255) NOT NULL,
                ranking integer,
                status character varying(100),
                total_desa integer,
                total_verified integer,
                tahun integer,
                status_current_year character varying(255),
                status_last_year character varying(255),
                created_at timestamp(6) DEFAULT now(),
                updated_at timestamp(6),
                deleted_at timestamp(6)
            );
        ");
    }

    public function down()
    {
        self::$connection->execute("
            DROP TABLE IF EXISTS jaga.kemendes_idm_provinsi;
            DROP TABLE IF EXISTS jaga.kemendes_idm_kabupaten;
        ");
    }
}