On Thu, Dec 1, 2011 at 6:34 PM, William Lee <w...@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 _______________________________________________ Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l