Use UTC timestamps instead of local timestamps.

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

diff --git a/tables/achievements.tab b/tables/achievements.tab
index a5006a4ee03d0222dbc260c6283755bfb57aae33..139e777bdfa7e18f757db36478ae16a8784eb485 100644 (file)
--- a/tables/achievements.tab
+++ b/tables/achievements.tab
@@ -3,7 +3,7 @@ CREATE TABLE xonstat.achievements
   achievement_id serial NOT NULL,
   achievement_cd integer NOT NULL,
   player_id integer NOT NULL,
-  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 achievements_pk PRIMARY KEY (achievement_id),
   CONSTRAINT achievements_fk001 FOREIGN KEY (achievement_cd)
       REFERENCES xonstat.cd_achievement (achievement_cd) MATCH SIMPLE