Auth

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
(Created page to document the auth database table)
 
m (Added a note about the purspose of the table)
Line 1: Line 1:
 +
The auth table contains user authentication information. It holds an encrypted version of the password used by a user to login to OpenSimulator.
 +
 
== auth Table Structure ==
 
== auth Table Structure ==
  

Revision as of 14:34, 25 July 2012

The auth table contains user authentication information. It holds an encrypted version of the password used by a user to login to OpenSimulator.

auth Table Structure

The current structure of the auth table is as follows:

Field Type Collation Attributes Null Default Extra
UUID char(36) utf8_general_ci No None
passwordHash char(36) utf8_general_ci No
passwordSalt char(32) utf8_general_ci No
webLoginKey varchar(255) utf8_general_ci No
accountType varchar(32) utf8_general_ci No UserAccount



      (back to Database Documentation)


Auth Fields

UUID
UUID of an avatar


passwordHash
An MD5 hash of the users password and the salt string.
The hash is calculated as follows: md5(md5("password") + ":" + passwordSalt)


passwordSalt
A string used in the encryption of the password


webLoginKey
needs to be documented


accountType
A string that can be used to distinguish different types of avatar accounts



      (back to Database Documentation)


Personal tools
General
About This Wiki