From: Steinar H. Gunderson <sesse@samfundet.no>
Date: Sun, 13 Feb 2005 18:32:15 +0000 (+0000)
Subject: Add position to roundparticipation (so we can order by it).
X-Git-Url: https://git.sesse.net/?p=ccbs;a=commitdiff_plain;h=13d692e9ecbf67e361d7512ab79ff38238e6f19a

Add position to roundparticipation (so we can order by it).
---

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)
 );