From 70e82d5f7f2b8cdd9b0d07744eae3c43999653fb Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Mon, 14 Feb 2005 14:46:00 +0000 Subject: [PATCH 1/1] Add a new table to the SQL for tournament participation. --- sql/ccbs.sql | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/sql/ccbs.sql b/sql/ccbs.sql index b7d342a..c248214 100644 --- a/sql/ccbs.sql +++ b/sql/ccbs.sql @@ -69,6 +69,14 @@ CREATE TABLE tournaments ( UNIQUE ( season, tournamentname ) ); +CREATE TABLE tournamentparticipation ( + tournament INTEGER NOT NULL REFERENCES tournaments, + player INTEGER NOT NULL REFERENCES players, + paid BOOLEAN NOT NULL, + + PRIMARY KEY ( tournament, player ) +); + CREATE TABLE tournamentrankings ( tournament INTEGER NOT NULL REFERENCES tournaments, ranking INTEGER NOT NULL, -- 2.39.2