Update the unique key on the player captimes table.
authorAnt Zucaro <azucaro@gmail.com>
Sat, 13 Jun 2015 13:18:47 +0000 (09:18 -0400)
committerAnt Zucaro <azucaro@gmail.com>
Sat, 13 Jun 2015 13:18:47 +0000 (09:18 -0400)
tables/player_map_captimes.tab

index cdc4afe..422702a 100644 (file)
@@ -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,