From 5a18e955ebd663a6e1318378002a6368a7c07566 Mon Sep 17 00:00:00 2001 From: Christian Grothoff Date: Sat, 4 Feb 2023 21:54:47 +0100 Subject: -fix AML decision update logic and history fetch logic --- src/exchangedb/0003-aml_history.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'src/exchangedb/0003-aml_history.sql') 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)' -- cgit v1.2.3