aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/0003-aml_history.sql
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2023-02-04 21:54:47 +0100
committerChristian Grothoff <christian@grothoff.org>2023-02-04 21:54:47 +0100
commit5a18e955ebd663a6e1318378002a6368a7c07566 (patch)
tree9f1d6349f36bf053253382705e2032e8e738c5ba /src/exchangedb/0003-aml_history.sql
parent47b9ef598dc33e10294c1af4c7cf0e2ac71f553e (diff)
downloadexchange-5a18e955ebd663a6e1318378002a6368a7c07566.tar.xz
-fix AML decision update logic and history fetch logic
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 1c737265b..36c0b3865 100644
--- a/src/exchangedb/0003-aml_history.sql
+++ b/src/exchangedb/0003-aml_history.sql
@@ -26,7 +26,7 @@ BEGIN
PERFORM create_partitioned_table(
'CREATE TABLE IF NOT EXISTS %I'
'(aml_history_serial_id BIGINT GENERATED BY DEFAULT AS IDENTITY'
- ',h_payto BYTEA PRIMARY KEY CHECK (LENGTH(h_payto)=32)'
+ ',h_payto BYTEA CHECK (LENGTH(h_payto)=32)'
',new_threshold_val INT8 NOT NULL DEFAULT(0)'
',new_threshold_frac INT4 NOT NULL DEFAULT(0)'
',new_status INT4 NOT NULL DEFAULT(0)'