projects
/
ccbs
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
3e2a27f
)
Add a new table to the SQL for tournament participation.
author
Steinar H. Gunderson
<sesse@samfundet.no>
Mon, 14 Feb 2005 14:46:00 +0000
(14:46 +0000)
committer
Steinar H. Gunderson
<sesse@samfundet.no>
Mon, 14 Feb 2005 14:46:00 +0000
(14:46 +0000)
sql/ccbs.sql
patch
|
blob
|
history
diff --git
a/sql/ccbs.sql
b/sql/ccbs.sql
index
b7d342a
..
c248214
100644
(file)
--- 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,