From OpenSimulator

Jump to: navigation, search

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:

Field Type Collation Attributes Null Default Extra
PrincipalID char(36) utf8_general_ci No None
ScopeID char(36) utf8_general_ci No 00000000-0000-0000-0000-000000000000
FirstName varchar(64) utf8_general_ci No None
LastName varchar(64) utf8_general_ci No None
Email varchar(64) utf8_general_ci Yes NULL
ServiceURLs text utf8_general_ci Yes NULL
Created int(11) Yes NULL
UserLevel int(11) No 0
UserFlags int(11) No 0
UserTitle varchar(64) utf8_general_ci No
active int(11) No 1

      (back to Database Documentation)

UserAccounts Fields

The UUID of an avatar
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
The first name of the avatar
The last name of the avatar
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
A unix timestamp when the avatar account was created
The value is 0 for normal users. Values of 200 and up are for grid gods.
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)
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.
Indicates if the user account is active.
NOTE: This field was added in 0.8.0-post-fixes.

      (back to Database Documentation)

Personal tools
About This Wiki