summaryrefslogtreecommitdiff
path: root/src/backenddb/merchant-0004.sql
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2023-02-20 17:44:06 +0100
committerChristian Grothoff <christian@grothoff.org>2023-02-20 17:44:06 +0100
commit2a52426a7cdc55f49f726f24ddc735d6c01decaa (patch)
tree877fdbd77d028f6650f8cdc1e80b6482d0d30d54 /src/backenddb/merchant-0004.sql
parent8ffaa360d505a40c74071a6cd3f534dfb4776c9f (diff)
downloadmerchant-2a52426a7cdc55f49f726f24ddc735d6c01decaa.tar.gz
merchant-2a52426a7cdc55f49f726f24ddc735d6c01decaa.tar.bz2
merchant-2a52426a7cdc55f49f726f24ddc735d6c01decaa.zip
preparations to store AML decision if any is returned by the exchange, incomplete, not really used
Diffstat (limited to 'src/backenddb/merchant-0004.sql')
-rw-r--r--src/backenddb/merchant-0004.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/src/backenddb/merchant-0004.sql b/src/backenddb/merchant-0004.sql
index 55cfa2fc..b63594ee 100644
--- a/src/backenddb/merchant-0004.sql
+++ b/src/backenddb/merchant-0004.sql
@@ -106,6 +106,13 @@ COMMENT ON COLUMN merchant_pending_webhooks.body
IS 'Body of the webhook';
+ALTER TABLE merchant_kyc
+ ADD COLUMN aml_decision INT4 NOT NULL DEFAULT (0);
+
+COMMENT ON COLUMN merchant_kyc.aml_decision
+ IS 'current AML decision for our account at the exchange';
+
+
COMMIT;