diff options
| author | Christian Grothoff <christian@grothoff.org> | 2024-02-13 22:01:02 +0100 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2024-02-13 22:01:02 +0100 |
| commit | 2d6bce2dc0ded9fcb77caa1cafecd401216b7238 (patch) | |
| tree | 7614abdaea0d86b8356f26e9be78bd5ba5dad1f9 /src/exchangedb/exchange_do_insert_kyc_attributes.sql | |
| parent | c4dfd21ebe721959312cd52a7224fbbf84e75c4d (diff) | |
| download | exchange-2d6bce2dc0ded9fcb77caa1cafecd401216b7238.tar.gz exchange-2d6bce2dc0ded9fcb77caa1cafecd401216b7238.tar.bz2 exchange-2d6bce2dc0ded9fcb77caa1cafecd401216b7238.zip | |
set 'finished' to TRUE when KYC process is done (either way, successful or failure); should fix #8055, needs testing
Diffstat (limited to 'src/exchangedb/exchange_do_insert_kyc_attributes.sql')
| -rw-r--r-- | src/exchangedb/exchange_do_insert_kyc_attributes.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/exchangedb/exchange_do_insert_kyc_attributes.sql b/src/exchangedb/exchange_do_insert_kyc_attributes.sql index 2efc0aec5..7db4d80c0 100644 --- a/src/exchangedb/exchange_do_insert_kyc_attributes.sql +++ b/src/exchangedb/exchange_do_insert_kyc_attributes.sql @@ -56,10 +56,11 @@ INSERT INTO exchange.kyc_attributes ,in_enc_attributes ,in_process_row); -UPDATE exchange.legitimization_processes +UPDATE legitimization_processes SET provider_user_id=in_provider_account_id ,provider_legitimization_id=in_provider_legitimization_id ,expiration_time=GREATEST(expiration_time,in_expiration_time) + ,finished=TRUE WHERE h_payto=in_h_payto AND legitimization_process_serial_id=in_process_row AND provider_section=in_provider_section; |