diff options
| -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, |