diff options
| author | Kyren223 <Kyren223@proton.me> | 2025-02-12 13:08:49 +0200 |
|---|---|---|
| committer | Kyren223 <Kyren223@proton.me> | 2025-02-12 13:08:49 +0200 |
| commit | 66983fb02847dc9b1c53916da0dc7ad5a09f6644 (patch) | |
| tree | 897301226bcb87bf6a7d2b823e74abecabece680 /query | |
| parent | 976d3683f963b6f9282a534e1b4fec2411b738a2 (diff) | |
Added blocking/unblocking of users using b/u (user settings are now s
instead of "u")
Diffstat (limited to 'query')
| -rw-r--r-- | query/trusted_and_blocked_users.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/query/trusted_and_blocked_users.sql b/query/trusted_and_blocked_users.sql index 5b80eac..71257a1 100644 --- a/query/trusted_and_blocked_users.sql +++ b/query/trusted_and_blocked_users.sql @@ -19,6 +19,10 @@ WHERE trusting_user_id = ? AND trusted_user_id = ?; SELECT blocked_user_id FROM blocked_users WHERE blocking_user_id = ?; +-- name: GetBlockingUsers :many +SELECT blocking_user_id FROM blocked_users +WHERE blocked_user_id = ?; + -- name: IsUserBlocked :one SELECT blocked_user_id FROM blocked_users WHERE blocking_user_id = ? AND blocked_user_id = ?; |
