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

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