diff options
author | Shy Robbiani | 2015-11-20 21:35:08 +0100 |
---|---|---|
committer | Kevin Cozens | 2015-11-21 20:03:42 -0500 |
commit | 01e7fa30954e29996d07221264f3e2c73a819fca (patch) | |
tree | 51addd4d9bdbf8e34a53ecfd86e3df0df3e2ebc9 /OpenSim/Data | |
parent | add a missing override (diff) | |
download | opensim-SC_OLD-01e7fa30954e29996d07221264f3e2c73a819fca.zip opensim-SC_OLD-01e7fa30954e29996d07221264f3e2c73a819fca.tar.gz opensim-SC_OLD-01e7fa30954e29996d07221264f3e2c73a819fca.tar.bz2 opensim-SC_OLD-01e7fa30954e29996d07221264f3e2c73a819fca.tar.xz |
row format fixed removed to allow creation of regions table
row_format=fixed is not supported by innodb and has broken the creation
of the regions table during the first startup of ROBUST. It must be a
relict from MyISAM. Also removed the probably inappropriate table
comment.
Signed-off-by: Kevin Cozens <kevin@ve3syb.ca>
Diffstat (limited to 'OpenSim/Data')
-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 | ||