Re: Table structure changes

[Jason Pincin <jpincin@ashtech.net>]

This message got postponed, don't know if you guys got it or not:



> Last login date/time,
> Number logins,
> Number articles submitted,
> other statistics???
> to the users table?  I'd be OK with it.

Number of articles submitted, # of comments, etc. etc. can all be determined by
doing clauses like "select UserID from ArticleUserXref where UserID = $CURUSER"

...and then doing a record count.

I'll add # of logins to the user table.

> There may be a few other table enhancements we could make as well (such
> as making Handle and E-mail unique fields).

Done (unique handles/emailaddr's).



> But we really do need to decide when the table will be final.  Changing
> it after we go live will be a pain.  I say we allow a few weeks for
> additional ideas.  We'll probably get ideas for enhancements as we do
> the coding.
---end quoted text---