dkforest

commit 65865b830fe0c0b20bebc9213935d64bbf951d61
parent 25133e9aa8f8687f6cb9a52d104534a5f686e809
Author: n0tr1v <n0tr1v@protonmail.com>
Date:   Sat,  4 Mar 2023 03:40:01 -0800

sql styling

Diffstat:
M
pkg/database/tableChatRooms.go
 | 
2
+-

1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/pkg/database/tableChatRooms.go b/pkg/database/tableChatRooms.go
@@ -150,7 +150,7 @@ FROM chat_rooms r
 LEFT JOIN chat_messages m ON m.id = (SELECT max(id) FROM chat_messages WHERE room_id = r.id AND (to_user_id IS NULL OR to_user_id = ?))
 -- Get read record for the authUser & room
 LEFT JOIN chat_read_records rr ON rr.user_id = ? AND rr.room_id = r.id
-WHERE r.name in ('general', 'programming', 'hacking', 'suggestions', 'club', 'moderators', 'announcements')
+WHERE r.name IN ('general', 'programming', 'hacking', 'suggestions', 'club', 'moderators', 'announcements')
 ORDER BY r.id ASC`, userID, userID).Scan(&out).Error
 	return
 }