|
1: 2010-01-13 (水) 18:55:36 iseki  |
| | + | mysql> show columns from land; |
| | + | +------------------+--------------+------+-----+--------------------------------------+-------+ |
| | + | | Field | Type | Null | Key | Default | Extra | |
| | + | +------------------+--------------+------+-----+--------------------------------------+-------+ |
| | + | | UUID | varchar(255) | NO | PRI | NULL | | |
| | + | | RegionUUID | varchar(255) | YES | | NULL | | |
| | + | | LocalLandID | int(11) | YES | | NULL | | |
| | + | | Bitmap | longblob | YES | | NULL | | |
| | + | | Name | varchar(255) | YES | | NULL | | |
| | + | | Description | varchar(255) | YES | | NULL | | |
| | + | | OwnerUUID | varchar(255) | YES | | NULL | | |
| | + | | IsGroupOwned | int(11) | YES | | NULL | | |
| | + | | Area | int(11) | YES | | NULL | | |
| | + | | AuctionID | int(11) | YES | | NULL | | |
| | + | | Category | int(11) | YES | | NULL | | |
| | + | | ClaimDate | int(11) | YES | | NULL | | |
| | + | | ClaimPrice | int(11) | YES | | NULL | | |
| | + | | GroupUUID | varchar(255) | YES | | NULL | | |
| | + | | SalePrice | int(11) | YES | | NULL | | |
| | + | | LandStatus | int(11) | YES | | NULL | | |
| | + | | LandFlags | int(11) | YES | | NULL | | |
| | + | | LandingType | int(11) | YES | | NULL | | |
| | + | | MediaAutoScale | int(11) | YES | | NULL | | |
| | + | | MediaTextureUUID | varchar(255) | YES | | NULL | | |
| | + | | MediaURL | varchar(255) | YES | | NULL | | |
| | + | | MusicURL | varchar(255) | YES | | NULL | | |
| | + | | PassHours | float | YES | | NULL | | |
| | + | | PassPrice | int(11) | YES | | NULL | | |
| | + | | SnapshotUUID | varchar(255) | YES | | NULL | | |
| | + | | UserLocationX | float | YES | | NULL | | |
| | + | | UserLocationY | float | YES | | NULL | | |
| | + | | UserLocationZ | float | YES | | NULL | | |
| | + | | UserLookAtX | float | YES | | NULL | | |
| | + | | UserLookAtY | float | YES | | NULL | | |
| | + | | UserLookAtZ | float | YES | | NULL | | |
| | + | | AuthbuyerID | varchar(36) | NO | | 00000000-0000-0000-0000-000000000000 | | |
| | + | | OtherCleanTime | int(11) | NO | | 0 | | |
| | + | | Dwell | int(11) | NO | | 0 | | |
| | + | +------------------+--------------+------+-----+--------------------------------------+-------+ |
