From d0ad8051bb08e1460be7cfd310f2fb9342623199 Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Mon, 5 Dec 2011 12:15:31 -0500 Subject: [PATCH] Add a unique constraint on server_id/match_id. --- tables/games.tab | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) mode change 100644 => 100755 tables/games.tab diff --git a/tables/games.tab b/tables/games.tab old mode 100644 new mode 100755 index e26ba1d..a9a5e5a --- a/tables/games.tab +++ b/tables/games.tab @@ -18,7 +18,8 @@ CREATE TABLE xonstat.games ON UPDATE NO ACTION ON DELETE NO ACTION, CONSTRAINT games_fk003 FOREIGN KEY (map_id) REFERENCES xonstat.maps (map_id) MATCH SIMPLE - ON UPDATE NO ACTION ON DELETE NO ACTION + ON UPDATE NO ACTION ON DELETE NO ACTION, + CONSTRAINT games_uk001 UNIQUE KEY (server_id, match_id) ) WITH ( OIDS=FALSE -- 2.39.2