03-24-2008, 09:40 PM
When the admin delete an user the UID not decrease... 
Sorry for bad english
Sorry for bad english
03-24-2008, 09:43 PM
There isn't any need to decrease the uid.
03-24-2008, 09:51 PM
MyBB is perfect!
03-26-2008, 12:50 AM
When you delete a user, the fact that the uid keeps counting doesn't look too good if you mass-deleted spambot accounts.
03-26-2008, 01:00 AM
This is not how DBMS systems work. The auto increment fields will always go up, and never back down. This is common across all database systems, not just MySQL.
There are many reasons for this, including:
1) Speed - a delete simply removes the entry from the table. If IDs had to go down, the DBMS system would have to keep refreshing potentially thousands or millions of rows each time.
2) Consistency - for example, if something linked to a UID which no longer exists, it simply won't exist any more. An ID is meant to be unique, not something that's overwritten. For example, if we have a user with UID=10, who got deleted. In future, if someone tried to view the profile with UID=10, they'll see that the user doesn't exist anymore, rather than get some random other user.
There are many reasons for this, including:
1) Speed - a delete simply removes the entry from the table. If IDs had to go down, the DBMS system would have to keep refreshing potentially thousands or millions of rows each time.
2) Consistency - for example, if something linked to a UID which no longer exists, it simply won't exist any more. An ID is meant to be unique, not something that's overwritten. For example, if we have a user with UID=10, who got deleted. In future, if someone tried to view the profile with UID=10, they'll see that the user doesn't exist anymore, rather than get some random other user.