Add TKA to the full build.

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

diff --git a/tables/player_map_captimes.tab b/tables/player_map_captimes.tab
old mode 100644 (file)
new mode 100755 (executable)
index c9960a3..422702a
--- a/tables/player_map_captimes.tab
+++ b/tables/player_map_captimes.tab
@@ -5,9 +5,10 @@ CREATE TABLE xonstat.player_map_captimes
   map_id integer NOT NULL,
   game_id bigint NOT NULL,
   fastest_cap interval NOT NULL,
+  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,