Add a summary stats "materialized view".

[xonotic/xonstatdb.git] / tables / summary_stats_mv.tab

diff --git a/tables/summary_stats_mv.tab b/tables/summary_stats_mv.tab
new file mode 100644 (file)
index 0000000..c0b6c3f
--- /dev/null
+++ b/tables/summary_stats_mv.tab
@@ -0,0 +1,9 @@
+CREATE TABLE summary_stats_mv (
+       scope character varying(30),
+       sort_order integer,
+       num_players integer,
+       game_type_cd character varying(10),
+       num_games integer
+);
+
+ALTER TABLE xonstat.summary_stats_mv OWNER TO xonstat;