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