<?php

use Phalcon\Mvc\Model\Migration;

class OmspanMasterPemdaMigration_443 extends Migration {
    public function up()
    {
        $this->down();
        self::$connection->execute("
            INSERT INTO jaga.omspan_master_provinsi (kd_prov, nm_prov) VALUES ('36', 'PAPUA SELATAN');
            INSERT INTO jaga.omspan_master_provinsi (kd_prov, nm_prov) VALUES ('37', 'PAPUA TENGAH');
            INSERT INTO jaga.omspan_master_provinsi (kd_prov, nm_prov) VALUES ('38', 'PAPUA PEGUNUNGAN');
            INSERT INTO jaga.omspan_master_provinsi (kd_prov, nm_prov) VALUES ('39', 'PAPUA BARAT DAYA');

            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3601', '36', 'KAB. MERAUKE');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3602', '36', 'KAB. BOVEN DIGOEL');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3603', '36', 'KAB. MAPPI');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3604', '36', 'KAB. ASMAT');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3701', '37', 'KAB. MIMIKA');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3702', '37', 'KAB. NABIRE');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3703', '37', 'KAB. PANIAI');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3704', '37', 'KAB. PUNCAK JAYA');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3705', '37', 'KAB. PUNCAK');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3706', '37', 'DOGIYAI');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3707', '37', 'KAB. INTAN JAYA');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3708', '37', 'KAB. DEIYAI');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3801', '38', 'KAB. JAYAWIJAYA');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3802', '38', 'KAB. YAHUKIMO');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3803', '38', 'KAB. TOLIKARA');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3804', '38', 'MAMBERAMO TENGAH');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3805', '38', 'YALIMO');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3806', '38', 'KAB. PEGUNUNGAN BINTANG');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3807', '38', 'KAB. LANNY JAYA');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3808', '38', 'NDUGA');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3902', '39', 'KAB. SORONG');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3903', '39', 'KAB. SORONG SELATAN');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3904', '39', 'KAB. RAJA AMPAT');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3905', '39', 'KAB. TAMBRAUW');
            INSERT INTO jaga.omspan_master_pemda (kd_lokasi, kd_prov, nm_lokasi) VALUES ('3906', '39', 'KAB. MAYBRAT');

            UPDATE jaga.omspan_master_pemda SET nm_lokasi = 'KAB. PASANGKAYU' WHERE kd_lokasi = '3403';
        ");
    }

    public function down()
    {
        self::$connection->execute("
            DELETE FROM jaga.omspan_master_provinsi WHERE kd_prov = '36';
            DELETE FROM jaga.omspan_master_provinsi WHERE kd_prov = '37';
            DELETE FROM jaga.omspan_master_provinsi WHERE kd_prov = '38';
            DELETE FROM jaga.omspan_master_provinsi WHERE kd_prov = '39';

            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3601';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3602';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3603';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3604';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3701';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3702';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3703';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3704';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3705';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3706';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3707';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3708';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3801';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3802';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3803';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3804';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3805';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3806';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3807';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3808';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3902';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3903';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3904';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3905';
            DELETE FROM jaga.omspan_master_pemda WHERE kd_lokasi = '3906';

            UPDATE jaga.omspan_master_pemda SET nm_lokasi = 'KAB. MAMUJU UTARA' WHERE kd_lokasi = '3403';
        ");
    }
}