aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/SQLite/Resources')
-rw-r--r--OpenSim/Data/SQLite/Resources/HGTravelStore.migrations20
1 files changed, 10 insertions, 10 deletions
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 @@
1:VERSION 1 # -------------------------- 1:VERSION 2 # --------------------------
2 2
3BEGIN; 3BEGIN;
4 4
5CREATE TABLE hg_traveling_data ( 5CREATE TABLE hg_traveling_data(
6 SessionID VARCHAR(36) NOT NULL, 6 SessionID VARCHAR(36) NOT NULL,
7 UserID VARCHAR(36) NOT NULL, 7 UserID VARCHAR(36) NOT NULL,
8 GridExternalName VARCHAR(255) NOT NULL DEFAULT '', 8 GridExternalName VARCHAR(255) NOT NULL DEFAULT "",
9 ServiceToken VARCHAR(255) NOT NULL DEFAULT '', 9 ServiceToken VARCHAR(255) NOT NULL DEFAULT "",
10 ClientIPAddress VARCHAR(16) NOT NULL DEFAULT '', 10 ClientIPAddress VARCHAR(16) NOT NULL DEFAULT "",
11 MyIPAddress VARCHAR(16) NOT NULL DEFAULT '', 11 MyIPAddress VARCHAR(16) NOT NULL DEFAULT "",
12 TMStamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 12 TMStamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
13 PRIMARY KEY (`SessionID`), 13 PRIMARY KEY(SessionID),
14 KEY (`UserID`) 14 UNIQUE(UserID)
15) ENGINE=InnoDB; 15);
16 16
17COMMIT; 17COMMIT;
18 18