CRM/Upgrade/Incremental/sql/4.3.alpha2.mysql.tpl

   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';