Delete a memory

Permanently deletes a memory. This is a hard delete - the memory cannot be recovered.

Users can only delete memories that are about them (subject_id = user).