<?php

use Phalcon\Mvc\Model\Migration;

class DesaTaniMigration_350 extends Migration
{
    public function up()
    {
        $this->down();

        self::$connection->execute('
            CREATE TABLE "jaga"."desa_tani"
            (
                "id" bigserial NOT NULL,
                "direktorat" character varying(255) NOT NULL,
                "code_provinsi" character varying(5),
                "provinsi" character varying(255) NOT NULL,
                "code_kabupaten" character varying(10),
                "kabupaten" character varying(255) NOT NULL,
                "kecamatan" character varying(255),
                "desa" character varying(255),
                "penerima_kelompok_tani" character varying(255),
                "nama_ketua" character varying(255),
                "jenis_alsin_kegiatan" character varying(255),
                "merek_tipe" character varying(255),
                "jumlah" integer,
                "harga" numeric,
                "komuditas" character varying(255),
                "prapanen_pascapanen" character varying(20),
                "tahun" integer,
                "created_at" timestamp(6) without time zone NOT NULL DEFAULT now(),
                PRIMARY KEY (id)
            )
            WITH (
                OIDS = FALSE
            );
        ');
    }

    public function down()
    {

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