From 5a88d5b04d8e950680a1417a3100c09165f57bbf Mon Sep 17 00:00:00 2001
From: Ant Zucaro <azucaro@gmail.com>
Date: Sat, 30 Jan 2016 14:52:50 -0500
Subject: [PATCH] Add an MV for active servers.

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

diff --git a/tables/active_servers_mv.tab b/tables/active_servers_mv.tab
new file mode 100755
index 0000000..28fcb6d
--- /dev/null
+++ b/tables/active_servers_mv.tab
@@ -0,0 +1,9 @@
+create table active_servers_mv(
+	sort_order integer,
+	server_id bigint,
+	server_name character varying(128),
+	games integer,
+	create_dt timestamp without time zone default (now() at time zone 'UTC')
+);
+
+ALTER TABLE xonstat.active_servers_mv OWNER TO xonstat;
-- 
2.39.2