aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/0003-aml_history.sql
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2023-01-22 15:13:34 +0100
committerChristian Grothoff <christian@grothoff.org>2023-01-22 15:13:34 +0100
commitf8bfc4dc9d9dcb69ccdd95258aea53dabf997246 (patch)
tree22ef212d0fad68b13b74e923b56d98389066ec57 /src/exchangedb/0003-aml_history.sql
parentd131951fbe09b3415c9976acd11f660d51493086 (diff)
address DB FIXMEs for AML
Diffstat (limited to 'src/exchangedb/0003-aml_history.sql')
-rw-r--r--src/exchangedb/0003-aml_history.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/src/exchangedb/0003-aml_history.sql b/src/exchangedb/0003-aml_history.sql
index c2ab532d..1c737265 100644
--- a/src/exchangedb/0003-aml_history.sql
+++ b/src/exchangedb/0003-aml_history.sql
@@ -110,7 +110,7 @@ BEGIN
EXECUTE FORMAT (
'CREATE INDEX ' || table_name || '_main_index '
'ON ' || table_name || ' '
- '(h_payto ASC, decision_time ASC);'
+ '(h_payto, decision_time DESC);'
);
END $$;