Database:Users

users	Stores users profile data     (back to Database Documentation)

The current structure of the users table is as follows:


 * UUID
 * The unique id of the user


 * username
 * The first name of the user


 * lastname
 * The last name of the user


 * passwordHash
 * The MD5-hash from password and salt


 * passwordSalt
 * The password salt


 * homeRegion
 * The region-handle of the home-region


 * homeLocationX, homeLocationY, homeLocationZ
 * The home-location within the home-region


 * homeLookAtX, homeLookAtY, homeLookAtZ
 * The direction the avatar looks after TP to the home-location


 * created
 * Creation timestamp of the profile (in seconds since UNIX-epoch (Jan 1st, 1971))


 * lastLogin
 * Time of last login (in seconds since UNIX-epoch)


 * userInventoryURI
 * needs to be documented


 * userAssetURI
 * needs to be documented


 * profileCanDoMask
 * needs to be documented


 * profileWantDoMask
 * needs to be documented


 * profileAboutText
 * The text in the about field of the profile dialog


 * profileFirstText
 * The text in the first-life field of the profile dialog


 * profileImage
 * The UUID of the profile image


 * profileFirstImage
 * The UUID of the first-life image


 * webLoginKey
 * needs to be documented


 * homeRegionID
 * The region UUID of the home-region


 * userFlags
 * needs to be documented


 * godLevel
 * needs to be documented


 * customType
 * needs to be documented


 * partner
 * The UUID of an user that will appear in the partner field of the profile dialog