From 398357c297e5732f6ee2fcc1d4d73574e127f5af Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Sat, 19 Feb 2005 19:24:00 +0000 Subject: [PATCH] Added a provision in the SQL for abbreviated titles. --- sql/ccbs.sql | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/sql/ccbs.sql b/sql/ccbs.sql index c3005d1..e9b3d32 100644 --- a/sql/ccbs.sql +++ b/sql/ccbs.sql @@ -24,6 +24,14 @@ CREATE TABLE songs ( UNIQUE ( title ) ); +CREATE TABLE songshorttitles ( + song INTEGER NOT NULL REFERENCES song, + shorttitle VARCHAR NOT NULL, + + PRIMARY KEY ( song, shorttitle ), + UNIQUE ( shorttitle ) +); + CREATE TABLE machinesongs ( song INTEGER NOT NULL REFERENCES songs, machine INTEGER NOT NULL REFERENCES machines, -- 2.39.2