diff options
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/HGTravelStore.migrations')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/HGTravelStore.migrations | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations b/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations index ed1fede..0766733 100644 --- a/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations +++ b/OpenSim/Data/MySQL/Resources/HGTravelStore.migrations | |||
@@ -12,6 +12,13 @@ CREATE TABLE IF NOT EXISTS `hg_traveling_data` ( | |||
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 DEFAULT CHARSET=utf8; | 15 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; |
16 | 16 | ||
17 | COMMIT; | 17 | COMMIT; |
18 | |||
19 | :VERSION 2 # -------------------------- | ||
20 | |||
21 | ALTER TABLE `hg_traveling_data` MODIFY `TMStamp` timestamp NOT NULL default CURRENT_TIMESTAMP; | ||
22 | |||
23 | COMMIT; | ||
24 | |||