X-Git-Url: http://de.git.xonotic.org/?a=blobdiff_plain;f=tables%2Fsummary_stats_mv.tab;h=4b8a1f58468901de59cdc877d025d9ec322c6f46;hb=e243918a57c21da7d77609af2a8336c45be93d31;hp=c0b6c3ff5247bd4c4ba23776cf09db49cebf7fc1;hpb=2fb4bf3cf76c6a27be0718c008c64aa9bf23c662;p=xonotic%2Fxonstatdb.git

diff --git a/tables/summary_stats_mv.tab b/tables/summary_stats_mv.tab
index c0b6c3f..4b8a1f5 100644
--- a/tables/summary_stats_mv.tab
+++ b/tables/summary_stats_mv.tab
@@ -3,7 +3,8 @@ CREATE TABLE summary_stats_mv (
 	sort_order integer,
 	num_players integer,
 	game_type_cd character varying(10),
-	num_games integer
+	num_games integer,
+    create_dt timestamp without time zone default (now() at time zone 'UTC')
 );
 
 ALTER TABLE xonstat.summary_stats_mv OWNER TO xonstat;