From: Steinar H. Gunderson <sesse@samfundet.no>
Date: Sun, 13 Feb 2005 16:47:46 +0000 (+0000)
Subject: Add an UNIQUE constraint on song title.
X-Git-Url: https://git.sesse.net/?p=ccbs;a=commitdiff_plain;h=2874aa98249548d1f60448bd74a596de5a4e7545;ds=sidebyside

Add an UNIQUE constraint on song title.
---

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.