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

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
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)
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: ---


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.