X-Git-Url: http://de.git.xonotic.org/?a=blobdiff_plain;f=tables%2Fplayer_weapon_stats.tab;h=60954bbff423ff3014adab4fdb37e418ab8a98c1;hb=75f5b39c54ab9d7a5f118aa4de1c1d0bb76626d1;hp=2968a8982c0f5ceb5231a6aa5eb2f1db8f7eb8ce;hpb=6fadb473da829b2a02075418f51c831b27a1acd5;p=xonotic%2Fxonstatdb.git

diff --git a/tables/player_weapon_stats.tab b/tables/player_weapon_stats.tab
index 2968a89..60954bb 100644
--- a/tables/player_weapon_stats.tab
+++ b/tables/player_weapon_stats.tab
@@ -10,7 +10,7 @@ CREATE TABLE xonstat.player_weapon_stats
   hit integer NOT NULL default 0,
   fired integer NOT NULL default 0,
   frags integer NOT NULL default 0,
-  create_dt timestamp without time zone NOT NULL DEFAULT now(),
+  create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'),
   CONSTRAINT player_weapon_stats_pk PRIMARY KEY (player_weapon_stats_id),
   CONSTRAINT player_weapon_stats_fk001 FOREIGN KEY (player_id)
       REFERENCES xonstat.players (player_id) MATCH SIMPLE