X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fccbs.sql;fp=sql%2Fccbs.sql;h=f9b6db313f425dc99f736c29859f59a6e73fefa8;hp=99b67003306220af9b40e6ce7234d0ede634c4e7;hb=78b3165f2d44ab70a0ab864dad6bdc14aed5fde7;hpb=39c362699f9d5070f2f09cfb576c4e2b0caa22f0;ds=sidebyside

diff --git a/sql/ccbs.sql b/sql/ccbs.sql
index 99b6700..f9b6db3 100644
--- a/sql/ccbs.sql
+++ b/sql/ccbs.sql
@@ -123,6 +123,7 @@ CREATE TABLE rounds (
 	chosensongs INTEGER NOT NULL,
 	numqualifying INTEGER,
 
+	UNIQUE (tournament, player),
 	PRIMARY KEY (tournament, round)
 );