<?php

use Phalcon\Mvc\Model\Migration;

class BPJSPuskesmasMigration_314 extends Migration
{
    public function up()
    {
        $this->down(); 
        
        self::$connection->execute('
            CREATE TABLE "jaga"."bpjs_puskesmas"
            (
                id bigserial NOT NULL,
                "kodepuskesmas" character varying(20) NOT NULL,
                "namapuskesmas" character varying(255),
                "kodepropinsi" character varying(3),
                "kodepropinsikemendagri" character varying(3),
                "namapropinsi" character varying(255),
                "kodedati2" character varying(8),
                "kodedati2kemendagri" character varying(8),
                "namadati2" character varying(255),
                "namakec" character varying(255),
                "namadesa" character varying(255),
                "alamat" character varying(255),
                "namakepala" character varying(255),
                "namapenanggungjawab" character varying(255),
                "jumlahdokter" integer,
                "jumlahdoktergigi" integer,
                "jumlahperawat" integer,
                "jumlahapoteker" integer,
                "jumlahasistenapoteker" integer,
                "jumlahbidan" integer,
                "jumlahahligizi" integer,
                "listdokter" text,
                "listdoktergigi" text,
                "tglpengajuanpaktaintegritas" timestamp(0) without time zone,
            	"created_at" timestamp(6) DEFAULT now(),
            	"updated_at" timestamp(6) DEFAULT now(),
            	"deleted_at" timestamp(6),
                PRIMARY KEY (id)
            )
            WITH (
                OIDS = FALSE
            );
        ');

        self::$connection->execute('
            CREATE TABLE "jaga"."bpjs_puskesmas_kapitasi"
            (
                id bigserial NOT NULL,
                "kodepuskesmas" character varying(20) NOT NULL,
                "namapuskesmas" character varying(255),
                "bulan" character varying(9),
                "jumlahpeserta" int,
                "danakapitasi" numeric ,
                "tanggalproses" date,
            	"created_at" timestamp(6) DEFAULT now(),
            	"updated_at" timestamp(6) DEFAULT now(),
            	"deleted_at" timestamp(6),
                PRIMARY KEY (id)
            )
            WITH (
                OIDS = FALSE
            );
        ');

        self::$connection->execute('
            CREATE TABLE "jaga"."bpjs_provinsi"
            (
                id bigserial NOT NULL,
                "kodepropinsi" character varying(3) NOT NULL,
                "namapropinsi" character varying(255),
                "kodepropinsikemendagri" character varying(2),
            	"created_at" timestamp(6) DEFAULT now(),
            	"updated_at" timestamp(6) DEFAULT now(),
            	"deleted_at" timestamp(6),
                PRIMARY KEY (id)
            )
            WITH (
                OIDS = FALSE
            );
        ');

        self::$connection->execute('
            CREATE TABLE "jaga"."bpjs_kota_kabupaten"
            (
                id bigserial NOT NULL,
                "kodedati2" character varying(5) NOT NULL,
                "namadati2" character varying(255),
                "kodedati2kemendagri" character varying(4),
                "kodepropinsi" character varying(3),
                "kodepropinsikemendagri" character varying(2),
            	"puskesmas_last_update_at" timestamp(6),
            	"puskesmas_last_update_page" character varying (4),
            	"created_at" timestamp(6) DEFAULT now(),
            	"updated_at" timestamp(6) DEFAULT now(),
            	"deleted_at" timestamp(6),
                PRIMARY KEY (id)
            )
            WITH (
                OIDS = FALSE
            );
        ');
    }

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

        self::$connection->execute('
            DROP TABLE IF EXISTS "jaga"."bpjs_puskesmas_kapitasi";
        ');
        self::$connection->execute('
            DROP TABLE IF EXISTS "jaga"."bpjs_provinsi";
        ');

        self::$connection->execute('
            DROP TABLE IF EXISTS "jaga"."bpjs_kota_kabupaten";
        ');
    }
}