Initial commit

1 files changed, 25 insertions, 0 deletions

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
+);