blob: 53d5c345953e07ee3d7553ecb76cbb9e4cce1b06 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
create table if not exists tracks(
date varchar(12) not null,
artist varchar(255) not null,
title varchar(255) not null,
album varchar(255) not null,
directory varchar(500) not null,
rating smallint not null
);
create index if not exists track_ratings_idx ON tracks (rating);
CREATE UNIQUE INDEX tracks_dir_idx ON tracks (directory);
create table if not exists albums(
date varchar(12) not null,
artist varchar(255) not null,
album varchar(255) not null,
directory varchar(500) not null,
rating smallint not null
);
create index if not exists album_ratings_idx ON albums (rating);
CREATE UNIQUE INDEX albums_dir_idx ON albums (directory);
|