Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

...

DELETE /binaries/context/{context}

SELECT reference_id FROM binary_refs WHERE context = ''
DELETE FROM log WHERE reference_id = ''
DELETE FROM binary_refs WHERE context = ''

DELETE /binaries/reference/{reference_id}

DELETE FROM binary_refs WHERE reference_id = ''
DELETE FROM log WHERE reference_id = ''

GET /binary/AB123CD

...

SELECT reference_id FROM binary_refs WHERE context = ''
SELECT message FROM logs WHERE reference_id = ''

Löschen nicht mehr benötigter Originals:

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 = ''
DLETE FROM scaled_... WHERE original_id = ''

Binary References (binary_refs)

...