db

const ActivateUser = `` /* 138-byte string literal not displayed */

const CountCover = `` /* 149-byte string literal not displayed */

const CountLiveTokens = `-- name: CountLiveTokens :one
SELECT count(*)
FROM auth_tokens
WHERE user_id = ? AND purpose = ? AND expires_at > ?
`

const CreateSession = `-- name: CreateSession :exec
INSERT INTO auth_sessions (token_hash, user_id, created_at, expires_at)
VALUES (?, ?, ?, ?)
`

const CreateToken = `` /* 129-byte string literal not displayed */

const CreateUser = `` /* 154-byte string literal not displayed */

const DeleteExpiredSessions = `-- name: DeleteExpiredSessions :execrows
DELETE FROM auth_sessions
WHERE expires_at <= ?
`

const DeleteExpiredTokens = `-- name: DeleteExpiredTokens :execrows
DELETE FROM auth_tokens
WHERE expires_at <= ?
`

const DeleteSession = `-- name: DeleteSession :exec
DELETE FROM auth_sessions
WHERE token_hash = ?
`

const DeleteToken = `-- name: DeleteToken :execrows
DELETE FROM auth_tokens
WHERE token_hash = ?
`

const DeleteUnconfirmedAccounts = `` /* 280-byte string literal not displayed */

const DeleteUserSessions = `-- name: DeleteUserSessions :exec
DELETE FROM auth_sessions
WHERE user_id = ?
`

const DeleteUserTokens = `-- name: DeleteUserTokens :exec
DELETE FROM auth_tokens
WHERE user_id = ?
`

const DeleteUserTokensForPurpose = `-- name: DeleteUserTokensForPurpose :exec
DELETE FROM auth_tokens
WHERE user_id = ? AND purpose = ?
`

const ExpiredTokens = `-- name: ExpiredTokens :many
SELECT user_id, purpose
FROM auth_tokens
WHERE expires_at <= ?
`

const FindLiveToken = `-- name: FindLiveToken :one
SELECT user_id
FROM auth_tokens
WHERE token_hash = ? AND purpose = ? AND expires_at > ?
`

const GetUserByEmail = `` /* 138-byte string literal not displayed */

const GetUserByID = `` /* 132-byte string literal not displayed */

const GetUserBySession = `` /* 246-byte string literal not displayed */

const GrantRoleToRoleless = `-- name: GrantRoleToRoleless :execrows
UPDATE auth_users
SET role = ?
WHERE role = ''
`

const HoldsPrivilege = `` /* 152-byte string literal not displayed */

const ListUsers = `` /* 136-byte string literal not displayed */

const ListUsersByIDs = `` /* 168-byte string literal not displayed */

const LockEnabledUser = `-- name: LockEnabledUser :one
SELECT id
FROM auth_users
WHERE id = ? AND NOT disabled
`

const LockUnactivatedUser = `-- name: LockUnactivatedUser :one
SELECT id
FROM auth_users
WHERE id = ? AND NOT disabled AND NOT confirmed
`

const LockUnconfirmedAccounts = `` /* 155-byte string literal not displayed */

const SetUserDisabled = `-- name: SetUserDisabled :execrows
UPDATE auth_users
SET disabled = ?
WHERE id = ?
`

const SetUserPassword = `-- name: SetUserPassword :execrows
UPDATE auth_users
SET password_hash = ?
WHERE id = ? AND NOT disabled
`

const SetUserRole = `-- name: SetUserRole :execrows
UPDATE auth_users
SET role = ?
WHERE id = ?
`