diff options
Diffstat (limited to 'src/exchangedb/0003-aml_history.sql')
-rw-r--r-- | src/exchangedb/0003-aml_history.sql | 13 |
1 files changed, 10 insertions, 3 deletions
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 ); |