Prims (database table)
From OpenSimulator
(Difference between revisions)
| Line 66: | Line 66: | ||
<tr><td>CameraAtOffsetY</td><td>double</td><td>NO</td><td></td><td>0</td><td></td></tr> | <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> | <tr><td>CameraAtOffsetZ</td><td>double</td><td>NO</td><td></td><td>0</td><td></td></tr> | ||
| + | <tr><td>ForceMouselook</td><td>tinyint(4)</td><td>NO</td><td></td><td>0</td><td></td></tr> | ||
| + | <tr><td>ScriptAccessPin</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td></td></tr> | ||
| + | <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> | ||
| + | <tr><td>SalePrice</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td></td></tr> | ||
| + | <tr><td>SaleType</td><td>tinyint(4)</td><td>NO</td><td></td><td>0</td><td></td></tr> | ||
| + | <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> | ||
| + | <tr><td>ColorB</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td></td></tr> | ||
| + | <tr><td>ColorA</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td></td></tr> | ||
| + | <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> | ||
| + | <tr><td>Material</td><td>tinyint(4)</td><td>NO</td><td></td><td>3</td><td></td></tr> | ||
| + | <tr><td>CollisionSound</td><td>char(36)</td><td>NO</td><td></td><td>00000000-0000-0000-0000-000000000000</td><td></td></tr> | ||
| + | <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> | ||
</table> | </table> | ||
<br> | <br> | ||
(back to [[Database Documentation]])<br> | (back to [[Database Documentation]])<br> | ||
<hr> | <hr> | ||
| + | |||
| + | |||
<br> | <br> | ||
<br> | <br> | ||
Revision as of 09:54, 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 | 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)
(back to Database Documentation)
