On Thu, Dec 1, 2011 at 6:34 PM, William Lee <wlee(a)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
[1]
http://www.mediawiki.org/wiki/License_integration