killbill-memoizeit

invoice: Fix migration file to include a non null default date

1/21/2019 11:26:22 PM

stephane brossier

Commit: 2cd947a

Tree: c739742

Parents: abf7f1c

Changes

invoice/src/main/resources/org/killbill/billing/invoice/migration/V20190121141325__tracking_ids_is_active.sql 2(+1 -1)

Details

invoice/src/main/resources/org/killbill/billing/invoice/migration/V20190121141325__tracking_ids_is_active.sql 2(+1 -1)

diff --git a/invoice/src/main/resources/org/killbill/billing/invoice/migration/V20190121141325__tracking_ids_is_active.sql b/invoice/src/main/resources/org/killbill/billing/invoice/migration/V20190121141325__tracking_ids_is_active.sql
index 217fa69..7998b74 100644
--- a/invoice/src/main/resources/org/killbill/billing/invoice/migration/V20190121141325__tracking_ids_is_active.sql
+++ b/invoice/src/main/resources/org/killbill/billing/invoice/migration/V20190121141325__tracking_ids_is_active.sql
@@ -1,4 +1,4 @@
 alter table invoice_tracking_ids add column is_active boolean default true after record_date;
 alter table invoice_tracking_ids add column updated_by varchar(50) NOT NULL after created_date;
-alter table invoice_tracking_ids add column updated_date datetime NOT NULL after updated_by;
+alter table invoice_tracking_ids add column updated_date datetime NOT NULL DEFAULT '1970-01-01 00:00:00' after updated_by;
 create index invoice_tracking_invoice_id_idx on invoice_tracking_ids(tenant_record_id, invoice_id);