Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- CRM-6554 |
2 | SELECT @domainID := min(id) FROM civicrm_domain; | |
3 | SELECT @navid := id FROM civicrm_navigation WHERE name='Option Lists'; | |
4 | SELECT @wt := max(weight) FROM civicrm_navigation WHERE parent_id=@navid; | |
5 | INSERT INTO civicrm_navigation | |
6 | ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) | |
7 | VALUES | |
8 | ( @domainID, 'civicrm/admin/options/wordreplacements&reset=1', '{ts escape="sql"}Word Replacements{/ts}', 'Word Replacements', 'administer CiviCRM', '', @navid, '1', NULL, @wt + 1); | |
9 | ||
10 | -- CRM-6532 | |
11 | UPDATE civicrm_state_province SET name = 'Bahia' WHERE name = 'Baia'; | |
12 | UPDATE civicrm_state_province SET name = 'Tocantins' WHERE name = 'Tocatins'; | |
13 | ||
14 | -- CRM-6330 | |
15 | SELECT @nav_mt := id FROM civicrm_navigation WHERE name = 'Manage Tags (Categories)'; | |
16 | SELECT @nav_fmdc := id FROM civicrm_navigation WHERE name = 'Find and Merge Duplicate Contacts'; | |
17 | SELECT @nav_c := id FROM civicrm_navigation WHERE name = 'Contacts'; | |
18 | SELECT @nav_c_wt := max(weight) from civicrm_navigation WHERE parent_id = @nav_c; | |
19 | ||
10824d34 | 20 | DELETE FROM civicrm_navigation WHERE id = @nav_fmdc; |
6a488035 TO |
21 | |
22 | UPDATE civicrm_navigation SET has_separator = '1' where id = @nav_mt; | |
23 | ||
24 | INSERT INTO civicrm_navigation | |
25 | ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) | |
26 | VALUES | |
27 | ( @domainID, 'civicrm/contact/deduperules&reset=1', '{ts escape="sql"}Find and Merge Duplicate Contacts{/ts}','Find and Merge Duplicate Contacts', 'administer dedupe rules,merge duplicate contacts', 'OR', @nav_c, '1', NULL, @nav_c_wt+1 ); | |
28 | ||
29 | --CRM-6565 | |
30 | ALTER TABLE civicrm_activity | |
31 | ADD INDEX UI_source_record_id(source_record_id), | |
32 | ADD INDEX index_medium_id (medium_id), | |
33 | ADD INDEX index_is_current_revision (is_current_revision), | |
34 | ADD INDEX index_is_deleted (is_deleted); | |
35 | ||
36 | {if $addActivityTypeIndex} | |
37 | ALTER TABLE civicrm_activity | |
38 | ADD INDEX UI_activity_type_id (activity_type_id); | |
39 | {/if} | |
40 | ||
41 | -- CRM-6622 | |
42 | SELECT @uf_group_id_summary := max(id) FROM civicrm_uf_group WHERE name = 'summary_overlay'; | |
43 | UPDATE civicrm_uf_field SET phone_type_id = 1 WHERE uf_group_id = @uf_group_id_summary AND location_type_id = 1 AND field_name = 'phone' AND phone_type_id IS NULL; | |
44 | UPDATE civicrm_uf_field SET location_type_id = 1, phone_type_id = 2 WHERE uf_group_id = @uf_group_id_summary AND location_type_id = 2 AND field_name = 'phone' AND phone_type_id IS NULL; | |
45 | ||
46 | -- CRM-6577 | |
47 | ALTER TABLE `civicrm_mapping_field` ADD COLUMN `website_type_id` int(10) unsigned DEFAULT NULL COMMENT 'Which type of website does this site belong'; | |
48 | ||
49 | -- CRM-6631 | |
50 | {include file='../CRM/Upgrade/3.2.1.msg_template/civicrm_msg_template.tpl'} |