From a3f0e98af04c042be42139660781d3e8b204a556 Mon Sep 17 00:00:00 2001
From: Ant Zucaro <azucaro@gmail.com>
Date: Fri, 12 May 2017 19:29:07 -0400
Subject: [PATCH] Add a new 'mv' table for player aggregate stats.

---
 tables/player_agg_stats_mv.tab | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)
 create mode 100755 tables/player_agg_stats_mv.tab

diff --git a/tables/player_agg_stats_mv.tab b/tables/player_agg_stats_mv.tab
new file mode 100755
index 0000000..28e58b3
--- /dev/null
+++ b/tables/player_agg_stats_mv.tab
@@ -0,0 +1,26 @@
+CREATE TABLE xonstat.player_agg_stats_mv
+(
+  player_id integer NOT NULL,
+  game_type_cd character varying(10),
+  nick character varying(128),
+  stripped_nick character varying(128),
+  last_seen timestamp without time zone,
+  games integer,
+  wins integer,
+  losses integer,
+  kills integer,
+  deaths integer,
+  suicides integer,
+  captures integer,
+  pickups integer,
+  drops integer,
+  carrier_frags integer,
+  alivetime interval,
+  create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'),
+  CONSTRAINT player_agg_stats_mv_pk PRIMARY KEY (player_id, game_type_cd),
+)
+WITH (
+  OIDS=FALSE
+);
+
+ALTER TABLE xonstat.player_agg_stats_mv OWNER TO xonstat;
-- 
2.39.2