Skip to:
Content
Pages
Categories
Search
Top
Bottom

Why aren’t user ids recycled after deleting users?


  • learntodesign
    Participant

    @learntodesign

    As the topic states, is there a specific reason user_ids aren’t recycled following deleting users? For example if I delete a user with id 84, the next user that is created is 85, not 84 again.

Viewing 5 replies - 1 through 5 (of 5 total)

  • Venutius
    Moderator

    @venutius

    I think it’s because of the way databases work, the database is set to auto-increment, there’s not a use deleted mode that I’m aware of. The user id is the databases auto-increment unique key.


    learntodesign
    Participant

    @learntodesign

    I think that would make more sense if the user deleted has a smaller user id than the largest one that currently exists. However even if I delete the user with the largest member id (integer), it still increments from the deleted id


    Venutius
    Moderator

    @venutius

    I still think it’s the database that is dishing out the unique keys so it is what’s controlling the user id’s not WordPress itself. BuddyPress just uses the WordPress User Id.


    learntodesign
    Participant

    @learntodesign

    Yeah youre right. It seems more like a mysql issue. However I still appreciate any on any opinions whether it would be not advised/smart to recycle ids.


    learntodesign
    Participant

    @learntodesign

    This can be closed. Thx @Venutius

Viewing 5 replies - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.
Skip to toolbar