From 6192aa9b748e97a41399357d9497395e25e1381a Mon Sep 17 00:00:00 2001 From: antzucaro Date: Mon, 10 Oct 2011 15:06:42 -0400 Subject: [PATCH] Remove unique constraint on pgstats that prevents multiple bot stats. --- tables/player_game_stats.tab | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/tables/player_game_stats.tab b/tables/player_game_stats.tab index 0ac34ba..840520f 100644 --- 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 -- 2.39.2