From 22add9e90e2c62a3a08d64b8c73a66b8de77bc97 Mon Sep 17 00:00:00 2001
From: kvahuja <k.v.ahuja@gmail.com>
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

