From af02231a7b334dde1e3dcbea03c93fe11bcc6037 Mon Sep 17 00:00:00 2001
From: Diva Canto
Date: Sun, 14 Jul 2013 16:03:46 -0700
Subject: Added SQLite version of hg travel data store. UNTESTED. Hope it
 works!

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

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

diff --git a/OpenSim/Data/SQLite/Resources/HGTravelStore.migrations b/OpenSim/Data/SQLite/Resources/HGTravelStore.migrations
new file mode 100644
index 0000000..2e73caa
--- /dev/null
+++ b/OpenSim/Data/SQLite/Resources/HGTravelStore.migrations
@@ -0,0 +1,18 @@
+: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 '',
+    TMStamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+    PRIMARY KEY  (`SessionID`),
+	KEY (`UserID`)
+) ENGINE=InnoDB;
+
+COMMIT;
+
-- 
cgit v1.1


From c1705236c7b0fe779c52b56a4531eb036817de89 Mon Sep 17 00:00:00 2001
From: Diva Canto
Date: Fri, 19 Jul 2013 20:24:56 -0700
Subject: Fix HGTravelStore.migrations in SQLite (mantis #6709)

---
 .../Data/SQLite/Resources/HGTravelStore.migrations   | 20 ++++++++++----------
 1 file changed, 10 insertions(+), 10 deletions(-)

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

diff --git a/OpenSim/Data/SQLite/Resources/HGTravelStore.migrations b/OpenSim/Data/SQLite/Resources/HGTravelStore.migrations
index 2e73caa..02612ce 100644
--- a/OpenSim/Data/SQLite/Resources/HGTravelStore.migrations
+++ b/OpenSim/Data/SQLite/Resources/HGTravelStore.migrations
@@ -1,18 +1,18 @@
-:VERSION 1         # -------------------------- 
+:VERSION 2         # -------------------------- 
 
 BEGIN;
 
-CREATE TABLE hg_traveling_data (
+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 '',
-    TMStamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
-    PRIMARY KEY  (`SessionID`),
-	KEY (`UserID`)
-) ENGINE=InnoDB;
+    GridExternalName VARCHAR(255) NOT NULL DEFAULT "",
+    ServiceToken VARCHAR(255) NOT NULL DEFAULT "",
+    ClientIPAddress VARCHAR(16) NOT NULL DEFAULT "",
+    MyIPAddress VARCHAR(16) NOT NULL DEFAULT "",
+    TMStamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+    PRIMARY KEY(SessionID),
+    UNIQUE(UserID)
+);
 
 COMMIT;
 
-- 
cgit v1.1