From: Steinar H. Gunderson Date: Sun, 13 Feb 2005 15:59:05 +0000 (+0000) Subject: More (minor) adjustments to the schemas. X-Git-Url: https://git.sesse.net/?p=ccbs;a=commitdiff_plain;h=e1b1008c6e84434bd126adfeaaa1018b4a66e208;ds=inline More (minor) adjustments to the schemas. --- diff --git a/ccbs.sql b/ccbs.sql index 3b3c4e7..0fc451b 100644 --- a/ccbs.sql +++ b/ccbs.sql @@ -76,12 +76,14 @@ CREATE TABLE scores ( player INTEGER NOT NULL REFERENCES players, song INTEGER NOT NULL REFERENCES songs, - playmode VARCHAR NOT NULL CHECK playmode IN ('single','double'), - difficulty VARCHAR NOT NULL CHECK difficulty IN ('beginner','standard','difficult','expert','challenge'), + playmode VARCHAR CHECK playmode IS NULL OR playmode IN ('single','double'), + difficulty VARCHAR CHECK difficulty IS NULL OR difficulty IN ('beginner','standard','difficult','expert','challenge'), + chosen BOOLEAN NOT NULL, score INTEGER NOT NULL CHECK (score >= 0 AND score <= 10000), + FOREIGN KEY (song) REFERENCES songs (song), FOREIGN KEY (song, playmode, difficulty) REFERENCES songs (song, playmode, difficulty), - FOREIGN KEY (tournament, round, parallel) REFERENCES groups (tournament, round, parallel), - PRIMARY KEY (tournament, round, parallel, player, songs) -); + FOREIGN KEY (tournament, round, parallel, player) REFERENCES roundparticipation (tournament, round, parallel, player), + PRIMARY KEY (tournament, round, parallel, player, song) +);