From 2874aa98249548d1f60448bd74a596de5a4e7545 Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Sun, 13 Feb 2005 16:47:46 +0000 Subject: [PATCH] Add an UNIQUE constraint on song title. --- ccbs.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/ccbs.sql b/ccbs.sql index 53289ec..e4a129f 100644 --- a/ccbs.sql +++ b/ccbs.sql @@ -15,7 +15,9 @@ CREATE TABLE songs ( title VARCHAR NOT NULL, artist VARCHAR NOT NULL, minbpm INTEGER NOT NULL, - maxbpm INTEGER NOT NULL + maxbpm INTEGER NOT NULL, + + UNIQUE ( title ) ); -- CREATE TABLE machinesongs etc. -- 2.39.2