Use user_id instead of lfm_name as much as possible

1 files changed, 2 insertions, 2 deletions

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 (