Remove clients, accounts, domains but leave settings & products
If you're done testing HostBill, and like to start with clean state but leave your settings & products configured intact, use SQL queries below on HostBill database to clear unwanted data:
Clean database for production
TRUNCATE hb_account_logs; TRUNCATE hb_account_metrics; TRUNCATE hb_accounts2servers; TRUNCATE hb_accounts; TRUNCATE hb_accounts_addons; TRUNCATE hb_accounts_relations; TRUNCATE hb_accounts_tags; TRUNCATE hb_aff; TRUNCATE hb_aff_clients; TRUNCATE hb_aff_coupons; TRUNCATE hb_aff_logs; TRUNCATE hb_aff_orders; TRUNCATE hb_aff_orders_items; TRUNCATE hb_aff_rates; TRUNCATE hb_aff_widlog; TRUNCATE hb_billing_records; TRUNCATE hb_client_access; TRUNCATE hb_client_ach; TRUNCATE hb_client_activity_log; TRUNCATE hb_client_billing; TRUNCATE hb_client_changes_log; TRUNCATE hb_client_credit_log; TRUNCATE hb_client_details; TRUNCATE hb_client_fields_values; TRUNCATE hb_client_login_status; TRUNCATE hb_client_privileges; TRUNCATE hb_config2accounts; TRUNCATE hb_config_upgrades; TRUNCATE hb_coupons_log; TRUNCATE hb_creditnotes; TRUNCATE hb_creditreceipts; TRUNCATE hb_domain_logs; TRUNCATE hb_domains; TRUNCATE hb_email_log; TRUNCATE hb_enom_certs; TRUNCATE hb_fraud_output; TRUNCATE hb_gateway_log; SET FOREIGN_KEY_CHECKS = 0; TRUNCATE hb_invoice_items; TRUNCATE hb_invoice_item_late_fees; TRUNCATE hb_invoice_items_queue; TRUNCATE hb_invoices; TRUNCATE hb_invoices_log; TRUNCATE hb_invoices_processing; SET FOREIGN_KEY_CHECKS = 1; TRUNCATE hb_knowledgebase; TRUNCATE hb_knowledgebase_cat; TRUNCATE hb_knowledgebase_relations; TRUNCATE hb_localcloud; TRUNCATE hb_mettered_reports; TRUNCATE hb_mettered_summary; TRUNCATE hb_mettered_sync; TRUNCATE hb_mettered_values; TRUNCATE hb_notes; TRUNCATE hb_notifications; TRUNCATE hb_order_items; TRUNCATE hb_order_log; TRUNCATE hb_order_steps; TRUNCATE hb_orders; TRUNCATE hb_oslicenses; TRUNCATE hb_queue_status; TRUNCATE hb_subscription_items; TRUNCATE hb_tags; TRUNCATE hb_tags_items; TRUNCATE hb_task_log; TRUNCATE hb_ticket_billing_items; TRUNCATE hb_ticket_departments; TRUNCATE hb_ticket_departments_import; TRUNCATE hb_ticket_departments_mail; TRUNCATE hb_ticket_departments_sla; TRUNCATE hb_ticket_departments_staff; TRUNCATE hb_ticket_rating; TRUNCATE hb_ticket_replies; TRUNCATE hb_ticket_replies_rating; TRUNCATE hb_tickets; TRUNCATE hb_tickets_attachments; TRUNCATE hb_tickets_log; TRUNCATE hb_tickets_notes; TRUNCATE hb_tickets_public; TRUNCATE hb_tickets_tags; TRUNCATE hb_transactions; TRUNCATE hb_upgrades; TRUNCATE hb_vps_details;
, multiple selections available,