CRM/Upgrade/Incremental/sql/3.4.beta2.mysql.tpl

   1 -- CRM-7817
   2 {include file='../CRM/Upgrade/3.4.beta2.msg_template/civicrm_msg_template.tpl'}
   3
   4
   5 -- CRM-7801
   6 SELECT @domain_id       := min(id) FROM civicrm_domain;
   7 SELECT @nav_case        := id FROM civicrm_navigation WHERE name = 'CiviCase';
   8 SELECT @nav_case_weight := MAX(ROUND(weight)) from civicrm_navigation WHERE parent_id = @nav_case;
   9
  10 INSERT INTO civicrm_navigation
  11         ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight )
  12 VALUES
  13   ( @domain_id, 'civicrm/admin/options/encounter_medium&group=encounter_medium&reset=1', '{ts escape="sql"}Encounter Medium{/ts}','Encounter Medium',  'administer CiviCase', NULL, @nav_case, '1', NULL, @nav_case_weight+1 );
  14