From d51ce47b2d7635b17f3dd429158e8f59b78b83aa Mon Sep 17 00:00:00 2001 From: Jeff Ames Date: Thu, 1 May 2008 14:31:30 +0000 Subject: Update svn properties. Minor formatting cleanup. --- OpenSim/Data/MySQL/Resources/CreateLandTable.sql | 76 +++++++++++----------- .../MySQL/Resources/UpgradeLandTableToVersion2.sql | 4 +- 2 files changed, 40 insertions(+), 40 deletions(-) (limited to 'OpenSim/Data/MySQL') 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 @@ -CREATE TABLE `land` - ( - `UUID` varchar (255) NOT NULL, - `RegionUUID` varchar (255) DEFAULT NULL , - `LocalLandID` int (11) DEFAULT NULL , - `Bitmap` longblob, - `Name` varchar (255) DEFAULT NULL , - `Description` varchar (255) DEFAULT NULL , - `OwnerUUID` varchar (255) DEFAULT NULL , - `IsGroupOwned` int (11) DEFAULT NULL , - `Area` int (11) DEFAULT NULL , - `AuctionID` int (11) DEFAULT NULL , - `Category` int (11) DEFAULT NULL , - `ClaimDate` int (11) DEFAULT NULL , - `ClaimPrice` int (11) DEFAULT NULL , - `GroupUUID` varchar (255) DEFAULT NULL , - `SalePrice` int (11) DEFAULT NULL , - `LandStatus` int (11) DEFAULT NULL , - `LandFlags` int (11) DEFAULT NULL , - `LandingType` int (11) DEFAULT NULL , - `MediaAutoScale` int (11) DEFAULT NULL , - `MediaTextureUUID` varchar (255) DEFAULT NULL , - `MediaURL` varchar (255) DEFAULT NULL , - `MusicURL` varchar (255) DEFAULT NULL , - `PassHours` float DEFAULT NULL , - `PassPrice` int (11) DEFAULT NULL , - `SnapshotUUID` varchar (255) DEFAULT NULL , - `UserLocationX` float DEFAULT NULL , - `UserLocationY` float DEFAULT NULL , - `UserLocationZ` float DEFAULT NULL , - `UserLookAtX` float DEFAULT NULL , - `UserLookAtY` float DEFAULT NULL , - `UserLookAtZ` float DEFAULT NULL , - `AuthbuyerID` varchar(36) default '00000000-0000-0000-0000-000000000000' not null, - - PRIMARY KEY (`UUID`) - ) - ENGINE=INNODB +CREATE TABLE `land` + ( + `UUID` varchar (255) NOT NULL, + `RegionUUID` varchar (255) DEFAULT NULL , + `LocalLandID` int (11) DEFAULT NULL , + `Bitmap` longblob, + `Name` varchar (255) DEFAULT NULL , + `Description` varchar (255) DEFAULT NULL , + `OwnerUUID` varchar (255) DEFAULT NULL , + `IsGroupOwned` int (11) DEFAULT NULL , + `Area` int (11) DEFAULT NULL , + `AuctionID` int (11) DEFAULT NULL , + `Category` int (11) DEFAULT NULL , + `ClaimDate` int (11) DEFAULT NULL , + `ClaimPrice` int (11) DEFAULT NULL , + `GroupUUID` varchar (255) DEFAULT NULL , + `SalePrice` int (11) DEFAULT NULL , + `LandStatus` int (11) DEFAULT NULL , + `LandFlags` int (11) DEFAULT NULL , + `LandingType` int (11) DEFAULT NULL , + `MediaAutoScale` int (11) DEFAULT NULL , + `MediaTextureUUID` varchar (255) DEFAULT NULL , + `MediaURL` varchar (255) DEFAULT NULL , + `MusicURL` varchar (255) DEFAULT NULL , + `PassHours` float DEFAULT NULL , + `PassPrice` int (11) DEFAULT NULL , + `SnapshotUUID` varchar (255) DEFAULT NULL , + `UserLocationX` float DEFAULT NULL , + `UserLocationY` float DEFAULT NULL , + `UserLocationZ` float DEFAULT NULL , + `UserLookAtX` float DEFAULT NULL , + `UserLookAtY` float DEFAULT NULL , + `UserLookAtZ` float DEFAULT NULL , + `AuthbuyerID` varchar(36) default '00000000-0000-0000-0000-000000000000' not null, + + PRIMARY KEY (`UUID`) + ) + ENGINE=INNODB 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 @@ -ALTER TABLE `land` - ADD COLUMN `AuthbuyerID` varchar(36) default '00000000-0000-0000-0000-000000000000' not null, +ALTER TABLE `land` + ADD COLUMN `AuthbuyerID` varchar(36) default '00000000-0000-0000-0000-000000000000' not null, COMMENT='Rev. 2'; \ No newline at end of file -- cgit v1.1