From e33ac50388b5b9d6d06c58c45e2ea6f17e9b987f Mon Sep 17 00:00:00 2001
From: Diva Canto
Date: Sun, 14 Jul 2013 14:31:20 -0700
Subject: HG UAS: Moved hg-session data from memory to DB storage. This makes
 it so that traveling info survives Robust resets. It should also eliminate
 the cause of empty IP addresses in agent circuit data that we saw in CC grid.
 MySQL only.

---
 OpenSim/Data/MySQL/Resources/HGTravelStore.migrations | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 OpenSim/Data/MySQL/Resources/HGTravelStore.migrations

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

diff --git a/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations b/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations
new file mode 100644
index 0000000..a0c9ebe
--- /dev/null
+++ b/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations
@@ -0,0 +1,17 @@
+:VERSION 1         # -------------------------- 
+
+BEGIN;
+
+CREATE TABLE `hg_traveling_data` (
+    `SessionID` VARCHAR(36) NOT NULL,
+    `UserID` VARCHAR(36) NOT NULL,
+	`GridExternalName` VARCHAR(255) NOT NULL DEFAULT '',
+	`ServiceToken` VARCHAR(255) NOT NULL DEFAULT '',
+	`ClientIPAddress` VARCHAR(16) NOT NULL DEFAULT '',
+	`MyIPAddress` VARCHAR(16) NOT NULL DEFAULT '',
+    PRIMARY KEY  (`SessionID`),
+	KEY (`UserID`)
+) ENGINE=InnoDB;
+
+COMMIT;
+
-- 
cgit v1.1