Add default to the create_dt of player game stats.
authorAnt Zucaro <azucaro@gmail.com>
Thu, 17 Nov 2011 15:15:40 +0000 (10:15 -0500)
committerAnt Zucaro <azucaro@gmail.com>
Thu, 17 Nov 2011 15:15:40 +0000 (10:15 -0500)
tables/player_game_stats.tab

index 947e072..c6988b2 100644 (file)
@@ -23,7 +23,7 @@ CREATE TABLE xonstat.player_game_stats
   pushes integer,
   pushed integer,
   carrier_frags integer,
-  create_dt timestamp without time zone NOT NULL,
+  create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'),
   CONSTRAINT player_game_stats_pk PRIMARY KEY (player_game_stat_id),
   CONSTRAINT player_game_stats_fk001 FOREIGN KEY (player_id)
       REFERENCES xonstat.players (player_id) MATCH SIMPLE