4 path text not null primary key,
7 last_queued timestamp with time zone,
8 generation bigint not null);
10 create index songs_artist_idx on songs(artist);
11 create index songs_album_idx on songs(album);
16 last_queued timestamp with time zone,
17 generation bigint not null,
18 primary key(album,artist));
21 artist text not null primary key,
22 last_queued timestamp with time zone,
23 generation bigint not null);
25 create table unwanted_albums(
28 generation bigint not null,
29 primary key(album,artist));
31 create table unwanted_artists(
32 artist text not null primary key,
33 generation bigint not null
37 generation bigint not null
40 insert into options(generation) values(0);