-- # $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, 'Loeschspritze Hand',    17, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1002, 'Loeschkanone',          82, 10);
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1003, 'Explosion Sim. Device', 11, 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,  9, NULL, 'Wasser','Wasser');
INSERT INTO pdm.pdm_charge_type (id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (2, 28, NULL, 'Schaum','Schaum');

INSERT INTO pdm.pdm_charge_type (id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (3, 56, NULL, 'Wasser','Wasser');
INSERT INTO pdm.pdm_charge_type (id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (4, 57, NULL, 'Schaum','Schaum');

INSERT INTO pdm.pdm_charge_type (id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (5, 48, NULL, 'Explosion Light',  'Exp Light');
INSERT INTO pdm.pdm_charge_type (id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (6, 49, NULL, 'Explosion Medium', 'Exp Medium');
INSERT INTO pdm.pdm_charge_type (id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (7, 70, NULL, 'Explosion Heavy',  'Exp Heavy');


-- GearClass10 to charge type assignments                                                     
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (1001, 3, 35);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (1001, 4, 15);

INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (1002, 1, 50);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (1002, 2, 20);

INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (1003, 5, 15);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (1003, 6, 40);
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (1003, 7, 80);


-- 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, 'Unknown Danger Area 1', 'UDA 1');
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, 'Unknown Borderline 1', 'UBL 1');
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, 'A-Kontamination', NULL, 2);
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (111, NULL, 205, 'A-Kontamination', 'A-Kont');
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (201, 111, NULL);

-- GearClass 4 -> Chemical (400+id / 4000+id)
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (401, 'C-Contamination', NULL, 4);
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name, properties) VALUES (121, 206, 1, 'Smoke', 'Smoke', '{"expansionFactor":1,"volatilityTypeId":1}');
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (401, 121, NULL);

-- GearClass 7 -> Explosion (700+id / 7000+id)
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (701, 'Explosion', NULL, 7);
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (141, 201, 1, 'Rauchgasexplosion', 'RG');
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (701, 141, NULL);

-- GearClass 8 -> Unused (800+id / 8000+id)
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (801, 'Unused', NULL, 8);
--INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (8001, NULL, 229, 'Rauchgasexplosion', 'RG');
--INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (801, 8001, NULL);

-- GearClass 11 -> Functional Areas (1100+id / 11000+id)
INSERT INTO pdm.pdm_gear_type (id, name, tas_code, gear_class_id) VALUES (1101, 'Funktionsraeume', NULL, 11);
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (161, 1, NULL, 'Medizinisch', 'Med');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (162, 2, NULL, 'Instandsetzung', 'Inst');
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (163, 3, NULL, 'Dekontamination', 'Dekon');
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, 'Technikfunktionsraeume', NULL, 12);
INSERT INTO pdm.pdm_charge_type(id, tas_code_direct, tas_code_indirect, name, short_name) VALUES (171, 1, NULL, 'Technisch', 'Tec');
INSERT INTO pdm.pdm_gear_type_charge_type(gear_type_id, charge_type_id, max_range) VALUES (1201, 171, NULL);

-- 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);

-- for test data ex 42 from guez data (AES + REP)
INSERT INTO pdm.pdm_charge_type (id, tas_code_direct, tas_code_indirect, name, short_name, properties) VALUES (131, 211, NULL, 'SchtzAbwMiD', 'SchtzAbwMiD', '{"isDus":true,"isReactivatable":false}');