diff options
Diffstat (limited to 'OpenSim/Data/MySQL/Resources')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/GridStore.migrations | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/OpenSim/Data/MySQL/Resources/GridStore.migrations b/OpenSim/Data/MySQL/Resources/GridStore.migrations index 98ba8c5..b8d287a 100644 --- a/OpenSim/Data/MySQL/Resources/GridStore.migrations +++ b/OpenSim/Data/MySQL/Resources/GridStore.migrations | |||
@@ -1,5 +1,7 @@ | |||
1 | :VERSION 1 | 1 | :VERSION 1 |
2 | 2 | ||
3 | BEGIN; | ||
4 | |||
3 | CREATE TABLE `regions` ( | 5 | CREATE TABLE `regions` ( |
4 | `uuid` varchar(36) NOT NULL, | 6 | `uuid` varchar(36) NOT NULL, |
5 | `regionHandle` bigint(20) unsigned NOT NULL, | 7 | `regionHandle` bigint(20) unsigned NOT NULL, |
@@ -31,7 +33,9 @@ CREATE TABLE `regions` ( | |||
31 | KEY `regionName` (`regionName`), | 33 | KEY `regionName` (`regionName`), |
32 | KEY `regionHandle` (`regionHandle`), | 34 | KEY `regionHandle` (`regionHandle`), |
33 | KEY `overrideHandles` (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`) | 35 | KEY `overrideHandles` (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`) |
34 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Rev. 3'; | 36 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
37 | |||
38 | COMMIT; | ||
35 | 39 | ||
36 | :VERSION 2 | 40 | :VERSION 2 |
37 | 41 | ||