[support] User ID in users table

[Earnie Boyd]

On Thu, Nov 29, 2012 at 9:38 PM, Kamal Palei wrote:
> Hi Folks
> In our development environment I created few users after quite long.  I see
> the user ids are not increasing monotonically.
> I had around 5/6 users in development environment. Suddenly the UID
> allocated to new user is 26. Next user , UID allocated is 33.
>
> Can somebody tell how the UID is decided, I checked the table "users", there
> uid is not auto_increment one.
> On what basis UID is decided?

It is decided by the rules of you DB engine.  The fields is an
auto-incremented field.  If you have gaps in the order it is possible
to see this type of sequencing as the gaps are used first.

--
Earnie
-- https://sites.google.com/site/earnieboyd