|
Cur: 2016-07-10 (Sun) 12:33:10 iseki  |
| | + | MariaDB [jogrid_db]> 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 | varchar(255) | NO | | | | |
| | + | | 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 | | |
| | + | | MediaURL | varchar(255) | YES | | NULL | | |
| | + | | DynAttrs | text | YES | | NULL | | |
| | + | | PhysicsShapeType | tinyint(4) | NO | | 0 | | |
| | + | | Density | double | NO | | 1000 | | |
| | + | | GravityModifier | double | NO | | 1 | | |
| | + | | Friction | double | NO | | 0.6 | | |
| | + | | Restitution | double | NO | | 0.5 | | |
| | + | | KeyframeMotion | blob | YES | | NULL | | |
| | + | | AttachedPosX | double | YES | | 0 | | |
| | + | | AttachedPosY | double | YES | | 0 | | |
| | + | | AttachedPosZ | double | YES | | 0 | | |
| | + | | PassCollisions | tinyint(4) | NO | | 0 | | |
| | + | | Vehicle | text | YES | | NULL | | |
| | + | | RotationAxisLocks | tinyint(4) | NO | | 0 | | |
| | + | +----------------------+--------------+------+-----+--------------------------------------+-------+ |
| | + | 93 rows in set (0.01 sec) |
