Versions Compared

Key

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

Queries:

PUT /binaries (url, context, mime)

  • SELECT original_id FROM urls WHERE url = ''

DELETE /binaries/context/{context}

  • DELETE FROM binary_refs WHERE context = ''

DELETE /binaries/reference/{reference_id}

  • DELETE FROM binary_refs WHERE reference_id = ''

GET /

  • SELECT original_id FROM binary_refs WHERE reference_id = ''
  • SELECT * FROM originals_data WHERE original_id = ''
  • SELECT * FROM scaled_800x600 WHERE original_id = '' ......
  • SELECT mime FROM originals WHERE original_id = ''
  • SELECT reference_id FROM binary_refs WHERE context = ''
  • SELECT message FROM logs WHERE reference_id = ''

...

Binary References (binary_refs)

...