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

   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
  20 DELETE FROM  civicrm_navigation WHERE id = @nav_fmdc;
  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'}