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