diff options
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/RegionStore.migrations')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/RegionStore.migrations | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/OpenSim/Data/MySQL/Resources/RegionStore.migrations b/OpenSim/Data/MySQL/Resources/RegionStore.migrations index 2108c76..c63cc95 100644 --- a/OpenSim/Data/MySQL/Resources/RegionStore.migrations +++ b/OpenSim/Data/MySQL/Resources/RegionStore.migrations | |||
@@ -97,7 +97,7 @@ CREATE TABLE IF NOT EXISTS `prims` ( | |||
97 | PRIMARY KEY (`UUID`), | 97 | PRIMARY KEY (`UUID`), |
98 | KEY `prims_regionuuid` (`RegionUUID`), | 98 | KEY `prims_regionuuid` (`RegionUUID`), |
99 | KEY `prims_scenegroupid` (`SceneGroupID`) | 99 | KEY `prims_scenegroupid` (`SceneGroupID`) |
100 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 100 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
101 | 101 | ||
102 | CREATE TABLE IF NOT EXISTS `primshapes` ( | 102 | CREATE TABLE IF NOT EXISTS `primshapes` ( |
103 | `Shape` int(11) DEFAULT NULL, | 103 | `Shape` int(11) DEFAULT NULL, |
@@ -130,7 +130,7 @@ CREATE TABLE IF NOT EXISTS `primshapes` ( | |||
130 | `Media` text, | 130 | `Media` text, |
131 | `LastAttachPoint` int(4) NOT NULL DEFAULT '0', | 131 | `LastAttachPoint` int(4) NOT NULL DEFAULT '0', |
132 | PRIMARY KEY (`UUID`) | 132 | PRIMARY KEY (`UUID`) |
133 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 133 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
134 | 134 | ||
135 | CREATE TABLE IF NOT EXISTS `primitems` ( | 135 | CREATE TABLE IF NOT EXISTS `primitems` ( |
136 | `invType` int(11) DEFAULT NULL, | 136 | `invType` int(11) DEFAULT NULL, |
@@ -154,13 +154,13 @@ CREATE TABLE IF NOT EXISTS `primitems` ( | |||
154 | `lastOwnerID` char(36) DEFAULT NULL, | 154 | `lastOwnerID` char(36) DEFAULT NULL, |
155 | PRIMARY KEY (`itemID`), | 155 | PRIMARY KEY (`itemID`), |
156 | KEY `primitems_primid` (`primID`) | 156 | KEY `primitems_primid` (`primID`) |
157 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 157 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
158 | 158 | ||
159 | CREATE TABLE IF NOT EXISTS `terrain` ( | 159 | CREATE TABLE IF NOT EXISTS `terrain` ( |
160 | `RegionUUID` varchar(255) DEFAULT NULL, | 160 | `RegionUUID` varchar(255) DEFAULT NULL, |
161 | `Revision` int(11) DEFAULT NULL, | 161 | `Revision` int(11) DEFAULT NULL, |
162 | `Heightfield` longblob | 162 | `Heightfield` longblob |
163 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 163 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
164 | 164 | ||
165 | CREATE TABLE IF NOT EXISTS `land` ( | 165 | CREATE TABLE IF NOT EXISTS `land` ( |
166 | `UUID` varchar(255) NOT NULL, | 166 | `UUID` varchar(255) NOT NULL, |
@@ -204,21 +204,21 @@ CREATE TABLE IF NOT EXISTS `land` ( | |||
204 | `ObscureMusic` tinyint(1) NOT NULL DEFAULT '0', | 204 | `ObscureMusic` tinyint(1) NOT NULL DEFAULT '0', |
205 | `ObscureMedia` tinyint(1) NOT NULL DEFAULT '0', | 205 | `ObscureMedia` tinyint(1) NOT NULL DEFAULT '0', |
206 | PRIMARY KEY (`UUID`) | 206 | PRIMARY KEY (`UUID`) |
207 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | 207 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
208 | 208 | ||
209 | CREATE TABLE IF NOT EXISTS `landaccesslist` ( | 209 | CREATE TABLE IF NOT EXISTS `landaccesslist` ( |
210 | `LandUUID` varchar(255) DEFAULT NULL, | 210 | `LandUUID` varchar(255) DEFAULT NULL, |
211 | `AccessUUID` varchar(255) DEFAULT NULL, | 211 | `AccessUUID` varchar(255) DEFAULT NULL, |
212 | `Flags` int(11) DEFAULT NULL, | 212 | `Flags` int(11) DEFAULT NULL, |
213 | `Expires` int(11) NOT NULL DEFAULT '0' | 213 | `Expires` int(11) NOT NULL DEFAULT '0' |
214 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; | 214 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
215 | 215 | ||
216 | CREATE TABLE IF NOT EXISTS `regionban` ( | 216 | CREATE TABLE IF NOT EXISTS `regionban` ( |
217 | `regionUUID` varchar(36) NOT NULL, | 217 | `regionUUID` varchar(36) NOT NULL, |
218 | `bannedUUID` varchar(36) NOT NULL, | 218 | `bannedUUID` varchar(36) NOT NULL, |
219 | `bannedIp` varchar(16) NOT NULL, | 219 | `bannedIp` varchar(16) NOT NULL, |
220 | `bannedIpHostMask` varchar(16) NOT NULL | 220 | `bannedIpHostMask` varchar(16) NOT NULL |
221 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | 221 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
222 | 222 | ||
223 | CREATE TABLE IF NOT EXISTS `regionsettings` ( | 223 | CREATE TABLE IF NOT EXISTS `regionsettings` ( |
224 | `regionUUID` char(36) NOT NULL, | 224 | `regionUUID` char(36) NOT NULL, |
@@ -265,7 +265,7 @@ CREATE TABLE IF NOT EXISTS `regionsettings` ( | |||
265 | `parcel_tile_ID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', | 265 | `parcel_tile_ID` char(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
266 | `covenant_datetime` int(10) unsigned NOT NULL DEFAULT '0', | 266 | `covenant_datetime` int(10) unsigned NOT NULL DEFAULT '0', |
267 | PRIMARY KEY (`regionUUID`) | 267 | PRIMARY KEY (`regionUUID`) |
268 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; | 268 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
269 | 269 | ||
270 | CREATE TABLE IF NOT EXISTS `regionwindlight` ( | 270 | CREATE TABLE IF NOT EXISTS `regionwindlight` ( |
271 | `region_id` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000', | 271 | `region_id` varchar(36) NOT NULL DEFAULT '000000-0000-0000-0000-000000000000', |