On Sat, 29 Mar 2003, Thomas Corell wrote:
Yust another thing to ask, to avoid mistakes. I hope I got this right:
On the real server there exists for each language a database, in the creation scripts usually called wikidb. The php-scripts exists only one time (I remember Brion told me that not long ago) and there is some function which selects the right database. I think depending on the domain name or so. (I will find this in the near future, but it's not important for database design)
Mmm, not exactly. They all use the same base source, but they're duplicated in a series of directories. Each has various settings in LocalSettings.php different, such as language selection, name of database to use, the URL to use for self-links, etc.
The Apache webserver is configured with name-based virtual hosts to use this or that directory as the web root depending on the domain name used to access it (so thus the language / meta / wiktionary / test).
Are there any bad mistakes, I made in this statements?
Just because I ran over it: There was the idea of having a unique userid in all wikis. Login once, registerd everywhere ;) There is the hard way: everybody register again,
Ouch! :)
or the soft way: we design a 'master'-userid, and the users can 'attach' language specific UID's and Names to this 'master-UID'. (thats just an idea wandering around in my brain, may be impossible to implement ;)
My present master plan is that we'll reassign all user_ids. This will be an automatic process, for the most part: no one needs to know their user_id (the auto-incremented integer key), we just need to match up all the identical accounts, merge them into a central user database, and swap out all the numbers in the cur & old tables.
Everyone needs new login cookies at that point, of course, since it would run over all subdomains of .wikipedia.org, so no problem that the id is different.
However, there are two potential pitfalls: - People using different login _names_ on different wikis would have to settle on one.
- There might be some cases of duplicate names on different wikis which belong to different people. We can verify if they're the same by checking that passwords match, but some people may use different passwords, so we can't be 100% sure in that case.
Ok, I will download one of the database dumps tomorrow, after getting 3 to 4 hours of sleep ;)
'Night. :)
-- brion vibber (brion @ pobox.com)