When you destroy a profile picture from the command line, that picture
does not cause anymore a 404 error on your user page. So, you do not see
anymore this problem:
{F4303304}
Instead, you just see your exciting builtin image, fully operational.
This will be even more useful in a future when users could be able to delete
their own profile pictures (T15407), and this would happen in a safe way,
without causing any website damages.
This feature works thanks to the brand-new "Before-Destruction Engine",
described in T16079.
To find which users use a file, we first look at where the file is attached,
because in normal conditions this search is very efficient, even if you have
a billion users with a billion profile pictures.
As a last attempt, we look at the 'user' table. We may want an index in the
future here, but this query is so rare that we can avoid it (T16080).
Ref T15407
Ref T16079
Ref T16080
Closes T16074
Closes T16078