From f64c11cc1e7a1fb68dcc1b342fe50df1bde75219 Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Thu, 17 Nov 2011 10:15:40 -0500 Subject: [PATCH] Add default to the create_dt of player game stats. --- tables/player_game_stats.tab | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/tables/player_game_stats.tab b/tables/player_game_stats.tab index 947e072..c6988b2 100644 --- a/tables/player_game_stats.tab +++ b/tables/player_game_stats.tab @@ -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 -- 2.39.2