Primitems

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
m (Wikified table structure)
(2 intermediate revisions by one user not shown)
Line 1: Line 1:
 
__NOTOC__
 
__NOTOC__
{{Template:Quicklinks}}
+
{{Quicklinks}}
 
<br />
 
<br />
 
[[Category:Database]]
 
  
 
'''Primitems''' ''Describes Prim Items and their relationships with Prims and Users ''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
 
'''Primitems''' ''Describes Prim Items and their relationships with Prims and Users ''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
<br><br>
+
<br /><br />
The current structure of the Primitems table is as follows:<br>
+
The current structure of the Primitems table is as follows:
<br>
+
<br />
<table>
+
{| style="border:1px solid #ccc;"
<tr><td>Field<br></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
+
|- style="background:#cce;"
<tr><td>&nbsp;</td></tr>
+
! Field
<tr><td>invType</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
+
! Type
<tr><td>assetType</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
+
! Null
<tr><td>Name</td><td>varchar(255)</td><td>YES</td><td></td><td></td><td></td></tr>
+
! Key
<tr><td>Description</td><td>varchar(255)</td><td>YES</td><td></td><td></td><td></td></tr>
+
! Default
<tr><td>CreationDate</td><td>bigint(20)</td><td>YES</td><td></td><td></td><td></td></tr>
+
! Extra
<tr><td>nextPermissions</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
+
|-
<tr><td>currentPermissions</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
+
| invType || int(11) || YES ||  ||  ||
<tr><td>basePermissions</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
+
|- style="background:#eee;"
<tr><td>everyonePermissions</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
+
| assetType || int(11) || YES ||  ||  ||
<tr><td>groupPermissions</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
+
|-
<tr><td>flags</td><td>int(11)</td><td>YES</td><td></td><td>0</td><td></td></tr>
+
| Name || varchar(255) || YES ||  ||  ||
<tr><td>itemID</td><td>char(36)</td><td>NO</td><td>PRI</td><td></td><td></td></tr>
+
|- style="background:#eee;"
<tr><td>prim</td><td>char(36)</td><td>NO</td><td>MUL</td><td></td><td></td></tr>
+
| Description || varchar(255) || YES ||  ||  ||
<tr><td>assetID</td><td>char(36)</td><td>YES</td><td></td><td></td><td></td></tr>
+
|-
<tr><td>parentfolderID</td><td>char(36)</td><td>YES</td><td></td><td></td><td></td></tr>
+
| CreationDate || bigint(20) || YES ||  ||  ||
<tr><td>creatorID</td><td>char(36)</td><td>YES</td><td></td><td></td><td></td></tr>
+
|- style="background:#eee;"
<tr><td>ownerID</td><td>char(36)</td><td>YES</td><td></td><td></td><td></td></tr>
+
| nextPermissions || int(11) || YES ||  ||  ||
<tr><td>groupID</td><td>char(36)</td><td>YES</td><td></td><td></td><td></td></tr>
+
|-
<tr><td>lastownerID</td><td>char(36)</td><td>YES</td><td></td><td></td><td></td></tr>
+
| currentPermissions || int(11) || YES ||  ||  ||
</table>
+
|- style="background:#eee;"
<br>
+
| basePermissions || int(11) || YES ||  ||  ||
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+
|-
<hr>
+
| everyonePermissions || int(11) || YES ||  ||  ||
 +
|- style="background:#eee;"
 +
| groupPermissions || int(11) || YES ||  ||  ||
 +
|-
 +
| flags || int(11) || YES ||  || 0 ||
 +
|- style="background:#eee;"
 +
| itemID || char(36) || NO || PRI ||  ||
 +
|-
 +
| prim || char(36) || NO || MUL ||  ||
 +
|- style="background:#eee;"
 +
| assetID || char(36) || YES ||  ||  ||
 +
|-
 +
| parentfolderID || char(36) || YES ||  ||  ||
 +
|- style="background:#eee;"
 +
| creatorID || char(36) || YES ||  ||  ||
 +
|-
 +
| ownerID || char(36) || YES ||  ||  ||
 +
|- style="background:#eee;"
 +
| groupID || char(36) || YES ||  ||  ||
 +
|-
 +
| lastownerID || char(36) || YES ||  ||  ||
 +
|}
 +
<br />
 +
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br />
 +
----
 
'''invType'''
 
'''invType'''
<br>
+
<br />
 
The inventory type of this item. Is this needed with asset type?
 
The inventory type of this item. Is this needed with asset type?
<br>
+
<br />
<br>
+
<br />
 
'''assetType'''
 
'''assetType'''
<br>
+
<br />
 
The asset type of this item.
 
The asset type of this item.
<br>
+
<br />
<br>
+
<br />
 
'''name'''
 
'''name'''
<br>
+
<br />
 
The name of this item defined by the creator.
 
The name of this item defined by the creator.
<br>
+
<br />
<br>
+
<br />
 
'''description'''
 
'''description'''
<br>
+
<br />
 
A definition of this item.
 
A definition of this item.
<br>
+
<br />
<br>
+
<br />
 
'''creationDate'''
 
'''creationDate'''
<br>
+
<br />
 
The date the item was created.
 
The date the item was created.
<br>
+
<br />
<br>
+
<br />
 
'''nextPermissions'''
 
'''nextPermissions'''
<br>
+
<br />
 
The permissions to be granted to the next owner of this item. Definitions of the Permissions fields can be found at [[OpenSim:Permissions]]
 
The permissions to be granted to the next owner of this item. Definitions of the Permissions fields can be found at [[OpenSim:Permissions]]
<br>
+
<br />
<br>
+
<br />
 
'''currentPermissions'''
 
'''currentPermissions'''
<br>
+
<br />
 
The permissions currently in force on thie item. Definitions of the Permissions fields can be found at [[OpenSim:Permissions]]
 
The permissions currently in force on thie item. Definitions of the Permissions fields can be found at [[OpenSim:Permissions]]
  
<br>
+
<br />
<br>
+
<br />
 
'''basepermissions'''
 
'''basepermissions'''
<br>
+
<br />
 
The permissions that the item was created with.
 
The permissions that the item was created with.
<br>
+
<br />
<br>
+
<br />
 
'''everyonepermissions'''
 
'''everyonepermissions'''
<br>
+
<br />
 
The permissions applied to everyone except the owner. Definitions of the Permissions fields can be found at [[OpenSim:Permissions]]
 
The permissions applied to everyone except the owner. Definitions of the Permissions fields can be found at [[OpenSim:Permissions]]
  
<br>
+
<br />
<br>
+
<br />
 
'''grouppermissions'''
 
'''grouppermissions'''
<br>
+
<br />
 
Not yet implemented - waiting on groups. Definitions of the Permissions fields can be found at [[OpenSim:Permissions]]
 
Not yet implemented - waiting on groups. Definitions of the Permissions fields can be found at [[OpenSim:Permissions]]
  
<br>
+
<br />
<br>
+
<br />
 
'''flags'''
 
'''flags'''
<br>
+
<br />
 
The use and values of flags are identified here: [[OpenSim:Permissions#ObjectFlags_.28F.29]]
 
The use and values of flags are identified here: [[OpenSim:Permissions#ObjectFlags_.28F.29]]
<br>
+
<br />
<br>
+
<br />
 
'''itemID'''
 
'''itemID'''
<br>
+
<br />
 
The UUID of this item (i.e. the key by which it is accessed).
 
The UUID of this item (i.e. the key by which it is accessed).
<br>
+
<br />
<br>
+
<br />
 
'''primID'''
 
'''primID'''
<br>
+
<br />
 
The UUID of the prim to which this item is attached.
 
The UUID of the prim to which this item is attached.
<br>
+
<br />
<br>
+
<br />
 
'''assetID'''
 
'''assetID'''
<br>
+
<br />
 
The UUID of the asset on the asset table created by this item.
 
The UUID of the asset on the asset table created by this item.
<br>
+
<br />
<br>
+
<br />
 
'''parentfolderID'''
 
'''parentfolderID'''
<br>
+
<br />
 
Not certain about the use of this field, but it seems to be the same as the primID.
 
Not certain about the use of this field, but it seems to be the same as the primID.
<br>
+
<br />
<br>
+
<br />
 
'''ownerID'''
 
'''ownerID'''
<br>
+
<br />
 
The UUID of the user who currently owns this item.
 
The UUID of the user who currently owns this item.
<br>
+
<br />
<br>
+
<br />
 
'''groupID'''
 
'''groupID'''
<br>
+
<br />
 
Not currently used as groups are not yet implemented.
 
Not currently used as groups are not yet implemented.
<br>
+
<br />
<br>
+
<br />
 
'''lastownerID'''
 
'''lastownerID'''
<br>
+
<br />
 
The UUID of the user who previously owned this item.
 
The UUID of the user who previously owned this item.
<br>
+
<br />
<br>
+
<br />
<hr>
+
----
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br />
 +
 
 +
[[Category:Database]]
 
[[Category:Database]]
 
[[Category:Database]]

Revision as of 13:10, 16 January 2014


Primitems Describes Prim Items and their relationships with Prims and Users       (back to Database Documentation)

The current structure of the Primitems table is as follows:

Field Type Null Key Default Extra
invType int(11) YES
assetType int(11) YES
Name varchar(255) YES
Description varchar(255) YES
CreationDate bigint(20) YES
nextPermissions int(11) YES
currentPermissions int(11) YES
basePermissions int(11) YES
everyonePermissions int(11) YES
groupPermissions int(11) YES
flags int(11) YES 0
itemID char(36) NO PRI
prim char(36) NO MUL
assetID char(36) YES
parentfolderID char(36) YES
creatorID char(36) YES
ownerID char(36) YES
groupID char(36) YES
lastownerID char(36) YES


      (back to Database Documentation)


invType
The inventory type of this item. Is this needed with asset type?

assetType
The asset type of this item.

name
The name of this item defined by the creator.

description
A definition of this item.

creationDate
The date the item was created.

nextPermissions
The permissions to be granted to the next owner of this item. Definitions of the Permissions fields can be found at OpenSim:Permissions

currentPermissions
The permissions currently in force on thie item. Definitions of the Permissions fields can be found at OpenSim:Permissions



basepermissions
The permissions that the item was created with.

everyonepermissions
The permissions applied to everyone except the owner. Definitions of the Permissions fields can be found at OpenSim:Permissions



grouppermissions
Not yet implemented - waiting on groups. Definitions of the Permissions fields can be found at OpenSim:Permissions



flags
The use and values of flags are identified here: OpenSim:Permissions#ObjectFlags_.28F.29

itemID
The UUID of this item (i.e. the key by which it is accessed).

primID
The UUID of the prim to which this item is attached.

assetID
The UUID of the asset on the asset table created by this item.

parentfolderID
Not certain about the use of this field, but it seems to be the same as the primID.

ownerID
The UUID of the user who currently owns this item.

groupID
Not currently used as groups are not yet implemented.

lastownerID
The UUID of the user who previously owned this item.


      (back to Database Documentation)

Personal tools
General
About This Wiki