Okay, I ran a little script to check over the user
tables and spit out
names that are registered on multiple wikis which don't all match in
either e-mail address or password. I haven't yet checked any of the
accounts for activity, nor have I visually checked the e-mail addresses
for signs of similarity, nor their user pages. Certainly there are
plenty on the list that do belong to the same person. :)
Not bad, but still not that good, I still would like to propose my system
since its easy to implement, it centralizes usernames into one table. and it
allows us to implement the wikimedia login system without disrupting service
or breaking anything, all it would take is a couple of changes to the user
login code. the basics are simple, the rest, like the alias system can be
worked in at a later time...
I have since changed my idea bit though, I like timwi's idea of using the
LJ-style userprop & userproplist tables. I reallythink that the user table
should have as little columns as possible, say something like "e-mail,
username, userId, password hash, registration date" and thats it. im even
sketchy about registration date.