Adding a stable way of adding whitelisted "orphaned" uploads in a plugin

[zogstrip (Régis HANOL)]

@eviltrout

Is it unsafe to delete an upload if a user removes it from their profile, because the same upload sha1 could be used elsewhere in the app? If that’s the case I think @sam’s suggestion of an UploadReference table is a good solution.

That’s exactly why we need the UploadReference table

@sam

I think this is work I would prefer the team here to take, it is very fiddly.

I actually think that’s a very good task to learn more about Discourse internals. Might be a good task for @cvx, starting early October. We’ll do some pair programming to get things started and properly split into several “small” tasks.