Update schema

string type doesn't exist in sqlite

1 files changed, 13 insertions, 13 deletions

diff --git a/schema.sql b/schema.sql
index d087f58..72211ee 100644
--- a/schema.sql
+++ b/schema.sql
@@ -1,25 +1,25 @@
 CREATE TABLE users (
-    name string PRIMARY KEY,
-    password string
+    name text PRIMARY KEY,
+    password text
 );
 
 CREATE TABLE sessions (
-    user string,
-    token string PRIMARY KEY,
-    client string,
-    protocol string,
-    created int
+    user text,
+    key text PRIMARY KEY,
+    client text,
+    protocol text,
+    created int DEFAULT (strftime('%s', 'now'))
 );
 
 CREATE TABLE scrobbles (
-	artist      string,
-	albumartist string,
-	trackname   string,
-	album       string,
+	artist      text,
+	albumartist text,
+	trackname   text,
+	album       text,
 	tracknumber int,
 	duration    int,
 	time        int,
 	chosen      bool,
-	mbid        string,
-	session     string
+	mbid        text,
+	session     text
 );