From f154ae1ec88146017abf3de9d14d119facb5fc4c Mon Sep 17 00:00:00 2001 From: Thibaut Horel 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