projects
/
ccbs
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
9b9c0a0
)
Added a provision in the SQL for abbreviated titles.
author
Steinar H. Gunderson
<sgunderson@bigfoot.com>
Sat, 19 Feb 2005 19:24:00 +0000
(19:24 +0000)
committer
Steinar H. Gunderson
<sgunderson@bigfoot.com>
Sat, 19 Feb 2005 19:24:00 +0000
(19:24 +0000)
sql/ccbs.sql
patch
|
blob
|
history
diff --git
a/sql/ccbs.sql
b/sql/ccbs.sql
index
c3005d1
..
e9b3d32
100644
(file)
--- 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,