Last modified: 2011-11-25 07:16:53 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T15579, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 13579 - Categorylinks table should use category ID rather than category name in cl_to field
Categorylinks table should use category ID rather than category name in cl_to...
Status: NEW
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.13.x
All All
: Low enhancement (vote)
: ---
Assigned To: Nobody - You can work on this!
: schema-change
Depends on:
Blocks: 13326
  Show dependency treegraph
 
Reported: 2008-04-01 18:25 UTC by Roan Kattouw
Modified: 2011-11-25 07:16 UTC (History)
4 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Roan Kattouw 2008-04-01 18:25:55 UTC
Rather than containing the category's name, the cl_to field should contain the category ID as defined in the category table. This would make moving categories (GSoC project) much easier and doesn't store the category name in two places.

BTW, has the category table been built on WMF wikis yet?
Comment 1 Aryeh Gregor (not reading bugmail, please e-mail directly) 2008-04-01 21:34:12 UTC
Yes, it has, long ago.  A major reason for this change would be a much smaller (therefore faster) categorylinks table.
Comment 2 Brion Vibber 2008-04-01 22:27:50 UTC
The link tables specify text rather than IDs for rename safety... the links are created by text in the article (and any templates it uses, and any parser functions it calls, etc), which would not be changed by any alteration to the target page.

Things get ugly when you have to try to figure out how to go back and change texts. :)
Comment 3 Aryeh Gregor (not reading bugmail, please e-mail directly) 2008-04-02 00:50:23 UTC
Conveniently, categories can't be renamed, so that's not a big issue at present.  ;)  Any implementation of this big a change should wait until an implementation of category redirects/renaming, which could easily require changes to categorylinks too.  It would be fairly annoying to change the schema in such a major way *twice*, not just for whoever does the alters but also for extension authors, etc.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links