projects
/
ccbs
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
8ec1d66
)
Add a table for tournament ranking to the SQL schema.
author
Steinar H. Gunderson
<sesse@samfundet.no>
Mon, 14 Feb 2005 02:01:32 +0000
(
02:01
+0000)
committer
Steinar H. Gunderson
<sesse@samfundet.no>
Mon, 14 Feb 2005 02:01:32 +0000
(
02:01
+0000)
sql/ccbs.sql
patch
|
blob
|
history
diff --git
a/sql/ccbs.sql
b/sql/ccbs.sql
index
e0b6284
..
44dcdf9
100644
(file)
--- 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,