Prims (database table)

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
 
(13 intermediate revisions by 8 users not shown)
Line 1: Line 1:
[[Category:Database]]
+
__NOTOC__
 +
{{Quicklinks}}
 +
<br />
  
'''Prims''' ''Describes all Prim attributes except shape and content ''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
+
'''Prims''' ''Describes all rezzed prim attributes except shape and content ''&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])
<br><br>
+
<br /><br />
The current structure of the Prims table is as follows:<br>
+
The current structure of the Prims table is as follows:<br />
<br>
+
{| style="border:1px solid #ccc;"
<table>
+
|- style="background:#cce;"
<tr><td>Field<br></td><td>Type</td><td>Null</td><td>Key</td><td>Default</td><td>Extra</td></tr>
+
! Field
<tr><td>&nbsp;</td></tr>
+
! Type
<tr><td>CreationDate</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>Text</td><td>varchar(255)</td><td>YES</td><td></td><td></td><td></td></tr>
+
! Default
<tr><td>Description</td><td>varchar(255)</td><td>YES</td><td></td><td></td><td></td></tr>
+
! Extra
<tr><td>SitName</td><td>varchar(255)</td><td>YES</td><td></td><td></td><td></td></tr>
+
|-
<tr><td>TouchName</td><td>varchar(255)</td><td>YES</td><td></td><td></td><td></td></tr>
+
| CreationDate         || int(11)     || YES ||    || NULL                                ||
<tr><td>ObjectFlags</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
+
|- style="background:#eee;"
<tr><td>OwnerMask</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
+
| Name                 || varchar(255) || YES ||    || NULL                                ||
<tr><td>nextOwnerMask</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
+
|-
<tr><td>GroupMask</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
+
| Text                 || varchar(255) || YES ||    || NULL                                ||
<tr><td>EveryoneMask</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
+
|- style="background:#eee;"
<tr><td>BaseMask</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
+
| Description         || varchar(255) || YES ||    || NULL                                ||
<tr><td>PositionX</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
+
|-
<tr><td>PositionY</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
+
| SitName             || varchar(255) || YES ||    || NULL                                ||
<tr><td>PositionZ</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
+
|- style="background:#eee;"
<tr><td>GroupPositionX</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
+
| TouchName           || varchar(255) || YES ||    || NULL                                ||
<tr><td>GroupPositionY</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
+
|-
<tr><td>GroupPositionZ</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
+
| ObjectFlags         || int(11)     || YES ||    || NULL                                ||
<tr><td>VelocityX</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
+
|- style="background:#eee;"
<tr><td>VelocityY</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
+
| OwnerMask           || int(11)     || YES ||    || NULL                                ||
<tr><td>VelocityZ</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
+
|-
<tr><td>AngularVelocityX</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
+
| NextOwnerMask        || int(11)     || YES ||    || NULL                                ||
<tr><td>AngularVelocityY</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
+
|- style="background:#eee;"
<tr><td>AngularVelocityZ</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
+
| GroupMask           || int(11)     || YES ||    || NULL                                ||
<tr><td>AccelerationX</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
+
|-
<tr><td>AccelerationY</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
+
| EveryoneMask         || int(11)     || YES ||    || NULL                                ||
<tr><td>AccelerationZ</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
+
|- style="background:#eee;"
<tr><td>RotationX</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
+
| BaseMask             || int(11)     || YES ||    || NULL                                ||
<tr><td>RotationY</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
+
|-
<tr><td>RotationZ</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
+
| PositionX           || float        || YES ||    || 0.0                                  ||
<tr><td>RotationW</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
+
|- style="background:#eee;"
<tr><td>SitTargetOffsetX</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
+
| PositionY           || float        || YES ||    || 0.0                                  ||
<tr><td>SitTargetOffsetY</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
+
|-
<tr><td>SitTargetOffsetZ</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
+
| PositionZ           || float        || YES ||    || 0.0                                  ||
<tr><td>UUID</td><td>char(36)</td><td>NO</td><td>PRI</td><td></td><td></td></tr>
+
|- style="background:#eee;"
<tr><td>RegionUUID</td><td>char(36)</td><td>YES</td><td>MUL</td><td></td><td></td></tr>
+
| GroupPositionX       || float        || YES ||    || 0.0                                  ||
<tr><td>CreatorID</td><td>char(36)</td><td>YES</td><td></td><td></td><td></td></tr>
+
|-
<tr><td>OwnerID</td><td>char(36)</td><td>YES</td><td></td><td></td><td></td></tr>
+
| GroupPositionY       || float        || YES ||    || 0.0                                  ||
<tr><td>GroupID</td><td>char(36)</td><td>YES</td><td></td><td></td><td></td></tr>
+
|- style="background:#eee;"
<tr><td>LastOwnerID</td><td>char(36)</td><td>YES</td><td></td><td></td><td></td></tr>
+
| GroupPositionZ       || float        || YES ||    || 0.0                                  ||
<tr><td>SceneGroupID</td><td>char(36)</td><td>YES</td><td></td><td></td><td></td></tr>
+
|-
<tr><td>PayPrice</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
| VelocityX           || float        || YES ||    || 0.0                                  ||
<tr><td>PayButton1</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
|- style="background:#eee;"
<tr><td>PayButton2</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
| VelocityY           || float        || YES ||    || 0.0                                  ||
<tr><td>PayButton3</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
|-
<tr><td>PayButton4</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
| VelocityZ           || float        || YES ||    || 0.0                                  ||
<tr><td>LoopedSound</td><td>char(36)</td><td>NO</td><td></td><td>00000000-0000-0000-0000-000000000000</td><td></td></tr>
+
|- style="background:#eee;"
<tr><td>LoopedSoundGain</td><td>double</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
| AngularVelocityX     || float        || YES ||    || 0.0                                  ||
<tr><td>TextureAnnimation</td><td>blob</td><td>YES</td><td></td><td></td><td></td></tr>
+
|-
<tr><td>OmegaX</td><td>double</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
| AngularVelocityY     || float        || YES ||    || 0.0                                  ||
<tr><td>OmegaY</td><td>double</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
|- style="background:#eee;"
<tr><td>OmegaZ</td><td>double</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
| AngularVelocityZ     || float        || YES ||    || 0.0                                  ||
<tr><td>CameraEyeOffsetX</td><td>double</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
|-
<tr><td>CameraEyeOffsetY</td><td>double</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
| AccelerationX       || float        || YES ||    || 0.0                                  ||
<tr><td>CameraEyeOffsetZ</td><td>double</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
|- style="background:#eee;"
<tr><td>CameraAtOffsetX</td><td>double</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
| AccelerationY       || float        || YES ||    || 0.0                                  ||
<tr><td>CameraAtOffsetY</td><td>double</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
|-
<tr><td>CameraAtOffsetZ</td><td>double</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
| AccelerationZ       || float        || YES ||    || 0.0                                  ||
<tr><td>ForceMouselook</td><td>tinyint(4)</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
|- style="background:#eee;"
<tr><td>ScriptAccessPin</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
| RotationX           || float        || YES ||    || 0.0                                  ||
<tr><td>AllowedDrop</td><td>tinyint(4)</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
|-
<tr><td>DieAtEdge</td><td>tinyint(4)</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
| RotationY           || float        || YES ||    || 0.0                                  ||
<tr><td>SalePrice</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
|- style="background:#eee;"
<tr><td>SaleType</td><td>tinyint(4)</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
| RotationZ           || float        || YES ||    || 0.0                                  ||
<tr><td>ColorR</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
|-
<tr><td>ColorG</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
| RotationW           || float        || YES ||    || 0.0                                  ||
<tr><td>ColorB</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
|- style="background:#eee;"
<tr><td>ColorA</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
| SitTargetOffsetX     || float        || YES ||    || 0.0                                  ||
<tr><td>ParticleSystem</td><td>blob</td><td>YES</td><td></td><td></td><td></td></tr>
+
|-
<tr><td>ClickAction</td><td>tinyint(4)</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
| SitTargetOffsetY     || float        || YES ||    || 0.0                                  ||
<tr><td>Material</td><td>tinyint(4)</td><td>NO</td><td></td><td>3</td><td></td></tr>
+
|- style="background:#eee;"
<tr><td>CollisionSound</td><td>char(36)</td><td>NO</td><td></td><td>00000000-0000-0000-0000-000000000000</td><td></td></tr>
+
| SitTargetOffsetZ     || float        || YES ||    || 0.0                                  ||
<tr><td>CollisionSoundVolume</td><td>double</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
|-
<tr><td>LinkNumber</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td></td></tr>
+
| SitTargetOrientW    || float        || YES  ||    || 0.0                                  ||
</table>
+
|- style="background:#eee;"
<br>
+
| SitTargetOrientX    || float        || YES  ||    || 0.0                                  ||
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+
|-
<hr>
+
| SitTargetOrientY    || float        || YES  ||    || 0.0                                  ||
<br>
+
|- style="background:#eee;"
 +
| SitTargetOrientZ    || float        || YES  ||    || 0.0                                  ||
 +
|-
 +
| UUID                 || char(36)     || NO   || PRI ||                                      ||
 +
|- style="background:#eee;"
 +
| RegionUUID           || char(36)     || YES || MUL || NULL                                ||
 +
|-
 +
| CreatorID           || varchar(255) || NO  ||    ||                                      ||
 +
|- style="background:#eee;"
 +
| OwnerID             || char(36)     || YES ||    || NULL                                ||
 +
|-
 +
| GroupID             || char(36)     || YES ||    || NULL                                ||
 +
|- style="background:#eee;"
 +
| LastOwnerID         || char(36)     || YES ||    || NULL                                ||
 +
|-
 +
| SceneGroupID         || char(36)     || YES || MUL || NULL                                ||
 +
|- style="background:#eee;"
 +
| PayPrice             || int(11)     || NO   ||    || 0                                   ||
 +
|-
 +
| PayButton1           || int(11)     || NO   ||    || 0                                   ||
 +
|- style="background:#eee;"
 +
| PayButton2           || int(11)     || NO   ||    || 0                                   ||
 +
|-
 +
| PayButton3           || int(11)     || NO   ||    || 0                                   ||
 +
|- style="background:#eee;"
 +
| PayButton4           || int(11)     || NO   ||    || 0                                   ||
 +
|-
 +
| LoopedSound         || char(36)     || NO   ||    || 00000000-0000-0000-0000-000000000000 ||
 +
|- style="background:#eee;"
 +
| LoopedSoundGain     || float        || NO   ||    || 0.0                                 ||
 +
|-
 +
| TextureAnimation    || blob         || YES ||    || NULL                                ||
 +
|- style="background:#eee;"
 +
| OmegaX               || float        || NO   ||    || 0.0                                 ||
 +
|-
 +
| OmegaY               || float        || NO   ||    || 0.0                                 ||
 +
|- style="background:#eee;"
 +
| OmegaZ               || float        || NO   ||    || 0.0                                  ||
 +
|-
 +
| CameraEyeOffsetX     || float        || NO   ||    || 0.0                                 ||
 +
|- style="background:#eee;"
 +
| CameraEyeOffsetY     || float        || NO   ||    || 0.0                                  ||
 +
|-
 +
| CameraEyeOffsetZ     || float        || NO   ||    || 0.0                                  ||
 +
|- style="background:#eee;"
 +
| CameraAtOffsetX     || float        || NO   ||    || 0.0                                  ||
 +
|-
 +
| CameraAtOffsetY     || float        || NO   ||    || 0.0                                  ||
 +
|- style="background:#eee;"
 +
| CameraAtOffsetZ     || float        || NO   ||    || 0.0                                  ||
 +
|-
 +
| ForceMouselook       || tinyint(4)   || NO   ||    || 0                                   ||
 +
|- style="background:#eee;"
 +
| ScriptAccessPin     || int(11)     || NO   ||    || 0                                   ||
 +
|-
 +
| AllowedDrop         || tinyint(4)   || NO   ||    || 0                                   ||
 +
|- style="background:#eee;"
 +
| DieAtEdge           || tinyint(4)   || NO   ||    || 0                                   ||
 +
|-
 +
| SalePrice           || int(11)     || NO   ||    || 10                                  ||
 +
|- style="background:#eee;"
 +
| SaleType             || tinyint(4)   || NO   ||    || 0                                   ||
 +
|-
 +
| ColorR               || int(11)     || NO   ||    || 0                                   ||
 +
|- style="background:#eee;"
 +
| ColorG               || int(11)     || NO   ||    || 0                                   ||
 +
|-
 +
| ColorB               || int(11)     || NO   ||    || 0                                   ||
 +
|- style="background:#eee;"
 +
| ColorA               || int(11)     || NO   ||    || 0                                   ||
 +
|-
 +
| ParticleSystem       || blob         || YES ||    || NULL                                ||
 +
|- style="background:#eee;"
 +
| ClickAction         || tinyint(4)   || NO   ||    || 0                                   ||
 +
|-
 +
| Material             || tinyint(4)   || NO   ||    || 3                                   ||
 +
|- style="background:#eee;"
 +
| CollisionSound       || char(36)     || NO   ||    || 00000000-0000-0000-0000-000000000000 ||
 +
|-
 +
| CollisionSoundVolume || float        || NO   ||    || 0.0                                 ||
 +
|- style="background:#eee;"
 +
| LinkNumber           || int(11)     || NO   ||    || 0                                   ||
 +
|-
 +
| PassTouches          || tinyint(4)  || NO  ||    || 0                                    ||
 +
|- style="background:#eee;"
 +
| MediaURL            || varchar(255) || YES  ||    || NULL                                ||
 +
|-
 +
| DynAttrs            || text        || YES  ||    || NULL                                ||
 +
|- style="background:#eee;"
 +
| PhysicsShapeType    || tinyint(4)  || NO  ||    || 0                                    ||
 +
|-
 +
| Density              || float        || NO  ||    || 1000.0                              ||
 +
|- style="background:#eee;"
 +
| GravityModifier      || float        || NO  ||    || 1.0                                  ||
 +
|-
 +
| Friction            || float        || NO  ||    || 0.6                                  ||
 +
|- style="background:#eee;"
 +
| Restitution          || float        || NO  ||    || 0.5                                  ||
 +
|-
 +
| KeyframeMotion      || blob        || YES  ||    || NULL                                ||
 +
|}<br />
 +
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br />
 +
----
 +
<br />
 
'''CreationDate'''
 
'''CreationDate'''
<br>
+
<br />
 
The date in standard UNIX format that the Prim was created.
 
The date in standard UNIX format that the Prim was created.
<br>
+
<br />
<br>
+
<br />
<b>Name</b>
+
'''Name'''
<br>
+
<br />
 
The Name of the Prim.
 
The Name of the Prim.
<br>
+
<br />
<br>
+
<br />
<b>Text</b>
+
'''Text'''
<br>
+
<br />
 
&nbsp;
 
&nbsp;
<br>
+
<br />
<br>
+
<br />
<b>Description</b>
+
'''Description'''
<br>
+
<br />
 
What the Prim is.
 
What the Prim is.
<br>
+
<br />
<br>
+
<br />
<b>SitName</b>
+
'''SitName'''
<br>
+
<br />
 
A name given to the Sit event.
 
A name given to the Sit event.
<br>
+
<br />
<br>
+
<br />
<b>TouchName</b>
+
'''TouchName'''
<br>
+
<br />
 
A name given to the Touch action.
 
A name given to the Touch action.
<br>
+
<br />
<br>
+
<br />
<b>SitName</b>
+
'''SitName'''
<br>
+
<br />
 
A name given to the Sit event.
 
A name given to the Sit event.
<br>
+
<br />
<br>
+
<br />
<b>ObjectFlags</b>
+
'''ObjectFlags'''
<br>
+
<br />
ObjectFlags are defined here: [[OpenSim:Permissions#ObjectFlags_.28F.29]]
+
ObjectFlags are defined here: [[OpenSimulator:Permissions#ObjectFlags_.28F.29]]
<br>
+
<br />
<br>
+
<br />
<b>OwnerMask</b>
+
'''OwnerMask'''
<br>
+
<br />
The permissions of the current owner. Further details are available here: [[OpenSim:Permissions#OwnerMask_.28O.29]]
+
The permissions of the current owner. Further details are available here: [[OpenSimulator:Permissions#OwnerMask_.28O.29]]
<br>
+
<br />
<br>
+
<br />
<b>NextOwnerMasks</b>
+
'''NextOwnerMasks'''
<br>
+
<br />
The permissions to be passed to the next owner. Further details are available here: [[OpenSim:Permissions#NextOwnerMask_.28N.29]]
+
The permissions to be passed to the next owner. Further details are available here: [[OpenSimulator:Permissions#NextOwnerMask_.28N.29]]
<br>
+
<br />
<br>
+
<br />
<b>GroupMask</b>
+
'''GroupMask'''
<br>
+
<br />
GroupMask is not yet implemented. However further details are available here: [[OpenSim:Permissions#GroupMask_.28G.29]]  
+
GroupMask is not yet implemented. However further details are available here: [[OpenSimulator:Permissions#GroupMask_.28G.29]]  
<br>
+
<br />
<br>
+
<br />
<b>EveryoneMask</b>
+
'''EveryoneMask'''
<br>
+
<br />
The permissions given to other users. Further details are available here: [[OpenSim:Permissions#EveryoneMask_.28E.29]]
+
The permissions given to other users. Further details are available here: [[OpenSimulator:Permissions#EveryoneMask_.28E.29]]
<br>
+
<br />
<br>
+
<br />
<b>BaseMask</b>
+
'''BaseMask'''
<br>
+
<br />
The initial permissions given to the current owner. Further details are available here: [[OpenSim:Permissions#BaseMask_.28B.29]]
+
The initial permissions given to the current owner. Further details are available here: [[OpenSimulator:Permissions#BaseMask_.28B.29]]
<br>
+
<br />
<br>
+
<br />
<b>PositionX</b>
+
'''PositionX'''
<br>
+
<br />
The location of the centre of the prim in the X-axis in metres relative to the origin of the region.
+
The distance in metres of this prim from GroupPositionX.
<br>
+
<br />
<br>
+
<br />
<b>PositionY</b>
+
'''PositionY'''
<br>
+
<br />
The location of the centre of the prim in the Y-axis in metres relative to the origin of the region.
+
The distance in metres of this prim from GroupPositionY.
<br>
+
<br />
<br>
+
<br />
<b>PositionZ</b>
+
'''PositionZ'''
<br>
+
<br />
The absolute height of the centre of the prim in metres.<br>
+
The distance in metres of this prim from GroupPositionZ.
<br>
+
<br />
<b>VelocityX</b>
+
'''GroupPositionX'''
<br>
+
<br />
 +
The X-axis location of the centre of the primary prim in the linked set to which this Prim belongs. Measured in metres relative to the origin of the region.
 +
<br />
 +
<br />
 +
'''GroupPositionY'''
 +
<br />
 +
The Y-axis location of the centre of the primary prim in the linked set to which this Prim belongs. Measured in metres relative to the origin of the region.
 +
<br />
 +
<br />
 +
'''GroupPositionZ'''
 +
<br />
 +
The Z-axis (height) location of the centre of the primary prim in the linked set to which this Prim belongs. Measured in metres.
 +
<br />
 +
'''VelocityX'''
 +
<br />
 
The speed at which the prim moves (+ or -) in the X-axis.
 
The speed at which the prim moves (+ or -) in the X-axis.
<br>
+
<br />
<br>
+
<br />
<b>VelocityY</b>
+
'''VelocityY'''
<br>
+
<br />
 
The speed at which the prim moves (+ or -) in the Y-axis.
 
The speed at which the prim moves (+ or -) in the Y-axis.
<br>
+
<br />
<br>
+
<br />
<b>VelocityZ</b>
+
'''VelocityZ'''
<br>
+
<br />
 
The speed at which the prim moves (+ or -) vertically.
 
The speed at which the prim moves (+ or -) vertically.
<br>
+
<br />
<br>
+
<br />
<b>AngularVelocityX</b>
+
'''AngularVelocityX'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>AngularVelocityY</b>
+
'''AngularVelocityY'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>AngularVelocityZ</b>
+
'''AngularVelocityZ'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>AccelerationX</b>
+
'''AccelerationX'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>AccelerationY</b>
+
'''AccelerationY'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>AccelerationZ</b>
+
'''AccelerationZ'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>RotationX</b>
+
'''RotationX'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>RotationY</b>
+
'''RotationY'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>RotationZ</b>
+
'''RotationZ'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>RotationW</b>
+
'''RotationW'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>SitTargetOffsetX</b>
+
'''SitTargetOffsetX'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>SitTargetOffsetY</b>
+
'''SitTargetOffsetY'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>SitTargetOffsetZ</b>
+
'''SitTargetOffsetZ'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>UUID</b>
+
'''SitTargetOrientW'''
<br>
+
<br />
 +
Not yet defined.
 +
<br />
 +
<br />
 +
'''SitTargetOrientX'''
 +
<br />
 +
Not yet defined.
 +
<br />
 +
<br />
 +
'''SitTargetOrientY'''
 +
<br />
 +
Not yet defined.
 +
<br />
 +
<br />
 +
'''SitTargetOrientZ'''
 +
<br />
 +
Not yet defined.
 +
<br />
 +
<br />
 +
'''UUID'''
 +
<br />
 
The unique key of this prim row on the database.
 
The unique key of this prim row on the database.
<br>
+
<br />
<br>
+
<br />
<b>RegionUUID</b>
+
'''RegionUUID'''
<br>
+
<br />
 
The key of the Region on the Regions table which contains this prim
 
The key of the Region on the Regions table which contains this prim
<br>
+
<br />
<br>
+
<br />
<b>CreatorID</b>
+
'''CreatorID'''
<br>
+
<br />
 
the UUID (key) of the user who created this prim.
 
the UUID (key) of the user who created this prim.
<br>
+
<br />
<br>
+
<br />
<b>OwnerID</b>
+
'''OwnerID'''
<br>
+
<br />
 
the UUID (key)of the user who currently owns this prim.
 
the UUID (key)of the user who currently owns this prim.
<br>
+
<br />
<br>
+
<br />
<b>GroupID</b>
+
'''GroupID'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>LastOwnerID</b>
+
'''LastOwnerID'''
<br>
+
<br />
 
The UUID (key) of the user who last owned this prim (i.e. who transferred it to the current OwnerID).
 
The UUID (key) of the user who last owned this prim (i.e. who transferred it to the current OwnerID).
<br>
+
<br />
<br>
+
<br />
<b>SceneGroupID</b>
+
'''SceneGroupID'''
<br>
+
<br />
Not yet defined.
+
All the prims in a linked object share the same SceneGroupID.
<br>
+
<br />
<br>
+
<br />
<b>PayPrice</b>
+
'''PayPrice'''
<br>
+
<br />
 
Can be either:
 
Can be either:
 
-1 PAY_HIDE or -2 PAY_DEFAULT
 
-1 PAY_HIDE or -2 PAY_DEFAULT
<br>
+
<br />
<br>
+
<br />
<b>PayButton1</b>
+
'''PayButton1'''
<br>
+
<br />
 
Can be either:
 
Can be either:
 
-1 PAY_HIDE or -2 PAY_DEFAULT
 
-1 PAY_HIDE or -2 PAY_DEFAULT
<br>
+
<br />
<br>
+
<br />
<b>PayButton2</b>
+
'''PayButton2'''
<br>
+
<br />
 
Can be either:
 
Can be either:
 
-1 PAY_HIDE or -2 PAY_DEFAULT
 
-1 PAY_HIDE or -2 PAY_DEFAULT
<br>
+
<br />
<br>
+
<br />
<b>PayButton3</b>
+
'''PayButton3'''
<br>
+
<br />
 
Can be either:
 
Can be either:
 
-1 PAY_HIDE or -2 PAY_DEFAULT
 
-1 PAY_HIDE or -2 PAY_DEFAULT
<br>
+
<br />
<br>
+
<br />
<b>PayButton4</b>
+
'''PayButton4'''
<br>
+
<br />
 
Can be either:
 
Can be either:
 
-1 PAY_HIDE or -2 PAY_DEFAULT
 
-1 PAY_HIDE or -2 PAY_DEFAULT
<br>
+
<br />
<br>
+
<br />
<b>LoopedSound</b>
+
'''LoopedSound'''
<br>
+
<br />
 
The UUID of an asset which defines a sound to be played from this prim.
 
The UUID of an asset which defines a sound to be played from this prim.
<br>
+
<br />
<br>
+
<br />
<b>LoopedSoundGain</b>
+
'''LoopedSoundGain'''
<br>
+
<br />
 
The volume of the looped sound.
 
The volume of the looped sound.
<br>
+
<br />
<br>
+
<br />
<b>TextureAnnimation</b>
+
'''TextureAnnimation'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>OmegaX</b>
+
'''OmegaX'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>OmegaY</b>
+
'''OmegaY'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>OmegaZ</b>
+
'''OmegaZ'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>CameraEyeOffsetX</b>
+
'''CameraEyeOffsetX'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>CameraEyeOffsetY</b>
+
'''CameraEyeOffsetY'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>CameraEyeOffsetZ</b>
+
'''CameraEyeOffsetZ'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>CameraAtOffsetX</b>
+
'''CameraAtOffsetX'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>CameraAtOffsetY</b>
+
'''CameraAtOffsetY'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>CameraAtOffsetZ</b>
+
'''CameraAtOffsetZ'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>ForceMouseLook</b>
+
'''ForceMouseLook'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>ScriptAccessPin</b>
+
'''ScriptAccessPin'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>AllowedDrop</b>
+
'''AllowedDrop'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>DieAtEdge</b>
+
'''DieAtEdge'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>SalePrice</b>
+
'''SalePrice'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>SaleType</b>
+
'''SaleType'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>ColorR</b>
+
'''ColorR'''
<br>
+
<br />
 +
Red colour intensity value range 0-255.
 +
<br />
 +
<br />
 +
'''ColorG'''
 +
<br />
 +
Green colour intensity value range 0-255.
 +
<br />
 +
<br />
 +
'''ColorB'''
 +
<br />
 +
Blue colour intensity value range 0-255.
 +
<br />
 +
<br />
 +
'''ColorA'''
 +
<br />
 +
Alpha channel value. Range 0-255.
 +
<br />
 +
<br />
 +
'''ParticleSystem'''
 +
<br />
 +
A block of data defining a particle effect associated with this Prim.
 +
<br />
 +
<br />
 +
'''ClickAction'''
 +
<br />
 +
Action to be performed on a left-button mouse click. Possible values:<br />
 +
&nbsp;&nbsp;0 - Touch/Grab (default)<br />
 +
&nbsp;&nbsp;1 - Sit on object<br />
 +
&nbsp;&nbsp;2 - Buy object<br />
 +
&nbsp;&nbsp;3 - Pay object<br />
 +
&nbsp;&nbsp;4 - Open<br />
 +
&nbsp;&nbsp;5 - Play parcel media<br />
 +
&nbsp;&nbsp;6 - Open parcel media
 +
<br />
 +
<br />
 +
'''Material'''
 +
<br />
 +
Affects the surface look of the prim, may be wood, metal etc.
 +
<br />
 +
<br />
 +
'''CollisionSound'''
 +
<br />
 +
The UUID of the asset which describes the sound made when an object collides with this prim.
 +
<br />
 +
<br />
 +
'''CollisionSoundVolume'''
 +
<br />
 +
The volume of the collision sound.
 +
<br />
 +
<br />
 +
'''LinkNumber'''
 +
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>ColorG</b>
+
'''PassTouches'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>ColorB</b>
+
'''MediaURL'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>ColorA</b>
+
'''DynAttrs'''
<br>
+
<br />
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>ParticleSystem</b>
+
'''PhysicsShapeType'''
<br>
+
<br />
A block of data defining a particle effect associated with this Prim.
+
<br>
+
<br>
+
<b>ClickAction</b>
+
<br>
+
Action to be performed on a left-button mouse click. Possible values:<br>
+
&nbsp;&nbsp;0 - Touch/Grab (default)<br>
+
&nbsp;&nbsp;1 - Sit on object<br>
+
&nbsp;&nbsp;2 - Buy object<br>
+
&nbsp;&nbsp;3 - Pay object<br>
+
&nbsp;&nbsp;4 - Open<br>
+
&nbsp;&nbsp;5 - Play parcel media<br>
+
&nbsp;&nbsp;6 - Open parcel media
+
<br>
+
<br>
+
<b>Material</b>
+
<br>
+
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<b>CollisionSound</b>
+
'''Density'''
<br>
+
<br />
The sound made when an object collides with this prim.
+
<br>
+
<br>
+
<b>CollisionSoundVolume</b>
+
<br>
+
The volume of the collision sound.
+
<br>
+
<br>
+
<b>LinkNumber</b>
+
<br>
+
 
Not yet defined.
 
Not yet defined.
<br>
+
<br />
<br>
+
<br />
<hr>
+
'''GravityModifier'''
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
+
<br />
 +
Not yet defined.
 +
<br />
 +
<br />
 +
'''Friction'''
 +
<br />
 +
Not yet defined.
 +
<br />
 +
<br />
 +
'''Restitution'''
 +
<br />
 +
Not yet defined.
 +
<br />
 +
<br />
 +
'''KeyframeMotion'''
 +
<br />
 +
Not yet defined.
 +
<br />
 +
<br />
 +
----
 +
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br />
 +
 
 +
[[Category:Database]]
 
[[Category:Database]]
 
[[Category:Database]]

Latest revision as of 13:08, 14 November 2023


Prims Describes all rezzed 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 NULL
Name varchar(255) YES NULL
Text varchar(255) YES NULL
Description varchar(255) YES NULL
SitName varchar(255) YES NULL
TouchName varchar(255) YES NULL
ObjectFlags int(11) YES NULL
OwnerMask int(11) YES NULL
NextOwnerMask int(11) YES NULL
GroupMask int(11) YES NULL
EveryoneMask int(11) YES NULL
BaseMask int(11) YES NULL
PositionX float YES 0.0
PositionY float YES 0.0
PositionZ float YES 0.0
GroupPositionX float YES 0.0
GroupPositionY float YES 0.0
GroupPositionZ float YES 0.0
VelocityX float YES 0.0
VelocityY float YES 0.0
VelocityZ float YES 0.0
AngularVelocityX float YES 0.0
AngularVelocityY float YES 0.0
AngularVelocityZ float YES 0.0
AccelerationX float YES 0.0
AccelerationY float YES 0.0
AccelerationZ float YES 0.0
RotationX float YES 0.0
RotationY float YES 0.0
RotationZ float YES 0.0
RotationW float YES 0.0
SitTargetOffsetX float YES 0.0
SitTargetOffsetY float YES 0.0
SitTargetOffsetZ float YES 0.0
SitTargetOrientW float YES 0.0
SitTargetOrientX float YES 0.0
SitTargetOrientY float YES 0.0
SitTargetOrientZ float YES 0.0
UUID char(36) NO PRI
RegionUUID char(36) YES MUL NULL
CreatorID varchar(255) NO
OwnerID char(36) YES NULL
GroupID char(36) YES NULL
LastOwnerID char(36) YES NULL
SceneGroupID char(36) YES MUL NULL
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 float NO 0.0
TextureAnimation blob YES NULL
OmegaX float NO 0.0
OmegaY float NO 0.0
OmegaZ float NO 0.0
CameraEyeOffsetX float NO 0.0
CameraEyeOffsetY float NO 0.0
CameraEyeOffsetZ float NO 0.0
CameraAtOffsetX float NO 0.0
CameraAtOffsetY float NO 0.0
CameraAtOffsetZ float NO 0.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 10
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 NULL
ClickAction tinyint(4) NO 0
Material tinyint(4) NO 3
CollisionSound char(36) NO 00000000-0000-0000-0000-000000000000
CollisionSoundVolume float NO 0.0
LinkNumber int(11) NO 0
PassTouches tinyint(4) NO 0
MediaURL varchar(255) YES NULL
DynAttrs text YES NULL
PhysicsShapeType tinyint(4) NO 0
Density float NO 1000.0
GravityModifier float NO 1.0
Friction float NO 0.6
Restitution float NO 0.5
KeyframeMotion blob YES NULL

      (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: OpenSimulator:Permissions#ObjectFlags_.28F.29

OwnerMask
The permissions of the current owner. Further details are available here: OpenSimulator:Permissions#OwnerMask_.28O.29

NextOwnerMasks
The permissions to be passed to the next owner. Further details are available here: OpenSimulator:Permissions#NextOwnerMask_.28N.29

GroupMask
GroupMask is not yet implemented. However further details are available here: OpenSimulator:Permissions#GroupMask_.28G.29

EveryoneMask
The permissions given to other users. Further details are available here: OpenSimulator:Permissions#EveryoneMask_.28E.29

BaseMask
The initial permissions given to the current owner. Further details are available here: OpenSimulator:Permissions#BaseMask_.28B.29

PositionX
The distance in metres of this prim from GroupPositionX.

PositionY
The distance in metres of this prim from GroupPositionY.

PositionZ
The distance in metres of this prim from GroupPositionZ.
GroupPositionX
The X-axis location of the centre of the primary prim in the linked set to which this Prim belongs. Measured in metres relative to the origin of the region.

GroupPositionY
The Y-axis location of the centre of the primary prim in the linked set to which this Prim belongs. Measured in metres relative to the origin of the region.

GroupPositionZ
The Z-axis (height) location of the centre of the primary prim in the linked set to which this Prim belongs. Measured in metres.
VelocityX
The speed at which the prim moves (+ or -) in the X-axis.

VelocityY
The speed at which the prim moves (+ or -) in the Y-axis.

VelocityZ
The speed at which the prim moves (+ or -) vertically.

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.

SitTargetOrientW
Not yet defined.

SitTargetOrientX
Not yet defined.

SitTargetOrientY
Not yet defined.

SitTargetOrientZ
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
All the prims in a linked object share the same SceneGroupID.

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
Red colour intensity value range 0-255.

ColorG
Green colour intensity value range 0-255.

ColorB
Blue colour intensity value range 0-255.

ColorA
Alpha channel value. Range 0-255.

ParticleSystem
A block of data defining a particle effect associated with this Prim.

ClickAction
Action to be performed on a left-button mouse click. Possible values:
  0 - Touch/Grab (default)
  1 - Sit on object
  2 - Buy object
  3 - Pay object
  4 - Open
  5 - Play parcel media
  6 - Open parcel media

Material
Affects the surface look of the prim, may be wood, metal etc.

CollisionSound
The UUID of the asset which describes the sound made when an object collides with this prim.

CollisionSoundVolume
The volume of the collision sound.

LinkNumber
Not yet defined.

PassTouches
Not yet defined.

MediaURL
Not yet defined.

DynAttrs
Not yet defined.

PhysicsShapeType
Not yet defined.

Density
Not yet defined.

GravityModifier
Not yet defined.

Friction
Not yet defined.

Restitution
Not yet defined.

KeyframeMotion
Not yet defined.


      (back to Database Documentation)

Personal tools
General
About This Wiki