From 5cc9d55dab54df9463124a5faea988a55ca0b072 Mon Sep 17 00:00:00 2001
From: dakkar <dakkar@thenautilus.net>
Date: Tue, 2 Jan 2018 17:44:58 +0000
Subject: give songs an id

it's needed for the api
---
 lib/Ultramarine/Model/DB.pm6 | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

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,
-- 
cgit v1.2.3