Remove clients, accounts, domains but leave settings & products

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;