summaryrefslogtreecommitdiff
path: root/query/users.sql
diff options
context:
space:
mode:
Diffstat (limited to 'query/users.sql')
-rw-r--r--query/users.sql11
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