![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
#author("2024-09-02T04:59:53+00:00","default:iseki","iseki") MariaDB [jogrid_db]> 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(10) unsigned | 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 | | | MediaType | varchar(32) | NO | | none/none | | | MediaDescription | varchar(255) | NO | | | | | MediaSize | varchar(16) | NO | | 0,0 | | | MediaLoop | tinyint(1) | NO | | 0 | | | ObscureMusic | tinyint(1) | NO | | 0 | | | ObscureMedia | tinyint(1) | NO | | 0 | | | SeeAVs | tinyint(4) | NO | | 1 | | | AnyAVSounds | tinyint(4) | NO | | 1 | | | GroupAVSounds | tinyint(4) | NO | | 1 | | +------------------+------------------+------+-----+--------------------------------------+-------+ 43 rows in set (0.01 sec)
