OpenSimulator - User contributions [en]

Talk:Database:Inventoryfolders

2009-02-18T16:01:39Z

Barth: schema of inventoryfolders

This is what I see in sqlite3:

CREATE TABLE inventoryfolders(
UUID varchar(255) primary key,
name varchar(255),
agentID varchar(255),
parentID varchar(255),
type integer,
version integer);

I guess I should change this page, too.

Database:Assets

2009-02-18T14:12:30Z

Barth: field is Type, not assetType

'''assets''' ''Records all assets''      (back to [[Database Documentation]]) 
          ''including textures, notecards, scripts, and avatar parts''
 
The current structure of the assets table is as follows: 
 
<table>
<tr><td>Field </td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
<tr><td> </td></tr>
<tr><td>Name</td><td>varchar(64)</td><td>NO</td><td></td><td>NULL</td><td> </td></tr>
<tr><td>description</td><td>varchar(64)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
<tr><td>Type</td><td>tinyint(4)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
<tr><td>local</td><td>tinyint(1)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td><tr>
<tr><td>temporary</td><td>tinyint(1)</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
<tr><td>data</td><td>longblob</td><td>NO</td><td></td><td>NULL</td><td></td><td></td></tr>
<tr><td>id</td><td>char(36)</td><td>NO</td><td>PRI</td><td>00000000-0000-0000-0000-000000000000</td><td></td><td></td></tr>
</table>
 
 
      (back to [[Database Documentation]]) 
<hr>
'''name'''
 
Name of the asset as it would appear in inventory 
 
'''description'''
Asset's description field, as it appears in various client-side editing widgets
 
 
'''Type'''
 
Integer which designates the asset's inventory type
 
 
'''local'''
 
For Future Use
 
 
'''temporary'''
 
For Future Use
 
 
'''data'''
This is the blob which contains the actual script, notecard text, 
or binary image (texture) or other data characterized by the invType column 
 
'''id'''
 
UUID which uniquely identifies the asset within the system
 
 
<hr>
      (back to [[Database Documentation]]) 
[[Category:Database]]

Database:Users

2009-02-18T13:54:42Z

Barth: it's not 'lastname', it's 'surname'

'''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 || ||
|-
| 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' ||
|}

;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)[http://opensimulator.org/wiki/How-to]

;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
[[Category:Database]]

Database:Inventoryitems

2009-01-31T13:49:19Z

Barth: added assettype enumeration link

'''inventoryitems''' ''Records details with respect to the avatar's personal property (assets)''      (back to [[Database Documentation]]) 
 
The current structure of the inventoryitems table is as follows: 
 
<table>
<tr><td>Field </td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
<tr><td> </td></tr>
<tr><td>assetID</td><td>varchar(36)</td><td>YES</td><td></td><td>NULL</td><td> </td></tr>
<tr><td>assetType</td><td>int(11) unsigned</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
<tr><td>inventoryName</td><td>varchar(64)</td><td>YES</td><td></td><td>NULL</td><td></td></tr>
<tr><td>inventoryDescription</td><td>varchar(64)</td><td>YES</td><td></td><td>NULL</td><td></td><td></td><tr>
<tr><td>inventoryNextPermissions</td><td>int(10) unsigned</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
<tr><td>inventoryCurrentPermissions</td><td>int(10) unsigned</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
<tr><td>invType</td><td>int(11)</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
<tr><td>CreatorID</td><td>varchar(36)</td><td>YES</td><td></td><td>NULL</td><td></td><td></td></tr>
<tr><td>inventoryBasePermissions</td><td>int(10) unsigned</td><td>NO</td><td></td><td>0</td><td></td><td></td></tr>
<tr><td>inventoryEveryOnePermissions</td><td>int(10) unsigned</td><td>NO</td><td></td><td>0</td><td></td><td></td></tr>
<tr><td>salePrice</td><td>int(11)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
<tr><td>saleType</td><td>tinyint(4)</td><td>NO</td><td></td><td>NULL</td><td></td><tr>
<tr><td>creationDate</td><td>int(11)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
<tr><td>groupID</td><td>varchar(36)</td><td>NO</td><td></td><td>00000000-0000-0000-0000-000000000000</td><td></td> 
<tr><td>groupOwned</td><td>tinyint(4)</td><td>NO</td><td></td><td>NULL</td><td></td></tr>
<tr><td>flags</td><td>int(11) unsigned</td><td>NO</td><td></td><td>0</td><td></td></tr>
<tr><td>inventoryID</td><td>char(36)</td><td>NO</td><td>PRI</td><td>00000000-0000-0000-0000-000000000000</td><td></td></tr>
<tr><td>avatarID</td><td>char(36)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td><tr>
<tr><td>parentFolderId</td><td>char(36)</td><td>YES</td><td>MUL</td><td>NULL</td><td></td></tr>
</table>
 
 
      (back to [[Database Documentation]]) 
<hr>
'''assetID''' 
Refers to the related row in the assets table.
 
'''assetType''' 
Type of asset (e.g., script, texture, or shape - [http://wiki.secondlife.com/wiki/AssetType asset type list])
 
'''inventoryName''' 
Text of the name of the inventory item as it appears in the client inventory interface.
 
'''inventoryDescription''' 
Text of the description of the inventory item as it appears in the client inventory interface.
 
'''inventoryNextPermissions''' 
Permissions that will be applied to the item if/when it is transferred to another avatar.
 
'''inventoryCurrentPermissions''' 
Permissions on the the item for the current posessor of the item.
 
'''invType''' 
Type of inventory item (is this redundant with assetType?)
 
'''creatorID''' 
UUID of the item's original creator.
 
'''inventoryBasePermissions''' 
Base permissions of the object.
 
'''inventoryEveryOnePermissions''' 
Permissions with respect to everyone but the owner of the item.
 
'''salePrice''' 
Sale price of the item.
 
'''saleType''' 
''presently unknown''
 
'''creationDate''' 
Date the item was created
 
'''groupID''' 
UUID of the group that the items is 'deeded' to
 
'''groupOwned''' 
group ownership flags
 
'''flags''' 
''presently unknown''
 
'''inventoryID''' 
UUID of inventory item
 
'''avatarID''' 
UUID of item's owner
 
'''parentFolderID''' 
UUID of the folder said to 'contain' the item
<hr> 
      (back to [[Database Documentation]]) 
[[Category:Database]]

Talk:Building a bot

2009-01-12T06:31:28Z

Barth: remark on changing int32 conversion

I needed to change these
Convert.ToInt32(pos.X)
to
(int) pos.X
etc
to make it work on Vista 32 Bit otherwise the bot would go elsewhere. I wonder why that is.