diff options
Diffstat (limited to 'create_rating.sql')
-rw-r--r-- | create_rating.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/create_rating.sql b/create_rating.sql index 67c00a3..cf59285 100644 --- a/create_rating.sql +++ b/create_rating.sql @@ -6,6 +6,7 @@ create table if not exists tracks( 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, @@ -15,3 +16,4 @@ create table if not exists albums( rating smallint not null ); create index if not exists album_ratings_idx ON albums (rating); +CREATE UNIQUE INDEX albums_dir_idx ON albums (directory); |