lifemaps/qt5-legatus-legacy
1
0 Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
story/qt6-migration
qt5-legatus-legacy/Lts/Tests/DatabaseInitialisation/insert_pdm_values_mil.sql
T
torsten b7d90b9afe Initial commit
2026-08-13 18:33:10 +02:00

303 lines
34 KiB
SQL
Executable File
Raw Permalink Blame History

-- # $Id$
-- # $HeadURL$
-- # $Author$
-- TDOO: use Excel or smth other for better overview
-- GearClass 10 -> DuellSimulation (1000+id)
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1001, 'M16', 17, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1002, 'HK53', 18, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1003, 'Sniper', 19, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1004, 'Caracal', 20, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1005, 'M203', 21, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1006, 'HMG', 25, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1007, 'Minimi', 26, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1008, 'MK19', 27, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1009, 'IGLA', 28, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1010, 'AT Weapon', 29, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1011, 'Light Mortar', 30, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1012, 'Hand Grenade', 33, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1013, 'Grenade', 34, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1014, 'AT Mine', 35, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1015, 'Claymore', 36, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1016, 'AP Mine', 37, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1017, 'Art Mine', 38, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1018, 'Side MG', 81, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1019, 'Main Weapon', 82, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1020, 'Cannon 30mm', 83, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1021, 'Coax MG', 84, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1022, 'Side MG left', 85, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1023, 'Side MG right', 86, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1024, 'Hydra-Launcher', 97, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1025, '30mm Machine Cannon', 98, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1026, 'Hellfire-Launcher', 99, 10);
-- Charges for GearClass 10 -> DuellSimulation (10000 + id)
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (1, 1, NULL, '120 mm APFSDS', 'APFS-120');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (2, 2, NULL, '120 mm APFSDS', 'APFS-120');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (3, 3, NULL, '120 mm HEAT', 'HEAT-120');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (4, 8, NULL, '100 mm HE', 'HE-100mm');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (5, 9, NULL, '30 mm APDS', 'APDS-30');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (6, 14, NULL, '100 mm Falah', 'Falah100');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (7, 15, NULL, 'Kornet', 'Kornet');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (8, 23, NULL, '7.62 mm Coax MG', 'CoMG7.62');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (9, 25, NULL, 'IGLA', 'IGLA');
-- mapping see geopairing (zssiwi_service_base.hpp) / sys_db.munition
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (10, 26, 112, '40mm m385HE', 'm385HE40');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (11, 27, 111, '40mm m430HE', 'm430HE40');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (12, 28, NULL, '30 mm HE', 'HE-30mm');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (13, 30, 1, '155mm HE M1A2 Percussion Fuze', 'M1A2-Prc');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (14, 31, 2, '155mm HE M1A2 Proximity Fuze', 'M1A2-Prx');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (15, 32, 1, '155mm VLAP M9703 Percussion Fuze', 'VLAP-Prc');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (16, 33, 2, '155mm VLAP M9703 Proximity Fuze', 'VLAP-Prx');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (17, 34, 5, '155mm SMK BE M2', 'SMK');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (18, 35, 3, '155mm Cluster HEHC M9609', 'Cluster');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (19, 37, NULL, '12.7 mm Coax MG', 'CoMG12.7');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (20, 42, NULL, 'Hydra PD', 'Hydra-PD');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (21, 43, NULL, 'Hydra MP', 'Hydra-MD');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (22, 44, NULL, '30mm AH 64', '30mm');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (23, 45, NULL, 'Hydra Generic', 'HydraGen');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (24, 46, NULL, 'Hellfire SAL', 'HellfSAL');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (25, 47, NULL, 'Hellfire RF', 'Hellf-RF');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (26, 49, NULL, 'Claymore', 'Claymore');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (27, 50, NULL, 'Hand Grenade', 'HGr');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (28, 51, NULL, 'Minimi', 'Minimi');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (29, 52, NULL, 'Suicide Bomber Light', 'SuicB-L');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (30, 53, NULL, 'Suicide Bomber Medium', 'SuicB-M');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (31, 54, NULL, 'Suicide Bomber Heavy', 'SuicB-H');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (32, 56, NULL, '5.56mm M16/HK53', 'M16-5.56');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (33, 57, NULL, '5.56mm M16/HK53', 'M16-5.56');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (34, 58, NULL, '7.62 mm Side MG', 'Side7.62');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (35, 59, NULL, '7.62 mm Side MG', 'Side7.62');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (36, 60, NULL, 'RPG-7', 'RPG-7');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (37, 62, NULL, 'Indirect Vehicle', 'Indirect');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (38, 64, NULL, '12.7 mm HMG', 'HMG-12.7');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (39, 65, NULL, '12.7 mm HMG', 'HMG-12.7');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name, properti VALUES (40, 66, NULL, 'AP Mine', 'AP Mine', '{"isDus"true }');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (41, 68, NULL, 'IED Light', 'IED-L');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (42, 69, NULL, 'IED Medium', 'IED-M');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (43, 70, NULL, 'IED Heavy', 'IED-H');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (44, 72, NULL, '7.62 mm Sniper', 'Snpr7.62');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (45, 73, NULL, '40mm UGL', 'UGL-40mm');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (46, 74, NULL, '40mm UGL', 'UGL-40mm');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (47, 76, NULL, 'Caracal', 'Caracal');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (48,128, NULL, '155mm Charge M64Base', 'M64Base');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (49,129, NULL, '155mm Charge M64Incr', 'M64Incr');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (50,130, NULL, '155mm Base Bleed', 'BBleed');
-- mapping see geopairing (zssiwi_service_base.hpp) / sys_db.munition
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (51,217, 10, 'Mortar HE Percussion Fuze', 'Mor-Prc');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (52,218, 11, 'Mortar HE Proximity Fuze', 'Mor-Prx');
-- virtual mines as from sys_db.minentypen
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name, properties) VALUES (55, 213, NULL, 'AT Mine', 'AT Mine', '{"isDus"true }');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name, properties) VALUES (53, NULL, 214, 'V-AP Mine', 'VAP Mine', '{"isDus":false }');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name, properties) VALUES (54, NULL, 215, 'V-AT Mine laid', 'VAT Mine-l', '{"isDus":false }');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name, properties) VALUES (56, NULL, 216, 'V-AT Mine thrown', 'VAT Mine-t', '{"isDus":false }');
-- GearClass 10 to charge type assignments
-- IGLA
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (1009, 9, 30000);
-- Light Mortar
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (1011, 51, 2000);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (1011, 52, 2000);
-- Hand Grenade
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (1012, 27, 10);
-- Claymore
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (1015, 26, 1);
-- Mines
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (1014, 54, 1); -- AT: AT (virtual)
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (1014, 55, 1); -- AT: AT (DUS)
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (1014, 56, 1); -- AT: AT (virtual)
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (1016, 40, 1); -- AP: AP (DUS)
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (1016, 53, 1); -- AP: AP (virtual)
-- t.b.c.
-- GearClass 1 -> Unspecified...
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (101, 'Unspecified', NULL, 1);
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (101, NULL, NULL, 'Danger Area Dummy', 'Dummy');
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (101, 101, NULL);
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (102, NULL, NULL, 'Borderline Dummy', 'Dummy');
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (101, 102, NULL);
-- GearClass 2 -> Nuclear (200+id / 2000+id)
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (201, 'Nuclear Area', NULL, 2);
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (111, NULL, NULL, 'N-Bomb', 'N-Bomb');
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (201, 111, NULL);
-- GearClass 3 -> Biological (300+id / 3000+id)
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (301, 'Biological Area', NULL, 3);
INSERT INTO pdm.pdm_charge_type(id, tas_code_indirect, name, short_name) VALUES (126, 129, 'Bacterium', 'Bacterium');
INSERT INTO pdm.pdm_charge_type(id, tas_code_indirect, name, short_name) VALUES (127, 130, 'Virus', 'Virus');
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (301, 126, NULL);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (301, 127, NULL);
-- GearClass 4 -> Chemical (400+id / 4000+id)
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (401, 'Chemical Area', NULL, 4);
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name, properties) VALUES (121, 206, 1, 'Sarin', 'Sarin', '{"expansionFactor":1,"volatilityTypeId":1}');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name, properties) VALUES (122, 206, 2, 'VX', 'VX', '{"expansionFactor":0,"volatilityTypeId":2}');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name, properties) VALUES (123, 206, 3, 'S-Lost', 'S-Lost', '{"expansionFactor":0,"volatilityTypeId":2}');
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (401, 121, NULL);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (401, 122, NULL);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (401, 123, NULL);
-- GearClass 5 -> MineArea (500+id / 5000+id)
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (501, 'Mine Area', NULL, 5);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (501, 53, NULL);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (501, 54, NULL);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (501, 55, NULL);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (501, 56, NULL);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (501, 40, NULL);
-- GearClass 6 -> MineSingle (600+id / 6000+id)
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (601, 'Single Mines', NULL, 6);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (601, 53, NULL);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (601, 54, NULL);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (601, 55, NULL);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (601, 56, NULL);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (601, 40, NULL);
-- GearClass 7 -> Artillery (700+id / 7000+id)
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (701, 'Artillery', NULL, 7);
INSERT INTO pdm.pdm_charge_type(id, tas_code_indirect, name, short_name, impact_radius) VALUES (141, 1, 'HE V-LAP Percussion Fuze', 'V-LAP Prc', 5);
INSERT INTO pdm.pdm_charge_type(id, tas_code_indirect, name, short_name, impact_radius) VALUES (142, 2, 'HE V-LAP Proximity Fuze', 'V-LAP Prx', 10);
INSERT INTO pdm.pdm_charge_type(id, tas_code_indirect, name, short_name, impact_radius) VALUES (143, 3, 'Cluster Ammunition', 'Cluster', 15);
INSERT INTO pdm.pdm_charge_type(id, tas_code_indirect, name, short_name, impact_radius) VALUES (145, 5, 'Smoke SMK BE M2', 'Smoke', 22);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (701, 141, NULL);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (701, 142, NULL);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (701, 143, NULL);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (701, 145, NULL);
-- GearClass 8 -> Mortar (800+id / 8000+id)
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (801, 'Mortar', NULL, 8);
INSERT INTO pdm.pdm_charge_type(id, tas_code_indirect, name, short_name, impact_radius) VALUES (151, 10, 'HE Percussion Fuze', 'Prc', 13);
INSERT INTO pdm.pdm_charge_type(id, tas_code_indirect, name, short_name, impact_radius) VALUES (152, 11, 'HE Proximity Fuze', 'Prx', 8);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (801, 151, NULL);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (801, 152, NULL);
-- GearClass 9 -> Geopairing (900+id / 9000+id)
-- GearClass 11 -> Functional Areas (1100+id / 11000+id)
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1101, 'Functional Area', NULL, 11);
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (161, 1, NULL, 'Medical', 'Med');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (162, 2, NULL, 'Maintenance', 'Maint');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (163, 3, NULL, 'Decontamination', 'Decon');
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (1101, 161, NULL);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (1101, 162, NULL);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (1101, 163, NULL);
-- GearClass 12 -> Technical Areas (1200+id / 12000+id)
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1201, 'Technical Area', NULL, 12);
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (171, 1, NULL, 'Technical', 'Tec');
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (1201, 171, NULL);
-- BuildingChargeEffect
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES ( 2, 200, 200, 2, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES ( 1, 200, 200, 1, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES ( 3, 200, 200, 3, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES ( 4, 100, 150, 8, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES ( 5, 30, 25, 9, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES ( 6, 100, 200, 14, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES ( 7, 100, 200, 15, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES ( 8, 5, 2, 23, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES ( 9, 50, 30, 25, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (10, 30, 20, 26, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (11, 20, 15, 27, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (12, 15, 20, 28, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (13, 150, 200, 30, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (14, 70, 200, 31, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (15, 75, 100, 32, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (16, 15, 20, 33, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (17, 100, 200, 34, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (18, 100, 200, 35, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (19, 7, 10, 37, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (20, 100, 150, 42, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (21, 10, 3, 43, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (22, 25, 20, 44, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (28, 2, 2, 51, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (31, 10, 3, 54, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (32, 1, 1, 56, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (34, 5, 2, 58, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (38, 10, 3, 64, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (44, 5, 2, 72, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (45, 15, 7, 73, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (46, 9, 3, 74, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (47, 1, 1, 76, true, true);
-- 207 - ECC, 208 - OC
--INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (207, 50, 20, 1, true, true);
--INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (208, 50, 20, 1, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (141, 50, 20, 227, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (142, 50, 20, 228, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (143, 50, 15, 229, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (14, 50, 20, 231, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (151, 2, 2, 218, true, true);
INSERT INTO pdm.pdm_building_charge_effect (charge_type_id, destructive_factor, penetration_factor, hit_sound, difcue_light, difcue_pyro) VALUES (152, 2, 2, 218, true, true);
-- radio group
--INSERT INTO pdm.pdm_radio_group (id, name, base_group, issi, group_issi1, radio_hostname, radio_port, radio_backup_hostname, radio_backup_port) VALUES (1, 'Base Group', true, 9999, 5000, 'CCSTSW01', 52010, 'CCSTSW02', 52010); -- Example for base group. Has to be swapped with Group 1 (same ISSIs) !!!
INSERT INTO pdm.pdm_radio_group (id, name, base_group, issi, group_issi1, radio_hostname, radio_port, radio_backup_hostname, radio_backup_port) VALUES (1, 'Group 1', false, 9999, 5000, 'CCSTSW01', 52010, 'CCSTSW02', 52010);
INSERT INTO pdm.pdm_radio_group (id, name, base_group, issi, group_issi1, radio_hostname, radio_port, radio_backup_hostname, radio_backup_port) VALUES (2, 'Group 2', false, 9998, 5001, 'CCSTSW01', 52010, 'CCSTSW02', 52010);
INSERT INTO pdm.pdm_radio_group (id, name, base_group, issi, group_issi1, radio_hostname, radio_port, radio_backup_hostname, radio_backup_port) VALUES (3, 'Group 3', false, 9997, 5002, 'CCSTSW01', 52010, 'CCSTSW02', 52010);
-- Fire Purpose for Single Fire / Area Fire
INSERT INTO pdm.pdm_fire_purpose (id, name) VALUES (1, 'Destroy');
INSERT INTO pdm.pdm_fire_purpose (id, name) VALUES (2, 'Kill');
INSERT INTO pdm.pdm_fire_purpose (id, name) VALUES (3, 'Interdict');
INSERT INTO pdm.pdm_fire_purpose (id, name) VALUES (4, 'Jam');
INSERT INTO pdm.pdm_fire_purpose (id, name) VALUES (5, 'Suppress');
INSERT INTO pdm.pdm_fire_purpose (id, name) VALUES (6, 'Blind');
-- Presets for Nuclear Agents
INSERT INTO pdm.pdm_nuclear_preset (id, name, detonation_value, impact_radius, border_length_inner, border_length_outer) VALUES (1, '0,3 kiloTons', 0.3, 420, 1400, 2800);
INSERT INTO pdm.pdm_nuclear_preset (id, name, detonation_value, impact_radius, border_length_inner, border_length_outer) VALUES (2, '100 kiloTons', 100, 1280, 3600, 7200);
INSERT INTO pdm.pdm_nuclear_preset (id, name, detonation_value, impact_radius, border_length_inner, border_length_outer) VALUES (3, '300 kiloTons', 300, 1840, 6100, 12200);
INSERT INTO pdm.pdm_nuclear_preset (id, name, detonation_value, impact_radius, border_length_inner, border_length_outer) VALUES (4, '475 kiloTons', 475, 2140, 7500, 15000);
INSERT INTO pdm.pdm_nuclear_preset (id, name, detonation_value, impact_radius, border_length_inner, border_length_outer) VALUES (5, '1200 kiloTons', 1200, 2910, 12300, 24600);
INSERT INTO pdm.pdm_nuclear_preset (id, name, detonation_value, impact_radius, border_length_inner, border_length_outer) VALUES (6, '5000 kiloTons', 5000, 4650, 25100, 50100);
-- Presets for Can Devices
-- bit 32 to 39 ---> devices battery status (Bit 0 = MSB)
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES (549755813888, -1, -1, 'Ausstattung');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES (274877906944, -1, -1, 'Bit 1');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES (137438953472, -1, -1, 'Bit 2');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 68719476736, -1, -1, 'Bit 3');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 34359738368, -1, -1, 'Batteriewarnung ABC-Filter');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 17179869184, -1, -1, 'Batteriewarnung Waffe');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 8589934592, -1, -1, 'Batteriewarnung Helmgurt');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 4294967296, -1, -1, 'Bit 7');
-- Bit 0 to 31 ---> devices bite state (Bit 0 = MSB)
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES (8388608, 13, -1, 'Teilnehmereinheit');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES (4194304, -1, -1, 'AGDUS');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES (2097152, 11, -1, 'ABE');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES (1048576, 22, -1, 'Sondersensorik FIR');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 524288, 23, -1, 'Sondersensorik MV');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 262144, 21, -1, 'Sondersensorik Standard');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 131072, 9, -1, 'MHGR-Sensorik');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 65536, 8, -1, 'ABC-Überdrucksensor');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 32768, -1, -1, 'ABC-Strömungswächter');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 16384, 10, -1, 'Wirkungsdarstellung');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 8192, 30, -1, 'SRT');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 4096, 29, -1, 'DMF');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 2048, 27, -1, 'IED-Sensorik');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 1024, 28, -1, 'IED-Kontrollgerät');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 512, -1, -1, 'Bit 14');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 256, -1, -1, 'Bit 15');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 128, -1, -1, 'Bit 16');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 64, -1, -1, 'Bit 17');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 32, -1, -1, 'Bit 18');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 16, -1, -1, 'Bit 19');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 8, -1, -1, 'Bit 20');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 4, -1, -1, 'Bit 21');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 2, -1, -1, 'Bit 22');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 1, -1, -1, 'Bit 23');
-- only device names
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 0, 4, -1, 'Test-/Servicerechner');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 0, 5, -1, 'ZE AGD HW2');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 0, 12, -1, 'Anzeigegerät Sondersensorik CSF (AGS)');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 0, 14, -1, 'CANAG Kommunikationsgerät');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 0, 16, -1, 'AGDUS aktiv');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 0, 18, -1, 'AGDUS Handwaffe');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 0, 19, -1, 'AGDUS passiv');
INSERT INTO pdm.pdm_can_component_string (bit_mask, can_device_id, sub_device_id, name) VALUES ( 0, -1, 13, 'PAN-Koordinator');
Reference in new issue View Git Blame Copy Permalink