<?php

use Phalcon\Mvc\Model\Migration;

class OmspanMasterProvinsiMigration_324 extends Migration
{
    public function up()
    {
        self::$connection->execute("
            DROP TABLE IF EXISTS jaga.omspan_master_provinsi;
            CREATE TABLE IF NOT EXISTS jaga.omspan_master_provinsi
                (
                    kd_prov CHARACTER VARYING(2) PRIMARY KEY,
                    nm_prov CHARACTER VARYING(100) NOT NULL
                )
            WITH (OIDS = FALSE);
            
            INSERT INTO jaga.omspan_master_provinsi VALUES('01', 'DKI JAKARTA');
            INSERT INTO jaga.omspan_master_provinsi VALUES('02', 'JAWA BARAT');
            INSERT INTO jaga.omspan_master_provinsi VALUES('03', 'JAWA TENGAH');
            INSERT INTO jaga.omspan_master_provinsi VALUES('04', 'DI YOGYAKARTA');
            INSERT INTO jaga.omspan_master_provinsi VALUES('05', 'JAWA TIMUR');
            INSERT INTO jaga.omspan_master_provinsi VALUES('06', 'ACEH');
            INSERT INTO jaga.omspan_master_provinsi VALUES('07', 'SUMATERA UTARA');
            INSERT INTO jaga.omspan_master_provinsi VALUES('08', 'SUMATERA BARAT');
            INSERT INTO jaga.omspan_master_provinsi VALUES('09', 'RIAU');
            INSERT INTO jaga.omspan_master_provinsi VALUES('10', 'JAMBI');
            INSERT INTO jaga.omspan_master_provinsi VALUES('11', 'SUMATERA SELATAN');
            INSERT INTO jaga.omspan_master_provinsi VALUES('12', 'LAMPUNG');
            INSERT INTO jaga.omspan_master_provinsi VALUES('13', 'KALIMANTAN BARAT');
            INSERT INTO jaga.omspan_master_provinsi VALUES('14', 'KALIMANTAN TENGAH');
            INSERT INTO jaga.omspan_master_provinsi VALUES('15', 'KALIMANTAN SELATAN');
            INSERT INTO jaga.omspan_master_provinsi VALUES('16', 'KALIMANTAN TIMUR');
            INSERT INTO jaga.omspan_master_provinsi VALUES('17', 'SULAWESI UTARA');
            INSERT INTO jaga.omspan_master_provinsi VALUES('18', 'SULAWESI TENGAH');
            INSERT INTO jaga.omspan_master_provinsi VALUES('19', 'SULAWESI SELATAN');
            INSERT INTO jaga.omspan_master_provinsi VALUES('20', 'SULAWESI TENGGARA');
            INSERT INTO jaga.omspan_master_provinsi VALUES('21', 'MALUKU');
            INSERT INTO jaga.omspan_master_provinsi VALUES('22', 'BALI');
            INSERT INTO jaga.omspan_master_provinsi VALUES('23', 'NUSA TENGGARA BARAT');
            INSERT INTO jaga.omspan_master_provinsi VALUES('24', 'NUSA TENGGARA TIMUR');
            INSERT INTO jaga.omspan_master_provinsi VALUES('25', 'PAPUA');
            INSERT INTO jaga.omspan_master_provinsi VALUES('26', 'BENGKULU');
            INSERT INTO jaga.omspan_master_provinsi VALUES('28', 'MALUKU UTARA');
            INSERT INTO jaga.omspan_master_provinsi VALUES('29', 'BANTEN');
            INSERT INTO jaga.omspan_master_provinsi VALUES('30', 'KEPULAUAN BANGKA BELITUNG');
            INSERT INTO jaga.omspan_master_provinsi VALUES('31', 'GORONTALO');
            INSERT INTO jaga.omspan_master_provinsi VALUES('32', 'KEPULAUAN RIAU');
            INSERT INTO jaga.omspan_master_provinsi VALUES('33', 'PAPUA BARAT');
            INSERT INTO jaga.omspan_master_provinsi VALUES('34', 'SULAWESI BARAT');
            INSERT INTO jaga.omspan_master_provinsi VALUES('35', 'KALIMANTAN UTARA');
        ");
    }

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