2 files changed, 42 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 @@
+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
new file mode 100644
index 0000000..eb024be
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/UpgradeLandTableToVersion2.sql
@@ -0,0 +1,3 @@
+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

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


diff --git a/OpenSim/Data/MySQL/Resources/UpgradeLandTableToVersion2.sql b/OpenSim/Data/MySQL/Resources/UpgradeLandTableToVersion2.sql new file mode 100644 index 0000000..eb024be --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/UpgradeLandTableToVersion2.sql
@@ -0,0 +1,3 @@
	1	ALTER TABLE `land`
	2	ADD COLUMN `AuthbuyerID` varchar(36) default '00000000-0000-0000-0000-000000000000' not null,
	3	COMMENT='Rev. 2'; \ No newline at end of file