Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- CRM-10969 |
2 | SELECT @mailingsID := MAX(id) FROM civicrm_navigation WHERE name = 'Mailings'; | |
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} | |
10824d34 | 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; | |
6a488035 TO |
19 | {/foreach} |
20 | {else} | |
10824d34 | 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';s |
22 | ALTER TABLE `civicrm_price_field_value` CHANGE `name` `name` VARCHAR(255) NULL DEFAULT NULL, CHANGE `label` `label` VARCHAR(255) NULL DEFAULT NULL; | |
6a488035 TO |
23 | {/if} |
24 | ||
25 | -- CRM-11014 | |
26 | ALTER TABLE `civicrm_line_item` CHANGE `label` `label` VARCHAR(255) NULL DEFAULT NULL; | |
10824d34 | 27 | |
6a488035 TO |
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} | |
10824d34 | 32 | UPDATE `civicrm_uf_group` SET title_{$locale} = '{ts escape="sql"}Contribution Bulk Entry{/ts}' WHERE name = 'contribution_batch_entry'; |
6a488035 | 33 | UPDATE `civicrm_uf_group` SET title_{$locale} = '{ts escape="sql"}Membership Bulk Entry{/ts}' WHERE name = 'membership_batch_entry'; |
10824d34 | 34 | {/foreach} |
6a488035 TO |
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'; |