<?php

use Phalcon\Mvc\Model\Migration;

class SipdMigration_220 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            CREATE TABLE jaga.sipd_master_bidang (
                id serial primary key,
                kode varchar,
                urai varchar
            );
        ");

        self::$connection->execute("
            CREATE TABLE jaga.sipd_master_program (
                id serial primary key,
                kode_bidang varchar,
                kode varchar,
                urai varchar
            );
        ");

        self::$connection->execute("
            CREATE TABLE jaga.sipd_skpd (
                id serial primary key,
                kode_bidang varchar,
                kode_pemda varchar,
                tahun INT,
                kode varchar,
                urai_urusan varchar
            );
        ");

        self::$connection->execute("
            CREATE TABLE jaga.sipd_program (
                id serial primary key,
                id_skpd INT,
                id_program INT
            );
        ");

        self::$connection->execute("
            CREATE TABLE jaga.sipd_kegiatan (
                id serial primary key,
                kode_kegiatan varchar,
                urai_kegiatan varchar,
                pagu decimal,
                pagu_p decimal
            );
        ");

        self::$connection->execute("
            CREATE TABLE jaga.sipd_kegiatan_lokasi (
                id serial primary key,
                kode_lokasi INT,
                id_kegiatan INT
            );
        ");
    }
    public function down()
    {
        // Do Nothing
    }
}