killbill-aplcache

Details

diff --git a/entitlement/src/main/resources/org/killbill/billing/entitlement/ddl.sql b/entitlement/src/main/resources/org/killbill/billing/entitlement/ddl.sql
index 8d2d2be..c085a6b 100644
--- a/entitlement/src/main/resources/org/killbill/billing/entitlement/ddl.sql
+++ b/entitlement/src/main/resources/org/killbill/billing/entitlement/ddl.sql
@@ -22,4 +22,5 @@ CREATE TABLE blocking_states (
     PRIMARY KEY(record_id)
 ) /*! CHARACTER SET utf8 COLLATE utf8_bin */;
 CREATE INDEX blocking_states_id ON blocking_states(blockable_id);
+CREATE INDEX blocking_states_id_real ON blocking_states(id);
 CREATE INDEX blocking_states_tenant_account_record_id ON blocking_states(tenant_record_id, account_record_id);
diff --git a/entitlement/src/main/resources/org/killbill/billing/entitlement/migration/V20161208173547__blocking_states_id_idx.sql b/entitlement/src/main/resources/org/killbill/billing/entitlement/migration/V20161208173547__blocking_states_id_idx.sql
new file mode 100644
index 0000000..f86f355
--- /dev/null
+++ b/entitlement/src/main/resources/org/killbill/billing/entitlement/migration/V20161208173547__blocking_states_id_idx.sql
@@ -0,0 +1 @@
+CREATE INDEX blocking_states_id_real ON blocking_states(id);