UserAccounts
From OpenSimulator
(Difference between revisions)
m (Updated default value for active field.) |
CodyCooper (Talk | contribs) (→UserAccounts Fields) |
||
| (5 intermediate revisions by one user not shown) | |||
| Line 7: | Line 7: | ||
<br /> | <br /> | ||
| − | == | + | == UserAccounts Table Structure == |
| − | The structure of the | + | 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:# | + | |- 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) || || || No || 1 || | |'''[[#active|active]]''' || int(11) || || || No || 1 || | ||
|} | |} | ||
| + | <br /> | ||
| + | (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 |
| − | + | ||
| − | <div id="scope">'''ScopeID''' | + | <div id="scope">'''ScopeID'''</div> |
| − | + | :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 | |
| − | < | + | |
| − | <div id="firstName">'''FirstName''' | + | <div id="firstName">'''FirstName'''</div> |
:The first name of the avatar | :The first name of the avatar | ||
| − | |||
| − | <div id="lastName">'''LastName''' | + | <div id="lastName">'''LastName'''</div> |
:The last name of the avatar | :The last name of the avatar | ||
| − | |||
| − | <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 | ||
| − | |||
| − | <div id="serviceURLs">'''ServiceURLs''' | + | <div id="serviceURLs">'''ServiceURLs'''</div> |
:unknown | :unknown | ||
| − | |||
| − | <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 | ||
| − | |||
| − | <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. | ||
| − | |||
| − | <div id="userFlags">'''UserFlags''' | + | <div id="userFlags">'''UserFlags'''</div> |
| − | + | :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. | |
| − | < | + | |
| − | <div id="userTitle">'''UserTitle''' | + | :<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> | ||
: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. | ||
| − | |||
| − | <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. | :'''NOTE:''' This field was added in 0.8.0-post-fixes. | ||
| Line 97: | Line 105: | ||
---- | ---- | ||
| − | + | (back to [[Database Documentation]]) | |
| − | + | ||
<br /> | <br /> | ||
[[Category:Database]] | [[Category:Database]] | ||
Latest revision as of 10:53, 9 April 2019
 |
Languages: |
|
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 | ||
| 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)
