Primitems
From OpenSimulator
JeffKelley (Talk | contribs) m (Wikified table structure) |
JeffKelley (Talk | contribs) m (Fixed internal links OpenSim:Permissions -> OpenSimulator:Permissions) |
||
| (One intermediate revision by one user not shown) | |||
| Line 40: | Line 40: | ||
| itemID || char(36) || NO || PRI || || | | itemID || char(36) || NO || PRI || || | ||
|- | |- | ||
| − | | | + | | primID || char(36) || NO || MUL || || |
|- style="background:#eee;" | |- style="background:#eee;" | ||
| assetID || char(36) || YES || || || | | assetID || char(36) || YES || || || | ||
| Line 84: | Line 84: | ||
'''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 [[ | + | The permissions to be granted to the next owner of this item. Definitions of the Permissions fields can be found at [[OpenSimulator: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 [[ | + | The permissions currently in force on thie item. Definitions of the Permissions fields can be found at [[OpenSimulator:Permissions]] |
<br /> | <br /> | ||
| Line 100: | Line 100: | ||
'''everyonepermissions''' | '''everyonepermissions''' | ||
<br /> | <br /> | ||
| − | The permissions applied to everyone except the owner. Definitions of the Permissions fields can be found at [[ | + | The permissions applied to everyone except the owner. Definitions of the Permissions fields can be found at [[OpenSimulator:Permissions]] |
<br /> | <br /> | ||
| Line 106: | Line 106: | ||
'''grouppermissions''' | '''grouppermissions''' | ||
<br /> | <br /> | ||
| − | Not yet implemented - waiting on groups. Definitions of the Permissions fields can be found at [[ | + | Not yet implemented - waiting on groups. Definitions of the Permissions fields can be found at [[OpenSimulator:Permissions]] |
<br /> | <br /> | ||
| Line 112: | Line 112: | ||
'''flags''' | '''flags''' | ||
<br /> | <br /> | ||
| − | The use and values of flags are identified here: [[ | + | The use and values of flags are identified here: [[OpenSimulator:Permissions#ObjectFlags_.28F.29]] |
<br /> | <br /> | ||
<br /> | <br /> | ||
Latest revision as of 20:17, 12 May 2023
 |
Languages: |
|
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 | ||
| primID | 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 OpenSimulator:Permissions
currentPermissions
The permissions currently in force on thie item. Definitions of the Permissions fields can be found at OpenSimulator: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 OpenSimulator:Permissions
grouppermissions
Not yet implemented - waiting on groups. Definitions of the Permissions fields can be found at OpenSimulator:Permissions
flags
The use and values of flags are identified here: OpenSimulator: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)
