From: Ant Zucaro <azucaro@gmail.com>
Date: Wed, 8 Nov 2017 02:19:04 +0000 (-0500)
Subject: Modify the sum type of the active servers MV.
X-Git-Url: http://git.xonotic.org/?p=xonotic%2Fxonstatdb.git;a=commitdiff_plain;h=735ed4f3033584d9cf7bdbd98dfd8140ac0de4d2

Modify the sum type of the active servers MV.
---

diff --git a/tables/active_servers_mv.tab b/tables/active_servers_mv.tab
index a6be890..3a5c594 100755
--- a/tables/active_servers_mv.tab
+++ b/tables/active_servers_mv.tab
@@ -2,7 +2,7 @@ create table active_servers_mv(
 	sort_order integer,
 	server_id bigint,
 	server_name character varying(128),
-	games integer,
+	play_time interval,
 	create_dt timestamp without time zone default (now() at time zone 'UTC'),
     CONSTRAINT active_servers_mv_pk PRIMARY KEY (sort_order)
 );