libeufin

commit e33140b56ee1a83e5be5514b1a0b06a71108d4d3
parent ecc5e07182e3f964492c60dfeb5c4723d8bcc6d5
Author: Antoine A <>
Date:   Sat, 13 Jan 2024 14:54:28 +0000

Add default value for taler_withdrawal_operations.creation_date in migration file

Diffstat:
M
database-versioning/libeufin-bank-0002.sql
 | 
5
+++--

1 file changed, 3 insertions(+), 2 deletions(-)
diff --git a/database-versioning/libeufin-bank-0002.sql b/database-versioning/libeufin-bank-0002.sql
@@ -80,11 +80,12 @@ 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 (extract(epoch from now())*1000000)::int8;
+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
   IS 'for garbage collection';
 
-
 COMMIT;