summaryrefslogtreecommitdiff
path: root/schema.sql
diff options
context:
space:
mode:
authorTor Andersson <tor@ccxvii.net>2023-09-21 21:33:20 +0200
committerTor Andersson <tor@ccxvii.net>2023-09-21 22:16:42 +0200
commit93c7a6e1443d19e8f924ba0bdaeffb3c755c4d7f (patch)
treef540c1896c6cfa9d22043004de47b6d488323e6b /schema.sql
parent97dc9e45cc7088c5b1c220f5e8ae306d94eaaab6 (diff)
downloadserver-93c7a6e1443d19e8f924ba0bdaeffb3c755c4d7f.tar.gz
Only update ELO if at least 5 moves were made.
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/schema.sql b/schema.sql
index d4cb397..f38ba53 100644
--- a/schema.sql
+++ b/schema.sql
@@ -156,6 +156,7 @@ create view rated_games_view as
games
where
status > 1
+ and moves > 5
and user_count = player_count
and player_count > 1
and not exists (