commit 096091fe9850518d35c68f44fcc98af7cbcdbd13
parent 11bf2426f46eaf4d970656b40815337827f14277
Author: Antoine A <>
Date: Mon, 5 Aug 2024 14:05:12 +0200
nexus: add an outgoing transactions status index for the future extended wire gateway API
Diffstat:
1 file changed, 3 insertions(+), 0 deletions(-)
diff --git a/database-versioning/libeufin-nexus-0006.sql b/database-versioning/libeufin-nexus-0006.sql
@@ -40,4 +40,7 @@ ALTER TABLE talerable_incoming_transactions ALTER COLUMN type DROP DEFAULT;
CREATE INDEX talerable_incoming_transactions_kyc_index ON talerable_incoming_transactions (account_pub) WHERE account_pub IS NOT NULL;
COMMENT ON INDEX talerable_incoming_transactions_kyc_index IS 'for reconciling KYC transaction without bank_id';
+CREATE INDEX initiated_outgoing_transactions_status_index ON initiated_outgoing_transactions (submission_state);
+COMMENT ON INDEX initiated_outgoing_transactions_status_index IS 'for listing taler transfers by status';
+
COMMIT;