Update svn properties. Minor formatting cleanup.

author: Jeff Ames 2008-05-01 14:31:30 +0000
committer: Jeff Ames 2008-05-01 14:31:30 +0000
commit: d51ce47b2d7635b17f3dd429158e8f59b78b83aa (patch)
tree: d3595bd5194199184059aa398b91a51dc6c799cf /OpenSim/Data
parent: * Looks like I had the bamboo build right in the first place - it was just th... (diff)
download: opensim-SC-d51ce47b2d7635b17f3dd429158e8f59b78b83aa.zip
opensim-SC-d51ce47b2d7635b17f3dd429158e8f59b78b83aa.tar.gz
opensim-SC-d51ce47b2d7635b17f3dd429158e8f59b78b83aa.tar.bz2
opensim-SC-d51ce47b2d7635b17f3dd429158e8f59b78b83aa.tar.xz
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 @@
-CREATE TABLE `land`
+CREATE TABLE `land`
-   (
+   (
-   `UUID` varchar (255) NOT NULL,
+   `UUID` varchar (255) NOT NULL,
-   `RegionUUID` varchar (255) DEFAULT NULL ,
+   `RegionUUID` varchar (255) DEFAULT NULL ,
-   `LocalLandID` int (11) DEFAULT NULL ,
+   `LocalLandID` int (11) DEFAULT NULL ,
-   `Bitmap` longblob,
+   `Bitmap` longblob,
-   `Name` varchar (255) DEFAULT NULL ,
+   `Name` varchar (255) DEFAULT NULL ,
-   `Description` varchar (255) DEFAULT NULL ,
+   `Description` varchar (255) DEFAULT NULL ,
-   `OwnerUUID` varchar (255) DEFAULT NULL ,
+   `OwnerUUID` varchar (255) DEFAULT NULL ,
-   `IsGroupOwned` int (11) DEFAULT NULL ,
+   `IsGroupOwned` int (11) DEFAULT NULL ,
-   `Area` int (11) DEFAULT NULL ,
+   `Area` int (11) DEFAULT NULL ,
-   `AuctionID` int (11) DEFAULT NULL ,
+   `AuctionID` int (11) DEFAULT NULL ,
-   `Category` int (11) DEFAULT NULL ,
+   `Category` int (11) DEFAULT NULL ,
-   `ClaimDate` int (11) DEFAULT NULL ,
+   `ClaimDate` int (11) DEFAULT NULL ,
-   `ClaimPrice` int (11) DEFAULT NULL ,
+   `ClaimPrice` int (11) DEFAULT NULL ,
-   `GroupUUID` varchar (255) DEFAULT NULL ,
+   `GroupUUID` varchar (255) DEFAULT NULL ,
-   `SalePrice` int (11) DEFAULT NULL ,
+   `SalePrice` int (11) DEFAULT NULL ,
-   `LandStatus` int (11) DEFAULT NULL ,
+   `LandStatus` int (11) DEFAULT NULL ,
-   `LandFlags` int (11) DEFAULT NULL ,
+   `LandFlags` int (11) DEFAULT NULL ,
-   `LandingType` int (11) DEFAULT NULL ,
+   `LandingType` int (11) DEFAULT NULL ,
-   `MediaAutoScale` int (11) DEFAULT NULL ,
+   `MediaAutoScale` int (11) DEFAULT NULL ,
-   `MediaTextureUUID` varchar (255) DEFAULT NULL ,
+   `MediaTextureUUID` varchar (255) DEFAULT NULL ,
-   `MediaURL` varchar (255) DEFAULT NULL ,
+   `MediaURL` varchar (255) DEFAULT NULL ,
-   `MusicURL` varchar (255) DEFAULT NULL ,
+   `MusicURL` varchar (255) DEFAULT NULL ,
-   `PassHours` float DEFAULT NULL ,
+   `PassHours` float DEFAULT NULL ,
-   `PassPrice` int (11) DEFAULT NULL ,
+   `PassPrice` int (11) DEFAULT NULL ,
-   `SnapshotUUID` varchar (255) DEFAULT NULL ,
+   `SnapshotUUID` varchar (255) DEFAULT NULL ,
-   `UserLocationX` float DEFAULT NULL ,
+   `UserLocationX` float DEFAULT NULL ,
-   `UserLocationY` float DEFAULT NULL ,
+   `UserLocationY` float DEFAULT NULL ,
-   `UserLocationZ` float DEFAULT NULL ,
+   `UserLocationZ` float DEFAULT NULL ,
-   `UserLookAtX` float DEFAULT NULL ,
+   `UserLookAtX` float DEFAULT NULL ,
-   `UserLookAtY` float DEFAULT NULL ,
+   `UserLookAtY` float DEFAULT NULL ,
-   `UserLookAtZ` float DEFAULT NULL ,
+   `UserLookAtZ` float DEFAULT NULL ,
-   `AuthbuyerID` varchar(36) default '00000000-0000-0000-0000-000000000000' not null,
+   `AuthbuyerID` varchar(36) default '00000000-0000-0000-0000-000000000000' not null,
-   
+   
-   PRIMARY KEY (`UUID`)
+   PRIMARY KEY (`UUID`)
-   )
+   )
-   ENGINE=INNODB
+   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` 
+ALTER TABLE `land` 
-        ADD COLUMN `AuthbuyerID` varchar(36) default '00000000-0000-0000-0000-000000000000' not null,
+        ADD COLUMN `AuthbuyerID` varchar(36) default '00000000-0000-0000-0000-000000000000' not null,
 COMMENT='Rev. 2';
 \ No newline at end of file
author	Jeff Ames	2008-05-01 14:31:30 +0000
committer	Jeff Ames	2008-05-01 14:31:30 +0000
commit	d51ce47b2d7635b17f3dd429158e8f59b78b83aa (patch)
tree	d3595bd5194199184059aa398b91a51dc6c799cf /OpenSim/Data
parent	* Looks like I had the bamboo build right in the first place - it was just th... (diff)
download	opensim-SC-d51ce47b2d7635b17f3dd429158e8f59b78b83aa.zip opensim-SC-d51ce47b2d7635b17f3dd429158e8f59b78b83aa.tar.gz opensim-SC-d51ce47b2d7635b17f3dd429158e8f59b78b83aa.tar.bz2 opensim-SC-d51ce47b2d7635b17f3dd429158e8f59b78b83aa.tar.xz

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