hmm, that’s a really good question.
I think it’s in wp_postMeta with keys of “_wp_attached_file” and “_wp_attachment_metadata” (where “wp_” is your table prefix)
Attachments (files you upload through the inline uploader) are actually saved as posts. The file is saved off to the normal location, of course, but a new entry is created in the posts table with all the information about this attachment. The Description is stored as the post_content. These posts have a post_status of “attachment” instead of the more normal “publish” and such.
Look at the wp_insert_attachment() function for details on where and how all this stuff is saved. Also look at inline-uploading.php which is the script that the file is actually uploaded to and which handles the processing of the file. Or just do a SELECT * FROM wp_posts WHERE post_status = “attachment”; and look at what you get back. These attachments do have the author name and such, as well as the filename, so finding which attachments any particular author uploaded should be easy enough there.
So Otto, what’s the stuff I found? Related meta or was I completely off base?
_wp_attached_file holds the filename of the file in question, and it is metadata that is actually linked to this fake post.
_wp_attachment_metadata is only there for image files that you upload, appearantly. It is also linked to this fake post, and it appears to be an array holding image related information. Width, height, location of the thumbnail image, a thing called “hwstring_small” which appears to have the width and height of the thumbnail image, etc…
