Remove unique constraint on pgstats that prevents multiple bot stats.

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

diff --git a/tables/player_game_stats.tab b/tables/player_game_stats.tab
index 0ac34ba2e395b1cefaf7d9bd9ad16922eb7a6a17..840520fd039f17ea329e5e72d6ca3d1f661134e0 100644 (file)
--- a/tables/player_game_stats.tab
+++ b/tables/player_game_stats.tab
@@ -30,8 +30,7 @@ CREATE TABLE xonstat.player_game_stats
       ON UPDATE NO ACTION ON DELETE NO ACTION,
   CONSTRAINT player_game_stats_fk002 FOREIGN KEY (game_id)
       REFERENCES xonstat.games (game_id) MATCH SIMPLE
-      ON UPDATE NO ACTION ON DELETE NO ACTION,
-  CONSTRAINT player_game_stats_uk001 UNIQUE (player_id, game_id)
+      ON UPDATE NO ACTION ON DELETE NO ACTION
 )
 WITH (
   OIDS=FALSE