https://bugzilla.wikimedia.org/show_bug.cgi?id=23741
--- Comment #3 from [email protected] 2010-06-01 13:11:54 UTC --- I don't have a wiki farm that I use for production purposes; I just have test wiki farms, one of which I used to verify that this collision can occur. As a side note, it would seem that user_properties is shared by default when you share databases, because I didn't explicitly set that table to be shared. I would think that users would prefer to have certain preferences set globally, especially when large checklists are involved, as might be the case with interwiki search and watchlist options (see bug 3525). I thought about having a big two-dimensional checklist with preferences on one axis and wikis on the other, and "select/deselect all" options for each row and column, but I think on large wiki farms (e.g. Wikimedia) it would be too big to be manageable. In order to help future-proof the database, perhaps we should just add a "wiki" field to all the tables, so that tables can be more readily shared without causing a bunch of collisions. In cases where that field should be applicable globally, it could be set to NULL or "*" as you suggest. There is a lot more that needs to be done as far as cross-wiki integration is concerned, and I think that this will create flexibility to implement such functionality without having to create new global tables and/or global databases. True, the field would be useless in isolated wikis, but one never knows when one will want to merge the wiki into a farm, e.g. to take a monolingual project multilingual. There might be some benefit, for instance, in having a wiki field for the page table, so that templates could be shared across wikis by setting a "*" value for that field. Changing the page on one wiki would change it on them all. Although maybe an even better option would be put a foreign key in that field leading to another table, and thereby provide arrays of wikis to which a given setting applies. E.g., a preference, page, or whatever might apply only to some wikis but not others, rather being global. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
