CREATE TABLE authors (authorid INTEGER PRIMARY KEY, authorname VARCHAR(40) NOT NULL);
CREATE TABLE songauthors (authorid INTEGER, songid INTEGER);
CREATE TABLE songs (songid INTEGER PRIMARY KEY, songtitle VARCHAR(60) NOT NULL, lyrics BLOB NOT NULL, copyrightinfo VARCHAR(255), settingsid INTEGER NOT NULL);