UserAccounts

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
m (Added links from table structure to field descriptions)
(UserAccounts Fields)
 
(7 intermediate revisions by one user not shown)
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 || ||
 
|-
 
|-
|'''[[#active|active]]''' || int(11) || || || || ||
+
|'''[[#active|active]]''' || int(11) || || || No || 1 ||
 
|}
 
|}
 +
<br />
  
 +
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
 
<br />
 
<br />
 +
 +
----
 
<br />
 
<br />
  
Line 50: Line 54:
  
 
;<div id="principalID">'''PrincipalID'''</div>
 
;<div id="principalID">'''PrincipalID'''</div>
:The UUID of an avatar
+
:The UUID of an avatar  
<br />
+
  
<div id="scope">'''ScopeID'''
+
<div id="scope">'''ScopeID'''</div>
:unknown
+
: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
<br />
+
  
<div id="firstName">'''FirstName'''
+
<div id="firstName">'''FirstName'''</div>
 
:The first name of the avatar
 
:The first name of the avatar
<br />
 
  
<div id="lastName">'''LastName'''
+
<div id="lastName">'''LastName'''</div>
 
:The last name of the avatar
 
:The last name of the avatar
<br />
 
  
<div id="mail">'''Email'''
+
<div id="mail">'''Email'''</div>
 
: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 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
<br />
 
  
<div id="serviceURLs">'''ServiceURLs'''
+
<div id="serviceURLs">'''ServiceURLs'''</div>
 
:unknown
 
:unknown
<br />
 
  
<div id="created">'''Created'''
+
<div id="created">'''Created'''</div>
 
:A unix timestamp when the avatar account was created
 
:A unix timestamp when the avatar account was created
<br />
 
  
<div id="userLevel">'''UserLevel'''
+
<div id="userLevel">'''UserLevel'''</div>
 
:The value is 0 for normal users. Values of 200 and up are for grid gods.
 
:The value is 0 for normal users. Values of 200 and up are for grid gods.
<br />
 
  
<div id="userFlags">'''UserFlags'''
+
<div id="userFlags">'''UserFlags'''</div>
:unknown
+
: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.
<br />
+
 
 +
:<i style="color:green;">Account Types:</i>
 +
:0 = Normal user (Resident)
 +
:1 = Trial Member
 +
:2 = Charter Member
 +
:3 = Linden Labs Employee
 +
 
 +
:<i style="color:green;">Bit flags:</i>
 +
: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)
  
<div id="userTitle">'''UserTitle'''
+
<div id="userTitle">'''UserTitle'''</div>
 
: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.
 
: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.
<br />
 
  
<div id="active">'''active'''
+
<div id="active">'''active'''</div>
 
:Indicates if the user account is active.
 
:Indicates if the user account is active.
 +
:'''NOTE:''' This field was added in 0.8.0-post-fixes.
 +
 
<br />
 
<br />
 
  
 
----
 
----
  
      (back to [[Database Documentation]])
+
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
 
+
 
<br />
 
<br />
  
 
[[Category:Database]]
 
[[Category:Database]]

Latest revision as of 10:53, 9 April 2019


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

[edit] 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)



[edit] 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)

Personal tools
General
About This Wiki