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