Use UTC timestamps instead of local timestamps.

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

diff --git a/tables/player_weapon_stats.tab b/tables/player_weapon_stats.tab
index 2968a8982c0f5ceb5231a6aa5eb2f1db8f7eb8ce..60954bbff423ff3014adab4fdb37e418ab8a98c1 100644 (file)
--- 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,
   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
   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