diff options
Diffstat (limited to 'OpenSim/Data/MySQL')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/CreateLandTable.sql | 76 | ||||
-rw-r--r-- | OpenSim/Data/MySQL/Resources/UpgradeLandTableToVersion2.sql | 4 |
2 files changed, 40 insertions, 40 deletions
diff --git a/OpenSim/Data/MySQL/Resources/CreateLandTable.sql b/OpenSim/Data/MySQL/Resources/CreateLandTable.sql index 8a1b626..6c7254a 100644 --- a/OpenSim/Data/MySQL/Resources/CreateLandTable.sql +++ b/OpenSim/Data/MySQL/Resources/CreateLandTable.sql | |||
@@ -1,39 +1,39 @@ | |||
1 | CREATE TABLE `land` | 1 | CREATE TABLE `land` |
2 | ( | 2 | ( |
3 | `UUID` varchar (255) NOT NULL, | 3 | `UUID` varchar (255) NOT NULL, |
4 | `RegionUUID` varchar (255) DEFAULT NULL , | 4 | `RegionUUID` varchar (255) DEFAULT NULL , |
5 | `LocalLandID` int (11) DEFAULT NULL , | 5 | `LocalLandID` int (11) DEFAULT NULL , |
6 | `Bitmap` longblob, | 6 | `Bitmap` longblob, |
7 | `Name` varchar (255) DEFAULT NULL , | 7 | `Name` varchar (255) DEFAULT NULL , |
8 | `Description` varchar (255) DEFAULT NULL , | 8 | `Description` varchar (255) DEFAULT NULL , |
9 | `OwnerUUID` varchar (255) DEFAULT NULL , | 9 | `OwnerUUID` varchar (255) DEFAULT NULL , |
10 | `IsGroupOwned` int (11) DEFAULT NULL , | 10 | `IsGroupOwned` int (11) DEFAULT NULL , |
11 | `Area` int (11) DEFAULT NULL , | 11 | `Area` int (11) DEFAULT NULL , |
12 | `AuctionID` int (11) DEFAULT NULL , | 12 | `AuctionID` int (11) DEFAULT NULL , |
13 | `Category` int (11) DEFAULT NULL , | 13 | `Category` int (11) DEFAULT NULL , |
14 | `ClaimDate` int (11) DEFAULT NULL , | 14 | `ClaimDate` int (11) DEFAULT NULL , |
15 | `ClaimPrice` int (11) DEFAULT NULL , | 15 | `ClaimPrice` int (11) DEFAULT NULL , |
16 | `GroupUUID` varchar (255) DEFAULT NULL , | 16 | `GroupUUID` varchar (255) DEFAULT NULL , |
17 | `SalePrice` int (11) DEFAULT NULL , | 17 | `SalePrice` int (11) DEFAULT NULL , |
18 | `LandStatus` int (11) DEFAULT NULL , | 18 | `LandStatus` int (11) DEFAULT NULL , |
19 | `LandFlags` int (11) DEFAULT NULL , | 19 | `LandFlags` int (11) DEFAULT NULL , |
20 | `LandingType` int (11) DEFAULT NULL , | 20 | `LandingType` int (11) DEFAULT NULL , |
21 | `MediaAutoScale` int (11) DEFAULT NULL , | 21 | `MediaAutoScale` int (11) DEFAULT NULL , |
22 | `MediaTextureUUID` varchar (255) DEFAULT NULL , | 22 | `MediaTextureUUID` varchar (255) DEFAULT NULL , |
23 | `MediaURL` varchar (255) DEFAULT NULL , | 23 | `MediaURL` varchar (255) DEFAULT NULL , |
24 | `MusicURL` varchar (255) DEFAULT NULL , | 24 | `MusicURL` varchar (255) DEFAULT NULL , |
25 | `PassHours` float DEFAULT NULL , | 25 | `PassHours` float DEFAULT NULL , |
26 | `PassPrice` int (11) DEFAULT NULL , | 26 | `PassPrice` int (11) DEFAULT NULL , |
27 | `SnapshotUUID` varchar (255) DEFAULT NULL , | 27 | `SnapshotUUID` varchar (255) DEFAULT NULL , |
28 | `UserLocationX` float DEFAULT NULL , | 28 | `UserLocationX` float DEFAULT NULL , |
29 | `UserLocationY` float DEFAULT NULL , | 29 | `UserLocationY` float DEFAULT NULL , |
30 | `UserLocationZ` float DEFAULT NULL , | 30 | `UserLocationZ` float DEFAULT NULL , |
31 | `UserLookAtX` float DEFAULT NULL , | 31 | `UserLookAtX` float DEFAULT NULL , |
32 | `UserLookAtY` float DEFAULT NULL , | 32 | `UserLookAtY` float DEFAULT NULL , |
33 | `UserLookAtZ` float DEFAULT NULL , | 33 | `UserLookAtZ` float DEFAULT NULL , |
34 | `AuthbuyerID` varchar(36) default '00000000-0000-0000-0000-000000000000' not null, | 34 | `AuthbuyerID` varchar(36) default '00000000-0000-0000-0000-000000000000' not null, |
35 | 35 | ||
36 | PRIMARY KEY (`UUID`) | 36 | PRIMARY KEY (`UUID`) |
37 | ) | 37 | ) |
38 | ENGINE=INNODB | 38 | ENGINE=INNODB |
39 | DEFAULT CHARSET=utf8 COMMENT='Rev. 2'; \ No newline at end of file | 39 | DEFAULT CHARSET=utf8 COMMENT='Rev. 2'; \ No newline at end of file |
diff --git a/OpenSim/Data/MySQL/Resources/UpgradeLandTableToVersion2.sql b/OpenSim/Data/MySQL/Resources/UpgradeLandTableToVersion2.sql index eb024be..c5c55f1 100644 --- a/OpenSim/Data/MySQL/Resources/UpgradeLandTableToVersion2.sql +++ b/OpenSim/Data/MySQL/Resources/UpgradeLandTableToVersion2.sql | |||
@@ -1,3 +1,3 @@ | |||
1 | ALTER TABLE `land` | 1 | ALTER TABLE `land` |
2 | ADD COLUMN `AuthbuyerID` varchar(36) default '00000000-0000-0000-0000-000000000000' not null, | 2 | ADD COLUMN `AuthbuyerID` varchar(36) default '00000000-0000-0000-0000-000000000000' not null, |
3 | COMMENT='Rev. 2'; \ No newline at end of file | 3 | COMMENT='Rev. 2'; \ No newline at end of file |