diff options
author | Diva Canto | 2013-07-19 20:24:56 -0700 |
---|---|---|
committer | Diva Canto | 2013-07-19 20:25:33 -0700 |
commit | c1705236c7b0fe779c52b56a4531eb036817de89 (patch) | |
tree | 5808524667783c7672318c46ed1f8a02d1eb458a /OpenSim/Data/SQLite/Resources/HGTravelStore.migrations | |
parent | Enable storing of environment settings in NullSimulationData (diff) | |
download | opensim-SC_OLD-c1705236c7b0fe779c52b56a4531eb036817de89.zip opensim-SC_OLD-c1705236c7b0fe779c52b56a4531eb036817de89.tar.gz opensim-SC_OLD-c1705236c7b0fe779c52b56a4531eb036817de89.tar.bz2 opensim-SC_OLD-c1705236c7b0fe779c52b56a4531eb036817de89.tar.xz |
Fix HGTravelStore.migrations in SQLite (mantis #6709)
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/SQLite/Resources/HGTravelStore.migrations | 20 |
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 | ||
3 | BEGIN; | 3 | BEGIN; |
4 | 4 | ||
5 | CREATE TABLE hg_traveling_data ( | 5 | CREATE 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 | ||
17 | COMMIT; | 17 | COMMIT; |
18 | 18 | ||