From 8bf395371926b3686c6ba3f1dd549c7ce9a7c2fb Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Mon, 14 Feb 2005 02:01:32 +0000 Subject: [PATCH] Add a table for tournament ranking to the SQL schema. --- sql/ccbs.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) diff --git a/sql/ccbs.sql b/sql/ccbs.sql index e0b6284..44dcdf9 100644 --- a/sql/ccbs.sql +++ b/sql/ccbs.sql @@ -69,6 +69,16 @@ CREATE TABLE tournaments ( 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, -- 2.39.2