killbill-uncached

diff --git a/util/src/main/resources/cleanAccount.sql b/util/src/main/resources/cleanAccount.sql
new file mode 100644
index 0000000..0ec45f0
--- /dev/null
+++ b/util/src/main/resources/cleanAccount.sql
@@ -0,0 +1,72 @@
+drop procedure if exists cleanAccount;
+DELIMITER //
+CREATE PROCEDURE cleanAccount(p_account_key char(36))
+BEGIN
+
+    DECLARE v_account_record_id int(11) unsigned; 
+    
+    select record_id from accounts WHERE external_key = p_account_key into v_account_record_id;
+
+    DELETE FROM analytics_account_fields WHERE account_record_id = v_account_record_id;
+    DELETE FROM analytics_account_tags WHERE account_record_id = v_account_record_id;
+    DELETE FROM analytics_account_transitions WHERE account_record_id = v_account_record_id;
+    DELETE FROM analytics_accounts WHERE account_record_id = v_account_record_id;
+    DELETE FROM analytics_bundle_fields WHERE account_record_id = v_account_record_id;
+    DELETE FROM analytics_bundle_tags WHERE account_record_id = v_account_record_id;
+    DELETE FROM analytics_bundles WHERE account_record_id = v_account_record_id;
+    DELETE FROM analytics_chargebacks WHERE account_record_id = v_account_record_id;
+    DELETE FROM analytics_invoice_adjustments WHERE account_record_id = v_account_record_id;
+    DELETE FROM analytics_invoice_credits WHERE account_record_id = v_account_record_id;
+    DELETE FROM analytics_invoice_fields WHERE account_record_id = v_account_record_id;
+    DELETE FROM analytics_invoice_item_adjustments WHERE account_record_id = v_account_record_id;
+    DELETE FROM analytics_invoice_items WHERE account_record_id = v_account_record_id;
+    DELETE FROM analytics_invoice_tags WHERE account_record_id = v_account_record_id;
+    DELETE FROM analytics_invoices WHERE account_record_id = v_account_record_id;
+    DELETE FROM analytics_payment_fields WHERE account_record_id = v_account_record_id;
+    DELETE FROM analytics_payment_tags WHERE account_record_id = v_account_record_id;
+    DELETE FROM analytics_payments WHERE account_record_id = v_account_record_id;
+    DELETE FROM analytics_refunds WHERE account_record_id = v_account_record_id;
+    DELETE FROM analytics_subscription_transitions WHERE account_record_id = v_account_record_id;
+
+    DELETE FROM accounts WHERE record_id = v_account_record_id;
+    DELETE FROM account_emails WHERE account_record_id = v_account_record_id;
+    DELETE FROM account_email_history WHERE account_record_id = v_account_record_id;
+    DELETE FROM account_history WHERE target_record_id = v_account_record_id;
+    DELETE FROM audit_log WHERE account_record_id = v_account_record_id;
+    DELETE FROM bac WHERE account_record_id = v_account_record_id;
+    DELETE FROM bac_fields WHERE account_record_id = v_account_record_id;
+    DELETE FROM bac_tags WHERE account_record_id = v_account_record_id;
+    DELETE FROM bii WHERE account_record_id = v_account_record_id;
+    DELETE FROM bin WHERE account_record_id = v_account_record_id;
+    DELETE FROM bin_fields WHERE account_record_id = v_account_record_id;
+    DELETE FROM bin_tags WHERE account_record_id = v_account_record_id;
+    DELETE FROM bip WHERE account_record_id = v_account_record_id;
+    DELETE FROM bip_fields WHERE account_record_id = v_account_record_id;
+    DELETE FROM bip_tags WHERE account_record_id = v_account_record_id;
+    DELETE FROM blocking_states WHERE account_record_id = v_account_record_id;
+    DELETE FROM bos WHERE account_record_id = v_account_record_id;
+    DELETE FROM bst WHERE account_record_id = v_account_record_id;
+    DELETE FROM bst_fields WHERE account_record_id = v_account_record_id;
+    DELETE FROM bst_tags WHERE account_record_id = v_account_record_id;
+    DELETE FROM bundles WHERE account_record_id = v_account_record_id;
+    DELETE FROM custom_field_history WHERE account_record_id = v_account_record_id;
+    DELETE FROM custom_fields WHERE account_record_id = v_account_record_id;
+    DELETE FROM invoice_payments WHERE account_record_id = v_account_record_id;
+    DELETE FROM invoices WHERE account_record_id = v_account_record_id;
+    DELETE FROM invoice_items WHERE account_record_id = v_account_record_id;
+    DELETE FROM payment_attempt_history WHERE account_record_id = v_account_record_id;
+    DELETE FROM payment_attempts WHERE account_record_id = v_account_record_id;
+    DELETE FROM payment_methods WHERE account_record_id = v_account_record_id;
+    DELETE FROM payment_method_history WHERE account_record_id = v_account_record_id;
+    DELETE FROM payment_history WHERE account_record_id = v_account_record_id;
+    DELETE FROM payments WHERE account_record_id = v_account_record_id;
+    DELETE FROM refunds WHERE account_record_id = v_account_record_id;
+    DELETE FROM refund_history WHERE account_record_id = v_account_record_id;
+    DELETE FROM subscriptions WHERE account_record_id = v_account_record_id;
+    DELETE FROM subscription_events WHERE account_record_id = v_account_record_id;
+    DELETE FROM tags WHERE account_record_id = v_account_record_id;
+    DELETE FROM tag_history WHERE account_record_id = v_account_record_id;
+
+    END;
+//
+DELIMITER ;