CREATE TABLE `Prims` (
  `UUID` char(36) NOT NULL default '',
  `RegionID` char(36) default NULL,
  `GroupID` char(36) default NULL,
  `ParentID` int(11) default NULL,
  `ParentUUID` char(36) default NULL,
  `OwnerID` char(36) default NULL,
  `LastOwnerID` char(36) default NULL,
  `CreatorID` char(36) default NULL,
  `CreationDate` int(11) default NULL,
  `LinkNum` int(11) default NULL,
  `Name` varchar(255) default NULL,
  `Text` varchar(255) default NULL,
  `Description` varchar(255) default NULL,
  `SitName` varchar(255) default NULL,
  `TouchName` varchar(255) default NULL,
  `ObjectFlags` int(11) default NULL,
  `OwnerMask` int(11) default NULL,
  `NextOwnerMask` int(11) default NULL,
  `GroupMask` int(11) default NULL,
  `EveryoneMask` int(11) default NULL,
  `BaseMask` int(11) default NULL,
  `Material` int(1) default NULL,  
  `ScriptAccessPin` int(11) default NULL,
  `TextureAnimation` blob,
  `ParticleSystem` blob,
  `ClickAction` int(1) default NULL,  
  `Color` int(11) default NULL,
  `PositionX` double default NULL,
  `PositionY` double default NULL,
  `PositionZ` double default NULL,
  `GroupPositionX` double default NULL,
  `GroupPositionY` double default NULL,
  `GroupPositionZ` double default NULL,
  `VelocityX` double default NULL,
  `VelocityY` double default NULL,
  `VelocityZ` double default NULL,
  `AngularVelocityX` double default NULL,
  `AngularVelocityY` double default NULL,
  `AngularVelocityZ` double default NULL,
  `AccelerationX` double default NULL,
  `AccelerationY` double default NULL,
  `AccelerationZ` double default NULL,
  `RotationX` double default NULL,
  `RotationY` double default NULL,
  `RotationZ` double default NULL,
  `RotationW` double default NULL,
  `SitTargetOffsetX` double default NULL,
  `SitTargetOffsetY` double default NULL,
  `SitTargetOffsetZ` double default NULL,
  `SitTargetOrientW` double default NULL,
  `SitTargetOrientX` double default NULL,
  `SitTargetOrientY` double default NULL,
  `SitTargetOrientZ` double default NULL,
  -- this is the shape
  `Shape` int(11) default NULL,
  `ScaleX` double default NULL,
  `ScaleY` double default NULL,
  `ScaleZ` double default NULL,
  `PCode` int(11) default NULL,
  `PathBegin` int(11) default NULL,
  `PathEnd` int(11) default NULL,
  `PathScaleX` int(11) default NULL,
  `PathScaleY` int(11) default NULL,
  `PathShearX` int(11) default NULL,
  `PathShearY` int(11) default NULL,
  `PathSkew` int(11) default NULL,
  `PathCurve` int(11) default NULL,
  `PathRadiusOffset` int(11) default NULL,
  `PathRevolutions` int(11) default NULL,
  `PathTaperX` int(11) default NULL,
  `PathTaperY` int(11) default NULL,
  `PathTwist` int(11) default NULL,
  `PathTwistBegin` int(11) default NULL,
  `ProfileBegin` int(11) default NULL,
  `ProfileEnd` int(11) default NULL,
  `ProfileCurve` int(11) default NULL,
  `ProfileHollow` int(11) default NULL,
  `State` int(11) default NULL,
  `Texture` longblob,
  `ExtraParams` longblob,
  PRIMARY KEY  (`UUID`),
  KEY `prims_regionuuid` (`RegionID`),
  KEY `prims_parentuuid` (`ParentUUID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


