diff options
| author | Christian Grothoff <christian@grothoff.org> | 2023-02-14 14:26:00 +0100 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2023-02-14 14:26:00 +0100 |
| commit | afe3f70d336e151598e02ebedb6498e13122530e (patch) | |
| tree | 16b28b9fec850465e963dd1eb2acee796d86d9f2 /src/exchangedb/0003-aml_history.sql | |
| parent | 437e6ec86a1cd3a391de437999ad21ac5e256e68 (diff) | |
| download | exchange-afe3f70d336e151598e02ebedb6498e13122530e.tar.gz exchange-afe3f70d336e151598e02ebedb6498e13122530e.tar.bz2 exchange-afe3f70d336e151598e02ebedb6498e13122530e.zip | |
begin API change to allow AML officers to trigger KYC process
Diffstat (limited to 'src/exchangedb/0003-aml_history.sql')
| -rw-r--r-- | src/exchangedb/0003-aml_history.sql | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/src/exchangedb/0003-aml_history.sql b/src/exchangedb/0003-aml_history.sql index 36c0b3865..b411a6fb1 100644 --- a/src/exchangedb/0003-aml_history.sql +++ b/src/exchangedb/0003-aml_history.sql @@ -32,6 +32,7 @@ BEGIN ',new_status INT4 NOT NULL DEFAULT(0)' ',decision_time INT8 NOT NULL DEFAULT(0)' ',justification VARCHAR NOT NULL' + ',kyc_requirements VARCHAR' ',decider_pub BYTEA CHECK (LENGTH(decider_pub)=32)' ',decider_sig BYTEA CHECK (LENGTH(decider_sig)=64)' ') %s ;' @@ -81,6 +82,12 @@ BEGIN ,partition_suffix ); PERFORM comment_partitioned_column( + 'Additional KYC requirements imposed by the AML staff member. Serialized JSON array of strings.' + ,'kyc_requirements' + ,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 @@ -114,7 +121,6 @@ BEGIN ); END $$; --- FIXME: also have INSERT on AML decisions to update AML status! INSERT INTO exchange_tables (name |