summaryrefslogtreecommitdiff
path: root/internal/storage/sql_provider_queries.go
diff options
context:
space:
mode:
Diffstat (limited to 'internal/storage/sql_provider_queries.go')
-rw-r--r--internal/storage/sql_provider_queries.go11
1 files changed, 11 insertions, 0 deletions
diff --git a/internal/storage/sql_provider_queries.go b/internal/storage/sql_provider_queries.go
index bff832dbd..48be6d2af 100644
--- a/internal/storage/sql_provider_queries.go
+++ b/internal/storage/sql_provider_queries.go
@@ -167,6 +167,17 @@ const (
WHERE id = ?;`
)
+const (
+ queryFmtInsertTOTPHistory = `
+ INSERT INTO %s (username, step)
+ VALUES (?, ?);`
+
+ queryFmtSelectTOTPHistory = `
+ SELECT COUNT(id)
+ FROM %s
+ WHERE username = ? AND step = ?;`
+)
+
//nolint:gosec // The following queries are not hard coded credentials.
const (
queryFmtSelectWebAuthnCredentials = `