UNIQUE ( season, tournamentname )
);
+CREATE TABLE tournamentrankings (
+ tournament INTEGER NOT NULL REFERENCES tournaments,
+ ranking INTEGER NOT NULL,
+ player INTEGER NOT NULL REFERENCES players,
+ points INTEGER
+
+ UNIQUE (tournament, player),
+ PRIMARY KEY (tournament, ranking)
+);
+
CREATE TABLE rounds (
tournament INTEGER NOT NULL REFERENCES tournaments,
round INTEGER NOT NULL,