diff options
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/HGTravelStore.migrations')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/HGTravelStore.migrations | 23 |
1 files changed, 11 insertions, 12 deletions
diff --git a/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations b/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations index 06ca29d..ed1fede 100644 --- a/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations +++ b/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations | |||
@@ -2,17 +2,16 @@ | |||
2 | 2 | ||
3 | BEGIN; | 3 | BEGIN; |
4 | 4 | ||
5 | CREATE TABLE `hg_traveling_data` ( | 5 | CREATE TABLE IF NOT EXISTS `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, | 12 | `TMStamp` timestamp NOT NULL, |
13 | PRIMARY KEY (`SessionID`), | 13 | PRIMARY KEY (`SessionID`), |
14 | KEY (`UserID`) | 14 | KEY (`UserID`) |
15 | ) ENGINE=MyISAM; | 15 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
16 | 16 | ||
17 | COMMIT; | 17 | COMMIT; |
18 | |||