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

   1 -- CRM-10969
   2 SELECT @mailingsID := MAX(id) FROM civicrm_navigation WHERE name = 'Mailings' AND domain_id = {$domainID};
   3 SELECT @navWeight := MAX(id) FROM civicrm_navigation WHERE name = 'New SMS' AND parent_id = @mailingsID;
   4
   5 UPDATE civicrm_navigation SET has_separator = NULL
   6 WHERE name = 'New SMS' AND parent_id = @mailingsID AND has_separator = 1;
   7
   8 INSERT INTO civicrm_navigation
   9     ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
  10 VALUES
  11     ( {$domainID}, 'civicrm/mailing/browse?reset=1&sms=1', '{ts escape="sql" skip="true"}Find Mass SMS{/ts}', 'Find Mass SMS', 'administer CiviCRM', NULL, @mailingsID, '1', 1, @navWeight+1 );
  12
  13 -- CRM-10980 and CRM-11014
  14 SELECT @optionID := max(id) FROM civicrm_option_value WHERE name = 'BULK SMS';
  15 {if $multilingual}
  16     {foreach from=$locales item=locale}
  17     UPDATE `civicrm_option_value` SET label_{$locale} = '{ts escape="sql"}Mass SMS{/ts}',name = 'Mass SMS',description_{$locale} = '{ts escape="sql"}Mass SMS{/ts}' WHERE id = @optionID;
  18       ALTER TABLE `civicrm_price_field_value` CHANGE name name VARCHAR(255) NULL DEFAULT NULL, CHANGE label_{$locale} label_{$locale} VARCHAR(255)  NULL DEFAULT NULL;
  19     {/foreach}
  20 {else}
  21   UPDATE `civicrm_option_value` SET label = '{ts escape="sql"}Mass SMS{/ts}',name = 'Mass SMS',description = '{ts escape="sql"}Mass SMS{/ts}' WHERE name = 'BULK SMS';
  22   ALTER TABLE `civicrm_price_field_value` CHANGE `name` `name` VARCHAR(255) NULL DEFAULT NULL, CHANGE `label` `label` VARCHAR(255)  NULL DEFAULT NULL;
  23 {/if}
  24
  25 -- CRM-11014
  26   ALTER TABLE `civicrm_line_item` CHANGE `label` `label` VARCHAR(255) NULL DEFAULT NULL;
  27
  28 -- CRM-10986: Rename Batches UI elements to Bulk Data Entry
  29 -- update reserved profile titles
  30 {if $multilingual}
  31   {foreach from=$locales item=locale}
  32     UPDATE `civicrm_uf_group` SET title_{$locale} = '{ts escape="sql"}Contribution Bulk Entry{/ts}' WHERE name = 'contribution_batch_entry';
  33     UPDATE `civicrm_uf_group` SET title_{$locale} = '{ts escape="sql"}Membership Bulk Entry{/ts}' WHERE name = 'membership_batch_entry';
  34   {/foreach}
  35 {else}
  36   UPDATE `civicrm_uf_group` SET title = '{ts escape="sql"}Contribution Bulk Entry{/ts}' WHERE name = 'contribution_batch_entry';
  37   UPDATE `civicrm_uf_group` SET title = '{ts escape="sql"}Membership Bulk Entry{/ts}' WHERE name = 'membership_batch_entry';
  38 {/if}
  39
  40 -- update navigation menu items and fix typo in permission column
  41 UPDATE `civicrm_navigation` SET label = '{ts escape="sql"}Bulk Data Entry{/ts}', name = 'Bulk Data Entry',
  42 permission = 'access CiviMember, access CiviContribute'
  43 WHERE url = 'civicrm/batch&reset=1';
  44
  45 -- CRM-11018
  46 ALTER TABLE civicrm_discount DROP FOREIGN KEY FK_civicrm_discount_option_group_id;
  47 ALTER TABLE `civicrm_discount`
  48   ADD CONSTRAINT `FK_civicrm_discount_option_group_id` FOREIGN KEY (`option_group_id`) REFERENCES `civicrm_price_set` (`id`) ON DELETE CASCADE;
  49 ALTER TABLE `civicrm_discount` CHANGE `option_group_id` `option_group_id` int(10) unsigned NOT NULL COMMENT 'FK to civicrm_price_set';