From e1b1008c6e84434bd126adfeaaa1018b4a66e208 Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Sun, 13 Feb 2005 15:59:05 +0000 Subject: [PATCH] More (minor) adjustments to the schemas. --- ccbs.sql | 12 +++++++----- 1 file changed, 7 insertions(+), 5 deletions(-) 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) +); -- 2.39.2