OXYGENHUB
◆ close-proposal-140 oxygenhub / crates / hub / migrations / 0014_pictures.sql
278 B · SQL · last changed Uploaded profile pictures and organisation logos: PNG, JPEG or WebP checked by content, cropped, scaled and re-encoded before storing, served at /avatar/{name} with the identicon as fallback, removable 1 month ago source blame history raw
a160b98f Andy McCall ↶ 1 
-- Uploaded pictures (hub spec §6.3): `png:<hash>` or `jpeg:<hash>` of the
2 
-- re-encoded file under <data>/avatars/, empty for the identicon.
3 
ALTER TABLE accounts ADD COLUMN avatar TEXT NOT NULL DEFAULT '';
4 
ALTER TABLE organisations ADD COLUMN avatar TEXT NOT NULL DEFAULT '';