Split the `user` table into an authentication portion and a chat portion.

We'll be building separate entities around this in future commits, to better separate the authentication data (non-synchronized and indeed "not public") from the chat data (synchronized and public).

1 files changed, 9 insertions, 8 deletions

diff --git a/src/token/repo/token.rs b/src/token/repo/token.rs
index 7ac4ac5..5368fee 100644
--- a/src/token/repo/token.rs
+++ b/src/token/repo/token.rs
@@ -37,7 +37,7 @@ impl Tokens<'_> {
         let secret = sqlx::query_scalar!(
             r#"
                 insert
-                into token (id, secret, user, issued_at, last_used_at)
+                into token (id, secret, login, issued_at, last_used_at)
                 values ($1, $2, $3, $4, $4)
                 returning secret as "secret!: Secret"
             "#,
@@ -91,7 +91,7 @@ impl Tokens<'_> {
             r#"
                 delete
                 from token
-                where user = $1
+                where login = $1
                 returning id as "id: Id"
             "#,
             user,
@@ -139,12 +139,12 @@ impl Tokens<'_> {
                 where secret = $2
                 returning
                     id as "token: Id",
-                    user as "user: user::Id"
+                    login as "login: user::Id"
             "#,
             used_at,
             secret,
         )
-        .map(|row| (row.token, row.user))
+        .map(|row| (row.token, row.login))
         .fetch_one(&mut *self.0)
         .await?;
 
@@ -152,11 +152,12 @@ impl Tokens<'_> {
             r#"
                 select
                     id as "id: user::Id",
-                    display_name as "display_name: String",
-                    canonical_name as "canonical_name: String",
-                    created_sequence as "created_sequence: Sequence",
-                    created_at as "created_at: DateTime"
+                    login.display_name as "display_name: String",
+                    login.canonical_name as "canonical_name: String",
+                    user.created_sequence as "created_sequence: Sequence",
+                    user.created_at as "created_at: DateTime"
                 from user
+                join login using (id)
                 where id = $1
             "#,
             user,