Prims (database table)

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
Line 86: Line 86:
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(back to [[Database Documentation]])<br>
 
<hr>
 
<hr>
 
 
 
<br>
 
<br>
 +
'''CreationDate'''
 
<br>
 
<br>
 +
The date in standard UNIX format that the Prim was created.
 +
<br>
 +
<br>
 +
<b><i>Further Field descriptions will be added as time permits (there are quite alot of them)</i></b>
 +
 
<hr>
 
<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]]

Revision as of 11:00, 24 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
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.

Further Field descriptions will be added as time permits (there are quite alot of them)


      (back to Database Documentation)

Personal tools
General
About This Wiki