diff options
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/RegionStore.migrations')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/RegionStore.migrations | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/OpenSim/Data/MySQL/Resources/RegionStore.migrations b/OpenSim/Data/MySQL/Resources/RegionStore.migrations index 5b59779..071f64e 100644 --- a/OpenSim/Data/MySQL/Resources/RegionStore.migrations +++ b/OpenSim/Data/MySQL/Resources/RegionStore.migrations | |||
@@ -146,7 +146,7 @@ CREATE TABLE `land` ( | |||
146 | `UserLookAtZ` float default NULL, | 146 | `UserLookAtZ` float default NULL, |
147 | `AuthbuyerID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000', | 147 | `AuthbuyerID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000', |
148 | PRIMARY KEY (`UUID`) | 148 | PRIMARY KEY (`UUID`) |
149 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 149 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
150 | 150 | ||
151 | CREATE TABLE `landaccesslist` ( | 151 | CREATE TABLE `landaccesslist` ( |
152 | `LandUUID` varchar(255) default NULL, | 152 | `LandUUID` varchar(255) default NULL, |
@@ -168,7 +168,7 @@ COMMIT; | |||
168 | :VERSION 3 #--------------------- | 168 | :VERSION 3 #--------------------- |
169 | 169 | ||
170 | BEGIN; | 170 | BEGIN; |
171 | CREATE TABLE regionban (regionUUID VARCHAR(36) NOT NULL, bannedUUID VARCHAR(36) NOT NULL, bannedIp VARCHAR(16) NOT NULL, bannedIpHostMask VARCHAR(16) NOT NULL) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; | 171 | CREATE TABLE regionban (regionUUID VARCHAR(36) NOT NULL, bannedUUID VARCHAR(36) NOT NULL, bannedIp VARCHAR(16) NOT NULL, bannedIpHostMask VARCHAR(16) NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; |
172 | COMMIT; | 172 | COMMIT; |
173 | 173 | ||
174 | :VERSION 4 #--------------------- | 174 | :VERSION 4 #--------------------- |
@@ -226,13 +226,13 @@ COMMIT; | |||
226 | 226 | ||
227 | BEGIN; | 227 | BEGIN; |
228 | 228 | ||
229 | alter table landaccesslist ENGINE = InnoDB; | 229 | alter table landaccesslist ENGINE = MyISAM; |
230 | alter table migrations ENGINE = InnoDB; | 230 | alter table migrations ENGINE = MyISAM; |
231 | alter table primitems ENGINE = InnoDB; | 231 | alter table primitems ENGINE = MyISAM; |
232 | alter table prims ENGINE = InnoDB; | 232 | alter table prims ENGINE = MyISAM; |
233 | alter table primshapes ENGINE = InnoDB; | 233 | alter table primshapes ENGINE = MyISAM; |
234 | alter table regionsettings ENGINE = InnoDB; | 234 | alter table regionsettings ENGINE = MyISAM; |
235 | alter table terrain ENGINE = InnoDB; | 235 | alter table terrain ENGINE = MyISAM; |
236 | 236 | ||
237 | COMMIT; | 237 | COMMIT; |
238 | 238 | ||
@@ -384,7 +384,7 @@ CREATE TABLE `regionsettings` ( | |||
384 | `covenant` char(36) default NULL, | 384 | `covenant` char(36) default NULL, |
385 | `Sandbox` tinyint(4) NOT NULL, | 385 | `Sandbox` tinyint(4) NOT NULL, |
386 | PRIMARY KEY (`regionUUID`) | 386 | PRIMARY KEY (`regionUUID`) |
387 | ) ENGINE=InnoDB; | 387 | ) ENGINE=MyISAM; |
388 | 388 | ||
389 | commit; | 389 | commit; |
390 | 390 | ||
@@ -852,7 +852,7 @@ CREATE TABLE IF NOT EXISTS `spawn_points` ( | |||
852 | `Pitch` float NOT NULL, | 852 | `Pitch` float NOT NULL, |
853 | `Distance` float NOT NULL, | 853 | `Distance` float NOT NULL, |
854 | KEY `RegionID` (`RegionID`) | 854 | KEY `RegionID` (`RegionID`) |
855 | ) ENGINE=Innodb; | 855 | ) ENGINE=MyISAM; |
856 | 856 | ||
857 | ALTER TABLE `regionsettings` ADD COLUMN `TelehubObject` varchar(36) NOT NULL; | 857 | ALTER TABLE `regionsettings` ADD COLUMN `TelehubObject` varchar(36) NOT NULL; |
858 | COMMIT; | 858 | COMMIT; |
@@ -891,7 +891,7 @@ CREATE TABLE `regionenvironment` ( | |||
891 | `region_id` varchar(36) NOT NULL, | 891 | `region_id` varchar(36) NOT NULL, |
892 | `llsd_settings` TEXT NOT NULL, | 892 | `llsd_settings` TEXT NOT NULL, |
893 | PRIMARY KEY (`region_id`) | 893 | PRIMARY KEY (`region_id`) |
894 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 894 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
895 | 895 | ||
896 | COMMIT; | 896 | COMMIT; |
897 | 897 | ||