On 08/01/11 17:29, Diederik van Liere wrote: > I am wondering whether the Mediawiki db contains a foreignkey > relationship between a main namespace article and the associated talk > page (if present).
We do not have any foreign key in the database schema. Constraints are handled at the application level (read: Mediawiki). > Having this information would greatly simplify analytic projects to > monitor editor behaviour and understanding revert behaviour (among > other topics). > > Currently, I am manually matching these two sets of pages by matching titles. That is how you have to do it. Finding a title with the same name but in the associated talk namespace. Core namespace are given a number between 0 and 99, by convention odd ones are the talk pages. > I have two questions: > 1) If this foreignkey does not exist, would it be worthwhile to create it? I do not think we want to add database constraints. It is probably a good thing but I am almost sure it will break the software in a lot of different and "interesting" ways. > 2) If this foreignkey does exist, what would it take to expose this in > the XML dumps? Maybe we can change the XML format. Adding a new field indicating there is a talk page for the given page should be trivial. -- Ashar Voultoiz _______________________________________________ Wikitech-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikitech-l
