SoloDB Documentation version 0.1-DEV 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;
Last modified: 07 April 2025