From 6aa382f07a75872db327f5f1ed1c012da0d3d5e3 Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Fri, 22 Dec 2023 00:23:43 +0100
Subject: Send system chat messages when players join and part active games.

---
 schema.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index 49da960..f780af4 100644
--- a/schema.sql
+++ b/schema.sql
@@ -405,7 +405,7 @@ create view game_chat_view as
 		game_id, chat_id, time, name, message
 	from
 		game_chat
-		join users using(user_id)
+		left join users using(user_id)
 	;
 
 create table if not exists game_replay (
-- 
cgit v1.2.3

