diff options
| author | Teravus Ovares | 2008-04-30 20:08:15 +0000 |
|---|---|---|
| committer | Teravus Ovares | 2008-04-30 20:08:15 +0000 |
| commit | b3f44fbb94287d58c635cad7d75e5223ef35aedf (patch) | |
| tree | 246dac84c3d914907f028fdb93cf030bd13f9dc9 /OpenSim/Data/MySQL/Resources/CreateLandTable.sql | |
| parent | * Refactor: Rename InventoryFolderImpl.HasSubFolder() to GetDescendentFolder() (diff) | |
| download | opensim-SC_OLD-b3f44fbb94287d58c635cad7d75e5223ef35aedf.zip opensim-SC_OLD-b3f44fbb94287d58c635cad7d75e5223ef35aedf.tar.gz opensim-SC_OLD-b3f44fbb94287d58c635cad7d75e5223ef35aedf.tar.bz2 opensim-SC_OLD-b3f44fbb94287d58c635cad7d75e5223ef35aedf.tar.xz | |
* Refactored the land table to be versionable in mySQL.
* Added AuthbuyerID so that if someone sets a land for sale to someone and then restarts the simulator, when the simulator comes back up, the setting persists.
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/CreateLandTable.sql')
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/CreateLandTable.sql | 39 |
1 files changed, 39 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/CreateLandTable.sql b/OpenSim/Data/MySQL/Resources/CreateLandTable.sql new file mode 100644 index 0000000..8a1b626 --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/CreateLandTable.sql | |||
| @@ -0,0 +1,39 @@ | |||
| 1 | CREATE TABLE `land` | ||
| 2 | ( | ||
| 3 | `UUID` varchar (255) NOT NULL, | ||
| 4 | `RegionUUID` varchar (255) DEFAULT NULL , | ||
| 5 | `LocalLandID` int (11) DEFAULT NULL , | ||
| 6 | `Bitmap` longblob, | ||
| 7 | `Name` varchar (255) DEFAULT NULL , | ||
| 8 | `Description` varchar (255) DEFAULT NULL , | ||
| 9 | `OwnerUUID` varchar (255) DEFAULT NULL , | ||
| 10 | `IsGroupOwned` int (11) DEFAULT NULL , | ||
| 11 | `Area` int (11) DEFAULT NULL , | ||
| 12 | `AuctionID` int (11) DEFAULT NULL , | ||
| 13 | `Category` int (11) DEFAULT NULL , | ||
| 14 | `ClaimDate` int (11) DEFAULT NULL , | ||
| 15 | `ClaimPrice` int (11) DEFAULT NULL , | ||
| 16 | `GroupUUID` varchar (255) DEFAULT NULL , | ||
| 17 | `SalePrice` int (11) DEFAULT NULL , | ||
| 18 | `LandStatus` int (11) DEFAULT NULL , | ||
| 19 | `LandFlags` int (11) DEFAULT NULL , | ||
| 20 | `LandingType` int (11) DEFAULT NULL , | ||
| 21 | `MediaAutoScale` int (11) DEFAULT NULL , | ||
| 22 | `MediaTextureUUID` varchar (255) DEFAULT NULL , | ||
| 23 | `MediaURL` varchar (255) DEFAULT NULL , | ||
| 24 | `MusicURL` varchar (255) DEFAULT NULL , | ||
| 25 | `PassHours` float DEFAULT NULL , | ||
| 26 | `PassPrice` int (11) DEFAULT NULL , | ||
| 27 | `SnapshotUUID` varchar (255) DEFAULT NULL , | ||
| 28 | `UserLocationX` float DEFAULT NULL , | ||
| 29 | `UserLocationY` float DEFAULT NULL , | ||
| 30 | `UserLocationZ` float DEFAULT NULL , | ||
| 31 | `UserLookAtX` float DEFAULT NULL , | ||
| 32 | `UserLookAtY` float DEFAULT NULL , | ||
| 33 | `UserLookAtZ` float DEFAULT NULL , | ||
| 34 | `AuthbuyerID` varchar(36) default '00000000-0000-0000-0000-000000000000' not null, | ||
| 35 | |||
| 36 | PRIMARY KEY (`UUID`) | ||
| 37 | ) | ||
| 38 | ENGINE=INNODB | ||
| 39 | DEFAULT CHARSET=utf8 COMMENT='Rev. 2'; \ No newline at end of file | ||