-- Profile fields shown on the user page: pronouns, a bio, a website and
-- location, and named social handles. `avatar_mime` records an uploaded
-- avatar's content type; NULL means fall back to a generated identicon. The
-- avatar bytes live on disk under `{storage.data_dir}/avatars/{id}`, keeping
-- the schema portable (no BLOB/BYTEA divergence).
ALTER TABLE users ADD COLUMN pronouns        TEXT;
ALTER TABLE users ADD COLUMN bio             TEXT;
ALTER TABLE users ADD COLUMN website         TEXT;
ALTER TABLE users ADD COLUMN location        TEXT;
ALTER TABLE users ADD COLUMN social_github   TEXT;
ALTER TABLE users ADD COLUMN social_mastodon TEXT;
ALTER TABLE users ADD COLUMN avatar_mime     TEXT;