...
- SELECT * FROM scaled_800x600 WHERE original_id = '' ......
SELECT mime FROM originals WHERE original_id = '' Brauchen wir nicht, da hier immer ein image/jpeg zurückkommt.
GET /binary/logs/{context}
...
Löschen nicht mehr benötigter Originals:
(asynchron, daher nicht zeitkritisch)
- SELECT original_id FROM originals
- SELECT reference_id FROM binary_refs WHERE original_id = ''
- DELETE FROM url WHERE original_id = ''
- DELETE FROM originals WHERE original_id = ''
- DELETE FROM originals_data WHERE original_id = ''
- DELETE FROM scaled_... WHERE original_id = ''
...