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

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

diff --git a/tables/achievements.tab b/tables/achievements.tab
index 1ce2cde69afceb77942506fb59e2b057fb0ac0e8..a5006a4ee03d0222dbc260c6283755bfb57aae33 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 with time zone NOT NULL DEFAULT now(),
+  create_dt timestamp without time zone NOT NULL DEFAULT now(),
   CONSTRAINT achievements_pk PRIMARY KEY (achievement_id),
   CONSTRAINT achievements_fk001 FOREIGN KEY (achievement_cd)
       REFERENCES xonstat.cd_achievement (achievement_cd) MATCH SIMPLE