From 9841965b47d4b54f28d3f3c0c0f44943976994aa Mon Sep 17 00:00:00 2001
From: schneefux <schneefux+commit@schneefux.xyz>
Date: Tue, 25 Jul 2017 13:15:50 +0200
Subject: add trueskill delta, rename trueskill max

---
 crunch_global.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'crunch_global.sql')

diff --git a/crunch_global.sql b/crunch_global.sql
index 0a2ab4b..176b296 100644
--- a/crunch_global.sql
+++ b/crunch_global.sql
@@ -16,6 +16,7 @@ select
     -- everything added here needs to be in on DUPLICATE too!!!
     count(p.id) as played,
     sum(cast(p.winner as INT)) as wins,
+    sum(p.trueskill_delta) as trueskill_delta,
     sum(p_s.duration) as time_spent,
     sum(p_s.kills) as kills,
     sum(p_s.deaths) as deaths,
@@ -63,6 +64,7 @@ order by p.id
 on duplicate key update
 played = played + values(played),
 wins = wins + values(wins),
+trueskill_delta = trueskill_delta + values(trueskill_delta),
 time_spent = time_spent + values(time_spent),
 kills = kills + values(kills),
 deaths = deaths + values(deaths),
-- 
cgit v1.3.1

