diff options
author | David Walter Seikel | 2013-02-23 07:20:32 +1000 |
---|---|---|
committer | David Walter Seikel | 2013-02-23 07:20:32 +1000 |
commit | 18af255e90b54b7b1d39eb20f4932ba433bc7b55 (patch) | |
tree | d5559672bfe22a6fca85a5722d9537a376f941f7 /OpenSim/Data/MySQL/Resources | |
parent | Add IG version bits. (diff) | |
download | opensim-SC_OLD-18af255e90b54b7b1d39eb20f4932ba433bc7b55.zip opensim-SC_OLD-18af255e90b54b7b1d39eb20f4932ba433bc7b55.tar.gz opensim-SC_OLD-18af255e90b54b7b1d39eb20f4932ba433bc7b55.tar.bz2 opensim-SC_OLD-18af255e90b54b7b1d39eb20f4932ba433bc7b55.tar.xz |
MyISAM is much better performing for OpenSim.
Diffstat (limited to '')
12 files changed, 35 insertions, 35 deletions
diff --git a/OpenSim/Data/MySQL/Resources/AssetStore.migrations b/OpenSim/Data/MySQL/Resources/AssetStore.migrations index e0526fe..f7211c2 100644 --- a/OpenSim/Data/MySQL/Resources/AssetStore.migrations +++ b/OpenSim/Data/MySQL/Resources/AssetStore.migrations | |||
@@ -13,7 +13,7 @@ CREATE TABLE `assets` ( | |||
13 | `temporary` tinyint(1) NOT NULL, | 13 | `temporary` tinyint(1) NOT NULL, |
14 | `data` longblob NOT NULL, | 14 | `data` longblob NOT NULL, |
15 | PRIMARY KEY (`id`) | 15 | PRIMARY KEY (`id`) |
16 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; | 16 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Rev. 1'; |
17 | 17 | ||
18 | COMMIT; | 18 | COMMIT; |
19 | 19 | ||
diff --git a/OpenSim/Data/MySQL/Resources/AuthStore.migrations b/OpenSim/Data/MySQL/Resources/AuthStore.migrations index 023c786..9450940 100644 --- a/OpenSim/Data/MySQL/Resources/AuthStore.migrations +++ b/OpenSim/Data/MySQL/Resources/AuthStore.migrations | |||
@@ -8,7 +8,7 @@ CREATE TABLE `auth` ( | |||
8 | `passwordSalt` char(32) NOT NULL default '', | 8 | `passwordSalt` char(32) NOT NULL default '', |
9 | `webLoginKey` varchar(255) NOT NULL default '', | 9 | `webLoginKey` varchar(255) NOT NULL default '', |
10 | PRIMARY KEY (`UUID`) | 10 | PRIMARY KEY (`UUID`) |
11 | ) ENGINE=InnoDB; | 11 | ) ENGINE=MyISAM; |
12 | 12 | ||
13 | CREATE TABLE `tokens` ( | 13 | CREATE TABLE `tokens` ( |
14 | `UUID` char(36) NOT NULL, | 14 | `UUID` char(36) NOT NULL, |
@@ -18,7 +18,7 @@ CREATE TABLE `tokens` ( | |||
18 | KEY `UUID` (`UUID`), | 18 | KEY `UUID` (`UUID`), |
19 | KEY `token` (`token`), | 19 | KEY `token` (`token`), |
20 | KEY `validity` (`validity`) | 20 | KEY `validity` (`validity`) |
21 | ) ENGINE=InnoDB; | 21 | ) ENGINE=MyISAM; |
22 | 22 | ||
23 | commit; | 23 | commit; |
24 | 24 | ||
diff --git a/OpenSim/Data/MySQL/Resources/EstateStore.migrations b/OpenSim/Data/MySQL/Resources/EstateStore.migrations index df82a2e..6ef92ee 100644 --- a/OpenSim/Data/MySQL/Resources/EstateStore.migrations +++ b/OpenSim/Data/MySQL/Resources/EstateStore.migrations | |||
@@ -10,19 +10,19 @@ CREATE TABLE IF NOT EXISTS `estate_managers` ( | |||
10 | `EstateID` int(10) unsigned NOT NULL, | 10 | `EstateID` int(10) unsigned NOT NULL, |
11 | `uuid` char(36) NOT NULL, | 11 | `uuid` char(36) NOT NULL, |
12 | KEY `EstateID` (`EstateID`) | 12 | KEY `EstateID` (`EstateID`) |
13 | ) ENGINE=InnoDB; | 13 | ) ENGINE=MyISAM; |
14 | 14 | ||
15 | CREATE TABLE IF NOT EXISTS `estate_groups` ( | 15 | CREATE TABLE IF NOT EXISTS `estate_groups` ( |
16 | `EstateID` int(10) unsigned NOT NULL, | 16 | `EstateID` int(10) unsigned NOT NULL, |
17 | `uuid` char(36) NOT NULL, | 17 | `uuid` char(36) NOT NULL, |
18 | KEY `EstateID` (`EstateID`) | 18 | KEY `EstateID` (`EstateID`) |
19 | ) ENGINE=InnoDB; | 19 | ) ENGINE=MyISAM; |
20 | 20 | ||
21 | CREATE TABLE IF NOT EXISTS `estate_users` ( | 21 | CREATE TABLE IF NOT EXISTS `estate_users` ( |
22 | `EstateID` int(10) unsigned NOT NULL, | 22 | `EstateID` int(10) unsigned NOT NULL, |
23 | `uuid` char(36) NOT NULL, | 23 | `uuid` char(36) NOT NULL, |
24 | KEY `EstateID` (`EstateID`) | 24 | KEY `EstateID` (`EstateID`) |
25 | ) ENGINE=InnoDB; | 25 | ) ENGINE=MyISAM; |
26 | 26 | ||
27 | CREATE TABLE IF NOT EXISTS `estateban` ( | 27 | CREATE TABLE IF NOT EXISTS `estateban` ( |
28 | `EstateID` int(10) unsigned NOT NULL, | 28 | `EstateID` int(10) unsigned NOT NULL, |
@@ -31,7 +31,7 @@ CREATE TABLE IF NOT EXISTS `estateban` ( | |||
31 | `bannedIpHostMask` varchar(16) NOT NULL, | 31 | `bannedIpHostMask` varchar(16) NOT NULL, |
32 | `bannedNameMask` varchar(64) default NULL, | 32 | `bannedNameMask` varchar(64) default NULL, |
33 | KEY `estateban_EstateID` (`EstateID`) | 33 | KEY `estateban_EstateID` (`EstateID`) |
34 | ) ENGINE=InnoDB; | 34 | ) ENGINE=MyISAM; |
35 | 35 | ||
36 | CREATE TABLE IF NOT EXISTS `estate_settings` ( | 36 | CREATE TABLE IF NOT EXISTS `estate_settings` ( |
37 | `EstateID` int(10) unsigned NOT NULL auto_increment, | 37 | `EstateID` int(10) unsigned NOT NULL auto_increment, |
@@ -60,14 +60,14 @@ CREATE TABLE IF NOT EXISTS `estate_settings` ( | |||
60 | `DenyMinors` tinyint not null, | 60 | `DenyMinors` tinyint not null, |
61 | 61 | ||
62 | PRIMARY KEY (`EstateID`) | 62 | PRIMARY KEY (`EstateID`) |
63 | ) ENGINE=InnoDB AUTO_INCREMENT=100; | 63 | ) ENGINE=MyISAM AUTO_INCREMENT=100; |
64 | 64 | ||
65 | CREATE TABLE IF NOT EXISTS `estate_map` ( | 65 | CREATE TABLE IF NOT EXISTS `estate_map` ( |
66 | `RegionID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', | 66 | `RegionID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', |
67 | `EstateID` int(11) NOT NULL, | 67 | `EstateID` int(11) NOT NULL, |
68 | PRIMARY KEY (`RegionID`), | 68 | PRIMARY KEY (`RegionID`), |
69 | KEY `EstateID` (`EstateID`) | 69 | KEY `EstateID` (`EstateID`) |
70 | ) ENGINE=InnoDB; | 70 | ) ENGINE=MyISAM; |
71 | 71 | ||
72 | COMMIT; | 72 | COMMIT; |
73 | 73 | ||
diff --git a/OpenSim/Data/MySQL/Resources/GridStore.migrations b/OpenSim/Data/MySQL/Resources/GridStore.migrations index 98ba8c5..b010c63 100644 --- a/OpenSim/Data/MySQL/Resources/GridStore.migrations +++ b/OpenSim/Data/MySQL/Resources/GridStore.migrations | |||
@@ -31,7 +31,7 @@ CREATE TABLE `regions` ( | |||
31 | KEY `regionName` (`regionName`), | 31 | KEY `regionName` (`regionName`), |
32 | KEY `regionHandle` (`regionHandle`), | 32 | KEY `regionHandle` (`regionHandle`), |
33 | KEY `overrideHandles` (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`) | 33 | KEY `overrideHandles` (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`) |
34 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Rev. 3'; | 34 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Rev. 3'; |
35 | 35 | ||
36 | :VERSION 2 | 36 | :VERSION 2 |
37 | 37 | ||
diff --git a/OpenSim/Data/MySQL/Resources/GridUserStore.migrations b/OpenSim/Data/MySQL/Resources/GridUserStore.migrations index d08e096..e2be27e 100644 --- a/OpenSim/Data/MySQL/Resources/GridUserStore.migrations +++ b/OpenSim/Data/MySQL/Resources/GridUserStore.migrations | |||
@@ -14,7 +14,7 @@ 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=InnoDB; | 17 | ) ENGINE=MyISAM; |
18 | 18 | ||
19 | COMMIT; | 19 | COMMIT; |
20 | 20 | ||
diff --git a/OpenSim/Data/MySQL/Resources/InventoryStore.migrations b/OpenSim/Data/MySQL/Resources/InventoryStore.migrations index 993a5a0..ca2fe11 100644 --- a/OpenSim/Data/MySQL/Resources/InventoryStore.migrations +++ b/OpenSim/Data/MySQL/Resources/InventoryStore.migrations | |||
@@ -11,7 +11,7 @@ CREATE TABLE `inventoryfolders` ( | |||
11 | PRIMARY KEY (`folderID`), | 11 | PRIMARY KEY (`folderID`), |
12 | KEY `owner` (`agentID`), | 12 | KEY `owner` (`agentID`), |
13 | KEY `parent` (`parentFolderID`) | 13 | KEY `parent` (`parentFolderID`) |
14 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 14 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
15 | 15 | ||
16 | CREATE TABLE `inventoryitems` ( | 16 | CREATE TABLE `inventoryitems` ( |
17 | `inventoryID` varchar(36) NOT NULL default '', | 17 | `inventoryID` varchar(36) NOT NULL default '', |
@@ -36,7 +36,7 @@ CREATE TABLE `inventoryitems` ( | |||
36 | PRIMARY KEY (`inventoryID`), | 36 | PRIMARY KEY (`inventoryID`), |
37 | KEY `owner` (`avatarID`), | 37 | KEY `owner` (`avatarID`), |
38 | KEY `folder` (`parentFolderID`) | 38 | KEY `folder` (`parentFolderID`) |
39 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 39 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
40 | 40 | ||
41 | COMMIT; | 41 | COMMIT; |
42 | 42 | ||
diff --git a/OpenSim/Data/MySQL/Resources/LogStore.migrations b/OpenSim/Data/MySQL/Resources/LogStore.migrations index 9ac26ac..b572411 100644 --- a/OpenSim/Data/MySQL/Resources/LogStore.migrations +++ b/OpenSim/Data/MySQL/Resources/LogStore.migrations | |||
@@ -10,4 +10,4 @@ CREATE TABLE `logs` ( | |||
10 | `priority` int(11) default NULL, | 10 | `priority` int(11) default NULL, |
11 | `message` text, | 11 | `message` text, |
12 | PRIMARY KEY (`logID`) | 12 | PRIMARY KEY (`logID`) |
13 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 13 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
diff --git a/OpenSim/Data/MySQL/Resources/Presence.migrations b/OpenSim/Data/MySQL/Resources/Presence.migrations index be4030e..5dc96d2 100644 --- a/OpenSim/Data/MySQL/Resources/Presence.migrations +++ b/OpenSim/Data/MySQL/Resources/Presence.migrations | |||
@@ -7,7 +7,7 @@ CREATE TABLE `Presence` ( | |||
7 | `RegionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', | 7 | `RegionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
8 | `SessionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', | 8 | `SessionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000', |
9 | `SecureSessionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000' | 9 | `SecureSessionID` CHAR(36) NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000' |
10 | ) ENGINE=InnoDB; | 10 | ) ENGINE=MyISAM; |
11 | 11 | ||
12 | CREATE UNIQUE INDEX SessionID ON Presence(SessionID); | 12 | CREATE UNIQUE INDEX SessionID ON Presence(SessionID); |
13 | CREATE INDEX UserID ON Presence(UserID); | 13 | CREATE INDEX UserID ON Presence(UserID); |
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 | ||
diff --git a/OpenSim/Data/MySQL/Resources/UserAccount.migrations b/OpenSim/Data/MySQL/Resources/UserAccount.migrations index 84011e6..97e5e4f 100644 --- a/OpenSim/Data/MySQL/Resources/UserAccount.migrations +++ b/OpenSim/Data/MySQL/Resources/UserAccount.migrations | |||
@@ -10,7 +10,7 @@ CREATE TABLE `UserAccounts` ( | |||
10 | `Email` VARCHAR(64), | 10 | `Email` VARCHAR(64), |
11 | `ServiceURLs` TEXT, | 11 | `ServiceURLs` TEXT, |
12 | `Created` INT(11) | 12 | `Created` INT(11) |
13 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 13 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
14 | 14 | ||
15 | COMMIT; | 15 | COMMIT; |
16 | 16 | ||
diff --git a/OpenSim/Data/MySQL/Resources/UserStore.migrations b/OpenSim/Data/MySQL/Resources/UserStore.migrations index f054611..9129075 100644 --- a/OpenSim/Data/MySQL/Resources/UserStore.migrations +++ b/OpenSim/Data/MySQL/Resources/UserStore.migrations | |||
@@ -21,7 +21,7 @@ CREATE TABLE `agents` ( | |||
21 | PRIMARY KEY (`UUID`), | 21 | PRIMARY KEY (`UUID`), |
22 | UNIQUE KEY `session` (`sessionID`), | 22 | UNIQUE KEY `session` (`sessionID`), |
23 | UNIQUE KEY `ssession` (`secureSessionID`) | 23 | UNIQUE KEY `ssession` (`secureSessionID`) |
24 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 24 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
25 | 25 | ||
26 | -- Create schema avatar_appearance | 26 | -- Create schema avatar_appearance |
27 | -- | 27 | -- |
@@ -59,7 +59,7 @@ CREATE TABLE `avatarappearance` ( | |||
59 | Skirt_Item char(36) NOT NULL, | 59 | Skirt_Item char(36) NOT NULL, |
60 | Skirt_Asset char(36) NOT NULL, | 60 | Skirt_Asset char(36) NOT NULL, |
61 | PRIMARY KEY (`Owner`) | 61 | PRIMARY KEY (`Owner`) |
62 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 62 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
63 | 63 | ||
64 | SET FOREIGN_KEY_CHECKS=0; | 64 | SET FOREIGN_KEY_CHECKS=0; |
65 | -- ---------------------------- | 65 | -- ---------------------------- |
@@ -71,7 +71,7 @@ CREATE TABLE `userfriends` ( | |||
71 | `friendPerms` INT NOT NULL, | 71 | `friendPerms` INT NOT NULL, |
72 | `datetimestamp` INT NOT NULL, | 72 | `datetimestamp` INT NOT NULL, |
73 | UNIQUE KEY (`ownerID`, `friendID`) | 73 | UNIQUE KEY (`ownerID`, `friendID`) |
74 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 74 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
75 | -- ---------------------------- | 75 | -- ---------------------------- |
76 | -- Table structure for users | 76 | -- Table structure for users |
77 | -- ---------------------------- | 77 | -- ---------------------------- |
@@ -101,7 +101,7 @@ CREATE TABLE `users` ( | |||
101 | `webLoginKey` varchar(36) default NULL, | 101 | `webLoginKey` varchar(36) default NULL, |
102 | PRIMARY KEY (`UUID`), | 102 | PRIMARY KEY (`UUID`), |
103 | UNIQUE KEY `usernames` (`username`,`lastname`) | 103 | UNIQUE KEY `usernames` (`username`,`lastname`) |
104 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; | 104 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
105 | 105 | ||
106 | -- ---------------------------- | 106 | -- ---------------------------- |
107 | -- Records | 107 | -- Records |
@@ -138,7 +138,7 @@ COMMIT; | |||
138 | 138 | ||
139 | BEGIN; | 139 | BEGIN; |
140 | 140 | ||
141 | CREATE TABLE `avatarattachments` (`UUID` char(36) NOT NULL, `attachpoint` int(11) NOT NULL, `item` char(36) NOT NULL, `asset` char(36) NOT NULL) ENGINE=InnoDB; | 141 | CREATE TABLE `avatarattachments` (`UUID` char(36) NOT NULL, `attachpoint` int(11) NOT NULL, `item` char(36) NOT NULL, `asset` char(36) NOT NULL) ENGINE=MyISAM; |
142 | 142 | ||
143 | COMMIT; | 143 | COMMIT; |
144 | 144 | ||
diff --git a/OpenSim/Data/MySQL/Resources/XAssetStore.migrations b/OpenSim/Data/MySQL/Resources/XAssetStore.migrations index d3cca5e..bb58c39 100644 --- a/OpenSim/Data/MySQL/Resources/XAssetStore.migrations +++ b/OpenSim/Data/MySQL/Resources/XAssetStore.migrations | |||
@@ -16,12 +16,12 @@ CREATE TABLE `xassetsmeta` ( | |||
16 | `asset_flags` int(11) NOT NULL, | 16 | `asset_flags` int(11) NOT NULL, |
17 | `creator_id` varchar(128) NOT NULL, | 17 | `creator_id` varchar(128) NOT NULL, |
18 | PRIMARY KEY (`id`) | 18 | PRIMARY KEY (`id`) |
19 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Version 1'; | 19 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Version 1'; |
20 | 20 | ||
21 | CREATE TABLE `xassetsdata` ( | 21 | CREATE TABLE `xassetsdata` ( |
22 | `hash` binary(32) NOT NULL, | 22 | `hash` binary(32) NOT NULL, |
23 | `data` longblob NOT NULL, | 23 | `data` longblob NOT NULL, |
24 | PRIMARY KEY (`hash`) | 24 | PRIMARY KEY (`hash`) |
25 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Version 1'; | 25 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Version 1'; |
26 | 26 | ||
27 | COMMIT; \ No newline at end of file | 27 | COMMIT; \ No newline at end of file |