UserAccounts

The UserAccounts table contains a list of avatar accounts      (back to Database Documentation)

UserAccounts Table Structure
The structure of the UserAccounts table as of v0.8.0-post-fixes is as follows:

(back to Database Documentation)

UserAccounts Fields

 * PrincipalID
 * The UUID of an avatar

ScopeID
 * Used if several Grids use this database, grid 1 has a scope ID of 00000000-0000-0000-0000-000000000000 and Grid two would have 00000000-0000-0000-0000-000000000001 or similar setup, default is 00000000-0000-0000-0000-000000000000

FirstName
 * The first name of the avatar

LastName
 * The last name of the avatar

Email
 * A real world email address that can be used to contact the person behind the avatar and that can be used when forwarding offline instant messages

ServiceURLs
 * unknown

Created
 * A unix timestamp when the avatar account was created

UserLevel
 * The value is 0 for normal users. Values of 200 and up are for grid gods.

UserFlags
 * This field consists of two different values. Bit 0-7 are a field of bit flags that define certain characteristics of the user. Bits 8-11 are the user account level, Bits 12-15 are not used.


 * Account Types:
 * 0 = Normal user (Resident)
 * 1 = Trial Member
 * 2 = Charter Member
 * 3 = Linden Labs Employee


 * Bit flags:
 * 1 (0x01) Allow external services like Google to index the user profile
 * 2 (0x02) The content of the profile is "mature" and should not appear on web pages children can access
 * 4 (0x04) The avatar has provided payment info and is therefore identified
 * 8 (0x08) The avatar has made at least one successful payment using their payment info
 * 16 (0x10) The avatar is online (This flag has no effect in the database, it is dynamically managed)
 * 32 (0x20) The avatar has been age verified using some external service (like LL's Aristotle)

UserTitle
 * The value of this field appears in a users Profile in the box under "Account:". It can be used to show text for grid staff such as "Mentor", "Tech. Support", "Grid Owner", or other special avatars in a grid.

active
 * Indicates if the user account is active.
 * NOTE: This field was added in 0.8.0-post-fixes.

(back to Database Documentation)