killbill-memoizeit

diff --git a/util/src/main/resources/trimTenant.sql b/util/src/main/resources/trimTenant.sql
new file mode 100644
index 0000000..6eac817
--- /dev/null
+++ b/util/src/main/resources/trimTenant.sql
@@ -0,0 +1,71 @@
+drop procedure if exists trimTenant;
+DELIMITER //
+CREATE PROCEDURE trimTenant(p_api_key varchar(36))
+BEGIN
+
+    DECLARE v_tenant_record_id bigint /*! unsigned */;
+
+    select record_id from tenants WHERE api_key = p_api_key into v_tenant_record_id;
+
+    DELETE FROM analytics_account_fields WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_account_tags WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_account_transitions WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_accounts WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_bundle_fields WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_bundle_tags WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_bundles WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_invoice_adjustments WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_invoice_credits WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_invoice_fields WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_invoice_item_adjustments WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_invoice_items WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_invoice_payment_fields WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_invoice_tags WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_invoices WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_notifications WHERE search_key2 = v_tenant_record_id;
+    DELETE FROM analytics_notifications_history WHERE search_key2 = v_tenant_record_id;
+    DELETE FROM analytics_payment_auths WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_payment_captures WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_payment_chargebacks WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_payment_credits WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_payment_fields WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_payment_method_fields WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_payment_purchases WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_payment_refunds WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_payment_tags WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_payment_voids WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_subscription_transitions WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM analytics_transaction_fields WHERE tenant_record_id = v_tenant_record_id;
+
+    DELETE FROM account_email_history WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM account_emails WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM audit_log WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM blocking_states WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM bundles WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM bus_events WHERE search_key2 = v_tenant_record_id;
+    DELETE FROM bus_events_history WHERE search_key2 = v_tenant_record_id;
+    DELETE FROM bus_ext_events WHERE search_key2 = v_tenant_record_id;
+    DELETE FROM bus_ext_events_history WHERE search_key2 = v_tenant_record_id;
+    DELETE FROM custom_field_history WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM custom_fields WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM invoice_items WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM invoice_parent_children WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM invoice_payments WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM invoices WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM notifications WHERE search_key2 = v_tenant_record_id;
+    DELETE FROM notifications_history WHERE search_key2 = v_tenant_record_id;
+    DELETE FROM payment_attempt_history WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM payment_attempts WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM payment_history WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM payment_transaction_history WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM payment_transactions WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM payments WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM rolled_up_usage WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM subscription_events WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM subscriptions WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM tag_history WHERE tenant_record_id = v_tenant_record_id;
+    DELETE FROM tags WHERE tenant_record_id = v_tenant_record_id;
+
+    END;
+//
+DELIMITER ;