From 18d3512ec6a5ece76322093ab9d987ee881a020f Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Sat, 30 Jan 2016 14:47:30 -0500 Subject: [PATCH] Add an MV for active players. --- tables/active_players_mv.tab | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100755 tables/active_players_mv.tab diff --git a/tables/active_players_mv.tab b/tables/active_players_mv.tab new file mode 100755 index 0000000..0d22213 --- /dev/null +++ b/tables/active_players_mv.tab @@ -0,0 +1,9 @@ +create table active_players_mv( + sort_order integer, + player_id bigint, + nick character varying(128), + alivetime interval, + create_dt timestamp without time zone default (now() at time zone 'UTC') +); + +ALTER TABLE xonstat.active_players_mv OWNER TO xonstat; -- 2.39.2