added create_rating.sql file

1 files changed, 17 insertions, 0 deletions

diff --git a/create_rating.sql b/create_rating.sql
new file mode 100644
index 0000000..67c00a3
--- /dev/null
+++ b/create_rating.sql
@@ -0,0 +1,17 @@
+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,
+    rating smallint not null
+);
+create index if not exists track_ratings_idx ON tracks (rating);
+
+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);