CRM/Upgrade/Incremental/sql/4.7.5.mysql.tpl

   1 {* file to handle db changes in 4.7.5 during upgrade *}
   2 {include file='../CRM/Upgrade/4.7.5.msg_template/civicrm_msg_template.tpl'}
   3
   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';
  19
  20 -- CRM-18327 filter value missed on the contact deleted by merge activity --
  21 UPDATE civicrm_option_value ov
  22 LEFT JOIN civicrm_option_group og ON og.id = ov.option_group_id
  23 SET filter = 1
  24 WHERE ov.name = 'Contact Deleted by Merge' AND og.name = 'activity_type';
  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 ;