Auth
From OpenSimulator
(Difference between revisions)
(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 13: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)
