schema.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

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
);