CREATE TABLE songs ( id int primary key, title varchar(50), artist varchar(50), composer varchar(50) performer varchar(50) album_id int, track_number int, duration varchar(10), mtime varchar(50), gain float, peak float, path varchar(100), ); CREATE TABLE albums ( id int primary key, title varchar(50), discnumber int, totaltracks int );