CREATE TABLE users ( name string PRIMARY KEY, password string ); CREATE TABLE sessions ( user string, token string PRIMARY KEY, client string, protocol string, created int ); CREATE TABLE scrobbles ( artist string, albumartist string, trackname string, album string, tracknumber int, duration int, time int, chosen bool, mbid string, session string );