From f154ae1ec88146017abf3de9d14d119facb5fc4c Mon Sep 17 00:00:00 2001
From: Thibaut Horel <thibaut.horel@gmail.com>
Date: Sat, 3 Jun 2017 18:00:51 -0400
Subject: Basic web app

---
 schema.sql | 35 +++++++++++++++++++++++++----------
 1 file changed, 25 insertions(+), 10 deletions(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index 72211ee..fb13dc7 100644
--- a/schema.sql
+++ b/schema.sql
@@ -1,25 +1,40 @@
-CREATE TABLE users (
-    name text PRIMARY KEY,
-    password text
-);
-
-CREATE TABLE sessions (
-    user text,
+CREATE TABLE IF NOT EXISTS scrobbling_sessions (
+	lfm_name text,
     key text PRIMARY KEY,
     client text,
     protocol text,
-    created int DEFAULT (strftime('%s', 'now'))
+	created timestamptz DEFAULT current_timestamp
 );
 
-CREATE TABLE scrobbles (
+CREATE TABLE IF NOT EXISTS scrobbles (
 	artist      text,
 	albumartist text,
 	trackname   text,
 	album       text,
 	tracknumber int,
 	duration    int,
-	time        int,
+	time        timestamptz,
 	chosen      bool,
 	mbid        text,
 	session     text
 );
+
+CREATE TABLE IF NOT EXISTS users (
+	user_id SERIAL PRIMARY KEY,
+	type text,
+	op_id text,
+	name text,
+	email text,
+	lfm_name text,
+	lfm_password text
+);
+
+CREATE TABLE IF NOT EXISTS user_sessions (
+	id text PRIMARY KEY,
+	user_id integer REFERENCES users
+);
+
+CREATE TABLE IF NOT EXISTS songs (
+	mbid text PRIMARY KEY,
+	image text
+);
-- 
cgit v1.2.3-70-g09d2

