From 2a52426a7cdc55f49f726f24ddc735d6c01decaa Mon Sep 17 00:00:00 2001
From: Christian Grothoff <christian@grothoff.org>
Date: Mon, 20 Feb 2023 17:44:06 +0100
Subject: preparations to store AML decision if any is returned by the
 exchange, incomplete, not really used

---
 src/backenddb/merchant-0004.sql | 7 +++++++
 1 file changed, 7 insertions(+)

(limited to 'src/backenddb/merchant-0004.sql')

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;
 
 
-- 
cgit v1.2.3