Get rid of time zones. We do not need them.

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

diff --git a/tables/player_game_stats.tab b/tables/player_game_stats.tab
index 9cdf17c8d2c0e4a59fbaeccf6bd5f133e2c976ef..19da7ff2a4cf099e008e0b8e366637e8dc2a1eec 100644 (file)
--- a/tables/player_game_stats.tab
+++ b/tables/player_game_stats.tab
@@ -22,7 +22,7 @@ CREATE TABLE xonstat.player_game_stats
   pushes integer,
   pushed integer,
   carrier_frags integer,
   pushes integer,
   pushed integer,
   carrier_frags integer,

-  create_dt timestamp with time zone NOT NULL,
+  create_dt timestamp without time zone NOT NULL,

   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
   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