Skip to content
Snippets Groups Projects
Select Git revision
  • be5f73c9547f3fb2c63e784fd2d0a1987fdda713
  • main
  • sar-277-update-docs-with-examples-for-lrc
  • st-946-automate
  • sar_302-log-fix
  • sar-287_subarray_commands_to_lrc
  • sar_302-POC_await_sub_device_state
  • sat_302_fix_pipelines
  • sar-286_lrc_one_subarry_command
  • sar-286_lrc_improvements
  • sar-288-async-controller
  • sar-276-combine-tango-queue
  • sar-255_remove_nexus_reference
  • sar-275-add-LRC
  • sar-273-add-lrc-attributes
  • sar-272
  • sp-1106-marvin-1230525148-ska-tango-base
  • sp-1106-marvin-813091765-ska-tango-base
  • sar-255/Publish-package-to-CAR
  • mccs-661-device-under-test-fixture
  • mccs-659-pep257-docstring-linting
  • 0.11.3
  • 0.11.2
  • 0.11.1
  • 0.11.0
  • 0.10.1
  • 0.10.0
  • 0.9.1
  • 0.9.0
  • 0.8.1
  • 0.8.0
  • 0.7.2
  • 0.7.1
  • 0.7.0
  • 0.6.6
  • 0.6.5
  • 0.6.4
  • 0.6.3
  • 0.6.2
  • 0.6.1
  • 0.6.0
41 results

queue_manager.rst

Blame
  • Code owners
    Assign users and groups as approvers for specific file changes. Learn more.
    add_virtual_instrument.sql 27.57 KiB
    -- This file was generated by the 'create_add_virtual_instrument.sql.py' script.
    -- Please do not modify this sql file, but modify and the python script if you want a different virtual instrument.
    
    -- resourceassignment password for testing on mcu005 is the same as the password on the president's luggage +6
    -- psql resourceassignment -U resourceassignment -f add_virtual_instrument.sql -W
    BEGIN;
    -- start with clearing the old virtual instrument model
    -- for some reason truncate takes a looooong time to complete, so use delete from
    DELETE FROM virtual_instrument.resource_group_to_resource_group CASCADE;
    DELETE FROM virtual_instrument.resource_to_resource_group CASCADE;
    DELETE FROM virtual_instrument.resource_group CASCADE;
    DELETE FROM virtual_instrument.resource_group_type CASCADE;
    DELETE FROM virtual_instrument.resource CASCADE;
    DELETE FROM virtual_instrument.resource_type CASCADE;
    DELETE FROM virtual_instrument.unit CASCADE;
    -- end of initial cleanup
    
    INSERT INTO virtual_instrument.unit VALUES (0, 'rsp_channel_bit'), (1, 'bytes'), (2, 'rcu_board'), (3, 'bits/second'), (4, 'cores');
    INSERT INTO virtual_instrument.resource_type VALUES (0, 'rsp', 0), (1, 'tbb', 1), (2, 'rcu', 2), (3, 'bandwidth', 3), (4, 'processor', 4), (5, 'storage', 1);
    INSERT INTO virtual_instrument.resource_group_type VALUES (0, 'instrument'), (1, 'cluster'), (2, 'station_group'), (3, 'station'), (4, 'node_group'), (5, 'node');
    INSERT INTO virtual_instrument.resource_group VALUES (0, 'LOFAR', 0), (1, 'CEP4', 1), (2, 'Cobalt', 1), (3, 'computenodes', 4), (4, 'gpunodes', 4), (5, 'cpunode01', 5), (6, 'cpunode02', 5), (7, 'cpunode03', 5), (8, 'cpunode04', 5), (9, 'cpunode05', 5), (10, 'cpunode06', 5), (11, 'cpunode07', 5), (12, 'cpunode08', 5), (13, 'cpunode09', 5), (14, 'cpunode10', 5), (15, 'cpunode11', 5), (16, 'cpunode12', 5), (17, 'cpunode13', 5), (18, 'cpunode14', 5), (19, 'cpunode15', 5), (20, 'cpunode16', 5), (21, 'cpunode17', 5), (22, 'cpunode18', 5), (23, 'cpunode19', 5), (24, 'cpunode20', 5), (25, 'cpunode21', 5), (26, 'cpunode22', 5), (27, 'cpunode23', 5), (28, 'cpunode24', 5), (29, 'cpunode25', 5), (30, 'cpunode26', 5), (31, 'cpunode27', 5), (32, 'cpunode28', 5), (33, 'cpunode29', 5), (34, 'cpunode30', 5), (35, 'cpunode31', 5), (36, 'cpunode32', 5), (37, 'cpunode33', 5), (38, 'cpunode34', 5), (39, 'cpunode35', 5), (40, 'cpunode36', 5), (41, 'cpunode37', 5), (42, 'cpunode38', 5), (43, 'cpunode39', 5), (44, 'cpunode40', 5), (45, 'cpunode41', 5), (46, 'cpunode42', 5), (47, 'cpunode43', 5), (48, 'cpunode44', 5), (49, 'cpunode45', 5), (50, 'cpunode46', 5), (51, 'cpunode47', 5), (52, 'cpunode48', 5), (53, 'cpunode49', 5), (54, 'cpunode50', 5), (55, 'cbt001', 5), (56, 'cbt002', 5), (57, 'cbt003', 5), (58, 'cbt004', 5), (59, 'cbt005', 5), (60, 'cbt006', 5), (61, 'cbt007', 5), (62, 'cbt008', 5), (63, 'DRAGNET', 1), (64, 'drgnodes', 4), (65, 'dragproc', 5), (66, 'drg01', 5), (67, 'drg02', 5), (68, 'drg03', 5), (69, 'drg04', 5), (70, 'drg05', 5), (71, 'drg06', 5), (72, 'drg07', 5), (73, 'drg08', 5), (74, 'drg09', 5), (75, 'drg10', 5), (76, 'drg11', 5), (77, 'drg12', 5), (78, 'drg13', 5), (79, 'drg14', 5), (80, 'drg15', 5), (81, 'drg16', 5), (82, 'drg17', 5), (83, 'drg18', 5), (84, 'drg19', 5), (85, 'drg20', 5), (86, 'drg21', 5), (87, 'drg22', 5), (88, 'drg23', 5);
    INSERT INTO virtual_instrument.resource VALUES (0, 'cpunode01_bandwidth', 3), (1, 'cpunode01_processor', 4), (2, 'cpunode02_bandwidth', 3), (3, 'cpunode02_processor', 4), (4, 'cpunode03_bandwidth', 3), (5, 'cpunode03_processor', 4), (6, 'cpunode04_bandwidth', 3), (7, 'cpunode04_processor', 4), (8, 'cpunode05_bandwidth', 3), (9, 'cpunode05_processor', 4), (10, 'cpunode06_bandwidth', 3), (11, 'cpunode06_processor', 4), (12, 'cpunode07_bandwidth', 3), (13, 'cpunode07_processor', 4), (14, 'cpunode08_bandwidth', 3), (15, 'cpunode08_processor', 4), (16, 'cpunode09_bandwidth', 3), (17, 'cpunode09_processor', 4), (18, 'cpunode10_bandwidth', 3), (19, 'cpunode10_processor', 4), (20, 'cpunode11_bandwidth', 3), (21, 'cpunode11_processor', 4), (22, 'cpunode12_bandwidth', 3), (23, 'cpunode12_processor', 4), (24, 'cpunode13_bandwidth', 3), (25, 'cpunode13_processor', 4), (26, 'cpunode14_bandwidth', 3), (27, 'cpunode14_processor', 4), (28, 'cpunode15_bandwidth', 3), (29, 'cpunode15_processor', 4), (30, 'cpunode16_bandwidth', 3), (31, 'cpunode16_processor', 4), (32, 'cpunode17_bandwidth', 3), (33, 'cpunode17_processor', 4), (34, 'cpunode18_bandwidth', 3), (35, 'cpunode18_processor', 4), (36, 'cpunode19_bandwidth', 3), (37, 'cpunode19_processor', 4), (38, 'cpunode20_bandwidth', 3), (39, 'cpunode20_processor', 4), (40, 'cpunode21_bandwidth', 3), (41, 'cpunode21_processor', 4), (42, 'cpunode22_bandwidth', 3), (43, 'cpunode22_processor', 4), (44, 'cpunode23_bandwidth', 3), (45, 'cpunode23_processor', 4), (46, 'cpunode24_bandwidth', 3), (47, 'cpunode24_processor', 4), (48, 'cpunode25_bandwidth', 3), (49, 'cpunode25_processor', 4), (50, 'cpunode26_bandwidth', 3), (51, 'cpunode26_processor', 4), (52, 'cpunode27_bandwidth', 3), (53, 'cpunode27_processor', 4), (54, 'cpunode28_bandwidth', 3), (55, 'cpunode28_processor', 4), (56, 'cpunode29_bandwidth', 3), (57, 'cpunode29_processor', 4), (58, 'cpunode30_bandwidth', 3), (59, 'cpunode30_processor', 4), (60, 'cpunode31_bandwidth', 3), (61, 'cpunode31_processor', 4), (62, 'cpunode32_bandwidth', 3), (63, 'cpunode32_processor', 4), (64, 'cpunode33_bandwidth', 3), (65, 'cpunode33_processor', 4), (66, 'cpunode34_bandwidth', 3), (67, 'cpunode34_processor', 4), (68, 'cpunode35_bandwidth', 3), (69, 'cpunode35_processor', 4), (70, 'cpunode36_bandwidth', 3), (71, 'cpunode36_processor', 4), (72, 'cpunode37_bandwidth', 3), (73, 'cpunode37_processor', 4), (74, 'cpunode38_bandwidth', 3), (75, 'cpunode38_processor', 4), (76, 'cpunode39_bandwidth', 3), (77, 'cpunode39_processor', 4), (78, 'cpunode40_bandwidth', 3), (79, 'cpunode40_processor', 4), (80, 'cpunode41_bandwidth', 3), (81, 'cpunode41_processor', 4), (82, 'cpunode42_bandwidth', 3), (83, 'cpunode42_processor', 4), (84, 'cpunode43_bandwidth', 3), (85, 'cpunode43_processor', 4), (86, 'cpunode44_bandwidth', 3), (87, 'cpunode44_processor', 4), (88, 'cpunode45_bandwidth', 3), (89, 'cpunode45_processor', 4), (90, 'cpunode46_bandwidth', 3), (91, 'cpunode46_processor', 4), (92, 'cpunode47_bandwidth', 3), (93, 'cpunode47_processor', 4), (94, 'cpunode48_bandwidth', 3), (95, 'cpunode48_processor', 4), (96, 'cpunode49_bandwidth', 3), (97, 'cpunode49_processor', 4), (98, 'cpunode50_bandwidth', 3), (99, 'cpunode50_processor', 4), (100, 'cbt001_bandwidth', 3), (101, 'cbt001_processor', 4), (102, 'cbt002_bandwidth', 3), (103, 'cbt002_processor', 4), (104, 'cbt003_bandwidth', 3), (105, 'cbt003_processor', 4), (106, 'cbt004_bandwidth', 3), (107, 'cbt004_processor', 4), (108, 'cbt005_bandwidth', 3), (109, 'cbt005_processor', 4), (110, 'cbt006_bandwidth', 3), (111, 'cbt006_processor', 4), (112, 'cbt007_bandwidth', 3), (113, 'cbt007_processor', 4), (114, 'cbt008_bandwidth', 3), (115, 'cbt008_processor', 4), (116, 'cep4_bandwidth', 3), (117, 'cep4_storage', 5), (118, 'dragproc_disk_bandwidth', 3), (119, 'dragproc_processor', 4), (120, 'dragproc_storage', 5), (121, 'drg01_disk_bandwidth', 3), (122, 'drg01_processor', 4), (123, 'drg01_data1_storage', 5), (124, 'drg01_data2_storage', 5), (125, 'drg02_disk_bandwidth', 3), (126, 'drg02_processor', 4), (127, 'drg02_data1_storage', 5), (128, 'drg02_data2_storage', 5), (129, 'drg03_disk_bandwidth', 3), (130, 'drg03_processor', 4), (131, 'drg03_data1_storage', 5), (132, 'drg03_data2_storage', 5), (133, 'drg04_disk_bandwidth', 3), (134, 'drg04_processor', 4), (135, 'drg04_data1_storage', 5), (136, 'drg04_data2_storage', 5), (137, 'drg05_disk_bandwidth', 3), (138, 'drg05_processor', 4), (139, 'drg05_data1_storage', 5), (140, 'drg05_data2_storage', 5), (141, 'drg06_disk_bandwidth', 3), (142, 'drg06_processor', 4), (143, 'drg06_data1_storage', 5), (144, 'drg06_data2_storage', 5), (145, 'drg07_disk_bandwidth', 3), (146, 'drg07_processor', 4), (147, 'drg07_data1_storage', 5), (148, 'drg07_data2_storage', 5), (149, 'drg08_disk_bandwidth', 3), (150, 'drg08_processor', 4), (151, 'drg08_data1_storage', 5), (152, 'drg08_data2_storage', 5), (153, 'drg09_disk_bandwidth', 3), (154, 'drg09_processor', 4), (155, 'drg09_data1_storage', 5), (156, 'drg09_data2_storage', 5), (157, 'drg10_disk_bandwidth', 3), (158, 'drg10_processor', 4), (159, 'drg10_data1_storage', 5), (160, 'drg10_data2_storage', 5), (161, 'drg11_disk_bandwidth', 3), (162, 'drg11_processor', 4), (163, 'drg11_data1_storage', 5), (164, 'drg11_data2_storage', 5), (165, 'drg12_disk_bandwidth', 3), (166, 'drg12_processor', 4), (167, 'drg12_data1_storage', 5), (168, 'drg12_data2_storage', 5), (169, 'drg13_disk_bandwidth', 3), (170, 'drg13_processor', 4), (171, 'drg13_data1_storage', 5), (172, 'drg13_data2_storage', 5), (173, 'drg14_disk_bandwidth', 3), (174, 'drg14_processor', 4), (175, 'drg14_data1_storage', 5), (176, 'drg14_data2_storage', 5), (177, 'drg15_disk_bandwidth', 3), (178, 'drg15_processor', 4), (179, 'drg15_data1_storage', 5), (180, 'drg15_data2_storage', 5), (181, 'drg16_disk_bandwidth', 3), (182, 'drg16_processor', 4), (183, 'drg16_data1_storage', 5), (184, 'drg16_data2_storage', 5), (185, 'drg17_disk_bandwidth', 3), (186, 'drg17_processor', 4), (187, 'drg17_data1_storage', 5), (188, 'drg17_data2_storage', 5), (189, 'drg18_disk_bandwidth', 3), (190, 'drg18_processor', 4), (191, 'drg18_data1_storage', 5), (192, 'drg18_data2_storage', 5), (193, 'drg19_disk_bandwidth', 3), (194, 'drg19_processor', 4), (195, 'drg19_data1_storage', 5), (196, 'drg19_data2_storage', 5), (197, 'drg20_disk_bandwidth', 3), (198, 'drg20_processor', 4), (199, 'drg20_data1_storage', 5), (200, 'drg20_data2_storage', 5), (201, 'drg21_disk_bandwidth', 3), (202, 'drg21_processor', 4), (203, 'drg21_data1_storage', 5), (204, 'drg21_data2_storage', 5), (205, 'drg22_disk_bandwidth', 3), (206, 'drg22_processor', 4), (207, 'drg22_data1_storage', 5), (208, 'drg22_data2_storage', 5), (209, 'drg23_disk_bandwidth', 3), (210, 'drg23_processor', 4), (211, 'drg23_data1_storage', 5), (212, 'drg23_data2_storage', 5);
    INSERT INTO virtual_instrument.resource_to_resource_group VALUES (DEFAULT, 10, 10), (DEFAULT, 116, 1), (DEFAULT, 117, 1), (DEFAULT, 118, 65), (DEFAULT, 119, 65), (DEFAULT, 120, 65), (DEFAULT, 0, 5), (DEFAULT, 1, 5), (DEFAULT, 2, 6), (DEFAULT, 3, 6), (DEFAULT, 4, 7), (DEFAULT, 5, 7), (DEFAULT, 6, 8), (DEFAULT, 7, 8), (DEFAULT, 8, 9), (DEFAULT, 9, 9), (DEFAULT, 67, 38), (DEFAULT, 68, 39), (DEFAULT, 69, 39), (DEFAULT, 70, 40), (DEFAULT, 71, 40), (DEFAULT, 72, 41), (DEFAULT, 73, 41), (DEFAULT, 74, 42), (DEFAULT, 75, 42), (DEFAULT, 76, 43), (DEFAULT, 77, 43), (DEFAULT, 78, 44), (DEFAULT, 79, 44), (DEFAULT, 80, 45), (DEFAULT, 81, 45), (DEFAULT, 82, 46), (DEFAULT, 83, 46), (DEFAULT, 84, 47), (DEFAULT, 85, 47), (DEFAULT, 86, 48), (DEFAULT, 87, 48), (DEFAULT, 88, 49), (DEFAULT, 89, 49), (DEFAULT, 90, 50), (DEFAULT, 91, 50), (DEFAULT, 92, 51), (DEFAULT, 93, 51), (DEFAULT, 94, 52), (DEFAULT, 95, 52), (DEFAULT, 96, 53), (DEFAULT, 97, 53), (DEFAULT, 98, 54), (DEFAULT, 99, 54), (DEFAULT, 100, 55), (DEFAULT, 101, 55), (DEFAULT, 102, 56), (DEFAULT, 103, 56), (DEFAULT, 104, 57), (DEFAULT, 105, 57), (DEFAULT, 106, 58), (DEFAULT, 107, 58), (DEFAULT, 108, 59), (DEFAULT, 109, 59), (DEFAULT, 110, 60), (DEFAULT, 111, 60), (DEFAULT, 112, 61), (DEFAULT, 113, 61), (DEFAULT, 114, 62), (DEFAULT, 115, 62), (DEFAULT, 121, 66), (DEFAULT, 122, 66), (DEFAULT, 123, 66), (DEFAULT, 124, 66), (DEFAULT, 125, 67), (DEFAULT, 126, 67), (DEFAULT, 127, 67), (DEFAULT, 128, 67), (DEFAULT, 129, 68), (DEFAULT, 130, 68), (DEFAULT, 131, 68), (DEFAULT, 132, 68), (DEFAULT, 133, 69), (DEFAULT, 134, 69), (DEFAULT, 135, 69), (DEFAULT, 136, 69), (DEFAULT, 137, 70), (DEFAULT, 138, 70), (DEFAULT, 139, 70), (DEFAULT, 140, 70), (DEFAULT, 141, 71), (DEFAULT, 142, 71), (DEFAULT, 143, 71), (DEFAULT, 144, 71), (DEFAULT, 145, 72), (DEFAULT, 146, 72), (DEFAULT, 147, 72), (DEFAULT, 148, 72), (DEFAULT, 149, 73), (DEFAULT, 150, 73), (DEFAULT, 151, 73), (DEFAULT, 152, 73), (DEFAULT, 153, 74), (DEFAULT, 154, 74), (DEFAULT, 155, 74), (DEFAULT, 156, 74), (DEFAULT, 157, 75), (DEFAULT, 158, 75), (DEFAULT, 159, 75), (DEFAULT, 160, 75), (DEFAULT, 161, 76), (DEFAULT, 162, 76), (DEFAULT, 163, 76), (DEFAULT, 164, 76), (DEFAULT, 165, 77), (DEFAULT, 166, 77), (DEFAULT, 167, 77), (DEFAULT, 168, 77), (DEFAULT, 169, 78), (DEFAULT, 170, 78), (DEFAULT, 171, 78), (DEFAULT, 172, 78), (DEFAULT, 173, 79), (DEFAULT, 174, 79), (DEFAULT, 175, 79), (DEFAULT, 176, 79), (DEFAULT, 177, 80), (DEFAULT, 178, 80), (DEFAULT, 179, 80), (DEFAULT, 180, 80), (DEFAULT, 181, 81), (DEFAULT, 182, 81), (DEFAULT, 183, 81), (DEFAULT, 184, 81), (DEFAULT, 185, 82), (DEFAULT, 186, 82), (DEFAULT, 187, 82), (DEFAULT, 188, 82), (DEFAULT, 189, 83), (DEFAULT, 190, 83), (DEFAULT, 191, 83), (DEFAULT, 192, 83), (DEFAULT, 193, 84), (DEFAULT, 194, 84), (DEFAULT, 195, 84), (DEFAULT, 196, 84), (DEFAULT, 197, 85), (DEFAULT, 198, 85), (DEFAULT, 199, 85), (DEFAULT, 200, 85), (DEFAULT, 201, 86), (DEFAULT, 202, 86), (DEFAULT, 203, 86), (DEFAULT, 204, 86), (DEFAULT, 205, 87), (DEFAULT, 206, 87), (DEFAULT, 207, 87), (DEFAULT, 208, 87), (DEFAULT, 209, 88), (DEFAULT, 210, 88), (DEFAULT, 211, 88), (DEFAULT, 212, 88), (DEFAULT, 12, 11), (DEFAULT, 13, 11), (DEFAULT, 14, 12), (DEFAULT, 15, 12), (DEFAULT, 11, 10), (DEFAULT, 16, 13), (DEFAULT, 17, 13), (DEFAULT, 18, 14), (DEFAULT, 19, 14), (DEFAULT, 20, 15), (DEFAULT, 21, 15), (DEFAULT, 22, 16), (DEFAULT, 23, 16), (DEFAULT, 24, 17), (DEFAULT, 25, 17), (DEFAULT, 26, 18), (DEFAULT, 27, 18), (DEFAULT, 28, 19), (DEFAULT, 29, 19), (DEFAULT, 30, 20), (DEFAULT, 31, 20), (DEFAULT, 32, 21), (DEFAULT, 33, 21), (DEFAULT, 34, 22), (DEFAULT, 35, 22), (DEFAULT, 36, 23), (DEFAULT, 37, 23), (DEFAULT, 38, 24), (DEFAULT, 39, 24), (DEFAULT, 40, 25), (DEFAULT, 41, 25), (DEFAULT, 42, 26), (DEFAULT, 43, 26), (DEFAULT, 44, 27), (DEFAULT, 45, 27), (DEFAULT, 46, 28), (DEFAULT, 47, 28), (DEFAULT, 48, 29), (DEFAULT, 49, 29), (DEFAULT, 50, 30), (DEFAULT, 51, 30), (DEFAULT, 52, 31), (DEFAULT, 53, 31), (DEFAULT, 54, 32), (DEFAULT, 55, 32), (DEFAULT, 56, 33), (DEFAULT, 57, 33), (DEFAULT, 58, 34), (DEFAULT, 59, 34), (DEFAULT, 60, 35), (DEFAULT, 61, 35), (DEFAULT, 62, 36), (DEFAULT, 63, 36), (DEFAULT, 64, 37), (DEFAULT, 65, 37), (DEFAULT, 66, 38);
    INSERT INTO resource_monitoring.resource_capacity VALUES (DEFAULT, 116, 515396075520, 515396075520), (DEFAULT, 117, 3450434462023680, 3450434462023680), (DEFAULT, 118, 3774873600, 3774873600), (DEFAULT, 119, 16, 16), (DEFAULT, 120, 23669957984256, 23669957984256), (DEFAULT, 0, 26000000000, 26000000000), (DEFAULT, 1, 24, 24), (DEFAULT, 2, 26000000000, 26000000000), (DEFAULT, 3, 24, 24), (DEFAULT, 4, 26000000000, 26000000000), (DEFAULT, 5, 24, 24), (DEFAULT, 6, 26000000000, 26000000000), (DEFAULT, 7, 24, 24), (DEFAULT, 8, 26000000000, 26000000000), (DEFAULT, 9, 24, 24), (DEFAULT, 10, 26000000000, 26000000000), (DEFAULT, 11, 24, 24), (DEFAULT, 12, 26000000000, 26000000000), (DEFAULT, 13, 24, 24), (DEFAULT, 14, 26000000000, 26000000000), (DEFAULT, 15, 24, 24), (DEFAULT, 16, 26000000000, 26000000000), (DEFAULT, 17, 24, 24), (DEFAULT, 18, 26000000000, 26000000000), (DEFAULT, 19, 24, 24), (DEFAULT, 20, 26000000000, 26000000000), (DEFAULT, 21, 24, 24), (DEFAULT, 22, 26000000000, 26000000000), (DEFAULT, 23, 24, 24), (DEFAULT, 24, 26000000000, 26000000000), (DEFAULT, 25, 24, 24), (DEFAULT, 26, 26000000000, 26000000000), (DEFAULT, 27, 24, 24), (DEFAULT, 28, 26000000000, 26000000000), (DEFAULT, 29, 24, 24), (DEFAULT, 30, 26000000000, 26000000000), (DEFAULT, 31, 24, 24), (DEFAULT, 88, 26000000000, 26000000000), (DEFAULT, 89, 24, 24), (DEFAULT, 90, 26000000000, 26000000000), (DEFAULT, 91, 24, 24), (DEFAULT, 92, 26000000000, 26000000000), (DEFAULT, 93, 24, 24), (DEFAULT, 94, 26000000000, 26000000000), (DEFAULT, 95, 24, 24), (DEFAULT, 96, 26000000000, 26000000000), (DEFAULT, 97, 24, 24), (DEFAULT, 98, 26000000000, 26000000000), (DEFAULT, 99, 24, 24), (DEFAULT, 100, 52000000000, 52000000000), (DEFAULT, 101, 24, 24), (DEFAULT, 102, 52000000000, 52000000000), (DEFAULT, 103, 24, 24), (DEFAULT, 104, 52000000000, 52000000000), (DEFAULT, 105, 24, 24), (DEFAULT, 106, 52000000000, 52000000000), (DEFAULT, 107, 24, 24), (DEFAULT, 108, 52000000000, 52000000000), (DEFAULT, 109, 24, 24), (DEFAULT, 110, 52000000000, 52000000000), (DEFAULT, 111, 24, 24), (DEFAULT, 112, 52000000000, 52000000000), (DEFAULT, 113, 24, 24), (DEFAULT, 114, 52000000000, 52000000000), (DEFAULT, 115, 24, 24), (DEFAULT, 121, 1887436800, 1887436800), (DEFAULT, 122, 16, 16), (DEFAULT, 123, 7913168961536, 7913168961536), (DEFAULT, 124, 7913168961536, 7913168961536), (DEFAULT, 125, 1887436800, 1887436800), (DEFAULT, 126, 16, 16), (DEFAULT, 127, 7913168961536, 7913168961536), (DEFAULT, 128, 7913168961536, 7913168961536), (DEFAULT, 129, 1887436800, 1887436800), (DEFAULT, 130, 16, 16), (DEFAULT, 131, 7913168961536, 7913168961536), (DEFAULT, 132, 7913168961536, 7913168961536), (DEFAULT, 133, 1887436800, 1887436800), (DEFAULT, 134, 16, 16), (DEFAULT, 135, 7913168961536, 7913168961536), (DEFAULT, 136, 7913168961536, 7913168961536), (DEFAULT, 137, 1887436800, 1887436800), (DEFAULT, 138, 16, 16), (DEFAULT, 139, 7913168961536, 7913168961536), (DEFAULT, 140, 7913168961536, 7913168961536), (DEFAULT, 141, 1887436800, 1887436800), (DEFAULT, 142, 16, 16), (DEFAULT, 143, 7913168961536, 7913168961536), (DEFAULT, 144, 7913168961536, 7913168961536), (DEFAULT, 145, 1887436800, 1887436800), (DEFAULT, 146, 16, 16), (DEFAULT, 147, 7913168961536, 7913168961536), (DEFAULT, 148, 7913168961536, 7913168961536), (DEFAULT, 149, 1887436800, 1887436800), (DEFAULT, 150, 16, 16), (DEFAULT, 151, 7913168961536, 7913168961536), (DEFAULT, 152, 7913168961536, 7913168961536), (DEFAULT, 153, 1887436800, 1887436800), (DEFAULT, 154, 16, 16), (DEFAULT, 155, 7913168961536, 7913168961536), (DEFAULT, 156, 7913168961536, 7913168961536), (DEFAULT, 157, 1887436800, 1887436800), (DEFAULT, 158, 16, 16), (DEFAULT, 159, 7913168961536, 7913168961536), (DEFAULT, 160, 7913168961536, 7913168961536), (DEFAULT, 161, 1887436800, 1887436800), (DEFAULT, 162, 16, 16), (DEFAULT, 163, 7913168961536, 7913168961536), (DEFAULT, 164, 7913168961536, 7913168961536), (DEFAULT, 165, 1887436800, 1887436800), (DEFAULT, 166, 16, 16), (DEFAULT, 167, 7913168961536, 7913168961536), (DEFAULT, 168, 7913168961536, 7913168961536), (DEFAULT, 169, 1887436800, 1887436800), (DEFAULT, 170, 16, 16), (DEFAULT, 171, 7913168961536, 7913168961536), (DEFAULT, 172, 7913168961536, 7913168961536), (DEFAULT, 173, 1887436800, 1887436800), (DEFAULT, 174, 16, 16), (DEFAULT, 175, 7913168961536, 7913168961536), (DEFAULT, 176, 7913168961536, 7913168961536), (DEFAULT, 177, 1887436800, 1887436800), (DEFAULT, 178, 16, 16), (DEFAULT, 179, 7913168961536, 7913168961536), (DEFAULT, 180, 7913168961536, 7913168961536), (DEFAULT, 181, 1887436800, 1887436800), (DEFAULT, 182, 16, 16), (DEFAULT, 183, 7913168961536, 7913168961536), (DEFAULT, 184, 7913168961536, 7913168961536), (DEFAULT, 185, 1887436800, 1887436800), (DEFAULT, 186, 16, 16), (DEFAULT, 187, 7913168961536, 7913168961536), (DEFAULT, 188, 7913168961536, 7913168961536), (DEFAULT, 189, 1887436800, 1887436800), (DEFAULT, 190, 16, 16), (DEFAULT, 191, 7913168961536, 7913168961536), (DEFAULT, 192, 7913168961536, 7913168961536), (DEFAULT, 193, 1887436800, 1887436800), (DEFAULT, 194, 16, 16), (DEFAULT, 195, 7913168961536, 7913168961536), (DEFAULT, 196, 7913168961536, 7913168961536), (DEFAULT, 197, 1887436800, 1887436800), (DEFAULT, 198, 16, 16), (DEFAULT, 199, 7913168961536, 7913168961536), (DEFAULT, 200, 7913168961536, 7913168961536), (DEFAULT, 201, 1887436800, 1887436800), (DEFAULT, 202, 16, 16), (DEFAULT, 203, 7913168961536, 7913168961536), (DEFAULT, 204, 7913168961536, 7913168961536), (DEFAULT, 32, 26000000000, 26000000000), (DEFAULT, 33, 24, 24), (DEFAULT, 34, 26000000000, 26000000000), (DEFAULT, 35, 24, 24), (DEFAULT, 36, 26000000000, 26000000000), (DEFAULT, 37, 24, 24), (DEFAULT, 38, 26000000000, 26000000000), (DEFAULT, 39, 24, 24), (DEFAULT, 40, 26000000000, 26000000000), (DEFAULT, 41, 24, 24), (DEFAULT, 42, 26000000000, 26000000000), (DEFAULT, 43, 24, 24), (DEFAULT, 44, 26000000000, 26000000000), (DEFAULT, 45, 24, 24), (DEFAULT, 46, 26000000000, 26000000000), (DEFAULT, 47, 24, 24), (DEFAULT, 48, 26000000000, 26000000000), (DEFAULT, 49, 24, 24), (DEFAULT, 50, 26000000000, 26000000000), (DEFAULT, 51, 24, 24), (DEFAULT, 52, 26000000000, 26000000000), (DEFAULT, 53, 24, 24), (DEFAULT, 54, 26000000000, 26000000000), (DEFAULT, 55, 24, 24), (DEFAULT, 56, 26000000000, 26000000000), (DEFAULT, 57, 24, 24), (DEFAULT, 58, 26000000000, 26000000000), (DEFAULT, 59, 24, 24), (DEFAULT, 60, 26000000000, 26000000000), (DEFAULT, 61, 24, 24), (DEFAULT, 62, 26000000000, 26000000000), (DEFAULT, 63, 24, 24), (DEFAULT, 64, 26000000000, 26000000000), (DEFAULT, 65, 24, 24), (DEFAULT, 66, 26000000000, 26000000000), (DEFAULT, 67, 24, 24), (DEFAULT, 68, 26000000000, 26000000000), (DEFAULT, 69, 24, 24), (DEFAULT, 70, 26000000000, 26000000000), (DEFAULT, 71, 24, 24), (DEFAULT, 72, 26000000000, 26000000000), (DEFAULT, 73, 24, 24), (DEFAULT, 74, 26000000000, 26000000000), (DEFAULT, 75, 24, 24), (DEFAULT, 76, 26000000000, 26000000000), (DEFAULT, 77, 24, 24), (DEFAULT, 78, 26000000000, 26000000000), (DEFAULT, 79, 24, 24), (DEFAULT, 80, 26000000000, 26000000000), (DEFAULT, 81, 24, 24), (DEFAULT, 82, 26000000000, 26000000000), (DEFAULT, 83, 24, 24), (DEFAULT, 84, 26000000000, 26000000000), (DEFAULT, 85, 24, 24), (DEFAULT, 86, 26000000000, 26000000000), (DEFAULT, 87, 24, 24), (DEFAULT, 205, 1887436800, 1887436800), (DEFAULT, 206, 16, 16), (DEFAULT, 207, 7913168961536, 7913168961536), (DEFAULT, 208, 7913168961536, 7913168961536), (DEFAULT, 209, 1887436800, 1887436800), (DEFAULT, 210, 16, 16), (DEFAULT, 211, 7913168961536, 7913168961536), (DEFAULT, 212, 7913168961536, 7913168961536);
    INSERT INTO resource_monitoring.resource_availability VALUES (DEFAULT, 47, TRUE), (DEFAULT, 48, TRUE), (DEFAULT, 49, TRUE), (DEFAULT, 50, TRUE), (DEFAULT, 51, TRUE), (DEFAULT, 52, TRUE), (DEFAULT, 53, TRUE), (DEFAULT, 54, TRUE), (DEFAULT, 55, TRUE), (DEFAULT, 56, TRUE), (DEFAULT, 57, TRUE), (DEFAULT, 58, TRUE), (DEFAULT, 59, TRUE), (DEFAULT, 60, TRUE), (DEFAULT, 61, TRUE), (DEFAULT, 62, TRUE), (DEFAULT, 63, TRUE), (DEFAULT, 64, TRUE), (DEFAULT, 65, TRUE), (DEFAULT, 66, TRUE), (DEFAULT, 67, TRUE), (DEFAULT, 68, TRUE), (DEFAULT, 69, TRUE), (DEFAULT, 70, TRUE), (DEFAULT, 71, TRUE), (DEFAULT, 72, TRUE), (DEFAULT, 73, TRUE), (DEFAULT, 74, TRUE), (DEFAULT, 19, TRUE), (DEFAULT, 20, TRUE), (DEFAULT, 21, TRUE), (DEFAULT, 22, TRUE), (DEFAULT, 23, TRUE), (DEFAULT, 24, TRUE), (DEFAULT, 25, TRUE), (DEFAULT, 26, TRUE), (DEFAULT, 27, TRUE), (DEFAULT, 28, TRUE), (DEFAULT, 29, TRUE), (DEFAULT, 30, TRUE), (DEFAULT, 31, TRUE), (DEFAULT, 32, TRUE), (DEFAULT, 33, TRUE), (DEFAULT, 34, TRUE), (DEFAULT, 35, TRUE), (DEFAULT, 36, TRUE), (DEFAULT, 37, TRUE), (DEFAULT, 38, TRUE), (DEFAULT, 39, TRUE), (DEFAULT, 40, TRUE), (DEFAULT, 41, TRUE), (DEFAULT, 42, TRUE), (DEFAULT, 43, TRUE), (DEFAULT, 44, TRUE), (DEFAULT, 45, TRUE), (DEFAULT, 46, TRUE), (DEFAULT, 75, TRUE), (DEFAULT, 76, TRUE), (DEFAULT, 77, TRUE), (DEFAULT, 78, TRUE), (DEFAULT, 79, TRUE), (DEFAULT, 80, TRUE), (DEFAULT, 81, TRUE), (DEFAULT, 82, TRUE), (DEFAULT, 83, TRUE), (DEFAULT, 84, TRUE), (DEFAULT, 85, TRUE), (DEFAULT, 86, TRUE), (DEFAULT, 87, TRUE), (DEFAULT, 88, TRUE), (DEFAULT, 89, TRUE), (DEFAULT, 90, TRUE), (DEFAULT, 91, TRUE), (DEFAULT, 92, TRUE), (DEFAULT, 93, TRUE), (DEFAULT, 94, TRUE), (DEFAULT, 95, TRUE), (DEFAULT, 96, TRUE), (DEFAULT, 97, TRUE), (DEFAULT, 98, TRUE), (DEFAULT, 99, TRUE), (DEFAULT, 100, TRUE), (DEFAULT, 101, TRUE), (DEFAULT, 102, TRUE), (DEFAULT, 116, TRUE), (DEFAULT, 117, TRUE), (DEFAULT, 118, TRUE), (DEFAULT, 119, TRUE), (DEFAULT, 120, TRUE), (DEFAULT, 0, TRUE), (DEFAULT, 1, TRUE), (DEFAULT, 2, TRUE), (DEFAULT, 3, TRUE), (DEFAULT, 4, TRUE), (DEFAULT, 5, TRUE), (DEFAULT, 6, TRUE), (DEFAULT, 7, TRUE), (DEFAULT, 8, TRUE), (DEFAULT, 9, TRUE), (DEFAULT, 10, TRUE), (DEFAULT, 11, TRUE), (DEFAULT, 12, TRUE), (DEFAULT, 13, TRUE), (DEFAULT, 14, TRUE), (DEFAULT, 15, TRUE), (DEFAULT, 16, TRUE), (DEFAULT, 17, TRUE), (DEFAULT, 18, TRUE), (DEFAULT, 103, TRUE), (DEFAULT, 104, TRUE), (DEFAULT, 105, TRUE), (DEFAULT, 106, TRUE), (DEFAULT, 107, TRUE), (DEFAULT, 108, TRUE), (DEFAULT, 109, TRUE), (DEFAULT, 110, TRUE), (DEFAULT, 111, TRUE), (DEFAULT, 112, TRUE), (DEFAULT, 113, TRUE), (DEFAULT, 114, TRUE), (DEFAULT, 115, TRUE), (DEFAULT, 121, TRUE), (DEFAULT, 122, TRUE), (DEFAULT, 123, TRUE), (DEFAULT, 124, TRUE), (DEFAULT, 125, TRUE), (DEFAULT, 126, TRUE), (DEFAULT, 127, TRUE), (DEFAULT, 128, TRUE), (DEFAULT, 129, TRUE), (DEFAULT, 130, TRUE), (DEFAULT, 131, TRUE), (DEFAULT, 132, TRUE), (DEFAULT, 133, TRUE), (DEFAULT, 134, TRUE), (DEFAULT, 135, TRUE), (DEFAULT, 136, TRUE), (DEFAULT, 137, TRUE), (DEFAULT, 138, TRUE), (DEFAULT, 139, TRUE), (DEFAULT, 140, TRUE), (DEFAULT, 141, TRUE), (DEFAULT, 142, TRUE), (DEFAULT, 143, TRUE), (DEFAULT, 144, TRUE), (DEFAULT, 145, TRUE), (DEFAULT, 146, TRUE), (DEFAULT, 147, TRUE), (DEFAULT, 148, TRUE), (DEFAULT, 149, TRUE), (DEFAULT, 150, TRUE), (DEFAULT, 151, TRUE), (DEFAULT, 152, TRUE), (DEFAULT, 153, TRUE), (DEFAULT, 154, TRUE), (DEFAULT, 155, TRUE), (DEFAULT, 156, TRUE), (DEFAULT, 157, TRUE), (DEFAULT, 158, TRUE), (DEFAULT, 159, TRUE), (DEFAULT, 160, TRUE), (DEFAULT, 161, TRUE), (DEFAULT, 162, TRUE), (DEFAULT, 163, TRUE), (DEFAULT, 164, TRUE), (DEFAULT, 165, TRUE), (DEFAULT, 166, TRUE), (DEFAULT, 167, TRUE), (DEFAULT, 168, TRUE), (DEFAULT, 169, TRUE), (DEFAULT, 170, TRUE), (DEFAULT, 171, TRUE), (DEFAULT, 172, TRUE), (DEFAULT, 173, TRUE), (DEFAULT, 174, TRUE), (DEFAULT, 175, TRUE), (DEFAULT, 176, TRUE), (DEFAULT, 177, TRUE), (DEFAULT, 178, TRUE), (DEFAULT, 179, TRUE), (DEFAULT, 180, TRUE), (DEFAULT, 181, TRUE), (DEFAULT, 182, TRUE), (DEFAULT, 183, TRUE), (DEFAULT, 184, TRUE), (DEFAULT, 185, TRUE), (DEFAULT, 186, TRUE), (DEFAULT, 187, TRUE), (DEFAULT, 188, TRUE), (DEFAULT, 189, TRUE), (DEFAULT, 190, TRUE), (DEFAULT, 191, TRUE), (DEFAULT, 192, TRUE), (DEFAULT, 193, TRUE), (DEFAULT, 194, TRUE), (DEFAULT, 195, TRUE), (DEFAULT, 196, TRUE), (DEFAULT, 197, TRUE), (DEFAULT, 198, TRUE), (DEFAULT, 199, TRUE), (DEFAULT, 200, TRUE), (DEFAULT, 201, TRUE), (DEFAULT, 202, TRUE), (DEFAULT, 203, TRUE), (DEFAULT, 204, TRUE), (DEFAULT, 205, TRUE), (DEFAULT, 206, TRUE), (DEFAULT, 207, TRUE), (DEFAULT, 208, TRUE), (DEFAULT, 209, TRUE), (DEFAULT, 210, TRUE), (DEFAULT, 211, TRUE), (DEFAULT, 212, TRUE);
    INSERT INTO virtual_instrument.resource_group_to_resource_group VALUES (DEFAULT, 0, 0), (DEFAULT, 1, 0), (DEFAULT, 2, 0), (DEFAULT, 63, 0), (DEFAULT, 3, 1), (DEFAULT, 4, 1), (DEFAULT, 64, 63), (DEFAULT, 65, 63), (DEFAULT, 5, 3), (DEFAULT, 6, 3), (DEFAULT, 7, 3), (DEFAULT, 8, 3), (DEFAULT, 9, 3), (DEFAULT, 10, 3), (DEFAULT, 11, 3), (DEFAULT, 12, 3), (DEFAULT, 13, 3), (DEFAULT, 14, 3), (DEFAULT, 15, 3), (DEFAULT, 16, 3), (DEFAULT, 17, 3), (DEFAULT, 18, 3), (DEFAULT, 19, 3), (DEFAULT, 20, 3), (DEFAULT, 21, 3), (DEFAULT, 81, 64), (DEFAULT, 82, 64), (DEFAULT, 83, 64), (DEFAULT, 84, 64), (DEFAULT, 85, 64), (DEFAULT, 86, 64), (DEFAULT, 87, 64), (DEFAULT, 88, 64), (DEFAULT, 22, 3), (DEFAULT, 23, 3), (DEFAULT, 24, 3), (DEFAULT, 25, 3), (DEFAULT, 26, 3), (DEFAULT, 27, 3), (DEFAULT, 28, 3), (DEFAULT, 29, 3), (DEFAULT, 30, 3), (DEFAULT, 31, 3), (DEFAULT, 32, 3), (DEFAULT, 33, 3), (DEFAULT, 34, 3), (DEFAULT, 35, 3), (DEFAULT, 36, 3), (DEFAULT, 37, 3), (DEFAULT, 38, 3), (DEFAULT, 39, 3), (DEFAULT, 40, 3), (DEFAULT, 41, 3), (DEFAULT, 42, 3), (DEFAULT, 43, 3), (DEFAULT, 44, 3), (DEFAULT, 45, 3), (DEFAULT, 46, 3), (DEFAULT, 47, 3), (DEFAULT, 48, 3), (DEFAULT, 49, 3), (DEFAULT, 50, 3), (DEFAULT, 51, 3), (DEFAULT, 52, 3), (DEFAULT, 53, 3), (DEFAULT, 54, 3), (DEFAULT, 55, 2), (DEFAULT, 56, 2), (DEFAULT, 57, 2), (DEFAULT, 58, 2), (DEFAULT, 59, 2), (DEFAULT, 60, 2), (DEFAULT, 61, 2), (DEFAULT, 62, 2), (DEFAULT, 66, 64), (DEFAULT, 67, 64), (DEFAULT, 68, 64), (DEFAULT, 69, 64), (DEFAULT, 70, 64), (DEFAULT, 71, 64), (DEFAULT, 72, 64), (DEFAULT, 73, 64), (DEFAULT, 74, 64), (DEFAULT, 75, 64), (DEFAULT, 76, 64), (DEFAULT, 77, 64), (DEFAULT, 78, 64), (DEFAULT, 79, 64), (DEFAULT, 80, 64);
    COMMIT;