Update README

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

diff --git a/tables/achievements.tab b/tables/achievements.tab
index 2ad5c2ef23a44f86d2a277bb53ad642e6609db9e..a5006a4ee03d0222dbc260c6283755bfb57aae33 100644 (file)
--- 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 now(),
   CONSTRAINT achievements_pk PRIMARY KEY (achievement_id),
   CONSTRAINT achievements_fk001 FOREIGN KEY (achievement_cd)
       REFERENCES xonstat.cd_achievement (achievement_cd) MATCH SIMPLE