diff options
| author | Diva Canto | 2013-07-14 15:47:54 -0700 |
|---|---|---|
| committer | Diva Canto | 2013-07-14 15:47:54 -0700 |
| commit | b0140383da21de03cb655160a2912d04c5b470e6 (patch) | |
| tree | 091f9a16f9f8da857820938e093c20ac7aafad97 /OpenSim/Data/MySQL/Resources | |
| parent | HG UAS: Moved hg-session data from memory to DB storage. This makes it so tha... (diff) | |
| download | opensim-SC_OLD-b0140383da21de03cb655160a2912d04c5b470e6.zip opensim-SC_OLD-b0140383da21de03cb655160a2912d04c5b470e6.tar.gz opensim-SC_OLD-b0140383da21de03cb655160a2912d04c5b470e6.tar.bz2 opensim-SC_OLD-b0140383da21de03cb655160a2912d04c5b470e6.tar.xz | |
Cleanup old hg sessions (older than 2 days)
Diffstat (limited to 'OpenSim/Data/MySQL/Resources')
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/HGTravelStore.migrations | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations b/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations index a0c9ebe..b4e4422 100644 --- a/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations +++ b/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations | |||
| @@ -9,6 +9,7 @@ CREATE TABLE `hg_traveling_data` ( | |||
| 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, | ||
| 12 | PRIMARY KEY (`SessionID`), | 13 | PRIMARY KEY (`SessionID`), |
| 13 | KEY (`UserID`) | 14 | KEY (`UserID`) |
| 14 | ) ENGINE=InnoDB; | 15 | ) ENGINE=InnoDB; |