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, 2 insertions, 1 deletions

diff --git a/src/invite/repo.rs b/src/invite/repo.rs
index 7cfa18e..934b0ce 100644
--- a/src/invite/repo.rs
+++ b/src/invite/repo.rs
@@ -71,10 +71,11 @@ impl Invites<'_> {
                 select
                     invite.id as "invite_id: Id",
                     issuer.id as "issuer_id: user::Id",
-                    issuer.display_name as "issuer_name: nfc::String",
+                    issuer_login.display_name as "issuer_name: nfc::String",
                     invite.issued_at as "invite_issued_at: DateTime"
                 from invite
                 join user as issuer on (invite.issuer = issuer.id)
+                join login as issuer_login on (issuer.id = issuer_login.id)
                 where invite.id = $1
             "#,
             invite,