This may be just me being a stickler for order, but sometimes I start a new project using an old database where I have to delete a bunch of data. Some of that data includes member info. Now, while deleting members, if I add a new one, the member ID assigned to that member is based on the previously added/deleted member. So if the last member was ID 200, the new member is ID 201.
However, if I delete it all down to the original 4 members, Member ID still follows the last one when I add the 5th member!
So it's like, Member ID 1, 2, 3, 4, then 201. Which looks super super odd.
If I delete members & add a new one, is it possible to have their member ID to be consecutive to current member IDs, not the deleted?