diff options
| author | Christian Grothoff <christian@grothoff.org> | 2023-02-17 18:24:20 +0100 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2023-02-17 18:24:20 +0100 |
| commit | aa5e7d2ad5e712434f32ab41b63d53bb897c6105 (patch) | |
| tree | 63eca83e563d69d5d689f4e9c3c218be0950e854 /src/exchangedb/0003-aml_history.sql | |
| parent | 86e0f2c70d07c7c5e1656667bd818498ea55d0a4 (diff) | |
| download | exchange-aa5e7d2ad5e712434f32ab41b63d53bb897c6105.tar.xz | |
more towards actually allowing AML decisions to trigger KYC
Diffstat (limited to 'src/exchangedb/0003-aml_history.sql')
| -rw-r--r-- | src/exchangedb/0003-aml_history.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/src/exchangedb/0003-aml_history.sql b/src/exchangedb/0003-aml_history.sql index b411a6fb1..e57a2313f 100644 --- a/src/exchangedb/0003-aml_history.sql +++ b/src/exchangedb/0003-aml_history.sql @@ -33,6 +33,7 @@ BEGIN ',decision_time INT8 NOT NULL DEFAULT(0)' ',justification VARCHAR NOT NULL' ',kyc_requirements VARCHAR' + ',kyc_req_row INT8 NOT NULL DEFAULT(0)' ',decider_pub BYTEA CHECK (LENGTH(decider_pub)=32)' ',decider_sig BYTEA CHECK (LENGTH(decider_sig)=64)' ') %s ;' @@ -88,6 +89,12 @@ BEGIN ,partition_suffix ); PERFORM comment_partitioned_column( + 'Row in the KYC table for this KYC requirement, 0 for none.' + ,'kyc_req_row' + ,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 |