diff options
Diffstat (limited to 'backend/db')
| -rw-r--r-- | backend/db/models.go | 2 | ||||
| -rw-r--r-- | backend/db/query.sql.go | 6 |
2 files changed, 4 insertions, 4 deletions
diff --git a/backend/db/models.go b/backend/db/models.go index bc2010d..4eda2cc 100644 --- a/backend/db/models.go +++ b/backend/db/models.go @@ -19,7 +19,7 @@ type User struct { UserID int32 Username string DisplayUsername string - IconUrl pgtype.Text + IconPath pgtype.Text IsAdmin bool CreatedAt pgtype.Timestamp } diff --git a/backend/db/query.sql.go b/backend/db/query.sql.go index d5158b5..5c4f910 100644 --- a/backend/db/query.sql.go +++ b/backend/db/query.sql.go @@ -12,7 +12,7 @@ import ( ) const getUserAuthFromUsername = `-- name: GetUserAuthFromUsername :one -SELECT users.user_id, username, display_username, icon_url, is_admin, created_at, user_auth_id, user_auths.user_id, auth_type, password_hash FROM users +SELECT users.user_id, username, display_username, icon_path, is_admin, created_at, user_auth_id, user_auths.user_id, auth_type, password_hash FROM users JOIN user_auths ON users.user_id = user_auths.user_id WHERE users.username = $1 ` @@ -21,7 +21,7 @@ type GetUserAuthFromUsernameRow struct { UserID int32 Username string DisplayUsername string - IconUrl pgtype.Text + IconPath pgtype.Text IsAdmin bool CreatedAt pgtype.Timestamp UserAuthID int32 @@ -37,7 +37,7 @@ func (q *Queries) GetUserAuthFromUsername(ctx context.Context, username string) &i.UserID, &i.Username, &i.DisplayUsername, - &i.IconUrl, + &i.IconPath, &i.IsAdmin, &i.CreatedAt, &i.UserAuthID, |