Prims (database table)
From OpenSimulator
(Difference between revisions)
| Line 49: | Line 49: | ||
<tr><td>LastOwnerID</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>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> | + | <tr><td>PayPrice</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td></td></tr> |
| − | <tr><td>PayButton1</td><td>int(11)</td><td> | + | <tr><td>PayButton1</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td></td></tr> |
| − | <tr><td>PayButton2</td><td>int(11)</td><td> | + | <tr><td>PayButton2</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td></td></tr> |
| − | <tr><td>PayButton3</td><td>int(11)</td><td> | + | <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>YES</td><td></td><td></td><td></td></tr> | + | <tr><td>PayButton4</td><td>int(11)</td><td>NO</td><td></td><td>0</td><td></td></tr> |
| + | <tr><td>LoopedSound</td><td>char(36)</td><td>NO</td><td></td><td>00000000-0000-0000-0000-000000000000</td><td></td></tr> | ||
| + | <tr><td>LoopedSoundGain</td><td>double</td><td>NO</td><td></td><td>0</td><td></td></tr> | ||
| + | <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> | ||
| + | <tr><td>OmegaY</td><td>double</td><td>NO</td><td></td><td>0</td><td></td></tr> | ||
| + | <tr><td>OmegaZ</td><td>double</td><td>NO</td><td></td><td>0</td><td></td></tr> | ||
| + | <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> | ||
| + | <tr><td>CameraEyeOffsetZ</td><td>double</td><td>NO</td><td></td><td>0</td><td></td></tr> | ||
| + | <tr><td>CameraAtOffsetX</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> | ||
</table> | </table> | ||
<br> | <br> | ||
Revision as of 09:45, 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 |
(back to Database Documentation)
(back to Database Documentation)
