UserAccounts
From OpenSimulator
The UserAccounts table contains a list of avatar accounts (back to Database Documentation)
Avatars Table Structure
The structure of the Avatars 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 | ||
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) |
UserAccounts Fields
- PrincipalID
- The UUID of an avatar
ScopeID
- unknown
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
- unknown
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.