From 6cd729c49f65aa293358b3ec14fa13f0f04c7daf Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Sun, 13 Feb 2005 16:02:08 +0000 Subject: [PATCH] Syntax fixes. --- ccbs.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/ccbs.sql b/ccbs.sql index 0fc451b..b4622ce 100644 --- a/ccbs.sql +++ b/ccbs.sql @@ -7,9 +7,9 @@ CREATE TABLE songs ( CREATE TABLE songratings ( 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'), - feetrating INTEGER NOT NULL CHECK (feetrating >= 0 AND feetrating <= 10) + 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) ); -- 2.39.2