From c8b338a686c3f5a50ae3efff6d5533cf671ea4d3 Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Sat, 13 Jun 2015 09:18:47 -0400 Subject: [PATCH] Update the unique key on the player captimes table. --- tables/player_map_captimes.tab | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/tables/player_map_captimes.tab b/tables/player_map_captimes.tab index cdc4afe..422702a 100644 --- a/tables/player_map_captimes.tab +++ b/tables/player_map_captimes.tab @@ -8,7 +8,7 @@ CREATE TABLE xonstat.player_map_captimes mod character varying(64), create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'), CONSTRAINT player_map_captimes_pk PRIMARY KEY (player_map_captime_id), - CONSTRAINT player_map_captimes_uk01 UNIQUE (player_id, map_id), + CONSTRAINT player_map_captimes_uk01 UNIQUE (player_id, map_id, mod), CONSTRAINT player_map_captimes_fk01 FOREIGN KEY (player_id) REFERENCES xonstat.players (player_id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION, -- 2.39.2