]> git.sesse.net Git - ccbs/blobdiff - sql/ccbs.sql
Update the parser scripts to handle tournament rankings, and fix a typo in the SQL...
[ccbs] / sql / ccbs.sql
index 44dcdf98a6617e01ac5f35a284fce98e218a765b..b7d342a91551b4bcd9d5185031b39c7906327352 100644 (file)
@@ -73,7 +73,7 @@ CREATE TABLE tournamentrankings (
        tournament INTEGER NOT NULL REFERENCES tournaments,
        ranking INTEGER NOT NULL,
        player INTEGER NOT NULL REFERENCES players,
        tournament INTEGER NOT NULL REFERENCES tournaments,
        ranking INTEGER NOT NULL,
        player INTEGER NOT NULL REFERENCES players,
-       points INTEGER
+       points INTEGER,
 
        UNIQUE (tournament, player),
        PRIMARY KEY (tournament, ranking)
 
        UNIQUE (tournament, player),
        PRIMARY KEY (tournament, ranking)