From 32d58d6e3e9a0ea1bfa808567d0f64c0652f8a85 Mon Sep 17 00:00:00 2001
From: BlueWall
Date: Sat, 21 Jan 2012 23:26:27 -0500
Subject: 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.
---
 OpenSim/Data/MySQL/Resources/EstateStore.migrations | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)

(limited to 'OpenSim/Data/MySQL/Resources/EstateStore.migrations')

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
-- 
cgit v1.1