diff options
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/GridUserStore.migrations')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/GridUserStore.migrations | 9 |
1 files changed, 2 insertions, 7 deletions
diff --git a/OpenSim/Data/MySQL/Resources/GridUserStore.migrations b/OpenSim/Data/MySQL/Resources/GridUserStore.migrations index e2be27e..dd73974 100644 --- a/OpenSim/Data/MySQL/Resources/GridUserStore.migrations +++ b/OpenSim/Data/MySQL/Resources/GridUserStore.migrations | |||
@@ -2,7 +2,7 @@ | |||
2 | 2 | ||
3 | BEGIN; | 3 | BEGIN; |
4 | 4 | ||
5 | CREATE TABLE `GridUser` ( | 5 | CREATE TABLE IF NOT EXISTS `GridUser` ( |
6 | `UserID` VARCHAR(255) NOT NULL, | 6 | `UserID` VARCHAR(255) NOT NULL, |
7 | `HomeRegionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', | 7 | `HomeRegionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
8 | `HomePosition` CHAR(64) NOT NULL DEFAULT '<0,0,0>', | 8 | `HomePosition` CHAR(64) NOT NULL DEFAULT '<0,0,0>', |
@@ -14,11 +14,6 @@ CREATE TABLE `GridUser` ( | |||
14 | `Login` CHAR(16) NOT NULL DEFAULT '0', | 14 | `Login` CHAR(16) NOT NULL DEFAULT '0', |
15 | `Logout` CHAR(16) NOT NULL DEFAULT '0', | 15 | `Logout` CHAR(16) NOT NULL DEFAULT '0', |
16 | PRIMARY KEY (`UserID`) | 16 | PRIMARY KEY (`UserID`) |
17 | ) ENGINE=MyISAM; | 17 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
18 | |||
19 | COMMIT; | ||
20 | |||
21 | :VERSION 2 # -------------------------- | ||
22 | BEGIN; | ||
23 | 18 | ||
24 | COMMIT; | 19 | COMMIT; |