commit 67aa5c2b22d376bbc6aeee42686b60baca8015ef
parent bfa7d7574be58fa401dc8a7e2602c8237a2299fc
Author: Christian Grothoff <christian@grothoff.org>
Date: Tue, 2 Sep 2025 23:02:36 +0200
-forgot to safe buffer
Diffstat:
1 file changed, 4 insertions(+), 4 deletions(-)
diff --git a/src/backenddb/merchant-0023.sql b/src/backenddb/merchant-0023.sql
@@ -49,8 +49,8 @@ CREATE TABLE tan_challenges
,merchant_serial INT8 NOT NULL
REFERENCES merchant_instances(merchant_serial)
ON DELETE CASCADE
- ,tan_channel tan_enum NULL DEFAULT NULL
- ,tan_info TEXT NULL DEFAULT NULL -- FIXME: when is this NULL?
+ ,tan_channel tan_enum NOT NULL
+ ,required_address TEXT NOT NULL
);
COMMENT ON TABLE tan_challenges
IS 'Stores multi-factor authorization (MFA) challenges';
@@ -76,8 +76,8 @@ COMMENT ON COLUMN tan_challenges.retry_counter
IS 'How many tries are left for this code; must be > 0';
COMMENT ON COLUMN tan_challenges.tan_channel
IS 'TAN channel to use, if NULL use customer configured one';
-COMMENT ON COLUMN tan_challenges.tan_info
- IS 'TAN information message to use to inform the user about where the challenge was sent';
+COMMENT ON COLUMN tan_challenges.required_address
+ IS 'Address to which the challenge will be sent';
CREATE INDEX tan_challenges_lookup_index
ON tan_challenges (merchant_serial,op,expiration_date,creation_date DESC);