Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- CRM-11847 |
2 | UPDATE `civicrm_dedupe_rule_group` | |
3 | SET name = 'IndividualGeneral' | |
4 | WHERE name = 'IndividualComplete'; | |
10824d34 | 5 | |
6a488035 TO |
6 | -- CRM-11791 |
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 ) | |
8 | VALUES | |
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 ); | |
10 | ||
11 | -- CRM-11886 | |
12 | UPDATE `civicrm_navigation` | |
13 | SET permission = 'view own manual batches,view all manual batches' | |
14 | WHERE | |
15 | name = 'Open Batches' OR | |
16 | name = 'Closed Batches' OR | |
17 | name = 'Exported Batches' OR | |
18 | name = 'Accounting Batches'; | |
10824d34 | 19 | |
6a488035 TO |
20 | UPDATE `civicrm_navigation` |
21 | SET permission = 'create manual batch' | |
22 | WHERE | |
23 | name = 'Accounting Batches'; | |
24 | ||
25 | -- CRM-11891 | |
95a8ac8d | 26 | SELECT @contributionlastID := max(id) from civicrm_navigation where name = 'Contributions' AND domain_id = {$domainID}; |
6a488035 TO |
27 | SELECT @importWeight := weight from civicrm_navigation where name = 'Import Contributions' and parent_id = @contributionlastID; |
28 | ||
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'; | |
32 | ||
33 | UPDATE `civicrm_navigation` | |
34 | SET `weight` = `weight`+2 | |
35 | WHERE `parent_id` = @contributionlastID | |
36 | AND (`weight` > @importWeight OR `name` = 'Accounting Batches'); | |
37 | ||
38 | UPDATE `civicrm_navigation` | |
39 | SET `weight` = @importWeight+1 | |
40 | WHERE `name` = 'Batch Data Entry'; |