UserAccounts - Revision history

CodyCooper: /* UserAccounts Fields */

2019-04-09T18:53:34Z

‎UserAccounts Fields

Kcozens: Added details about the UserFlags field from the Database:Users page

2016-06-22T01:38:15Z

Added details about the UserFlags field from the Database:Users page

Kcozens: Added missing tags

2016-04-12T02:13:15Z

Added missing </div> tags

Kcozens: Minor formatting changes to match other database documentation pages

2016-04-12T01:46:01Z

Minor formatting changes to match other database documentation pages

Kcozens: Changed colour of table headers and alternate lines in Table Structure table. Fixed C&P error.

2016-04-12T00:36:58Z

Changed colour of table headers and alternate lines in Table Structure table. Fixed C&P error.

Kcozens: Adjusted spacing between sections of field details

2016-04-12T00:01:37Z

Adjusted spacing between sections of field details

Kcozens: Updated default value for active field.

2016-04-11T23:58:41Z

Updated default value for active field.

Kcozens: Added a note that the active field was added in 080PF

2016-04-02T01:57:34Z

Added a note that the active field was added in 080PF

Kcozens: Added links from table structure to field descriptions

2016-04-02T01:43:28Z

Added links from table structure to field descriptions

Kcozens: Created page with information on UserAccounts table

2016-04-02T01:34:45Z

Created page with information on UserAccounts table

New page

__NOTOC__
{{Quicklinks}}
<br />

The '''UserAccounts''' table contains a list of avatar accounts       (back to [[Database Documentation]])
<br />
<br />

== Avatars Table Structure ==

The structure of the Avatars table as of v0.8.0-post-fixes is as follows:
<br />
{| style="border:1px solid #ccc;"
|- style="background:#eef;"
! Field
! Type
! Collation
! Attributes
! Null
! Default
! Extra
|-
| '''[[#principalID|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) || || || || ||
|}

<br />
<br />

== UserAccounts Fields ==

;<div name="principalID">'''PrincipalID'''</div>
:The UUID of an avatar
<br />

<div name="ScopeID">'''ScopeID'''
:unknown
<br />

<div name="FirstName">'''FirstName'''
:The first name of the avatar
<br />

<div name="LastName">'''LastName'''
:The last name of the avatar
<br />

<div name="Email">'''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
<br />

<div name="ServiceURLs">'''ServiceURLs'''
:unknown
<br />

<div name="Created">'''Created'''
:A unix timestamp when the avatar account was created
<br />

<div name="UserLevel">'''UserLevel'''
:The value is 0 for normal users. Values of 200 and up are for grid gods.
<br />

<div name="UserFlags">'''UserFlags'''
:unknown
<br />

<div name="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.
<br />

<div name="active">'''active'''
:Indicates if the user account is active.
<br />

----

(back to [[Database Documentation]])

<br />

[[Category:Database]]

@@ Line 54: / Line 54: @@
 ;<div id="principalID">'''PrincipalID'''</div>
 :The UUID of an avatar
 <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
 <div id="firstName">'''FirstName'''</div>

@@ Line 78: / Line 78: @@
 <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.
 <div id="userTitle">'''UserTitle'''</div>

@@ Line 56: / Line 56: @@
 :The UUID of an avatar
-<div id="scope">'''ScopeID'''
+<div id="scope">'''ScopeID'''</div>
 :unknown
-<div id="firstName">'''FirstName'''
+<div id="firstName">'''FirstName'''</div>
 :The first name of the avatar
-<div id="lastName">'''LastName'''
+<div id="lastName">'''LastName'''</div>
 :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
-<div id="serviceURLs">'''ServiceURLs'''
+<div id="serviceURLs">'''ServiceURLs'''</div>
 :unknown
-<div id="created">'''Created'''
+<div id="created">'''Created'''</div>
 :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.
-<div id="userFlags">'''UserFlags'''
+<div id="userFlags">'''UserFlags'''</div>
 :unknown
-<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.
-<div id="active">'''active'''
+<div id="active">'''active'''</div>
 :Indicates if the user account is active.
 :'''NOTE:''' This field was added in 0.8.0-post-fixes.

@@ Line 7: / Line 7: @@
 <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 />
 {| style="border:1px solid #ccc;"
-|- style="background:#eef;"
+|- style="background:#cce;"
 ! Field
 ! Type
@@ Line 22: / Line 22: @@
 |-
 | '''[[#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 ||
 |-
 |'''[[#firstName|FirstName]]''' || varchar(64) || utf8_general_ci || || No || None ||
-|-
+|- style="background:#eee;"
 |'''[[#lastName|LastName]]''' || varchar(64) || utf8_general_ci || || No || None ||
 |-
 |'''[[#mail|Email]]''' || varchar(64) || utf8_general_ci || || Yes || NULL ||
-|-
+|- style="background:#eee;"
 |'''[[#serviceURLs|ServiceURLs]]''' || text || utf8_general_ci || || Yes || NULL ||
 |-
 |'''[[#created|Created]]''' || int(11) || || || Yes || NULL ||
-|-
+|- style="background:#eee;"
 |'''[[#userLevel|UserLevel]]''' || int(11) || || || No || 0 ||
 |-
 |'''[[#userFlags|UserFlags]]''' || int(11) || || || No || 0 ||
-|-
+|- style="background:#eee;"
 |'''[[#userTitle|UserTitle]]''' || varchar(64) || utf8_general_ci || || No || ||
 |-

@@ Line 51: / Line 51: @@
 ;<div id="principalID">'''PrincipalID'''</div>
 :The UUID of an avatar
 <div id="scope">'''ScopeID'''
 :unknown
 <div id="firstName">'''FirstName'''
 :The first name of the avatar
 <div id="lastName">'''LastName'''
 :The last name of the avatar
 <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
 <div id="serviceURLs">'''ServiceURLs'''
 :unknown
 <div id="created">'''Created'''
 :A unix timestamp when the avatar account was created
 <div id="userLevel">'''UserLevel'''
 :The value is 0 for normal users. Values of 200 and up are for grid gods.
 <div id="userFlags">'''UserFlags'''
 :unknown
 <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.
 <div id="active">'''active'''

@@ Line 43: / Line 43: @@
 |'''[[#active|active]]''' || int(11) || || || No || 1 ||
 |}
 <br />
 <br />
@@ Line 87: / Line 91: @@
 ----
-       (back to [[Database Documentation]])
+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
-−
 <br />
 [[Category:Database]]