X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=sql%2Fccbs.sql;h=22c99bc55b8994de07692621f33f23fcbcccbe52;hb=df9a219dc572f63e39ff432e052883c4052ff448;hp=2b1a68605721d7ce334075fbb4873eff8a83221d;hpb=7cef45596273ce846eef3b58393d768c0b8d9dc6;p=ccbs

diff --git a/sql/ccbs.sql b/sql/ccbs.sql
index 2b1a686..22c99bc 100644
--- a/sql/ccbs.sql
+++ b/sql/ccbs.sql
@@ -111,8 +111,7 @@ CREATE TABLE tournamentrankings (
 	player INTEGER NOT NULL REFERENCES players,
 	points INTEGER,
 
-	UNIQUE (tournament, player),
-	PRIMARY KEY (tournament, ranking)
+	PRIMARY KEY (tournament, player)
 );
 
 CREATE TABLE rounds (