diff options
Diffstat (limited to 'src/stasis/stasis-0001.sql')
-rw-r--r-- | src/stasis/stasis-0001.sql | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/src/stasis/stasis-0001.sql b/src/stasis/stasis-0001.sql index beb886d..87dde94 100644 --- a/src/stasis/stasis-0001.sql +++ b/src/stasis/stasis-0001.sql @@ -161,7 +161,8 @@ CREATE TABLE IF NOT EXISTS anastasis_challengecode creation_date INT8 NOT NULL, expiration_date INT8 NOT NULL, retransmission_date INT8 NOT NULL DEFAULT 0, - retry_counter INT4 NOT NULL); + retry_counter INT4 NOT NULL, + satisfied BOOLEAN NOT NULL DEFAULT FALSE); COMMENT ON TABLE anastasis_challengecode IS 'Stores a code which is checked for the authentication by SMS, E-Mail..'; COMMENT ON COLUMN anastasis_challengecode.truth_uuid @@ -176,6 +177,8 @@ COMMENT ON COLUMN anastasis_challengecode.expiration_date IS 'When will the code expire'; COMMENT ON COLUMN anastasis_challengecode.retry_counter IS 'How many tries are left for this code must be > 0'; +COMMENT ON COLUMN anastasis_challengecode.satisfied + IS 'Has this challenge been satisfied by the user, used if it is not enough for the user to know the code (like for video identification or SEPA authentication). For SMS/E-mail/Post verification, this field being FALSE does not imply that the user did not meet the challenge.'; CREATE INDEX IF NOT EXISTS anastasis_challengecode_uuid_index ON anastasis_challengecode |