diff options
-rw-r--r-- | database-versioning/libeufin-bank-0002.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/database-versioning/libeufin-bank-0002.sql b/database-versioning/libeufin-bank-0002.sql index 0859d80f..fcd82e7c 100644 --- a/database-versioning/libeufin-bank-0002.sql +++ b/database-versioning/libeufin-bank-0002.sql @@ -80,7 +80,9 @@ COMMENT ON INDEX bank_account_transactions_expiration_index IS 'for garbage collection'; ALTER TABLE taler_withdrawal_operations - ADD creation_date INT8 NOT NULL; + ADD creation_date INT8 NOT NULL DEFAULT 0; +ALTER TABLE taler_withdrawal_operations + ALTER creation_date DROP DEFAULT; CREATE INDEX taler_withdrawal_operations_expiration_index ON taler_withdrawal_operations (creation_date); COMMENT ON INDEX taler_withdrawal_operations_expiration_index |