From 53841da448baa28067bab046198757954cebc4a1 Mon Sep 17 00:00:00 2001
From: Thibaut Horel <thibaut.horel@gmail.com>
Date: Tue, 6 Jun 2017 19:20:09 -0400
Subject: Use user_id instead of lfm_name as much as possible

---
 schema.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'schema.sql')

diff --git a/schema.sql b/schema.sql
index 475c46d..f875137 100644
--- a/schema.sql
+++ b/schema.sql
@@ -11,7 +11,7 @@ CREATE TABLE IF NOT EXISTS users (
 
 CREATE TABLE IF NOT EXISTS scrobbling_sessions (
     session_key text PRIMARY KEY,
-	lfm_name text REFERENCES users(lfm_name),
+	user_id int REFERENCES users,
     client text,
 	client_version text,
     protocol text,
@@ -29,7 +29,7 @@ CREATE TABLE IF NOT EXISTS scrobbles (
 	mbid text,
 	mbid_computed text,
 	session_key text REFERENCES scrobbling_sessions,
-	lfm_name text REFERENCES users(lfm_name)
+	user_id int REFERENCES users
 );
 
 CREATE TABLE IF NOT EXISTS user_sessions (
-- 
cgit v1.2.3-70-g09d2