On Wed, Apr 2, 2008 at 2:41 AM, Simetrical
<Simetrical+wikilist(a)gmail.com> wrote:
1) Change cl_to to two columns: cl_to_id and
cl_final_id. cl_to_id
would contain the id of the category that it's actually included in,
whereas cl_final_id would be the id of the category it's included in
once all redirects are resolved.
2) When querying what category something is in for the purposes of
category pages, etc., use cl_final_id, not cl_to_id.
Wouldn't it be easier for upgrading and backwards compatibility to
keep the current cl_to field which should indicate the category that
is indicated in wikitext, and add a cl_id field, which indicates the
real category that is being pointed to.
Bryan