diff options
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/CreateLandTable.sql')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/CreateLandTable.sql | 39 |
1 files changed, 0 insertions, 39 deletions
diff --git a/OpenSim/Data/MySQL/Resources/CreateLandTable.sql b/OpenSim/Data/MySQL/Resources/CreateLandTable.sql deleted file mode 100644 index 6c7254a..0000000 --- a/OpenSim/Data/MySQL/Resources/CreateLandTable.sql +++ /dev/null | |||
@@ -1,39 +0,0 @@ | |||
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 | ||