iu
96268ee16c
Move physical file facts out of the photos table into an objects ledger:
- objects / photo_objects / variant_jobs tables (migration 000008)
- drop storage_key/thumb_key/preview_key/size/width/height/mime_type from
photos (migration 000009); they are derived via joins to the original object
- album-free storage keys: objects/{id}/{role}.{ext}
- explicit GC via pending/ready/deleting states; objects deleted only when no
photo references them
- background worker drives variant generation (durable variant_jobs) and GC
- copy/move are metadata-only; storage objects are shared between photos
- remove unused storage.DeletePrefix
Non-destructive to the external JSON API: size/dimensions/mime and URLs are
still returned, just sourced from the object layer.
OpenSpec change: media-object-layer
11 lines
553 B
SQL
11 lines
553 B
SQL
-- Physical facts move to the objects table; photos keeps only membership and
|
|
-- presentation data. size/width/height/mime_type are derived from the original
|
|
-- object via photo_objects + objects.
|
|
ALTER TABLE photos DROP COLUMN IF EXISTS storage_key;
|
|
ALTER TABLE photos DROP COLUMN IF EXISTS thumb_key;
|
|
ALTER TABLE photos DROP COLUMN IF EXISTS preview_key;
|
|
ALTER TABLE photos DROP COLUMN IF EXISTS size;
|
|
ALTER TABLE photos DROP COLUMN IF EXISTS width;
|
|
ALTER TABLE photos DROP COLUMN IF EXISTS height;
|
|
ALTER TABLE photos DROP COLUMN IF EXISTS mime_type;
|