Telehub Support:

	Telehub settings now persist to the database and are saved across sim restarts. So-far this only works on MySQL. this is a work in progress, teleport routing is not yet implemented.

1 files changed, 21 insertions, 0 deletions

diff --git a/OpenSim/Data/MySQL/Resources/EstateStore.migrations b/OpenSim/Data/MySQL/Resources/EstateStore.migrations
index df82a2e..591295b 100644
--- a/OpenSim/Data/MySQL/Resources/EstateStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/EstateStore.migrations
@@ -78,4 +78,25 @@ ALTER TABLE estate_settings AUTO_INCREMENT = 100;
 COMMIT;
 
 
+:VERSION 33         #--------------------- ( Supporting Telehubs
 
+BEGIN;
+CREATE TABLE IF NOT EXISTS `spawn_points` (
+  `EstateID` varchar(36) COLLATE utf8_unicode_ci NOT NULL,
+  `PointX` float NOT NULL,
+  `PointY` float NOT NULL,
+  `PointZ` float NOT NULL,
+  KEY `EstateID` (`EstateID`)
+) ENGINE=Innodb;
+
+ALTER TABLE `estate_settings` ADD COLUMN `TelehubObject` varchar(36) NOT NULL;
+ALTER TABLE `estate_settings` ADD COLUMN `TelehubName` varchar(255) NOT NULL;
+ALTER TABLE `estate_settings` ADD COLUMN `TelehubEnabled` tinyint(4) NOT NULL;
+ALTER TABLE `estate_settings` ADD COLUMN `TelehubPosX` float NOT NULL;
+ALTER TABLE `estate_settings` ADD COLUMN `TelehubPosY` float NOT NULL;
+ALTER TABLE `estate_settings` ADD COLUMN `TelehubPosZ` float NOT NULL;
+ALTER TABLE `estate_settings` ADD COLUMN `TelehubRotX` float NOT NULL;
+ALTER TABLE `estate_settings` ADD COLUMN `TelehubRotY` float NOT NULL;
+ALTER TABLE `estate_settings` ADD COLUMN `TelehubRotZ` float NOT NULL;
+ALTER TABLE `estate_settings` ADD COLUMN `TelehubRotW` float NOT NULL;
+COMMIT;
\ No newline at end of file