commit 4166428e6ddbc57d3e564bc4ffd920c7891fc25b
parent 096091fe9850518d35c68f44fcc98af7cbcdbd13
Author: Antoine A <>
Date: Mon, 5 Aug 2024 14:25:01 +0200
nexus: fix sql migration
Diffstat:
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/database-versioning/libeufin-nexus-0006.sql b/database-versioning/libeufin-nexus-0006.sql
@@ -40,7 +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);
+CREATE INDEX initiated_outgoing_transactions_status_index ON initiated_outgoing_transactions (submitted);
COMMENT ON INDEX initiated_outgoing_transactions_status_index IS 'for listing taler transfers by status';
COMMIT;