libeufin

commit e1815acea417dd870fbad7c20abb6eb60eb74ea4
parent 26c237198c053efb21fc29bf2e422fa1726a47ee
Author: MS <ms@taler.net>
Date:   Thu,  9 Nov 2023 11:51:57 +0100

nexus fetch: indexing the execution_time column

Diffstat:
M
database-versioning/libeufin-nexus-0001.sql
 | 
5
+++++

1 file changed, 5 insertions(+), 0 deletions(-)
diff --git a/database-versioning/libeufin-nexus-0001.sql b/database-versioning/libeufin-nexus-0001.sql
@@ -98,4 +98,9 @@ CREATE TABLE IF NOT EXISTS bounced_transactions
    ,initiated_outgoing_transaction_id INT8 NOT NULL UNIQUE REFERENCES initiated_outgoing_transactions(initiated_outgoing_transaction_id) ON DELETE CASCADE
   );
 
+-- Helps to detect the last known incoming transaction.
+-- According to this value, camt.05x date ranges should be adjusted.
+CREATE INDEX IF NOT EXISTS incoming_transaction_timestamp
+  ON incoming_transactions (execution_time); 
+
 COMMIT;