CREATE TABLE users (
    name text PRIMARY KEY,
    password text
);

CREATE TABLE sessions (
    user text,
    key text PRIMARY KEY,
    client text,
    protocol text,
    created int DEFAULT (strftime('%s', 'now'))
);

CREATE TABLE scrobbles (
	artist      text,
	albumartist text,
	trackname   text,
	album       text,
	tracknumber int,
	duration    int,
	time        int,
	chosen      bool,
	mbid        text,
	session     text
);
