Database:Users

From OpenSimulator

Revision as of 18:09, 11 July 2009 by Courtneywise (Talk | contribs)

Jump to: navigation, search


users Stores users profile data      (back to Database Documentation)

The current structure of the users table is as follows:

Field Type Null Key Default Extra
UUID varchar(36) NO PRI
username varchar(32) NO UNI
lastname varchar(32) NO UNI
passwordHash varchar(32) NO
passwordSalt varchar(32) NO
homeRegion bigint(20) unsigned YES NULL
homeLocationX float YES NULL
homeLocationY float YES NULL
homeLocationZ float YES NULL
homeLookAtX float YES NULL
homeLookAtY float YES NULL
homeLookAtZ float YES NULL
created int(11) NO
lastLogin int(11) NO
userInventoryURI varchar(255) YES NULL
userAssetURI varchar(255) YES NULL
profileCanDoMask int(10) unsigned YES NULL
profileWantDoMask int(10) unsigned YES NULL
profileAboutText text YES NULL
profileFirstText text YES NULL
profileImage varchar(36) YES NULL
profileFirstImage varchar(36) YES NULL
webLoginKey varchar(36) YES NULL
homeRegionID char(36) NO '00000000-0000-0000-0000-000000000000'
userFlags int(11) NO '0'
godLevel int(11) NO '0'
customType varchar(32) NO
partner char(36) NO '00000000-0000-0000-0000-000000000000'
email varchar(250) YES



      (back to Database Documentation)


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
Account Types:
Insert 200 to: Resident:Payment info on account
Insert 300 to: Testing:Payment info on account
Insert 400 to: Testing:No payment info on account
Insert 600 to: Member Estatute:Payment info on account
Insert 800 to: Linden Contracted
New Info by Matpratta (matpratta@gmail.com)[1]
godLevel
Admins:
Insert 200 to: allow user to get admin level (advanced -> request admin
customType
Custom Account Names:
enter what ever you want and it will be show as your user type so you can have custom account types then the defalt set ones under userFlags
partner
The UUID of a user that will appear in the partner field of the profile dialog
email
The email address of the user



      (back to Database Documentation)

Personal tools
General
About This Wiki