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 'OpenSim/Data/SQLite/Resources/HGTravelStore.migrations')
| -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 | ||