[support] User ID in users table

[Jamie Holly]

This isn't the case in D7.  UID is assigned by a SELECT MAX(uid) FROM 
{users}. Check user.module line 571.

Jamie Holly
http://www.intoxination.net
http://www.hollyit.net

On 11/30/2012 8:13 AM, Earnie Boyd wrote:
> 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