Multiple User Tables

[Anon]

Hey,

I am creating a application where I need to keep all the users, no matter what. So, I have created 5 tables.

active_users
deleted_users
denied_users
expired_users
pending_users

All of which, have different status'. I am just wondering if this is the best and most efficient way of doing it. I am just thinking that many people will be using it, so I might as well keep the active users (obviously, the busiest) as clean as posible.

Any thoughts? Also, when moving an entire field, any ideas on the best way of MOVING those fields from table to table? (Any shortcuts). I mean, beyond just doing a select/insert/delete. Or a insert (with sub-select)/delete.

Any comments are appreciated,
-Travis

[Anon]

I would just have maybe one table with a field called "Status", which would equal either active, frozen (or deleted), denied, expired, or pending. However, I can see your idea of keeping everything clean, so if you do it that way I think you've got the right idea.

One problem, though, is that it will be a lot tougher to figure out what table the user is on to process the login... so I think you're better off with one table.

Ideally you would want to tell the user the status of his/her account, not just say they entered an invalid password, etc...

~Mark