small fixes

2 files changed, 5 insertions, 1 deletions

diff --git a/clerk b/clerk
index a24945a..eddc6f4 100755
--- a/clerk
+++ b/clerk
@@ -198,6 +198,10 @@ updateDB () {
                     title=${title//\'\\\'}
                     rating=${rating//\'/\\\'}
                     echo "$title"
+                    echo "artist=${artist}"
+                    echo "title=${title}"
+                    echo "date=${date}"
+                    echo "rating=${rating}"
                     sqlite3 ../ratings.db "insert or replace into tracks (date, artist, album, title, tracknumber, rating) values ('$date', '$artist', '$album', '$title', '$tracknumber', '$rating')"
                 done
             fi
diff --git a/create_rating.sql b/create_rating.sql
index 470997f..8cb60ee 100644
--- a/create_rating.sql
+++ b/create_rating.sql
@@ -3,7 +3,7 @@ create table if not exists tracks(
     artist varchar(255) not null,
     album varchar(255) not null,
     title varchar(255) not null,
-    trackbumber smallint not null,
+    tracknumber smallint not null,
     rating smallint not null
 );
 create index if not exists track_ratings_idx ON tracks (rating);