Fix unique key definition on games.

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

diff --git a/tables/games.tab b/tables/games.tab
index 15c32869136a14734baad21c7ac1c513b49cceb6..2d8a4a5386cf3b079278aa257289d5f21eff2d29 100755 (executable)
--- a/tables/games.tab
+++ b/tables/games.tab
@@ -19,7 +19,7 @@ CREATE TABLE xonstat.games
   CONSTRAINT games_fk003 FOREIGN KEY (map_id)
       REFERENCES xonstat.maps (map_id) MATCH SIMPLE
       ON UPDATE NO ACTION ON DELETE NO ACTION,
-  CONSTRAINT games_uk001 UNIQUE KEY (server_id, match_id)
+  CONSTRAINT games_uk001 UNIQUE (server_id, match_id)
 )
 WITH (
   OIDS=FALSE