diff options
author | dakkar <dakkar@thenautilus.net> | 2018-01-02 17:44:58 +0000 |
---|---|---|
committer | dakkar <dakkar@thenautilus.net> | 2018-01-02 17:44:58 +0000 |
commit | 5cc9d55dab54df9463124a5faea988a55ca0b072 (patch) | |
tree | ea21f68d507bfe96d3c820291b49e27e9aefccbc | |
parent | make MusicFile work with non-absolute paths (diff) | |
download | Ultramarine-5cc9d55dab54df9463124a5faea988a55ca0b072.tar.gz Ultramarine-5cc9d55dab54df9463124a5faea988a55ca0b072.tar.bz2 Ultramarine-5cc9d55dab54df9463124a5faea988a55ca0b072.zip |
give songs an id
it's needed for the api
-rw-r--r-- | lib/Ultramarine/Model/DB.pm6 | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/lib/Ultramarine/Model/DB.pm6 b/lib/Ultramarine/Model/DB.pm6 index 9673d8e..572d35c 100644 --- a/lib/Ultramarine/Model/DB.pm6 +++ b/lib/Ultramarine/Model/DB.pm6 @@ -44,7 +44,8 @@ class Ultramarine::Model::DB { $dbh.do(q:to/END/); CREATE TABLE songs ( - path TEXT NOT NULL PRIMARY KEY, + id INTEGER PRIMARY KEY, + path TEXT UNIQUE NOT NULL, mtime INTEGER NOT NULL, directory_id INTEGER, album_id INTEGER, |