|
1: 2010-05-17 (Mon) 23:38:17 admin |
| + | *** prims [#e51b136c] |
| + | mysql> show columns from prims; |
| + | +----------------------+--------------+------+-----+--------------------------------------+-------+ |
| + | | Field | Type | Null | Key | Default | Extra | |
| + | +----------------------+--------------+------+-----+--------------------------------------+-------+ |
| + | | CreationDate | int(11) | YES | | NULL | | |
| + | | Name | varchar(255) | YES | | NULL | | |
| + | | Text | varchar(255) | YES | | NULL | | |
| + | | Description | varchar(255) | YES | | NULL | | |
| + | | SitName | varchar(255) | YES | | NULL | | |
| + | | TouchName | varchar(255) | YES | | NULL | | |
| + | | ObjectFlags | int(11) | YES | | NULL | | |
| + | | OwnerMask | int(11) | YES | | NULL | | |
| + | | NextOwnerMask | int(11) | YES | | NULL | | |
| + | | GroupMask | int(11) | YES | | NULL | | |
| + | | EveryoneMask | int(11) | YES | | NULL | | |
| + | | BaseMask | int(11) | YES | | NULL | | |
| + | | PositionX | double | YES | | NULL | | |
| + | | PositionY | double | YES | | NULL | | |
| + | | PositionZ | double | YES | | NULL | | |
| + | | GroupPositionX | double | YES | | NULL | | |
| + | | GroupPositionY | double | YES | | NULL | | |
| + | | GroupPositionZ | double | YES | | NULL | | |
| + | | VelocityX | double | YES | | NULL | | |
| + | | VelocityY | double | YES | | NULL | | |
| + | | VelocityZ | double | YES | | NULL | | |
| + | | AngularVelocityX | double | YES | | NULL | | |
| + | | AngularVelocityY | double | YES | | NULL | | |
| + | | AngularVelocityZ | double | YES | | NULL | | |
| + | | AccelerationX | double | YES | | NULL | | |
| + | | AccelerationY | double | YES | | NULL | | |
| + | | AccelerationZ | double | YES | | NULL | | |
| + | | RotationX | double | YES | | NULL | | |
| + | | RotationY | double | YES | | NULL | | |
| + | | RotationZ | double | YES | | NULL | | |
| + | | RotationW | double | YES | | NULL | | |
| + | | SitTargetOffsetX | double | YES | | NULL | | |
| + | | SitTargetOffsetY | double | YES | | NULL | | |
| + | | SitTargetOffsetZ | double | YES | | NULL | | |
| + | | SitTargetOrientW | double | YES | | NULL | | |
| + | | SitTargetOrientX | double | YES | | NULL | | |
| + | | SitTargetOrientY | double | YES | | NULL | | |
| + | | SitTargetOrientZ | double | YES | | NULL | | |
| + | | UUID | char(36) | NO | PRI | | | |
| + | | RegionUUID | char(36) | YES | MUL | NULL | | |
| + | | CreatorID | char(36) | YES | | NULL | | |
| + | | OwnerID | char(36) | YES | | NULL | | |
| + | | GroupID | char(36) | YES | | NULL | | |
| + | | LastOwnerID | char(36) | YES | | NULL | | |
| + | | SceneGroupID | char(36) | YES | MUL | NULL | | |
| + | | 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 | | |
| + | | TextureAnimation | blob | YES | | NULL | | |
| + | | 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 | | 10 | | |
| + | | 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 | | NULL | | |
| + | | 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 | | |
| + | | PassTouches | tinyint(4) | NO | | 0 | | |
| + | +----------------------+--------------+------+-----+--------------------------------------+------- |