X-Git-Url: http://git.xonotic.org/?a=blobdiff_plain;f=tables%2Fachievements.tab;h=139e777bdfa7e18f757db36478ae16a8784eb485;hb=3edab703b50d1068254554b5851cf22fea1d1b59;hp=2ad5c2ef23a44f86d2a277bb53ad642e6609db9e;hpb=43a962d48f81097237c35a0f6c74e62de2bca028;p=xonotic%2Fxonstatdb.git

diff --git a/tables/achievements.tab b/tables/achievements.tab
old mode 100644
new mode 100755
index 2ad5c2e..139e777
--- a/tables/achievements.tab
+++ b/tables/achievements.tab
@@ -2,8 +2,8 @@ CREATE TABLE xonstat.achievements
 (
   achievement_id serial NOT NULL,
   achievement_cd integer NOT NULL,
-  player_id serial NOT NULL,
-  create_dt timestamp with time zone NOT NULL DEFAULT now(),
+  player_id integer NOT NULL,
+  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