From 8d6525e381f23b2335dc2b86282baf2147dd900c Mon Sep 17 00:00:00 2001
From: Guillaume Horel <guillaume.horel@gmail.com>
Date: Sun, 11 Dec 2016 18:54:26 -0500
Subject: Update schema

string type doesn't exist in sqlite
---
 schema.sql | 26 +++++++++++++-------------
 1 file changed, 13 insertions(+), 13 deletions(-)

(limited to 'schema.sql')

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
 );
-- 
cgit v1.2.3-70-g09d2