X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=sql%2Fccbs.sql;h=97bcd3f1be8c9b2a0e0dbcba2ec285240f785b0a;hb=a6425f3e55078bd6b9652f5f9e13bac3b3391cbb;hp=e9b3d321e91a682f6f15907f7ee54046c91dcd99;hpb=398357c297e5732f6ee2fcc1d4d73574e127f5af;p=ccbs 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 ),