From f8e2d20a24676ee5e17abbaeee854a9c14cebb0d Mon Sep 17 00:00:00 2001
From: Tor Andersson <tor@ccxvii.net>
Date: Sun, 14 Jan 2024 16:57:27 +0100
Subject: Fix rating_view schema.

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

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index 516fe28..650b379 100644
--- a/schema.sql
+++ b/schema.sql
@@ -192,7 +192,7 @@ create view rating_view as
 		title_id, name, rating, count, last
 	from
 		ratings
-		join users using(title_id, user_id)
+		join users using(user_id)
 	order by
 		title_id,
 		rating desc
-- 
cgit v1.2.3

