INSERT IGNORE INTO `device` (`uuid`, `aindex`, `reg`, `reg_prev`, `reg_unavailable`, `editor`, `inspector`, `title`, `notes`, `EditDate`, `version`, `certificate_latest_int`, `next_usage_inspection`, `next_inside_inspection`, `next_scheduled_pressure`, `next_scheduled_inspection`, `next_other_inspection`, `next_followup`, `next_operational_inspection`, `next_condition_inspection`, `next_seal_inspection`, `inspection_date_latest`, `inspection_date_next`, `running_number`, `running_number_changed`, `running_number_history`, `company_owner`, `company_holder`, `company_manufacturer`, `company_importer`, `person_contact`, `person_supervisor`, `person_supervisor_alt`, `inspector_person_name`, `container_number`, `manufacturing_year`, `manufacturing_number`, `manufacturing_standardby`, `manufacturing_standard`, `location_device`, `location_description`, `location_address`, `location_street`, `location_zip_code`, `location_city`, `category_code`, `category_description`, `subcategory_code`, `subcategory_description`, `substucture_description`, `usage_method_code`, `usage_method_description`, `stucture_code`, `stucture_description`, `stucture_sheat_material`, `stucture_sheat_strength`, `stucture_bottom_material`, `stucture_bottom_strength`, `stucture_topend_material`, `stucture_topend_strength`, `stucture_drawings`, `primary_fuel_code`, `primary_fuel`, `ps_state1_min`, `ps_state1_max`, `ps_state2_min`, `ps_state2_max`, `ps_state3_min`, `ps_state3_max`, `ts_state1_min`, `ts_state1_max`, `ts_state2_min`, `ts_state2_max`, `ts_state3_min`, `ts_state3_max`, `v_state1`, `v_state2`, `v_state3`, `content_primary`, `content_primary_title`, `content_primary_subtitle`, `content_primary_density`, `content_state1`, `content_state1_title`, `content_state1_subtitle`, `content_state2`, `content_state2_title`, `content_state2_subtitle`, `content_state3`, `content_state3_title`, `content_state3_subtitle`, `power_state1`, `power_state2`, `power_state3`, `latest_other_inspection`, `latest_followup`, `latest_seal_inspection`, `latest_condition_inspection`, `latest_operational_inspection`, `latest_scheduled_inspection`, `latest_usage_inspection`, `latest_scheduled_pressure`, `latest_inside_inspection`, `latest_change_inspection`, `cycle_other_inspection`, `cycle_followup`, `cycle_seal_inspection`, `cycle_condition_inspection`, `cycle_operational_inspection`, `cycle_scheduled_inspection`, `cycle_usage_inspection`, `cycle_scheduled_pressure`, `cycle_inside_inspection`, `UpdateTime`, `InsertTime`, `orbeon_import_allowed`, `orbeon_imported`, `title_state1`, `title_state2`, `title_state3`, `location_state1`, `location_state2`, `location_state3`, `dn_state1`, `dn_state2`, `dn_state3`, `person_supervisor_role`, `person_supervisor_role_code`, `person_supervisor_alt_role`, `person_supervisor_alt_role_code`, `person_supervisor_alt_qualification`, `person_supervisor_alt_qualification_code`, `person_supervisor_qualification`, `person_supervisor_qualification_code`, `primary_diameter`, `primary_volume`, `primary_lenght`, `primary_class`, `class_description`, `safety_device_description`, `running_number_static`, `delete_allowed`, `archived`, `archive_reason`, `archived_at`) VALUES ('84e8ca7c-aab8-4e13-8f9a-d9e01e217417', '34395', 'X-5405460', '', '0', '46d229b0-33af-06a1-91ff-2267bca9ae56', '', 'TESTI', '', '2025-05-19', '24', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '1970-01-01', '', 'c5dc4139-9bb5-4977-836d-3989421722fb', 'c5dc4139-9bb5-4977-836d-3989421722fb', '', '', '', '78d78b3e-b610-48b0-a3e4-4c4bd54d2191', '', '', '', '2100', '', '', '', '', '', ',  ', '', '', '', '0', '', '0', '', '', '0', '', '0', '', '', '0.00', '', '0.00', '', '0.00', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '0.000', '0.000', '0.000', '', '', '', '0.00', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2025-05-19 14:41:16', '2022-02-24 10:05:39', '1', '0', '', '', '', '', '', '', '0.00', '0.00', '0.00', '', '0', '', '0', '', '0', '', '0', '0.00', '0.00', '0.00', '', '', '', '0', '0', '1', 'testii', '2025-05-19 11:41:16');
INSERT IGNORE INTO `device` (`uuid`, `aindex`, `reg`, `reg_prev`, `reg_unavailable`, `editor`, `inspector`, `title`, `notes`, `EditDate`, `version`, `certificate_latest_int`, `next_usage_inspection`, `next_inside_inspection`, `next_scheduled_pressure`, `next_scheduled_inspection`, `next_other_inspection`, `next_followup`, `next_operational_inspection`, `next_condition_inspection`, `next_seal_inspection`, `inspection_date_latest`, `inspection_date_next`, `running_number`, `running_number_changed`, `running_number_history`, `company_owner`, `company_holder`, `company_manufacturer`, `company_importer`, `person_contact`, `person_supervisor`, `person_supervisor_alt`, `inspector_person_name`, `container_number`, `manufacturing_year`, `manufacturing_number`, `manufacturing_standardby`, `manufacturing_standard`, `location_device`, `location_description`, `location_address`, `location_street`, `location_zip_code`, `location_city`, `category_code`, `category_description`, `subcategory_code`, `subcategory_description`, `substucture_description`, `usage_method_code`, `usage_method_description`, `stucture_code`, `stucture_description`, `stucture_sheat_material`, `stucture_sheat_strength`, `stucture_bottom_material`, `stucture_bottom_strength`, `stucture_topend_material`, `stucture_topend_strength`, `stucture_drawings`, `primary_fuel_code`, `primary_fuel`, `ps_state1_min`, `ps_state1_max`, `ps_state2_min`, `ps_state2_max`, `ps_state3_min`, `ps_state3_max`, `ts_state1_min`, `ts_state1_max`, `ts_state2_min`, `ts_state2_max`, `ts_state3_min`, `ts_state3_max`, `v_state1`, `v_state2`, `v_state3`, `content_primary`, `content_primary_title`, `content_primary_subtitle`, `content_primary_density`, `content_state1`, `content_state1_title`, `content_state1_subtitle`, `content_state2`, `content_state2_title`, `content_state2_subtitle`, `content_state3`, `content_state3_title`, `content_state3_subtitle`, `power_state1`, `power_state2`, `power_state3`, `latest_other_inspection`, `latest_followup`, `latest_seal_inspection`, `latest_condition_inspection`, `latest_operational_inspection`, `latest_scheduled_inspection`, `latest_usage_inspection`, `latest_scheduled_pressure`, `latest_inside_inspection`, `latest_change_inspection`, `cycle_other_inspection`, `cycle_followup`, `cycle_seal_inspection`, `cycle_condition_inspection`, `cycle_operational_inspection`, `cycle_scheduled_inspection`, `cycle_usage_inspection`, `cycle_scheduled_pressure`, `cycle_inside_inspection`, `UpdateTime`, `InsertTime`, `orbeon_import_allowed`, `orbeon_imported`, `title_state1`, `title_state2`, `title_state3`, `location_state1`, `location_state2`, `location_state3`, `dn_state1`, `dn_state2`, `dn_state3`, `person_supervisor_role`, `person_supervisor_role_code`, `person_supervisor_alt_role`, `person_supervisor_alt_role_code`, `person_supervisor_alt_qualification`, `person_supervisor_alt_qualification_code`, `person_supervisor_qualification`, `person_supervisor_qualification_code`, `primary_diameter`, `primary_volume`, `primary_lenght`, `primary_class`, `class_description`, `safety_device_description`, `running_number_static`, `delete_allowed`, `archived`, `archive_reason`, `archived_at`) VALUES ('2cdec44e-c28e-452b-b320-cbe093fb67ef', '34396', 'K-600443', 'K-600443', '0', '46d229b0-33af-06a1-91ff-2267bca9ae56', '12178278-346e-4b67-901a-89edb81e4bc5', 'Tukes Testi 541', '', '2025-05-12', '32', '3301200', '0', '0', '1', '0', '1', '0', '0', '0', '0', '2024-06-05', '2024-06-12', '1', '2024-08-27', '2024-08-27 = 1\n', 'c5dc4139-9bb5-4977-836d-3989421722fb', 'c5dc4139-9bb5-4977-836d-3989421722fb', '', '', '', '0cf92dc3-de04-47e2-8d86-405985ce5d88', '', 'Stefan Simonsén', '', '1800', 'X898989', '', 'EN 12952', 'X123', 'Hallissa', ',  ', 'Paineenkatu 123', '33410', 'Tampere', '0', 'Kattila', '11', 'Höyrykattila', '', '4', 'Jaksottainen', '3', 'Muu kattila', '', '0.00', '', '0.00', '', '0.00', '', '9', 'Jätelämpö', '10', '10', '60', '80', '', '', '11', '11', '60', '80', '', '', '12.000', '80.000', '0.000', '', '', '', '0.00', '1973', 'KLOORIDIFLUORIMETAANIN JA KLOORIPENTAFLUORIETAANIN SEOS, jolla on kiinteä kiehumispiste ja joka sisältää noin 49 % klooridifluorimetaania (KYLMÄAINEKAASU R 502)', '', '', '', '', '', '', '', '13.00', '60.00', '0.00', '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2025-05-19 14:40:00', '2022-02-24 10:16:33', '1', '0', '', 'Testaus', '', '', '', '', '0.00', '0.00', '0.00', 'Omistaja', '1', 'Haltija', '2', 'Konemestari', '2', 'Poikkeuslupa', '7', '0.00', '0.00', '0.00', '', 'I-luokan laite (PED)', 'Varoventtiili', '1', '0', '0', '', '');
INSERT IGNORE INTO `device` (`uuid`, `aindex`, `reg`, `reg_prev`, `reg_unavailable`, `editor`, `inspector`, `title`, `notes`, `EditDate`, `version`, `certificate_latest_int`, `next_usage_inspection`, `next_inside_inspection`, `next_scheduled_pressure`, `next_scheduled_inspection`, `next_other_inspection`, `next_followup`, `next_operational_inspection`, `next_condition_inspection`, `next_seal_inspection`, `inspection_date_latest`, `inspection_date_next`, `running_number`, `running_number_changed`, `running_number_history`, `company_owner`, `company_holder`, `company_manufacturer`, `company_importer`, `person_contact`, `person_supervisor`, `person_supervisor_alt`, `inspector_person_name`, `container_number`, `manufacturing_year`, `manufacturing_number`, `manufacturing_standardby`, `manufacturing_standard`, `location_device`, `location_description`, `location_address`, `location_street`, `location_zip_code`, `location_city`, `category_code`, `category_description`, `subcategory_code`, `subcategory_description`, `substucture_description`, `usage_method_code`, `usage_method_description`, `stucture_code`, `stucture_description`, `stucture_sheat_material`, `stucture_sheat_strength`, `stucture_bottom_material`, `stucture_bottom_strength`, `stucture_topend_material`, `stucture_topend_strength`, `stucture_drawings`, `primary_fuel_code`, `primary_fuel`, `ps_state1_min`, `ps_state1_max`, `ps_state2_min`, `ps_state2_max`, `ps_state3_min`, `ps_state3_max`, `ts_state1_min`, `ts_state1_max`, `ts_state2_min`, `ts_state2_max`, `ts_state3_min`, `ts_state3_max`, `v_state1`, `v_state2`, `v_state3`, `content_primary`, `content_primary_title`, `content_primary_subtitle`, `content_primary_density`, `content_state1`, `content_state1_title`, `content_state1_subtitle`, `content_state2`, `content_state2_title`, `content_state2_subtitle`, `content_state3`, `content_state3_title`, `content_state3_subtitle`, `power_state1`, `power_state2`, `power_state3`, `latest_other_inspection`, `latest_followup`, `latest_seal_inspection`, `latest_condition_inspection`, `latest_operational_inspection`, `latest_scheduled_inspection`, `latest_usage_inspection`, `latest_scheduled_pressure`, `latest_inside_inspection`, `latest_change_inspection`, `cycle_other_inspection`, `cycle_followup`, `cycle_seal_inspection`, `cycle_condition_inspection`, `cycle_operational_inspection`, `cycle_scheduled_inspection`, `cycle_usage_inspection`, `cycle_scheduled_pressure`, `cycle_inside_inspection`, `UpdateTime`, `InsertTime`, `orbeon_import_allowed`, `orbeon_imported`, `title_state1`, `title_state2`, `title_state3`, `location_state1`, `location_state2`, `location_state3`, `dn_state1`, `dn_state2`, `dn_state3`, `person_supervisor_role`, `person_supervisor_role_code`, `person_supervisor_alt_role`, `person_supervisor_alt_role_code`, `person_supervisor_alt_qualification`, `person_supervisor_alt_qualification_code`, `person_supervisor_qualification`, `person_supervisor_qualification_code`, `primary_diameter`, `primary_volume`, `primary_lenght`, `primary_class`, `class_description`, `safety_device_description`, `running_number_static`, `delete_allowed`, `archived`, `archive_reason`, `archived_at`) VALUES ('4af78f2b-fccb-4116-a2a6-f0bbd38b5633', '34401', '', 'A-10001', '1', '46d229b0-33af-06a1-91ff-2267bca9ae56', '46d229b0-33af-06a1-91ff-2267bca9ae56', '', '', '2025-05-15', '54', '0100024', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2025-03-05', '2222-12-12', '5', '2023-06-19', '2022-04-13=1\n2023-01-18 = 2\n2023-01-18 = 3\n2023-01-18 = 4\n2023-06-19 = 5\n', 'c5dc4139-9bb5-4977-836d-3989421722fb', 'c5dc4139-9bb5-4977-836d-3989421722fb', 'f25fd55f-75e4-ff8c-bd54-a710ec8d7d7e', '', '', '0efa46da-4865-4945-8432-59742a091041', '78d78b3e-b610-48b0-a3e4-4c4bd54d2191', '', '', '2022', '12367', '', 'SFS-EN 145372', 'S341', 'Tuotantohalli', ',  ', 'Erittäin pitkä Tuotetestaajankatu 3001', '21000', 'NOORMARKKU', '0', 'Painesäiliö', '25', 'Autoklaavi', '', '0', '', '0', '', '', '0.00', '', '0.00', '', '0.00', '', '8', 'Sähkö', '', '12', '', '', '', '', '', '250', '', '', '', '', '15.000', '0.000', '0.000', '', '', '', '0.00', '1002', 'ILMA, PURISTETTU', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '2', '8', '4', '2025-05-19 14:40:00', '2022-02-25 13:21:17', '1', '0', 'Erityinen tila', '', '', '', '', '', '0.00', '0.00', '0.00', 'Omistaja', '1', 'Omistaja', '1', 'Riittävä asiantuntemus', '0', 'DI/ins. Kattilalaitoksen käytön valvojana', '6', '0.00', '0.00', '0.00', '', 'IV-luokan laite (PED)', '', '5', '0', '0', '', '');
INSERT IGNORE INTO `device` (`uuid`, `aindex`, `reg`, `reg_prev`, `reg_unavailable`, `editor`, `inspector`, `title`, `notes`, `EditDate`, `version`, `certificate_latest_int`, `next_usage_inspection`, `next_inside_inspection`, `next_scheduled_pressure`, `next_scheduled_inspection`, `next_other_inspection`, `next_followup`, `next_operational_inspection`, `next_condition_inspection`, `next_seal_inspection`, `inspection_date_latest`, `inspection_date_next`, `running_number`, `running_number_changed`, `running_number_history`, `company_owner`, `company_holder`, `company_manufacturer`, `company_importer`, `person_contact`, `person_supervisor`, `person_supervisor_alt`, `inspector_person_name`, `container_number`, `manufacturing_year`, `manufacturing_number`, `manufacturing_standardby`, `manufacturing_standard`, `location_device`, `location_description`, `location_address`, `location_street`, `location_zip_code`, `location_city`, `category_code`, `category_description`, `subcategory_code`, `subcategory_description`, `substucture_description`, `usage_method_code`, `usage_method_description`, `stucture_code`, `stucture_description`, `stucture_sheat_material`, `stucture_sheat_strength`, `stucture_bottom_material`, `stucture_bottom_strength`, `stucture_topend_material`, `stucture_topend_strength`, `stucture_drawings`, `primary_fuel_code`, `primary_fuel`, `ps_state1_min`, `ps_state1_max`, `ps_state2_min`, `ps_state2_max`, `ps_state3_min`, `ps_state3_max`, `ts_state1_min`, `ts_state1_max`, `ts_state2_min`, `ts_state2_max`, `ts_state3_min`, `ts_state3_max`, `v_state1`, `v_state2`, `v_state3`, `content_primary`, `content_primary_title`, `content_primary_subtitle`, `content_primary_density`, `content_state1`, `content_state1_title`, `content_state1_subtitle`, `content_state2`, `content_state2_title`, `content_state2_subtitle`, `content_state3`, `content_state3_title`, `content_state3_subtitle`, `power_state1`, `power_state2`, `power_state3`, `latest_other_inspection`, `latest_followup`, `latest_seal_inspection`, `latest_condition_inspection`, `latest_operational_inspection`, `latest_scheduled_inspection`, `latest_usage_inspection`, `latest_scheduled_pressure`, `latest_inside_inspection`, `latest_change_inspection`, `cycle_other_inspection`, `cycle_followup`, `cycle_seal_inspection`, `cycle_condition_inspection`, `cycle_operational_inspection`, `cycle_scheduled_inspection`, `cycle_usage_inspection`, `cycle_scheduled_pressure`, `cycle_inside_inspection`, `UpdateTime`, `InsertTime`, `orbeon_import_allowed`, `orbeon_imported`, `title_state1`, `title_state2`, `title_state3`, `location_state1`, `location_state2`, `location_state3`, `dn_state1`, `dn_state2`, `dn_state3`, `person_supervisor_role`, `person_supervisor_role_code`, `person_supervisor_alt_role`, `person_supervisor_alt_role_code`, `person_supervisor_alt_qualification`, `person_supervisor_alt_qualification_code`, `person_supervisor_qualification`, `person_supervisor_qualification_code`, `primary_diameter`, `primary_volume`, `primary_lenght`, `primary_class`, `class_description`, `safety_device_description`, `running_number_static`, `delete_allowed`, `archived`, `archive_reason`, `archived_at`) VALUES ('90d9c017-ee7f-4bad-91cb-64c4f8245730', '34402', 'K-23456', 'K-23456', '0', '46d229b0-33af-06a1-91ff-2267bca9ae56', '12178278-346e-4b67-901a-89edb81e4bc5', 'Muokkausta', 'Testilaite kaiketi? // ss', '2025-05-19', '28', '21000229', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '21', '1970-01-01', '', 'c5dc4139-9bb5-4977-836d-3989421722fb', 'c5dc4139-9bb5-4977-836d-3989421722fb', 'f25fd55f-75e4-ff8c-bd54-a710ec8d7d7e', 'f25fd55f-75e4-ff8c-bd54-a710ec8d7d7e', '', '78d78b3e-b610-48b0-a3e4-4c4bd54d2191', '', 'Stefan Simonsén', '', '2099', 'X12345', '', '', '', '', ',  ', 'Mallitie 13', '', '', '0', 'Kattila', '11', 'Höyrykattila', '', '2', 'Jaksottainen valvonta', '2', 'Vesiputkikattila', '', '0.00', '', '0.00', '', '0.00', '', '10', 'Muu', '10', '100', '11', '111', '', '', '11', '101', '22', '222', '', '', '123.000', '321.000', '0.000', '', '', '', '0.00', '1002', 'Ilma', '', '0000', 'Vesi(höyry)', '', '', '', '', '222.00', '0.00', '0.00', '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2025-05-19 14:40:00', '2022-02-25 14:13:48', '1', '0', '', '', '', '', '', '', '0.00', '0.00', '0.00', 'Omistaja', '1', '', '0', '', '0', 'Riittävä asiantuntemus', '8', '0.00', '0.00', '0.00', '', '', 'Varoventtiili', '21', '0', '0', '', '');
INSERT IGNORE INTO `device` (`uuid`, `aindex`, `reg`, `reg_prev`, `reg_unavailable`, `editor`, `inspector`, `title`, `notes`, `EditDate`, `version`, `certificate_latest_int`, `next_usage_inspection`, `next_inside_inspection`, `next_scheduled_pressure`, `next_scheduled_inspection`, `next_other_inspection`, `next_followup`, `next_operational_inspection`, `next_condition_inspection`, `next_seal_inspection`, `inspection_date_latest`, `inspection_date_next`, `running_number`, `running_number_changed`, `running_number_history`, `company_owner`, `company_holder`, `company_manufacturer`, `company_importer`, `person_contact`, `person_supervisor`, `person_supervisor_alt`, `inspector_person_name`, `container_number`, `manufacturing_year`, `manufacturing_number`, `manufacturing_standardby`, `manufacturing_standard`, `location_device`, `location_description`, `location_address`, `location_street`, `location_zip_code`, `location_city`, `category_code`, `category_description`, `subcategory_code`, `subcategory_description`, `substucture_description`, `usage_method_code`, `usage_method_description`, `stucture_code`, `stucture_description`, `stucture_sheat_material`, `stucture_sheat_strength`, `stucture_bottom_material`, `stucture_bottom_strength`, `stucture_topend_material`, `stucture_topend_strength`, `stucture_drawings`, `primary_fuel_code`, `primary_fuel`, `ps_state1_min`, `ps_state1_max`, `ps_state2_min`, `ps_state2_max`, `ps_state3_min`, `ps_state3_max`, `ts_state1_min`, `ts_state1_max`, `ts_state2_min`, `ts_state2_max`, `ts_state3_min`, `ts_state3_max`, `v_state1`, `v_state2`, `v_state3`, `content_primary`, `content_primary_title`, `content_primary_subtitle`, `content_primary_density`, `content_state1`, `content_state1_title`, `content_state1_subtitle`, `content_state2`, `content_state2_title`, `content_state2_subtitle`, `content_state3`, `content_state3_title`, `content_state3_subtitle`, `power_state1`, `power_state2`, `power_state3`, `latest_other_inspection`, `latest_followup`, `latest_seal_inspection`, `latest_condition_inspection`, `latest_operational_inspection`, `latest_scheduled_inspection`, `latest_usage_inspection`, `latest_scheduled_pressure`, `latest_inside_inspection`, `latest_change_inspection`, `cycle_other_inspection`, `cycle_followup`, `cycle_seal_inspection`, `cycle_condition_inspection`, `cycle_operational_inspection`, `cycle_scheduled_inspection`, `cycle_usage_inspection`, `cycle_scheduled_pressure`, `cycle_inside_inspection`, `UpdateTime`, `InsertTime`, `orbeon_import_allowed`, `orbeon_imported`, `title_state1`, `title_state2`, `title_state3`, `location_state1`, `location_state2`, `location_state3`, `dn_state1`, `dn_state2`, `dn_state3`, `person_supervisor_role`, `person_supervisor_role_code`, `person_supervisor_alt_role`, `person_supervisor_alt_role_code`, `person_supervisor_alt_qualification`, `person_supervisor_alt_qualification_code`, `person_supervisor_qualification`, `person_supervisor_qualification_code`, `primary_diameter`, `primary_volume`, `primary_lenght`, `primary_class`, `class_description`, `safety_device_description`, `running_number_static`, `delete_allowed`, `archived`, `archive_reason`, `archived_at`) VALUES ('2f0cbc9c-56dd-4a96-beee-b721235bb145', '34616', 'X-1002', '', '0', '12178278-346e-4b67-901a-89edb81e4bc5', '', 'TESTILAITE', '', '2024-09-26', '6', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '1970-01-01', '', 'f25fd55f-75e4-ff8c-bd54-a710ec8d7d7e', 'ee67dfd8-85ab-4dce-bd0c-503b3540e540', '', 'ee67dfd8-85ab-4dce-bd0c-503b3540e540', '', '0cf92dc3-de04-47e2-8d86-405985ce5d88', '', '', '', '2099', '508006', '', 'EN 12952', '', '', ',  ', '', '', '', '0', 'Painesäiliö', '25', 'Autoklaavi', '', '0', '', '0', '', '', '0.00', '', '0.00', '', '0.00', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '0.000', '0.000', '0.000', '', '', '', '0.00', '2831', '1,1,1-TRIKLOORIETAANI', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2025-05-19 14:40:00', '2022-12-12 05:43:20', '1', '0', '', '', '', '', '', '', '0.00', '0.00', '0.00', '', '0', '', '0', '', '0', '', '0', '0.00', '0.00', '0.00', '', 'SEP', 'Varoventtiili', '0', '0', '0', '', '');
INSERT IGNORE INTO `device` (`uuid`, `aindex`, `reg`, `reg_prev`, `reg_unavailable`, `editor`, `inspector`, `title`, `notes`, `EditDate`, `version`, `certificate_latest_int`, `next_usage_inspection`, `next_inside_inspection`, `next_scheduled_pressure`, `next_scheduled_inspection`, `next_other_inspection`, `next_followup`, `next_operational_inspection`, `next_condition_inspection`, `next_seal_inspection`, `inspection_date_latest`, `inspection_date_next`, `running_number`, `running_number_changed`, `running_number_history`, `company_owner`, `company_holder`, `company_manufacturer`, `company_importer`, `person_contact`, `person_supervisor`, `person_supervisor_alt`, `inspector_person_name`, `container_number`, `manufacturing_year`, `manufacturing_number`, `manufacturing_standardby`, `manufacturing_standard`, `location_device`, `location_description`, `location_address`, `location_street`, `location_zip_code`, `location_city`, `category_code`, `category_description`, `subcategory_code`, `subcategory_description`, `substucture_description`, `usage_method_code`, `usage_method_description`, `stucture_code`, `stucture_description`, `stucture_sheat_material`, `stucture_sheat_strength`, `stucture_bottom_material`, `stucture_bottom_strength`, `stucture_topend_material`, `stucture_topend_strength`, `stucture_drawings`, `primary_fuel_code`, `primary_fuel`, `ps_state1_min`, `ps_state1_max`, `ps_state2_min`, `ps_state2_max`, `ps_state3_min`, `ps_state3_max`, `ts_state1_min`, `ts_state1_max`, `ts_state2_min`, `ts_state2_max`, `ts_state3_min`, `ts_state3_max`, `v_state1`, `v_state2`, `v_state3`, `content_primary`, `content_primary_title`, `content_primary_subtitle`, `content_primary_density`, `content_state1`, `content_state1_title`, `content_state1_subtitle`, `content_state2`, `content_state2_title`, `content_state2_subtitle`, `content_state3`, `content_state3_title`, `content_state3_subtitle`, `power_state1`, `power_state2`, `power_state3`, `latest_other_inspection`, `latest_followup`, `latest_seal_inspection`, `latest_condition_inspection`, `latest_operational_inspection`, `latest_scheduled_inspection`, `latest_usage_inspection`, `latest_scheduled_pressure`, `latest_inside_inspection`, `latest_change_inspection`, `cycle_other_inspection`, `cycle_followup`, `cycle_seal_inspection`, `cycle_condition_inspection`, `cycle_operational_inspection`, `cycle_scheduled_inspection`, `cycle_usage_inspection`, `cycle_scheduled_pressure`, `cycle_inside_inspection`, `UpdateTime`, `InsertTime`, `orbeon_import_allowed`, `orbeon_imported`, `title_state1`, `title_state2`, `title_state3`, `location_state1`, `location_state2`, `location_state3`, `dn_state1`, `dn_state2`, `dn_state3`, `person_supervisor_role`, `person_supervisor_role_code`, `person_supervisor_alt_role`, `person_supervisor_alt_role_code`, `person_supervisor_alt_qualification`, `person_supervisor_alt_qualification_code`, `person_supervisor_qualification`, `person_supervisor_qualification_code`, `primary_diameter`, `primary_volume`, `primary_lenght`, `primary_class`, `class_description`, `safety_device_description`, `running_number_static`, `delete_allowed`, `archived`, `archive_reason`, `archived_at`) VALUES ('a79be73d-4b30-4bbd-bec0-877c52a4fac1', '34818', '', '', '0', '46d229b0-33af-06a1-91ff-2267bca9ae56', '46d229b0-33af-06a1-91ff-2267bca9ae56', 'X TESTI 20231108', '', '2025-05-12', '4', '0100012', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2025-03-04', '1222-12-12', '0', '1970-01-01', '', '', '', '', '', '', '', '', '', '', '2099', '', '', '', '', '', ',  ', '', '', '', '0', 'Kemikaalisäiliö', '0', '', '', '0', '', '0', '', '', '0.00', '', '0.00', '', '0.00', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '0.000', '0.000', '0.000', '', '', 'DDS', '0.00', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2025-05-19 14:40:00', '2023-11-08 15:45:44', '1', '0', '', '', '', '', '', '', '0.00', '0.00', '0.00', '', '0', '', '0', '', '0', '', '0', '0.00', '0.00', '0.00', '', '', '', '0', '0', '0', '', '');
INSERT IGNORE INTO `device` (`uuid`, `aindex`, `reg`, `reg_prev`, `reg_unavailable`, `editor`, `inspector`, `title`, `notes`, `EditDate`, `version`, `certificate_latest_int`, `next_usage_inspection`, `next_inside_inspection`, `next_scheduled_pressure`, `next_scheduled_inspection`, `next_other_inspection`, `next_followup`, `next_operational_inspection`, `next_condition_inspection`, `next_seal_inspection`, `inspection_date_latest`, `inspection_date_next`, `running_number`, `running_number_changed`, `running_number_history`, `company_owner`, `company_holder`, `company_manufacturer`, `company_importer`, `person_contact`, `person_supervisor`, `person_supervisor_alt`, `inspector_person_name`, `container_number`, `manufacturing_year`, `manufacturing_number`, `manufacturing_standardby`, `manufacturing_standard`, `location_device`, `location_description`, `location_address`, `location_street`, `location_zip_code`, `location_city`, `category_code`, `category_description`, `subcategory_code`, `subcategory_description`, `substucture_description`, `usage_method_code`, `usage_method_description`, `stucture_code`, `stucture_description`, `stucture_sheat_material`, `stucture_sheat_strength`, `stucture_bottom_material`, `stucture_bottom_strength`, `stucture_topend_material`, `stucture_topend_strength`, `stucture_drawings`, `primary_fuel_code`, `primary_fuel`, `ps_state1_min`, `ps_state1_max`, `ps_state2_min`, `ps_state2_max`, `ps_state3_min`, `ps_state3_max`, `ts_state1_min`, `ts_state1_max`, `ts_state2_min`, `ts_state2_max`, `ts_state3_min`, `ts_state3_max`, `v_state1`, `v_state2`, `v_state3`, `content_primary`, `content_primary_title`, `content_primary_subtitle`, `content_primary_density`, `content_state1`, `content_state1_title`, `content_state1_subtitle`, `content_state2`, `content_state2_title`, `content_state2_subtitle`, `content_state3`, `content_state3_title`, `content_state3_subtitle`, `power_state1`, `power_state2`, `power_state3`, `latest_other_inspection`, `latest_followup`, `latest_seal_inspection`, `latest_condition_inspection`, `latest_operational_inspection`, `latest_scheduled_inspection`, `latest_usage_inspection`, `latest_scheduled_pressure`, `latest_inside_inspection`, `latest_change_inspection`, `cycle_other_inspection`, `cycle_followup`, `cycle_seal_inspection`, `cycle_condition_inspection`, `cycle_operational_inspection`, `cycle_scheduled_inspection`, `cycle_usage_inspection`, `cycle_scheduled_pressure`, `cycle_inside_inspection`, `UpdateTime`, `InsertTime`, `orbeon_import_allowed`, `orbeon_imported`, `title_state1`, `title_state2`, `title_state3`, `location_state1`, `location_state2`, `location_state3`, `dn_state1`, `dn_state2`, `dn_state3`, `person_supervisor_role`, `person_supervisor_role_code`, `person_supervisor_alt_role`, `person_supervisor_alt_role_code`, `person_supervisor_alt_qualification`, `person_supervisor_alt_qualification_code`, `person_supervisor_qualification`, `person_supervisor_qualification_code`, `primary_diameter`, `primary_volume`, `primary_lenght`, `primary_class`, `class_description`, `safety_device_description`, `running_number_static`, `delete_allowed`, `archived`, `archive_reason`, `archived_at`) VALUES ('f0ce0095-bdfb-45d1-a138-b7e30bb84bbd', '35098', 'A-600438', 'A-600438', '0', '46d229b0-33af-06a1-91ff-2267bca9ae56', '12178278-346e-4b67-901a-89edb81e4bc5', 'Tukes Testi 1', '', '2025-05-12', '35', 'XX03826', '1', '0', '1', '0', '0', '0', '0', '0', '0', '2024-09-24', '2025-03-13', '1', '2024-08-27', '2024-08-27 = 1\n', 'c5dc4139-9bb5-4977-836d-3989421722fb', 'c5dc4139-9bb5-4977-836d-3989421722fb', '', '', '', '0cf92dc3-de04-47e2-8d86-405985ce5d88', '78d78b3e-b610-48b0-a3e4-4c4bd54d2191', 'Stefan Simonsén', '', '1800', 'X898989', '', 'EN 12952', 'X123', 'Hallissa', ',  ', 'Paineenkatu 123', '33410', 'Tampere', '0', 'Kattila', '11', 'Höyrykattila', '', '4', 'Jaksottainen', '3', 'Muu kattila', '', '0.00', '', '0.00', '', '0.00', '', '9', 'Jätelämpö', '10', '10', '', '80', '', '', '11', '11', '', '10', '', '', '12.000', '0.000', '0.000', '', '', '', '0.00', '2377', '1,1-DIMETOKSIETAANI', '', '3159', '1,1,1,2-TETRAFLUORIETAANI (KYLMÄAINEKAASU R 134a)', '', '', '', '', '13.00', '0.00', '0.00', '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2025-05-19 14:40:00', '2024-09-23 06:19:11', '1', '0', '', '', '', '', '', '', '0.00', '0.00', '0.00', 'Omistaja', '1', 'Haltija', '2', 'A-koneenhoitaja', '4', 'Riittävä asiantuntemus', '8', '0.00', '0.00', '0.00', '', 'I-luokan laite (PED)', 'Varoventtiili', '1', '0', '0', '', '');
INSERT IGNORE INTO `device` (`uuid`, `aindex`, `reg`, `reg_prev`, `reg_unavailable`, `editor`, `inspector`, `title`, `notes`, `EditDate`, `version`, `certificate_latest_int`, `next_usage_inspection`, `next_inside_inspection`, `next_scheduled_pressure`, `next_scheduled_inspection`, `next_other_inspection`, `next_followup`, `next_operational_inspection`, `next_condition_inspection`, `next_seal_inspection`, `inspection_date_latest`, `inspection_date_next`, `running_number`, `running_number_changed`, `running_number_history`, `company_owner`, `company_holder`, `company_manufacturer`, `company_importer`, `person_contact`, `person_supervisor`, `person_supervisor_alt`, `inspector_person_name`, `container_number`, `manufacturing_year`, `manufacturing_number`, `manufacturing_standardby`, `manufacturing_standard`, `location_device`, `location_description`, `location_address`, `location_street`, `location_zip_code`, `location_city`, `category_code`, `category_description`, `subcategory_code`, `subcategory_description`, `substucture_description`, `usage_method_code`, `usage_method_description`, `stucture_code`, `stucture_description`, `stucture_sheat_material`, `stucture_sheat_strength`, `stucture_bottom_material`, `stucture_bottom_strength`, `stucture_topend_material`, `stucture_topend_strength`, `stucture_drawings`, `primary_fuel_code`, `primary_fuel`, `ps_state1_min`, `ps_state1_max`, `ps_state2_min`, `ps_state2_max`, `ps_state3_min`, `ps_state3_max`, `ts_state1_min`, `ts_state1_max`, `ts_state2_min`, `ts_state2_max`, `ts_state3_min`, `ts_state3_max`, `v_state1`, `v_state2`, `v_state3`, `content_primary`, `content_primary_title`, `content_primary_subtitle`, `content_primary_density`, `content_state1`, `content_state1_title`, `content_state1_subtitle`, `content_state2`, `content_state2_title`, `content_state2_subtitle`, `content_state3`, `content_state3_title`, `content_state3_subtitle`, `power_state1`, `power_state2`, `power_state3`, `latest_other_inspection`, `latest_followup`, `latest_seal_inspection`, `latest_condition_inspection`, `latest_operational_inspection`, `latest_scheduled_inspection`, `latest_usage_inspection`, `latest_scheduled_pressure`, `latest_inside_inspection`, `latest_change_inspection`, `cycle_other_inspection`, `cycle_followup`, `cycle_seal_inspection`, `cycle_condition_inspection`, `cycle_operational_inspection`, `cycle_scheduled_inspection`, `cycle_usage_inspection`, `cycle_scheduled_pressure`, `cycle_inside_inspection`, `UpdateTime`, `InsertTime`, `orbeon_import_allowed`, `orbeon_imported`, `title_state1`, `title_state2`, `title_state3`, `location_state1`, `location_state2`, `location_state3`, `dn_state1`, `dn_state2`, `dn_state3`, `person_supervisor_role`, `person_supervisor_role_code`, `person_supervisor_alt_role`, `person_supervisor_alt_role_code`, `person_supervisor_alt_qualification`, `person_supervisor_alt_qualification_code`, `person_supervisor_qualification`, `person_supervisor_qualification_code`, `primary_diameter`, `primary_volume`, `primary_lenght`, `primary_class`, `class_description`, `safety_device_description`, `running_number_static`, `delete_allowed`, `archived`, `archive_reason`, `archived_at`) VALUES ('eceb5412-a0ef-4aaf-9043-945a70a3405b', '35107', 'X-88552', 'X-88552', '0', '46d229b0-33af-06a1-91ff-2267bca9ae56', '', 'Testilaite', '', '2025-05-12', '3', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '', '0', '1970-01-01', '', '', '', '', '', '', '', '', '', '', '1800', '', '', '', '', '', ',  ', '', '', '', '0', 'Kattila', '25', 'Autoklaavi', '', '0', '', '0', '', '', '0.00', '', '0.00', '', '0.00', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '0.000', '0.000', '0.000', '', '', '', '0.00', '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', '', '', '', '', '', '', '', '', '', '', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2025-05-19 14:40:00', '2024-09-27 03:01:08', '1', '0', '', '', '', '', '', '', '0.00', '0.00', '0.00', '', '0', '', '0', '', '0', '', '0', '0.00', '0.00', '0.00', '', '', '', '0', '0', '0', '', '');
