From c2c39cc2756230c1de29d8065b8b320f2f084045 Mon Sep 17 00:00:00 2001
From: Thibaut Horel <thibaut.horel@gmail.com>
Date: Sat, 19 Nov 2016 17:35:07 -0500
Subject: Initial commit

---
 schema.sql | 25 +++++++++++++++++++++++++
 1 file changed, 25 insertions(+)
 create mode 100644 schema.sql

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
new file mode 100644
index 0000000..d087f58
--- /dev/null
+++ b/schema.sql
@@ -0,0 +1,25 @@
+CREATE TABLE users (
+    name string PRIMARY KEY,
+    password string
+);
+
+CREATE TABLE sessions (
+    user string,
+    token string PRIMARY KEY,
+    client string,
+    protocol string,
+    created int
+);
+
+CREATE TABLE scrobbles (
+	artist      string,
+	albumartist string,
+	trackname   string,
+	album       string,
+	tracknumber int,
+	duration    int,
+	time        int,
+	chosen      bool,
+	mbid        string,
+	session     string
+);
-- 
cgit v1.2.3-70-g09d2

