diff options
| -rw-r--r-- | backend/db/models.go | 2 | ||||
| -rw-r--r-- | backend/db/query.sql.go | 6 | ||||
| -rw-r--r-- | backend/schema.sql | 2 |
3 files changed, 5 insertions, 5 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, diff --git a/backend/schema.sql b/backend/schema.sql index 6a2db2d..999d628 100644 --- a/backend/schema.sql +++ b/backend/schema.sql @@ -2,7 +2,7 @@ CREATE TABLE users ( user_id SERIAL PRIMARY KEY, username VARCHAR(64) NOT NULL UNIQUE, display_username VARCHAR(64) NOT NULL, - icon_url VARCHAR(255), + icon_path VARCHAR(255), is_admin BOOLEAN NOT NULL, created_at TIMESTAMP NOT NULL DEFAULT NOW() ); |