From 22add9e90e2c62a3a08d64b8c73a66b8de77bc97 Mon Sep 17 00:00:00 2001 From: kvahuja Date: Sat, 18 Feb 2017 15:42:48 +0530 Subject: refactoring as part of https://github.com/vainglorygame/vainsocial.com/issues/17 --- queries/match_results.sql | 22 ---------------------- 1 file changed, 22 deletions(-) delete mode 100644 queries/match_results.sql (limited to 'queries/match_results.sql') diff --git a/queries/match_results.sql b/queries/match_results.sql deleted file mode 100644 index c493d5c..0000000 --- a/queries/match_results.sql +++ /dev/null @@ -1,22 +0,0 @@ -SELECT - -attributes->'stats'->>'side' AS "team", -FALSE AS "winner", -FALSE AS "surrender", -0 AS "teamSize", -'' AS "hero_1", -'' AS "hero_2", -'' AS "hero_3", -0 AS "laneMinionsSlayed", -0 AS "jungleMinionsSlayed", -(attributes->'stats'->>'turretKills')::int AS "turretsDestroyed", -(attributes->'stats'->>'heroKills')::int AS "kills", -0 AS "assists", -0 AS "deaths", -(attributes->'stats'->>'krakenCaptures')::int AS "krakenCaptures", -0 AS "goldMineCaptures", -0 AS "crystalMineCaptures", -0 AS "afkCount", -0 AS "afkTime" - -FROM roster -- cgit v1.3.1