miniBB ® miniBB®
miniBB Support Forums
 | Forums | Register | Reply | Search | Statistics | Manual |
The Other miniBB Support Forums / The Other /   

User IDs changing / what's happening to deleted IDs

Author MB
Guest
#1 | Posted: 16 Feb 2004 05:14 
I have just added a fourth user to my test forum. While the first three users have the IDs of 1, 2, 3 respectively, the fourth user has the ID of 10 instead of 5. Is this normal?

Perhaps this has something to do with the fact that upon a time I had a few more users on the test forum (they since been all remvoved though)?

Do user ID numbers adjust themselves to reflect changes after certain members have been deleted? For example, does Jack (ID#10) become ID#9 when Peter (current ID#9) is removed?

Thanks.

--MB

Author cakeman
Registered
#2 | Posted: 16 Feb 2004 11:31 
Do user ID numbers adjust themselves to reflect changes after certain members have been deleted? For example, does Jack (ID#10) become ID#9 when Peter (current ID#9) is removed?

Definitely not :)
ID has the proprety AUTO-INCREMENT in the DB: in fact, when you create a user, ID is incremented of 1 and affected to the last user registered. If the last user is deleted, ID value does'nt change.

fourth user has the ID of 10 instead of 5

That means that you created 10 users (the fourth users is in fact the user 10 ) but you deleted five users among this ten users.

Author MB
Guest
#3 | Posted: 16 Feb 2004 13:14 
Ah-hah, I see! Many thanks for your explanation, Cakeman.
Cheers,
MB

The Other miniBB Support Forums / The Other / User IDs changing / what's happening to deleted IDs Top

Your Reply Click this icon to move up to the quoted message

 Short link for this topic:

 ?
Only registered users are allowed to post here. Please, enter your username/password details upon posting a message, or register first.


Before posting, make sure your message is compliant with our forum posting rules. If not, it may be locked or deleted with no explanation.
 
miniBB Support Forums Powered by Forum Software miniBB ® Features  Requirements  Demo  Download  Showcase  Gallery of Arts
Compiler  Premium Extensions  Premium Support  License  Contacts
Get the Captcha add-on: protect your miniBB-forums from the automated spam and flood.
Captcha Addon for miniBB