killbill-aplcache

Details

diff --git a/account/src/main/resources/org/killbill/billing/account/ddl.sql b/account/src/main/resources/org/killbill/billing/account/ddl.sql
index 031e560..a24f272 100644
--- a/account/src/main/resources/org/killbill/billing/account/ddl.sql
+++ b/account/src/main/resources/org/killbill/billing/account/ddl.sql
@@ -35,6 +35,7 @@ CREATE TABLE accounts (
 ) /*! CHARACTER SET utf8 COLLATE utf8_bin */;
 CREATE UNIQUE INDEX accounts_id ON accounts(id);
 CREATE UNIQUE INDEX accounts_external_key ON accounts(external_key, tenant_record_id);
+CREATE INDEX accounts_parents ON accounts(parent_account_id);
 CREATE INDEX accounts_tenant_record_id ON accounts(tenant_record_id);
 
 DROP TABLE IF EXISTS account_history;
diff --git a/account/src/main/resources/org/killbill/billing/account/migration/V20161208173107__parent_id_idx.sql b/account/src/main/resources/org/killbill/billing/account/migration/V20161208173107__parent_id_idx.sql
new file mode 100644
index 0000000..b018110
--- /dev/null
+++ b/account/src/main/resources/org/killbill/billing/account/migration/V20161208173107__parent_id_idx.sql
@@ -0,0 +1 @@
+CREATE INDEX accounts_parents ON accounts(parent_account_id);