<?php 

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

/**
 * Class ProfilDaerahMigration_297
 */
class ProfilDaerahMigration_297 extends Migration
{
    /**
     * Run the migrations
     *
     * @return void
     */
    public function up()
    {
        self::$connection->execute('
            DROP TABLE IF EXISTS "jaga"."profil_daerah";
            CREATE TABLE "jaga"."profil_daerah" (
            "id" serial NOT NULL,
            "nama_wilayah" varchar(100) COLLATE "default" NOT NULL,
            "code_klpd" int4 NOT NULL,
            "jenis" varchar(10) COLLATE "default" NOT NULL,
            "nama_kepala_daerah" varchar(100) COLLATE "default",
            "jabatan_kepala_daerah" varchar(100) COLLATE "default",
            "nama_wakil_kepala_daerah" varchar(100) COLLATE "default",
            "jabatan_wakil_kepala_daerah" varchar(100) COLLATE "default",
            "audit_bpk" varchar(5) COLLATE "default",
            "keterangan_bpk" text COLLATE "default",
            "nilai_lakip" numeric,
            "keterangan_lakip" text COLLATE "default",
            "nilai_ptk" numeric,
            "keterangan_ptk" text COLLATE "default",
            "created_at" timestamp(6) DEFAULT now(),
            "updated_at" timestamp(6) DEFAULT now(),
            "deleted_at" timestamp(6)
            )
            WITH (OIDS=FALSE)
            ;
            ALTER TABLE "jaga"."profil_daerah" ADD PRIMARY KEY ("id");
        ');
    }

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

}