]> git.xonotic.org Git - xonotic/xonstatdb.git/commitdiff
Add an MV for active servers.
authorAnt Zucaro <azucaro@gmail.com>
Sat, 30 Jan 2016 19:52:50 +0000 (14:52 -0500)
committerAnt Zucaro <azucaro@gmail.com>
Sat, 30 Jan 2016 19:52:50 +0000 (14:52 -0500)
tables/active_servers_mv.tab [new file with mode: 0755]

diff --git a/tables/active_servers_mv.tab b/tables/active_servers_mv.tab
new file mode 100755 (executable)
index 0000000..28fcb6d
--- /dev/null
@@ -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;