X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=ccbs.sql;h=e4a129f4ee631c60762afd4c727837d39c85b807;hp=53289ec6ab009e3b44d2ee2e15d801ddac2c4612;hb=2874aa98249548d1f60448bd74a596de5a4e7545;hpb=a417b96ae900ccd4cc4666cae76d271e3b7b7bd2 diff --git a/ccbs.sql b/ccbs.sql index 53289ec..e4a129f 100644 --- a/ccbs.sql +++ b/ccbs.sql @@ -15,7 +15,9 @@ CREATE TABLE songs ( title VARCHAR NOT NULL, artist VARCHAR NOT NULL, minbpm INTEGER NOT NULL, - maxbpm INTEGER NOT NULL + maxbpm INTEGER NOT NULL, + + UNIQUE ( title ) ); -- CREATE TABLE machinesongs etc.