UserAccounts

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
m (Adjusted spacing between sections of field details)
m (Changed colour of table headers and alternate lines in Table Structure table. Fixed C&P error.)
Line 7: Line 7:
 
<br />
 
<br />
  
== Avatars Table Structure ==
+
== UserAccounts Table Structure ==
  
The structure of the Avatars table as of v0.8.0-post-fixes is as follows:
+
The structure of the UserAccounts table as of v0.8.0-post-fixes is as follows:
 
<br />
 
<br />
 
{| style="border:1px solid #ccc;"
 
{| style="border:1px solid #ccc;"
|- style="background:#eef;"
+
|- style="background:#cce;"
 
! Field
 
! Field
 
! Type
 
! Type
Line 22: Line 22:
 
|-
 
|-
 
| '''[[#principalID|PrincipalID]]''' || char(36) || utf8_general_ci ||  || No || ''None'' ||
 
| '''[[#principalID|PrincipalID]]''' || char(36) || utf8_general_ci ||  || No || ''None'' ||
|-
+
|- style="background:#eee;"
 
|'''[[#scope|ScopeID]]''' || char(36) || utf8_general_ci || || No || 00000000-0000-0000-0000-000000000000 ||  
 
|'''[[#scope|ScopeID]]''' || char(36) || utf8_general_ci || || No || 00000000-0000-0000-0000-000000000000 ||  
 
|-
 
|-
 
|'''[[#firstName|FirstName]]''' || varchar(64) || utf8_general_ci || || No || None ||
 
|'''[[#firstName|FirstName]]''' || varchar(64) || utf8_general_ci || || No || None ||
|-
+
|- style="background:#eee;"
 
|'''[[#lastName|LastName]]''' || varchar(64) || utf8_general_ci || || No || None ||
 
|'''[[#lastName|LastName]]''' || varchar(64) || utf8_general_ci || || No || None ||
 
|-
 
|-
 
|'''[[#mail|Email]]''' || varchar(64) || utf8_general_ci || || Yes || NULL ||
 
|'''[[#mail|Email]]''' || varchar(64) || utf8_general_ci || || Yes || NULL ||
|-
+
|- style="background:#eee;"
 
|'''[[#serviceURLs|ServiceURLs]]''' || text || utf8_general_ci || || Yes || NULL ||
 
|'''[[#serviceURLs|ServiceURLs]]''' || text || utf8_general_ci || || Yes || NULL ||
 
|-
 
|-
 
|'''[[#created|Created]]''' || int(11) || || || Yes || NULL ||
 
|'''[[#created|Created]]''' || int(11) || || || Yes || NULL ||
|-
+
|- style="background:#eee;"
 
|'''[[#userLevel|UserLevel]]''' || int(11) || || || No || 0 ||
 
|'''[[#userLevel|UserLevel]]''' || int(11) || || || No || 0 ||
 
|-
 
|-
 
|'''[[#userFlags|UserFlags]]''' || int(11) || || || No || 0 ||
 
|'''[[#userFlags|UserFlags]]''' || int(11) || || || No || 0 ||
|-
+
|- style="background:#eee;"
 
|'''[[#userTitle|UserTitle]]''' || varchar(64) || utf8_general_ci || || No || ||
 
|'''[[#userTitle|UserTitle]]''' || varchar(64) || utf8_general_ci || || No || ||
 
|-
 
|-

Revision as of 17:36, 11 April 2016


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



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.
NOTE: This field was added in 0.8.0-post-fixes.



      (back to Database Documentation)

Personal tools
General
About This Wiki