SoloDB Documentation Version 1.0 Help

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;
07 April 2025