<?php

use Phalcon\Mvc\Model\Migration;

class InstansiMigration_283 extends Migration
{
    public function up()
    {
        self::$connection->execute('
            ALTER TABLE "jaga"."instansi" ADD IF NOT EXISTS flag_dana_desa INT DEFAULT 0;
            
            --Provinsi Aceh
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (101, 103, 105, 106, 108, 109, 110, 111, 158, 404, 450, 520,
            587, 556, 557, 204, 102, 104, 361, 107, 148, 405, 597);

            --Provinsi Sumatera Utara
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (114, 190, 192 ,241, 283, 295, 329, 368, 449, 487, 488, 489,
            499, 570, 382, 370, 221, 441, 430, 143, 379, 380, 284, 285,
            371, 369, 544);

            --Provinsi Sumatera Barat
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (300, 112, 252, 381, 389, 403, 447, 455, 481, 590, 578, 390,
            194, 456);

            --Provinsi Riau
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (149, 222, 223, 234, 274, 397, 424, 425, 427, 253);

            --Provinsi Jambi
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (142, 178, 260, 340, 352, 434, 485, 486, 492, 599);

            --Provinsi Sumatera Selatan
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (286, 357, 358, 351, 374, 375, 585, 133, 373, 377, 376, 198,
            400, 359);

            --Provinsi Bengkulu
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (151, 153, 422, 243, 436, 353, 298, 249, 152);

            --Provinsi Lampung
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (289, 290, 291, 293, 292, 484, 507, 512, 401, 411, 342, 506,
            402);

            --Provinsi Jawa Barat
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (118, 144, 162, 186, 187, 189, 203, 224, 239, 278, 314, 419, 
            461, 462, 471, 491, 523, 119, 385);

            --Provinsi Jawa Tengah
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (130, 134, 141, 160, 173, 174, 188, 193, 210, 231, 238, 245,
            248, 262, 276, 311, 393, 396, 398, 418, 420, 423, 437, 460,
            464, 493, 496, 513, 514);

            --Provinsi DI Yogyakarta
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (132, 211, 277, 454);

            --Provinsi Jawa Timur
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (127, 135, 159, 163, 169, 209, 228, 232, 246, 288, 306, 310,
            312, 317, 348, 366, 367, 378, 383, 392, 409, 412, 431, 445,
            472, 504, 505, 508, 526);

            --Provinsi Kalimantan Barat
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (150, 294, 236, 261, 339, 429, 432, 452, 435, 338, 244, 275);

            --Provinsi Kalimantan Tengah
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (137, 139, 235, 272, 273, 242, 442, 463, 287, 212, 413, 356,
            138);

            --Provinsi Kalimantan Selatan
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (129, 136, 218, 219, 220, 271, 474, 482, 490, 117, 480);

            --Provinsi Kalimantan Timur
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (154, 281, 280, 282, 391, 399, 313);

            --Provinsi Sulawesi Utara
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (164, 344, 254, 258, 345, 347, 443, 554, 167, 346, 166, 165);

            --Provinsi Sulawesi Tengah
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (120, 121, 179, 501, 197, 349, 410, 388, 500, 446, 122, 350);

            --Provinsi Sulawesi Selatan
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (131, 140, 170, 176, 200, 208, 230, 307, 309, 336, 386, 308,
            406, 451, 255, 444, 457, 476, 479, 509, 503);

            --Provinsi Sulawesi Tenggara
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (182, 267, 264, 354, 269, 168, 510, 266, 270, 185, 268, 265,
            355, 184, 183);

            --Provinsi Bali
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (116, 128, 175, 205, 229, 237, 263, 475, 541);

            --Provinsi Nusa Tenggara Barat
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (156, 196, 302, 303, 304, 469, 470, 305);

            --Provinsi Nusa Tenggara Timur
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (113, 147, 199, 202, 279, 299, 330, 365, 448, 465, 468, 497,
            498, 426, 331, 362, 466, 467, 332, 428, 316);

            --Provinsi Maluku
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (322, 320, 321, 180, 517, 438, 439, 251, 613, 319, 181);

            --Provinsi Papua
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (155, 226, 227, 341, 343, 360, 387, 417, 259, 551, 433, 247,
            515, 395, 502, 172, 335, 115, 511, 473, 324, 325, 516, 296, 
            364, 195, 416, 225, 191);

            --Provinsi Maluku Utara
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (215, 213, 216, 214, 217, 257, 611, 414, 415);

            --Provinsi Banten
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (297, 384, 440, 483);

            --Provinsi Bangka Belitung
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (123, 145, 125, 126, 124, 146);

            --Provinsi Gorontalo
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (161, 206, 407, 171, 207);

            --Provinsi Kepulauan Riau
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (363, 250, 240, 301, 157);

            --Provinsi Papua Barat
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (201, 333, 458, 421, 459, 494, 495, 233, 337, 477, 334, 394);

            --Provinsi Sulawesi Barat
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (315, 326, 408, 323, 328, 327);

            --Provinsi Kalimantan Utara
            UPDATE "jaga"."instansi" SET flag_dana_desa = 1 WHERE id IN
            (177, 318, 372, 478);
        ');
    }
}