Database:Users
From OpenSimulator
(Difference between revisions)
| Line 68: | Line 68: | ||
| email|| varchar(250) || YES|| || ''|| | | email|| varchar(250) || YES|| || ''|| | ||
|} | |} | ||
| − | + | <br> | |
| − | + | <br> | |
| + | (back to [[Database Documentation]]) | ||
| + | <hr> | ||
;UUID | ;UUID | ||
:The unique id of the user | :The unique id of the user | ||
Revision as of 09:31, 23 February 2009
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 | ||
| surname | 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' | ||
| varchar(250) | YES |
(back to Database Documentation)
- UUID
- The unique id of the user
- username
- The first name of the user
- surname
- 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
- needs to be documented
- customType
- needs to be documented
- partner
- The UUID of a user that will appear in the partner field of the profile dialog
- The email address of the user
