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