blob: 8fd0539d24973caf0ad7c0383b6b055c962b46c3 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
-- Based on slow query table feedback
ALTER TABLE `prefix_entity_relationships` DROP KEY `relationship`;
ALTER TABLE `prefix_entity_relationships` ADD KEY `relationship` (`relationship`);
ALTER TABLE `prefix_entity_relationships` DROP KEY `guid_two`;
ALTER TABLE `prefix_entity_relationships` ADD KEY `guid_two` (`guid_two`);
-- The following seemed to have been missed off upgrade
ALTER TABLE `prefix_users_entity` DROP KEY `code`;
ALTER TABLE `prefix_users_entity` ADD KEY `code` (`code`);
-- Access collections missing keys
ALTER TABLE `prefix_access_collections` DROP KEY `site_guid`;
ALTER TABLE `prefix_access_collections` ADD KEY `site_guid` (`site_guid`);
ALTER TABLE `prefix_access_collections` DROP KEY `owner_guid`;
ALTER TABLE `prefix_access_collections` ADD KEY `owner_guid` (`owner_guid`);
|
