[libeufin] 02/06: nexus fetch: indexing the execution_time column

[gnunet]

This is an automated email from the git hooks/post-receive script.

ms pushed a commit to branch master
in repository libeufin.

commit e1815acea417dd870fbad7c20abb6eb60eb74ea4
Author: MS <ms@taler.net>
AuthorDate: Thu Nov 9 11:51:57 2023 +0100

    nexus fetch: indexing the execution_time column
---
 database-versioning/libeufin-nexus-0001.sql | 5 +++++
 1 file changed, 5 insertions(+)

diff --git a/database-versioning/libeufin-nexus-0001.sql 
b/database-versioning/libeufin-nexus-0001.sql
index 4211f467..579c6900 100644
--- 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;

-- 
To stop receiving notification emails like this one, please contact
gnunet@gnunet.org.