| 1 | -- An uploaded image of a project's production (src/production-image.ts): |
| 2 | -- the SHA-256 of its bytes, kept in the avatars namespace under |
| 3 | -- `production/<sha256>` and served from the usercontent origin; the type |
| 4 | -- read from its bytes; and whether it is shown instead of a screenshot. |
| 5 | ALTER TABLE projects ADD COLUMN production_image TEXT; |
| 6 | ALTER TABLE projects ADD COLUMN production_image_type TEXT; |
| 7 | ALTER TABLE projects ADD COLUMN production_image_preferred INTEGER NOT NULL DEFAULT 0; |