killbill-memoizeit

entitlement: add missing audit columns in blocking_states Signed-off-by:

10/31/2013 12:39:12 PM

Details

diff --git a/entitlement/src/main/resources/com/ning/billing/entitlement/dao/BlockingStateSqlDao.sql.stg b/entitlement/src/main/resources/com/ning/billing/entitlement/dao/BlockingStateSqlDao.sql.stg
index d470eb9..25067a4 100644
--- a/entitlement/src/main/resources/com/ning/billing/entitlement/dao/BlockingStateSqlDao.sql.stg
+++ b/entitlement/src/main/resources/com/ning/billing/entitlement/dao/BlockingStateSqlDao.sql.stg
@@ -15,7 +15,10 @@ tableFields(prefix) ::= <<
 , <prefix>block_billing
 , <prefix>effective_date
 , <prefix>is_active
+, <prefix>created_by
 , <prefix>created_date
+, <prefix>updated_by
+, <prefix>updated_date
 >>
 
 
@@ -29,7 +32,10 @@ tableValues() ::= <<
 , :blockBilling
 , :effectiveDate
 , :isActive
+, :createdBy
 , :createdDate
+, :updatedBy
+, :updatedDate
 >>
 
 
diff --git a/entitlement/src/main/resources/com/ning/billing/entitlement/ddl.sql b/entitlement/src/main/resources/com/ning/billing/entitlement/ddl.sql
index 8a20159..74b2998 100644
--- a/entitlement/src/main/resources/com/ning/billing/entitlement/ddl.sql
+++ b/entitlement/src/main/resources/com/ning/billing/entitlement/ddl.sql
@@ -14,6 +14,9 @@ CREATE TABLE blocking_states (
     effective_date datetime NOT NULL,
     is_active bool DEFAULT 1,
     created_date datetime NOT NULL,
+    created_by varchar(50) NOT NULL,
+    updated_date datetime DEFAULT NULL,
+    updated_by varchar(50) DEFAULT NULL,
     account_record_id int(11) unsigned default null,
     tenant_record_id int(11) unsigned default null,
     PRIMARY KEY(record_id)