OpenSimulator - User contributions [en]

Database:Users

2009-07-12T02:13:40Z

Courtneywise:

__NOTOC__
{{Template:Quicklinks}}
 
'''users''' ''Stores users profile data''      (back to [[Database Documentation]])

The current structure of the users table is as follows:
{| cellpadding="5" cellspacing="0" border="1"
!align="left"| Field
!align="left"| Type
!align="left"| Null
!align="left"| Key
!align="left"| Default
!align="left"| 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]])
<hr>
;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)[http://opensimulator.org/wiki/How-to]

;godLevel
:Admins:
:Insert 200 to: allow user to get admin level (advanced -> request admin)
:New Info by courtneywise

;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
:New Info by courtneywise

;partner
:The UUID of a user that will appear in the partner field of the profile dialog

;email
:The email address of the user
 
<hr>
      (back to [[Database Documentation]])
 
[[Category:Database]]

Database:Users

2009-07-12T02:10:49Z

Courtneywise:

__NOTOC__
{{Template:Quicklinks}}
 
'''users''' ''Stores users profile data''      (back to [[Database Documentation]])

The current structure of the users table is as follows:
{| cellpadding="5" cellspacing="0" border="1"
!align="left"| Field
!align="left"| Type
!align="left"| Null
!align="left"| Key
!align="left"| Default
!align="left"| 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]])
<hr>
;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)[http://opensimulator.org/wiki/How-to]

;godLevel
:Admins:
:Insert 200 to: allow user to get admin level (advanced -> request admin)
:New Info by courtneywise

;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
:New Info by courtneywise

;partner
:The UUID of a user that will appear in the partner field of the profile dialog

;email
:The email address of the user
 
<hr>
      (back to [[Database Documentation]])
 
[[Category:Database]]

Database:Users

2009-07-12T02:09:53Z

Courtneywise:

__NOTOC__
{{Template:Quicklinks}}
 
'''users''' ''Stores users profile data''      (back to [[Database Documentation]])

The current structure of the users table is as follows:
{| cellpadding="5" cellspacing="0" border="1"
!align="left"| Field
!align="left"| Type
!align="left"| Null
!align="left"| Key
!align="left"| Default
!align="left"| 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]])
<hr>
;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)[http://opensimulator.org/wiki/How-to]

;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
 
<hr>
      (back to [[Database Documentation]])
 
[[Category:Database]]