summaryrefslogtreecommitdiff
path: root/internal/storage
diff options
context:
space:
mode:
authorJames Elliott <james-d-elliott@users.noreply.github.com>2023-10-27 20:24:13 +1100
committerJames Elliott <james-d-elliott@users.noreply.github.com>2024-03-04 20:28:24 +1100
commit87d2a3419d6f29db900bc1aeb4cf5d7769a15ce3 (patch)
treea4efff47cb7be04f9fb1ce344cb9e40f4096dee6 /internal/storage
parentc0dbdd97ab2ac580e3da07a0137dbc7a1b9c9b83 (diff)
feat(web): user one-time password preferences
This allows administrators to configure a list of Time-based One-Time Password parameters that users can pick from the web UI during registrations. Signed-off-by: James Elliott <james-d-elliott@users.noreply.github.com>
Diffstat (limited to 'internal/storage')
-rw-r--r--internal/storage/sql_provider_queries.go4
1 files changed, 2 insertions, 2 deletions
diff --git a/internal/storage/sql_provider_queries.go b/internal/storage/sql_provider_queries.go
index 882258d5c..6def1c880 100644
--- a/internal/storage/sql_provider_queries.go
+++ b/internal/storage/sql_provider_queries.go
@@ -73,12 +73,12 @@ const (
const (
queryFmtSelectTOTPConfiguration = `
- SELECT id, username, issuer, algorithm, digits, period, secret
+ SELECT id, created_at, last_used_at, username, issuer, algorithm, digits, period, secret
FROM %s
WHERE username = ?;`
queryFmtSelectTOTPConfigurations = `
- SELECT id, username, issuer, algorithm, digits, period, secret
+ SELECT id, created_at, last_used_at, username, issuer, algorithm, digits, period, secret
FROM %s
LIMIT ?
OFFSET ?;`