From: Steinar H. Gunderson <sesse@samfundet.no>
Date: Sun, 13 Feb 2005 18:16:27 +0000 (+0000)
Subject: Add uniqueness constraint to tournaments as well.
X-Git-Url: https://git.sesse.net/?p=ccbs;a=commitdiff_plain;h=e6217cf647a58ad25f62dd37f7dc58c6a617807e

Add uniqueness constraint to tournaments as well.
---

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 (