blob: f2d112ee3bf3b226601c466e7880d7113b0c330d (
plain)
1
2
3
4
5
6
7
8
|
create table if not exists albums(
date varchar(12) not null,
artist varchar(255) not null,
album varchar(255) 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 (album);
|