Land (database table)
From OpenSimulator
(New page: Category:Database '''Estate Managers''' ''Records managers of estates '' (back to Database Documentation) <br><br> The current structure of the ...) |
|||
Line 53: | Line 53: | ||
<br> | <br> | ||
The UUID of the region containing this land parcel. | The UUID of the region containing this land parcel. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''LocalLandID''' | ||
+ | <br> | ||
+ | To be identified. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''Bitmap''' | ||
+ | <br> | ||
+ | To be identified. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''Name''' | ||
+ | <br> | ||
+ | The name of this land parcel. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''Description''' | ||
+ | <br> | ||
+ | A description of this land parcel. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''OwnerUUID''' | ||
+ | <br> | ||
+ | The UUID of the user who owns this land parcel. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''IsGroupOwned''' | ||
+ | <br> | ||
+ | To be identified. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''Area''' | ||
+ | <br> | ||
+ | To be identified. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''AuctionID''' | ||
+ | <br> | ||
+ | To be identified. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''Category''' | ||
+ | <br> | ||
+ | To be identified. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''ClaimDate''' | ||
+ | <br> | ||
+ | To be identified. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''ClaimPrice''' | ||
+ | <br> | ||
+ | To be identified. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''GroupUUID''' | ||
+ | <br> | ||
+ | To be identified when Groups are implemented. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''SalePrice''' | ||
+ | <br> | ||
+ | If the land is for sale this is the price asked. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''LandStatus''' | ||
+ | <br> | ||
+ | To be identified. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''LandFlags''' | ||
+ | <br> | ||
+ | To be identified. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''LandingType''' | ||
+ | <br> | ||
+ | To be identified. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''MediaAutoScale''' | ||
+ | <br> | ||
+ | To be identified. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''MediaTextureUUID''' | ||
+ | <br> | ||
+ | To be identified. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''MediaURL''' | ||
+ | <br> | ||
+ | The URL of the Media station to be played in this land. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''MusicURL''' | ||
+ | <br> | ||
+ | The URL of the Music station to be played in this land. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''Passhours''' | ||
+ | <br> | ||
+ | To be identified. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''PassPrice''' | ||
+ | <br> | ||
+ | To be identified. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''SnapshotUUID''' | ||
+ | <br> | ||
+ | To be identified. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''UserLocationX''' | ||
+ | <br> | ||
+ | To be identified. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''UserLocationY''' | ||
+ | <br> | ||
+ | To be identified. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''UserLocationZ''' | ||
+ | <br> | ||
+ | To be identified. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''UserLookAtX''' | ||
+ | <br> | ||
+ | To be identified. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''UserLookAtY''' | ||
+ | <br> | ||
+ | To be identified. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''UserLookAtZ''' | ||
+ | <br> | ||
+ | To be identified. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''AuthBuyID''' | ||
+ | <br> | ||
+ | The UUID of the User authorised to buy this land. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''OtherCleanTime''' | ||
+ | <br> | ||
+ | To be identified. | ||
+ | <br> | ||
+ | <br> | ||
+ | '''Dwell''' | ||
+ | <br> | ||
+ | To be identified. | ||
<br> | <br> | ||
<br> | <br> |
Revision as of 14:35, 22 February 2009
Estate Managers Records managers of estates (back to Database Documentation)
The current structure of the Land table is as follows:
Field | Type | Null | Key | Default | Extra |
UUID | varchar(255) | NO | PRI | ||
RegionUUID | varchar(255) | YES | |||
LocalLandID | int(11) | YES | |||
bitmap | longblob | YES | |||
Name | varchar(255) | YES | |||
Description | varchar(255) | YES | |||
OwnerUUID | varchar(255) | YES | |||
IsGroupOwned | int(11) | YES | |||
Area | int(11) | YES | |||
AuctionID | int(11) | YES | |||
Category | int(11) | YES | |||
ClaimDate | int(11) | YES | |||
ClaimPrice | int(11) | YES | |||
GroupUUID | varchar(255) | YES | |||
SalePrice | int(11) | YES | |||
LandStatus | int(11) | YES | |||
LandFlags | int(11) | YES | |||
MediaAutoScale | int(11) | YES | |||
MediaTextureUUID | varchar(255) | YES | |||
MediaURL | varchar(255) | YES | |||
MUSICURL | varchar(255) | YES | |||
Passhours | float | YES | |||
PassPrice | int(11) | YES | |||
SnapshotUUID | varchar(255) | YES | |||
UserLocationX | int(11) | YES | |||
UserLocationY | int(11) | YES | |||
UserLocationZ | int(11) | YES | |||
UserLookAtX | int(11) | YES | |||
UserLookAtY | int(11) | YES | |||
UserLookAtZ | int(11) | YES | |||
AuthBuyerID | varchar(255) | NO | 00000000-0000-0000-0000-000000000000 | ||
OtherCleanTime | int(11) | NO | |||
Dwell | int(11) | NO |
(back to Database Documentation)
UUID
The unique ID of the Land Parcel.
RegionUUID
The UUID of the region containing this land parcel.
LocalLandID
To be identified.
Bitmap
To be identified.
Name
The name of this land parcel.
Description
A description of this land parcel.
OwnerUUID
The UUID of the user who owns this land parcel.
IsGroupOwned
To be identified.
Area
To be identified.
AuctionID
To be identified.
Category
To be identified.
ClaimDate
To be identified.
ClaimPrice
To be identified.
GroupUUID
To be identified when Groups are implemented.
SalePrice
If the land is for sale this is the price asked.
LandStatus
To be identified.
LandFlags
To be identified.
LandingType
To be identified.
MediaAutoScale
To be identified.
MediaTextureUUID
To be identified.
MediaURL
The URL of the Media station to be played in this land.
MusicURL
The URL of the Music station to be played in this land.
Passhours
To be identified.
PassPrice
To be identified.
SnapshotUUID
To be identified.
UserLocationX
To be identified.
UserLocationY
To be identified.
UserLocationZ
To be identified.
UserLookAtX
To be identified.
UserLookAtY
To be identified.
UserLookAtZ
To be identified.
AuthBuyID
The UUID of the User authorised to buy this land.
OtherCleanTime
To be identified.
Dwell
To be identified.
(back to Database Documentation)