merchant

commit c3fa0cc225d24f290d029d8d445f26353f56bf23
parent 9d68a5d1d49b61ab5aa4792bd05a4e73a243c723
Author: Christian Grothoff <grothoff@gnunet.org>
Date:   Wed,  6 Aug 2025 12:48:54 +0200

add columns for GC

Diffstat:
M
src/backenddb/merchant-0022.sql
 | 
10
++++++++--

1 file changed, 8 insertions(+), 2 deletions(-)
diff --git a/src/backenddb/merchant-0022.sql b/src/backenddb/merchant-0022.sql
@@ -28,8 +28,10 @@ SET search_path TO merchant;
 
 ALTER TABLE merchant_instances
   ADD COLUMN phone_number TEXT DEFAULT NULL,
-  ADD COLUMN phone_validated BOOL DEFAULT FALSE,
-  ADD COLUMN email_validated BOOL DEFAULT FALSE,
+  ADD COLUMN phone_validated BOOL NOT NULL DEFAULT FALSE,
+  ADD COLUMN email_validated BOOL NOT NULL DEFAULT FALSE,
+  ADD COLUMN validation_needed BOOL NOT NULL DEFAULT FALSE,
+  ADD COLUMN validation_expiration INT8 NOT NULL DEFAULT 0,
   DROP COLUMN user_type;
 
 COMMENT ON COLUMN merchant_instances.phone_number
@@ -38,5 +40,9 @@ COMMENT ON COLUMN merchant_instances.phone_validated
   IS 'TRUE if the merchant backend validated the phone number';
 COMMENT ON COLUMN merchant_instances.email_validated
   IS 'TRUE if the merchant backend validated the e-mail address';
+COMMENT ON COLUMN merchant_instances.validation_needed
+  IS 'TRUE if this is a self-provisioned instance that still needs the recovery addresses to be validated';
+COMMENT ON COLUMN merchant_instances.validation_expiration
+  IS 'Time when the instance should be garbage collected if the recovery addresses remain unvalidated';
 
 COMMIT;