On 26/05/05, Brion Vibber brion@pobox.com wrote:
I've gone ahead and made another change to the schema which I'd originally passed over.
The links and brokenlinks tables are now merged to a single pagelinks table, which records the namespace+title key pair of target links rather than the page ID or the prefixed title.
Just a quick suggestion (once again) that the opportunity is taken to merge in the categorylinks, imagelinks, etc tables as well (see comments on bug 1065, various posts in the mail archive, etc) while things are being changed (i.e. before 1.5 goes stable). If nothing else, keeping the schema relatively stable (as opposed to lots of little changes in future releases) ought to minimise the pain to users while big Wikimedia databases are upgraded. I know, "so do it yourself", but I just thought I'd keep it in the general consciousness that this needs doing...