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 '')
-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 | ||