Prims (database table)

From OpenSimulator

Revision as of 10:31, 10 March 2011 by Kcozens (Talk | contribs)

Jump to: navigation, search


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
TypeNullKeyDefaultExtra
 
CreationDateint(11)YES
Namevarchar(255)YES
Textvarchar(255)YES
Descriptionvarchar(255)YES
SitNamevarchar(255)YES
TouchNamevarchar(255)YES
ObjectFlagsint(11)YES
OwnerMaskint(11)YES
nextOwnerMaskint(11)YES
GroupMaskint(11)YES
EveryoneMaskint(11)YES
BaseMaskint(11)YES
PositionXdoubleYES
PositionYdoubleYES
PositionZdoubleYES
GroupPositionXdoubleYES
GroupPositionYdoubleYES
GroupPositionZdoubleYES
VelocityXdoubleYES
VelocityYdoubleYES
VelocityZdoubleYES
AngularVelocityXdoubleYES
AngularVelocityYdoubleYES
AngularVelocityZdoubleYES
AccelerationXdoubleYES
AccelerationYdoubleYES
AccelerationZdoubleYES
RotationXdoubleYES
RotationYdoubleYES
RotationZdoubleYES
RotationWdoubleYES
SitTargetOffsetXdoubleYES
SitTargetOffsetYdoubleYES
SitTargetOffsetZdoubleYES
UUIDchar(36)NOPRI
RegionUUIDchar(36)YESMUL
CreatorIDchar(36)YES
OwnerIDchar(36)YES
GroupIDchar(36)YES
LastOwnerIDchar(36)YES
SceneGroupIDchar(36)YES
PayPriceint(11)NO0
PayButton1int(11)NO0
PayButton2int(11)NO0
PayButton3int(11)NO0
PayButton4int(11)NO0
LoopedSoundchar(36)NO00000000-0000-0000-0000-000000000000
LoopedSoundGaindoubleNO0
TextureAnnimationblobYES
OmegaXdoubleNO0
OmegaYdoubleNO0
OmegaZdoubleNO0
CameraEyeOffsetXdoubleNO0
CameraEyeOffsetYdoubleNO0
CameraEyeOffsetZdoubleNO0
CameraAtOffsetXdoubleNO0
CameraAtOffsetYdoubleNO0
CameraAtOffsetZdoubleNO0
ForceMouselooktinyint(4)NO0
ScriptAccessPinint(11)NO0
AllowedDroptinyint(4)NO0
DieAtEdgetinyint(4)NO0
SalePriceint(11)NO0
SaleTypetinyint(4)NO0
ColorRint(11)NO0
ColorGint(11)NO0
ColorBint(11)NO0
ColorAint(11)NO0
ParticleSystemblobYES
ClickActiontinyint(4)NO0
Materialtinyint(4)NO3
CollisionSoundchar(36)NO00000000-0000-0000-0000-000000000000
CollisionSoundVolumedoubleNO0
LinkNumberint(11)NO0


      (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
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.

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
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.


      (back to Database Documentation)

Personal tools
General
About This Wiki