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')

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


From b0140383da21de03cb655160a2912d04c5b470e6 Mon Sep 17 00:00:00 2001
From: Diva Canto
Date: Sun, 14 Jul 2013 15:47:54 -0700
Subject: Cleanup old hg sessions (older than 2 days)

---
 OpenSim/Data/MySQL/Resources/HGTravelStore.migrations | 1 +
 1 file changed, 1 insertion(+)

(limited to 'OpenSim/Data/MySQL/Resources')

diff --git a/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations b/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations
index a0c9ebe..b4e4422 100644
--- a/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations
@@ -9,6 +9,7 @@ CREATE TABLE `hg_traveling_data` (
 	`ServiceToken` VARCHAR(255) NOT NULL DEFAULT '',
 	`ClientIPAddress` VARCHAR(16) NOT NULL DEFAULT '',
 	`MyIPAddress` VARCHAR(16) NOT NULL DEFAULT '',
+    `TMStamp` timestamp NOT NULL,
     PRIMARY KEY  (`SessionID`),
 	KEY (`UserID`)
 ) ENGINE=InnoDB;
-- 
cgit v1.1