| 1 | -- CRM-11847 |
| 2 | UPDATE `civicrm_dedupe_rule_group` |
| 3 | SET name = 'IndividualGeneral' |
| 4 | WHERE name = 'IndividualComplete'; |
| 5 | |
| 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'; |
| 19 | |
| 20 | UPDATE `civicrm_navigation` |
| 21 | SET permission = 'create manual batch' |
| 22 | WHERE |
| 23 | name = 'Accounting Batches'; |
| 24 | |
| 25 | -- CRM-11891 |
| 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; |
| 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'; |