Prims (database table)
From OpenSimulator
| Line 95: | Line 95: | ||
<br> | <br> | ||
The Name of the Prim. | The Name of the Prim. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>Text</b> | ||
| + | <br> | ||
| + | | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>Description</b> | ||
| + | <br> | ||
| + | What the Prim is. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>SitName</b> | ||
| + | <br> | ||
| + | A name given to the Sit event. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>TouchName</b> | ||
| + | <br> | ||
| + | A name given to the Touch action. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>SitName</b> | ||
| + | <br> | ||
| + | A name given to the Sit event. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>ObjectFlags</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>OwnerMask</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>NextOwnerMasks</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>GroupMask</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>EveryoneMask</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>BaseMask</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>PositionX</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>PositionY</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>PositionZ</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>VelocityX</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>VelocityY</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>VelocityZ</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>AngularVelocityX</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>AngularVelocityY</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>AngularVelocityZ</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>AccelerationX</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>AccelerationY</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>AccelerationZ</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>RotationX</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>RotationY</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>RotationZ</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>RotationW</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>SitTargetOffsetX</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>SitTargetOffsetY</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>SitTargetOffsetZ</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>UUID</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>RegionUUID</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>CreatorID</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>OwnerID</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>GroupID</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>LastOwnerID</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>SceneGroupID</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>PayPrice</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>PayButton1</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>PayButton2</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>PayButton3</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>PayButton4</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>LoopedSound</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>LoopedSoundGain</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>TextureAnnimation</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>OmegaX</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>OmegaY</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>OmegaZ</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>CameraEyeOffsetX</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>CameraEyeOffsetY</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>CameraEyeOffsetZ</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>CameraAtOffsetX</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>CameraAtOffsetY</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>CameraAtOffsetZ</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>ForceMouseLook</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>ScriptAccessPin</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>AllowedDrop</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>DieAtEdge</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>SalePrice</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>SaleType</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>ColorR</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>ColorG</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>ColorB</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>ColorA</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>ParticleSystem</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>ClickAction</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>Material</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>CollisionSound</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>CollicionSoundVolume</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
| + | <br> | ||
| + | <br> | ||
| + | <b>LinkNumber</b> | ||
| + | <br> | ||
| + | Not yet defined. | ||
<br> | <br> | ||
<br> | <br> | ||
Revision as of 02:18, 25 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)
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
Not yet defined.
OwnerMask
Not yet defined.
NextOwnerMasks
Not yet defined.
GroupMask
Not yet defined.
EveryoneMask
Not yet defined.
BaseMask
Not yet defined.
PositionX
Not yet defined.
PositionY
Not yet defined.
PositionZ
Not yet defined.
VelocityX
Not yet defined.
VelocityY
Not yet defined.
VelocityZ
Not yet defined.
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
Not yet defined.
RegionUUID
Not yet defined.
CreatorID
Not yet defined.
OwnerID
Not yet defined.
GroupID
Not yet defined.
LastOwnerID
Not yet defined.
SceneGroupID
Not yet defined.
PayPrice
Not yet defined.
PayButton1
Not yet defined.
PayButton2
Not yet defined.
PayButton3
Not yet defined.
PayButton4
Not yet defined.
LoopedSound
Not yet defined.
LoopedSoundGain
Not yet defined.
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
Not yet defined.
ColorG
Not yet defined.
ColorB
Not yet defined.
ColorA
Not yet defined.
ParticleSystem
Not yet defined.
ClickAction
Not yet defined.
Material
Not yet defined.
CollisionSound
Not yet defined.
CollicionSoundVolume
Not yet defined.
LinkNumber
Not yet defined.
Further Field descriptions will be added as time permits (there are quite alot of them)
(back to Database Documentation)
