aboutsummaryrefslogtreecommitdiff
path: root/src/exchangedb/exchange_do_insert_kyc_attributes.sql
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2023-07-30 14:02:40 +0200
committerChristian Grothoff <christian@grothoff.org>2023-07-30 14:02:40 +0200
commita29f04189c8b7457ede0b3ac01222b88853325a8 (patch)
treec00400029ee53863481c2e30ffea5c275685733c /src/exchangedb/exchange_do_insert_kyc_attributes.sql
parentafa706914fefc90812c0bda01341e1dcfca06840 (diff)
downloadexchange-a29f04189c8b7457ede0b3ac01222b88853325a8.tar.gz
exchange-a29f04189c8b7457ede0b3ac01222b88853325a8.tar.bz2
exchange-a29f04189c8b7457ede0b3ac01222b88853325a8.zip
unify to TEXT instead of mixing TEXT and VARCHAR
Diffstat (limited to 'src/exchangedb/exchange_do_insert_kyc_attributes.sql')
-rw-r--r--src/exchangedb/exchange_do_insert_kyc_attributes.sql10
1 files changed, 5 insertions, 5 deletions
diff --git a/src/exchangedb/exchange_do_insert_kyc_attributes.sql b/src/exchangedb/exchange_do_insert_kyc_attributes.sql
index 29efde11f..d9818c882 100644
--- a/src/exchangedb/exchange_do_insert_kyc_attributes.sql
+++ b/src/exchangedb/exchange_do_insert_kyc_attributes.sql
@@ -18,16 +18,16 @@ CREATE OR REPLACE FUNCTION exchange_do_insert_kyc_attributes(
IN in_process_row INT8,
IN in_h_payto BYTEA,
IN in_kyc_prox BYTEA,
- IN in_provider_section VARCHAR,
+ IN in_provider_section TEXT,
IN in_birthday INT4,
- IN in_provider_account_id VARCHAR,
- IN in_provider_legitimization_id VARCHAR,
+ IN in_provider_account_id TEXT,
+ IN in_provider_legitimization_id TEXT,
IN in_collection_time_ts INT8,
IN in_expiration_time INT8,
IN in_expiration_time_ts INT8,
IN in_enc_attributes BYTEA,
IN in_require_aml BOOLEAN,
- IN in_kyc_completed_notify_s VARCHAR,
+ IN in_kyc_completed_notify_s TEXT,
OUT out_ok BOOLEAN)
LANGUAGE plpgsql
AS $$
@@ -105,5 +105,5 @@ INSERT INTO kyc_alerts
END $$;
-COMMENT ON FUNCTION exchange_do_insert_kyc_attributes(INT8, BYTEA, BYTEA, VARCHAR, INT4, VARCHAR, VARCHAR, INT8, INT8, INT8, BYTEA, BOOL, VARCHAR)
+COMMENT ON FUNCTION exchange_do_insert_kyc_attributes(INT8, BYTEA, BYTEA, TEXT, INT4, TEXT, TEXT, INT8, INT8, INT8, BYTEA, BOOL, TEXT)
IS 'Inserts new KYC attributes and updates the status of the legitimization process and the AML status for the account';