summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTor Andersson <tor@ccxvii.net>2024-01-14 16:57:27 +0100
committerTor Andersson <tor@ccxvii.net>2024-01-28 13:50:27 +0100
commitf8e2d20a24676ee5e17abbaeee854a9c14cebb0d (patch)
tree3e06a8d6c74a205436c3473b3c1a4e679843bb97
parenta1c93c992e456764415b5a4c302e1137673c0a5f (diff)
downloadserver-f8e2d20a24676ee5e17abbaeee854a9c14cebb0d.tar.gz
Fix rating_view schema.
-rw-r--r--schema.sql2
1 files changed, 1 insertions, 1 deletions
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