]> git.xonotic.org Git - xonotic/xonstatdb.git/commitdiff
Add a create_dt to summary stats.
authorAnt Zucaro <azucaro@gmail.com>
Fri, 29 Jan 2016 03:13:04 +0000 (22:13 -0500)
committerAnt Zucaro <azucaro@gmail.com>
Fri, 29 Jan 2016 03:13:04 +0000 (22:13 -0500)
tables/summary_stats_mv.tab

index c0b6c3ff5247bd4c4ba23776cf09db49cebf7fc1..4b8a1f58468901de59cdc877d025d9ec322c6f46 100644 (file)
@@ -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;