1: 2016-05-16 (月) 19:00:51 iseki  |
現: 2016-05-16 (月) 19:01:48 iseki |
| - | MariaDB [jogrid_db]> show columns from land; | + | MariaDB [jogrid_db]> show columns from land; |
| - | +------------------+------------------+------+-----+--------------------------------------+-------+ | + | +------------------+------------------+------+-----+--------------------------------------+-------+ |
| - | | Field | Type | Null | Key | Default | Extra | | + | | Field | Type | Null | Key | Default | Extra | |
| - | +------------------+------------------+------+-----+--------------------------------------+-------+ | + | +------------------+------------------+------+-----+--------------------------------------+-------+ |
| - | | UUID | varchar(255) | NO | PRI | NULL | | | + | | UUID | varchar(255) | NO | PRI | NULL | | |
| - | | RegionUUID | varchar(255) | YES | | NULL | | | + | | RegionUUID | varchar(255) | YES | | NULL | | |
| - | | LocalLandID | int(11) | YES | | NULL | | | + | | LocalLandID | int(11) | YES | | NULL | | |
| - | | Bitmap | longblob | YES | | NULL | | | + | | Bitmap | longblob | YES | | NULL | | |
| - | | Name | varchar(255) | YES | | NULL | | | + | | Name | varchar(255) | YES | | NULL | | |
| - | | Description | varchar(255) | YES | | NULL | | | + | | Description | varchar(255) | YES | | NULL | | |
| - | | OwnerUUID | varchar(255) | YES | | NULL | | | + | | OwnerUUID | varchar(255) | YES | | NULL | | |
| - | | IsGroupOwned | int(11) | YES | | NULL | | | + | | IsGroupOwned | int(11) | YES | | NULL | | |
| - | | Area | int(11) | YES | | NULL | | | + | | Area | int(11) | YES | | NULL | | |
| - | | AuctionID | int(11) | YES | | NULL | | | + | | AuctionID | int(11) | YES | | NULL | | |
| - | | Category | int(11) | YES | | NULL | | | + | | Category | int(11) | YES | | NULL | | |
| - | | ClaimDate | int(11) | YES | | NULL | | | + | | ClaimDate | int(11) | YES | | NULL | | |
| - | | ClaimPrice | int(11) | YES | | NULL | | | + | | ClaimPrice | int(11) | YES | | NULL | | |
| - | | GroupUUID | varchar(255) | YES | | NULL | | | + | | GroupUUID | varchar(255) | YES | | NULL | | |
| - | | SalePrice | int(11) | YES | | NULL | | | + | | SalePrice | int(11) | YES | | NULL | | |
| - | | LandStatus | int(11) | YES | | NULL | | | + | | LandStatus | int(11) | YES | | NULL | | |
| - | | LandFlags | int(10) unsigned | YES | | NULL | | | + | | LandFlags | int(10) unsigned | YES | | NULL | | |
| - | | LandingType | int(11) | YES | | NULL | | | + | | LandingType | int(11) | YES | | NULL | | |
| - | | MediaAutoScale | int(11) | YES | | NULL | | | + | | MediaAutoScale | int(11) | YES | | NULL | | |
| - | | MediaTextureUUID | varchar(255) | YES | | NULL | | | + | | MediaTextureUUID | varchar(255) | YES | | NULL | | |
| - | | MediaURL | varchar(255) | YES | | NULL | | | + | | MediaURL | varchar(255) | YES | | NULL | | |
| - | | MusicURL | varchar(255) | YES | | NULL | | | + | | MusicURL | varchar(255) | YES | | NULL | | |
| - | | PassHours | float | YES | | NULL | | | + | | PassHours | float | YES | | NULL | | |
| - | | PassPrice | int(11) | YES | | NULL | | | + | | PassPrice | int(11) | YES | | NULL | | |
| - | | SnapshotUUID | varchar(255) | YES | | NULL | | | + | | SnapshotUUID | varchar(255) | YES | | NULL | | |
| - | | UserLocationX | float | YES | | NULL | | | + | | UserLocationX | float | YES | | NULL | | |
| - | | UserLocationY | float | YES | | NULL | | | + | | UserLocationY | float | YES | | NULL | | |
| - | | UserLocationZ | float | YES | | NULL | | | + | | UserLocationZ | float | YES | | NULL | | |
| - | | UserLookAtX | float | YES | | NULL | | | + | | UserLookAtX | float | YES | | NULL | | |
| - | | UserLookAtY | float | YES | | NULL | | | + | | UserLookAtY | float | YES | | NULL | | |
| - | | UserLookAtZ | float | YES | | NULL | | | + | | UserLookAtZ | float | YES | | NULL | | |
| - | | AuthbuyerID | varchar(36) | NO | | 00000000-0000-0000-0000-000000000000 | | | + | | AuthbuyerID | varchar(36) | NO | | 00000000-0000-0000-0000-000000000000 | | |
| - | | OtherCleanTime | int(11) | NO | | 0 | | | + | | OtherCleanTime | int(11) | NO | | 0 | | |
| - | | Dwell | int(11) | NO | | 0 | | | + | | Dwell | int(11) | NO | | 0 | | |
| - | | MediaType | varchar(32) | NO | | none/none | | | + | | MediaType | varchar(32) | NO | | none/none | | |
| - | | MediaDescription | varchar(255) | NO | | | | | + | | MediaDescription | varchar(255) | NO | | | | |
| - | | MediaSize | varchar(16) | NO | | 0,0 | | | + | | MediaSize | varchar(16) | NO | | 0,0 | | |
| - | | MediaLoop | tinyint(1) | NO | | 0 | | | + | | MediaLoop | tinyint(1) | NO | | 0 | | |
| - | | ObscureMusic | tinyint(1) | NO | | 0 | | | + | | ObscureMusic | tinyint(1) | NO | | 0 | | |
| - | | ObscureMedia | tinyint(1) | NO | | 0 | | | + | | ObscureMedia | tinyint(1) | NO | | 0 | | |
| - | | SeeAVs | tinyint(4) | NO | | 1 | | | + | | SeeAVs | tinyint(4) | NO | | 1 | | |
| - | | AnyAVSounds | tinyint(4) | NO | | 1 | | | + | | AnyAVSounds | tinyint(4) | NO | | 1 | | |
| - | | GroupAVSounds | tinyint(4) | NO | | 1 | | | + | | GroupAVSounds | tinyint(4) | NO | | 1 | | |
| - | +------------------+------------------+------+-----+--------------------------------------+-------+ | + | +------------------+------------------+------+-----+--------------------------------------+-------+ |
| - | 43 rows in set (0.01 sec) | + | 43 rows in set (0.01 sec) |
