From 5cdc7862b20c8642a235e8ea46686939e5f6032a Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Fri, 13 Oct 2023 19:17:52 +0200
Subject: Fix SQL game view to show games with no owner.

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

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index 536a831..85e5ba4 100644
--- a/schema.sql
+++ b/schema.sql
@@ -451,7 +451,7 @@ create view game_view as
 	from
 		games
 		join titles using(title_id)
-		join users as owner
+		left join users as owner
 			on owner.user_id = games.owner_id
 	;
 
-- 
cgit v1.2.3

