From 6c49eba2219d2af1a5ffd918ab853443d9c48b42 Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Fri, 18 Feb 2005 15:27:12 +0000 Subject: [PATCH 1/1] Different songs can have different ratings on different machines, so change the SQL schemas. --- sql/ccbs.sql | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/sql/ccbs.sql b/sql/ccbs.sql index d7d461f..bc4b0e4 100644 --- a/sql/ccbs.sql +++ b/sql/ccbs.sql @@ -39,12 +39,13 @@ CREATE TABLE scoringsystems ( ); CREATE TABLE songratings ( - song INTEGER NOT NULL REFERENCES songs, -- strictly song+machine + song INTEGER NOT NULL REFERENCES songs, + machine INTEGER NOT NULL REFERENCES machines, playmode VARCHAR NOT NULL CHECK (playmode IN ('single','double')), difficulty VARCHAR NOT NULL CHECK (difficulty IN ('beginner','standard','difficult','expert','challenge')), feetrating INTEGER NOT NULL CHECK (feetrating >= 0 AND feetrating <= 10), - PRIMARY KEY (song, playmode, difficulty) + PRIMARY KEY (song, machine, playmode, difficulty) ); CREATE TABLE players ( @@ -148,7 +149,7 @@ CREATE TABLE scores ( chosen BOOLEAN, score INTEGER CHECK (score IS NULL OR (score >= 0 AND score <= 10000)), - FOREIGN KEY (song, playmode, difficulty) REFERENCES songratings (song, playmode, difficulty), + -- FOREIGN KEY (song, playmode, difficulty) REFERENCES songratings (song, playmode, difficulty), FOREIGN KEY (tournament, round, parallel, player) REFERENCES roundparticipation (tournament, round, parallel, player), PRIMARY KEY (tournament, round, parallel, player, songnumber) ); -- 2.39.2