2 UPDATE `civicrm_dedupe_rule_group`
3 SET name = 'IndividualGeneral'
4 WHERE name = 'IndividualComplete';
7 INSERT IGNORE INTO `civicrm_relationship_type` ( name_a_b,label_a_b, name_b_a,label_b_a, description, contact_type_a, contact_type_b, is_reserved )
9 ( 'Partner of', '{ts escape="sql"}Partner of{/ts}', 'Partner of', '{ts escape="sql"}Partner of{/ts}', '{ts escape="sql"}Partner relationship.{/ts}', 'Individual', 'Individual', 0 );
12 UPDATE `civicrm_navigation`
13 SET permission = 'view own manual batches,view all manual batches'
15 name = 'Open Batches' OR
16 name = 'Closed Batches' OR
17 name = 'Exported Batches' OR
18 name = 'Accounting Batches';
20 UPDATE `civicrm_navigation`
21 SET permission = 'create manual batch'
23 name = 'Accounting Batches';
26 SELECT @contributionlastID := max(id) from civicrm_navigation where name = 'Contributions' AND domain_id = {$domainID};
27 SELECT @importWeight := weight from civicrm_navigation where name = 'Import Contributions' and parent_id = @contributionlastID;
29 -- since 'Bulk Data Entry' was renamed to 'Batch Data Entry'
30 UPDATE `civicrm_navigation` SET label = '{ts escape="sql"}Batch Data Entry{/ts}', name = 'Batch Data Entry'
31 WHERE url = 'civicrm/batch&reset=1';
33 UPDATE `civicrm_navigation`
34 SET `weight` = `weight`+2
35 WHERE `parent_id` = @contributionlastID
36 AND (`weight` > @importWeight OR `name` = 'Accounting Batches');
38 UPDATE `civicrm_navigation`
39 SET `weight` = @importWeight+1
40 WHERE `name` = 'Batch Data Entry';