1 2DROP TABLE IF EXISTS customer CASCADE; 3CREATE table customer ( 4 id BIGINT not null primary key, 5 x DOUBLE PRECISION, 6 y DOUBLE PRECISION, 7 demand INTEGER, 8 opentime INTEGER, 9 closetime INTEGER, 10 servicetime INTEGER, 11 pindex BIGINT, 12 dindex BIGINT 13); 14 15 16INSERT INTO customer( 17 id, x, y, demand, opentime, closetime, servicetime, pindex, dindex) VALUES 18( 0, 40, 50, 0, 0, 1236, 0, 0, 0), 19( 1, 45, 68, -10, 912, 967, 90, 11, 0), 20( 2, 45, 70, -20, 825, 870, 90, 6, 0), 21( 3, 42, 66, 10, 65, 146, 90, 0, 75), 22( 4, 42, 68, -10, 727, 782, 90, 9, 0), 23( 5, 42, 65, 10, 15, 67, 90, 0, 7), 24( 6, 40, 69, 20, 621, 702, 90, 0, 2), 25( 7, 40, 66, -10, 170, 225, 90, 5, 0), 26( 8, 38, 68, 20, 255, 324, 90, 0, 10), 27( 9, 38, 70, 10, 534, 605, 90, 0, 4), 28( 10, 35, 66, -20, 357, 410, 90, 8, 0), 29( 11, 35, 69, 10, 448, 505, 90, 0, 1), 30( 12, 25, 85, -20, 652, 721, 90, 18, 0), 31( 13, 22, 75, 30, 30, 92, 90, 0, 17), 32( 14, 22, 85, -40, 567, 620, 90, 16, 0), 33( 15, 20, 80, -10, 384, 429, 90, 19, 0), 34( 16, 20, 85, 40, 475, 528, 90, 0, 14), 35( 17, 18, 75, -30, 99, 148, 90, 13, 0), 36( 18, 15, 75, 20, 179, 254, 90, 0, 12), 37( 19, 15, 80, 10, 278, 345, 90, 0, 15), 38( 20, 30, 50, 10, 10, 73, 90, 0, 24), 39( 21, 30, 52, -10, 914, 965, 90, 30, 0), 40( 22, 28, 52, -20, 812, 883, 90, 28, 0), 41( 23, 28, 55, 10, 732, 777, 0, 0, 103), 42( 24, 25, 50, -10, 65, 144, 90, 20, 0), 43( 25, 25, 52, 40, 169, 224, 90, 0, 27), 44( 26, 25, 55, -10, 622, 701, 90, 29, 0), 45( 27, 23, 52, -40, 261, 316, 90, 25, 0), 46( 28, 23, 55, 20, 546, 593, 90, 0, 22), 47( 29, 20, 50, 10, 358, 405, 90, 0, 26), 48( 30, 20, 55, 10, 449, 504, 90, 0, 21), 49( 31, 10, 35, -30, 200, 237, 90, 32, 0), 50( 32, 10, 40, 30, 31, 100, 90, 0, 31), 51( 33, 8, 40, 40, 87, 158, 90, 0, 37), 52( 34, 8, 45, -30, 751, 816, 90, 38, 0), 53( 35, 5, 35, 10, 283, 344, 90, 0, 39), 54( 36, 5, 45, 10, 665, 716, 0, 0, 105), 55( 37, 2, 40, -40, 383, 434, 90, 33, 0), 56( 38, 0, 40, 30, 479, 522, 90, 0, 34), 57( 39, 0, 45, -10, 567, 624, 90, 35, 0), 58( 40, 35, 30, -20, 264, 321, 90, 42, 0), 59( 41, 35, 32, -10, 166, 235, 90, 43, 0), 60( 42, 33, 32, 20, 68, 149, 90, 0, 40), 61( 43, 33, 35, 10, 16, 80, 90, 0, 41), 62( 44, 32, 30, 10, 359, 412, 90, 0, 46), 63( 45, 30, 30, 10, 541, 600, 90, 0, 48), 64( 46, 30, 32, -10, 448, 509, 90, 44, 0), 65( 47, 30, 35, -10, 1054, 1127, 90, 49, 0), 66( 48, 28, 30, -10, 632, 693, 90, 45, 0), 67( 49, 28, 35, 10, 1001, 1066, 90, 0, 47), 68( 50, 26, 32, 10, 815, 880, 90, 0, 52), 69( 51, 25, 30, 10, 725, 786, 0, 0, 101), 70( 52, 25, 35, -10, 912, 969, 90, 50, 0), 71( 53, 44, 5, 20, 286, 347, 90, 0, 58), 72( 54, 42, 10, 40, 186, 257, 90, 0, 60), 73( 55, 42, 15, -40, 95, 158, 90, 57, 0), 74( 56, 40, 5, 30, 385, 436, 90, 0, 59), 75( 57, 40, 15, 40, 35, 87, 90, 0, 55), 76( 58, 38, 5, -20, 471, 534, 90, 53, 0), 77( 59, 38, 15, -30, 651, 740, 90, 56, 0), 78( 60, 35, 5, -40, 562, 629, 90, 54, 0), 79( 61, 50, 30, -10, 531, 610, 90, 67, 0), 80( 62, 50, 35, 20, 262, 317, 90, 0, 68), 81( 63, 50, 40, 50, 171, 218, 90, 0, 74), 82( 64, 48, 30, 10, 632, 693, 0, 0, 102), 83( 65, 48, 40, 10, 76, 129, 90, 0, 72), 84( 66, 47, 35, 10, 826, 875, 90, 0, 69), 85( 67, 47, 40, 10, 12, 77, 90, 0, 61), 86( 68, 45, 30, -20, 734, 777, 90, 62, 0), 87( 69, 45, 35, -10, 916, 969, 90, 66, 0), 88( 70, 95, 30, -30, 387, 456, 90, 81, 0), 89( 71, 95, 35, 20, 293, 360, 90, 0, 77), 90( 72, 53, 30, -10, 450, 505, 90, 65, 0), 91( 73, 92, 30, -10, 478, 551, 90, 76, 0), 92( 74, 53, 35, -50, 353, 412, 90, 63, 0), 93( 75, 45, 65, -10, 997, 1068, 90, 3, 0), 94( 76, 90, 35, 10, 203, 260, 90, 0, 73), 95( 77, 88, 30, -20, 574, 643, 90, 71, 0), 96( 78, 88, 35, 20, 109, 170, 0, 0, 104), 97( 79, 87, 30, 10, 668, 731, 90, 0, 80), 98( 80, 85, 25, -10, 769, 820, 90, 79, 0), 99( 81, 85, 35, 30, 47, 124, 90, 0, 70), 100( 82, 75, 55, 20, 369, 420, 90, 0, 85), 101( 83, 72, 55, -20, 265, 338, 90, 87, 0), 102( 84, 70, 58, 20, 458, 523, 90, 0, 89), 103( 85, 68, 60, -20, 555, 612, 90, 82, 0), 104( 86, 66, 55, 10, 173, 238, 90, 0, 91), 105( 87, 65, 55, 20, 85, 144, 90, 0, 83), 106( 88, 65, 60, -10, 645, 708, 90, 90, 0), 107( 89, 63, 58, -20, 737, 802, 90, 84, 0), 108( 90, 60, 55, 10, 20, 84, 90, 0, 88), 109( 91, 60, 60, -10, 836, 889, 90, 86, 0), 110( 92, 67, 85, 20, 368, 441, 90, 0, 93), 111( 93, 65, 85, -20, 475, 518, 90, 92, 0), 112( 94, 65, 82, -10, 285, 336, 90, 96, 0), 113( 95, 62, 80, -20, 196, 239, 90, 98, 0), 114( 96, 60, 80, 10, 95, 156, 90, 0, 94), 115( 97, 60, 85, 30, 561, 622, 0, 0, 106), 116( 98, 58, 75, 20, 30, 84, 90, 0, 95), 117( 99, 55, 80, -20, 743, 820, 90, 100, 0), 118( 100, 55, 85, 20, 647, 726, 90, 0, 99), 119( 101, 25, 30, -10, 725, 786, 90, 51, 0), 120( 102, 48, 30, -10, 632, 693, 90, 64, 0), 121( 103, 28, 55, -10, 732, 777, 90, 23, 0), 122( 104, 88, 35, -20, 109, 170, 90, 78, 0), 123( 105, 5, 45, -10, 665, 716, 90, 36, 0), 124( 106, 60, 85, -30, 561, 622, 90, 97, 0); 125