Database:Primshapes

From OpenSimulator

Jump to: navigation, search


Primshapes Describes prim shapes, colors and textures       (back to Database Documentation)

The current structure of the Prims table is as follows:

Field Type Null Key Default Extra
Shape int(11) YES NULL
ScaleX double NO 0
ScaleY double NO 0
ScaleZ double NO 0
PCode int(11) YES NULL
PathBegin int(11) YES NULL
PathEnd int(11) YES NULL
PathScaleX int(11) YES NULL
PathScaleY int(11) YES NULL
PathShearX int(11) YES NULL
PathShearY int(11) YES NULL
PathSkew int(11) YES NULL
PathCurve int(11) YES NULL
PathRadiusOffset int(11) YES NULL
PathRevolutions int(11) YES NULL
PathTaperX int(11) YES NULL
PathTaperY int(11) YES NULL
PathTwist int(11) YES NULL
PathTwistBegin int(11) YES NULL
ProfileBegin int(11) YES NULL
ProfileEnd int(11) YES NULL
ProfileCurve int(11) YES NULL
ProfileHollow int(11) YES NULL
State int(11) YES NULL
Texture longblob YES NULL
ExtraParams longblob YES NULL
UUID char(36) NO PRI
Media text YES NULL

      (back to Database Documentation)




ScaleX ScaleY Scalez
The size of the prim in meters.


ProfileHollow
The percent size of the hole in the prim. Divide this integer by 500.0 to get the number you see in the build dialog.


Texture
Contains a list of up to 8 texture asset UUIDs for the 8 faces of the prim. If all the faces are the same only one UUID is present. Each UUID is stored as 16 BINARY bytes (not as hex strings) and must be converted to strings to use to search the asset table. Each UUID is followed by a single byte related to the face number that texture is on. Face 0 must always be last and has a face number 0 which terminates the list. 16 or more bytes follow the last texture assetUUID and these contain ????


ExtraParams
Contains different data for each prim type.
If the first byte is 0 there are no more ExtraParams.
If the first byte is 1 then you look at the next byte, it's meaning is:
FlexiEP = 0x10;
LightEP = 0x20;
SculptEP = 0x30;
ProjectionEP = 0x40;
MeshFlagsEP = 0x70;
On sculpts, the next 5 bytes have fixed constants: 00 11 00 00 00 (Hex).
Bytes 7 through 22 contain a 16 byte binary asset UUID of the sculpt texture.
Byte 23 contains the sculpt stitching type (cylinder sphere, etc).
The UUID is stored as a binary 16bit value, it must be converted to hex string format.
A sculpt of stitching type 5 is a mesh, the UUID references a mesh asset.


UUID
The UUID of this prim in database table Prims.

Personal tools
General
About This Wiki