diff options
| author | Kyren223 <Kyren223@proton.me> | 2025-01-26 19:09:02 +0200 |
|---|---|---|
| committer | Kyren223 <Kyren223@proton.me> | 2025-01-26 19:09:02 +0200 |
| commit | 97a85f94e58ebb48a955c6d658e5e9683bc72a7b (patch) | |
| tree | fd24f7215d1084ffcdb4e4ac3fb04ac788e25ef3 /query | |
| parent | eab0af859c13e1cf75fbd7b606ed164f429d2320 (diff) | |
Added the ability to read and send messages between 2 users
Diffstat (limited to 'query')
| -rw-r--r-- | query/messages.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/query/messages.sql b/query/messages.sql index 063b576..ed8b315 100644 --- a/query/messages.sql +++ b/query/messages.sql @@ -10,7 +10,7 @@ ORDER BY id; -- name: GetDirectMessages :many SELECT * FROM messages WHERE - (sender_id = @user1 AND receiver_id = @user2) OR + (sender_id = @user1 AND receiver_id = @user2) OR (sender_id = @user2 AND receiver_id = @user1) ORDER BY id; |