Prims (database table)
From OpenSimulator
| Line 129: | Line 129: | ||
<b>OwnerMask</b> | <b>OwnerMask</b> | ||
<br> | <br> | ||
| − | + | The permissions of the current owner. Further details are available here: [[OpenSim:Permissions#OwnerMask_.28O.29]] | |
<br> | <br> | ||
<br> | <br> | ||
<b>NextOwnerMasks</b> | <b>NextOwnerMasks</b> | ||
<br> | <br> | ||
| − | + | The permissions to be passed to the next owner. Further details are available here: [[OpenSim:Permissions#NextOwnerMask_.28N.29]] | |
<br> | <br> | ||
<br> | <br> | ||
<b>GroupMask</b> | <b>GroupMask</b> | ||
<br> | <br> | ||
| − | + | GroupMask is not yet implemented. However further details are available here: [[OpenSim:Permissions#GroupMask_.28G.29]] | |
<br> | <br> | ||
<br> | <br> | ||
<b>EveryoneMask</b> | <b>EveryoneMask</b> | ||
<br> | <br> | ||
| − | + | The permissions given to other users. Further details are available here: [[OpenSim:Permissions#EveryoneMask_.28E.29]] | |
<br> | <br> | ||
<br> | <br> | ||
<b>BaseMask</b> | <b>BaseMask</b> | ||
<br> | <br> | ||
| − | + | The initial permissions given to the current owner. Further details are available here: [[OpenSim:Permissions#BaseMask_.28B.29]] | |
<br> | <br> | ||
<br> | <br> | ||
| Line 249: | Line 249: | ||
<b>UUID</b> | <b>UUID</b> | ||
<br> | <br> | ||
| − | + | The unique key of this prim row on the database. | |
<br> | <br> | ||
<br> | <br> | ||
<b>RegionUUID</b> | <b>RegionUUID</b> | ||
<br> | <br> | ||
| − | + | The key of the Region on the Regions table which contains this prim | |
<br> | <br> | ||
<br> | <br> | ||
<b>CreatorID</b> | <b>CreatorID</b> | ||
<br> | <br> | ||
| − | + | the UUID (key) of the user who created this prim. | |
<br> | <br> | ||
<br> | <br> | ||
<b>OwnerID</b> | <b>OwnerID</b> | ||
<br> | <br> | ||
| − | + | the UUID (key)of the user who currently owns this prim. | |
<br> | <br> | ||
<br> | <br> | ||
| Line 274: | Line 274: | ||
<b>LastOwnerID</b> | <b>LastOwnerID</b> | ||
<br> | <br> | ||
| − | + | The UUID (key) of the user who last owned this prim (i.e. who transferred it to the current OwnerID). | |
<br> | <br> | ||
<br> | <br> | ||
| Line 284: | Line 284: | ||
<b>PayPrice</b> | <b>PayPrice</b> | ||
<br> | <br> | ||
| − | + | Can be either: | |
| + | -1 PAY_HIDE or -2 PAY_DEFAULT | ||
<br> | <br> | ||
<br> | <br> | ||
<b>PayButton1</b> | <b>PayButton1</b> | ||
<br> | <br> | ||
| − | + | Can be either: | |
| + | -1 PAY_HIDE or -2 PAY_DEFAULT | ||
<br> | <br> | ||
<br> | <br> | ||
<b>PayButton2</b> | <b>PayButton2</b> | ||
<br> | <br> | ||
| − | + | Can be either: | |
| + | -1 PAY_HIDE or -2 PAY_DEFAULT | ||
<br> | <br> | ||
<br> | <br> | ||
<b>PayButton3</b> | <b>PayButton3</b> | ||
<br> | <br> | ||
| − | + | Can be either: | |
| + | -1 PAY_HIDE or -2 PAY_DEFAULT | ||
<br> | <br> | ||
<br> | <br> | ||
<b>PayButton4</b> | <b>PayButton4</b> | ||
<br> | <br> | ||
| − | + | Can be either: | |
| + | -1 PAY_HIDE or -2 PAY_DEFAULT | ||
<br> | <br> | ||
<br> | <br> | ||
<b>LoopedSound</b> | <b>LoopedSound</b> | ||
<br> | <br> | ||
| − | + | The UUID of an asset which defines a sound to be played from this prim. | |
<br> | <br> | ||
<br> | <br> | ||
<b>LoopedSoundGain</b> | <b>LoopedSoundGain</b> | ||
<br> | <br> | ||
| − | + | The volume of the looped sound. | |
<br> | <br> | ||
<br> | <br> | ||
| Line 419: | Line 424: | ||
<b>ParticleSystem</b> | <b>ParticleSystem</b> | ||
<br> | <br> | ||
| − | + | A block of data defining a particle effect associated with this Prim. | |
<br> | <br> | ||
<br> | <br> | ||
| Line 434: | Line 439: | ||
<b>CollisionSound</b> | <b>CollisionSound</b> | ||
<br> | <br> | ||
| − | + | The sound made when an object collides with this prim. | |
<br> | <br> | ||
<br> | <br> | ||
| − | <b> | + | <b>CollisionSoundVolume</b> |
<br> | <br> | ||
| − | + | The volume of the collision sound. | |
<br> | <br> | ||
<br> | <br> | ||
Revision as of 10:42, 25 February 2009
Prims Describes all Prim attributes except shape and content (back to Database Documentation)
The current structure of the Prims table is as follows:
| Field | Type | Null | Key | Default | Extra |
| CreationDate | int(11) | YES | |||
| Name | varchar(255) | YES | |||
| Text | varchar(255) | YES | |||
| Description | varchar(255) | YES | |||
| SitName | varchar(255) | YES | |||
| TouchName | varchar(255) | YES | |||
| ObjectFlags | int(11) | YES | |||
| OwnerMask | int(11) | YES | |||
| nextOwnerMask | int(11) | YES | |||
| GroupMask | int(11) | YES | |||
| EveryoneMask | int(11) | YES | |||
| BaseMask | int(11) | YES | |||
| PositionX | double | YES | |||
| PositionY | double | YES | |||
| PositionZ | double | YES | |||
| GroupPositionX | double | YES | |||
| GroupPositionY | double | YES | |||
| GroupPositionZ | double | YES | |||
| VelocityX | double | YES | |||
| VelocityY | double | YES | |||
| VelocityZ | double | YES | |||
| AngularVelocityX | double | YES | |||
| AngularVelocityY | double | YES | |||
| AngularVelocityZ | double | YES | |||
| AccelerationX | double | YES | |||
| AccelerationY | double | YES | |||
| AccelerationZ | double | YES | |||
| RotationX | double | YES | |||
| RotationY | double | YES | |||
| RotationZ | double | YES | |||
| RotationW | double | YES | |||
| SitTargetOffsetX | double | YES | |||
| SitTargetOffsetY | double | YES | |||
| SitTargetOffsetZ | double | YES | |||
| UUID | char(36) | NO | PRI | ||
| RegionUUID | char(36) | YES | MUL | ||
| CreatorID | char(36) | YES | |||
| OwnerID | char(36) | YES | |||
| GroupID | char(36) | YES | |||
| LastOwnerID | char(36) | YES | |||
| SceneGroupID | char(36) | YES | |||
| PayPrice | int(11) | NO | 0 | ||
| PayButton1 | int(11) | NO | 0 | ||
| PayButton2 | int(11) | NO | 0 | ||
| PayButton3 | int(11) | NO | 0 | ||
| PayButton4 | int(11) | NO | 0 | ||
| LoopedSound | char(36) | NO | 00000000-0000-0000-0000-000000000000 | ||
| LoopedSoundGain | double | NO | 0 | ||
| TextureAnnimation | blob | YES | |||
| OmegaX | double | NO | 0 | ||
| OmegaY | double | NO | 0 | ||
| OmegaZ | double | NO | 0 | ||
| CameraEyeOffsetX | double | NO | 0 | ||
| CameraEyeOffsetY | double | NO | 0 | ||
| CameraEyeOffsetZ | double | NO | 0 | ||
| CameraAtOffsetX | double | NO | 0 | ||
| CameraAtOffsetY | double | NO | 0 | ||
| CameraAtOffsetZ | double | NO | 0 | ||
| ForceMouselook | tinyint(4) | NO | 0 | ||
| ScriptAccessPin | int(11) | NO | 0 | ||
| AllowedDrop | tinyint(4) | NO | 0 | ||
| DieAtEdge | tinyint(4) | NO | 0 | ||
| SalePrice | int(11) | NO | 0 | ||
| SaleType | tinyint(4) | NO | 0 | ||
| ColorR | int(11) | NO | 0 | ||
| ColorG | int(11) | NO | 0 | ||
| ColorB | int(11) | NO | 0 | ||
| ColorA | int(11) | NO | 0 | ||
| ParticleSystem | blob | YES | |||
| ClickAction | tinyint(4) | NO | 0 | ||
| Material | tinyint(4) | NO | 3 | ||
| CollisionSound | char(36) | NO | 00000000-0000-0000-0000-000000000000 | ||
| CollisionSoundVolume | double | NO | 0 | ||
| LinkNumber | int(11) | NO | 0 |
(back to Database Documentation)
CreationDate
The date in standard UNIX format that the Prim was created.
Name
The Name of the Prim.
Text
Description
What the Prim is.
SitName
A name given to the Sit event.
TouchName
A name given to the Touch action.
SitName
A name given to the Sit event.
ObjectFlags
ObjectFlags are defined here: OpenSim:Permissions#ObjectFlags_.28F.29
OwnerMask
The permissions of the current owner. Further details are available here: OpenSim:Permissions#OwnerMask_.28O.29
NextOwnerMasks
The permissions to be passed to the next owner. Further details are available here: OpenSim:Permissions#NextOwnerMask_.28N.29
GroupMask
GroupMask is not yet implemented. However further details are available here: OpenSim:Permissions#GroupMask_.28G.29
EveryoneMask
The permissions given to other users. Further details are available here: OpenSim:Permissions#EveryoneMask_.28E.29
BaseMask
The initial permissions given to the current owner. Further details are available here: OpenSim:Permissions#BaseMask_.28B.29
PositionX
Not yet defined.
PositionY
Not yet defined.
PositionZ
Not yet defined.
VelocityX
Not yet defined.
VelocityY
Not yet defined.
VelocityZ
Not yet defined.
AngularVelocityX
Not yet defined.
AngularVelocityY
Not yet defined.
AngularVelocityZ
Not yet defined.
AccelerationX
Not yet defined.
AccelerationY
Not yet defined.
AccelerationZ
Not yet defined.
RotationX
Not yet defined.
RotationY
Not yet defined.
RotationZ
Not yet defined.
RotationW
Not yet defined.
SitTargetOffsetX
Not yet defined.
SitTargetOffsetY
Not yet defined.
SitTargetOffsetZ
Not yet defined.
UUID
The unique key of this prim row on the database.
RegionUUID
The key of the Region on the Regions table which contains this prim
CreatorID
the UUID (key) of the user who created this prim.
OwnerID
the UUID (key)of the user who currently owns this prim.
GroupID
Not yet defined.
LastOwnerID
The UUID (key) of the user who last owned this prim (i.e. who transferred it to the current OwnerID).
SceneGroupID
Not yet defined.
PayPrice
Can be either:
-1 PAY_HIDE or -2 PAY_DEFAULT
PayButton1
Can be either:
-1 PAY_HIDE or -2 PAY_DEFAULT
PayButton2
Can be either:
-1 PAY_HIDE or -2 PAY_DEFAULT
PayButton3
Can be either:
-1 PAY_HIDE or -2 PAY_DEFAULT
PayButton4
Can be either:
-1 PAY_HIDE or -2 PAY_DEFAULT
LoopedSound
The UUID of an asset which defines a sound to be played from this prim.
LoopedSoundGain
The volume of the looped sound.
TextureAnnimation
Not yet defined.
OmegaX
Not yet defined.
OmegaY
Not yet defined.
OmegaZ
Not yet defined.
CameraEyeOffsetX
Not yet defined.
CameraEyeOffsetY
Not yet defined.
CameraEyeOffsetZ
Not yet defined.
CameraAtOffsetX
Not yet defined.
CameraAtOffsetY
Not yet defined.
CameraAtOffsetZ
Not yet defined.
ForceMouseLook
Not yet defined.
ScriptAccessPin
Not yet defined.
AllowedDrop
Not yet defined.
DieAtEdge
Not yet defined.
SalePrice
Not yet defined.
SaleType
Not yet defined.
ColorR
Not yet defined.
ColorG
Not yet defined.
ColorB
Not yet defined.
ColorA
Not yet defined.
ParticleSystem
A block of data defining a particle effect associated with this Prim.
ClickAction
Not yet defined.
Material
Not yet defined.
CollisionSound
The sound made when an object collides with this prim.
CollisionSoundVolume
The volume of the collision sound.
LinkNumber
Not yet defined.
(back to Database Documentation)
