]> git.sesse.net Git - ccbs/blobdiff - sql/ccbs.sql
Players may now split places in tournament rankings.
[ccbs] / sql / ccbs.sql
index 2b1a68605721d7ce334075fbb4873eff8a83221d..22c99bc55b8994de07692621f33f23fcbcccbe52 100644 (file)
@@ -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 (