diff options
Diffstat (limited to 'OpenSim')
| -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 | ||