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)