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

   1 -- CRM-5824
   2 {if $multilingual}
   3   {foreach from=$locales item=locale}
   4     UPDATE civicrm_option_value ov
   5 INNER JOIN civicrm_option_group og ON ( og.id = ov.option_group_id )
   6        SET ov.name = ov.label_{$locale}
   7      WHERE og.name = 'activity_type'
   8        AND ov.name IS NULL;
   9   {/foreach}
  10 {else}
  11     UPDATE civicrm_option_value ov
  12 INNER JOIN civicrm_option_group og ON ( og.id = ov.option_group_id )
  13        SET ov.name = ov.label
  14      WHERE og.name = 'activity_type'
  15        AND ov.name IS NULL;
  16 {/if}
  17
  18 -- CRM-5825
  19     UPDATE civicrm_menu
  20            SET is_ssl = 1
  21     WHERE path = 'civicrm/event/manage';
  22
  23 -- CRM-5872
  24
  25     UPDATE civicrm_option_value ov
  26     INNER JOIN civicrm_option_group og ON ( og.id = ov.option_group_id )
  27        SET ov.is_reserved = 1
  28      WHERE ov.name = 'Bulk Email' AND
  29            og.name = 'activity_type';