Prims (database table)

From OpenSimulator

(Difference between revisions)
Jump to: navigation, search
(New page: Category:Database '''Prims''' ''Describes all Prim attributes except shape and content ''      (back to Database Documentation) <br><br> The current ...)
 
Line 38: Line 38:
 
<tr><td>RotationY</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
 
<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>
 
<tr><td>RotationZ</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
 +
<tr><td>RotationW</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
 +
<tr><td>SitTargetOffsetX</td><td>double</td><td>YES</td><td></td><td></td><td></td></tr>
 +
<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>
 +
<tr><td>UUID</td><td>char(36)</td><td>NO</td><td>PRI</td><td></td><td></td></tr>
 +
<tr><td>RegionUUID</td><td>char(36)</td><td>YES</td><td>MUL</td><td></td><td></td></tr>
 +
<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>
 +
<tr><td>GroupID</td><td>char(36)</td><td>YES</td><td></td><td></td><td></td></tr>
 +
<tr><td>LastOwnerID</td><td>char(36)</td><td>YES</td><td></td><td></td><td></td></tr>
 +
<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>YES</td><td></td><td></td><td></td></tr>
 +
<tr><td>PayButton1</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
 +
<tr><td>PayButton2</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
 +
<tr><td>PayButton3</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
 +
<tr><td>PayButton4</td><td>int(11)</td><td>YES</td><td></td><td></td><td></td></tr>
 
</table>
 
</table>
 
<br>
 
<br>

Revision as of 10:36, 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)YES
PayButton1int(11)YES
PayButton2int(11)YES
PayButton3int(11)YES
PayButton4int(11)YES


      (back to Database Documentation)





      (back to Database Documentation)

Personal tools
General
About This Wiki