From: Steinar H. Gunderson <sgunderson@bigfoot.com>
Date: Sat, 19 Feb 2005 19:26:40 +0000 (+0000)
Subject: Fixed a typo in the SQL for shorttitles.
X-Git-Url: https://git.sesse.net/?p=ccbs;a=commitdiff_plain;h=51f4b7eb1881b302cdf9f5006a4549ce8600a418

Fixed a typo in the SQL for shorttitles.
---

diff --git a/sql/ccbs.sql b/sql/ccbs.sql
index e9b3d32..97bcd3f 100644
--- a/sql/ccbs.sql
+++ b/sql/ccbs.sql
@@ -25,7 +25,7 @@ CREATE TABLE songs (
 );
 
 CREATE TABLE songshorttitles (
-	song INTEGER NOT NULL REFERENCES song,
+	song INTEGER NOT NULL REFERENCES songs,
 	shorttitle VARCHAR NOT NULL,
 
 	PRIMARY KEY ( song, shorttitle ),