killbill-aplcache

util: relax constraint on audit_log#account_record_id The

7/15/2015 5:03:16 PM

Details

diff --git a/util/src/main/resources/org/killbill/billing/util/ddl.sql b/util/src/main/resources/org/killbill/billing/util/ddl.sql
index 45547ec..62f19f8 100644
--- a/util/src/main/resources/org/killbill/billing/util/ddl.sql
+++ b/util/src/main/resources/org/killbill/billing/util/ddl.sql
@@ -138,7 +138,8 @@ CREATE TABLE audit_log (
     reason_code varchar(255) DEFAULT NULL,
     comments varchar(255) DEFAULT NULL,
     user_token varchar(36),
-    account_record_id bigint /*! unsigned */ not null,
+    /* Note: can be NULL (e.g. tenant_kvs audits) */
+    account_record_id bigint /*! unsigned */ default null,
     tenant_record_id bigint /*! unsigned */ not null default 0,
     PRIMARY KEY(record_id)
 ) /*! CHARACTER SET utf8 COLLATE utf8_bin */;