summaryrefslogtreecommitdiff
path: root/schema.sql
diff options
context:
space:
mode:
authorTor Andersson <tor@ccxvii.net>2023-10-13 19:17:52 +0200
committerTor Andersson <tor@ccxvii.net>2023-10-13 20:03:41 +0200
commit5cdc7862b20c8642a235e8ea46686939e5f6032a (patch)
tree0c2c725bd0edb8a6707a9d4811f4bd74c4c9e1db /schema.sql
parentf642d234d346138552809a9c11357127e15fb0f3 (diff)
downloadserver-5cdc7862b20c8642a235e8ea46686939e5f6032a.tar.gz
Fix SQL game view to show games with no owner.
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql2
1 files changed, 1 insertions, 1 deletions
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
;