From e6217cf647a58ad25f62dd37f7dc58c6a617807e Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Sun, 13 Feb 2005 18:16:27 +0000 Subject: [PATCH 1/1] Add uniqueness constraint to tournaments as well. --- sql/ccbs.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/sql/ccbs.sql b/sql/ccbs.sql index 0bbc009..b866067 100644 --- a/sql/ccbs.sql +++ b/sql/ccbs.sql @@ -64,7 +64,9 @@ CREATE TABLE tournaments ( location VARCHAR NOT NULL, "date" DATE NOT NULL, machine INTEGER NOT NULL REFERENCES machines, - scoringsystem INTEGER NOT NULL REFERENCES scoringsystems + scoringsystem INTEGER NOT NULL REFERENCES scoringsystems, + + UNIQUE ( season, name ) ); CREATE TABLE rounds ( -- 2.39.2