Lightning wrote in part:
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.
Actually, even e-mail isn't central to our user management.
Quite a few users have no e-mail address -- none is required.
I say "userId, username, password hash" -- that identifies the user.
The rest -- even e-mail -- is for specific tasks of one sort or another,
the material for userproplist.
-- Toby