From 5dcad73d29bb431c7ae4529cc3755b56edbbb402 Mon Sep 17 00:00:00 2001
From: Christian Grothoff <grothoff@gnunet.org>
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

