From 13d692e9ecbf67e361d7512ab79ff38238e6f19a Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Sun, 13 Feb 2005 18:32:15 +0000 Subject: [PATCH] Add position to roundparticipation (so we can order by it). --- sql/ccbs.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/sql/ccbs.sql b/sql/ccbs.sql index b866067..11901b4 100644 --- a/sql/ccbs.sql +++ b/sql/ccbs.sql @@ -102,8 +102,10 @@ CREATE TABLE roundparticipation ( round INTEGER NOT NULL, parallel INTEGER NOT NULL, player INTEGER NOT NULL REFERENCES players, + position INTEGER NOT NULL, UNIQUE (tournament, round, player), + UNIQUE (tournament, round, parallel, position) FOREIGN KEY (tournament, round, parallel) REFERENCES groups (tournament, round, parallel), PRIMARY KEY (tournament, round, parallel, player) ); -- 2.39.2