Unify permissions on all the table scripts.

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

diff --git a/tables/achievements.tab b/tables/achievements.tab
old mode 100644 (file)
new mode 100755 (executable)
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