Since Lee added a namespace field, I think now is the time to brainstorm and see if any other changes to the database scheme are needed or desirable.

First, I think the cur_namespace should be indexed, since we are using it for finding articles. Should old also get a an old_namespace, or do you intend to store the namespace as part of the title? Also, I was wondering about the cur_title/cur_ind_title situation. Would it be possible to declare cur_title not as binary and combine the two? Should we store the passwords in user in encrypted form? (Right now, any sysop with mysql access can read all passwords.) Maybe we should store the user_rights as a bitstring?

The tables linked, unlinked and ipblocks should have PACK_KEYS=1 (makes reads faster and updates slower). Any other possible fields for site_stats? Maybe a date field?

Axel