diff options
Diffstat (limited to 'internal/storage/sql_provider_queries.go')
| -rw-r--r-- | internal/storage/sql_provider_queries.go | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/internal/storage/sql_provider_queries.go b/internal/storage/sql_provider_queries.go index fb9276458..bff832dbd 100644 --- a/internal/storage/sql_provider_queries.go +++ b/internal/storage/sql_provider_queries.go @@ -57,7 +57,7 @@ const ( const ( queryFmtSelectIdentityVerification = ` - SELECT id, jti, iat, issued_ip, exp, username, action, consumed, consumed_ip + SELECT id, jti, iat, issued_ip, exp, username, action, consumed, consumed_ip, revoked, revoked_ip FROM %s WHERE jti = ?;` @@ -69,6 +69,11 @@ const ( UPDATE %s SET consumed = CURRENT_TIMESTAMP, consumed_ip = ? WHERE jti = ?;` + + queryFmtRevokeIdentityVerification = ` + UPDATE %s + SET revoked = CURRENT_TIMESTAMP, revoked_ip = ? + WHERE jti = ?;` ) const ( |