Clean up all processes and equipment
Run this query to remove all templates from the database. This will also remove all files associated with the templates.
SET
FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE process_category;
TRUNCATE TABLE process_category_type;
TRUNCATE TABLE process_module;
TRUNCATE TABLE process_module_hidden_parameter;
TRUNCATE TABLE process_module_parameter;
TRUNCATE TABLE process_module_parameter_value;
TRUNCATE TABLE process_module_recipe;
TRUNCATE TABLE process_module_recipe_changelog;
TRUNCATE TABLE process_module_recipe_checklist;
TRUNCATE TABLE process_module_recipe_file;
TRUNCATE TABLE process_module_recipe_parameter;
TRUNCATE TABLE process_module_recipe_parameter_value;
TRUNCATE TABLE process_module_recipe_rework;
TRUNCATE TABLE process_module_recipe_type;
TRUNCATE TABLE process_module_recipe_version;
TRUNCATE TABLE process_module_recipe_version_checklist;
TRUNCATE TABLE process_module_recipe_version_parameter;
TRUNCATE TABLE process_module_recipe_version_parameter_value;
TRUNCATE TABLE process_parameter;
TRUNCATE TABLE process_parameter_consumable_type;
TRUNCATE TABLE process_parameter_type;
TRUNCATE TABLE process_parameter_type_unit;
TRUNCATE TABLE process_process;
TRUNCATE TABLE process_process_file;
TRUNCATE TABLE process_type;
TRUNCATE TABLE process_unit;
TRUNCATE TABLE equipment_category;
TRUNCATE TABLE equipment_category_type;
TRUNCATE TABLE equipment_category_type_property;
TRUNCATE TABLE equipment_document;
TRUNCATE TABLE equipment_equipment;
TRUNCATE TABLE equipment_equipment_category_type;
TRUNCATE TABLE equipment_equipment_document_file;
TRUNCATE TABLE equipment_equipment_link;
TRUNCATE TABLE equipment_equipment_link_type;
TRUNCATE TABLE equipment_equipment_preventive_maintenance_maintenance;
TRUNCATE TABLE equipment_equipment_preventive_maintenance_maintenance_file;
TRUNCATE TABLE equipment_equipment_preventive_maintenance_schedule;
TRUNCATE TABLE equipment_equipment_preventive_maintenance_schedule_file;
TRUNCATE TABLE equipment_equipment_property;
TRUNCATE TABLE equipment_equipment_request;
TRUNCATE TABLE equipment_equipment_request_flow;
TRUNCATE TABLE equipment_equipment_role;
TRUNCATE TABLE equipment_equipment_user;
TRUNCATE TABLE equipment_file;
TRUNCATE TABLE equipment_logging;
TRUNCATE TABLE equipment_logging_column;
TRUNCATE TABLE equipment_logging_direct_value;
TRUNCATE TABLE equipment_logging_identifier_value;
TRUNCATE TABLE equipment_logging_parameter;
TRUNCATE TABLE equipment_logging_parameter_equipment;
TRUNCATE TABLE equipment_logging_service;
TRUNCATE TABLE equipment_logging_service_method;
TRUNCATE TABLE equipment_logging_service_method_parameter;
TRUNCATE TABLE equipment_logging_service_processing_method;
TRUNCATE TABLE equipment_logging_service_processing_method_parameter;
TRUNCATE TABLE equipment_logging_service_processing_method_result;
TRUNCATE TABLE equipment_logging_service_processing_method_result_parameter;
TRUNCATE TABLE equipment_module;
TRUNCATE TABLE equipment_module_asset;
TRUNCATE TABLE equipment_module_asset_function;
TRUNCATE TABLE equipment_module_changelog;
TRUNCATE TABLE equipment_module_ecn;
TRUNCATE TABLE equipment_module_ecn_attachment;
TRUNCATE TABLE equipment_module_ecn_attachment_file;
TRUNCATE TABLE equipment_module_external_activity;
TRUNCATE TABLE equipment_module_external_activity_type;
TRUNCATE TABLE equipment_module_facility;
TRUNCATE TABLE equipment_module_function;
TRUNCATE TABLE equipment_module_function_property;
TRUNCATE TABLE equipment_module_group;
TRUNCATE TABLE equipment_module_group_group;
TRUNCATE TABLE equipment_module_issue;
TRUNCATE TABLE equipment_module_issue_attachment;
TRUNCATE TABLE equipment_module_issue_attachment_file;
TRUNCATE TABLE equipment_module_parameter;
TRUNCATE TABLE equipment_module_parameter_value;
TRUNCATE TABLE equipment_module_property;
TRUNCATE TABLE equipment_module_status;
TRUNCATE TABLE equipment_module_status_attachment;
TRUNCATE TABLE equipment_module_status_attachment_file;
TRUNCATE TABLE equipment_monitor;
TRUNCATE TABLE equipment_monitor_changelog;
TRUNCATE TABLE equipment_monitor_file_file;
TRUNCATE TABLE equipment_monitor_measurement;
TRUNCATE TABLE equipment_monitor_measurement_label;
TRUNCATE TABLE equipment_monitor_measurement_logging_parameter;
TRUNCATE TABLE equipment_monitor_measurement_result;
TRUNCATE TABLE equipment_monitor_measurement_result_process_parameter_value;
TRUNCATE TABLE equipment_monitor_measurement_result_value;
TRUNCATE TABLE equipment_monitor_requirement;
TRUNCATE TABLE equipment_monitor_requirement_label;
TRUNCATE TABLE equipment_monitor_requirement_module_status_change;
TRUNCATE TABLE equipment_monitor_requirement_module_status_change_from_status;
TRUNCATE TABLE equipment_monitor_requirement_module_status_change_targets;
TRUNCATE TABLE equipment_monitor_requirement_target;
TRUNCATE TABLE equipment_monitor_run;
TRUNCATE TABLE equipment_monitor_schedule;
TRUNCATE TABLE equipment_monitor_step;
TRUNCATE TABLE equipment_monitor_step_file;
TRUNCATE TABLE equipment_monitor_step_group;
TRUNCATE TABLE equipment_monitor_step_label;
TRUNCATE TABLE equipment_monitor_step_parameter;
TRUNCATE TABLE equipment_monitor_step_parameter_value;
TRUNCATE TABLE equipment_monitor_step_tag;
TRUNCATE TABLE equipment_monitor_user;
TRUNCATE TABLE equipment_monitor_variable;
TRUNCATE TABLE equipment_picture;
TRUNCATE TABLE equipment_property;
TRUNCATE TABLE equipment_reservation;
TRUNCATE TABLE equipment_reservation_block;
TRUNCATE TABLE equipment_reservation_module;
TRUNCATE TABLE equipment_reservation_module_asset;
TRUNCATE TABLE equipment_setup;
TRUNCATE TABLE equipment_setup_equipment;
TRUNCATE TABLE equipment_statusmail;
SET
FOREIGN_KEY_CHECKS = 1;
Last modified: 07 April 2025