diff --git a/account/src/main/resources/org/killbill/billing/account/migration/V20171108184350__reference_time.sql b/account/src/main/resources/org/killbill/billing/account/migration/V20171108184350__reference_time.sql
index 68d8e2a..8b6ebd5 100644
--- a/account/src/main/resources/org/killbill/billing/account/migration/V20171108184350__reference_time.sql
+++ b/account/src/main/resources/org/killbill/billing/account/migration/V20171108184350__reference_time.sql
@@ -1,4 +1,4 @@
-alter table accounts add column reference_time datetime NOT NULL after payment_method_id;
-alter table account_history add column reference_time datetime NOT NULL after payment_method_id;
+alter table accounts add column reference_time datetime NOT NULL DEFAULT '1970-01-01 00:00:00' after payment_method_id;
+alter table account_history add column reference_time datetime NOT NULL DEFAULT '1970-01-01 00:00:00' after payment_method_id;
update accounts set reference_time = created_date;
update account_history set reference_time = created_date;
\ No newline at end of file
