On Thu, Dec 1, 2011 at 6:34 PM, William Lee wlee@wikia-inc.com wrote:
We propose expanding the metadata field into a new table. We propose the name image_metadata. It will have three columns: img_name, attribute (varchar) and value (varchar). It can be joined with Image on img_name.
Per convention this should probably read "file" instead of image, (like is already done with namespaces and the "filearchive" table). Anyway, that's just naming.
A major problem as mentioned before in this thread is a key. Right now files (both the files as an abstract thing or the versions) have a no unique key. All they have is a page title and a timestamp.
This is related to the License-integration project[1] (that name is a bit outdated, it started for license information, but it basically aiming at storing all kinds of file properties).
The first blocker bug would be https://bugzilla.wikimedia.org/show_bug.cgi?id=26741 (image/oldimage to filerevision).
And another one would be to make the file system even more like page/revisions. By giving implementing file ids and filerevision ids.
- Krinkle