Re: [support] User ID in users table

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