removed uris from ratings

1 files changed, 4 insertions, 4 deletions

diff --git a/create_rating.sql b/create_rating.sql
index cf59285..470997f 100644
--- a/create_rating.sql
+++ b/create_rating.sql
@@ -2,18 +2,18 @@ create table if not exists tracks(
     date varchar(12) not null,
     artist varchar(255) not null,
     album varchar(255) not null,
-    directory varchar(500) not null,
+    title varchar(255) not null,
+    trackbumber smallint 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 UNIQUE INDEX tracks_title_idx ON tracks (title);
 
 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);
+CREATE UNIQUE INDEX albums_dir_idx ON albums (album);