CREATE TABLE `prims` ( `ParentID` int(11) default NULL, `CreationDate` int(11) default NULL, `Name` varchar(255) default NULL, `ParentUUID` char(36) 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, `PositionX` float default NULL, `PositionY` float default NULL, `PositionZ` float default NULL, `GroupPositionX` float default NULL, `GroupPositionY` float default NULL, `GroupPositionZ` float default NULL, `VelocityX` float default NULL, `VelocityY` float default NULL, `VelocityZ` float default NULL, `AngularVelocityX` float default NULL, `AngularVelocityY` float default NULL, `AngularVelocityZ` float default NULL, `AccelerationX` float default NULL, `AccelerationY` float default NULL, `AccelerationZ` float default NULL, `RotationX` float default NULL, `RotationY` float default NULL, `RotationZ` float default NULL, `RotationW` float default NULL, `SitTargetOffsetX` float default NULL, `SitTargetOffsetY` float default NULL, `SitTargetOffsetZ` float default NULL, `SitTargetOrientW` float default NULL, `SitTargetOrientX` float default NULL, `SitTargetOrientY` float default NULL, `SitTargetOrientZ` float default NULL, `UUID` char(36) NOT NULL default '', `RegionID` char(36) default NULL, `CreatorID` char(36) default NULL, `OwnerID` char(36) default NULL, `GroupID` char(36) default NULL, `LastOwnerID` char(36) default NULL, PRIMARY KEY (`UUID`), KEY `prims_regionuuid` (`RegionID`), KEY 'prims_parentuuid' ('ParentUUID') ) ENGINE=InnoDB DEFAULT CHARSET=utf8