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