diff options
Diffstat (limited to 'engine/schema/upgrades/2008110301.sql')
| -rw-r--r-- | engine/schema/upgrades/2008110301.sql | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/engine/schema/upgrades/2008110301.sql b/engine/schema/upgrades/2008110301.sql new file mode 100644 index 000000000..8fd0539d2 --- /dev/null +++ b/engine/schema/upgrades/2008110301.sql @@ -0,0 +1,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`); |