X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;ds=sidebyside;f=sql%2Fccbs.sql;h=b8660671f1a89548a8788da21a267f0bb8599f2e;hb=e6217cf647a58ad25f62dd37f7dc58c6a617807e;hp=0bbc0097b8f0212b58017c3bfd6adf42a7e4fdd4;hpb=a0c29dc24500059c580f6ec2647e8a2d2385ea77;p=ccbs

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 (