From 5dcad73d29bb431c7ae4529cc3755b56edbbb402 Mon Sep 17 00:00:00 2001 From: Christian Grothoff Date: Tue, 27 Dec 2022 09:05:45 +0100 Subject: -prepare for AML staff PKI --- src/exchangedb/0003-aml_history.sql | 13 ++++++++++--- 1 file changed, 10 insertions(+), 3 deletions(-) (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 60382cc26..2d6298ed8 100644 --- a/src/exchangedb/0003-aml_history.sql +++ b/src/exchangedb/0003-aml_history.sql @@ -32,7 +32,8 @@ BEGIN ',new_status INT4 NOT NULL DEFAULT(0)' ',decision_time INT8 NOT NULL DEFAULT(0)' ',justification VARCHAR NOT NULL' - ',decider VARCHAR NOT NULL' + ',decider_pub BYTEA PRIMARY KEY CHECK (LENGTH(decider_pub)=32)' + ',decider_sig BYTEA PRIMARY KEY CHECK (LENGTH(decider_sig)=64)' ') %s ;' ,table_name ,'PARTITION BY HASH (h_payto)' @@ -74,8 +75,14 @@ BEGIN ,partition_suffix ); PERFORM comment_partitioned_column( - 'Name of the staff member who made the AML decision' - ,'decider' + 'Public key of the staff member who made the AML decision' + ,'decider_pub' + ,table_name + ,partition_suffix + ); + PERFORM comment_partitioned_column( + 'Signature key of the staff member affirming the AML decision; of type AML_DECISION' + ,'decider_sig' ,table_name ,partition_suffix ); -- cgit v1.2.3