diff options
Diffstat (limited to 'query/users.sql')
| -rw-r--r-- | query/users.sql | 11 |
1 files changed, 1 insertions, 10 deletions
diff --git a/query/users.sql b/query/users.sql index 9866c8a..f3629ca 100644 --- a/query/users.sql +++ b/query/users.sql @@ -36,21 +36,12 @@ UPDATE users SET WHERE id = ? AND is_deleted = false RETURNING *; --- name: SerUserPublicDMs :one +-- name: SetUserPublicDMs :one UPDATE users SET is_public_dm = ? WHERE id = ? AND is_deleted = false RETURNING *; --- name: UpdateUser :one -UPDATE users SET - name = COALESCE(?, name), - public_key = COALESCE(?, public_key), - description = COALESCE(?, description), - is_public_dm = COALESCE(?, is_public_dm) -WHERE id = ? AND is_deleted = false -RETURNING *; - -- name: DeleteUser :one UPDATE users SET is_deleted = true |
