UserAccounts

From OpenSimulator

Revision as of 17:43, 1 April 2016 by Kcozens (Talk | contribs)

Jump to: navigation, search


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
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)



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.


active
Indicates if the user account is active.




      (back to Database Documentation)

Personal tools
General
About This Wiki