88a562db |
1 | {* file to handle db changes in 4.7.5 during upgrade *} |
a0b8d522 |
2 | {include file='../CRM/Upgrade/4.7.5.msg_template/civicrm_msg_template.tpl'} |
3 | |
55206923 |
4 | -- Minor fix for CRM-16173, CRM-16831 - change labels, add separator, etc. |
5 | SELECT @parent_id := id from `civicrm_navigation` where name = 'System Settings' AND domain_id = {$domainID}; |
6 | UPDATE `civicrm_navigation` SET `label` = 'Components' where `name` = 'Enable Components' and `parent_id` = @parent_id; |
7 | |
8 | UPDATE |
9 | `civicrm_navigation` AS nav1 |
10 | JOIN `civicrm_navigation` AS nav2 ON |
11 | nav1.name = 'Connections' |
12 | AND nav2.name = 'Manage Extensions' |
13 | AND nav1.parent_id = @parent_id |
14 | SET |
15 | nav1.weight = nav2.weight, |
16 | nav2.weight = nav1.weight, |
17 | nav2.has_separator = 1, |
18 | nav2.label = 'Extensions'; |
e14e412b |
19 | |
ac81c185 |
20 | -- CRM-18327 filter value missed on the contact deleted by merge activity -- |
e14e412b |
21 | UPDATE civicrm_option_value ov |
22 | LEFT JOIN civicrm_option_group og ON og.id = ov.option_group_id |
23 | SET filter = 1 |
a73fd4ab |
24 | WHERE ov.name = 'Contact Deleted by Merge' AND og.name = 'activity_type'; |
ac81c185 |
25 | |
26 | -- CRM-18241 Change field length of civicrm_option_value.label from 255 to 512 -- |
27 | ALTER TABLE civicrm_option_value CHANGE label label varchar( 512 ) DEFAULT NULL ; |