UserAccounts
From OpenSimulator
(Difference between revisions)
(Created page with information on UserAccounts table) |
m (Added links from table structure to field descriptions) |
||
| Line 23: | Line 23: | ||
| '''[[#principalID|PrincipalID]]''' || char(36) || utf8_general_ci || || No || ''None'' || | | '''[[#principalID|PrincipalID]]''' || char(36) || utf8_general_ci || || No || ''None'' || | ||
|- | |- | ||
| − | |'''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''' || varchar(64) || utf8_general_ci || || No || None || | + | |'''[[#firstName|FirstName]]''' || varchar(64) || utf8_general_ci || || No || None || |
|- | |- | ||
| − | |'''LastName''' || varchar(64) || utf8_general_ci || || No || None || | + | |'''[[#lastName|LastName]]''' || varchar(64) || utf8_general_ci || || No || None || |
|- | |- | ||
| − | |'''Email''' || varchar(64) || utf8_general_ci || || Yes || NULL || | + | |'''[[#mail|Email]]''' || varchar(64) || utf8_general_ci || || Yes || NULL || |
|- | |- | ||
| − | |'''ServiceURLs''' || text || utf8_general_ci || || Yes || NULL || | + | |'''[[#serviceURLs|ServiceURLs]]''' || text || utf8_general_ci || || Yes || NULL || |
|- | |- | ||
| − | |'''Created''' || int(11) || || || Yes || NULL || | + | |'''[[#created|Created]]''' || int(11) || || || Yes || NULL || |
|- | |- | ||
| − | |'''UserLevel''' || int(11) || || || No || 0 || | + | |'''[[#userLevel|UserLevel]]''' || int(11) || || || No || 0 || |
|- | |- | ||
| − | |'''UserFlags''' || int(11) || || || No || 0 || | + | |'''[[#userFlags|UserFlags]]''' || int(11) || || || No || 0 || |
|- | |- | ||
| − | |'''UserTitle''' || varchar(64) || utf8_general_ci || || No || || | + | |'''[[#userTitle|UserTitle]]''' || varchar(64) || utf8_general_ci || || No || || |
|- | |- | ||
| − | |'''active''' || int(11) || || || || || | + | |'''[[#active|active]]''' || int(11) || || || || || |
|} | |} | ||
| Line 49: | Line 49: | ||
== UserAccounts Fields == | == UserAccounts Fields == | ||
| − | ;<div | + | ;<div id="principalID">'''PrincipalID'''</div> |
:The UUID of an avatar | :The UUID of an avatar | ||
<br /> | <br /> | ||
| − | <div | + | <div id="scope">'''ScopeID''' |
:unknown | :unknown | ||
<br /> | <br /> | ||
| − | <div | + | <div id="firstName">'''FirstName''' |
:The first name of the avatar | :The first name of the avatar | ||
<br /> | <br /> | ||
| − | <div | + | <div id="lastName">'''LastName''' |
:The last name of the avatar | :The last name of the avatar | ||
<br /> | <br /> | ||
| − | <div | + | <div id="mail">'''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 | :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 /> | <br /> | ||
| − | <div | + | <div id="serviceURLs">'''ServiceURLs''' |
:unknown | :unknown | ||
<br /> | <br /> | ||
| − | <div | + | <div id="created">'''Created''' |
:A unix timestamp when the avatar account was created | :A unix timestamp when the avatar account was created | ||
<br /> | <br /> | ||
| − | <div | + | <div id="userLevel">'''UserLevel''' |
: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 /> | <br /> | ||
| − | <div | + | <div id="userFlags">'''UserFlags''' |
:unknown | :unknown | ||
<br /> | <br /> | ||
| − | <div | + | <div id="userTitle">'''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. | :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 /> | <br /> | ||
| − | <div | + | <div id="active">'''active''' |
:Indicates if the user account is active. | :Indicates if the user account is active. | ||
<br /> | <br /> | ||
Revision as of 17:43, 1 April 2016
 |
Languages: |
|
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.
